Raw

The zksyncera dataset holds the standardized ZKsync Era tables. 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.

All four tables begin at 2023-02.

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
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 `zksyncera.transactions`
where block_timestamp >= timestamp('2026-08-16')
  and block_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 usdc_logs,
    count(distinct transaction_hash) as transactions
from `zksyncera.logs`
where block_timestamp >= timestamp('2026-08-20')
  and block_timestamp < timestamp('2026-08-21')
  and address = '0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4'

⌘I

Overview

Core entities

Market verticals

Chain verticals

Tables

Sample queries

​Tables

​Sample queries

Tables

Sample queries