select events.block_timestamp::date as day,
count(distinct events.TX_ID) as daily_nft_transfer_count, sum(amount_usd) as daily_volume
from flipside_prod_db.polygon.udm_events as events
join polygon.core.dim_labels as label
on events.contract_address = label.address
where LABEL_TYPE like '%nft%' and lower(event_name) like '%transfer%' and day>= DATEADD(DAY,-30,CURRENT_DATE())
group by 1
order by 1