DATE_TRUNC('day', BLOCK_TIMESTAMP) AS "Time",

SUM(PRICE) AS "NBA Top Shot Volume",

COUNT(DISTINCT "BUYER") AS "NBA Top Shot Buyers",

COUNT(DISTINCT "TX_ID") AS "NBA Top Shot Sales"

FROM flow.core.fact_nft_sales s

left join flow.core.dim_contract_labels f ON s.nft_collection = f.event_contract

WHERE CONTRACT_NAME = 'TopShot'

GROUP BY "Time"