eslamis-darkatcountandfeeandvolume
    Updated 2022-09-25
    select date_trunc('day', block_timestamp),count(*),count(distinct FROM_ADDRESS),sum(ETH_VALUE),sum(tx_fee), CASE
    when block_timestamp::date = '2022-09-15' then 'merge'
    else 'other' end as merge_date
    from ethereum.core.fact_transactions
    where block_timestamp::date > '2022-08-01'
    group by 1,6
    Run a query to Download Data