select a.block_timestamp::date as day, play_type, count(distinct(tx_id)) as tx_num from flow.core.ez_nft_sales a
join flow.core.dim_allday_metadata b
on a.nft_id = b.nft_id
where tx_succeeded = 1
and a.nft_collection = 'A.e4cf4bdc1751c65d.AllDay'
group by day, play_type
order by day, tx_num desc