This schema contains comprehensive on-chain datasets for tracking Ethereum fundamental data across multiple metrics categories, including network activity, fees, censorship, staking, data availability, stablecoins, and more.

ā€‹
Available Tables

Ethereum data is available in several tables:

  • ez_metrics: Main aggregated metrics for the Ethereum 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_block_metrics_by_block_producers: Block production metrics by builder
  • ez_etf_metrics: Ethereum ETF flow metrics
  • ez_cohort_retention: User retention metrics by cohort
  • 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 the Ethereum network
ez_metricschain_dauDaily unique users on Ethereum
ez_metricschain_wauWeekly unique users on Ethereum
ez_metricschain_mauMonthly unique users on Ethereum
ez_metricschain_avg_txn_feeThe average transaction fee on Ethereum
ez_metricschain_median_txn_feeThe median transaction fee on Ethereum
ez_metricsreturning_usersThe number of returning users on Ethereum
ez_metricsnew_usersThe number of new users on Ethereum
ez_metricsdau_over_100_balanceThe number of users who have made over 100 transactions
ez_metricssettlement_volumeTotal volume of settlements (DEX + NFT + P2P transfers)

ā€‹
User Classification Metrics

Table NameColumn NameDescription
ez_metricssybil_usersThe number of sybil users on Ethereum
ez_metricsnon_sybil_usersThe number of non-sybil users on Ethereum
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 Ethereum
ez_metricsecosystem_revenueThe total USD value generated from all user-paid fees
ez_metricsecosystem_revenue_nativeThe total native ETH value from all user-paid fees
ez_metricspriority_feeThe total USD value of priority fees on Ethereum
ez_metricspriority_fee_nativeThe total native value of priority fees on Ethereum
ez_metricsburned_cash_flowThe USD value of ETH burned through transactions
ez_metricsburned_cash_flow_nativeThe amount of native ETH burned through transactions

ā€‹
Block Metrics and Censorship Metrics

Table NameColumn NameDescription
ez_metricstotal_blocks_producedThe total number of blocks produced on Ethereum
ez_metricscensored_blocksThe number of blocks produced by builders who do not include certain transactions
ez_metricssemi_censored_blocksThe number of blocks produced by builders who partially censor certain transactions
ez_metricsnon_censored_blocksThe number of blocks produced by builders who include all transactions
ez_metricspercent_censored_blocksThe percentage of blocks that are produced by censoring builders
ez_metricspercent_semi_censored_blocksThe percentage of blocks that are produced by semi-censoring builders
ez_metricspercent_non_censored_blocksThe percentage of blocks that are produced by non-censoring builders

Note: Censorship in this context refers to builders not including certain transactions (e.g., Tornado Cash) in the blocks they produce. Even with high censorship rates, censored transactions will eventually be included by non-censoring builders, resulting in slightly longer confirmation times (e.g., up to a minute instead of 1-15 seconds).

ā€‹
Staking Metrics

Table NameColumn NameDescription
ez_metricstotal_stakedThe total USD value staked on Ethereum
ez_metricstotal_staked_nativeThe total amount of native ETH staked
ez_metricsqueue_entry_amountThe amount of ETH added to the validator queue
ez_metricsqueue_exit_amountThe amount of ETH removed from the validator queue
ez_metricsqueue_active_amountThe amount of ETH in the validator queue

ā€‹
Data Availability (Blob) Metrics

Table NameColumn NameDescription
ez_metricsblob_feesThe total USD value of blob fees on Ethereum
ez_metricsblob_fees_nativeThe total amount of native blob fees on Ethereum
ez_metricsblob_size_mibThe total amount of data stored in blobs (in MiB)
ez_metricsavg_mib_per_secondThe average amount of data stored in blobs per second
ez_metricsavg_cost_per_mibThe average cost per MiB of data stored in blobs (USD)
ez_metricsavg_cost_per_mib_gweiThe average cost per MiB of data stored in blobs (gwei)
ez_metricssubmittersThe number of blob submitters on Ethereum

ā€‹
Transfer and Volume Metrics

Table NameColumn NameDescription
ez_metricschain_nft_trading_volumeThe total volume of NFT trading on Ethereum
ez_metricschain_spot_volumeTotal spot DEX volume on Ethereum
ez_metricsp2p_native_transfer_volumeThe total volume of P2P native ETH 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_metricsnon_p2p_stablecoin_transfer_volumeVolume of non-P2P stablecoin transfers (wallet-to-contract)

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.

