| chain | VARCHAR(16777216) | Slug identifying the blockchain this record belongs to (e.g. ethereum, base, avalanche, solana). In per-chain tables this is always the same value; in cross-chain tables it identifies which chain the row came from. |
| activity_date | TIMESTAMP_NTZ(9) | Calendar date (UTC) for which this metric or aggregate is computed. Only includes fully completed days — the current in-progress day is excluded. |
| total_blocks | NUMBER(38,0) | Total number of blocks produced on this date. |
| avg_block_time | FLOAT | Average time in seconds between consecutive blocks on this date. |
| 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) |
| native_token_symbol | VARCHAR(16777216) | The ticker symbol of the chain’s native token. |
| native_token_name | VARCHAR(16777216) | Full name of the chain’s native gas token. |
| native_token_price_median_usd | FLOAT | The median price of the chain’s native token in USD for the given day. |
| project_token_symbol | VARCHAR(16777216) | The symbol of the project token (same as native token for most chains) |
| project_token_name | VARCHAR(16777216) | The name of the project token (same as native token for most chains) |
| project_token_price_median_usd | FLOAT | The median price of the project token in USD |
| active_addresses | NUMBER(38,0) | Number of distinct wallet addresses that initiated at least one successful transaction on this date. |
| new_addresses | NUMBER(38,0) | Number of distinct wallet addresses that sent their very first transaction on this date (nonce = 0). |
| returning_addresses | NUMBER(38,0) | Number of distinct wallet addresses that sent a transaction on this date but are not new (nonce > 0). |
| total_transactions | NUMBER(38,0) | Total number of transactions processed in this aggregated time period or entity scope. |
| total_system_transactions | NUMBER(38,0) | The total number of system transactions (automated transactions by the protocol) where transaction type is not ‘user_transaction’ |
| success_transactions | NUMBER(38,0) | Number of transactions that executed successfully (receipt_status = 1) on this date. |
| failed_transactions | NUMBER(38,0) | Number of transactions that reverted or failed (receipt_status = 0) on this date. |
| transaction_fees | FLOAT | Total gas fees paid for this transaction in the chain’s native token. |
| transaction_fees_usd | FLOAT | Total gas fees paid for this transaction, converted to USD. |
| 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 |
| 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 |
| gross_tvl_usd | FLOAT | Total USD TVL before deducting double-counted assets. Sum of usd_balance across all rows for the group, regardless of is_primary. |
| tvl_usd | FLOAT | Total value locked (TVL) in USD for this protocol, chain, or market at this point in time. For chain metrics overview, this is the deduplicated TVL: sum of adjusted_usd_balance across all sectors. |
| fungible_transfer_volume_usd | FLOAT | The total volume of fungible token transfers, in USD terms |
| fungible_transfer_count | NUMBER(38,0) | The total number of fungible transfers |
| fungible_transfer_tx_count | NUMBER(38,0) | The total number of transactions with fungible transfers |
| stablecoin_transfer_count | NUMBER(38,0) | The total number of stablecoin transfers. Includes all currencies. |
| stablecoin_transfer_tx_count | NUMBER(38,0) | The total number of transactions with stablecoin transfers. Includes all currencies. |
| stablecoin_transfer_volume_usd | FLOAT | The total volume of stablecoin transfers in USD terms. Includes all stablecoin currencies. |
| usd_stablecoin_transfer_count | NUMBER(38,0) | The total number of USD stablecoin transfers. |
| usd_stablecoin_transfer_tx_count | NUMBER(38,0) | The total number of transactions with USD stablecoin transfers. |
| usd_stablecoin_transfer_volume_usd | FLOAT | The total volume of USD stablecoin transfers, in USD terms. |
