KaskoazulBANK Index vs SP500
Updated 2022-03-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
SELECT
hour::date as fecha,
avg(price),
'BED' as Index
FROM
ethereum.token_prices_hourly
WHERE
fecha >= '2021-07-21'
AND token_address IN ('0x2af1df3ab0ab157e1e2ad8f88a7d04fbea0c7dc6')
GROUP BY 1,3
UNION SELECT
block_timestamp::date as fecha,
avg(price_usd),
'SP500' as Index
FROM
terra.oracle_prices
WHERE
fecha >= '2021-07-21'
AND symbol = 'mSPY'
GROUP BY 1, 3
Run a query to Download Data