| 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) | 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 | 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 ticker symbol of the chain’s project token, if different from the native token |
| project_token_name | VARCHAR(16777216) | 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 |
| active_addresses | NUMBER(38,0) | Number of distinct wallet addresses that initiated at least one successful transaction on this date. |
| new_addresses | NUMBER(18,0) | The number of distinct wallet addresses that initiated their first successful transaction on this date |
| returning_addresses | NUMBER(38,0) | The number of distinct wallet addresses that sent a transaction on this date but are not new |
| total_transactions | NUMBER(38,0) | Total number of transactions processed in this aggregated time period or entity scope. |
| 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 |
| _max_ingested_at | TIMESTAMP_NTZ(9) | Latest ingestion timestamp among source rows contributing to this aggregate |
| _min_ingested_at | TIMESTAMP_NTZ(9) | Earliest ingestion timestamp among source rows contributing to this aggregate |
