MLDZMNsuccessrate
Updated 2023-05-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
date_trunc('{{Time_basis}}',BLOCK_TIMESTAMP) as date,
case
when SUCCEEDED='TRUE' then 'SUCCEEDED'
else 'FAILED' end as success_rate,
count(distinct tx_id) as no_swaps,
count(distinct SWAPPER) as no_trader
from solana.core.fact_swaps
where PROGRAM_ID ilike 'JUP%'
AND block_timestamp >=CURRENT_DATE- {{Time_period_days}}
group by 1,2
Run a query to Download Data