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_
    ),

    agg_txs as (

    select

    day_
    , n_tx
    , n_succeeded
    , n_blocks
    , total_fees_eth
    , median_fee_eth
    , (total_fees_eth * eth_day_price) as total_fees_usd
    , (median_fee_eth * eth_day_price) as median_fees_usd
    , total_compute_units
    , total_compute_limit

    from datascience_public_misc.eclipse_analytics.daily_tx_stats
    left join eth_daily_price
    using (day_)
    ),

    agg_vote_txs as (

    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
    21807511903111425221795132678123792251205.3416665.527185638e-85e-80.00014015740690.000134132791731768559348441477910287140248634534516124.84
    1
    156B
    16s