| chain | VARCHAR(6) | 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. |
| 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. |
| 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. |
| total_supply | FLOAT | Total token supply outstanding (minted minus burned). In token base units unless otherwise specified. |
| _supply_updated_slot | NUMBER(38,0) | The block slot on Solana when the native token supply metrics were updated |
| _supply_updated_timestamp | TIMESTAMP_NTZ(9) | The timestamp when the native token supply metrics were updated |
| 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) |
| tx_initiating_addresses | NUMBER(38,0) | Number of distinct addresses that signed at least one transaction in this period (EOA-level, excludes contract-initiated calls). |
| active_addresses | NUMBER(38,0) | Number of distinct wallet addresses that initiated at least one successful transaction on this date. |
| active_voter_addresses | NUMBER(38,0) | Number of distinct addresses that submitted at least one governance vote transaction in this period. |
| active_non_voter_addresses | NUMBER(38,0) | Number of distinct active addresses that did not submit any governance vote in this period. |
| 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). |
| 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. |
| failed_transactions | NUMBER(38,0) | Number of transactions that reverted or failed (receipt_status = 0) on this date. |
| success_voting_tx_count | NUMBER(38,0) | The total number of successful voting transactions on Solana, where validators participate in Solana’s consensus mechanism |
| success_non_voting_tx_count | NUMBER(38,0) | The total number of successful regular transactions on Solana |
| failed_voting_tx_count | NUMBER(38,0) | The total number of failed voting transactions on Solana, where validators participate in Solana’s consensus mechanism |
| failed_non_voting_tx_count | NUMBER(38,0) | The total number of failed regular transactions on Solana |
| 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 |
| native_token_avg_transfer_fees | FLOAT | The average cost to transfer the native token, expressed in the native token |
| native_token_avg_transfer_fees_usd | FLOAT | The average cost to transfer the native token, in USD terms |
| fungible_spl_avg_transfer_fees | FLOAT | The average cost to transfer fungible SPL20 tokens on Solana, expressed in the native token |
| fungible_spl_avg_transfer_fees_usd | FLOAT | The average cost to transfer fungible SPL20 tokens on Solana, expressed in USD terms |
| nft_avg_transfer_fees | FLOAT | The average cost to transfer non-fungible SPL20 tokens on Solana, expressed in the native token |
| nft_avg_transfer_fees_usd | FLOAT | The average cost to transfer non-fungible SPL20 tokens on Solana, expressed in USD terms |
| 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 |
| dex_trade_avg_fees | FLOAT | The average cost to complete a DEX trade, expressed in the native token |
| dex_trade_avg_fees_usd | FLOAT | The average cost to complete a DEX trade, in USD terms |
| new_deployed_contracts | NUMBER(38,0) | The total number of new smart contracts deployed |
| active_contracts | NUMBER(38,0) | The total number of distinct smart contracts that have been interacted with |
| new_contracts_called | NUMBER(38,0) | Number of contracts receiving their first-ever call in this period. |
| returning_contracts_called | NUMBER(38,0) | Number of contracts called in this period that have also been called in a prior period. |
| total_contract_calls | NUMBER(38,0) | The total number of contract calls |
| contract_callers | NUMBER(38,0) | Number of distinct addresses that called at least one smart contract in this period. |
| native_token_transfer_volume | FLOAT | The total volume of native token transfers, expressed in the native token |
| native_token_transfer_volume_usd | FLOAT | The total volume of native token transfers, in USD terms |
| native_token_transfer_count | NUMBER(38,0) | The total number of native token transfers. This includes transfers of gas paid to miners and gas burned (for Ethereum) and L1/L2 fees (for EVM L2s). |
| native_token_value_transfer_count | NUMBER(38,0) | The total number of native token value transfers. Equivalent to native_token_transfer_count excluding transfers of gas paid to miners and gas burned (for Ethereum) and L1/L2 fees (for EVM L2s). |
| native_token_transfer_tx_count | NUMBER(38,0) | The total number of transactions with native token transfers |
| spl_transfer_volume_usd | FLOAT | The total volume of SPL20 token transfers on Solana (incl. fungible & non-fungible SPL tokens), in USD terms |
| spl_transfer_count | NUMBER(38,0) | The total number of SPL20 token transfers on Solana (incl. fungible & non-fungible SPL tokens) |
| spl_transfer_tx_count | NUMBER(38,0) | The total number of transactions with SPL20 token transfers on Solana (incl. fungible & non-fungible SPL tokens) |
| 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. |
| 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. |
| dex_volume_usd | FLOAT | The total volume of DEX trades, in USD terms |
| dex_trade_tx_count | NUMBER(38,0) | The total number of DEX trade transactions |
| dex_trader_count | NUMBER(38,0) | The total number of DEX traders |
| dex_avg_trade_usd | FLOAT | The average DEX trade size, in USD terms |
| dex_volume_usd_adjusted | FLOAT | DEX trading volume (USD) with wash trading and inorganic volume removed. |
| dex_avg_trade_usd_adjusted | FLOAT | Average DEX trade size in USD after wash trading adjustments. |
| 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 |
| 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. |
| 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. |
