AFFILIATE | RAW_AVERAGE_AFFILIATE_BPS | WEIGHTED_AVERAGE_AFFILIATE_BPS | |
---|---|---|---|
1 | 0 | 0 | 0 |
2 | 1 | 0.006794564349 | 0.00618071157 |
3 | 3 | 0 | 0 |
4 | BTC/BTC | ||
5 | bbs | 0 | 0 |
6 | bot | 100 | 100 |
7 | cakewallet | 82.083333333333 | 99.680957105 |
8 | commission | 30 | 30 |
9 | dcf | 0.283546325879 | 0.2401053572 |
10 | dokwallet | 100 | 100 |
11 | ds | 11.651515151515 | 13.627699842 |
12 | dx | 8.27373823781 | 6.472633374 |
13 | ej | 73.599670510708 | 74.944725491 |
14 | ferz | 53.333333333333 | 30.005753759 |
15 | giddy | 80 | 80.024342471 |
16 | iw | 25 | 30.187580074 |
17 | iwt | 35 | 49.602362129 |
18 | kf | 0 | 0 |
19 | kk | 24 | 24.802889592 |
20 | lends | 0 | 0 |
NineRealmsAffiliate Fee Averaged Basis Points
Updated 2024-11-22
999
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 Top 10 Affiliates (By Volume USD) @ https://flipsidecrypto.xyz/edit/queries/94af4cff-a83c-498b-b9d4-5c79895eb063
-- forked from (THORSwap) Top 10 Directed Swap Pairs By Affiliate Address @ https://flipsidecrypto.xyz/edit/queries/dd2bdbc7-f3f0-4332-b970-d18ef5cc9822
WITH attempted_txs AS (
SELECT
TX_ID,
SPLIT_PART(MEMO, ':', 4) LIKE '%/%/%' AS IS_STREAMING,
CASE
WHEN split_part(MEMO, ':', 5) != '' THEN split_part(MEMO, ':', 5)
WHEN (
MEMO LIKE '%::0'
AND MEMO NOT LIKE '+%'
) THEN 'te-ios'
ELSE NULL
END AS AFFILIATE_ADDRESS,
CASE
UPPER(
SPLIT_PART(
REPLACE(SPLIT_PART(MEMO, ':', 2), '/', '.'),
'-',
1
)
)
WHEN 'A' THEN 'AVAX.AVAX'
WHEN 'B' THEN 'BTC.BTC'
WHEN 'C' THEN 'BCH.BCH'
WHEN 'N' THEN 'BNB.BNB'
WHEN 'S' THEN 'BSC.BNB'
WHEN 'D' THEN 'DOGE.DOGE'
WHEN 'E' THEN 'ETH.ETH'
WHEN 'G' THEN 'GAIA.ATOM'
WHEN 'L' THEN 'LTC.LTC'
WHEN 'R' THEN 'THOR.RUNE'
ELSE UPPER(
SPLIT_PART(
REPLACE(SPLIT_PART(MEMO, ':', 2), '/', '.'),
'-',
Last run: 2 months ago
44
1KB
13s