flipside

    RUNE Earnings Distribution
    pietrektRUNE Earnings Distribution
    Updated 2 hours ago
    WITH rewards AS (SELECT day,
    liquidity_fees, liquidity_fees_usd,
    CASE
    WHEN day > '2025-04-01' AND block_rewards < 0 THEN 2
    ELSE block_rewards
    END AS block_rewards_adjsuted,
    CASE
    WHEN day > '2025-04-01' AND block_rewards_usd < 0 THEN 2.5
    ELSE block_rewards_usd
    END AS block_rewards_usd_adjsuted,

    block_rewards_usd,
    100 * EARNINGS_TO_POOLS/TOTAL_EARNINGS as pool_share_factor_pct,
    liquidity_fees * 100 / (liquidity_fees + block_rewards_adjsuted) AS pct_of_earnings_from_liq_fees,
    avg(pct_of_earnings_from_liq_fees) OVER(ORDER BY day
    ROWS BETWEEN 29 PRECEDING AND CURRENT ROW )
    as pctday_moving_average_30d,
    total_earnings, total_earnings_usd,
    earnings_to_nodes, earnings_to_nodes_usd,
    earnings_to_pools, earnings_to_pools_usd,
    floor(avg_node_count) as node_count, ROW_NUMBER() OVER(ORDER BY day) AS rownum
    from thorchain.defi.fact_daily_earnings),
    cumulative_rewards AS(SELECT day,
    liquidity_fees, liquidity_fees_usd,
    block_rewards_adjsuted as block_rewards,
    block_rewards_usd_adjsuted as block_rewards_usd,
    pool_share_factor_pct,
    pct_of_earnings_from_liq_fees,
    CASE
    WHEN pctday_moving_average_30d > 0 THEN pctday_moving_average_30d
    ELSE 0
    END AS pct_30d_moving_average,
    total_earnings, total_earnings_usd,
    earnings_to_nodes, earnings_to_nodes_usd,
    earnings_to_pools, earnings_to_pools_usd,
    Last run: about 2 hours agoAuto-refreshes every 24 hours
    DAY
    LIQUIDITY_FEES
    LIQUIDITY_FEES_USD
    BLOCK_REWARDS
    BLOCK_REWARDS_USD
    POOL_SHARE_FACTOR_PCT
    PCT_OF_EARNINGS_FROM_LIQ_FEES
    PCT_30D_MOVING_AVERAGE
    TOTAL_EARNINGS
    TOTAL_EARNINGS_USD
    EARNINGS_TO_NODES
    EARNINGS_TO_NODES_USD
    EARNINGS_TO_POOLS
    EARNINGS_TO_POOLS_USD
    LIQUIDITY_FEES_USD_CUMULATIVE
    BLOCK_REWARDS_USD_CUMULATIVE
    TOTAL_EARNINGS_USD_CUMULATIVE
    EARNINGS_TO_NODES_USD_CUMULATIVE
    EARNINGS_TO_POOLS_USD_CUMULATIVE
    1
    		2025-06-10 00:00:00.0009384.8851530716501.86414658522.539.18903691999.97869367899.9939515089354.8014670116448.9666531915688.7448664110002.7750386883666.05660066446.19161450383298433.589734151260535.79245234558969.382184108728039.373676125830930.008508
    2
    		2025-06-09 00:00:00.00040081.4808157669590.95769643122.538.52242353499.99501041399.99452006340020.2915513469484.71861980424603.5053403342717.52102156915416.7862110126767.19759823583281931.7255874151260588.689944234542520.415531108718036.598637125824483.816893
    3
    		2025-06-08 00:00:00.00018064.6138844729467.11260433822.538.06212171699.98892985799.99452864818012.8248105929382.63393895111156.7615066818198.9800457196856.0633039111183.65389323283212340.767891151260694.92902234473035.696911108675319.077616125797716.619295
    4
    		2025-06-07 00:00:00.00019019.8364503630963.66888862922.537.76635395299.98948576899.99477991619000.4498929830932.10821011511824.67273419250.178738797175.7771589811681.92947132583182873.6552866151260779.407686234443653.062972108657120.09757125786532.965402
    5
    		2025-06-06 00:00:00.00045714.0149694972034.1263095222.537.53961224899.99562516599.99501442645587.9585992371835.4922472228474.415709544868.72700148617113.5428897326966.76524573483151909.986398151260810.968364234412720.954762108637869.918831125774851.035931
    6
    		2025-06-05 00:00:00.00028802.0370272244266.57888438622.537.51199617999.99305652999.99482607628755.2396571144194.65482312617968.5752555527616.35759436510786.6644015616578.29722876283079875.8600885151261009.602426234340885.462515108593001.19183125747884.270685
    7
    		2025-06-04 00:00:00.00017159.0748571727771.40490555622.537.13820310599.98834571899.99491976417035.4586258727571.33605330710708.7954015517331.8372711066326.6632243210239.49878220183035609.2812041151261081.526488234296690.807692108565384.834236125731305.973456
    8
    		2025-06-03 00:00:00.00044710.3564641874892.94735741422.537.5952533599.99552696499.99507495744483.9366165274513.67841230827760.0879452746500.07223243516723.8486712528013.60617987383007837.8762985151261281.59534234269119.471638108548052.996964125721066.474674
    9
    		2025-06-02 00:00:00.00033820.9434959758233.95467929622.537.21748590699.99408685499.99505563333777.3273970558158.85512070121206.2553336636513.59141311612571.0720633921645.26370758582932944.9289411151261660.864285234194605.793226108501552.924732125693052.868494
    10
    		2025-06-01 00:00:00.00040871.8087131169974.22444471922.537.07648724199.99510689199.99503853240822.7326103569890.20413004525687.0973627343977.37151320315135.6352476225912.83261684182874710.9742618151261735.963844234136446.938105108465039.333319125671407.604786
    11
    		2025-05-31 00:00:00.00055365.7129518191990.50811421922.536.58092962199.99638778799.99508149855175.2787428991674.10038266634991.6488579358138.86224127620183.6298849633535.2381413982804736.7498171151261819.984158234066556.733975108421061.961806125645494.77217
    12
    		2025-05-30 00:00:00.00040692.2145213167236.31162862722.537.99398922899.99508529699.99504267440576.7002355667045.44576876625159.9931190141572.2063255615416.7071165525473.23944320682712746.2417029151262136.39189233974882.633593108362923.099564125611959.534028
    13
    		2025-05-29 00:00:00.00036125.3155293266523.9939553622.538.9577736999.99446402399.9950494535153.7621355964734.89921266221458.6390391239515.62367863813695.1230964725219.27553402482645509.9300743151262327.25775233907837.187824108321350.893239125586486.294585
    14
    		2025-05-28 00:00:00.00042436.8477765481796.96281968122.539.60547001899.99528733799.99515251142240.4948413181418.49282051625510.9483213749172.31605716716729.5465199432246.17676334982578985.9361189151264116.352492233843102.288611108281835.26956125561267.019051
    15
    		2025-05-27 00:00:00.00041084.7488519680530.13312934622.539.55685594499.99513225199.99511428140868.0950915280105.47053169824701.9615890948418.2649501716166.1335024331687.20558152782497188.9732992151264494.822491233761683.795791108232662.953503125529020.842288
    16
    		2025-05-26 00:00:00.00035332.9665475168074.64255277922.540.02887736399.99433988499.99500962235201.1585969767820.69333777221110.5299919340672.83117504414090.6286050427147.86216272782416658.8401699151264919.485089233681578.325259108184244.688553125497333.636706
    17
    		2025-05-25 00:00:00.00039704.5712622179269.05967258722.539.00765267999.9949630599.99498097439687.0573542679234.09364801424206.0678631848326.73359481315480.9894910830907.36005320182348584.1976171151265173.434304233613757.631921108143571.857378125470185.774543
    18
    		2025-05-24 00:00:00.00033328.8343958762591.44932366922.539.22554635299.9939995599.99495378733286.6984813962512.31820481320229.8091396237991.51985185913056.8893417724520.79835295582269315.1379445151265208.400329233534523.538273108095245.123783125439278.41449
    19
    		2025-05-23 00:00:00.00034666.1938200566210.87958481122.539.87189122999.99423102399.9950116734135.2866378165196.87061409820524.9022788439201.64527806613610.3843589725995.22533603282206723.6886208151265287.531448233472011.220068108057253.603931125414757.616137
    20
    		2025-05-22 00:00:00.00096604.41369868206265.47523414922.539.49395947499.99792974499.99507263196489.06101136206019.17927355458381.7103583124654.04810175638107.3506530681365.13117179882140512.809036151266301.540418233406814.349454108018051.958653125388762.390801
    ...
    1499
    443KB
    4s