wollok-ethToken Test Query
    Updated 2024-08-29
    -- SELECT *
    -- FROM ethereum.price.dim_asset_metadata -- ethereum.core.dim_contracts
    -- WHERE token_address = lower('0x64d91f12ece7362f91a6f8e7940cd55f05060b92') -- $ASH (Burn)
    -- Result: asset_id for ASH is 11566

    SELECT hour, open, low, high, close
    FROM ethereum.price.fact_prices_ohlc_hourly
    WHERE asset_id = 11566
    -- AND inserted_timestamp::DATE >= CURRENT_DATE - 30
    ORDER BY hour DESC



    QueryRunArchived: QueryRun has been archived