DATE | USD_PRICE_OF_RUNE | TOTAL_POOLED_RUNE | USD_NONRUNE_TVL | |
|---|---|---|---|---|
1 | 2024-01-29 00:00:00.000 | 4.288086 | 33320972.2151229 | 142883194.462057 |
2 | 2024-01-28 00:00:00.000 | 4.277086 | 33378507.1726661 | 142762745.72911 |
3 | 2024-01-27 00:00:00.000 | 4.302907 | 34069391.0713602 | 146597421.326693 |
4 | 2024-01-26 00:00:00.000 | 4.330536 | 34144032.5655087 | 147861962.210108 |
5 | 2024-01-25 00:00:00.000 | 4.028432 | 34722929.6731665 | 139878961.029133 |
6 | 2024-01-24 00:00:00.000 | 4.073361 | 34500773.3949207 | 140534104.816707 |
7 | 2024-01-23 00:00:00.000 | 3.970453 | 34721409.0854106 | 137859722.867396 |
8 | 2024-01-22 00:00:00.000 | 3.947041 | 35175645.8430206 | 138839716.343882 |
9 | 2024-01-21 00:00:00.000 | 4.212215 | 35093761.8780055 | 147822470.188963 |
10 | 2024-01-20 00:00:00.000 | 4.115493 | 35205723.8603016 | 144888910.107004 |
11 | 2024-01-19 00:00:00.000 | 4.196851 | 35304898.1826733 | 148169397.242851 |
12 | 2024-01-18 00:00:00.000 | 4.055993 | 35615436.0879301 | 144455959.464592 |
13 | 2024-01-17 00:00:00.000 | 4.292347 | 35552632.0907663 | 152604233.696904 |
14 | 2024-01-16 00:00:00.000 | 4.73003 | 34251291.2154718 | 162009634.987918 |
15 | 2024-01-15 00:00:00.000 | 4.565006 | 34840740.9327028 | 159048191.402234 |
16 | 2024-01-14 00:00:00.000 | 4.447267 | 34775044.3968359 | 154653907.369583 |
17 | 2024-01-13 00:00:00.000 | 4.590662 | 33989679.0193891 | 156035127.866507 |
18 | 2024-01-12 00:00:00.000 | 4.562328 | 34348294.4417388 | 156708185.483789 |
19 | 2024-01-11 00:00:00.000 | 5.11515 | 33392354.279226 | 170806900.991383 |
20 | 2024-01-10 00:00:00.000 | 5.037467 | 33398316.2633756 | 168242916.032318 |
Multipartite(Auto-updating) USD Non-RUNE Total Value Locked (at end of each day)
Updated 2024-01-29
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
›
⌄
--Since the block_pool_depths table reflects when depths have changed,
--it is more accurately representative to get end-of-day values
--rather than start-of-day values.
WITH
pricerefs AS
(
SELECT DISTINCT DATE(block_timestamp) AS date,
rune_e8 AS rune_e8_ref,
asset_e8 AS asset_e8_ref
FROM thorchain.defi.fact_block_pool_depths
WHERE pool_name = 'BNB.BUSD-BD1'
--At present BNB.BUSD is hard-coded as the reference pool,
--but other approaches are to check the deepest USD stablecoin pool
--or to take a median of the stablecoin pools.
QUALIFY block_timestamp = MAX(block_timestamp) OVER(PARTITION BY date)
),
pools_rune AS
(
SELECT DATE(block_timestamp) AS date, pool_name, rune_e8
FROM thorchain.defi.fact_block_pool_depths
WHERE (pool_name LIKE '%.%') AND (pool_name NOT LIKE 'THOR.%') AND (asset_e8 > 0) AND (rune_e8 > 0)
QUALIFY block_timestamp = MAX(block_timestamp) OVER(PARTITION BY date, pool_name)
),
pooled_rune AS
(
SELECT date, SUM(rune_e8) AS pooled_rune_e8
FROM pools_rune
GROUP BY date
)
SELECT pooled_rune.date,
asset_e8_ref / rune_e8_ref AS USD_price_of_RUNE,
POWER(10,-8) * pooled_rune_e8 AS total_pooled_RUNE,
Last run: about 1 year agoAuto-refreshes every 24 hours
...
1001
69KB
180s