ā€‹
ETF Metrics

Table NameColumn NameDescription
ez_metricsnet_etf_flowThe net flow of Ethereum ETFs in USD
ez_metricsnet_etf_flow_nativeThe net flow of Ethereum ETFs in native ETH
ez_metricscumulative_etf_flowThe cumulative flow of Ethereum ETFs in USD
ez_metricscumulative_etf_flow_nativeThe cumulative flow of Ethereum ETFs in native ETH

ā€‹
Stablecoin Metrics

Table NameColumn NameDescription
ez_metricsstablecoin_total_supplyThe total supply of stablecoins on Ethereum
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
ez_metricsp2p_stablecoin_txnsThe number of P2P stablecoin transactions
ez_metricsp2p_stablecoin_dauDaily active users of P2P stablecoin transfers
ez_metricsp2p_stablecoin_mauMonthly active users of P2P stablecoin transfers
ez_metricsp2p_stablecoin_transfer_volumeThe total volume of P2P stablecoin transfers

ā€‹
Market and Supply Metrics

Table NameColumn NameDescription
ez_metricspriceThe price of ETH in USD
ez_metricsmarket_capThe market cap of ETH in USD
ez_metricsfdmcThe fully diluted market cap of ETH in USD
ez_metricstvlThe total value locked in Ethereum protocols
ez_metricsgross_emissions_nativeThe amount of block rewards in native ETH
ez_metricsgross_emissionsThe USD value of block rewards

ā€‹
Developer Metrics

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

ā€‹
Sample Queries

ā€‹
Basic Network Activity Query

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

ā€‹
Block Production and Censorship Analysis

-- Analyze Ethereum block production and censorship
SELECT
    date,
    total_blocks_produced,
    censored_blocks,
    semi_censored_blocks,
    non_censored_blocks,
    percent_censored_blocks,
    percent_semi_censored_blocks,
    percent_non_censored_blocks
FROM
    art_share.ethereum.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

ā€‹
Staking Analysis

-- Track Ethereum staking metrics
SELECT
    date,
    total_staked,
    total_staked_native,
    queue_entry_amount,
    queue_exit_amount,
    queue_active_amount,
    price
FROM
    art_share.ethereum.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

ā€‹
Data Availability (Blob) Metrics

-- Analyze Ethereum blob usage and costs
SELECT
    date,
    blob_size_mib,
    avg_mib_per_second,
    blob_fees,
    avg_cost_per_mib,
    avg_cost_per_mib_gwei,
    submitters
FROM
    art_share.ethereum.ez_metrics
WHERE
    date >= DATEADD(month, -1, CURRENT_DATE())
ORDER BY
    date ASC

ā€‹
Stablecoin Activity

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

ā€‹
ETF Flow Analysis

-- Track Ethereum ETF flows
SELECT
    date,
    net_etf_flow,
    net_etf_flow_native,
    cumulative_etf_flow,
    cumulative_etf_flow_native,
    price
FROM
    art_share.ethereum.ez_metrics
WHERE
    date >= '2023-01-01'
ORDER BY
    date ASC

ā€‹
User Segmentation Analysis

-- Analyze different user types on Ethereum
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,
    dau_over_100_balance
FROM
    art_share.ethereum.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
    date ASC

ā€‹
Volume Analysis by Category

-- Analyze different volume sources on Ethereum
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.ethereum.ez_metrics
WHERE
    date >= DATEADD(month, -1, CURRENT_DATE())
ORDER BY
    date ASC

ā€‹
Block Producer Analysis

-- Analyze block production by builder
SELECT
    date,
    builder,
    builder_name,
    censors,
    blocks_produced
FROM
    art_share.ethereum.ez_block_metrics_by_block_producers
WHERE
    date >= DATEADD(week, -2, CURRENT_DATE())
ORDER BY
    date ASC, blocks_produced DESC

ā€‹
Developer Activity

-- Track developer activity on Ethereum
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.ethereum.ez_metrics
WHERE
    date >= DATEADD(month, -6, CURRENT_DATE())
ORDER BY
    date ASC