DATE | VALUE | VALUE_PRECISE_RAW | VALUE_PRECISE | |
|---|---|---|---|---|
1 | 2025-01-23 00:00:00.000 | 0.5087762841 | 508776284118961145 | 0.508776284118961145 |
2 | 2025-01-23 00:00:00.000 | 0.036 | 36000000000000000 | 0.036 |
3 | 2025-01-23 00:00:00.000 | 0.02671400586 | 26714005859639713 | 0.026714005859639713 |
4 | 2025-01-23 00:00:00.000 | 0.05 | 50000000000000000 | 0.05 |
5 | 2025-01-23 00:00:00.000 | 0.2 | 200000000000000000 | 0.2 |
6 | 2025-01-23 00:00:00.000 | 0.02315259401 | 23152594012701291 | 0.023152594012701291 |
7 | 2025-01-23 00:00:00.000 | 0.0480699165 | 48069916495741422 | 0.048069916495741422 |
8 | 2025-01-23 00:00:00.000 | 0.1322354561 | 132235456064586093 | 0.132235456064586093 |
9 | 2025-01-23 00:00:00.000 | 0.0495 | 49500000000000000 | 0.0495 |
10 | 2025-01-23 00:00:00.000 | 0.1206945791 | 120694579130455062 | 0.120694579130455062 |
11 | 2025-01-23 00:00:00.000 | 0.054 | 54000000000000000 | 0.054 |
12 | 2025-01-23 00:00:00.000 | 0.1 | 100000000000000000 | 0.1 |
13 | 2025-01-23 00:00:00.000 | 0.01 | 10000000000000000 | 0.01 |
14 | 2025-01-23 00:00:00.000 | 0.5 | 500000000000000000 | 0.5 |
15 | 2025-01-23 00:00:00.000 | 0.1 | 100000000000000000 | 0.1 |
16 | 2025-01-23 00:00:00.000 | 0.5659325029 | 565932502855661867 | 0.565932502855661867 |
17 | 2025-01-23 00:00:00.000 | 0.4682302975 | 468230297497792004 | 0.468230297497792004 |
18 | 2025-01-23 00:00:00.000 | 0.08906425744 | 89064257443892825 | 0.089064257443892825 |
19 | 2025-01-23 00:00:00.000 | 0.03 | 30000000000000000 | 0.03 |
20 | 2025-01-23 00:00:00.000 | 0.3614597797 | 361459779701440536 | 0.361459779701440536 |
hessminimum-coral
Updated 2025-02-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with price as ( select hour::date as day,
token_address,
symbol,
avg(price) as avg_price
from ronin.price.ez_prices_hourly
where symbol = 'RON'
group by 1,2,3)
,
fee as ( select block_timestamp::Date as date,
VALUE,
VALUE_PRECISE_RAW,
VALUE_PRECISE
from ronin.core.fact_traces
where from_address = '0xa54b0184d12349cf65281c6f965a74828ddd9e8f'
and to_address = '0x3a62b1e24a2e734d9721ebb9064dfdb0504a7dbb'
)
select *
from fee
limit 100
Last run: 2 months ago
100
7KB
1s