alirsOP-ETH-03
Updated 2022-10-28
9
1
2
3
4
5
6
7
8
9
›
⌄
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