BlockTrackercustom affiliate fee over time
Updated 2025-01-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
›
⌄
with affiliate as (
select
CASE
WHEN affiliate_address IN ('t','t/-','T','ts','thor160yye65pf9rzwrgqmtgav69n6zlsyfpgm9a7xk','thor17suv0n437snv68axkx64whutkrvefv7pzq7xep') THEN 'Thorswap'
WHEN affiliate_address IN ('ti', 'te','tr', 'td') THEN 'Trust Wallet'
WHEN affiliate_address IN ('dx','thor1ap5vn4svwkpch2c9jm7hlpr2pj47e62xwpcvtw') THEN 'Asgardex'
WHEN affiliate_address IN ('wr','thor1a427q3v96psuj4fnughdw8glt5r7j38lj7rkp8') THEN 'Thorwallet'
WHEN affiliate_address IN ('va', 'vi','v0') THEN 'Vultisig'
WHEN affiliate_address IN ('zcx-com','0xbami','unizen-utxo') THEN 'Unizen'
WHEN affiliate_address = 'ds' THEN 'Defispot'
WHEN affiliate_address = 'rg' THEN 'Rango'
WHEN affiliate_address = 'ss' THEN 'Shapeshift'
WHEN affiliate_address = 'lends' THEN 'Lends'
WHEN affiliate_address = 'bp' THEN 'BitPay'
WHEN affiliate_address = 'dcf' THEN 'Decentralfi'
WHEN affiliate_address = 'tl' THEN 'Thorswap Ledger'
WHEN affiliate_address = 'ej' THEN 'Edge Wallet'
WHEN affiliate_address IN ('lifi','lifi/-_') THEN 'Lifi'
WHEN affiliate_address IN ('okw','okw/-_') THEN 'OKX Wallet'
WHEN affiliate_address = 'sy' THEN 'Symbiosis'
WHEN affiliate_address IN ('oky','OKY') THEN 'OneKey'
WHEN affiliate_address IN ('xdf','XDF') THEN 'XDEFI'
WHEN affiliate_address = 'zengo' THEN 'Zengo'
WHEN affiliate_address = 'cb' THEN 'Coinbot'
WHEN affiliate_address = 'pl' THEN 'Plexus'
WHEN affiliate_address = 'bqx' THEN 'Ethos'
WHEN affiliate_address = 'kf' THEN 'Babylon (Kensho)'
WHEN affiliate_address = 'ferz' THEN 'Ferz Wallet'
WHEN affiliate_address = 'runifier' THEN 'Runifier'
WHEN affiliate_address = 'cakewallet' THEN 'Cake Wallet'
WHEN affiliate_address = 'ELD' THEN 'El Dorado'
WHEN affiliate_address = 'cs' THEN 'CacaoSwap'
WHEN affiliate_address = 'moca' THEN 'Moca Wallet'
WHEN affiliate_address = 'll' THEN 'Ledger Live'
WHEN affiliate_address = 'bgw' THEN 'Bitget Wallet'