KingTigerMafia-7mwRZbSolana Free Square - Swap Volume
    Updated 2022-06-14
    with all_tx as (
    select block_timestamp::date as date, count(distinct tx_id) as tx_count
    from solana.core.fact_swaps
    where date >= '2022-01-01'
    group by 1
    order by 1 ASC
    ), success_tx as (
    select block_timestamp::date as date, count(distinct tx_id) as tx_count
    from solana.core.fact_swaps
    where date >= '2022-01-01' and succeeded = 'TRUE'
    group by 1
    order by 1 ASC
    )

    select all_tx.date, all_tx.tx_count as total_volume, s_t.tx_count/all_tx.tx_count * 100 as success_rate
    from success_tx s_t join all_tx on s_t.date = all_tx.date
    order by 1 asc
    Run a query to Download Data