Raw

The ethereum dataset holds the standardized Ethereum tables. The four core tables follow the shared EVM layout; Ethereum additionally carries beacon_validators and uncle_blocks, which no other chain in the family publishes. Every column is documented at EVM ▸ Overview.

Tables

Table	Description
`blocks`	One row per block, with its gas and fee totals.
`transactions`	One row per transaction, with its receipt fields on the same row.
`logs`	One row per event log a contract emitted.
`traces`	One row per internal call recorded during execution.
`beacon_validators`	Beacon chain validator balances and statuses, snapshotted per slot.
`uncle_blocks`	Headers of the uncle blocks that canonical blocks reference.

blocks also carries a 1970-01-01 partition holding rows whose source timestamp is zero; the chain’s history starts 2015-07. uncle_blocks is a closed record: it ends at its 2022-09-15 partition, the day Ethereum stopped producing uncles.

Sample queries

The partition column differs by table: transactions, logs and traces split on block_timestamp, blocks splits on timestamp. Bound the right column in every query and keep it bare on the left of the comparison; wrapping it in a function reads every partition.

Daily transactions
Daily ETH burn
One contract's logs

Count daily transactions and the accounts that sent them.

select
    timestamp_trunc(block_timestamp, day) as day,
    count(*) as transactions,
    count(distinct from_address) as senders
from `ethereum.transactions`
where block_timestamp >= timestamp('2026-08-16')
  and block_timestamp < timestamp('2026-08-23')
group by day
order by day

Work out how much ETH the network burned each day. Ethereum destroys the base fee of every block rather than paying it to the block producer, so the burn is the base fee per gas unit multiplied by the gas the block used. blocks splits on timestamp, not block_timestamp.

select
    timestamp_trunc(timestamp, day) as day,
    count(*) as blocks,
    sum(gas_used) as gas_used,
    sum(cast(base_fee_per_gas as bignumeric) * gas_used) / 1e18 as eth_burned
from `ethereum.blocks`
where timestamp >= timestamp('2026-08-16')
  and timestamp < timestamp('2026-08-23')
group by day
order by day

Count the logs one contract emitted on a single day. A log is the record a contract writes when something happens inside it, and address is the contract that wrote it.

select
    count(*) as usdt_logs,
    count(distinct transaction_hash) as transactions
from `ethereum.logs`
where block_timestamp >= timestamp('2026-08-20')
  and block_timestamp < timestamp('2026-08-21')
  and address = '0xdac17f958d2ee523a2206206994597c13d831ec7'

Notes

beacon_validators covers the consensus side of the chain. Ethereum runs two chains in step: the execution chain that holds transactions, and the beacon chain that agrees on them. One row is one validator at one slot, with its balance and status at that moment. uncle_blocks holds a closed chapter. Before the 2022 switch away from mining, a block produced slightly too late became an uncle, referenced by a later canonical block and rewarded in part. The table stops at 2022-09-15 because Ethereum stopped producing them.

Overview

Core entities

Market verticals

Chain verticals

Tables

Sample queries

Notes

​Tables

​Sample queries

​Notes

Tables

Sample queries

Notes