AFFILIATE_NAME | SWAP_COUNT | Swap Volume | |
|---|---|---|---|
1 | Vultisig | 382 | 8074847 |
Spot-WiggumVultisig 7 Day Volume
Updated 2025-02-06
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 7 Day Volume @ https://flipsidecrypto.xyz/studio/queries/89e72bfe-d4b6-4c09-b07c-a3a28ed4d503
-- 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 '7 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,
block_timestamp::date AS day,
from_address,
from_amount_usd,
affiliate_address,
CASE
WHEN affiliate_address IN ('vi', 'va', 'v0') THEN 'Vultisig'
ELSE 'Unknown Affiliate'
END AS affiliate_name
Last run: 2 months agoAuto-refreshes every 12 hours
1
26B
41s