select sum(PRICE),MOMENT_STATS_FULL:metadata:playerPosition as position ,to_date(s.block_timestamp)
from flow.core.ez_nft_sales as s inner join flow.core.dim_allday_metadata as m
on s.nft_id=m.nft_id
where s.NFT_COLLECTION='A.e4cf4bdc1751c65d.AllDay' and position!=''
group by 2,3