Table Details
| Property | Value |
|---|---|
| Table Name | ton.metrics.overview |
| Table Status | Production-Ready |
| Unique Key | activity_date |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| chain | VARCHAR(3) | 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. |
| native_token_symbol | VARCHAR(16777216) | Symbol of the chain’s native gas token. |
| native_token_price_median_usd | FLOAT | Median USD price of the chain’s native token over the measurement period, using hourly price samples. |
| 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) |
| active_addresses | NUMBER(38,0) | Number of distinct wallet addresses that initiated at least one successful transaction on this date. |
| 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 |