VOLUME_USD | SWAPS | SWAPPERS | Average Volume Per User | Avg Trade Volume | Median Trade Volume | Max Trade Volume | FROM_TOKENS | TO_TOKENS | |
|---|---|---|---|---|---|---|---|---|---|
1 | 254726063.099963 | 1605022 | 147248 | 1729.91187045 | 160.080631094 | 22.9790945 | 873900 | 244 | 262 |
hessTotal Swap
Updated 2025-02-21
999
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 base as ( select block_timestamp,
tx_hash,
origin_from_address::string as swapper,
contract_address,
symbol,
amount,
to_address,
event_index,
from_address
from sei.core_evm.ez_token_transfers
where tx_hash in (select tx_hash
from sei.core_evm.fact_event_logs
where topics[0]::string = '0xd78ad95fa46c994b6551d0da85fc275fe613ce37657fb8d5e3d130840159d822'
)
and block_timestamp::date >= '2024-05-27')
,
index as ( select tx_hash,
event_index as max,
rank() over (partition by tx_hash order by event_index desc) as rank
from sei.core_evm.ez_token_transfers
where tx_hash in (select tx_hash from base)
qualify rank <= 2
)
,
min_index as ( select tx_hash,
min(event_index) as min
from sei.core_evm.ez_token_transfers
where tx_hash in (select tx_hash from base)
group by 1
)
,
token_in as ( select block_timestamp,
a.tx_hash,
swapper,
contract_address as token_in_address,
symbol as symbol_in,
Last run: 2 months ago
1
89B
68s