shreexTop 10 Players By Sales Volume
    Updated 2023-03-13
    select
    player,
    moment_stats_full:metadata:playerPosition as position,
    sum(price) as volume,
    count(*) as sales
    from flow.core.ez_nft_sales sales left join flow.core.dim_allday_metadata meta on meta.nft_id=sales.nft_id
    where sales.nft_collection='A.e4cf4bdc1751c65d.AllDay' and meta.nft_id=sales.nft_id and player != 'N/A'
    GROUP BY player,position
    ORDER BY volume DESC
    LIMIT 10
    Run a query to Download Data