project_name AS "NFT collection",

platform_name AS "NFT sales Platform",

CASE

WHEN SUM(price_usd) >= 1e9 THEN TO_CHAR(ROUND(SUM(price_usd) / 1e9, 2)) || 'B'

WHEN SUM(price_usd) >= 1e6 THEN TO_CHAR(ROUND(SUM(price_usd) / 1e6, 2)) || 'M'

WHEN SUM(price_usd) >= 1e3 THEN TO_CHAR(ROUND(SUM(price_usd) / 1e3, 2)) || 'K'

ELSE TO_CHAR(ROUND(SUM(price_usd), 2))

END AS "total Volume"

arbitrum.nft.ez_nft_sales

block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '30 DAY'

AND platform_name IS NOT NULL

GROUP BY

project_name,

platform_name

ORDER BY

SUM(price_usd) DESC

10;