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