| chain | VARCHAR(4) | Name of the blockchain network this record belongs to. |
| activity_date | TIMESTAMP_NTZ(9) | Calendar date (UTC) this daily metric aggregates. |
| native_token_symbol | VARCHAR(16777216) | Ticker symbol of the chain’s native token. |
| native_token_price_median_usd | FLOAT | Median USD price of the native token over the day. |
| avg_block_time | FLOAT | Average time between blocks over the day, in seconds. |
| avg_transactions_per_second | FLOAT | Average number of transactions per second over the day. |
| active_addresses | NUMBER(38,0) | Number of distinct addresses active over the day. |
| new_addresses | NUMBER(38,0) | Number of addresses seen for the first time over the day. |
| returning_addresses | NUMBER(38,0) | Number of previously-seen addresses active again over the day. |
| newly_funded_addresses | NUMBER(38,0) | Number of addresses funded for the first time over the day. |
| total_transactions | NUMBER(38,0) | Total number of transactions over the day. |
| success_transactions | NUMBER(38,0) | Number of successful transactions over the day. |
| failed_transactions | NUMBER(38,0) | Number of failed transactions over the day. |
| transaction_fees | FLOAT | Total transaction fees collected over the day, in the native token. |
| transaction_fees_usd | FLOAT | Total transaction fees collected over the day, in USD. |
| avg_transaction_fees | FLOAT | Average transaction fee over the day, in the native token. |
| avg_transaction_fees_usd | FLOAT | Average transaction fee over the day, in USD. |
| native_token_avg_transfer_fees | FLOAT | Average fee per native token transfer over the day, in the native token. |
| native_token_avg_transfer_fees_usd | FLOAT | Average fee per native token transfer over the day, in USD. |
| erc20_avg_transfer_fees | FLOAT | Average fee per ERC-20 transfer over the day, in the native token. |
| erc20_avg_transfer_fees_usd | FLOAT | Average fee per ERC-20 transfer over the day, in USD. |
| erc721_avg_transfer_fees | FLOAT | Average fee per ERC-721 transfer over the day, in the native token. |
| erc721_avg_transfer_fees_usd | FLOAT | Average fee per ERC-721 transfer over the day, in USD. |
| erc1155_avg_transfer_fees | FLOAT | Average fee per ERC-1155 transfer over the day, in the native token. |
| erc1155_avg_transfer_fees_usd | FLOAT | Average fee per ERC-1155 transfer over the day, in USD. |
| dex_trade_avg_fees | FLOAT | Average fee per DEX trade over the day, in the native token. |
| dex_trade_avg_fees_usd | FLOAT | Average fee per DEX trade over the day, in USD. |
| active_contracts | NUMBER(38,0) | Number of distinct contracts interacted with over the day. |
| new_deployed_contracts | NUMBER(38,0) | Number of contracts deployed over the day. |
| native_token_transfer_volume | FLOAT | Total native token transfer volume over the day, in the native token. |
| native_token_transfer_volume_usd | FLOAT | Total native token transfer volume over the day, in USD. |
| native_token_transfer_count | NUMBER(38,0) | Number of native token transfers over the day. |
| native_token_value_transfer_count | NUMBER(38,0) | Number of native token value transfers over the day. |
| native_token_transfer_tx_count | NUMBER(38,0) | Number of transactions containing native token transfers over the day. |
| erc20_transfer_volume_usd | FLOAT | Total ERC-20 transfer volume over the day, in USD. |
| erc20_transfer_count | NUMBER(38,0) | Number of ERC-20 transfers over the day. |
| erc20_transfer_tx_count | NUMBER(38,0) | Number of transactions containing ERC-20 transfers over the day. |
| stablecoin_transfer_count | NUMBER(38,0) | Number of stablecoin transfers over the day. |
| stablecoin_transfer_tx_count | NUMBER(38,0) | Number of transactions containing stablecoin transfers over the day. |
| usd_stablecoin_transfer_count | NUMBER(38,0) | Number of USD stablecoin transfers over the day. |
| usd_stablecoin_transfer_tx_count | NUMBER(38,0) | Number of transactions containing USD stablecoin transfers over the day. |
| usd_stablecoin_transfer_volume_usd | FLOAT | Total USD stablecoin transfer volume over the day, in USD. |
| user_initiated_native_token_transfer_volume | FLOAT | User-initiated Total native token transfer volume over the day, in the native token. |
| user_initiated_native_token_transfer_volume_usd | FLOAT | User-initiated Total native token transfer volume over the day, in USD. |
| user_initiated_native_token_transfer_count | NUMBER(38,0) | User-initiated Number of native token transfers over the day. |
| user_initiated_native_token_value_transfer_count | NUMBER(38,0) | User-initiated Number of native token value transfers over the day. |
| user_initiated_native_token_transfer_tx_count | FLOAT | User-initiated Number of transactions containing native token transfers over the day. |
| user_initiated_erc20_transfer_volume_usd | FLOAT | User-initiated Total ERC-20 transfer volume over the day, in USD. |
| user_initiated_erc20_transfer_count | NUMBER(38,0) | User-initiated Number of ERC-20 transfers over the day. |
| user_initiated_erc20_transfer_tx_count | NUMBER(38,0) | User-initiated Number of transactions containing ERC-20 transfers over the day. |
| user_initiated_stablecoin_transfer_count | NUMBER(38,0) | User-initiated Number of stablecoin transfers over the day. |
| user_initiated_stablecoin_transfer_tx_count | NUMBER(38,0) | User-initiated Number of transactions containing stablecoin transfers over the day. |
| user_initiated_usd_stablecoin_transfer_count | NUMBER(38,0) | User-initiated Number of USD stablecoin transfers over the day. |
| user_initiated_usd_stablecoin_transfer_tx_count | NUMBER(38,0) | User-initiated Number of transactions containing USD stablecoin transfers over the day. |
| user_initiated_usd_stablecoin_transfer_volume_usd | FLOAT | User-initiated Total USD stablecoin transfer volume over the day, in USD. |
| tvl_usd | FLOAT | Total value locked on the chain over the day, in USD. |
| dex_volume_usd | FLOAT | Total DEX trading volume over the day, in USD. |
| dex_trade_tx_count | NUMBER(38,0) | Number of transactions containing DEX trades over the day. |
| dex_trader_count | NUMBER(38,0) | Number of distinct DEX traders over the day. |
| dex_avg_trade_usd | FLOAT | Average USD size of a DEX trade over the day. |
