AFFILIATE_NAME | SWAP_COUNT | Swap Volume | Swap Volume % | Cumulative Volume | |
|---|---|---|---|---|---|
1 | Edge Wallet | 40 | 83369 | 43.6 | 191332 |
2 | XDEFI | 10 | 54571 | 28.5 | 107963 |
3 | Lifi | 59 | 51112 | 26.7 | 53392 |
4 | Zengo | 8 | 2080 | 1.1 | 2280 |
5 | Symbiosis | 1 | 200 | 0.1 | 200 |
Spot-WiggumSwapKit Cumulative Volume (24hr)
Updated 6 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 SwapKit Cumulative Volume (7d) @ https://flipsidecrypto.xyz/studio/queries/a38f6f5c-279d-4fa4-9d70-8bc60eb9bd56
-- forked from SwapKit Cumulative Volume (30d) @ https://flipsidecrypto.xyz/studio/queries/f26d624e-e463-42c8-a20b-1fd8c157ced2
-- 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 >= CURRENT_DATE - INTERVAL '1 days'
),
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,
from_address,
from_amount_usd,
affiliate_address,
CASE
WHEN affiliate_address = 'tl' THEN 'Thorswap Ledger'
WHEN affiliate_address = 'ej' THEN 'Edge Wallet'
Last run: about 6 hours agoAuto-refreshes every 12 hours
5
152B
57s