, round(sum(matic_value), 2) as "Daily Volume"

from polygon.core.fact_event_logs

join polygon.core.fact_transactions on fact_event_logs.tx_hash = fact_transactions.tx_hash

join polygon.core.dim_labels on fact_event_logs.contract_address = dim_labels.address

where fact_event_logs.event_name = 'Transfer' -- Transfer when from address is not NULL (0x0000000000000000000000000000000000000000)

and fact_event_logs.event_inputs:from != '0x0000000000000000000000000000000000000000' -- not NULL address

and fact_event_logs.tx_status = 'SUCCESS' -- successful transactions

and matic_value != 0 -- filter direct transfer

and label_type = 'nft'

--and fact_event_logs.block_timestamp::date >= CURRENT_DATE - 30 -- past month

group by 1

order by 1