sherwanxplyrsal
    Updated 2022-10-14
    with metadata as (select nft_id as players, player from flow.core.dim_topshot_metadata)
    select
    player,
    sum(price) as volume,
    count(DISTINCT(TX_ID)) as sales_count
    from flow.core.fact_nft_sales left join metadata on players=nft_id
    where nft_collection='A.0b2a3299cc857e29.TopShot' and currency='A.ead892083b3e2c6c.DapperUtilityCoin' and tx_succeeded='TRUE' and player is not null
    AND player!='N/A' and block_timestamp >='2022-07-01'
    group by 1
    order by 3 desc
    limit 10
    Run a query to Download Data