alirsOP-ETH-03
    Updated 2022-10-28
    select block_timestamp::date as date,
    count (distinct tx_hash)/1440 as TPM,
    case
    when date> '2022-08-05' and date < '2022-09-15' then '40 days Before Merge'
    else '40 days After Merge' end as Period
    from ethereum.core.fact_transactions
    where date > '2022-08-05' and date < '2022-10-25' and status='SUCCESS'
    group by 1
    order by 1
    Run a query to Download Data