sinahosseinzadehUntitled Query
Updated 2022-08-08
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
block_timestamp::date as date,
case
when date < '2022-07-01' then 'Before July'
when date >= '2022-07-01' and date <= '2022-07-31' then 'July'
when date > '2022-07-31' then 'After July'
end as period,
count(distinct tx_hash) / (24 * 60 * 60) as tps,
count(distinct tx_hash) / (24 * 60) as tx_per_min
from optimism.core.fact_transactions
group by 1
Run a query to Download Data