Raw - Token Terminal Docs

The berachain dataset holds the standardized Berachain tables. Every column is documented at EVM ▸ Overview.

Tables

Table	Since	Description
`blocks`	2025-01	One row per block, with its gas and fee totals.
`transactions`	2025-01	One row per transaction, with its receipt fields on the same row.
`logs`	2025-01	One row per event log a contract emitted.
`traces`	2025-01	One row per internal call recorded during execution.

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 `berachain.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 `berachain.logs`
where block_timestamp >= timestamp('2026-08-20')
  and block_timestamp < timestamp('2026-08-21')
  and address = '0xf05a207442f14e446b0e32b12d2043bfc68cb1c9'

⌘I