kellenTHORChain LP Revenue
Updated 2023-01-10Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH t0 AS (
SELECT DATE_TRUNC('month', day)::date AS month
, SUM(liquidity_fees_usd) AS liquidity_fees_usd
, SUM(block_rewards_usd) AS block_rewards_usd
FROM thorchain.core.fact_daily_earnings
WHERE month >= DATE_TRUNC('month', DATEADD('month', -18, CURRENT_DATE))
GROUP BY 1
)
SELECT *
, liquidity_fees_usd + block_rewards_usd AS tot_revenue
, 100 * liquidity_fees_usd / tot_revenue AS pct_revenue_liquidity_fees
, 100 * block_rewards_usd / tot_revenue AS pct_revenue_block_rewards
, SUM(liquidity_fees_usd) OVER (ORDER BY month) AS cumu_liquidity_fees_usd
, SUM(liquidity_fees_usd) OVER (ORDER BY month) AS cumu_liquidity_fees_usd
, SUM(block_rewards_usd) OVER (ORDER BY month) AS cumu_block_rewards_usd
FROM t0
ORDER BY month DESC
Run a query to Download Data