Chain Metrics provides a comprehensive suite of pre-computed blockchain metrics designed to streamline the analysis and comparison of on-chain activity across multiple blockchain networks.Documentation Index
Fetch the complete documentation index at: https://docs.allium.so/llms.txt
Use this file to discover all available pages before exploring further.
Not all metrics are available for every chain. The list of columns present in the table may vary by chain.
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| chain | VARCHAR | The name of the blockchain |
| activity_date | TIMESTAMP_NTZ(9) | The date for which metrics are being calculated. Only includes completed days. |
| native_token_symbol | VARCHAR | The ticker symbol of the chain’s native token |
| symbol | VARCHAR | The ticker symbol of the chain’s native token |
| native_token_price_median_usd | FLOAT | The median price of the chain’s native token in USD for the given day |
| name | VARCHAR | The display name of the chain’s native token |
| price_median_usd | FLOAT | The median price of the chain’s native token in USD for the given day |
| market_cap_usd | FLOAT | The market capitalization of the chain’s native token in USD |
| project_token_symbol | VARCHAR | The ticker symbol of the chain’s project token, if different from the native token |
| project_token_name | VARCHAR | The display name of the chain’s project token, if different from the native token |
| project_token_price_median_usd | FLOAT | The median price of the chain’s project token in USD for the given day |
| project_token_market_cap_usd | FLOAT | The market capitalization of the chain’s project token in USD |
| project_token_total_volume_usd | FLOAT | The total trading volume of the chain’s project token in USD |
| total_blocks | NUMBER(38,0) | The total number of blocks produced on the chain for the given day |
| avg_network_utilisation | FLOAT | The average network utilisation as a percentage, calculated as gas used divided by gas limit |
| avg_block_size | FLOAT | The average size of blocks in bytes |
| avg_block_time | FLOAT | The average time between blocks |
| avg_transactions_per_second | FLOAT | The average number of transactions per second, calculated as the average number of transactions per block divided by the average block time (in seconds) |
| active_contracts | NUMBER(38,0) | The total number of distinct smart contracts that have been interacted with |
| new_deployed_contracts | NUMBER(38,0) | The total number of new smart contracts deployed |
| distinct_contract_deployers | NUMBER(38,0) | The total number of distinct addresses that have deployed smart contracts |
| active_addresses | NUMBER(38,0) | The number of distinct wallet addresses that have initiated successful transactions |
| new_addresses | NUMBER(38,0) | The number of distinct wallet addresses that have initiated their first successful transactions, i.e. where nonce = 0 |
| returning_addresses | NUMBER(38,0) | The number of distinct wallet addresses, that are not new, that have initiated successful transactions, i.e. where nonce > 0 |
| newly_funded_addresses | NUMBER(38,0) | The number of distinct wallet addresses that have been funded for the first time with either native tokens or ERC20 tokens |
| total_transactions | NUMBER(38,0) | The total number of transactions, including both successful and failed transactions |
| success_transactions | NUMBER(38,0) | The total number of successful transactions only |
| failed_transactions | NUMBER(38,0) | The total number of failed transactions only |
| transaction_fees | FLOAT | The total transaction fees paid (including L1 and L2 fees), expressed in the native token |
| transaction_fees_usd | FLOAT | The total transaction fees paid (including L1 and L2 fees) in USD terms |
| avg_transaction_fees | FLOAT | The average transaction fees paid (including L1 and L2 fees) expressed in the native token, excluding system transactions (where applicable) and transactions with 0 fees |
| avg_transaction_fees_usd | FLOAT | The average transaction fees paid (including L1 and L2 fees) in USD terms, excluding system transactions (where applicable) and transactions with 0 fees |
| native_token_avg_transfer_fees | FLOAT | The average cost to transfer the native token, expressed in the native token |
| native_token_avg_transfer_fees_usd | FLOAT | The average cost to transfer the native token, in USD terms |
| erc20_avg_transfer_fees | FLOAT | The average cost to transfer ERC20 tokens, expressed in the native token |
| erc20_avg_transfer_fees_usd | FLOAT | The average cost to transfer ERC20 tokens, in USD terms |
| erc721_avg_transfer_fees | FLOAT | The average cost to transfer ERC721 tokens, expressed in the native token |
| erc721_avg_transfer_fees_usd | FLOAT | The average cost to transfer ERC721 tokens, in USD terms |
| erc1155_avg_transfer_fees | FLOAT | The average cost to transfer ERC1155 tokens, expressed in the native token |
| erc1155_avg_transfer_fees_usd | FLOAT | The average cost to transfer ERC1155 tokens, in USD terms |
| dex_trade_avg_fees | FLOAT | The average cost to complete a DEX trade, expressed in the native token |
| dex_trade_avg_fees_usd | FLOAT | The average cost to complete a DEX trade, in USD terms |
| native_token_transfer_volume | FLOAT | The total volume of native token transfers, expressed in the native token |
| native_token_transfer_volume_usd | FLOAT | The total volume of native token transfers, in USD terms |
| native_token_transfer_count | NUMBER(38,0) | The total number of native token transfers, including gas paid to miners, gas burned, and L1/L2 fees |
| native_token_value_transfer_count | NUMBER(38,0) | The total number of native token value transfers, excluding gas payments, burns, and L1/L2 fees |
| native_token_transfer_tx_count | NUMBER(38,0) | The total number of transactions with native token transfers |
| erc20_transfer_volume_usd | FLOAT | Total USD volume of all ERC20 token transfers for the day |
| erc20_transfer_count | NUMBER(38,0) | Total number of ERC20 token transfer events for the day |
| erc20_transfer_tx_count | NUMBER(38,0) | Total number of transactions containing ERC20 token transfers for the day |
| stablecoin_transfer_count | NUMBER(38,0) | Total number of stablecoin transfer events for the day |
| stablecoin_transfer_tx_count | NUMBER(38,0) | Total number of transactions containing stablecoin transfers for the day |
| usd_stablecoin_transfer_count | NUMBER(38,0) | Total number of USD-pegged stablecoin (e.g., USDC, USDT) transfer events for the day |
| usd_stablecoin_transfer_tx_count | NUMBER(38,0) | Total number of transactions containing USD-pegged stablecoin transfers for the day |
| usd_stablecoin_transfer_volume_usd | FLOAT | Total USD volume of USD-pegged stablecoin transfers for the day |
| user_initiated_native_token_transfer_volume | FLOAT | The total volume of user-initiated native token transfers, expressed in the native token |
| user_initiated_native_token_transfer_volume_usd | FLOAT | The total volume of user-initiated native token transfers, in USD terms |
| user_initiated_native_token_transfer_count | NUMBER(38,0) | The total number of user-initiated native token transfers |
| user_initiated_native_token_value_transfer_count | NUMBER(38,0) | The total number of user-initiated native token value transfers |
| user_initiated_native_token_transfer_tx_count | NUMBER(38,0) | The total number of transactions with user-initiated native token transfers |
| user_initiated_erc20_transfer_volume_usd | FLOAT | USD volume of ERC20 transfers initiated by user wallets (excluding contract-to-contract transfers) |
| user_initiated_erc20_transfer_count | NUMBER(38,0) | Number of ERC20 transfer events initiated by user wallets |
| user_initiated_erc20_transfer_tx_count | NUMBER(38,0) | Number of transactions with ERC20 transfers initiated by user wallets |
| user_initiated_stablecoin_transfer_count | NUMBER(38,0) | Number of stablecoin transfer events initiated by user wallets |
| user_initiated_stablecoin_transfer_tx_count | NUMBER(38,0) | Number of transactions with stablecoin transfers initiated by user wallets |
| user_initiated_usd_stablecoin_transfer_count | NUMBER(38,0) | Number of USD-pegged stablecoin transfer events initiated by user wallets |
| user_initiated_usd_stablecoin_transfer_tx_count | NUMBER(38,0) | Number of transactions with USD-pegged stablecoin transfers initiated by user wallets |
| user_initiated_usd_stablecoin_transfer_volume_usd | FLOAT | USD volume of USD-pegged stablecoin transfers initiated by user wallets |
| tvl_usd | FLOAT | The total value locked in DeFi protocols in USD terms, sourced from DefiLlama |
| dex_volume_usd | FLOAT | The total volume of DEX trades, in USD terms |
| dex_trade_tx_count | NUMBER(38,0) | The total number of DEX trade transactions |
| dex_trader_count | NUMBER(38,0) | The total number of DEX traders |
| dex_avg_trade_usd | FLOAT | The average DEX trade size, in USD terms |
| active_addresses_7d | NUMBER(38,0) | Same as active_addresses but over 7-day rolling window |
| new_addresses_7d | NUMBER(38,0) | Same as new_addresses but over 7-day rolling window |
| returning_addresses_7d | NUMBER(38,0) | Same as returning_addresses but over 7-day rolling window |
| active_addresses_28d | NUMBER(38,0) | Same as active_addresses but over 28-day rolling window. 28 days chosen for equal weekday/weekend weighting |
| new_addresses_28d | NUMBER(38,0) | Same as new_addresses but over 28-day rolling window. 28 days chosen for equal weekday/weekend weighting |
| returning_addresses_28d | NUMBER(38,0) | Same as returning_addresses but over 28-day rolling window. 28 days chosen for equal weekday/weekend weighting |