keshanwETH Deposit Rate
Updated 2022-06-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- 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