amelia-leeUntitled Query
    Updated 2022-10-02
    select
    day::DATE as DATE,
    sum (LIQUIDITY_FEES) as "LIQUIDITY FEES",
    sum (BLOCK_REWARDS) as "BLOCK REWARDS",
    "BLOCK REWARDS" - "LIQUIDITY FEES" as "Fee volume need to offset"
    from flipside_prod_db.thorchain.daily_earnings where day >= '2022-01-01' and LIQUIDITY_FEES > 0 group by DATE
    Run a query to Download Data