SELECT SUM(PRICE_USD) AS Total, DATE_TRUNC('day', BLOCK_TIMESTAMP) AS "DATE", NFT_ADDRESS

FROM optimism.core.ez_nft_sales

WHERE PRICE_USD IS NOT NULL a

GROUP BY 3, 2),

IT AS (

SELECT SUM(Total) AS Total, NFT_ADDRESS, "DATE"

FROM (SELECT NFT_ADDRESS, SUM(AMOUNT_USD) AS Total, DATE_TRUNC('day', YU.BLOCK_TIMESTAMP) AS "DATE"

FROM optimism.core.ez_nft_sales YU

JOIN optimism.core.ez_eth_transfers SY ON SY.TX_HASH = YU.TX_HASH AND SY.AMOUNT = YU.PRICE

WHERE YU.PRICE_USD IS NULL

GROUP BY 1, 3

UNION ALL

SELECT NFT_ADDRESS, Total, "DATE"

FROM ut) GROUP BY 2, 3),

IU AS (

SELECT Max(Total) AS Total, "DATE"

FROM IT

GROUP BY 2

SELECT IU.Total, CASE WHEN PROJECT_NAME IS NOT NULL THEN PROJECT_NAME ELSE NFT_ADDRESS END AS PROJECT_NAME, IT."DATE"

FROM IU

JOIN IT ON IU.Total = IT.Total AND IU."DATE" = IT."DATE"

LEFT JOIN optimism.core.dim_labels lb ON NFT_ADDRESS = ADDRESS