spacebar2024-03-09 02:24 PM
    Updated 2024-03-09
    select date_trunc('day',hour) as date,AVG(price) as price
    from crosschain.price.ez_prices_hourly
    where blockchain = 'ethereum'
    and token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
    and hour >= TIMESTAMP '2024-02-29'
    group by 1
    ;

    QueryRunArchived: QueryRun has been archived