Sandeshnew users active
    Updated 2022-10-25

    with new_users as
    (
    select distinct from_address
    from optimism.core.fact_transactions
    where to_address in
    (
    lower('0xc35DADB65012eC5796536bD9864eD8773aBc74C4'),
    lower('0x93395129bd3fcf49d95730D3C2737c17990fF328'),
    lower('0x2f686751b19a9d91cc3d57d90150Bc767f050066'),
    lower('0xCaAbdD9Cf4b61813D4a52f980d6BC1B713FE66F5'),
    lower('0xbE811A0D44E2553d25d11CB8DC0d3F0D0E6430E6'),
    lower('0xaB235da7f52d35fb4551AfBa11BFB56e18774A65'),
    lower('0x8B396ddF906D552b2F98a8E7d743DD58Cd0d920f'),
    lower('0x4ab2fc6e258a0ca7175d05ff10c5cf798a672cae'),
    lower('0x0689640d190b10765f09310fcfe9c670ede4e25b')
    )
    and block_timestamp > CURRENT_DATE - interval ' {{number_of_months}} months'
    and nonce < 3
    group by 1
    )
    select date_trunc('week',block_timestamp) as week, count(distinct tx_hash) as transactions, count(distinct ORIGIN_FROM_ADDRESS) as users
    from optimism.sushi.ez_swaps
    where ORIGIN_FROM_ADDRESS in ( select * from new_users)
    and block_timestamp > current_date - interval ' {{number_of_months}} months'
    group by week
    Run a query to Download Data