PREVIEW / futures_1hour / 2023-05-14
file: by_date/futures_1hour/2023/2023-05-14.parquet size: 19 KB rows: 414
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-05-14 18:00:00 | ES | Futures | 4584.37 | 4585.76 | 4580.77 | 4580.77 | 4702.0 |
| 2023-05-14 19:00:00 | ES | Futures | 4581.05 | 4585.21 | 4580.77 | 4584.37 | 3458.0 |
| 2023-05-14 20:00:00 | ES | Futures | 4584.1 | 4585.48 | 4578.27 | 4580.49 | 8077.0 |
| 2023-05-14 21:00:00 | ES | Futures | 4580.77 | 4589.09 | 4580.21 | 4588.26 | 9253.0 |
| 2023-05-14 22:00:00 | ES | Futures | 4588.26 | 4589.09 | 4586.87 | 4588.81 | 3655.0 |
| 2023-05-14 23:00:00 | ES | Futures | 4588.81 | 4590.75 | 4588.53 | 4589.92 | 4459.0 |
| 2023-05-14 18:00:00 | NQ | Futures | 15067.31 | 15067.31 | 15043.1 | 15044.22 | 2861.0 |
| 2023-05-14 19:00:00 | NQ | Futures | 15044.79 | 15057.74 | 15041.69 | 15053.51 | 2031.0 |
| 2023-05-14 20:00:00 | NQ | Futures | 15053.23 | 15059.14 | 15034.93 | 15044.5 | 4105.0 |
| 2023-05-14 21:00:00 | NQ | Futures | 15043.94 | 15078.01 | 15043.38 | 15072.66 | 5105.0 |
| 2023-05-14 22:00:00 | NQ | Futures | 15073.22 | 15076.04 | 15066.18 | 15073.22 | 2406.0 |
| 2023-05-14 23:00:00 | NQ | Futures | 15074.07 | 15084.77 | 15073.79 | 15080.54 | 2548.0 |
| 2023-05-14 18:00:00 | YM | Futures | 36830.0 | 36830.0 | 36786.9 | 36790.2 | 660.0 |
| 2023-05-14 19:00:00 | YM | Futures | 36790.2 | 36825.6 | 36788.0 | 36821.1 | 607.0 |
| 2023-05-14 20:00:00 | YM | Futures | 36821.1 | 36832.2 | 36788.0 | 36801.2 | 1009.0 |
| 2023-05-14 21:00:00 | YM | Futures | 36801.2 | 36854.3 | 36800.1 | 36849.9 | 1139.0 |
| 2023-05-14 22:00:00 | YM | Futures | 36849.9 | 36849.9 | 36833.3 | 36846.6 | 495.0 |
| 2023-05-14 23:00:00 | YM | Futures | 36847.7 | 36862.0 | 36847.7 | 36858.7 | 626.0 |
| 2023-05-14 18:00:00 | CL | Futures | 56.96 | 57.07 | 56.94 | 57.01 | 503.0 |
| 2023-05-14 19:00:00 | CL | Futures | 57.01 | 57.02 | 56.89 | 56.98 | 183.0 |
| 2023-05-14 20:00:00 | CL | Futures | 56.96 | 57.11 | 56.94 | 57.04 | 521.0 |
| 2023-05-14 21:00:00 | CL | Futures | 57.06 | 57.11 | 56.56 | 56.69 | 1626.0 |
| 2023-05-14 22:00:00 | CL | Futures | 56.69 | 56.75 | 56.57 | 56.58 | 421.0 |
| 2023-05-14 23:00:00 | CL | Futures | 56.58 | 56.64 | 56.46 | 56.47 | 806.0 |
| 2023-05-14 18:00:00 | GC | Futures | 2315.4 | 2318.6 | 2312.9 | 2317.7 | 2345.0 |
| 2023-05-14 19:00:00 | GC | Futures | 2317.7 | 2317.7 | 2316.1 | 2316.3 | 818.0 |
| 2023-05-14 20:00:00 | GC | Futures | 2316.3 | 2319.2 | 2315.4 | 2319.1 | 1706.0 |
| 2023-05-14 21:00:00 | GC | Futures | 2319.3 | 2327.6 | 2319.2 | 2325.3 | 5830.0 |
| 2023-05-14 22:00:00 | GC | Futures | 2325.3 | 2325.5 | 2320.4 | 2320.6 | 3574.0 |
| 2023-05-14 23:00:00 | GC | Futures | 2320.6 | 2322.3 | 2320.1 | 2321.2 | 1583.0 |
| 2023-05-14 18:00:00 | ZN | Futures | 118.364536 | 118.396592 | 118.316453 | 118.380564 | 5334.0 |
| 2023-05-14 19:00:00 | ZN | Futures | 118.380564 | 118.428647 | 118.380564 | 118.412619 | 4647.0 |
| 2023-05-14 20:00:00 | ZN | Futures | 118.412619 | 118.412619 | 118.348508 | 118.412619 | 8090.0 |
| 2023-05-14 21:00:00 | ZN | Futures | 118.412619 | 118.444675 | 118.380564 | 118.412619 | 10457.0 |
| 2023-05-14 22:00:00 | ZN | Futures | 118.428647 | 118.444675 | 118.396592 | 118.412619 | 7778.0 |
| 2023-05-14 23:00:00 | ZN | Futures | 118.412619 | 118.428647 | 118.380564 | 118.396592 | 2828.0 |
> showing 36 of 414 rows — these rows as CSV