Ethereum

-- 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

-- 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

-- 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

-- 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

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

-- 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

-- 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

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

-- 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

-- 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