Ethereum queries

This directory contains examples of queries that can be run on the Ethereum dataset.

These queries were originally written for BigQuery and have been migrated and optimized for ClickHouse.

Queries

• Average costs over time
• Ether supply by day
• Gas used per week
• 10 most popular collectibles (ERC721)
• 10 most popular tokens (ERC20 contracts)
• Smart contract creation
• Ethereum throughput
• Ethereum throughput average per day
• Top balances
• Total market capitalization