shreexVolume Generated By Play Types
    Updated 2022-07-25
    SELECT
    play_type,
    sum(price) as volume_usd,
    count(tx_id) as sales_count
    from flow.core.fact_nft_sales sales
    join flow.core.dim_topshot_metadata meta on meta.nft_id=sales.nft_id
    where sales.nft_collection='A.0b2a3299cc857e29.TopShot' and TX_SUCCEEDED='TRUE' and currency='A.ead892083b3e2c6c.DapperUtilityCoin'
    GROUP BY play_type
    ORDER BY volume_usd DESC