This directory contains examples that demonstrate how store and query Ethereum data in ClickHouse.
Read the accompanying blog post: Migrating a multi-TB dataset from ClickHouse to Big Query data.
If you just want to play with the data, you can try it live at crypto.clickhouse.com.
ClickHouse supports both batch and streaming workflows.
The batch directory contains table schemas and examples of loading the Ethereum data set in batches.
The streaming directory contains table schemas and examples of loading the Ethereum data set as streams.
The queries directory contains examples of queries that can be run on the Ethereum dataset.
We recommend the following resources with respect to Ethereum and querying this dataset.
- How to replay time series data from Google BigQuery to Pub/Sub
- Evgeny Medvedev series on the blockchain analysis
- Ethereum in BigQuery: a Public Dataset for smart contract analytics
- Awesome BigQuery Views for Crypto
- How to Query Balances for all Ethereum Addresses in BigQuery
- Visualizing Average Ether Costs Over Time
- Plotting Ethereum Address Growth Chart in BigQuery
- Comparing Transaction Throughputs for 8 blockchains in Google BigQuery with Google Data Studio
- Introducing six new cryptocurrencies in BigQuery Public Datasets—and how to analyze them