nitsPrices of ETH Derivatives
Updated 2022-09-14
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT date(hour) as day,contract_name, avg(price) as avg_price from
(SELECT *, case when token_address ilike '0xE95A203B1a91a908F9B9CE46459d101078c2c3cb' then 'aETH'
when token_address ilike '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' then 'stETH'
when token_address ilike '0xae78736cd615f374d3085123a210448e74fc6393' then 'rETH' end as contract_name
from ethereum.core.fact_hourly_token_prices
where token_address ilike '0xE95A203B1a91a908F9B9CE46459d101078c2c3cb'
or token_address ilike '0xae78736cd615f374d3085123a210448e74fc6393'
or token_address ilike '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' )
where day >= CURRENT_DATE -180
GROUP by 1 ,2
-- limit 100
Run a query to Download Data