Crazy_KidNew DEX Users 1
Updated 2022-03-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
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