SELECT *

FROM flow.core.ez_nft_sales as a JOIN flow.core.dim_allday_metadata as b

ON a.nft_id = b.nft_id

WHERE a.nft_collection = 'A.e4cf4bdc1751c65d.AllDay'

AND a.block_timestamp > '2022-08-04'

--AND block_timestamp > CURRENT_DATE - 1

SELECT team,

sum(price) as usd_volume,

COUNT(DISTINCT tx_id) as sales_count

FROM nfl_allday_sales

GROUP BY team