DAY | AFFILIATE_NAME | SWAP_COUNT | Swap Volume | |
---|---|---|---|---|
1 | 2025-02-16 00:00:00.000 | SwapKit | 120 | 2161339 |
2 | 2025-02-16 00:00:00.000 | Thorswap | 22 | 3893 |
3 | 2025-02-15 00:00:00.000 | SwapKit | 197 | 4960134 |
4 | 2025-02-15 00:00:00.000 | Thorswap | 26 | 4417 |
5 | 2025-02-14 00:00:00.000 | SwapKit | 292 | 4250836 |
6 | 2025-02-14 00:00:00.000 | Thorswap | 33 | 384598 |
7 | 2025-02-13 00:00:00.000 | SwapKit | 482 | 4428817 |
8 | 2025-02-13 00:00:00.000 | Thorswap | 26 | 4199 |
9 | 2025-02-12 00:00:00.000 | SwapKit | 256 | 3571298 |
10 | 2025-02-12 00:00:00.000 | Thorswap | 38 | 295784 |
11 | 2025-02-11 00:00:00.000 | SwapKit | 202 | 4591281 |
12 | 2025-02-11 00:00:00.000 | Thorswap | 41 | 6167 |
13 | 2025-02-10 00:00:00.000 | SwapKit | 170 | 1976124 |
14 | 2025-02-10 00:00:00.000 | Thorswap | 33 | 5459 |
15 | 2025-02-09 00:00:00.000 | SwapKit | 198 | 2318502 |
16 | 2025-02-09 00:00:00.000 | Thorswap | 34 | 4368 |
17 | 2025-02-08 00:00:00.000 | SwapKit | 121 | 2361450 |
18 | 2025-02-08 00:00:00.000 | Thorswap | 42 | 146660 |
19 | 2025-02-07 00:00:00.000 | SwapKit | 194 | 3661807 |
20 | 2025-02-07 00:00:00.000 | Thorswap | 28 | 3604 |
Spot-WiggumThorswap/ SwapKit Daily Volume
Updated 2 days 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 SwapKit Affiliates Daily Volumes @ https://flipsidecrypto.xyz/studio/queries/1fe30f14-c134-4e6d-ab12-7f2b5e4f6b84
-- 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,
block_timestamp::date AS day,
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: 2 days agoAuto-refreshes every 12 hours
...
826
40KB
10s