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

​
Available Tables

Arbitrum data is available in several tables:
  • ez_metrics: Main aggregated metrics for the Arbitrum 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
  • ez_arbitrum_stablecoin_metrics_by_address_with_labels: Stablecoin metrics by address with labels

​
Table Schema

​
Network and Usage Metrics

Table NameColumn NameDescription
ez_metricschain_txnsDaily transactions on the Arbitrum network
ez_metricschain_dauDaily unique users on Arbitrum
ez_metricschain_wauWeekly unique users on Arbitrum
ez_metricschain_mauMonthly unique users on Arbitrum
ez_metricschain_avg_txn_feeThe average transaction fee on Arbitrum
ez_metricschain_median_txn_feeThe median transaction fee on Arbitrum
ez_metricsreturning_usersThe number of returning users on Arbitrum
ez_metricsnew_usersThe number of new users on Arbitrum
ez_metricsdau_over_100_balanceThe number of users with balances over $100

​
User Classification Metrics

Table NameColumn NameDescription
ez_metricssybil_usersThe number of sybil users (suspected bots) on Arbitrum
ez_metricsnon_sybil_usersThe number of non-sybil users on Arbitrum
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_metricschain_feesThe total transaction fees paid on Arbitrum (in USD)
ez_metricsfeesTotal revenue generated (same as chain_fees)
ez_metricsfees_nativeThe total native ARB value from all user-paid fees
ez_metricsl1_fee_allocationFees paid to Ethereum L1 for data posting
ez_metricsl1_fee_allocation_nativeFees paid to Ethereum L1 in native tokens
ez_metricstreasury_fee_allocationRevenue allocated to Arbitrum treasury (fees - L1 costs)
ez_metricsfeesLegacy naming for chain_fees
ez_metricsfees_nativeTransaction fees in native ARB tokens
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 native tokens

​
Volume and Trading Metrics

Table NameColumn NameDescription
ez_metricschain_spot_volumeTotal spot DEX volume on Arbitrum
ez_metricschain_nft_trading_volumeThe total volume of NFT trading on Arbitrum
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 ARB 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 Arbitrum
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 transactions 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 (contract interactions)

​
Bridge Metrics

Table NameColumn NameDescription
ez_metricsbridge_volumeThe total volume bridged to/from Arbitrum
ez_metricsbridge_dauDaily active users of Arbitrum bridges

​
Developer Activity Metrics

Table NameColumn NameDescription
ez_metricsweekly_commits_core_ecosystemCommits to the Arbitrum core ecosystem repositories
ez_metricsweekly_commits_sub_ecosystemCommits to Arbitrum sub-ecosystem repositories
ez_metricsweekly_developers_core_ecosystemDevelopers contributing to core repositories
ez_metricsweekly_developers_sub_ecosystemDevelopers contributing to sub-ecosystem repositories
ez_metricsweekly_contracts_deployedThe number of new contracts deployed on Arbitrum
ez_metricsweekly_contract_deployersThe number of addresses deploying contracts

​
Market and Token Metrics

Table NameColumn NameDescription
ez_metricspriceThe price of ARB token in USD
ez_metricsmarket_capThe market cap of ARB token in USD
ez_metricsfdmcThe fully diluted market cap of ARB token in USD
ez_metricstvlThe total value locked in Arbitrum protocols

​
Sample Queries

​
Basic Network Activity Query

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

​
Fee Distribution Analysis

-- Analyze Arbitrum fee distribution between L1 and Arbitrum
SELECT
    date,
    fees,
    l1_fee_allocation,
    treasury_fee_allocation,
    l1_fee_allocation / fees * 100 as l1_fee_percentage,
    treasury_fee_allocation / fees * 100 as arbitrum_revenue_percentage
FROM
    art_share.arbitrum.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
    AND fees > 0
ORDER BY
    date ASC

​
User Analysis

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

​
Volume Analysis

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

​
Stablecoin Analysis

-- Track stablecoin usage on Arbitrum
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
FROM
    art_share.arbitrum.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
    date ASC

​
Bridge Activity Analysis

-- Track bridge activity on Arbitrum
SELECT
    date,
    bridge_volume,
    bridge_dau,
    bridge_volume / NULLIF(bridge_dau, 0) as avg_bridge_volume_per_user,
    chain_dau,
    bridge_dau / NULLIF(chain_dau, 0) * 100 as bridging_user_percentage
FROM
    art_share.arbitrum.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

​
Developer Activity Monitoring

-- Track developer activity on Arbitrum
SELECT
    date,
    weekly_contracts_deployed,
    weekly_contract_deployers,
    weekly_commits_core_ecosystem,
    weekly_commits_sub_ecosystem,
    weekly_developers_core_ecosystem,
    weekly_developers_sub_ecosystem,
    weekly_contracts_deployed / NULLIF(weekly_contract_deployers, 0) as avg_contracts_per_deployer
FROM
    art_share.arbitrum.ez_metrics
WHERE
    date >= DATEADD(month, -6, CURRENT_DATE())
ORDER BY
    date ASC

​
Layer 2 Economics Analysis

-- Analyze Arbitrum's economics as a Layer 2 solution
SELECT
    date,
    chain_txns,
    chain_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,
    price,
    market_cap
FROM
    art_share.arbitrum.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

​
Application-specific Analysis

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