CryptoLionAPY and Comp Speed
Updated 2021-04-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
SELECT
date_trunc('day',block_hour) as day,
avg(supply_apy) * 100 as apy,
avg(comp_apy_supply) * 100 as comp,
underlying_symbol as symbol
FROM compound.market_stats
WHERE
block_hour >= getdate() - interval '31 days'
GROUP BY date_trunc('day',block_hour), symbol
ORDER BY 1
-- SELECT *
-- FROM compound.deposits
-- WHERE supplied_base_asset_usd > 100000
-- LIMIT 10
-- SELECT *
-- FROM ethereum.udm_events
-- WHERE
-- amount_usd > 100000
-- AND tx_id = '0x18a27d7dde47b09ea9293afe8c111d660f52afaed228a7652d8a3d2a7667ed98'
Run a query to Download Data