Nige7777cWBTC-cWBTC2
Updated 2023-03-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select
distinct date_trunc('day', block_hour) as date,
contract_name,
avg(borrows_usd) OVER (PARTITION BY date, ctoken_address ORDER BY block_hour RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) as Borrow,
avg(supply_usd) OVER (PARTITION BY date, ctoken_address ORDER BY block_hour RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) as Supply,
avg(supply_usd - borrows_usd) OVER (PARTITION BY date, ctoken_address ORDER BY block_hour RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) as TVL,
avg(reserves_usd) OVER (PARTITION BY date, ctoken_address ORDER BY block_hour RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) as Reserves,
last_value(comp_apy_supply) OVER(PARTITION by date, ctoken_address ORDER BY block_hour RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) as Supply_APY,
last_value(comp_apy_borrow) OVER(PARTITION by date, ctoken_address ORDER BY block_hour RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) as Borrow_APY
from compound.market_stats
where
underlying_symbol = 'WBTC'
--and date >= '2021-03-16T00:00:00Z'
--'0xc11b1268c1a384e55c48c2391d8d480264a3a7f4' -- 'cWBTC'
--'0xccf4429db6322d5c611ee964527d42e5d685dd6a' --'cWBTC2'
Run a query to Download Data