SELECT

BLOCK_TIMESTAMP::date AS date,

NFT_ID,

PRICE

FROM flow.core.fact_nft_sales

WHERE date >= '2022-05-12'

AND date <= '2022-06-3'

AND NFT_COLLECTION = 'A.0b2a3299cc857e29.TopShot'

), metadata AS (

SELECT NFT_ID, TEAM FROM flow.core.dim_topshot_metadata

), results AS (

SELECT

sales.date,

SUM(sales.price) AS volume,

metadata.team

FROM sales

LEFT JOIN (

SELECT * FROM metadata

) metadata

ON sales.NFT_ID=metadata.NFT_ID

GROUP BY date, metadata.team

), target_teams AS (

SELECT * FROM results

WHERE TEAM = 'Dallas Mavericks'

OR TEAM = 'Boston Celtics'

OR TEAM = 'Miami Heat'

OR TEAM = 'Golden State Warriors'

date,

DATEADD (ms, 5, CAST(date AS DATETIME)) AS datetime,

CAST(volume AS INT) AS volume,

team,

-- CASE WHEN ROW_NUMBER() OVER ( ORDER BY date ) <= 5 THEN NULL