DAY | LENDING_CHANGE | CUMULATIVE_LENDING_BURN | ADR12 | CUMULATIVE_ADR12_BURN | KILLSWITCH | CUMULATIVE_KILLSWITCH_BURN | ADR17 | CUMULATIVE_ADR17_BURN | CUMULATIVE_RUNE_SUPPLY_CHANGE | CURRENT_RUNE_SUPPLY | |
|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-06-09 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -2000.454951 | -755595.06264 | -74451691.381983 | 425548308.618017 |
2 | 2025-06-08 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -900.641044 | -753594.607689 | -74449690.927032 | 425550309.072968 |
3 | 2025-06-07 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -950.022181 | -752693.966645 | -74448790.285988 | 425551209.714012 |
4 | 2025-06-06 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -2279.397807 | -751743.944464 | -74447840.263807 | 425552159.736193 |
5 | 2025-06-05 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -1437.761851 | -749464.546657 | -74445560.866 | 425554439.134 |
6 | 2025-06-04 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -851.772693 | -748026.784806 | -74444123.104149 | 425555876.895851 |
7 | 2025-06-03 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -2224.196568 | -747175.012113 | -74443271.331456 | 425556728.668544 |
8 | 2025-06-02 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -1688.866133 | -744950.815545 | -74441047.134888 | 425558952.865112 |
9 | 2025-06-01 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -2041.136361 | -743261.949412 | -74439358.268755 | 425560641.731245 |
10 | 2025-05-31 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -2758.763825 | -741220.813051 | -74437317.132394 | 425562682.867606 |
11 | 2025-05-30 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -2028.834864 | -738462.049226 | -74434558.368569 | 425565441.631431 |
12 | 2025-05-29 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -1757.687934 | -736433.214362 | -74432529.533705 | 425567470.466295 |
13 | 2025-05-28 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -2112.02462 | -734675.526428 | -74430771.845771 | 425569228.154229 |
14 | 2025-05-27 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -2043.404579 | -732563.501808 | -74428659.821151 | 425571340.178849 |
15 | 2025-05-26 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -1760.057784 | -730520.097229 | -74426616.416572 | 425573383.583428 |
16 | 2025-05-25 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -1984.352795 | -728760.039445 | -74424856.358788 | 425575143.641212 |
17 | 2025-05-24 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -1664.33474 | -726775.68665 | -74422872.005993 | 425577127.994007 |
18 | 2025-05-23 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -1706.764342 | -725111.35191 | -74421207.671253 | 425578792.328747 |
19 | 2025-05-22 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -4824.45305 | -723404.587568 | -74419500.906911 | 425580499.093089 |
20 | 2025-05-21 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -4616.429703 | -718580.134518 | -74414676.453861 | 425585323.546139 |
pietrektrune supply change
Updated 3 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 3 hours agoAuto-refreshes every 24 hours
...
1498
125KB
4s