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