drone-mostafaUntitled Query
    Updated 2022-09-24
    select date_trunc('day',block_timestamp) as daily, count (distinct tx_hash) as TXN,
    (count (distinct case when STATUS = 'SUCCESS' then tx_hash end) / count(distinct tx_hash)) * 100 as Success_Rate,
    case
    when daily >= '2022-08-01' and daily < '2022-09-15' then 'Before Merge'
    when daily >= '2022-09-15' then 'After Merge' else null end as Merge
    from ethereum.core.fact_transactions
    where block_timestamp >= '2022-09-05' and block_timestamp <= '2022-09-24'
    group by daily,Merge
    Run a query to Download Data