project_name AS "NFT collection",

platform_name AS "NFT sales Platform",

CASE

WHEN COUNT(DISTINCT tx_hash) >= 1e9 THEN TO_CHAR(ROUND(COUNT(DISTINCT tx_hash) / 1e9, 2)) || 'B'

WHEN COUNT(DISTINCT tx_hash) >= 1e6 THEN TO_CHAR(ROUND(COUNT(DISTINCT tx_hash) / 1e6, 2)) || 'M'

WHEN COUNT(DISTINCT tx_hash) >= 1e3 THEN TO_CHAR(ROUND(COUNT(DISTINCT tx_hash) / 1e3, 2)) || 'K'

ELSE TO_CHAR(COUNT(DISTINCT tx_hash)) -

END AS "transaction count"

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

COUNT(DISTINCT tx_hash) DESC

10;