This schema contains comprehensive on-chain datasets for tracking Solana fundamental data across multiple metrics categories, including network activity, fees, staking, transfers, stablecoins, and developer metrics.

​
Available Tables

Solana data is available in several tables:
  • ez_metrics: Main aggregated metrics for the Solana network
  • ez_metrics_by_category_v2: Basic metrics (DAU, gas fees, transactions) broken down by transaction category
  • ez_metrics_by_application_v2: Basic metrics (DAU, gas fees, transactions) broken down by application
  • ez_metrics_by_subcategory: Basic metrics (DAU, gas fees, transactions) broken down by subcategory
  • ez_metrics_by_contract_v2: Basic metrics (DAU, gas fees, transactions) broken down by contract
  • ez_stablecoin_metrics_by_currency: Stablecoin metrics broken down by currency
  • ez_stablecoin_metrics_by_address_with_labels: Stablecoin metrics by address with labels
Note: The by_category, by_application, by_subcategory, and by_contract tables contain the same basic metrics (daily active users, gas fees, transaction counts) but broken down by different groupings based on transaction data.

​
Table Schema

​
Network and Usage Metrics

Table NameColumn NameDescription
ez_metricschain_txnsDaily transactions on Solana (excluding vote transactions)
ez_metricschain_dauDaily unique users on Solana
ez_metricschain_wauWeekly unique users on Solana
ez_metricschain_mauMonthly unique users on Solana
ez_metricschain_avg_txn_feeThe average transaction fee on Solana
ez_metricschain_median_txn_feeThe median transaction fee on Solana
ez_metricsreturning_usersThe number of returning users on Solana
ez_metricsnew_usersThe number of new users on Solana
ez_metricssettlement_volumeTotal volume of settlements (DEX + NFT + P2P transfers)

​
User Classification Metrics

Table NameColumn NameDescription
ez_metricssybil_usersThe number of sybil users on Solana
ez_metricsnon_sybil_usersThe number of non-sybil users on Solana
ez_metricslow_sleep_usersThe number of continuously active addresses (deprecated - addresses active without 5+ hour dormancy)
ez_metricshigh_sleep_usersThe number of addresses with normal activity patterns (deprecated - addresses with 5+ hour dormancy)

​
Fee and Revenue Metrics

Table NameColumn NameDescription
ez_metricschain_feesThe total transaction fees paid on Solana including gas fees and vote fees
ez_metricsfeesThe total USD value generated from all user-paid fees
ez_metricsfees_nativeThe total native SOL value from all user-paid fees
ez_metricsbase_feeThe total USD value of base transaction fees on Solana
ez_metricsbase_fee_nativeThe total native value of base transaction fees on Solana
ez_metricsvote_tx_feeThe total USD value of vote transaction fees on Solana
ez_metricsvote_tx_fee_nativeThe total native value of vote transaction fees on Solana
ez_metricspriority_feeThe total USD value of priority fees on Solana
ez_metricspriority_fee_nativeThe total native value of priority fees on Solana
ez_metricsrevTotal revenue including Jito tip fees (Blockworks’ REV metric)

​
Cash Flow Distribution Metrics

Table NameColumn NameDescription
ez_metricsburned_fee_allocationUSD value of SOL burned through transaction fees
ez_metricsburned_fee_allocation_nativeAmount of native SOL burned through transaction fees
ez_metricsvalidator_fee_allocationUSD value of revenue allocated to validators
ez_metricsvalidator_fee_allocation_nativeNative SOL value of revenue allocated to validators
ez_metricsrevenueLegacy naming for burned_fee_allocation
ez_metricsrevenue_nativeLegacy naming for burned_fee_allocation_native
Note: On Solana, prior to the implementation of SIMD 0096 (February 12, 2025), half of both base fees and priority fees were burned. After its implementation, only half of base fees are burned, while priority fees are fully distributed to validators.

​
Transfer and Volume Metrics

Table NameColumn NameDescription
ez_metricschain_nft_trading_volumeThe total volume of NFT trading on Solana
ez_metricschain_spot_volumeTotal spot DEX volume on Solana
ez_metricsp2p_native_transfer_volumeThe total volume of P2P native SOL transfers (wallet-to-wallet)
ez_metricsp2p_token_transfer_volumeThe total volume of P2P token transfers (wallet-to-wallet)
ez_metricsp2p_transfer_volumeThe total volume of all P2P transfers (wallet-to-wallet)
ez_metricsdex_volumesLegacy naming for chain_spot_volume
ez_metricsnft_trading_volumeLegacy naming for chain_nft_trading_volume
Note: “P2P” (peer-to-peer) refers to transfers directly from one wallet to another wallet, as opposed to transfers from a wallet to a smart contract.

​
Staking Metrics

Table NameColumn NameDescription
ez_metricstotal_stakedThe total USD value staked on Solana
ez_metricstotal_staked_nativeThe total amount of native SOL staked

​
Stablecoin Metrics

