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 Name | Column Name | Description |
|---|---|---|
| ez_metrics | chain_txns | Daily transactions on the Base network |
| ez_metrics | chain_dau | Daily unique users on Base |
| ez_metrics | chain_avg_txn_fee | The average transaction fee on Base |
| ez_metrics | chain_median_txn_fee | The median transaction fee on Base |
| ez_metrics | returning_users | The number of returning users on Base |
| ez_metrics | new_users | The number of new users on Base |
| ez_metrics | dau | Legacy naming for chain_dau |
| ez_metrics | txns | Legacy naming for chain_txns |
| ez_metrics | wau | Weekly active users on Base |
| ez_metrics | mau | Monthly active users on Base |
| ez_metrics | dau_over_100 | Users with balances over $100 (legacy naming) |
User Classification Metrics
| Table Name | Column Name | Description |
|---|---|---|
| ez_metrics | sybil_users | The number of sybil users (suspected bots) on Base |
| ez_metrics | non_sybil_users | The number of non-sybil users on Base |
| ez_metrics | low_sleep_users | Users with continuous activity (possible bots) |
| ez_metrics | high_sleep_users | Users with normal activity patterns (likely humans) |
Fee and Revenue Metrics
| Table Name | Column Name | Description |
|---|---|---|
| ez_metrics | fees | Total revenue generated from transaction fees (USD) |
| ez_metrics | fees_native | Total revenue from transaction fees in ETH |
| ez_metrics | l1_fee_allocation | Fees paid to Ethereum L1 for data posting (USD) |
| ez_metrics | l1_fee_allocation_native | Fees paid to Ethereum L1 in ETH |
| ez_metrics | treasury_fee_allocation | Revenue allocated to Base treasury (fees - L1 costs) |
| ez_metrics | fees | Legacy naming for fees |
| ez_metrics | fees_native | Legacy naming for fees_native |
| ez_metrics | avg_txn_fee | Legacy naming for chain_avg_txn_fee |
| ez_metrics | median_txn_fee | Legacy naming for chain_median_txn_fee |
| ez_metrics | l1_data_cost | Legacy naming for l1_fee_allocation |
| ez_metrics | l1_data_cost_native | Legacy naming for l1_fee_allocation_native |
| ez_metrics | revenue | Legacy naming for treasury_fee_allocation |
| ez_metrics | revenue_native | Legacy naming for treasury_fee_allocation in ETH |
Volume and Trading Metrics
| Table Name | Column Name | Description |
|---|---|---|
| ez_metrics | chain_spot_volume | Total spot DEX volume on Base |
| ez_metrics | chain_nft_trading_volume | The total volume of NFT trading on Base |
| ez_metrics | settlement_volume | Total volume of DEX + NFT + P2P transfers |
| ez_metrics | dex_volumes | Legacy naming for chain_spot_volume |
| ez_metrics | nft_trading_volume | Legacy naming for chain_nft_trading_volume |
Stablecoin Metrics
| Table Name | Column Name | Description |
|---|---|---|
| ez_metrics | stablecoin_total_supply | The total supply of stablecoins on Base |
| ez_metrics | stablecoin_txns | The number of stablecoin transactions |
| ez_metrics | stablecoin_dau | Daily active users of stablecoins |
| ez_metrics | stablecoin_mau | Monthly active users of stablecoins |
| ez_metrics | stablecoin_transfer_volume | The total volume of stablecoin transfers |
| ez_metrics | stablecoin_tokenholder_count | The number of unique stablecoin tokenholders |
Bridge Metrics
| Table Name | Column Name | Description |
|---|---|---|
| ez_metrics | bridge_volume | The total volume bridged to/from Base |
| ez_metrics | bridge_daa | Daily active users of Base bridges |
Developer Activity Metrics
| Table Name | Column Name | Description |
|---|---|---|
| ez_metrics | weekly_contracts_deployed | The number of new contracts deployed on Base |
| ez_metrics | weekly_contract_deployers | The number of addresses deploying contracts |
Market Metrics
| Table Name | Column Name | Description |
|---|---|---|
| ez_metrics | tvl | The 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,
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
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,
stablecoin_transfer_volume,
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