KaskoazulBANK Index vs SP500 performance
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
24
25
26
27
28
29
30
31
32
33
›
⌄
WITH BEDSP5500 AS (
SELECT
hour::date as fecha,
avg(price) as 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) as Price,
'SP500' as Index
FROM
terra.oracle_prices
WHERE
fecha >= '2021-07-21'
AND symbol = 'mSPY'
GROUP BY 1, 3
ORDER BY 1
)
SELECT
fecha,
Price,
Index
FROM
BEDSP5500
WHERE fecha = '2021-07-21' OR fecha = '2022-03-06'
ORDER BY 3
Run a query to Download Data