select date_trunc('day', block_timestamp) as date,b.classification,b.player, b.season, b.play_type, b.set_name, sum(price) as amount
from flow.core.ez_nft_sales a
left join flow.core.dim_allday_metadata b
on a.nft_id = b.nft_id
where to_date(block_timestamp) between '2022-04-20' and '2022-08-03'
and a.nft_id is not null
and a.nft_collection = 'A.e4cf4bdc1751c65d.AllDay'
and a.nft_collection is not null
and classification is not null
group by date, b.classification , b.player, b.season, b.play_type, b.set_name