mattkstewMerry Christmas, Contracts 4
    Updated 2023-01-07
    with tab1 as (
    select
    from_address,
    min(block_timestamp) as min_date

    from optimism.core.fact_transactions
    group by 1
    )

    , tab2 as (
    select
    date_trunc('day', min_date) as date1,
    count(*) as value

    from tab1
    where date1 > current_date - 60
    group by 1
    order by 1 )

    select
    avg(value)
    from tab2
    Run a query to Download Data