COUNT(*) AS total_sales,

SUM(price_usd) AS total_sale_volume

FROM

ARBITRUM.nft.ez_nft_sales

WHERE

event_type = 'sale'

AND block_timestamp >= DATEADD(DAY, -30, CURRENT_TIMESTAMP)

AND price_usd > 0;