This schema contains comprehensive datasets for tracking Base fundamental data across multiple metrics categories, including network activity, fees, revenue distribution, stablecoin usage, bridge activity, developer engagement, and market data.

​
Available Tables

Base data is available in several tables:
  • ez_metrics: Main aggregated metrics for the Base network
  • ez_metrics_by_category_v2: Metrics broken down by transaction category
  • ez_metrics_by_application_v2: Metrics broken down by application
  • ez_metrics_by_subcategory: Metrics broken down by subcategory
  • ez_metrics_by_contract_v2: Metrics broken down by contract
  • ez_metrics_by_chain: Cross-chain flow metrics with inflow and outflow data

​
Table Schema

​
Network and Usage Metrics

Table NameColumn NameDescription
ez_metricschain_txnsDaily transactions on the Base network
ez_metricschain_dauDaily unique users on Base
ez_metricschain_avg_txn_feeThe average transaction fee on Base
ez_metricschain_median_txn_feeThe median transaction fee on Base
ez_metricsreturning_usersThe number of returning users on Base
ez_metricsnew_usersThe number of new users on Base
ez_metricsdauLegacy naming for chain_dau
ez_metricstxnsLegacy naming for chain_txns
ez_metricswauWeekly active users on Base
ez_metricsmauMonthly active users on Base
ez_metricsdau_over_100Users with balances over $100 (legacy naming)

​
User Classification Metrics

Table NameColumn NameDescription
ez_metricssybil_usersThe number of sybil users (suspected bots) on Base
ez_metricsnon_sybil_usersThe number of non-sybil users on Base
ez_metricslow_sleep_usersUsers with continuous activity (possible bots)
ez_metricshigh_sleep_usersUsers with normal activity patterns (likely humans)

​
Fee and Revenue Metrics

Table NameColumn NameDescription
ez_metricsfeesTotal revenue generated from transaction fees (USD)
ez_metricsfees_nativeTotal revenue from transaction fees in ETH
ez_metricsl1_fee_allocationFees paid to Ethereum L1 for data posting (USD)
ez_metricsl1_fee_allocation_nativeFees paid to Ethereum L1 in ETH
ez_metricstreasury_fee_allocationRevenue allocated to Base treasury (fees - L1 costs)
ez_metricsfeesLegacy naming for fees
ez_metricsfees_nativeLegacy naming for fees_native
ez_metricsavg_txn_feeLegacy naming for chain_avg_txn_fee
ez_metricsmedian_txn_feeLegacy naming for chain_median_txn_fee
ez_metricsl1_data_costLegacy naming for l1_fee_allocation
ez_metricsl1_data_cost_nativeLegacy naming for l1_fee_allocation_native
ez_metricsrevenueLegacy naming for treasury_fee_allocation
ez_metricsrevenue_nativeLegacy naming for treasury_fee_allocation in ETH

​
Volume and Trading Metrics

Table NameColumn NameDescription
ez_metricschain_spot_volumeTotal spot DEX volume on Base
ez_metricschain_nft_trading_volumeThe total volume of NFT trading on Base
ez_metricssettlement_volumeTotal volume of DEX + NFT + P2P transfers
ez_metricsdex_volumesLegacy naming for chain_spot_volume
ez_metricsnft_trading_volumeLegacy naming for chain_nft_trading_volume

​
P2P Transfer Metrics

Table NameColumn NameDescription
ez_metricsp2p_native_transfer_volumeVolume of ETH transfers directly between wallets
ez_metricsp2p_token_transfer_volumeVolume of ERC-20 token transfers between wallets
ez_metricsp2p_transfer_volumeTotal volume of all P2P transfers

​
Stablecoin Metrics

Table NameColumn NameDescription
ez_metricsstablecoin_total_supplyThe total supply of stablecoins on Base
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_metricsartemis_stablecoin_txnsStablecoin txns excluding MEV transactions
ez_metricsartemis_stablecoin_dauDaily users excluding MEV addresses
ez_metricsartemis_stablecoin_mauMonthly users excluding MEV addresses
ez_metricsartemis_stablecoin_transfer_volumeStablecoin volume excluding MEV transactions
ez_metricsp2p_stablecoin_txnsP2P stablecoin transactions (wallet-to-wallet)
ez_metricsp2p_stablecoin_dauDaily users of P2P stablecoin transfers
ez_metricsp2p_stablecoin_mauMonthly users of P2P stablecoin transfers
ez_metricsp2p_stablecoin_transfer_volumeVolume of P2P stablecoin transfers
ez_metricsp2p_stablecoin_tokenholder_countUnique holders conducting P2P transfers
ez_metricsnon_p2p_stablecoin_transfer_volumeVolume of non-P2P stablecoin transfers

​
Bridge Metrics

Table NameColumn NameDescription
ez_metricsbridge_volumeThe total volume bridged to/from Base
ez_metricsbridge_daaDaily active users of Base bridges

​
Developer Activity Metrics

Table NameColumn NameDescription
ez_metricsweekly_contracts_deployedThe number of new contracts deployed on Base
ez_metricsweekly_contract_deployersThe number of addresses deploying contracts

​
Market Metrics

Table NameColumn NameDescription
ez_metricstvlThe total value locked in Base protocols

​
Sample Queries

​
Basic Network Activity Query

-- Pull fundamental network activity data for Base
SELECT
    date,
    chain_txns,
    chain_dau,
    fees,
    chain_avg_txn_fee,
    chain_median_txn_fee,
    tvl
FROM
    art_share.base.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

​
Fee Distribution Analysis

