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

Layers

LayerSinceWhat it holds
Raw2020-09Blocks, transactions, logs and internal calls.
Projects2022-09Daily trading and bridge volume for each tracked app and project, broken out to Avalanche.
Assets2021-02Every curated asset issued on Avalanche, 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.
Stablecoins2021-02Every stablecoin issued on Avalanche: supply, holders and transfers.
Tokenized assets2022-10Tokenized stocks, funds and commodities issued on Avalanche, tracked against their underlying instruments.
DEX2023-06Trading pools, their daily volume, value locked and fees.
LendingIn progressThe lending markets deployed on Avalanche, the asset each one lends, and the lending facts.
Bridges2022-09Cross-chain transfers that left Avalanche or arrived on it, matched leg to leg.

Filtering

chain_id reads avalanche in every catalog table that mentions a chain, so the same filter selects Avalanche everywhere. Bridge transfers are the one exception: a transfer has a chain on each end and carries source_chain_id and destination_chain_id instead.
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.