drone-mostafaUntitled Query
    Updated 2022-07-16
    select nft_users.dt, case when new_user.from_address is not null then 'User tarted' else 'other user' end groups, count(distinct nft_users.from_address) daily_active_nft_users
    from ( select distinct date(block_timestamp) dt, from_address
    from flipside_prod_db.polygon.transactions where to_label_type = 'nft' and block_timestamp >= '2022-06-06' )
    nft_users left join ( select from_address, min(date(block_timestamp)) first_dt
    from flipside_prod_db.polygon.transactions group by 1)
    new_user on nft_users.from_address = new_user.from_address and nft_users.dt = new_user.first_dt group by 1,2




    Run a query to Download Data