trader_address,

platform_name,

SUM(total_price_usd) AS TotalSalesVolume

(

SELECT

DISTINCT seller_address AS trader_address,

platform_name,

total_price_usd

FROM

aptos.nft.ez_nft_sales

WHERE

seller_address IS NOT NULL

AND block_timestamp >= current_timestamp - INTERVAL '1 month'

UNION

ALL

SELECT

DISTINCT buyer_address AS trader_address,

platform_name,

total_price_usd

FROM

aptos.nft.ez_nft_sales

WHERE

buyer_address IS NOT NULL

AND block_timestamp >= current_timestamp - INTERVAL '1 month'

) AS TraderSales

GROUP BY

trader_address,

platform_name

ORDER BY

TotalSalesVolume DESC

10;