SandeshUntitled Query
    Updated 2022-10-26
    with tab as
    (
    select ft.*
    , dc.*
    from optimism.core.fact_transactions ft
    left join optimism.core.dim_labels dc
    on ft.to_address=dc.address
    where block_timestamp > CURRENT_DATE - interval '3 months'
    -- and ft.to_address=lower('0xbE811A0D44E2553d25d11CB8DC0d3F0D0E6430E6')
    and nonce < 3
    )
    select project_name, count(distinct from_address) as cnt
    from tab
    group by project_name
    order by cnt desc
    Run a query to Download Data