shadilAverage Price of tokens per month
Updated 2022-09-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select case when token_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' then 'stETH'
when token_address = '0xae78736cd615f374d3085123a210448e74fc6393' then 'rETH'
when token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' then 'ETH'
when token_address = '0xe95a203b1a91a908f9b9ce46459d101078c2c3cb' then 'aETH' end token_name,
avg(price) token_price,
date_trunc('month', hour) as date_time
from ethereum.core.fact_hourly_token_prices
where (token_address = '0xae78736cd615f374d3085123a210448e74fc6393'
or token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
or token_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
or token_address = '0xe95a203b1a91a908f9b9ce46459d101078c2c3cb')
group by date_time, token_name
order by date_time
Run a query to Download Data