date_trunc('hour', block_timestamp) AS "Hour"

, CASE WHEN swap_program ILIKE '%raydium%' THEN 'Raydium'

WHEN swap_program ILIKE '%meteora%' THEN 'Meteora'

WHEN swap_program ILIKE '%orca%' THEN 'Orca'

WHEN swap_program ILIKE '%phoenix%' THEN 'Phoenix'

ELSE swap_program END AS "Platform"

, count(DISTINCT swapper) AS Traders

, SUM(CASE WHEN swap_to_mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN' THEN swap_from_amount_usd ELSE 0 END) AS "Buy"

, SUM(CASE WHEN swap_from_mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN' THEN -(swap_to_amount_usd) ELSE 0 END) AS "Sell"

, SUM(CASE WHEN swap_to_mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'

THEN swap_from_amount_usd

ELSE swap_to_amount_usd

END)

AS "Volume"

, SUM("Volume") OVER (ORDER BY "Hour") AS "Cummulative volume"

FROM solana.defi.ez_dex_swaps

WHERE swap_to_mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'

OR swap_from_mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'

GROUP BY 1, 2

ORDER BY "Hour" desc