select count(tx_id) as transactions,player,sum(price) as volume
from flow.core.ez_nft_sales s
join flow.core.dim_allday_metadata m on m.nft_id = s.nft_id
where play_type is not null
and play_type not like 'Pressure'
and player not like 'N/A'
and s.nft_collection like 'A.e4cf4bdc1751c65d.AllDay'
group by player
order by transactions desc
limit 10