peteer14optimims
Updated 2023-04-14
9
1
2
3
4
5
6
7
8
9
›
⌄
with users as (select min(block_timestamp::date) as min_dates , SENDER from
optimism.core.ez_dex_swaps
group by SENDER)
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