(CASE

WHEN swap_from_amount < 10 THEN 'Less Than 10 SOl'

WHEN swap_from_amount >= 10 AND swap_from_amount < 100 THEN 'Between 10 SOL & 100 SOL'

WHEN swap_from_amount >= 100 AND swap_from_amount < 1000 THEN 'Between 100 SOL & 1K SOL'

WHEN swap_from_amount >= 1000 AND swap_from_amount < 10000 THEN 'Between 1K SOL & 10K SOL'

WHEN swap_from_amount >= 10000 THEN 'More Than 10K SOL'

END) AS Label,

COUNT(tx_id) AS number_of_txs,

COUNT(DISTINCT swapper) AS swappers,

SUM(swap_from_amount) AS swap_from_amount, SUM(swap_to_amount) AS swap_to_amount

FROM solana.core.fact_swaps

WHERE swap_from_mint IN ('So11111111111111111111111111111111111111112', -- SOL

'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So', -- marinade staked sol

'7dHbWXmci3dT8UFYWYZweBLXgycu7Y3iL6trKn1Y7ARj', -- Lido Staked SOL

'5oVNBeEEQvYi1cX3ir8Dx5n1P7pdxydbGF2X4TxVusJm', -- Socean staked SOL

'7Q2afV64in6N6SeZsAAB81TJzwDoD6zpqmHkzi9Dcavn', -- JPOOL Solana Token

'GEJpt3Wjmr628FqXxTgxMce1pLntcPV4uFi8ksxMyPQh', -- daoSOL Token

'bSo13r4TkiE4KumL71LsHTPpL2euBYLFx6h9HP3piy1' -- BlazeStake Staked SOL

)

AND swap_to_mint IN(

'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v', --USD Coin (USDC)

'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB', --USDT (USDT)

'A9mUU4qviSctJVPJdBJWkb28deg915LYJKrzQ19ji3FM', --USD Coin (Wormhole) (USDC)

'DdFPRnccQqLD4zCHrBqdY95D6hvw6PLWp9DEXj1fLCL9', --Wrapped USDC (Allbridge from Ethereum) (aeUSDC)

'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX', --USDH Hubble Stablecoin (USDH)

'6nuaX3ogrr2CaoAPjtaKHAoBNWok32BMcRozuf32s2QF' --Wrapped BUSD (Allbridge from BSC) (abBUSD)

)

AND block_timestamp::DATE BETWEEN CURRENT_DATE - 10 AND CURRENT_DATE - 1

AND swap_from_amount <> 0

GROUP BY 1,2

ORDER BY 1