AS (SELECT address, address_name, project_name

FROM polygon.core.dim_labels

WHERE label_type = 'nft'

AND (label_subtype = 'token_contract' or label_subtype = 'general_contract')) --opensea: seaport dapp general_contract opensea

SELECT Q.block_timestamp::date AS dates, ---years_month-day

COUNT(DISTINCT Q.tx_hash) AS count_transaction,----number of transaction in nft

COUNT(DISTINCT origin_to_address) AS Count_firest_buyers,----first buyer

sum(matic_value) AS matic_value ---total all volume--matic_value

FROM polygon.core.fact_event_logs Q

JOIN nfts O ON Q.contract_address = O.address

JOIN polygon.core.fact_transactions ---us group TX_HASH

W on Q.tx_hash = W.tx_hash

WHERE Q.block_timestamp::date

between '2021-07-16' and '2022-07-16'

AND event_name = 'Transfer'

GROUP BY 1