SELECT

project_name,

MAX(price_usd) AS "highest sale usd",

MIN(price_usd) AS "lowest sale usd"

FROM arbitrum.nft.ez_nft_sales

WHERE block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '30 DAY'

GROUP BY project_name

SELECT

project_name,

"highest sale usd",

"lowest sale usd",

("highest sale usd" - "lowest sale usd") AS "price range"

FROM price_disparity

ORDER BY "price range" DESC;