DATE | TRADE_TYPE | N_TXS | N_USER | VOLUME | |
|---|---|---|---|---|---|
1 | 2025-01-08 00:00:00.000 | Buy | 37 | 16 | 14300.405130242 |
2 | 2025-01-08 00:00:00.000 | Sell | 20 | 16 | 14087.486151813 |
3 | 2025-01-07 00:00:00.000 | Buy | 171 | 49 | 37967.449028728 |
4 | 2025-01-07 00:00:00.000 | Sell | 220 | 48 | 31826.550698604 |
5 | 2025-01-06 00:00:00.000 | Sell | 454 | 64 | 43853.581564259 |
6 | 2025-01-06 00:00:00.000 | Buy | 295 | 39 | 47274.504567737 |
7 | 2025-01-05 00:00:00.000 | Buy | 207 | 24 | 7249.160201218 |
8 | 2025-01-05 00:00:00.000 | Sell | 366 | 19 | 9395.925882256 |
9 | 2025-01-04 00:00:00.000 | Sell | 426 | 38 | 17913.832199359 |
10 | 2025-01-04 00:00:00.000 | Buy | 247 | 43 | 13708.150497482 |
11 | 2025-01-03 00:00:00.000 | Buy | 201 | 42 | 28398.169253134 |
12 | 2025-01-03 00:00:00.000 | Sell | 180 | 46 | 18560.398863226 |
13 | 2025-01-02 00:00:00.000 | Buy | 22 | 17 | 3415.267186268 |
14 | 2025-01-02 00:00:00.000 | Sell | 23 | 20 | 3707.45457372 |
15 | 2025-01-01 00:00:00.000 | Buy | 52 | 17 | 8807.174947962 |
16 | 2025-01-01 00:00:00.000 | Sell | 26 | 21 | 7287.167466224 |
17 | 2024-12-31 00:00:00.000 | Buy | 103 | 35 | 16392.881955678 |
18 | 2024-12-31 00:00:00.000 | Sell | 48 | 26 | 16029.576496187 |
19 | 2024-12-30 00:00:00.000 | Buy | 117 | 35 | 15427.326581334 |
20 | 2024-12-30 00:00:00.000 | Sell | 113 | 42 | 12997.162721091 |
0xHaM-d$HAIR Sell/Buy
Updated 2025-01-08
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
token_info as (
select
token_address,
symbol,
name,
decimals
from aptos.core.dim_tokens
)
,prices as (
select
hour::date as p_date,
symbol,
decimals,
token_address,
avg(price) as avg_price
from aptos.price.ez_prices_hourly
GROUP by 1, 2, 3, 4
)
, swaps as (
SELECT
BLOCK_TIMESTAMP,
TX_HASH,
EVENT_DATA,
EVENT_TYPE,
sender as swapper,
CASE
WHEN event_data:x_in :: int = 0 THEN TRIM(SPLIT_PART(SPLIT(event_type, ',')[1], ' ',2) :: string, '>')
WHEN event_data:x_in :: int != 0 THEN TRIM(SPLIT_PART(SPLIT(event_type, ',')[0], '<', 2) :: string, ' ')
END AS token_in,
CASE
WHEN event_data:y_in :: int = 0 THEN TRIM(SPLIT_PART(SPLIT(event_type, ',')[1], ' ',2) :: string, '>')
WHEN event_data:y_in :: int != 0 THEN TRIM(SPLIT_PART(SPLIT(event_type, ',')[0], '<', 2) :: string, ' ')
END AS token_out,
CASE
WHEN event_data : x_in :: int = 0 THEN event_data : y_in :: int
Last run: 3 months ago
96
5KB
83s