fat3mehUntitled Query
    Updated 2022-05-08
    with new_wallets as (
    select * from (
    select
    date(block_timestamp) as date,
    from_address as wallets
    from ethereum_core.fact_transactions
    where to_address = lower('0xdef171fe48cf0115b1d80b88dc8eab59176fee57'))
    ),
    min as (
    select
    wallets,
    min(date) as date
    from new_wallets
    group by wallets
    )
    select
    date,
    count(distinct wallets) as new_users
    from min
    where date > '2021-10-01' and date < '2021-12-01'
    group by date
    Run a query to Download Data