date_trunc('day',block_timestamp),

sum(price),

avg(price),

COUNT(*)

FROM flow.core.ez_nft_sales

LEFT outer JOIN flow.core.dim_allday_metadata

ON flow.core.dim_allday_metadata.nft_id = flow.core.ez_nft_sales.nft_id

WHERE flow.core.ez_nft_sales.nft_collection LIKE '%TopShot'

GROUP BY 1