SWAPS | SWAPPERS | |
|---|---|---|
1 | 1 | 330606 |
2 | 2 | 107875 |
3 | 3 | 38912 |
4 | 4 | 29660 |
5 | 5 | 17054 |
6 | 6 | 15187 |
7 | 7 | 8975 |
8 | 8 | 7888 |
9 | 9 | 5403 |
10 | 10 | 5318 |
11 | 11 | 3874 |
12 | 12 | 3713 |
13 | 14 | 3014 |
14 | 13 | 2688 |
15 | 16 | 2440 |
16 | 15 | 2023 |
17 | 18 | 1799 |
18 | 20 | 1625 |
19 | 17 | 1368 |
20 | 34 | 1257 |
MasiShare of Users by Number of Swaps
Updated 2025-02-02
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 tb1 as ( select trunc(block_timestamp,'day') as day,
tx_hash,
swapper,
--case when amount_in_usd is null then amount_out_usd else amount_in_usd end as amount_usd,
concat(symbol_in,'/',symbol_out) as pair,
symbol_in,
amount_in,
amount_out,
token_in,
token_out,
symbol_out,
platform,
amount_in_usd,
amount_out_usd
from aptos.defi.ez_dex_swaps
--where (AMOUNT_IN_USD between AMOUNT_OUT_USD - 5000 and AMOUNT_OUT_USD + 5000) -- Credited to Abbas from old Dashboards
where platform = 'thala'
)
,
tb2 as ( select trunc(hour,'day') as day,
token_address,
avg(price) as token_price
from aptos.price.ez_prices_hourly
group by 1,2 )
,
tb3 as ( select a.*,
amount_in_usd*b.token_price as amount_in_usd0,
amount_out_usd*c.token_price as amount_out_usd0,
case when symbol_in = 'USDC' then amount_in else amount_in_usd end as amount_usd0,
case when symbol_out = 'USDC' then amount_out else amount_out_usd end as amount_usd1,
case when amount_usd0 is null then amount_usd1 else amount_usd0 end as amount0,
case when amount_in_usd is null then amount_out_usd else amount_in_usd end as amount1,
case when amount0 is null then amount1 else amount0 end as amount_usd
from tb1 a left outer join tb2 b on a.token_in = b.token_address and a.day = b.day
left outer join tb2 c on a.token_out = c.token_address and a.day = c.day
)
Last run: 3 months ago
20
200B
14s