MONTH | AFFILIATE_NAME | SWAP_COUNT | Swap Volume | |
|---|---|---|---|---|
1 | 2025-04-01 00:00:00.000 | SwapKit | 2699 | 7829053 |
2 | 2025-04-01 00:00:00.000 | Thorswap | 1569 | 633699 |
3 | 2025-03-01 00:00:00.000 | SwapKit | 4267 | 123623761 |
4 | 2025-03-01 00:00:00.000 | Thorswap | 1387 | 794712 |
5 | 2025-02-01 00:00:00.000 | SwapKit | 5294 | 117606804 |
6 | 2025-02-01 00:00:00.000 | Thorswap | 2031 | 30263136 |
7 | 2025-01-01 00:00:00.000 | SwapKit | 7372 | 186219009 |
8 | 2025-01-01 00:00:00.000 | Thorswap | 3365 | 148875510 |
9 | 2024-12-01 00:00:00.000 | SwapKit | 7039 | 150512279 |
10 | 2024-12-01 00:00:00.000 | Thorswap | 3045 | 172900153 |
11 | 2024-11-01 00:00:00.000 | SwapKit | 7074 | 185203826 |
12 | 2024-11-01 00:00:00.000 | Thorswap | 4519 | 259504899 |
13 | 2024-10-01 00:00:00.000 | SwapKit | 6295 | 195829199 |
14 | 2024-10-01 00:00:00.000 | Thorswap | 3033 | 130424728 |
15 | 2024-09-01 00:00:00.000 | SwapKit | 4940 | 114869208 |
16 | 2024-09-01 00:00:00.000 | Thorswap | 2247 | 72901816 |
17 | 2024-08-01 00:00:00.000 | SwapKit | 4828 | 102004545 |
18 | 2024-08-01 00:00:00.000 | Thorswap | 3640 | 314692091 |
19 | 2024-07-01 00:00:00.000 | SwapKit | 2705 | 14956073 |
20 | 2024-07-01 00:00:00.000 | Thorswap | 5231 | 243273977 |
Spot-WiggumThorswap/ SwapKit Monthly Volume
Updated 8 hours ago
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
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from Thorswap/ SwapKit monthly Volume @ https://flipsidecrypto.xyz/studio/queries/2e56dbb2-4366-40d3-ae96-280dda58ff98
-- forked from SwapKit Affiliates Daily Volumes @ https://flipsidecrypto.xyz/studio/queries/68248f53-fea9-40d9-a15a-d5a6efcd4ef4
WITH attempted_txs AS (
SELECT
DISTINCT tx_id,
block_timestamp,
from_address,
from_amount_usd,
affiliate_address
FROM
thorchain.defi.fact_swaps
WHERE
block_timestamp >= '2024-01-01'
),
successful_txs AS (
SELECT *
FROM attempted_txs AS a
WHERE NOT EXISTS (
SELECT 1
FROM thorchain.defi.fact_refund_events AS r
WHERE r.tx_id = a.tx_id
)
),
affiliate_swaps AS (
SELECT
DISTINCT tx_id,
DATE_TRUNC('month',block_timestamp) AS month,
from_address,
from_amount_usd,
affiliate_address,
CASE
WHEN affiliate_address IN ('t', 'T', 'ts', 'thor160yye65pf9rzwrgqmtgav69n6zlsyfpgm9a7xk','thor17suv0n437snv68axkx64whutkrvefv7pzq7xep') THEN 'Thorswap'
WHEN affiliate_address IN ('tl','ej','lifi','okw','sy','oky','xdf','cb','pl','zengo','bqx','bp','ELD') THEN 'SwapKit'
ELSE 'Unknown Affiliate'
Last run: about 8 hours agoAuto-refreshes every 12 hours
32
2KB
74s