SELECT

SUM(PRICE_USD) AS total_vol,

COUNT(*) AS total_trades,

COUNT(DISTINCT BUYER_ADDRESS) AS total_unique_buyers,

COUNT(DISTINCT SELLER_ADDRESS) AS total_unique_sellers,

COUNT(DISTINCT NFT_ADDRESS) AS total_unique_mints

FROM aptos.nft.ez_nft_sales

WHERE BLOCK_TIMESTAMP BETWEEN '2024-09-01' AND '2024-10-01'

),

previous_month AS (

SELECT

SUM(PRICE_USD) AS total_vol,

COUNT(*) AS total_trades,

COUNT(DISTINCT BUYER_ADDRESS) AS total_unique_buyers,

COUNT(DISTINCT SELLER_ADDRESS) AS total_unique_sellers,

COUNT(DISTINCT NFT_ADDRESS) AS total_unique_mints

FROM aptos.nft.ez_nft_sales

WHERE BLOCK_TIMESTAMP BETWEEN '2024-08-01' AND '2024-09-01'

SELECT

current_month.total_vol,

previous_month.total_vol AS prev_total_vol,

ROUND(((current_month.total_vol - previous_month.total_vol) / previous_month.total_vol) * 100, 2) AS total_vol_pct_change,

current_month.total_trades,

previous_month.total_trades AS prev_total_trades,

ROUND(((current_month.total_trades - previous_month.total_trades) / previous_month.total_trades) * 100, 2) AS total_trades_pct_change,

current_month.total_unique_buyers,

previous_month.total_unique_buyers AS prev_total_unique_buyers,

ROUND(((current_month.total_unique_buyers - previous_month.total_unique_buyers) / previous_month.total_unique_buyers) * 100, 2) AS total_unique_buyers_pct_change,

current_month.total_unique_sellers,

previous_month.total_unique_sellers AS prev_total_unique_sellers,

ROUND(((current_month.total_unique_sellers - previous_month.total_unique_sellers) / previous_month.total_unique_sellers) * 100, 2) AS total_unique_sellers_pct_change,