The arbitrum dataset holds the standardized Arbitrum tables.
Every column is documented at EVM โธ Overview.
| Table | Since | Description |
|---|
blocks | 2021-05 | One row per block, with its gas and fee totals. |
transactions | 2022-08 | One row per transaction, with its receipt fields on the same row. |
logs | 2021-05 | One row per event log a contract emitted. |
traces | 2023-06 | 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.blocks also has a 1970-01-01 partition holding rows whose source timestamp is zero; bound the column and it never appears.
Daily transactions
One contract's logs
Count daily transactions and the accounts that sent them. 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.