| chain | VARCHAR(7) | 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. |
| total_supply | FLOAT | Total token supply outstanding (minted minus burned). In token base units unless otherwise specified. |
| non_circulating_supply | FLOAT | Issuer-basis non-circulating supply: minted tokens held in issuer-, treasury-, or bridge-escrow-controlled wallets that are not in public circulation. Subtracted from total_supply to compute circulating_supply. See adjusted_non_circulating_supply for the all-layers variant. |
| circulating_supply | FLOAT | Circulating supply of the token: total_supply minus non_circulating_supply (issuer_basis layer). Represents tokens held outside issuer/treasury/bridge-escrow wallets, i.e. in public circulation. Derived from supply distribution (balances of non-circulating wallets), not from the mint/burn supply_change series, which tracks total supply. |
| max_supply | FLOAT | The Bitcoin hard cap of 21,000,000 BTC |
| 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) |
| block_subsidy | FLOAT | The pre-determined amount of new Bitcoin minted in each block. This was initially set to 50 BTC and halves every 210,000 blocks |
| block_subsidy_usd | FLOAT | The pre-determined amount of new Bitcoin minted in each block, expressed in USD terms |
| miner_revenue | FLOAT | The revenue earned by miners, calculated as the sum of block_subsidy and transaction_fees |
| miner_revenue_usd | FLOAT | The revenue earned by miners expressed in USD terms, calculated as the sum of block_subsidy_usd and transaction_fees_usd |
| hash_rate | FLOAT | An estimation of the computational power being used by miners to validate and process Bitcoin transactions. Expressed as the number of Exahashes per second (EH/s). |
| 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). |
| 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 |
| 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 |
| 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. |
| 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 |
| nft_trade_avg_fees | FLOAT | The average cost to complete an NFT trade, expressed in the native token |
| nft_trade_avg_fees_usd | FLOAT | The average cost to complete an NFT trade, in USD terms |
| nft_volume_usd | FLOAT | The total volume of NFT trades, in USD terms |
| nft_trade_tx_count | NUMBER(38,0) | The total number of NFT trade transactions |
| nft_avg_trade_usd | FLOAT | The average NFT trade size, in USD terms |
| nft_buyer_count | NUMBER(38,0) | The distinct number of wallet addresses that have purchased an NFT |
| nft_seller_count | NUMBER(38,0) | The distinct number of wallet addresses that have sold an NFT |
