date_trunc(day, block_timestamp) as day,

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 '%phoenix%' then 'Phoenix'

when SWAP_PROGRAM ilike '%jupiter%' then 'Jupiter'

else SWAP_PROGRAM

end as DEX,

count(DISTINCT tx_id) as N_Swap,

count(DISTINCT SWAPPER) as N_Swapper,

sum(SWAP_FROM_AMOUNT_USD) as Swap_Amount

solana.defi.ez_dex_swaps

(

SWAP_from_MINT = 'A8C3xuqscfmyLrte3VmTqrAq8kgMASius9AFNANwpump'

or SWAP_to_MINT = 'A8C3xuqscfmyLrte3VmTqrAq8kgMASius9AFNANwpump'

)

and block_timestamp >= current_timestamp - interval '90 days'

group by

1,

2

),

fill_dates as (

select

date_day,

DEX

from crosschain.core.dim_dates cross join swaps

where date_day >= current_timestamp - interval '90 days'

and date_day <= current_timestamp

group by 1,2

select