strawbettyETH price now
    Updated 2022-06-16
    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