vahid-2jsEENTotal Sales volume/count AllDay
Updated 2022-07-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with totalsales_volume_count_AllDay as (select sum(price),count(price) from flow.core.fact_nft_sales
where nft_collection='A.e4cf4bdc1751c65d.AllDay')
, totalsales_volume_count_TopShot as (select sum(price),count(price) from flow.core.fact_nft_sales
where nft_collection='A.0b2a3299cc857e29.TopShot')
, totalsales_volume_count_PackNFT as (select sum(price),count(price) from flow.core.fact_nft_sales
where nft_collection='A.e4cf4bdc1751c65d.PackNFT')
,totalsalesvolume_AllDay_daily as (select sum(price),count(price),block_timestamp::date from flow.core.fact_nft_sales
where nft_collection='A.e4cf4bdc1751c65d.AllDay'
group by 3)
,totalsalesvolume_TopShot_daily as (select sum(price),count(price),block_timestamp::date from flow.core.fact_nft_sales
where nft_collection='A.0b2a3299cc857e29.TopShot'
group by 3)
,totalsalesvolume_PackNFT_daily as (select sum(price),count(price),block_timestamp::date from flow.core.fact_nft_sales
where nft_collection='A.e4cf4bdc1751c65d.PackNFT'
group by 3)
select * from totalsales_volume_count_AllDay
Run a query to Download Data