PREVIEW / futures_1hour / 2023-12-10
file: by_date/futures_1hour/2023/2023-12-10.parquet size: 18 KB rows: 402
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 |
|---|---|---|---|---|---|---|---|
| 2023-12-10 18:00:00 | ES | Futures | 5005.09 | 5012.15 | 5004.55 | 5009.17 | 6287.0 |
| 2023-12-10 19:00:00 | ES | Futures | 5008.62 | 5011.61 | 5003.73 | 5005.09 | 6423.0 |
| 2023-12-10 20:00:00 | ES | Futures | 5005.09 | 5006.18 | 5002.65 | 5004.82 | 5295.0 |
| 2023-12-10 21:00:00 | ES | Futures | 5004.55 | 5005.64 | 5001.56 | 5002.11 | 3110.0 |
| 2023-12-10 22:00:00 | ES | Futures | 5002.38 | 5003.73 | 5000.75 | 5002.92 | 1895.0 |
| 2023-12-10 23:00:00 | ES | Futures | 5002.65 | 5003.46 | 5001.29 | 5001.56 | 1353.0 |
| 2023-12-10 18:00:00 | NQ | Futures | 17680.68 | 17704.3 | 17668.87 | 17693.04 | 4311.0 |
| 2023-12-10 19:00:00 | NQ | Futures | 17692.77 | 17698.54 | 17654.32 | 17661.46 | 4252.0 |
| 2023-12-10 20:00:00 | NQ | Futures | 17661.73 | 17663.38 | 17647.17 | 17655.14 | 3750.0 |
| 2023-12-10 21:00:00 | NQ | Futures | 17654.04 | 17658.98 | 17635.64 | 17637.29 | 2802.0 |
| 2023-12-10 22:00:00 | NQ | Futures | 17637.84 | 17644.7 | 17633.44 | 17641.13 | 1659.0 |
| 2023-12-10 23:00:00 | NQ | Futures | 17640.86 | 17645.25 | 17633.72 | 17636.74 | 1301.0 |
| 2023-12-10 18:00:00 | YM | Futures | 39360.6 | 39405.8 | 39360.6 | 39381.1 | 1225.0 |
| 2023-12-10 19:00:00 | YM | Futures | 39381.1 | 39405.8 | 39373.5 | 39381.1 | 724.0 |
| 2023-12-10 20:00:00 | YM | Futures | 39380.0 | 39389.6 | 39357.4 | 39374.6 | 879.0 |
| 2023-12-10 21:00:00 | YM | Futures | 39373.5 | 39378.9 | 39358.5 | 39361.7 | 542.0 |
| 2023-12-10 22:00:00 | YM | Futures | 39362.8 | 39366.0 | 39352.1 | 39359.6 | 414.0 |
| 2023-12-10 23:00:00 | YM | Futures | 39360.6 | 39367.1 | 39348.8 | 39354.2 | 364.0 |
| 2023-12-10 18:00:00 | CL | Futures | 59.73 | 59.82 | 59.54 | 59.81 | 1641.0 |
| 2023-12-10 19:00:00 | CL | Futures | 59.81 | 60.02 | 59.8 | 59.97 | 2067.0 |
| 2023-12-10 20:00:00 | CL | Futures | 59.98 | 60.04 | 59.8 | 59.92 | 3502.0 |
| 2023-12-10 21:00:00 | CL | Futures | 59.92 | 60.04 | 59.88 | 59.96 | 1221.0 |
| 2023-12-10 22:00:00 | CL | Futures | 59.97 | 60.17 | 59.95 | 60.14 | 2394.0 |
| 2023-12-10 23:00:00 | CL | Futures | 60.13 | 60.16 | 60.1 | 60.13 | 853.0 |
| 2023-12-10 18:00:00 | GC | Futures | 2234.7 | 2238.5 | 2233.7 | 2238.2 | 3428.0 |
| 2023-12-10 19:00:00 | GC | Futures | 2238.1 | 2238.8 | 2235.1 | 2235.3 | 2463.0 |
| 2023-12-10 20:00:00 | GC | Futures | 2235.2 | 2235.5 | 2231.9 | 2232.2 | 4203.0 |
| 2023-12-10 21:00:00 | GC | Futures | 2232.2 | 2233.1 | 2226.6 | 2228.4 | 4690.0 |
| 2023-12-10 22:00:00 | GC | Futures | 2228.3 | 2230.9 | 2225.1 | 2226.8 | 4746.0 |
| 2023-12-10 23:00:00 | GC | Futures | 2226.8 | 2226.9 | 2223.5 | 2226.3 | 3744.0 |
| 2023-12-10 18:00:00 | ZN | Futures | 111.815983 | 111.879344 | 111.784303 | 111.815983 | 18740.0 |
| 2023-12-10 19:00:00 | ZN | Futures | 111.815983 | 111.863504 | 111.736782 | 111.784303 | 20267.0 |
| 2023-12-10 20:00:00 | ZN | Futures | 111.784303 | 111.847664 | 111.736782 | 111.768463 | 22626.0 |
| 2023-12-10 21:00:00 | ZN | Futures | 111.752622 | 111.815983 | 111.752622 | 111.800143 | 12688.0 |
| 2023-12-10 22:00:00 | ZN | Futures | 111.800143 | 111.815983 | 111.752622 | 111.768463 | 7856.0 |
| 2023-12-10 23:00:00 | ZN | Futures | 111.768463 | 111.800143 | 111.752622 | 111.752622 | 4369.0 |
> showing 36 of 402 rows — these rows as CSV