drone-mostafaUntitled Query
Updated 2022-07-16Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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