Documentation Index
Fetch the complete documentation index at: https://docs.allium.so/llms.txt
Use this file to discover all available pages before exploring further.
Table Details
| Property | Value |
|---|---|
| Table Name | stable.metrics.overview |
| Table Status | Production-Ready |
| Unique Key | activity_date |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| chain | VARCHAR(16777216) | The name of the blockchain |
| activity_date | TIMESTAMP_NTZ(9) | The date for which metrics are being calculated. Only includes completed days. |
| total_blocks | NUMBER(38,0) | The total number of blocks produced on the chain for the given day |
| avg_network_utilisation | FLOAT | The average network utilisation as a percentage, calculated as gas used divided by gas limit |
| avg_block_size | FLOAT | The average size of blocks in bytes |
| avg_block_time | FLOAT | The average time between blocks |
| 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_contracts | NUMBER(38,0) | The total number of distinct smart contracts that have been interacted with |
| new_deployed_contracts | NUMBER(38,0) | The total number of new smart contracts deployed |
| distinct_contract_deployers | NUMBER(38,0) | The total number of distinct addresses that have deployed smart contracts |
| 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_avg_trade_fees | FLOAT | The average transaction fees for DEX trades, expressed in the native token |
| dex_avg_trade_fees_usd | FLOAT | The average transaction fees for DEX trades, in USD terms |
| dex_stablecoin_swap_volume_usd | FLOAT | The total volume of stablecoin-to-stablecoin swaps on DEXes, in USD terms |
| dex_stablecoin_swap_user_count | NUMBER(38,0) | The number of unique users performing stablecoin-to-stablecoin swaps on DEXes |
| dex_tvl_usd | FLOAT | The total value locked across all DEX liquidity pools, in USD terms |
| dex_stablecoin_tvl_usd | FLOAT | The total value of stablecoins locked across all DEX liquidity pools, in USD terms |
| erc20_transfer_volume_usd | FLOAT | Total USD volume of all ERC20 token transfers for the day |
| erc20_transfer_count | NUMBER(38,0) | Total number of ERC20 token transfer events for the day |
| erc20_transfer_tx_count | NUMBER(38,0) | Total number of transactions containing ERC20 token transfers for the day |
| user_initiated_erc20_transfer_volume_usd | FLOAT | USD volume of ERC20 transfers initiated by user wallets (excluding contract-to-contract transfers) |
| user_initiated_erc20_transfer_count | NUMBER(38,0) | Number of ERC20 transfer events initiated by user wallets |
| user_initiated_erc20_transfer_tx_count | NUMBER(38,0) | Number of transactions with ERC20 transfers initiated by user wallets |
| stablecoin_transfer_count | NUMBER(38,0) | Total number of stablecoin transfer events for the day |
| stablecoin_transfer_tx_count | NUMBER(38,0) | Total number of transactions containing stablecoin transfers for the day |
| stablecoin_transfer_volume_usd | FLOAT | The total volume of stablecoin transfers in USD terms. Includes all stablecoin currencies. |
| user_initiated_stablecoin_transfer_count | NUMBER(38,0) | Number of stablecoin transfer events initiated by user wallets |
| user_initiated_stablecoin_transfer_tx_count | NUMBER(38,0) | Number of transactions with stablecoin transfers initiated by user wallets |
| user_initiated_stablecoin_transfer_volume_usd | FLOAT | USD volume of stablecoin transfers initiated by user wallets |
| usd_stablecoin_transfer_count | NUMBER(38,0) | Total number of USD-pegged stablecoin (e.g., USDC, USDT) transfer events for the day |
| usd_stablecoin_transfer_tx_count | NUMBER(38,0) | Total number of transactions containing USD-pegged stablecoin transfers for the day |
| usd_stablecoin_transfer_volume_usd | FLOAT | Total USD volume of USD-pegged stablecoin transfers for the day |
| user_initiated_usd_stablecoin_transfer_count | NUMBER(38,0) | Number of USD-pegged stablecoin transfer events initiated by user wallets |
| user_initiated_usd_stablecoin_transfer_tx_count | NUMBER(38,0) | Number of transactions with USD-pegged stablecoin transfers initiated by user wallets |
| user_initiated_usd_stablecoin_transfer_volume_usd | FLOAT | USD volume of USD-pegged stablecoin transfers initiated by user wallets |
| loan_deposit_projects | VARCHAR(16777216) | Number of distinct lending protocols that received at least one deposit in the aggregation period. |
| loan_deposit_volume_usd | FLOAT | Total USD value deposited across all lending protocols in the aggregation period. |
| loan_deposit_avg_usd | FLOAT | Average USD value per deposit event across all lending protocols in the aggregation period. |
| loan_deposit_count | NUMBER(38,0) | Number of deposit events across all lending protocols in the aggregation period. |
| loan_deposit_tx_count | NUMBER(38,0) | Number of transactions containing deposit events across all lending protocols in the aggregation period. |
| loan_withdrawal_projects | VARCHAR(16777216) | Number of distinct lending protocols that had at least one withdrawal in the aggregation period. |
| loan_withdrawal_volume_usd | FLOAT | Total USD value withdrawn across all lending protocols in the aggregation period. |
| loan_withdrawal_avg_usd | FLOAT | Average USD value per withdrawal event across all lending protocols in the aggregation period. |
| loan_withdrawal_count | NUMBER(38,0) | Number of withdrawal events across all lending protocols in the aggregation period. |
| loan_withdrawal_tx_count | NUMBER(38,0) | Number of transactions containing withdrawal events across all lending protocols in the aggregation period. |
| loan_projects | VARCHAR(16777216) | Number of distinct lending protocols with active or historical borrow positions. |
| loan_volume_usd | FLOAT | Total loan volume in USD for the activity date |
| loan_avg_usd | FLOAT | Average loan size in USD |
| loan_count | NUMBER(38,0) | Total number of active or historical borrow positions across all lending protocols. |
| loan_tx_count | NUMBER(38,0) | Total number of loan transactions |
| loan_repayment_projects | VARCHAR(16777216) | Number of distinct lending protocols that received at least one repayment in the aggregation period. |
| loan_repayment_volume_usd | FLOAT | Total USD value repaid across all lending protocols in the aggregation period. |
| loan_repayment_avg_usd | FLOAT | Average USD value per repayment event across all lending protocols in the aggregation period. |
| loan_repayment_count | NUMBER(38,0) | Number of repayment events across all lending protocols in the aggregation period. |
| loan_repayment_tx_count | NUMBER(38,0) | Number of transactions containing repayment events across all lending protocols in the aggregation period. |
| loan_liquidation_projects | VARCHAR(16777216) | Number of distinct lending protocols that had at least one liquidation in the aggregation period. |
| loan_liquidation_volume_usd | FLOAT | Total USD value liquidated across all lending protocols in the aggregation period. |
| loan_liquidation_avg_usd | FLOAT | Average USD value per liquidation event across all lending protocols in the aggregation period. |
| loan_liquidation_count | NUMBER(38,0) | Number of liquidation events across all lending protocols in the aggregation period. |
| loan_liquidation_tx_count | NUMBER(38,0) | Number of transactions containing liquidation events across all lending protocols in the aggregation period. |
| lending_tvl_usd | FLOAT | Total value locked across all lending protocols on this chain, in USD. |
| lending_stablecoin_tvl_usd | FLOAT | Total value locked in stablecoin assets across all lending protocols on this chain, in USD. |
| symbol | VARCHAR(16777216) | The ticker symbol of the chain’s native token |
| name | VARCHAR(16777216) | The display name of the chain’s native token |
| price_median_usd | FLOAT | The median price of the chain’s native token in USD for the given day |
| market_cap_usd | FLOAT | The market capitalization of the chain’s native token in USD |
| project_token_symbol | VARCHAR(16777216) | The ticker symbol of the chain’s project token, if different from the native token |
| project_token_name | VARCHAR(16777216) | The display name of the chain’s project token, if different from the native token |
| project_token_price_median_usd | FLOAT | The median price of the chain’s project token in USD for the given day |
| project_token_market_cap_usd | FLOAT | The market capitalization of the chain’s project token in USD |
| project_token_total_volume_usd | FLOAT | The total trading volume of the chain’s project token in USD |
| active_addresses | NUMBER(38,0) | The number of distinct wallet addresses that have initiated successful transactions |
| new_addresses | NUMBER(38,0) | The number of distinct wallet addresses that have initiated their first successful transactions, i.e. where nonce = 0 |
| returning_addresses | NUMBER(38,0) | The number of distinct wallet addresses, that are not new, that have initiated successful transactions, i.e. where nonce > 0 |
| total_transactions | NUMBER(38,0) | The total number of transactions, including both successful and failed transactions |
| success_transactions | NUMBER(38,0) | The total number of successful transactions only |
| failed_transactions | NUMBER(38,0) | The total number of failed transactions only |
| transaction_fees | FLOAT | The total transaction fees paid (including L1 and L2 fees), expressed in the native token |
| transaction_fees_usd | FLOAT | The total transaction fees paid (including L1 and L2 fees) in USD terms |
| 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 |
| 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 |
| 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 |