WITH Daily_NFT_Transactions AS (
SELECT
DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS day,
COUNT(DISTINCT TX_HASH) AS total_transactions
FROM
polygon.core.ez_token_transfers
WHERE
BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '30 days'
GROUP BY
DATE_TRUNC('DAY', BLOCK_TIMESTAMP)
)
SELECT
day,
total_transactions
FROM
Daily_NFT_Transactions
ORDER BY
day DESC;