HosseinUntitled Query
Updated 2022-07-26
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select date_trunc('month', list1.block_timestamp) as date, list3.play_type, count(distinct(list1.tx_id)) as wallets_count,
ROW_NUMBER() OVER (PARTITION BY list3.play_type ORDER BY wallets_count ASC) AS n from flow.core.fact_transactions list1
join flow.core.fact_nft_sales list2 on list2.tx_id = list1.tx_id
join flow.core.dim_topshot_metadata list3 on list3.nft_id = list2.nft_id and list3.nft_collection = list2.nft_collection
where list1.tx_succeeded = 1
and list2.nft_collection = 'A.0b2a3299cc857e29.TopShot'
group by date, list3.play_type
order by wallets_count desc
Run a query to Download Data