PREVIEW / futures_1hour / 2024-09-15
file: by_date/futures_1hour/2024/2024-09-15.parquet size: 19 KB rows: 423
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-09-15 18:00:00 | ES | Futures | 5900.52 | 5907.79 | 5899.49 | 5904.42 | 3309.0 |
| 2024-09-15 19:00:00 | ES | Futures | 5904.16 | 5912.46 | 5903.64 | 5911.42 | 1980.0 |
| 2024-09-15 20:00:00 | ES | Futures | 5911.42 | 5911.94 | 5907.01 | 5908.31 | 2096.0 |
| 2024-09-15 21:00:00 | ES | Futures | 5908.05 | 5910.13 | 5903.38 | 5909.87 | 1722.0 |
| 2024-09-15 22:00:00 | ES | Futures | 5909.87 | 5910.91 | 5907.79 | 5909.35 | 1121.0 |
| 2024-09-15 23:00:00 | ES | Futures | 5909.35 | 5911.42 | 5907.79 | 5911.42 | 970.0 |
| 2024-09-15 18:00:00 | NQ | Futures | 20594.33 | 20625.38 | 20575.02 | 20601.38 | 2427.0 |
| 2024-09-15 19:00:00 | NQ | Futures | 20598.51 | 20647.56 | 20595.64 | 20639.73 | 1482.0 |
| 2024-09-15 20:00:00 | NQ | Futures | 20640.51 | 20644.17 | 20613.12 | 20619.64 | 1679.0 |
| 2024-09-15 21:00:00 | NQ | Futures | 20617.03 | 20626.42 | 20593.03 | 20624.34 | 1517.0 |
| 2024-09-15 22:00:00 | NQ | Futures | 20624.86 | 20630.08 | 20610.25 | 20616.25 | 789.0 |
| 2024-09-15 23:00:00 | NQ | Futures | 20617.81 | 20631.9 | 20610.25 | 20630.6 | 1086.0 |
| 2024-09-15 18:00:00 | YM | Futures | 43523.2 | 43538.0 | 43487.5 | 43529.6 | 313.0 |
| 2024-09-15 19:00:00 | YM | Futures | 43527.5 | 43578.9 | 43527.5 | 43573.7 | 413.0 |
| 2024-09-15 20:00:00 | YM | Futures | 43574.7 | 43576.8 | 43550.6 | 43562.1 | 257.0 |
| 2024-09-15 21:00:00 | YM | Futures | 43562.1 | 43572.6 | 43533.8 | 43570.5 | 177.0 |
| 2024-09-15 22:00:00 | YM | Futures | 43571.6 | 43573.7 | 43559.0 | 43565.3 | 129.0 |
| 2024-09-15 23:00:00 | YM | Futures | 43569.5 | 43573.7 | 43559.0 | 43571.6 | 79.0 |
| 2024-09-15 18:00:00 | CL | Futures | 61.19 | 61.37 | 60.95 | 61.0 | 636.0 |
| 2024-09-15 19:00:00 | CL | Futures | 60.99 | 61.01 | 60.9 | 60.91 | 356.0 |
| 2024-09-15 20:00:00 | CL | Futures | 60.89 | 61.0 | 60.78 | 60.94 | 723.0 |
| 2024-09-15 21:00:00 | CL | Futures | 60.94 | 60.98 | 60.87 | 60.95 | 537.0 |
| 2024-09-15 22:00:00 | CL | Futures | 60.94 | 61.03 | 60.89 | 60.98 | 482.0 |
| 2024-09-15 23:00:00 | CL | Futures | 60.96 | 60.99 | 60.82 | 60.86 | 415.0 |
| 2024-09-15 18:00:00 | GC | Futures | 2746.1 | 2746.9 | 2743.5 | 2746.2 | 2660.0 |
| 2024-09-15 19:00:00 | GC | Futures | 2746.3 | 2746.7 | 2744.3 | 2745.1 | 2148.0 |
| 2024-09-15 20:00:00 | GC | Futures | 2745.0 | 2748.5 | 2744.9 | 2747.3 | 1448.0 |
| 2024-09-15 21:00:00 | GC | Futures | 2747.2 | 2748.7 | 2745.4 | 2747.6 | 1928.0 |
| 2024-09-15 22:00:00 | GC | Futures | 2747.5 | 2752.1 | 2747.4 | 2751.5 | 1952.0 |
| 2024-09-15 23:00:00 | GC | Futures | 2751.5 | 2755.2 | 2749.8 | 2752.6 | 4128.0 |
| 2024-09-15 18:00:00 | ZN | Futures | 115.600748 | 115.710307 | 115.585096 | 115.616399 | 12699.0 |
| 2024-09-15 19:00:00 | ZN | Futures | 115.616399 | 115.616399 | 115.569445 | 115.600748 | 9399.0 |
| 2024-09-15 20:00:00 | ZN | Futures | 115.600748 | 115.647702 | 115.600748 | 115.647702 | 12712.0 |
| 2024-09-15 21:00:00 | ZN | Futures | 115.63205 | 115.663353 | 115.616399 | 115.663353 | 5175.0 |
| 2024-09-15 22:00:00 | ZN | Futures | 115.663353 | 115.663353 | 115.616399 | 115.63205 | 15477.0 |
| 2024-09-15 23:00:00 | ZN | Futures | 115.63205 | 115.694656 | 115.616399 | 115.679004 | 6373.0 |
> showing 36 of 423 rows — these rows as CSV