Afonso_DiazBy Swap route
Updated 2025-01-21
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
stablecoins as (
select
'A.0x3c5959b568896393.FUSD' as token_address
union all
select
'A.0xb19436aae4d94622.FiatToken' as token_address
union all
select
'A.231cc0dbbcffc4b7.ceBUSD' as token_address
union all
select
'A.f1ab99c82dee3526.USDCFlow' as token_address
),
main as (
select
tx_id,
block_timestamp,
trader as swapper,
platform,
token_in_symbol as symbol_in,
token_out_symbol as symbol_out,
case
when token_in in (select token_address from stablecoins) then 'Stablecoin'
when token_in = 'A.1654653399040a61.FlowToken' then 'Flow Token'
else 'Other Assets'
end || ' -> ' || case
when token_out in (select token_address from stablecoins) then 'Stablecoin'
QueryRunArchived: QueryRun has been archived