flipside

    RUNE Earnings Distribution
    pietrektRUNE Earnings Distribution
    Updated 4 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 4 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-05-21 00:00:00.00020902.7929641238815.55945562222.537.497782999.99043281699.99479140320874.9791704438763.91047435413047.3248006424228.3034810417827.654369814535.60699331381791304.7023521151266851.994521233058156.696873107805884.585879125252272.110994
    2
    		2025-05-20 00:00:00.00038838.6192164669871.50298404422.537.03948632799.99485075299.99494825538709.7239533169639.61766099424371.8410425943845.46099960914337.8829107225794.15666138581752489.1428965151266903.643502233019392.786398107781656.282398125237736.504001
    3
    		2025-05-19 00:00:00.00065713.9654728117601.33280656822.537.3619195599.996956699.99494132565594.06799715117386.76497710941086.8650824573528.81628395624507.202914743857.94869315381682617.6399124151267135.528825232949753.168737107737810.821398125211942.347339
    4
    		2025-05-18 00:00:00.00042428.5764506880345.02977940322.537.36808033399.99528641899.99487075142226.6457670579962.64299797326447.3588549850082.13832627615779.2869120729880.50467169781565016.3071058151267350.096654232832366.40376107664282.005114125168084.398646
    5
    		2025-05-17 00:00:00.00034667.3286525858441.5418967722.536.21467698999.99423121299.99491296434519.2333788258191.88562146522018.2045116637117.88220994212501.0288671621074.00341152381484671.2773264151267732.483436232752403.760762107614199.866788125138203.893975
    6
    		2025-05-16 00:00:00.00035425.7224078362886.48221388422.537.93460179699.99435470399.99500904935076.9339934262267.32542812621770.638760638646.46347764413306.2952328223620.86195048181426229.7354297151267982.139711232694211.875141107577081.984578125117129.890563
    7
    		2025-05-15 00:00:00.00029163.9682375355084.06697148222.538.61736886999.99314269399.99498446228993.135726154761.40342227417796.7495560933613.99026490611196.3861700121147.41315736881363343.2532158151268601.296497232631944.549713107538435.5211125093509.028613
    8
    		2025-05-14 00:00:00.00032337.533864263133.25707789422.539.4391417299.99381561999.99508313332118.4527783262705.54040123419451.2106688137975.01345610512667.2421095124730.52694512981308259.1862443151268923.960046232577183.14629107504821.530835125072361.615455
    9
    		2025-05-13 00:00:00.00049608.11957189102738.55799501722.539.49692231299.99596856499.99524485349170.21148865101831.64909795129749.4912562861611.28176459819420.7202323740220.36733335481245125.9291664151269351.676723232514477.605889107466846.517379125047631.08851
    10
    		2025-05-12 00:00:00.00055751.63520435107699.56955626722.538.50997706499.9964127999.99529411955098.62203146106438.0955676233880.1553243765448.80937679521218.4667070940989.28619082581142387.3711714151270258.58562232412645.956791107405235.235615125007410.721177
    11
    		2025-05-11 00:00:00.00047060.3005452882627.26865718822.536.08097714799.99575031499.99529576446512.9204128181666.1926602429730.6042284652200.23235002216782.3161843529465.96031021881034687.8016151151271520.059609232306207.861224107339786.426238124966421.434986
    12
    		2025-05-10 00:00:00.00042263.1663785473594.23143333222.535.32315566199.99526797199.99534393340259.1419145470104.55820627926038.3425481645341.41598540314220.7993663824763.14222087680952060.5329579151272481.135606232224541.668563107287586.193888124936955.474676
    13
    		2025-05-09 00:00:00.00056621.6599637784588.12444422622.532.75513308899.99646790899.99534903444270.6502076666136.727029729769.7398132244473.55407107814500.9103944421663.17295862380878466.3015246151275970.808833232154437.110357107242244.777902124912192.332455
    14
    		2025-05-08 00:00:00.00057486.8448713379211.32531633622.531.75718523299.99652106499.99543128639241.8258522354071.44957329626779.7265281136899.87917494112462.0993241217171.57039835580793878.1770804151294422.206247232088300.383327107197771.223831124890529.159496
    15
    		2025-05-07 00:00:00.00019947.473040424853.94795966222.531.4100655899.98997467399.99544048919472.6858254524262.37745304313356.3024374916641.5487837766116.383387967620.82866926680714666.851764151319562.08199232034228.933754107160871.344656124873357.589098
    16
    		2025-05-06 00:00:00.00048390.888493261577.78488094522.531.4098335499.99586716199.99565661846467.9278863859130.80243717531872.4290875940557.91582054914595.4987987918572.88661662680689812.9038044151320153.652497232009966.556301107144229.795873124865736.760429
    17
    		2025-05-05 00:00:00.00028575.5453615835735.31338933622.531.91452788899.99300149899.99562391121529.7350088926924.13453520614658.6217252818331.4241103836871.113283618592.71042482280628235.1189234151322600.634941231950835.753864107103671.880052124847163.873812
    18
    		2025-05-04 00:00:00.00038909.7408221248950.1263064081.966108422.47344889632.25631092899.99494725799.99554329438911.7069305448952.59975530426360.225755533162.29697072712551.4811750415790.30278457880592499.8055341151331411.813795231923911.619329107085340.455942124838571.163387
    19
    		2025-05-03 00:00:00.00030545.5505974638738.2824853461.963039942.48955393631.833468799.99357381499.99542599730547.513637438740.77203928220823.1804449726408.2404979689724.3331924312332.53154131480543549.6792277151331409.340346231874959.019573107052178.158971124822780.860603
    20
    		2025-05-02 00:00:00.00055052.3231738472137.6301993061.984234742.60003545135.79218099599.99639585999.99542096355054.3074085872140.23023475635349.1700554846319.66845908319705.137353125820.56177567380504811.3967423151331406.850792231836218.247534107025769.918473124810448.329061
    ...
    1479
    438KB
    3s