PREVIEW / futures_1hour / 2022-02-27
file: by_date/futures_1hour/2022/2022-02-27.parquet size: 20 KB rows: 438
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2022-02-27 18:00:00 | ES | Futures | 4863.63 | 4870.42 | 4809.33 | 4846.95 | 76887.0 |
| 2022-02-27 19:00:00 | ES | Futures | 4846.95 | 4851.19 | 4835.92 | 4848.92 | 26632.0 |
| 2022-02-27 20:00:00 | ES | Futures | 4848.92 | 4880.03 | 4844.12 | 4844.68 | 35415.0 |
| 2022-02-27 21:00:00 | ES | Futures | 4844.97 | 4851.19 | 4817.25 | 4827.15 | 25924.0 |
| 2022-02-27 22:00:00 | ES | Futures | 4826.87 | 4834.5 | 4820.36 | 4826.02 | 16061.0 |
| 2022-02-27 23:00:00 | ES | Futures | 4826.3 | 4846.1 | 4826.3 | 4836.76 | 14788.0 |
| 2022-02-27 18:00:00 | NQ | Futures | 16114.12 | 16114.12 | 15862.27 | 16060.8 | 25073.0 |
| 2022-02-27 19:00:00 | NQ | Futures | 16060.22 | 16069.78 | 16014.14 | 16051.81 | 12858.0 |
| 2022-02-27 20:00:00 | NQ | Futures | 16050.94 | 16176.72 | 16039.35 | 16040.8 | 16853.0 |
| 2022-02-27 21:00:00 | NQ | Futures | 16039.06 | 16070.07 | 15955.01 | 15996.75 | 14787.0 |
| 2022-02-27 22:00:00 | NQ | Futures | 15997.91 | 16004.57 | 15945.74 | 15961.1 | 8028.0 |
| 2022-02-27 23:00:00 | NQ | Futures | 15961.97 | 16047.47 | 15960.52 | 16009.5 | 8807.0 |
| 2022-02-27 18:00:00 | YM | Futures | 37847.3 | 37847.3 | 37482.1 | 37645.1 | 13783.0 |
| 2022-02-27 19:00:00 | YM | Futures | 37650.7 | 37673.2 | 37577.6 | 37637.2 | 4898.0 |
| 2022-02-27 20:00:00 | YM | Futures | 37636.1 | 37859.7 | 37617.0 | 37617.0 | 5279.0 |
| 2022-02-27 21:00:00 | YM | Futures | 37622.6 | 37655.2 | 37447.3 | 37495.6 | 4996.0 |
| 2022-02-27 22:00:00 | YM | Futures | 37493.3 | 37566.4 | 37456.3 | 37512.5 | 2340.0 |
| 2022-02-27 23:00:00 | YM | Futures | 37514.7 | 37624.8 | 37514.7 | 37564.1 | 2601.0 |
| 2022-02-27 18:00:00 | CL | Futures | 68.99 | 71.98 | 68.87 | 70.28 | 33312.0 |
| 2022-02-27 19:00:00 | CL | Futures | 70.27 | 70.36 | 69.94 | 70.15 | 7265.0 |
| 2022-02-27 20:00:00 | CL | Futures | 70.15 | 70.26 | 69.31 | 70.07 | 16266.0 |
| 2022-02-27 21:00:00 | CL | Futures | 70.07 | 70.2 | 69.73 | 69.81 | 7503.0 |
| 2022-02-27 22:00:00 | CL | Futures | 69.82 | 70.42 | 69.78 | 70.26 | 5819.0 |
| 2022-02-27 23:00:00 | CL | Futures | 70.26 | 70.84 | 70.24 | 70.63 | 7119.0 |
| 2022-02-27 18:00:00 | GC | Futures | 2306.0 | 2323.1 | 2288.7 | 2295.8 | 17252.0 |
| 2022-02-27 19:00:00 | GC | Futures | 2295.6 | 2307.0 | 2292.2 | 2304.7 | 7056.0 |
| 2022-02-27 20:00:00 | GC | Futures | 2304.8 | 2304.8 | 2290.2 | 2299.3 | 8709.0 |
| 2022-02-27 21:00:00 | GC | Futures | 2299.3 | 2299.6 | 2293.5 | 2294.7 | 3844.0 |
| 2022-02-27 22:00:00 | GC | Futures | 2294.8 | 2296.5 | 2287.0 | 2292.4 | 3879.0 |
| 2022-02-27 23:00:00 | GC | Futures | 2292.4 | 2297.6 | 2290.6 | 2297.1 | 4469.0 |
| 2022-02-27 18:00:00 | ZN | Futures | 130.384946 | 130.866249 | 130.336816 | 130.417033 | 5552.0 |
| 2022-02-27 19:00:00 | ZN | Futures | 130.40099 | 130.417033 | 130.208469 | 130.384946 | 2897.0 |
| 2022-02-27 20:00:00 | ZN | Futures | 130.368903 | 130.368903 | 130.224512 | 130.304729 | 1133.0 |
| 2022-02-27 21:00:00 | ZN | Futures | 130.304729 | 130.513294 | 130.304729 | 130.513294 | 1785.0 |
| 2022-02-27 22:00:00 | ZN | Futures | 130.513294 | 130.513294 | 130.433077 | 130.481207 | 857.0 |
| 2022-02-27 23:00:00 | ZN | Futures | 130.465163 | 130.529337 | 130.465163 | 130.49725 | 649.0 |
> showing 36 of 438 rows — these rows as CSV