peteer2optimims
Updated 2023-04-14
9
1
2
3
4
5
6
7
8
›
⌄
with users as (select min(block_timestamp::date) as min_dates , from_address from
optimism.core.fact_transactions
group by from_address)
select 'year 2022' , count(*)/365 from users where year(min_dates)=2022
UNION
select 'year 2023' , count(*)/ datediff('days' , '2023-01-01' , CURRENT_DATE)
from users where year(min_dates)=2023
Run a query to Download Data