kellenTHORChain LP Revenue
    Updated 2023-01-10

    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