Crazy_KidNew DEX Users 1
    Updated 2022-03-31
    WITH tiny AS (SELECT DISTINCT swapper FROM algorand.swaps WHERE swap_program = 'tinyman'),
    algo AS (SELECT swapper as algofi_swapper, ROW_NUMBER() OVER(ORDER BY algofi_swapper) as row1
    FROM algorand.swaps
    WHERE swap_program = 'algofi' AND swapper IN (SELECT * FROM tiny)
    AND date(block_timestamp) >= '2022-01-01'
    GROUP BY algofi_swapper),

    pact AS (SELECT swapper as pactfi_swapper, ROW_NUMBER() OVER(ORDER BY pactfi_swapper) as row2
    FROM algorand.swaps
    WHERE swap_program = 'pactfi' AND swapper IN (SELECT * FROM tiny)
    AND date(block_timestamp) >= '2022-01-01'
    GROUP BY pactfi_swapper),

    wagmi AS (SELECT swapper as wagmi_swapper, ROW_NUMBER() OVER(ORDER BY wagmi_swapper) as row3
    FROM algorand.swaps
    WHERE swap_program = 'wagmiswap' AND swapper IN (SELECT * FROM tiny)
    AND date(block_timestamp) >= '2022-01-01'
    GROUP BY wagmi_swapper)


    SELECT algofi_swapper, pactfi_swapper, wagmi_swapper
    FROM algo
    LEFT JOIN pact ON row1 = row2
    LEFT JOIN wagmi ON row1 = row3
    ORDER BY row1
    Run a query to Download Data