NO_SWAPS | USERS | TOTAL_VOLUME | AVG_VOLUME | MEDIAN_VOLUME | AVG_VOL_PER_WEEK | AVG_USER_PER_WEEK | |
|---|---|---|---|---|---|---|---|
1 | 235657 | 11939 | 925774101.517252 | 4503.953361116 | 603.834979695 | 5200978.09841153 | 67.073034 |
MLDZMNs1_total
Updated 2025-03-28
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 pools as (
select
*
from $query('10fe49b2-202c-4f2e-a145-d50c66a70ca7')
),
price_tab as (
select
HOUR::date as day,
TOKEN_ADDRESS,
SYMBOL,
avg(PRICE) as price
from boba.price.ez_prices_hourly
group by 1,2,3),
raw_swaps as (
select
logs.BLOCK_NUMBER,
logs.BLOCK_TIMESTAMP,
logs.TX_HASH,
logs.ORIGIN_FROM_ADDRESS,
logs.ORIGIN_FUNCTION_SIGNATURE,
logs.EVENT_INDEX,
logs.CONTRACT_ADDRESS as pool_address,
pool_name,
token0,
symbol0,
token1,
symbol1,
regexp_substr_all(substr(DATA, 3, len(DATA)), '.{64}') as split,
livequery.utils.udf_hex_to_int(split [0])::int as amount0in,
livequery.utils.udf_hex_to_int(split [1])::int as amount1in,
livequery.utils.udf_hex_to_int(split [2])::int as amount0out,
livequery.utils.udf_hex_to_int(split [3])::int as amount1out
from
boba.core.fact_event_logs logs
Last run: 3 months ago
1
89B
39s