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-05-24 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -1663.608977 | -726774.960887 | -74422871.28023 | 425577128.71977 |
2 | 2025-05-23 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -1706.764342 | -725111.35191 | -74421207.671253 | 425578792.328747 |
3 | 2025-05-22 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -4824.45305 | -723404.587568 | -74419500.906911 | 425580499.093089 |
4 | 2025-05-21 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -4616.429703 | -718580.134518 | -74414676.453861 | 425585323.546139 |
5 | 2025-05-20 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -1935.486132 | -713963.704815 | -74410060.024158 | 425589939.975842 |
6 | 2025-05-19 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -3279.703353 | -712028.218683 | -74408124.538026 | 425591875.461974 |
7 | 2025-05-18 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -2111.332159 | -708748.51533 | -74404844.834673 | 425595155.165327 |
8 | 2025-05-17 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -1725.961541 | -706637.183171 | -74402733.502514 | 425597266.497486 |
9 | 2025-05-16 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -1753.846589 | -704911.22163 | -74401007.540973 | 425598992.459027 |
10 | 2025-05-15 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -1449.656694 | -703157.375041 | -74399253.694384 | 425600746.305616 |
11 | 2025-05-14 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -1605.922649 | -701707.718347 | -74397804.03769 | 425602195.96231 |
12 | 2025-05-13 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -2458.51052 | -700101.795698 | -74396198.115041 | 425603801.884959 |
13 | 2025-05-12 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -2754.931111 | -697643.285178 | -74393739.604521 | 425606260.395479 |
14 | 2025-05-11 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -2325.646019 | -694888.354067 | -74390984.67341 | 425609015.32659 |
15 | 2025-05-10 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -2012.957077 | -692562.708048 | -74388659.027391 | 425611340.972609 |
16 | 2025-05-09 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -2213.532553 | -690549.750971 | -74386646.070314 | 425613353.929686 |
17 | 2025-05-08 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -1962.091258 | -688336.218418 | -74384432.537761 | 425615567.462239 |
18 | 2025-05-07 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -973.634172 | -686374.12716 | -74382470.446503 | 425617529.553497 |
19 | 2025-05-06 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -2323.396345 | -685400.492988 | -74381496.812331 | 425618503.187669 |
20 | 2025-05-05 00:00:00.000 | 0 | 226155.680657 | 0 | -60000000 | 0 | -13922252 | -1076.48661 | -683077.096643 | -74379173.415986 | 425620826.584014 |
pietrektrune supply change
Updated 19 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 19 hours agoAuto-refreshes every 24 hours
...
1482
123KB
14s