flipside

    Copy of Asset Prices on THORChain Post-November Halt
    binhachonCopy of Asset Prices on THORChain Post-November Halt
    Updated 2022-06-04

    SELECT SPLIT(pool_name, '-')[0]::string AS clean_pool_name, *
    FROM thorchain.prices
    WHERE 1=1
    AND block_timestamp >= '2021-11-18 18:00:00'
    AND block_timestamp <= '2021-11-18 20:00:00'
    ORDER BY block_timestamp, pool_name
    -- LIMIT 50000