main as (

tx_id,

block_timestamp,

swapper,

swap_from_symbol as symbol_in,

swap_to_symbol as symbol_out,

abs(nvl(swap_from_amount_usd, swap_to_amount_usd)) as amount_usd,

case

when platform ilike 'jupiter%' then 'Jupiter'

when platform ilike 'raydium%' then 'Raydium'

when platform ilike 'meteora%' then 'Meteora'

when platform ilike 'saber%' then 'Saber'

when platform ilike 'orca%' then 'Orca'

else initcap(platform)

end as platform

solana.marinade.ez_swaps

succeeded

and 'MSOL' in (symbol_in, symbol_out)

select

extract(hour from block_timestamp) as hour,

count(*) as swap_count,

sum(amount_usd) as total_volume

from main

group by hour

order by hour