Multipartite2022-12-14 RUNE TVL ratio
Updated 2022-12-14
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
lockedaddresses AS
(
SELECT
'thor1g98cy3n9mmjrpn0sxmn63lztelera37n8n67c0' AS pool_module,
'thor17gw75axcnr8747pkanye45pnrwk7p9c3cqncsv' AS bond_module
),
--Treasury addresses are available to go into LPs at will, so don't count as 'locked' in the same sense(s).
balance_changes AS
(
SELECT block_timestamp,
(CASE WHEN to_address = lockedaddresses.pool_module THEN CAST(POWER(10,-8) * amount_e8 AS DECIMAL(28,8)) ELSE 0 END)
- (CASE WHEN from_address = lockedaddresses.pool_module THEN CAST(POWER(10,-8) * amount_e8 AS DECIMAL(28,8)) ELSE 0 END)
AS pool,
(CASE WHEN to_address = lockedaddresses.bond_module THEN CAST(POWER(10,-8) * amount_e8 AS DECIMAL(28,8)) ELSE 0 END)
- (CASE WHEN from_address = lockedaddresses.bond_module THEN CAST(POWER(10,-8) * amount_e8 AS DECIMAL(28,8)) ELSE 0 END)
AS bond
FROM thorchain.core.fact_transfer_events, lockedaddresses
WHERE ((SELECT CONCAT(*) FROM lockedaddresses) LIKE CONCAT('%', to_address, '%'))
OR ((SELECT CONCAT(*) FROM lockedaddresses) LIKE CONCAT('%', from_address, '%'))
),
intermediatetable3 AS (
SELECT DATE(block_timestamp) AS date,
SUM(pool) AS pool,
SUM(bond) as bond
FROM balance_changes
GROUP BY date
HAVING date IS NOT NULL
),
intermediatetable AS (
SELECT DISTINCT date,
SUM(pool) OVER(ORDER BY date ASC) AS pool_balance,
SUM(bond) OVER(ORDER BY date ASC) AS bond_balance
Run a query to Download Data