vahid-2jsEENTotal Sales volume/count AllDay
    Updated 2022-07-04
    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