SELECT

address_name,

project_name,

address

FROM polygon.core.dim_labels

WHERE label_type = 'nft'

AND (label_subtype = 'token_contract' OR label_subtype = 'general_contract'))

SELECT

e.block_timestamp::date AS days,

COUNT(DISTINCT e.tx_hash) AS count_txs,

COUNT(DISTINCT origin_to_address) AS count_buyers,

sum(matic_value) AS volume

FROM polygon.core.fact_event_logs e

JOIN polygon.core.fact_transactions t ON e.tx_hash = t.tx_hash

JOIN polygon n ON e.contract_address = n.address

WHERE event_name = 'Transfer'

and days>= CURRENT_DATE - 365

GROUP BY 1

ORDER BY 1