with full_dex as

(select dex_label,

sum(SWAP_FROM_AMOUNT_USD) as total_vol

from

(select BLOCK_TIMESTAMP,

SWAP_PROGRAM,

case

when SWAP_PROGRAM like '%raydium%' then 'Raydium'

when SWAP_PROGRAM like '%Raydium%' then 'Orca'

when SWAP_PROGRAM like '%jupiter%' then 'Jupiter'

when SWAP_PROGRAM like '%orca%' then 'Orca'

when SWAP_PROGRAM like '%ORCA%' then 'Orca'

when SWAP_PROGRAM like '%phoenix%' then 'Phoenix'

--when SWAP_PROGRAM like '%Saber%' then 'Saber'

--when SWAP_PROGRAM like '%meteora%' then 'Meteora'

else 'Other'

end as dex_label,

SWAP_FROM_AMOUNT_USD

from solana.defi.ez_dex_swaps)

where date(BLOCK_TIMESTAMP) >= current_date() - 7

-- and

-- date(BLOCK_TIMESTAMP) <= current_date()

and

dex_label != 'Other'

and

dex_label != 'Raydium'

group by 1),

full_data_lifinity AS (

SELECT live.udf_api(

) as response

),