zakkisyedPre-Merge: Ethereum - Daily Average Transaction Count
    Updated 2022-10-15


    select avg(tx) from
    (
    select count(*) as tx, date_trunc(day,block_timestamp) as dt,
    sum(tx) over (order by dt) as cumulative
    from
    (
    select distinct tx_hash, block_timestamp
    from ethereum.core.fact_transactions
    where block_number < 15537393
    and block_number >= 12965000 -- london hard fork
    )
    group by 2
    order by 1 desc
    )

    Run a query to Download Data