PREVIEW / futures_1hour / 2024-09-08
file: by_date/futures_1hour/2024/2024-09-08.parquet size: 19 KB rows: 434
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-08 18:00:00 | ES | Futures | 5673.23 | 5680.04 | 5668.25 | 5676.37 | 17010.0 |
| 2024-09-08 19:00:00 | ES | Futures | 5676.11 | 5684.24 | 5671.13 | 5681.35 | 10024.0 |
| 2024-09-08 20:00:00 | ES | Futures | 5681.62 | 5693.15 | 5680.83 | 5688.7 | 14349.0 |
| 2024-09-08 21:00:00 | ES | Futures | 5688.43 | 5697.35 | 5688.43 | 5694.99 | 12707.0 |
| 2024-09-08 22:00:00 | ES | Futures | 5694.73 | 5697.87 | 5692.89 | 5696.04 | 6846.0 |
| 2024-09-08 23:00:00 | ES | Futures | 5696.04 | 5700.76 | 5696.04 | 5699.71 | 7378.0 |
| 2024-09-08 18:00:00 | NQ | Futures | 19429.11 | 19475.84 | 19419.87 | 19447.06 | 7048.0 |
| 2024-09-08 19:00:00 | NQ | Futures | 19446.53 | 19494.32 | 19414.33 | 19476.1 | 6158.0 |
| 2024-09-08 20:00:00 | NQ | Futures | 19479.8 | 19539.46 | 19473.99 | 19513.85 | 6662.0 |
| 2024-09-08 21:00:00 | NQ | Futures | 19513.85 | 19561.9 | 19513.85 | 19548.43 | 6276.0 |
| 2024-09-08 22:00:00 | NQ | Futures | 19548.43 | 19562.95 | 19532.33 | 19553.98 | 4934.0 |
| 2024-09-08 23:00:00 | NQ | Futures | 19555.03 | 19579.05 | 19552.39 | 19575.89 | 3074.0 |
| 2024-09-08 18:00:00 | YM | Futures | 42385.3 | 42448.4 | 42376.9 | 42432.6 | 1564.0 |
| 2024-09-08 19:00:00 | YM | Futures | 42431.5 | 42464.1 | 42407.4 | 42446.3 | 971.0 |
| 2024-09-08 20:00:00 | YM | Futures | 42450.5 | 42510.3 | 42448.4 | 42491.4 | 1145.0 |
| 2024-09-08 21:00:00 | YM | Futures | 42489.3 | 42545.0 | 42489.3 | 42527.2 | 1423.0 |
| 2024-09-08 22:00:00 | YM | Futures | 42526.1 | 42544.0 | 42512.4 | 42533.5 | 636.0 |
| 2024-09-08 23:00:00 | YM | Futures | 42531.4 | 42554.5 | 42531.4 | 42549.2 | 644.0 |
| 2024-09-08 18:00:00 | CL | Futures | 60.34 | 60.46 | 60.24 | 60.45 | 2760.0 |
| 2024-09-08 19:00:00 | CL | Futures | 60.45 | 60.54 | 60.38 | 60.51 | 1010.0 |
| 2024-09-08 20:00:00 | CL | Futures | 60.51 | 60.7 | 60.5 | 60.53 | 2880.0 |
| 2024-09-08 21:00:00 | CL | Futures | 60.52 | 60.86 | 60.36 | 60.69 | 5421.0 |
| 2024-09-08 22:00:00 | CL | Futures | 60.69 | 60.86 | 60.64 | 60.69 | 1809.0 |
| 2024-09-08 23:00:00 | CL | Futures | 60.68 | 60.91 | 60.67 | 60.72 | 2357.0 |
| 2024-09-08 18:00:00 | GC | Futures | 2660.3 | 2661.2 | 2659.1 | 2660.8 | 2411.0 |
| 2024-09-08 19:00:00 | GC | Futures | 2661.1 | 2661.4 | 2658.3 | 2659.8 | 2428.0 |
| 2024-09-08 20:00:00 | GC | Futures | 2659.9 | 2661.2 | 2658.3 | 2658.7 | 3035.0 |
| 2024-09-08 21:00:00 | GC | Futures | 2658.6 | 2661.7 | 2657.4 | 2660.6 | 3135.0 |
| 2024-09-08 22:00:00 | GC | Futures | 2660.7 | 2662.2 | 2659.7 | 2659.9 | 2345.0 |
| 2024-09-08 23:00:00 | GC | Futures | 2659.8 | 2663.5 | 2659.4 | 2662.1 | 2840.0 |
| 2024-09-08 18:00:00 | ZN | Futures | 115.16251 | 115.16251 | 115.052951 | 115.099905 | 16842.0 |
| 2024-09-08 19:00:00 | ZN | Futures | 115.099905 | 115.131208 | 115.0373 | 115.0373 | 14873.0 |
| 2024-09-08 20:00:00 | ZN | Futures | 115.0373 | 115.068602 | 114.959043 | 114.990346 | 26634.0 |
| 2024-09-08 21:00:00 | ZN | Futures | 114.974694 | 115.005997 | 114.943392 | 114.974694 | 18640.0 |
| 2024-09-08 22:00:00 | ZN | Futures | 114.974694 | 115.005997 | 114.959043 | 114.990346 | 8890.0 |
| 2024-09-08 23:00:00 | ZN | Futures | 114.990346 | 114.990346 | 114.943392 | 114.959043 | 8153.0 |
> showing 36 of 434 rows — these rows as CSV