date_trunc('year',block_timestamp) AS Last_30_Days

, COUNT(*) AS sales

, COUNT(DISTINCT origin_from_address) AS traders

, COUNT(DISTINCT buyer_address) AS nft_buyers

, COUNT(DISTINCT seller_address) AS nft_sellers

, SUM(PRICE_USD) AS sales_volume

, SUM(creator_fee_usd) AS creator_fees

, SUM(platform_fee_usd) AS platform_fees

, SUM(total_fees_usd) AS fees

, SUM(tx_fee_usd) AS tx_fees

FROM

base.nft.ez_nft_sales

WHERE 1=1

AND block_timestamp >= (CURRENT_DATE - INTERVAL '30 DAYS')

GROUP BY

1

ORDER BY

1 desc