drone-mostafaUntitled Query
Updated 2022-09-24
9
1
2
3
4
5
6
7
8
9
›
⌄
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