PREVIEW / futures_1hour / 2022-11-27
file: by_date/futures_1hour/2022/2022-11-27.parquet size: 20 KB rows: 442
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 |
|---|---|---|---|---|---|---|---|
| 2022-11-27 18:00:00 | ES | Futures | 4533.13 | 4537.36 | 4528.34 | 4528.34 | 14240.0 |
| 2022-11-27 19:00:00 | ES | Futures | 4528.34 | 4530.59 | 4523.55 | 4525.24 | 13460.0 |
| 2022-11-27 20:00:00 | ES | Futures | 4525.24 | 4525.24 | 4514.24 | 4515.94 | 19572.0 |
| 2022-11-27 21:00:00 | ES | Futures | 4516.22 | 4519.88 | 4511.99 | 4519.32 | 15098.0 |
| 2022-11-27 22:00:00 | ES | Futures | 4519.04 | 4519.6 | 4515.94 | 4517.34 | 5757.0 |
| 2022-11-27 23:00:00 | ES | Futures | 4517.34 | 4518.75 | 4517.06 | 4517.91 | 3294.0 |
| 2022-11-27 18:00:00 | NQ | Futures | 13482.77 | 13500.87 | 13466.68 | 13477.88 | 5883.0 |
| 2022-11-27 19:00:00 | NQ | Futures | 13477.88 | 13483.63 | 13445.99 | 13452.02 | 5658.0 |
| 2022-11-27 20:00:00 | NQ | Futures | 13452.6 | 13452.6 | 13408.06 | 13425.3 | 8158.0 |
| 2022-11-27 21:00:00 | NQ | Futures | 13425.3 | 13443.4 | 13407.78 | 13440.24 | 5017.0 |
| 2022-11-27 22:00:00 | NQ | Futures | 13440.53 | 13441.97 | 13429.9 | 13431.91 | 2144.0 |
| 2022-11-27 23:00:00 | NQ | Futures | 13431.34 | 13436.8 | 13427.89 | 13429.9 | 1468.0 |
| 2022-11-27 18:00:00 | YM | Futures | 38492.6 | 38516.2 | 38442.1 | 38444.4 | 2870.0 |
| 2022-11-27 19:00:00 | YM | Futures | 38444.4 | 38465.7 | 38424.2 | 38435.4 | 2155.0 |
| 2022-11-27 20:00:00 | YM | Futures | 38434.3 | 38438.7 | 38352.3 | 38360.2 | 3340.0 |
| 2022-11-27 21:00:00 | YM | Futures | 38360.2 | 38384.9 | 38333.3 | 38381.5 | 2106.0 |
| 2022-11-27 22:00:00 | YM | Futures | 38382.6 | 38386.0 | 38359.1 | 38371.4 | 792.0 |
| 2022-11-27 23:00:00 | YM | Futures | 38371.4 | 38383.8 | 38370.3 | 38378.1 | 543.0 |
| 2022-11-27 18:00:00 | CL | Futures | 62.21 | 62.67 | 62.12 | 62.31 | 5522.0 |
| 2022-11-27 19:00:00 | CL | Futures | 62.31 | 62.42 | 62.06 | 62.13 | 2131.0 |
| 2022-11-27 20:00:00 | CL | Futures | 62.14 | 62.15 | 60.51 | 60.9 | 13940.0 |
| 2022-11-27 21:00:00 | CL | Futures | 60.9 | 61.08 | 60.48 | 60.99 | 7233.0 |
| 2022-11-27 22:00:00 | CL | Futures | 60.99 | 60.99 | 60.71 | 60.81 | 2834.0 |
| 2022-11-27 23:00:00 | CL | Futures | 60.79 | 60.79 | 60.63 | 60.72 | 1903.0 |
| 2022-11-27 18:00:00 | GC | Futures | 2074.5 | 2074.5 | 2067.1 | 2067.7 | 1386.0 |
| 2022-11-27 19:00:00 | GC | Futures | 2067.9 | 2071.5 | 2067.9 | 2069.1 | 1709.0 |
| 2022-11-27 20:00:00 | GC | Futures | 2069.2 | 2069.2 | 2062.0 | 2063.0 | 3134.0 |
| 2022-11-27 21:00:00 | GC | Futures | 2062.9 | 2067.9 | 2062.2 | 2067.0 | 2460.0 |
| 2022-11-27 22:00:00 | GC | Futures | 2067.2 | 2067.3 | 2065.0 | 2066.3 | 1048.0 |
| 2022-11-27 23:00:00 | GC | Futures | 2066.4 | 2068.8 | 2065.9 | 2068.7 | 904.0 |
| 2022-11-27 18:00:00 | ZN | Futures | 116.692691 | 116.757162 | 116.644338 | 116.708809 | 10683.0 |
| 2022-11-27 19:00:00 | ZN | Futures | 116.692691 | 116.789398 | 116.692691 | 116.741044 | 11892.0 |
| 2022-11-27 20:00:00 | ZN | Futures | 116.741044 | 116.934457 | 116.741044 | 116.91834 | 22364.0 |
| 2022-11-27 21:00:00 | ZN | Futures | 116.934457 | 117.015046 | 116.886104 | 116.91834 | 19742.0 |
| 2022-11-27 22:00:00 | ZN | Futures | 116.91834 | 116.982811 | 116.91834 | 116.950575 | 4719.0 |
| 2022-11-27 23:00:00 | ZN | Futures | 116.950575 | 116.998929 | 116.91834 | 116.950575 | 8223.0 |
> showing 36 of 442 rows — these rows as CSV