alitaslimiSwaps Overview
Updated 2024-10-08
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
swaps as (
select
block_timestamp,
tx_hash,
origin_from_address as swapper,
event_index,
case platform
when 'balancer' then 'Balancer'
when 'curve' then 'Curve'
when 'fraxswap' then 'Fraxswap'
when 'gmx' then 'GMX'
when 'hashflow' then 'Hashflow'
when 'kyberswap-v1' then 'KyberSwap'
when 'kyberswap-v2' then 'KyberSwap'
when 'pangolin' then 'Pangolin'
when 'platypus' then 'Platypus'
when 'sushiswap' then 'Sushiswap'
when 'trader-joe-v1' then 'Trader Joe'
when 'trader-joe-v2' then 'Trader Joe'
when 'uniswap-v3' then 'Uniswap'
when 'woofi' then 'WOOFi'
else platform
end as dex,
pool_name,
token_in,
token_out,
symbol_in,
symbol_out,
amount_in,
amount_out,
amount_in_usd,
amount_out_usd,
(amount_in_usd + amount_out_usd) / 2 as amount_usd
from
avalanche.defi.ez_dex_swaps
Auto-refreshes every 6 hours
QueryRunArchived: QueryRun has been archived