flipside

    6optimims
    peteer6optimims
    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 optimism.core.ez_eth_transfers where year(block_timestamp::date)=2022
    UNION
    select 'year 2023' , count(*)/ datediff('days' , '2023-01-01' , CURRENT_DATE)
    from optimism.core.ez_eth_transfers where year(block_timestamp::date)=2023
    Run a query to Download Data