flipside

    5optimims
    peteer5optimims
    Updated 2023-04-14
    with users as (select min(block_timestamp::date) as min_dates , ETH_FROM_ADDRESS from
    optimism.core.ez_eth_transfers
    group by ETH_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