Flipside Team1.1. Tx & Fees All-Time
    Updated 20 minutes 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: 20 minutes 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
    21824912134111498721812309023126031111209.4951765.541810059e-85e-80.00014038695180.000133564354232557193350815509899037140683647657390524.94
    1
    156B
    19s