DAY | RUNE_PRICE | DETERMINISTIC_RUNE_PRICE | |
|---|---|---|---|
1 | 2025-04-25 00:00:00.000 | 1.3825 | 0.5879804705 |
2 | 2025-04-24 00:00:00.000 | 1.31375 | 0.5965333619 |
3 | 2025-04-23 00:00:00.000 | 1.306666667 | 0.5753629508 |
4 | 2025-04-22 00:00:00.000 | 1.253333333 | 0.5779639952 |
5 | 2025-04-21 00:00:00.000 | 1.230833333 | 0.5413352166 |
6 | 2025-04-20 00:00:00.000 | 1.179583333 | 0.5326790873 |
7 | 2025-04-19 00:00:00.000 | 1.152916667 | 0.525169397 |
8 | 2025-04-18 00:00:00.000 | 1.13625 | 0.5160278741 |
9 | 2025-04-17 00:00:00.000 | 1.13 | 0.5152705512 |
10 | 2025-04-16 00:00:00.000 | 1.111916667 | 0.5109757101 |
11 | 2025-04-15 00:00:00.000 | 1.139166667 | 0.506417961 |
12 | 2025-04-14 00:00:00.000 | 1.163333333 | 0.5188238241 |
13 | 2025-04-13 00:00:00.000 | 1.1625 | 0.5158360611 |
14 | 2025-04-12 00:00:00.000 | 1.143333333 | 0.5301311264 |
15 | 2025-04-11 00:00:00.000 | 1.105708333 | 0.5086969247 |
16 | 2025-04-10 00:00:00.000 | 1.089708333 | 0.4900375141 |
17 | 2025-04-09 00:00:00.000 | 1.034390917 | 0.508294678 |
18 | 2025-04-08 00:00:00.000 | 1.040540458 | 0.4632032878 |
19 | 2025-04-07 00:00:00.000 | 1.017930417 | 0.4803600893 |
20 | 2025-04-06 00:00:00.000 | 1.074346958 | 0.4815860114 |
pietrektDeterministic Rune Price
Updated 20 hours 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 20 hours agoAuto-refreshes every 24 hours
...
1453
74KB
12s