MLDZMNOLAS price
    Updated 2025-02-16
    -- select
    -- Hour::date as day,
    -- avg(PRICE) as "Avg price",
    -- min(PRICE) as "Min price",
    -- max(PRICE) as "Max price"

    -- from ethereum.price.ez_prices_hourly
    -- where SYMBOL = 'OLAS'
    -- and Hour >= current_date - 30
    -- group by 1
    -- order by 1 desc

    select
    Hour,
    OPEN,
    HIGH,
    LOW,
    CLOSE
    from ethereum.price.fact_prices_ohlc_hourly
    where ASSET_ID = '28458'
    and Hour >= current_date - 30
    QueryRunArchived: QueryRun has been archived