mmdrezaDaily Total Sales Volume of Top 10 Play type
    Updated 2022-09-20
    with tab1 as (select count(tx_id) as transactions,play_type,sum(price) as volume
    from flow.core.ez_nft_sales s
    join flow.core.dim_allday_metadata m on m.nft_id = s.nft_id
    where play_type is not null
    and play_type not like 'Pressure'
    and play_type not like 'N/A'
    and s.nft_collection like 'A.e4cf4bdc1751c65d.AllDay'
    group by play_type
    order by volume desc
    limit 10)
    select date_trunc('day',block_timestamp) as date,play_type,count(tx_id) as transactions,sum(price) as volume
    from flow.core.ez_nft_sales s
    join flow.core.dim_allday_metadata m on m.nft_id = s.nft_id
    where play_type in (select play_type from tab1)
    group by date,play_type
    order by date asc
    Run a query to Download Data