binhachon1. [Easy] New Active Users
    Updated 2021-12-12
    select
    date_trunc('day', block_timestamp) as blocktime,
    count(to_address) as daily_new_users
    from
    (
    select
    block_timestamp,
    to_address,
    row_number () over (
    partition by to_address
    order by
    block_timestamp
    ) as rownumber
    from
    ethereum.dex_swaps
    where
    from_address = '0xdef171fe48cf0115b1d80b88dc8eab59176fee57' qualify rownumber = 1
    )
    where
    block_timestamp > getdate() - interval '90 days'
    group by
    blocktime

    Run a query to Download Data