piper$UST price peg
Updated 2022-05-12
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
›
⌄
⌄
/*
Twitter: @der_piper
Discrod: piper#6707
ThorChain - IL Protection Over Time
Q88. With highly volatile prices recently, more IL protection has
been paid out on THORChain. How do recent days or weeks compare to
historical amounts?
*/
SELECT
DATE_TRUNC('HOUR', block_timestamp) AS hour,
AVG(price_usd) AS usd_price
FROM
terra.oracle_prices
WHERE
symbol = 'UST'
AND
block_timestamp BETWEEN '2022-01-01' AND '2022-05-12'
GROUP BY hour
ORDER BY hour
/* The End! */
Run a query to Download Data