Raw

The arbitrum dataset holds the standardized Arbitrum 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.

The four tables do not all start on the same date: blocks and logs begin 2021-05, transactions begins 2022-08, and traces begins 2023-06. blocks also carries a 1970-01-01 partition holding rows whose source timestamp is zero; the chain’s real history starts 2021-05.

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

⌘I

Overview

Core entities

Market verticals

Chain verticals

Tables

Sample queries

​Tables

​Sample queries

Tables

Sample queries