shreexTotal Metrics For Playtypes
    Updated 2022-10-13
    with playtypes as (
    select
    play_type as p_t,
    nft_id as nft_idd,
    season,
    team,
    player
    from flow.core.dim_topshot_metadata
    )
    select
    p_t as play_type,
    team,
    sum(price) as volume,
    count(distinct tx_id) as number_of_sales,
    count(distinct buyer ) as unique_buyers,
    count(distinct seller) as unique_sellers
    from flow.core.ez_nft_sales inner join playtypes on nft_id=nft_idd
    where nft_collection = 'A.0b2a3299cc857e29.TopShot'
    and currency = 'A.ead892083b3e2c6c.DapperUtilityCoin'
    and tx_succeeded = 'TRUE' and nft_id=nft_idd
    GROUP BY p_t,team