Skip to main content
Most of the catalog is queryable for Arbitrum, from the blocks themselves to the daily activity of the projects that run on it. The chain’s own record sits in the arbitrum dataset: one row per block, transaction, log and internal call. Everything above that sits in the catalog, where the Arbitrum rows are selected with chain_id = 'arbitrum'. The section mirrors the catalog itself: the core entities, then the market verticals with data on Arbitrum.

Layers

LayerSinceWhat it holds
Raw2021-05Blocks, transactions, logs and internal calls.
Projects2021-08Daily Fees and Revenue for each tracked project, broken out to Arbitrum.
Apps2022-08Daily Trading volume, TVL, Fees and Revenue for each tracked app, broken out to Arbitrum.
Assets2021-06Every curated asset issued on Arbitrum, with daily supply, holders and transfer activity.
TokensIn progressEvery ERC-20 transfer, both sides of every balance move, holder balances at query time, and daily prices.
AccountsIn progressWallets and contracts labeled with the projects that own them.
Contracts2023-06Every contract deployed on Arbitrum, with the account that created it.
Stablecoins2021-06Every stablecoin issued on Arbitrum: supply, holders and transfers.
Real-world assets2023-02Tokenized stocks, funds and commodities issued on Arbitrum, tracked against their underlying instruments.
DEX2021-07Trading pools, their daily volume, value locked and fees.
LendingIn progressThe lending markets deployed on Arbitrum, the asset each one lends, and the lending facts.
Bridges2022-11Cross-chain transfers that left Arbitrum or arrived on it, matched leg to leg.

Filtering

chain_id reads arbitrum wherever a catalog table has a chain column, so the same filter selects Arbitrum everywhere. Some shapes ask for something else. The asset tables key on the asset or its deployment, so the chain comes from dimensions.asset_tokens, as the query below does. Project and app totals span every chain a project runs on, so one chain’s share reads from metrics_project_chains and metrics_app_chains. A bridge transfer has a chain on each end, named by source_chain_id and destination_chain_id.
Every table splits by day: the raw and event tables on block_timestamp, the daily tables on timestamp. Bound that column in every query; without a bound the query reads the whole table.