drone-mostafaUntitled Query
Updated 2022-06-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with eth_price as ( select date(hour) as date, avg(price ) as price
from ethereum.core.fact_hourly_token_prices where date(hour) >= current_date - 180 and symbol = 'WETH' group by 1)
select date, case
when price >=2000
then 'higher than 2000'
else 'lower than 2000'
end as high_or_low_now,
count(*) as count
from ethereum.udm_events, eth_price
where contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
AND from_address = '0x0000000000000000000000000000000000000000'
and date = date(block_timestamp)
group by 1, 2
Run a query to Download Data