DATE_TRUNC('month', block_timestamp) AS transaction_date,

COUNT(*) AS total_transactions,

COUNT(DISTINCT buyer_address) AS unique_buyers,

COUNT(DISTINCT seller_address) AS unique_sellers,

COUNT(DISTINCT project_name) AS unique_collections,

SUM(platform_fee_usd) AS total_platform_fees_usd,

SUM(price_usd) AS total_usd_volume

FROM

avalanche.nft.ez_nft_sales

WHERE

PLATFORM_NAME = 'joepegs'

AND CAST(block_timestamp AS DATE) >= '2024-01-01' AND CAST(block_timestamp AS DATE) <= '2024-12-31'

GROUP BY

transaction_date

ORDER BY

transaction_date