CryptoIcicleOsmo-9.wETH & wBTC On- and Off- Ramps - WBTC
Updated 2022-06-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
-- Payout 73.53 OSMO
-- Grand Prize 220.59 OSMO
-- Level Intermediate
-- Q9. On the Osmosis Frontier, there are pools for wETH and wBTC.
-- How do users respond and change their position in these pools in response to governance proposals involving extra incentives for these pools?
-- Do their deposits and withdrawals of wBTC and wETH onto Osmosis change as well?
-- Hint: Find the addresses for wBTC and wETH in the asset metadata table.
with txns as (
select
l.label,
a.amount/pow(10, a.decimal) as amount_actual,
a.*
from osmosis.core.fact_liquidity_provider_actions a
join osmosis.core.dim_labels l on a.currency = l.address
where label in ('Wrapped Ether','Wrapped Bitcoin')
)
select
block_timestamp::date as date,
action as type,
count(distinct tx_id) as n_txns,
sum(amount_actual) as amount
from txns
where label = 'Wrapped Bitcoin'
group by date, type
Run a query to Download Data