BlockTrackerliquidity fee / Block reward copy
    Updated 8 days ago
    -- forked from liquidity fee / Block reward @ https://flipsidecrypto.xyz/studio/queries/121df26f-9b2e-4beb-835a-38b10b9ff0a1

    select
    date_trunc('quarter',day) as month,
    0.5 as "50% line",
    sum(block_rewards_usd) as "Block Reward $",
    sum(liquidity_fees_usd) as "Liquidity Fees $",
    "Liquidity Fees $" / "Block Reward $" as "Ratio"
    from thorchain.defi.fact_daily_earnings
    where month >= '2021-01-01'
    group by 1



    Last run: 8 days ago
    MONTH
    50% line
    Block Reward $
    Liquidity Fees $
    Ratio
    1
    2021-04-01 00:00:00.0000.53841754.149486961969400.1320050.5126304431
    2
    2021-07-01 00:00:00.0000.57510204.655807962162650.878479610.2879616439
    3
    2021-10-01 00:00:00.0000.514834627.67195683938605.950068950.2655008294
    4
    2022-01-01 00:00:00.0000.519284477.42508463454829.883135910.1791508168
    5
    2025-01-01 00:00:00.0000.53082474.4278066214427272.75729454.680419285
    6
    2022-04-01 00:00:00.0000.516868761.69978945009871.972557810.2969910929
    7
    2022-07-01 00:00:00.0000.57458169.441483191451101.093656640.1945653159
    8
    2022-10-01 00:00:00.0000.54511064.28930031277799.926887280.2832590814
    9
    2023-07-01 00:00:00.0000.53632638.684205273450814.68818890.9499471288
    10
    2023-10-01 00:00:00.0000.510853391.68718876606351.582964830.608690055
    11
    2024-01-01 00:00:00.0000.514858502.53016818574313.58698080.5770644498
    12
    2024-04-01 00:00:00.0000.513640908.46165575377747.066190470.3942367241
    13
    2024-10-01 00:00:00.0000.512863954.905176410952002.66949150.8513713512
    14
    2023-01-01 00:00:00.0000.54836871.470994721922723.318509150.3975138331
    15
    2023-04-01 00:00:00.0000.53531207.08627241981323.036793730.5610894486
    16
    2024-07-01 00:00:00.0000.59798925.741903326393728.729488950.652492824
    16
    1KB
    1s