headitmanagerEthereum price in 2022
Updated 2022-06-27
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with algo_price as (select price_usd,block_hour::date from algorand.prices_swap
where asset_id=0 and hour(block_hour)=0 and block_hour::date>'2022-01-01')
, eth_price as (select price,hour from ethereum_core.fact_hourly_token_prices
where token_address is null and hour(hour)=0 and hour::date>'2022-01-01')
, algo_transactions as (select count(*), block_timestamp::date from algorand.transactions
where block_timestamp::date>'2022-01-01'
group by block_timestamp::date )
, algo_transfer as (select count(*), block_timestamp::date from algorand.transfers
where block_timestamp::date>'2022-01-01'
group by block_timestamp::date )
select * from eth_price
Run a query to Download Data