Flipside Team1.1. Tx & Fees All-Time
    Updated 3 hours ago


    with eth_daily_price AS (
    select
    date_trunc('day', hour) as day_,
    avg(price) as eth_day_price
    from ethereum.price.ez_prices_hourly
    where is_native = TRUE
    group by day_
    ),

    daily_priced AS (
    select d.day_,
    n_tx,
    n_succeeded,
    n_blocks,
    total_fees_eth,
    median_fee_eth,
    (total_fees_eth * p.eth_day_price) as total_fees_usd,
    (median_fee_eth * p.eth_day_price) as median_fees_usd,
    total_compute_units,
    total_compute_limit
    from
    datascience_public_misc.eclipse_analytics.daily_tx_stats d left join eth_daily_price p using (day_)
    )

    select
    sum(n_tx) as "Transactions"
    , (select count(signer_) from datascience_public_misc.eclipse_analytics.signer_first_timestamp) as "All-Time Signers"
    , sum(n_succeeded) as "Successful Transactions"
    , "Transactions" - "Successful Transactions" as "Failed Transactions"
    , sum(total_fees_eth) as "Fees"
    , sum(total_fees_eth)/sum(n_tx) as "Average Fee (ETH)"
    , median(median_fee_eth) as "Median Fee (ETH)"
    , sum(total_fees_usd)/sum(n_tx) as "Average Fee (USD)"
    , median(median_fees_usd) as "Median Fee (USD)"
    Last run: about 3 hours agoAuto-refreshes every 3 hours
    Transactions
    All-Time Signers
    Successful Transactions
    Failed Transactions
    Fees
    Average Fee (ETH)
    Median Fee (ETH)
    Average Fee (USD)
    Median Fee (USD)
    Blocks Produced
    CU's Consumed
    CU's Limit
    CU's Limit %
    1
    862061684381902986132900327326811495.4671065.747466974e-85e-80.00018246609660.00015862214581534040213348625562438658183157995944222.94
    1
    150B
    36s