| 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. |
| symbol | VARCHAR(16777216) | Ticker symbol of this token or asset. Short alias for token_symbol used in tables that preserve the original blockchain field naming convention. |
| name | VARCHAR(16777216) | Name of this token or asset. Short alias for token_name used in tables that preserve the original blockchain field naming convention. |
| price_median_usd | FLOAT | The median price of the native token in USD |
| market_cap_usd | FLOAT | The market capitalization of the native token in USD |
| 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 |
| project_token_market_cap_usd | FLOAT | The market capitalization of the project token in USD |
| project_token_total_volume_usd | FLOAT | The total trading volume of the project token in USD |
| total_tipsets | NUMBER(38,0) | The total number of tipsets produced on the given date. |
| total_blocks | NUMBER(38,0) | Total number of blocks produced on this date. |
| avg_tipset_time | FLOAT | The average time between tipsets in seconds. |
| 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. |
| 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. |
| 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 |
| total_base_fee_burn | FLOAT | Total base fee burn in FIL (permanently destroyed). |
| total_overestimation_burn | FLOAT | Total gas overestimation burn in FIL (permanently destroyed). |
| total_miner_tip | FLOAT | Total miner tips paid in FIL. |
| total_miner_penalty | FLOAT | Total miner penalties in FIL (permanently destroyed). |
| total_fil_burned | FLOAT | Total FIL burned (base_fee_burn + overestimation_burn + miner_penalty). |
| total_gas_used | NUMBER(38,0) | Total gas units consumed. |
| total_base_fee_burn_usd | FLOAT | Total base fee burn in USD. |
| total_overestimation_burn_usd | FLOAT | Total gas overestimation burn in USD. |
| total_miner_tip_usd | FLOAT | Total miner tips paid in USD. |
| total_miner_penalty_usd | FLOAT | Total miner penalties in USD. |
| total_fil_burned_usd | FLOAT | Total FIL burned in USD. |
| native_transfer_count | NUMBER(38,0) | The total number of native FIL transfers. |
| native_transfer_volume | FLOAT | The total volume of native FIL transfers in FIL. |
| native_transfer_volume_usd | FLOAT | The total volume of native FIL transfers in USD. |
| fevm_transfer_count | NUMBER(38,0) | The total number of FEVM (ERC20-like) token transfers. |
| fevm_transfer_volume | FLOAT | The total volume of FEVM token transfers in native token units. |
| fevm_transfer_volume_usd | FLOAT | The total volume of FEVM token transfers in USD. |
| total_miner_rewards | FLOAT | Total miner rewards in FIL (block rewards + miner tips), derived from miner balance changes in actor_state_snapshots. |
| total_miner_rewards_usd | FLOAT | Total miner rewards in USD. |
| deals_published | NUMBER(38,0) | The number of storage deal proposals published. |
| deals_activated | NUMBER(38,0) | The number of storage deals activated. |
| deals_terminated | NUMBER(38,0) | The number of storage deals terminated early. |
| deals_completed | NUMBER(38,0) | The number of storage deals completed successfully. |
| total_deal_size_gib | FLOAT | Total size of published deals in GiB. |
| sectors_precommitted | NUMBER(38,0) | The number of sectors pre-committed. |
| sectors_provecommitted | NUMBER(38,0) | The number of sectors prove-committed (standard 2-step sealing). |
| sectors_provecommitted_ni | NUMBER(38,0) | The number of sectors prove-committed non-interactively (1-step sealing, no separate precommit). |
| sectors_replica_updated | NUMBER(38,0) | The number of existing sectors that had their data replaced via Snap Deals (replica_update). |
| sectors_net_growth | NUMBER(38,0) | Net new sector growth (provecommitted + provecommitted_ni - precommitted). |
| avg_sealing_time_seconds | FLOAT | Average sealing time in seconds (provecommit - precommit, standard 2-step only). |
| median_sealing_time_seconds | FLOAT | Median sealing time in seconds (standard 2-step only). |
| deals_renewed | NUMBER(38,0) | Number of deal proposals that renew previously stored content (same piece_cid in an earlier deal). |
| deal_renewal_rate | FLOAT | Fraction of deal proposals that are renewals of previously stored content. |
| deals_renewed_1m | NUMBER(38,0) | Renewed deals where the previous deal’s duration was under 1 month. |
| deal_renewal_rate_1m | FLOAT | Renewal rate for deals where the previous deal’s duration was under 1 month. |
| deals_renewed_3m | NUMBER(38,0) | Renewed deals where the previous deal’s duration was 1 to 3 months. |
| deal_renewal_rate_3m | FLOAT | Renewal rate for deals where the previous deal’s duration was 1 to 3 months. |
| deals_renewed_6m | NUMBER(38,0) | Renewed deals where the previous deal’s duration was under 6 months. |
| deal_renewal_rate_6m | FLOAT | Renewal rate for deals where the previous deal’s duration was under 6 months. |
| deals_renewed_1y | NUMBER(38,0) | Renewed deals where the previous deal’s duration was 6 months to 1 year. |
| deal_renewal_rate_1y | FLOAT | Renewal rate for deals where the previous deal’s duration was 6 months to 1 year. |
| deals_renewed_2y | NUMBER(38,0) | Renewed deals where the previous deal’s duration was 1 to 2 years. |
| deal_renewal_rate_2y | FLOAT | Renewal rate for deals where the previous deal’s duration was 1 to 2 years. |
| deals_renewed_2y_plus | NUMBER(38,0) | Renewed deals where the previous deal’s duration was over 2 years. |
| deal_renewal_rate_2y_plus | FLOAT | Renewal rate for deals where the previous deal’s duration was over 2 years. |
| 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 |
