efalkendailyAggEarnings
    Updated 2025-02-28
    SELECT
    day,
    liquidity_fees,
    block_rewards,
    total_earnings,
    earnings_to_nodes,
    earnings_to_pools,
    earnings_to_pools_usd,
    FROM thorchain.defi.fact_daily_earnings
    WHERE DAY > '2024-02-22'
    Last run: about 2 months ago
    DAY
    LIQUIDITY_FEES
    BLOCK_REWARDS
    TOTAL_EARNINGS
    EARNINGS_TO_NODES
    EARNINGS_TO_POOLS
    EARNINGS_TO_POOLS_USD
    1
    2025-02-27 00:00:00.000441659.322712791.96759159441661.29030438222555.78351003219105.50679435287798.395382422
    2
    2025-02-25 00:00:00.000455802.136927321.98896826455804.12589558244057.87312481211746.25277077324615.375868447
    3
    2025-02-24 00:00:00.000463259.398977491.984262463261.38323949259200.08704735204061.29619214291242.861481798
    4
    2025-02-22 00:00:00.000167241.688145842.00412904167243.6922748896337.7697948870905.92248101152.175085743
    5
    2025-02-21 00:00:00.00049014.811635671.9673058649016.7789415328672.4336804320344.345261125653.332391161
    6
    2025-02-19 00:00:00.00040622.372696151.8483536140624.2210497621847.3987898518776.8222599123021.528002183
    7
    2025-02-18 00:00:00.00051268.684400732.0070540351270.6914547627557.2691819523713.4222728129644.21334648
    8
    2025-02-17 00:00:00.00040325.564497752.007890240327.5723879521492.9709775518834.601410423933.00482325
    9
    2025-02-16 00:00:00.00036014.689340472.0110794836016.7004199518635.1896929217381.5107270322927.497717501
    10
    2025-02-14 00:00:00.00037439.261525721.9835004637441.2450261819014.6989016918426.5461244926347.293027744
    11
    2025-02-13 00:00:00.00055084.207703411.9855158455086.1932192527311.3408678127774.8523514442071.362078447
    12
    2025-02-12 00:00:00.00033550.060313222.004760633552.0650738217366.7513062616185.3137675624523.788146616
    13
    2025-02-11 00:00:00.00048560.351581159061.0932620757621.4448432230206.3635433927415.0812998338701.301728989
    14
    2025-02-10 00:00:00.00049113.7737053822688.9745311571802.7482365338406.3033840933396.4448524448449.456415639
    15
    2025-02-08 00:00:00.00033373.9352817625424.0165490658797.9518308232936.4479160125861.5039148133613.370103581
    16
    2025-02-06 00:00:00.00057883.4085459425298.9446070983182.3531530346910.7690224136271.5841306247691.260985229
    17
    2025-02-04 00:00:00.00072448.2615422425490.4813409197938.7428831555692.2633771642246.4795059960279.920916183
    18
    2025-02-03 00:00:00.000153755.8282823825507.07779412179262.9060765104339.7430315774923.16304493116605.514537233
    19
    2025-02-01 00:00:00.000262517.6096117424793.29300377287310.90261551142157.32526016145153.57735535177661.729489088
    20
    2025-01-31 00:00:00.00039143.3568936524905.9711533964049.3280470423357.6661427440691.661904389319.835617294
    ...
    371
    43KB
    1s