DAY | RUNE_PRICE | DETERMINISTIC_RUNE_PRICE | |
|---|---|---|---|
1 | 2025-04-11 00:00:00.000 | 1.07675 | 0.5070857864 |
2 | 2025-04-10 00:00:00.000 | 1.089708333 | 0.4900375141 |
3 | 2025-04-09 00:00:00.000 | 1.034390917 | 0.508294678 |
4 | 2025-04-08 00:00:00.000 | 1.040540458 | 0.4632032878 |
5 | 2025-04-07 00:00:00.000 | 1.017930417 | 0.4803600893 |
6 | 2025-04-06 00:00:00.000 | 1.074346958 | 0.4815860114 |
7 | 2025-04-05 00:00:00.000 | 1.115833333 | 0.5154656711 |
8 | 2025-04-04 00:00:00.000 | 1.120416667 | 0.5201258781 |
9 | 2025-04-03 00:00:00.000 | 1.117833333 | 0.5164967961 |
10 | 2025-04-02 00:00:00.000 | 1.170833333 | 0.5151518567 |
11 | 2025-04-01 00:00:00.000 | 1.18375 | 0.5407849434 |
12 | 2025-03-31 00:00:00.000 | 1.127916667 | 0.5217024338 |
13 | 2025-03-30 00:00:00.000 | 1.134583333 | 0.5180602619 |
14 | 2025-03-29 00:00:00.000 | 1.138333333 | 0.5195066083 |
15 | 2025-03-28 00:00:00.000 | 1.2 | 0.5351505015 |
16 | 2025-03-27 00:00:00.000 | 1.27375 | 0.5633771228 |
17 | 2025-03-26 00:00:00.000 | 1.275416667 | 0.5632434629 |
18 | 2025-03-25 00:00:00.000 | 1.2525 | 0.5624534787 |
19 | 2025-03-24 00:00:00.000 | 1.27875 | 0.5667795586 |
20 | 2025-03-23 00:00:00.000 | 1.252083333 | 0.5622660926 |
pietrektDeterministic Rune Price
Updated 2 days ago
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 init AS (
SELECT to_date(block_timestamp) as day
from thorchain.core.dim_block
where day > '2021-04-10 00:00:00.000'
group by day
),
supply_changes AS ( SELECT
to_date(block_timestamp) as day
,
CASE
WHEN supply = 'burn' and reason = 'swap' then -asset_e8 / 1e8
WHEN supply = 'mint' and reason = 'swap' then asset_e8 / 1e8
ELSE 0
END as lending_change9,
CASE
WHEN supply = 'burn' and reason = 'adr' then -asset_e8 / 1e8
ELSE 0
END as adr129,
CASE
WHEN supply = 'burn' and reason = 'burn_system_income' then -asset_e8 / 1e8
ELSE 0
END as adr179
FROM thorchain.defi.fact_mint_burn_events
where asset = 'THOR.RUNE'
),
killswitch AS (
SELECT a.day,
COALESCE(lending_change9, 0) as lending_change9,
COALESCE(adr179, 0) as adr179,
COALESCE(adr129, 0) as adr129,
Last run: about 22 hours agoAuto-refreshes every 24 hours
...
1439
73KB
18s