adriaparcerisaswETH Deposit Rate on Osmosis 2
Updated 2022-06-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
--Calculate the deposit rate of wETH over time on Osmosis.
--How does this compare to SushiSwap and Thorchain now?
--How does the wETH deposit rate compare to when wETH was a relatively new asset (or the protocol was relatively new)?
--Is Osmosis growing at a faster rate than Thorchain and Sushiswap?
SELECT
case when block_timestamp>='2022-03-01' then 'Post-launch period'
else 'New asset period' end as period,
avg(amount/pow(10,decimal)) as avg_deposit_rate
from osmosis.core.fact_liquidity_provider_actions x
join osmosis.core.dim_labels y on x.currency = y.address
and project_name like '%WETH%'
group by 1
order by 1 asc
Run a query to Download Data