Table NameColumn NameDescription
ez_metricsstablecoin_total_supplyThe total supply of stablecoins on Solana
ez_metricsstablecoin_txnsThe number of stablecoin transactions
ez_metricsstablecoin_dauDaily active users of stablecoins
ez_metricsstablecoin_mauMonthly active users of stablecoins
ez_metricsstablecoin_transfer_volumeThe total volume of stablecoin transfers
ez_metricsstablecoin_tokenholder_countThe number of unique stablecoin tokenholders
ez_metricsp2p_stablecoin_tokenholder_countThe number of unique P2P stablecoin tokenholders (wallet-to-wallet)
ez_metricsp2p_stablecoin_txnsThe number of P2P stablecoin transactions (wallet-to-wallet)
ez_metricsp2p_stablecoin_dauDaily active users of P2P stablecoin transfers (wallet-to-wallet)
ez_metricsp2p_stablecoin_mauMonthly active users of P2P stablecoin transfers (wallet-to-wallet)
ez_metricsp2p_stablecoin_transfer_volumeThe total volume of P2P stablecoin transfers (wallet-to-wallet)
ez_metricsartemis_stablecoin_txnsNumber of stablecoin transactions excluding MEV and intra-CEX transfers
ez_metricsartemis_stablecoin_dauDaily active stablecoin users excluding MEV and intra-CEX transfers
ez_metricsartemis_stablecoin_mauMonthly active stablecoin users excluding MEV and intra-CEX transfers
ez_metricsartemis_stablecoin_transfer_volumeVolume of stablecoin transfers excluding MEV and intra-CEX transfers
Note: “artemisstablecoin**” metrics filter out MEV and intra-exchange transfers to provide a cleaner view of organic stablecoin activity. “p2pstablecoin**” metrics focus specifically on wallet-to-wallet stablecoin transfers, excluding wallet-to-contract interactions.

​
Market and Supply Metrics

Table NameColumn NameDescription
ez_metricspriceThe price of SOL in USD
ez_metricsmarket_capThe market cap of SOL in USD
ez_metricsfdmcThe fully diluted market cap of SOL in USD
ez_metricstvlThe total value locked in Solana protocols
ez_metricsgross_emissions_nativeThe amount of block rewards in native SOL
ez_metricsgross_emissionsThe USD value of block rewards
ez_metricsissuanceLegacy naming for gross_emissions_native

​
Developer Metrics

Table NameColumn NameDescription
ez_metricsweekly_commits_core_ecosystemThe number of commits to the Solana core ecosystem
ez_metricsweekly_commits_sub_ecosystemThe number of commits to the Solana sub-ecosystem
ez_metricsweekly_developers_core_ecosystemThe number of developers who have made commits to the Solana core ecosystem
ez_metricsweekly_developers_sub_ecosystemThe number of developers who have made commits to the Solana sub-ecosystem
ez_metricsweekly_contracts_deployedThe number of contracts deployed on Solana
ez_metricsweekly_contract_deployersThe number of contract deployers on Solana

​
Sample Queries

​
Basic Network Activity Query

-- Pull fundamental network activity data for Solana
SELECT
    date,
    chain_txns,
    chain_dau,
    chain_fees,
    chain_avg_txn_fee,
    chain_median_txn_fee,
    price
FROM
    art_share.solana.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

​
Fee Breakdown Analysis

-- Analyze Solana fee components
SELECT
    date,
    chain_fees,
    base_fee,
    vote_tx_fee,
    priority_fee,
    burned_fee_allocation,
    validator_fee_allocation
FROM
    art_share.solana.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

​
Cash Flow Distribution Before and After SIMD 0096

-- Track Solana fee distribution before and after fee changes
SELECT
    date,
    IFF(date < '2025-02-13', 'Before SIMD 0096', 'After SIMD 0096') as fee_regime,
    fees,
    validator_fee_allocation,
    burned_fee_allocation,
    validator_fee_allocation / fees as validator_share,
    burned_fee_allocation / fees as burned_share
FROM
    art_share.solana.ez_metrics
WHERE
    date BETWEEN '2025-01-01' AND '2025-03-31'
ORDER BY
    date ASC

​
Staking Analysis

-- Track Solana staking metrics
SELECT
    date,
    total_staked,
    total_staked_native,
    total_staked / market_cap as stake_ratio,
    price
FROM
    art_share.solana.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

​
Volume Analysis by Category

-- Analyze different volume sources on Solana
SELECT
    date,
    settlement_volume,
    chain_spot_volume,
    chain_nft_trading_volume,
    p2p_transfer_volume,
    p2p_native_transfer_volume,
    p2p_token_transfer_volume,
    stablecoin_transfer_volume
FROM
    art_share.solana.ez_metrics
WHERE
    date >= DATEADD(month, -1, CURRENT_DATE())
ORDER BY
    date ASC

​
Stablecoin Activity

-- Track stablecoin usage on Solana
SELECT
    date,
    stablecoin_total_supply,
    stablecoin_transfer_volume,
    stablecoin_dau,
    stablecoin_txns,
    p2p_stablecoin_transfer_volume,
    artemis_stablecoin_transfer_volume
FROM
    art_share.solana.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
    date ASC

​
User Segmentation Analysis

-- Analyze different user types on Solana
SELECT
    date,
    chain_dau,
    returning_users,
    new_users,
    sybil_users,
    non_sybil_users,
    -- Note: low_sleep_users and high_sleep_users are deprecated metrics
    low_sleep_users,
    high_sleep_users
FROM
    art_share.solana.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
    date ASC

​
Application-specific Analysis

-- Analyze metrics for specific applications on Solana
SELECT
    date,
    app,
    friendly_name,
    category,
    txns,
    dau,
    returning_users,
    new_users
FROM
    art_share.solana.ez_metrics_by_application_v2
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
    AND app IN ('jupiter', 'magic-eden', 'raydium')
ORDER BY
    app, date ASC

​
Developer Activity

-- Track developer activity on Solana
SELECT
    date,
    weekly_contracts_deployed,
    weekly_contract_deployers,
    weekly_commits_core_ecosystem,
    weekly_commits_sub_ecosystem,
    weekly_developers_core_ecosystem,
    weekly_developers_sub_ecosystem
FROM
    art_share.solana.ez_metrics
WHERE
    date >= DATEADD(month, -6, CURRENT_DATE())
ORDER BY
    date ASC