WEEK | AFFILIATE_NAME | Swap Count | Swap Volume | |
|---|---|---|---|---|
1 | 2025-02-24 00:00:00.000 | Trust Wallet | 5001 | 90525744 |
2 | 2025-02-24 00:00:00.000 | Thorwallet | 850 | 71900530 |
3 | 2025-02-24 00:00:00.000 | Asgardex | 220 | 24710750 |
4 | 2025-02-24 00:00:00.000 | Ledger | 462 | 18930664 |
5 | 2025-02-24 00:00:00.000 | -_ | 835 | 11606231 |
6 | 2025-02-24 00:00:00.000 | OKX Wallet | 108 | 10168600 |
7 | 2025-02-24 00:00:00.000 | Lifi | 260 | 7490840 |
8 | 2025-02-24 00:00:00.000 | g1 | 42 | 7341731 |
9 | 2025-02-24 00:00:00.000 | Shapeshift | 142 | 6244633 |
10 | 2025-02-24 00:00:00.000 | XDEFI | 79 | 2029886 |
11 | 2025-02-24 00:00:00.000 | Thorswap | 239 | 375435 |
12 | 2025-02-24 00:00:00.000 | Babylon (Kensho) | 2 | 157011 |
13 | 2025-02-24 00:00:00.000 | El Dorado | 12 | 152141 |
14 | 2025-02-24 00:00:00.000 | Vultisig | 15 | 101444 |
15 | 2025-02-24 00:00:00.000 | Zengo | 51 | 81277 |
16 | 2025-02-24 00:00:00.000 | Plexus | 1 | 66237 |
17 | 2025-02-24 00:00:00.000 | Edge Wallet | 18 | 42345 |
18 | 2025-02-24 00:00:00.000 | unizen-utxo | 4 | 18692 |
19 | 2025-02-24 00:00:00.000 | Decentralfi | 2 | 13717 |
20 | 2025-02-24 00:00:00.000 | XDF | 76 | 6396 |
Spot-WiggumAffiliates Weekly Volumes
Updated 2025-02-27
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 Affiliates Daily Volumes @ https://flipsidecrypto.xyz/studio/queries/5d849804-ebbb-4983-8c33-12523e13c899
-- 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(week,block_timestamp) AS week,
from_address,
from_amount_usd,
affiliate_address,
CASE
WHEN affiliate_address IN ('t', 'T','ts','thor160yye65pf9rzwrgqmtgav69n6zlsyfpgm9a7xk','thor17suv0n437snv68axkx64whutkrvefv7pzq7xep','tl') THEN 'Thorswap'
WHEN affiliate_address IN ('ti','te','tr','td','tb') THEN 'Trust Wallet'
WHEN affiliate_address IN ('dx','thor1ap5vn4svwkpch2c9jm7hlpr2pj47e62xwpcvtw') THEN 'Asgardex'
Last run: 2 months agoAuto-refreshes every 12 hours
...
1833
85KB
151s