Date_trunc(day , block_timestamp) AS date,

COUNT(DISTINCT SWAP_FROM_AMOUNT) AS Swap_volume,

--Swap_program,

CASE

when swap_program ilike '%meteora%' then 'Meteora'

when swap_program ilike '%raydium%' then 'Raydium'

when swap_program ilike '%orca%' then 'Orca'

when swap_program ilike '%jupiter%' then 'Jupiter'

end as DEX

FROM solana.defi.fact_swaps

WHERE swap_from_mint like '8wXtPeU6557ETkp9WHFY1n1EcU6NxDvbAggHGsMYiHsB'

OR swap_to_mint like '8wXtPeU6557ETkp9WHFY1n1EcU6NxDvbAggHGsMYiHsB'

AND succeeded = 'TRUE'

GROUP BY 1,3

ORDER BY 2 DESC