Crazy_KidTinyman Dex Popularity 2
    Updated 2022-03-24
    WITH wagmi AS (SELECT date(block_timestamp) as date1, count(DISTINCT tx_group_id) as wagmiswap
    FROM algorand.swaps
    WHERE swap_program = 'wagmiswap' AND date1 >= '2022-01-01' AND swap_from_amount != 0
    GROUP BY date1
    ORDER BY date1),
    algofi AS (SELECT date(block_timestamp) as date2, count(DISTINCT tx_group_id) as algofi
    FROM algorand.swaps
    WHERE swap_program = 'algofi' AND date2 >= '2022-01-01' AND swap_from_amount != 0
    GROUP BY date2
    ORDER BY date2),



    pactfi AS (SELECT date(block_timestamp) as date3, count(DISTINCT tx_group_id) as pactfi
    FROM algorand.swaps
    WHERE swap_program = 'pactfi' AND date3 >= '2022-01-01' AND swap_from_amount != 0
    GROUP BY date3
    ORDER BY date3)

    SELECT date1 as date, algofi, wagmiswap, pactfi
    FROM wagmi
    LEFT JOIN algofi ON date1 = date2
    LEFT JOIN pactfi on date1 = date3
    ORDER BY date
    Run a query to Download Data