bachi7. Thorchain - Weekly APY
Updated 2021-11-02
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 total_pool_rewards_tbl AS (
/*SELECT
date(block_timestamp) AS day,
SUM(bond_e8) AS bond_earnings
FROM thorchain.rewards_events*/
SELECT
date(day) AS day,
SUM(bonding_earnings) AS bond_earnings
FROM thorchain.block_rewards
GROUP BY 1
),
tvl_pool AS (
SELECT
day,
SUM(tvl) AS tvl
FROM (
SELECT
date(block_timestamp) AS day,
pool_name,
AVG(rune_e8) AS tvl
FROM thorchain.block_pool_depths
GROUP BY 1,2
)
GROUP BY 1
),
daily_apy_nodeops AS (
SELECT
total_pool_rewards_tbl.day,
bond_earnings,
tvl,
bond_earnings / tvl * 100 AS daily_APY_nodeops
FROM total_pool_rewards_tbl
LEFT JOIN tvl_pool
ON total_pool_rewards_tbl.day = tvl_pool.day
Run a query to Download Data