addresses_of_nfts as

(

Select *

from polygon.core.DIM_LABELS

where label_type='nft'

),

all_txs as (

Select *

from polygon.core.fact_token_transfers

inner join addresses_of_nfts

where addresses_of_nfts.address=fact_token_transfers.contract_address

)

Select date_trunc(day, block_timestamp) as daily, count(*) from all_txs group by daily