-- Analyze Base fee distribution between L1 and Base
SELECT
    date,
    fees,
    l1_fee_allocation,
    treasury_fee_allocation,
    l1_fee_allocation / NULLIF(fees, 0) * 100 as l1_fee_percentage,
    treasury_fee_allocation / NULLIF(fees, 0) * 100 as base_revenue_percentage,
    fees / chain_txns as avg_fee_per_txn,
    l1_fee_allocation / chain_txns as avg_l1_cost_per_txn
FROM
    art_share.base.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
    AND fees > 0
ORDER BY
    date ASC

​
User Growth Analysis

-- Analyze user growth and retention on Base
SELECT
    date,
    chain_dau,
    new_users,
    returning_users,
    new_users / NULLIF(chain_dau, 0) * 100 as new_user_percentage,
    LAG(chain_dau, 7) OVER (ORDER BY date) as dau_week_ago,
    chain_dau / NULLIF(dau_week_ago, 0) - 1 as weekly_dau_growth
FROM
    art_share.base.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

​
User Classification Analysis

-- Analyze different user types on Base
SELECT
    date,
    chain_dau,
    sybil_users,
    non_sybil_users,
    low_sleep_users,
    high_sleep_users,
    non_sybil_users / NULLIF(chain_dau, 0) * 100 as non_sybil_percentage,
    high_sleep_users / NULLIF(chain_dau, 0) * 100 as high_sleep_percentage
FROM
    art_share.base.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
    date ASC

​
Volume Analysis

-- Analyze different volume sources on Base
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,
    chain_spot_volume / NULLIF(settlement_volume, 0) * 100 as dex_percentage,
    chain_nft_trading_volume / NULLIF(settlement_volume, 0) * 100 as nft_percentage,
    p2p_transfer_volume / NULLIF(settlement_volume, 0) * 100 as p2p_percentage
FROM
    art_share.base.ez_metrics
WHERE
    date >= DATEADD(month, -1, CURRENT_DATE())
ORDER BY
    date ASC

​
Stablecoin Analysis

-- Track stablecoin usage on Base
SELECT
    date,
    stablecoin_total_supply,
    stablecoin_dau,
    artemis_stablecoin_dau,
    p2p_stablecoin_dau,
    stablecoin_transfer_volume,
    p2p_stablecoin_transfer_volume,
    non_p2p_stablecoin_transfer_volume,
    p2p_stablecoin_transfer_volume / NULLIF(stablecoin_transfer_volume, 0) * 100 as p2p_percentage,
    stablecoin_transfer_volume / NULLIF(chain_spot_volume, 0) * 100 as stablecoin_to_dex_ratio
FROM
    art_share.base.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
    date ASC

​
Bridge Activity Analysis

-- Track bridge activity on Base
SELECT
    date,
    bridge_volume,
    bridge_daa as bridge_dau,
    bridge_volume / NULLIF(bridge_daa, 0) as avg_bridge_volume_per_user,
    chain_dau,
    bridge_daa / NULLIF(chain_dau, 0) * 100 as bridging_user_percentage,
    LAG(bridge_volume, 7) OVER (ORDER BY date) as bridge_volume_week_ago,
    bridge_volume / NULLIF(bridge_volume_week_ago, 0) - 1 as weekly_bridge_growth
FROM
    art_share.base.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

​
Developer Activity Monitoring

-- Track developer activity on Base
SELECT
    date,
    weekly_contracts_deployed,
    weekly_contract_deployers,
    weekly_contracts_deployed / NULLIF(weekly_contract_deployers, 0) as avg_contracts_per_deployer,
    LAG(weekly_contracts_deployed, 4) OVER (ORDER BY date) as contracts_month_ago,
    weekly_contracts_deployed / NULLIF(contracts_month_ago, 0) - 1 as monthly_contract_growth
FROM
    art_share.base.ez_metrics
WHERE
    date >= DATEADD(month, -6, CURRENT_DATE())
ORDER BY
    date ASC

​
Layer 2 Economics Analysis

-- Analyze Base's economics as a Layer 2 solution
SELECT
    date,
    chain_txns,
    fees,
    l1_fee_allocation,
    treasury_fee_allocation,
    chain_avg_txn_fee,
    l1_fee_allocation / NULLIF(chain_txns, 0) as l1_cost_per_transaction,
    treasury_fee_allocation / NULLIF(chain_txns, 0) as profit_per_transaction,
    treasury_fee_allocation / NULLIF(l1_fee_allocation, 0) as profit_to_cost_ratio
FROM
    art_share.base.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

​
Application-specific Analysis

-- Analyze metrics for specific applications on Base
SELECT
    date,
    app,
    friendly_name,
    category,
    txns,
    dau,
    returning_users,
    new_users
FROM
    art_share.base.ez_metrics_by_application_v2
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
    AND app IN ('aerodrome', 'baseswap', 'uniswap-v3')
ORDER BY
    app, date ASC

​
Cross-chain Flow Analysis

-- Analyze cross-chain flows to and from Base
SELECT
    date,
    inflow,
    outflow,
    inflow - outflow as net_flow,
    SUM(inflow - outflow) OVER (ORDER BY date) as cumulative_net_flow
FROM
    art_share.base.ez_metrics_by_chain
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

​
TVL and Usage Correlation

-- Analyze relationship between TVL and usage metrics on Base
SELECT
    date,
    tvl,
    chain_dau,
    chain_txns,
    chain_spot_volume,
    stablecoin_total_supply,
    tvl / NULLIF(chain_dau, 0) as tvl_per_user,
    chain_spot_volume / NULLIF(tvl, 0) as dex_volume_to_tvl_ratio,
    stablecoin_total_supply / NULLIF(tvl, 0) * 100 as stablecoin_percentage_of_tvl
FROM
    art_share.base.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC