daily_swaps as (

select

date(block_timestamp) as date,

count(*) as total_swaps,

sum(

case

when succeeded = true then 1

else 0

end

) as succeeded,

sum(

case

when succeeded = false then 1

else 0

end

) as failed

from

solana.defi.fact_swaps

where

program_id in (

'JUP6i4ozu5ydDCnLiMogSckDPpbtr7BJ4FtzYWkb5Rk',

'JUP2jxvXaqu7NQY1GmNF4m1vodw12LVXYxbFL2uJvfo',

'JUP3c2Uh3WA4Ng34tw6kPd2G4C5BB21Xo36Je1s32Ph',

'JUP4Fb2cqiRUcaTHdrPC8h2gNsA2ETXiPDD33WcGuJB'

)

group by

date(block_timestamp)

),

swap_success_rate as (

select

date,

total_swaps,

succeeded,

failed,

(succeeded * 100.0) / total_swaps as success_rate,