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'

), other_teams AS (

SELECT

date,

SUM(volume),

'Others Teams' AS team,

0 AS MA5

FROM results

WHERE TEAM IS NOT NULL