peteer3optimims
Updated 2023-04-14
9
1
2
3
4
5
›
⌄
select 'year 2022' , count(*)/365
from optimism.core.fact_transactions where year(block_timestamp::date)=2022
UNION
select 'year 2023' , count(*)/ datediff('days' , '2023-01-01' , CURRENT_DATE)
from optimism.core.fact_transactions where year(block_timestamp::date)=2023
Run a query to Download Data