strawbettyETH price now
Updated 2022-06-16
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with eth_price as (
select date(hour) as date, avg(price ) as price
from ethereum.token_prices_hourly
where date(hour) >= '2022-01-01' and symbol = 'ETH'
group by 1)
select date, origin_address, amount, price,
case
when price >=3260 then 'higher than now'
else 'lower than now' end as high_or_low_now
from ethereum.udm_events, eth_price
where contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' AND from_address = '0x0000000000000000000000000000000000000000' and date = date(block_timestamp)
Run a query to Download Data