DATE | TOTAL | New Swapper | Returning Swapper | |
|---|---|---|---|---|
1 | 2025-02-20 00:00:00.000 | 530 | 234 | 296 |
2 | 2025-02-21 00:00:00.000 | 575 | 197 | 378 |
3 | 2025-02-03 00:00:00.000 | 590 | 387 | 203 |
4 | 2025-02-01 00:00:00.000 | 1553 | 1318 | 235 |
5 | 2025-02-28 00:00:00.000 | 1173 | 818 | 355 |
6 | 2025-03-04 00:00:00.000 | 925 | 532 | 393 |
7 | 2025-02-07 00:00:00.000 | 690 | 411 | 279 |
8 | 2025-01-17 00:00:00.000 | 260 | 236 | 24 |
9 | 2025-03-08 00:00:00.000 | 313 | 158 | 155 |
10 | 2025-02-13 00:00:00.000 | 742 | 402 | 340 |
11 | 2025-02-22 00:00:00.000 | 587 | 246 | 341 |
12 | 2025-01-24 00:00:00.000 | 314 | 232 | 82 |
13 | 2025-01-15 00:00:00.000 | 89 | 87 | 2 |
14 | 2025-03-01 00:00:00.000 | 1624 | 1132 | 492 |
15 | 2025-01-23 00:00:00.000 | 272 | 194 | 78 |
16 | 2025-02-17 00:00:00.000 | 664 | 347 | 317 |
17 | 2025-01-30 00:00:00.000 | 2437 | 1978 | 459 |
18 | 2025-01-26 00:00:00.000 | 457 | 311 | 146 |
19 | 2025-02-19 00:00:00.000 | 550 | 245 | 305 |
20 | 2025-01-27 00:00:00.000 | 392 | 247 | 145 |
hess2. Daily New
Updated 2025-03-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 base as (select tx_hash,
block_timestamp,
origin_from_address AS swapper,
DECODED_LOG:"amount0In"::NUMBER AS amount0In,
DECODED_LOG:"amount0Out"::NUMBER AS amount0Out,
DECODED_LOG:"amount1In"::NUMBER AS amount1In,
DECODED_LOG:"amount1Out"::NUMBER AS amount1Out,
DECODED_LOG:"sender"::STRING AS sender,
DECODED_LOG:"to"::STRING AS recipient,
contract_address as pool_address,
case when decoded_log:amount1Out::NUMBER = 0 then decoded_log:amount1In::NUMBER else decoded_log:amount1Out::NUMBER end AS token_1_amounts,
case when decoded_log:amount0In::NUMBER = 0 then decoded_log:amount0Out::NUMBER else decoded_log:amount0In::NUMBER end AS token_0_amounts,
DECODED_LOG:"amount0"::NUMBER as amount0,
DECODED_LOG:"amount1"::NUMBER as amount1,
case when amount0 > 0 then amount0 else abs(amount0) end as token0,
case when amount1 > 0 then amount1 else abs(amount1) end as token1,
Coalesce(token_1_amounts,token1) as token_1_amount,
Coalesce(token_0_amounts,token0) as token_0_amount
FROM ink.core.ez_decoded_event_logs
WHERE event_name = 'Swap'
and origin_to_address = lower('0x652e53c6a4fe39b6b30426d9c96376a105c89a95')
and TX_SUCCEEDED = 'TRUE')
,
pool as (select concat('0x', substr(topics[1], 24 + 3, 32 + 8)) as token_0_address,
concat('0x', substr(topics[2], 24 + 3, 32 + 8)) as token_1_address,
regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') AS pool_data,
concat('0x', substr(pool_data[0], 25, 40)) as pool_address
from ink.core.fact_event_logs
having pool_address is not null)
,
pair as ( select a.*,
token_0_address,
token_1_address
from base a left outer join pool b on a.pool_address = b.pool_address)
,
token_bonk as ( select * from $query('43200306-984d-4255-816a-7685810d5804'))
Last run: about 2 months ago
54
2KB
5s