MultipartiteRun Selected error successful (nothing selected, below sections already deleted)
Updated 2022-04-17
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
cointype AS
(
SELECT SPLIT('ETH.USDT', '-')[0] AS coin
--'SPLIT' so that fine with or without the ID, for later.
),
/*
Assumptions:
We have each block's total liquidity fees for each pool. (Check regarding asymmetric add/withdraw liquidity.)
We have each block's total block rewards (bond's rewards_events + pools' rewards_event_entries , negatives cancelling out).
We have each block's full share for bond of block rewards plus liquidity fees. (rewards_events)
Adding the first two and comparing to the third tells us the incentive pendulum ratio in that block.
Perhaps a more straightforward approach:
having the total liquidity fees and total rewards, we know the reward-to-liquidity-fee ratio, and can split each pool's inflow for that block according to it.
Check whether an asymmetric add_liquidity currently generates liquidity fees (of which nodes get their cut) or not:
https://midgard.thorchain.info/v2/debug/block/5112783
No liquidity fee mention in the "add_liquidity".
----
Kellen code:
SELECT DATE_TRUNC('MONTH', day::date) AS month
, COALESCE(liquidity_fee, 0) AS liquidity_fee
, COALESCE(block_rewards, 0) AS block_rewards
FROM thorchain.block_rewards
ORDER BY 1
----
Orion original question (only mentioning swap fees):
"Does anyone have an existing dash for this? "breakdown of yield from block rewards vs swap fees" could be total or by pool. "
How are these calculated?
SELECT day, block_rewards
Run a query to Download Data