SELECT

tx_id,

NVL(SWAP_FROM_AMOUNT_USD, SWAP_TO_AMOUNT_USD) AS amount_usd

FROM

solana.defi.ez_dex_swaps

WHERE

Swap_from_mint = '2zMMhcVQEXDtdE6vsFS7S7D5oUodfJHE8vd1gnBouauv'

OR swap_to_mint = '2zMMhcVQEXDtdE6vsFS7S7D5oUodfJHE8vd1gnBouauv'

SELECT

CASE

WHEN amount_usd < 10 THEN '🟢 a. Less than 10 $'

WHEN amount_usd <= 50 THEN '🔵 b. 10 - 50 $'

WHEN amount_usd <= 100 THEN '🟡 c. 50 - 100 $'

WHEN amount_usd <= 500 THEN '🟠 d. 100 - 500 $'

WHEN amount_usd <= 1000 THEN '🟣 e. 500 - 1000 $'

WHEN amount_usd <= 5000 THEN '🔴 f. 1000 - 5000 $'

WHEN amount_usd <= 10000 THEN '🟤 g. 5000 - 10,000 $'

WHEN amount_usd <= 100000 THEN '⚪ h. 10,000 - 100,000 $'

ELSE '⚫ i. More than 100,000 $'

END AS type,

COUNT(DISTINCT tx_id) AS transactions

FROM

main

GROUP BY

type

ORDER BY

type