from polygon.core.dim_labels

where label_type like '%nft%' or project_name like '%nft%' or project_name like '%opensea%'

and project_name != 'opensea')

SELECT date_trunc('day',block_timestamp) AS date ,sum(AMOUNT_USD) as volume

FROM flipside_prod_db.polygon.udm_events

where contract_address in (select address from nfts)

AND block_timestamp >= current_date-30 and amount_usd is not null

GROUP BY date

ORDER BY date ASC