BlockTrackerpool balance
    Updated 3 days ago
    select
    day,
    EARNINGS_TO_POOLS_USD,
    sum(EARNINGS_TO_POOLS_USD) over (order by day) as cum_lp_earning
    from maya.defi.fact_daily_earnings
    order by day desc




    Last run: 3 days ago
    DAY
    EARNINGS_TO_POOLS_USD
    CUM_LP_EARNING
    1
    2025-03-14 00:00:00.0005.44564881074268.70816331
    2
    2025-03-13 00:00:00.0001222.8789527581074263.26251452
    3
    2025-03-12 00:00:00.0006775.8595426241073040.38356176
    4
    2025-03-11 00:00:00.0001095.1439928231066264.52401913
    5
    2025-03-10 00:00:00.0004462.7260833241065169.38002631
    6
    2025-03-09 00:00:00.000247.0366957561060706.65394299
    7
    2025-03-08 00:00:00.000229.540595111060459.61724723
    8
    2025-03-07 00:00:00.000451.2507402141060230.07665212
    9
    2025-03-06 00:00:00.0002855.6766818821059778.82591191
    10
    2025-03-05 00:00:00.000948.6969975751056923.14923002
    11
    2025-03-04 00:00:00.0003299.3340771051055974.45223245
    12
    2025-03-03 00:00:00.0003066.6561488851052675.11815534
    13
    2025-03-02 00:00:00.00012907.0163202481049608.46200646
    14
    2025-03-01 00:00:00.0005218.419564031036701.44568621
    15
    2025-02-28 00:00:00.0002825.4338522751031483.02612218
    16
    2025-02-27 00:00:00.0004288.0245736711028657.59226991
    17
    2025-02-26 00:00:00.0003351.3934861721024369.56769624
    18
    2025-02-25 00:00:00.0002353.403175171021018.17421006
    19
    2025-02-24 00:00:00.0003378.9439412411018664.77103489
    20
    2025-02-23 00:00:00.0001039.9268320711015285.82709365
    ...
    728
    41KB
    1s