farid-c9j0VMsale volume per day by collection
Updated 2022-07-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
select
trunc(block_timestamp,'day') as date,
nft_collection,
sum(price) as volume_sales,
sum(volume_sales) over (partition by nft_collection order by date) as cum_volume,
count(distinct buyer) as n_buyers,
sum(n_buyers) over (partition by nft_collection order by date) as cum_buyers,
count(distinct tx_id) as n_sales,
sum(n_sales) over (partition by nft_collection order by date) as cum_sales,
CASE
when nft_collection = 'A.0b2a3299cc857e29.TopShot' then 'NBA Top Shot'
when nft_collection = 'A.e4cf4bdc1751c65d.AllDay' then 'NFL All Day'
when nft_collection = 'A.329feb3ab062d289.UFC_NFT' then 'UFC Strike'
when nft_collection = 'A.e4cf4bdc1751c65d.PackNFT' then 'NFL All Day - Packs'
end as Collection
from flow.core.fact_nft_sales
where block_timestamp>='2022-01-01'
and nft_collection in ('A.0b2a3299cc857e29.TopShot','A.e4cf4bdc1751c65d.AllDay','A.329feb3ab062d289.UFC_NFT','A.e4cf4bdc1751c65d.PackNFT')
group by 1,2
having volume_Sales >1000
order by 1 asc
Run a query to Download Data