PREVIEW / futures_1hour / 2024-03-03
file: by_date/futures_1hour/2024/2024-03-03.parquet size: 18 KB rows: 424
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 |
|---|---|---|---|---|---|---|---|
| 2024-03-03 18:00:00 | ES | Futures | 5524.37 | 5528.67 | 5522.49 | 5524.1 | 9394.0 |
| 2024-03-03 19:00:00 | ES | Futures | 5524.1 | 5525.71 | 5520.88 | 5524.37 | 8997.0 |
| 2024-03-03 20:00:00 | ES | Futures | 5524.37 | 5525.45 | 5523.03 | 5523.83 | 5362.0 |
| 2024-03-03 21:00:00 | ES | Futures | 5523.83 | 5525.45 | 5522.49 | 5524.37 | 5036.0 |
| 2024-03-03 22:00:00 | ES | Futures | 5524.64 | 5524.64 | 5522.49 | 5523.3 | 2490.0 |
| 2024-03-03 23:00:00 | ES | Futures | 5523.3 | 5524.64 | 5522.22 | 5523.3 | 3328.0 |
| 2024-03-03 18:00:00 | NQ | Futures | 19891.3 | 19923.31 | 19882.35 | 19898.9 | 8651.0 |
| 2024-03-03 19:00:00 | NQ | Futures | 19900.53 | 19902.97 | 19881.0 | 19895.92 | 4648.0 |
| 2024-03-03 20:00:00 | NQ | Futures | 19896.46 | 19907.03 | 19891.03 | 19903.24 | 3413.0 |
| 2024-03-03 21:00:00 | NQ | Futures | 19903.24 | 19919.24 | 19898.08 | 19913.54 | 3630.0 |
| 2024-03-03 22:00:00 | NQ | Futures | 19913.81 | 19914.9 | 19904.32 | 19908.93 | 2194.0 |
| 2024-03-03 23:00:00 | NQ | Futures | 19909.75 | 19911.92 | 19899.71 | 19905.14 | 2027.0 |
| 2024-03-03 18:00:00 | YM | Futures | 42011.5 | 42017.9 | 41986.8 | 41995.4 | 1326.0 |
| 2024-03-03 19:00:00 | YM | Futures | 41996.4 | 42006.1 | 41978.2 | 41994.3 | 737.0 |
| 2024-03-03 20:00:00 | YM | Futures | 41995.4 | 41997.5 | 41986.8 | 41988.9 | 733.0 |
| 2024-03-03 21:00:00 | YM | Futures | 41987.8 | 41991.1 | 41976.0 | 41981.4 | 582.0 |
| 2024-03-03 22:00:00 | YM | Futures | 41982.5 | 41983.5 | 41965.3 | 41968.5 | 409.0 |
| 2024-03-03 23:00:00 | YM | Futures | 41971.7 | 41982.5 | 41970.7 | 41978.2 | 270.0 |
| 2024-03-03 18:00:00 | CL | Futures | 67.07 | 67.27 | 66.81 | 66.9 | 5074.0 |
| 2024-03-03 19:00:00 | CL | Futures | 66.9 | 67.16 | 66.9 | 67.07 | 2338.0 |
| 2024-03-03 20:00:00 | CL | Futures | 67.06 | 67.21 | 66.95 | 67.03 | 4308.0 |
| 2024-03-03 21:00:00 | CL | Futures | 67.04 | 67.04 | 66.92 | 66.97 | 2622.0 |
| 2024-03-03 22:00:00 | CL | Futures | 66.97 | 66.97 | 66.85 | 66.91 | 1322.0 |
| 2024-03-03 23:00:00 | CL | Futures | 66.91 | 66.97 | 66.87 | 66.89 | 742.0 |
| 2024-03-03 18:00:00 | GC | Futures | 2292.5 | 2296.3 | 2291.9 | 2293.2 | 6471.0 |
| 2024-03-03 19:00:00 | GC | Futures | 2293.3 | 2294.2 | 2291.9 | 2292.1 | 7491.0 |
| 2024-03-03 20:00:00 | GC | Futures | 2292.3 | 2292.5 | 2288.7 | 2289.5 | 7395.0 |
| 2024-03-03 21:00:00 | GC | Futures | 2289.7 | 2292.9 | 2289.1 | 2290.9 | 3929.0 |
| 2024-03-03 22:00:00 | GC | Futures | 2290.9 | 2291.4 | 2289.5 | 2290.8 | 2392.0 |
| 2024-03-03 23:00:00 | GC | Futures | 2290.8 | 2291.0 | 2289.5 | 2290.1 | 1135.0 |
| 2024-03-03 18:00:00 | ZN | Futures | 111.974385 | 111.974385 | 111.958545 | 111.958545 | 32.0 |
| 2024-03-03 19:00:00 | ZN | Futures | 111.974385 | 111.974385 | 111.926865 | 111.926865 | 63.0 |
| 2024-03-03 20:00:00 | ZN | Futures | 111.911024 | 111.911024 | 111.895184 | 111.895184 | 45.0 |
| 2024-03-03 21:00:00 | ZN | Futures | 111.911024 | 111.926865 | 111.911024 | 111.926865 | 27.0 |
| 2024-03-03 22:00:00 | ZN | Futures | 111.942705 | 111.942705 | 111.895184 | 111.926865 | 7.0 |
| 2024-03-03 23:00:00 | ZN | Futures | 111.895184 | 111.895184 | 111.895184 | 111.895184 | 15.0 |
> showing 36 of 424 rows — these rows as CSV