BlockTrackerpool balance
    Updated 4 days ago
    select
    day,
    EARNINGS_TO_POOLS_USD,
    sum(EARNINGS_TO_POOLS_USD) over (order by day) as cum_lp_earning
    from thorchain.defi.fact_daily_earnings
    where day >= '2024-01-01'
    order by day desc
    Last run: 4 days ago
    DAY
    EARNINGS_TO_POOLS_USD
    CUM_LP_EARNING
    1
    2025-06-13 00:00:00.00019548.53378315353654256.4265618
    2
    2025-06-12 00:00:00.00034791.01214054953634707.8927786
    3
    2025-06-11 00:00:00.00031737.16414697553599916.8806381
    4
    2025-06-10 00:00:00.00016757.87373810753568179.7164911
    5
    2025-06-09 00:00:00.00026767.19759823553551421.842753
    6
    2025-06-08 00:00:00.00011183.65389323253524654.6451548
    7
    2025-06-07 00:00:00.00011681.92947132553513470.9912615
    8
    2025-06-06 00:00:00.00026966.76524573453501789.0617902
    9
    2025-06-05 00:00:00.00016578.29722876253474822.2965445
    10
    2025-06-04 00:00:00.00010239.49878220153458243.9993157
    11
    2025-06-03 00:00:00.00028013.60617987353448004.5005335
    12
    2025-06-02 00:00:00.00021645.26370758553419990.8943536
    13
    2025-06-01 00:00:00.00025912.83261684153398345.6306461
    14
    2025-05-31 00:00:00.00033535.2381413953372432.7980292
    15
    2025-05-30 00:00:00.00025473.23944320653338897.5598878
    16
    2025-05-29 00:00:00.00025219.27553402453313424.3204446
    17
    2025-05-28 00:00:00.00032246.17676334953288205.0449106
    18
    2025-05-27 00:00:00.00031687.20558152753255958.8681472
    19
    2025-05-26 00:00:00.00027147.86216272753224271.6625657
    20
    2025-05-25 00:00:00.00030907.36005320153197123.800403
    ...
    530
    32KB
    1s