HosseinUntitled Query
Updated 2022-07-12
9
1
2
3
4
5
6
7
8
›
⌄
select date_trunc('day', list1.block_timestamp) as date, count(*) as total_tx_volume from flow.core.fact_transactions list1
join flow.core.fact_nft_sales list2 on list2.tx_id = list1.tx_id
where list1.tx_succeeded = 1
and list1.block_timestamp::date >= '2022-05-01'
and list1.block_timestamp::date <= '2022-05-30'
and list2.nft_collection = 'A.0b2a3299cc857e29.TopShot'
group by date
order by date
Run a query to Download Data