pietrektSavers yield
    Updated 2025-05-08
    with
    saveryield AS (
    SELECT
    to_date(block_timestamp) as day,
    REPLACE(pool_name, '.', '/') as pool_name,
    sum(saver_e8) / POW(10, 8) as yield
    from
    thorchain.defi.fact_rewards_event_entries
    where
    saver_e8 > 0
    and block_timestamp is not null
    group by
    day,
    pool_name
    order by
    day DESC
    ),
    yieldcumulative AS (
    SELECT
    day,
    pool_name as saver_pool,
    yield,
    SUM(yield) OVER (
    PARTITION BY
    pool_name
    ORDER BY
    day ASC
    ) AS cumulative_yield
    from
    saveryield
    ORDER BY
    day DESC
    ),
    prices AS (
    SELECT
    Last run: 13 days ago
    DAY
    SAVER_POOL
    YIELD
    YIELD_USD
    CUMULATIVE_YIELD
    CUMULATIVE_YIELD_USD
    TOTAL_CUMULATIVE_YIELD_USD
    1
    2025-01-31 00:00:00.000GAIA/ATOM11.5481811772.33522638510636.6816454966625.7970402763101133.78988753
    2
    2025-01-31 00:00:00.000BCH/BCH0.23369862101.090405714401.20209886173546.9509713553101133.78988753
    3
    2025-01-31 00:00:00.000Stablecoin994.82458878994.8118227661155785.841153141155772.30039313101133.78988753
    4
    2025-01-31 00:00:00.000AVAX/AVAX2.87095225100.2070973374895.88654181170884.9665630233101133.78988753
    5
    2025-01-31 00:00:00.000ETH/ETH7e-80.0002315144907463.907308391534303.774919773101133.78988753
    6
    2025-01-30 00:00:00.000AVAX/AVAX4.97412577168.4200553694893.01558956165673.7273286053047096.68940035
    7
    2025-01-30 00:00:00.000Stablecoin2298.886809162296.6078932981154791.016564361153933.060201213047096.68940035
    8
    2025-01-30 00:00:00.000BCH/BCH0.31302447134.29538351400.96840024172025.5451133113047096.68940035
    9
    2025-01-30 00:00:00.000ETH/ETH0.0075486124.262186222463.907308321491056.698403333047096.68940035
    10
    2025-01-30 00:00:00.000GAIA/ATOM17.17037038104.08371367410625.1334643264407.658353893047096.68940035
    11
    2025-01-29 00:00:00.000GAIA/ATOM9.308689954.12809538210607.9630939461683.0987313681540390.62202063
    12
    2025-01-29 00:00:00.000BCH/BCH0.1582817365.481057983400.65537577165750.8917289171540390.62202063
    13
    2025-01-29 00:00:00.000AVAX/AVAX2.9775170197.7452415844888.04146379160463.4976539121540390.62202063
    14
    2025-01-29 00:00:00.000Stablecoin1512.411160941512.3381605961152492.12975521152493.133906431540390.62202063
    15
    2025-01-28 00:00:00.000BCH/BCH0.183207577.702681846400.49709404169860.3947903643016701.97025355
    16
    2025-01-28 00:00:00.000AVAX/AVAX2.9255823898.1822460774885.06394678163942.247466933016701.97025355
    17
    2025-01-28 00:00:00.000ETH/ETH0.0312720599.07455068463.899759711469704.104899293016701.97025355
    18
    2025-01-28 00:00:00.000GAIA/ATOM6.5573677538.49491346310598.6544040462219.2165606583016701.97025355
    19
    2025-01-28 00:00:00.000Stablecoin992.95816798992.9349475371150979.718594261150976.006536313016701.97025355
    20
    2025-01-27 00:00:00.000BNB/BNB0.0234437115.475761095432.6100796285576.397225213358383.29316581
    ...
    6905
    742KB
    9s