with failed_jupiter as (
Select
block_timestamp::date as date,
count(*) as failed_swaps_count
From Solana.swaps s
where block_timestamp::date >= '2022-01-01'
and succeeded = 'FALSE'
and swap_program like '%jupiter%'
GROUP BY 1
ORDER BY 1
), success_jupiter as (
Select
block_timestamp::date as date,
count(*) as success_swaps_count
From Solana.swaps s
where block_timestamp::date >= '2022-01-01'
and succeeded = 'TRUE'
and swap_program like '%jupiter%'
GROUP BY 1
ORDER BY 1
)
SELECT f.date, failed_swaps_count, success_swaps_count, success_swaps_count/(success_swaps_count+failed_swaps_count) as success_ratio
FROM failed_jupiter f LEFT JOIN success_jupiter s ON f.date = s.date
ORDER BY 1