SUM(PRICE) AS total_nft_volume,

SUM(PRICE_USD) AS total_nft_volume_usd

FROM

base.nft.ez_nft_sales;

WHERE

BLOCK_TIMESTAMP >= DATEADD(DAY, -30, CURRENT_TIMESTAMP())

AND BLOCK_TIMESTAMP < CURRENT_TIMESTAMP();