Afonso_DiazTotal
Updated 2025-01-20
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
main as (
select
tx_id,
block_timestamp,
from_address as swapper,
from_asset as symbol_in,
to_asset as symbol_out,
case
when affiliate_address = 'tl' then 'TS Ledger'
when affiliate_address = 'cb' then 'Team CoinBot'
when affiliate_address = 'dx' then 'Asgardex'
when affiliate_address in ('ti', 'tr', 'td', 'te') then 'Trust Wallet'
when affiliate_address = 'rg' then 'Rango'
when affiliate_address = 'oky' then 'OneKey Wallet'
when affiliate_address = 'ss' then 'ShapeShift'
when affiliate_address = 'xdf' then 'xDEFI'
when affiliate_address in ('thor160yye65pf9rzwrgqmtgav69n6zlsyfpgm9a7xk', 't', 'T') then 'THORSwap'
when affiliate_address = 'ej' then 'Edge Wallet'
when affiliate_address = 'ds' then 'DefiSpot'
when affiliate_address in ('wr', 'thor1a427q3v96psuj4fnughdw8glt5r7j38lj7rkp8') then 'THOR Wallet'
when affiliate_address = 'sy' then 'Symbiosis'
when affiliate_address = 'lends' then 'Lends'
when affiliate_address = 'vi' then 'Vultisig'
when affiliate_address = 'cakewallet' then 'Cake Wallet'
when affiliate_address = 'lifi' then 'Lifi'
end as affiliate,
nvl(from_amount_usd, to_amount_usd) as amount_usd
from
thorchain.defi.fact_swaps
where
pool_name like 'BASE.%'
)
select
QueryRunArchived: QueryRun has been archived