drone-mostafaUntitled Query
    Updated 2022-06-15
    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