from polygon.core.dim_labels

where label_type like '%nft%' and (label_subtype = 'general_contract' or label_subtype = 'token_contract' ))

select block_timestamp::date as day , sum(amount_usd) as usd_volume ,count(DISTINCT to_address) as buyer ,

count(DISTINCT tx_id) as sales_number , count(DISTINCT from_address) as seller

from flipside_prod_db.polygon.udm_events

where contract_address in ( select address from tb)

and to_address != '%0x0000000000000000000000000000000000000000%' and from_address != '0x0000000000000000000000000000000000000000' and block_timestamp::date >= current_date - 365

group by day