keshanwETH Deposit Rate
    Updated 2022-06-13
    -- ibc/65381C5F3FD21442283D56925E62EA524DED8B6927F0FF94E21E0020954C40B5 - WETH.grv
    -- ibc/EA1D43981D5C9A1C4AAEA9C23BB1D4FA126BA9BC7020A25E0AE4AA841EA25DC5 - axlWETH
    with added as (select block_timestamp::date as date, sum(amount/pow(10, decimal)) as amount_added, pool_id
    from osmosis.core.fact_liquidity_provider_actions
    where tx_status='SUCCEEDED'
    and currency in ('ibc/EA1D43981D5C9A1C4AAEA9C23BB1D4FA126BA9BC7020A25E0AE4AA841EA25DC5', 'ibc/65381C5F3FD21442283D56925E62EA524DED8B6927F0FF94E21E0020954C40B5')
    and action='pool_joined'
    group by date, pool_id),
    removed as (select block_timestamp::date as date, sum(amount/pow(10, decimal)) as amount_removed, pool_id
    from osmosis.core.fact_liquidity_provider_actions
    where tx_status='SUCCEEDED'
    and currency in ('ibc/EA1D43981D5C9A1C4AAEA9C23BB1D4FA126BA9BC7020A25E0AE4AA841EA25DC5', 'ibc/65381C5F3FD21442283D56925E62EA524DED8B6927F0FF94E21E0020954C40B5')
    and action='pool_exited'
    group by date, pool_id)

    select a.date, amount_added, -1 * amount_removed as amount_removed, (amount_added - amount_removed) as net_weth, sum(net_weth) over (order by a.date), a.pool_id
    from added a left join removed r on a.date=r.date and a.pool_id=r.pool_id
    Run a query to Download Data