MLDZMNsuccessrate
    Updated 2023-05-12
    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