zakkisyedPre-Merge: Ethereum - Daily Active Users (Average)
    Updated 2023-06-15
    select avg(users)

    from
    (
    select date_trunc(day,block_timestamp) as dt, count (distinct from_address) as users
    --case when block_number > 15537393 then 'post_merge'
    --else 'pre_merge' end as merge_status

    from ethereum.core.fact_transactions
    where block_number < 15537393
    and block_number >= 12965000
    group by 1
    --order by 1 desc
    )

    Run a query to Download Data