flipside

    Rewards_Incentive_Pendulum
    sebateau22-AHRewards_Incentive_Pendulum
    Updated 2025-02-26
    SELECT
    day,
    liquidity_fees_usd,
    total_earnings_usd,
    earnings_to_pools_usd,
    earnings_to_nodes_usd,
    earnings_to_nodes_usd/(total_earnings_usd) as ratio_rewards_bonds,
    SUM(earnings_to_pools_usd) OVER (ORDER BY day) AS cum_earnings_to_pools,
    SUM(earnings_to_nodes_usd) OVER (ORDER BY day) AS cumulative_earnings_to_bonds,
    FROM thorchain.defi.fact_daily_earnings
    WHERE day >= '2023-01-01'
    ORDER BY day ASC

    Last run: 2 months ago
    DAY
    LIQUIDITY_FEES_USD
    TOTAL_EARNINGS_USD
    EARNINGS_TO_POOLS_USD
    EARNINGS_TO_NODES_USD
    RATIO_REWARDS_BONDS
    CUM_EARNINGS_TO_POOLS
    CUMULATIVE_EARNINGS_TO_BONDS
    1
    		2023-01-01 00:00:00.0003837.05456888848065.49210943425976.61399025722088.8781191770.459557931325976.61399025722088.878119177
    2
    		2023-01-02 00:00:00.00010474.59720649755945.29784505330405.04230584225540.2555392120.456521933456381.65629609947629.133658388
    3
    		2023-01-03 00:00:00.0008018.914618653586.46354804228690.75734942824895.7061986140.464589460785072.41364552772524.839857003
    4
    		2023-01-04 00:00:00.0007519.81289909653661.00860117629333.42554565224327.5830555240.4533567983114405.8391911896852.422912526
    5
    		2023-01-05 00:00:00.0006668.95547755252756.41125249228859.82682189123896.5844306010.4529607656143265.666013071120749.007343127
    6
    		2023-01-06 00:00:00.0004354.31817739851396.01351618527957.7459278523438.2675883350.4560327929171223.411940921144187.274931463
    7
    		2023-01-07 00:00:00.0005449.8200469652200.63839547728141.4621363224059.1762591580.4608981231199364.87407724168246.45119062
    8
    		2023-01-08 00:00:00.0003984.64824292652932.82967084928039.99406007224892.8356107770.4702721499227404.868137312193139.286801397
    9
    		2023-01-09 00:00:00.0008619.65864587358197.2606620931320.69486799426876.5657940960.4618183998258725.563005306220015.852595493
    10
    		2023-01-10 00:00:00.0005685.52708166255854.30923210329560.91807686426293.3911552390.4707495539288286.48108217246309.243750732
    11
    		2023-01-11 00:00:00.00034647.17523503585232.09538054444070.01889748141162.0764830630.4829410365332356.499979651287471.320233795
    12
    		2023-01-12 00:00:00.00038619.83767555492491.47685052348112.73809080644378.7387597180.4798143599380469.238070457331850.058993512
    13
    		2023-01-13 00:00:00.00061093.178719073118720.55271431162202.87858966256517.6741246490.4760563595442672.116660118388367.733118161
    14
    		2023-01-14 00:00:00.00039295.85513805399963.97131113953196.56501729846767.4062938410.4678426205495868.681677416435135.139412002
    15
    		2023-01-15 00:00:00.00016114.63777616276645.5566499440716.43823518235929.1184147580.4687697498536585.119912598471064.25782676
    16
    		2023-01-16 00:00:00.00020582.57362564681500.00546552343388.35876323938111.6467022850.4676275355579973.478675837509175.904529045
    17
    		2023-01-17 00:00:00.00014086.93459157272535.92281794538837.49384994933698.4289679960.4645757255618810.972525786542874.333497041
    18
    		2023-01-18 00:00:00.00023295.00554351377879.43277945141140.70709083136738.7256886210.4717384857659951.679616617579613.059185661
    19
    		2023-01-19 00:00:00.00011502.75172949567997.77056623235567.72726682632430.0432994060.4769280379695519.406883443612043.102485067
    20
    		2023-01-20 00:00:00.00016834.86327533778011.26466339840391.50848063737619.7561827610.4822349227735910.915364081649662.858667827
    ...
    788
    107KB
    2s