PREVIEW / futures_1hour / 2023-02-05
file: by_date/futures_1hour/2023/2023-02-05.parquet size: 20 KB rows: 448
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-02-05 18:00:00 | ES | Futures | 4623.85 | 4633.64 | 4619.38 | 4630.56 | 20765.0 |
| 2023-02-05 19:00:00 | ES | Futures | 4630.56 | 4631.4 | 4624.69 | 4626.93 | 12414.0 |
| 2023-02-05 20:00:00 | ES | Futures | 4626.65 | 4631.68 | 4621.34 | 4629.45 | 13870.0 |
| 2023-02-05 21:00:00 | ES | Futures | 4629.45 | 4630.56 | 4623.29 | 4624.13 | 10441.0 |
| 2023-02-05 22:00:00 | ES | Futures | 4623.85 | 4625.53 | 4622.46 | 4622.74 | 5720.0 |
| 2023-02-05 23:00:00 | ES | Futures | 4622.74 | 4625.25 | 4620.22 | 4622.18 | 6045.0 |
| 2023-02-05 18:00:00 | NQ | Futures | 14306.64 | 14344.76 | 14281.6 | 14327.97 | 9767.0 |
| 2023-02-05 19:00:00 | NQ | Futures | 14327.69 | 14333.38 | 14304.36 | 14321.72 | 5006.0 |
| 2023-02-05 20:00:00 | NQ | Futures | 14320.29 | 14340.78 | 14296.11 | 14333.38 | 5672.0 |
| 2023-02-05 21:00:00 | NQ | Futures | 14333.66 | 14342.48 | 14306.07 | 14310.05 | 5063.0 |
| 2023-02-05 22:00:00 | NQ | Futures | 14309.77 | 14314.89 | 14302.09 | 14307.21 | 3082.0 |
| 2023-02-05 23:00:00 | NQ | Futures | 14307.49 | 14318.3 | 14292.41 | 14300.09 | 3869.0 |
| 2023-02-05 18:00:00 | YM | Futures | 37755.2 | 37815.3 | 37727.3 | 37799.7 | 2093.0 |
| 2023-02-05 19:00:00 | YM | Futures | 37798.6 | 37800.8 | 37750.7 | 37767.4 | 1067.0 |
| 2023-02-05 20:00:00 | YM | Futures | 37768.5 | 37796.4 | 37736.2 | 37776.3 | 2071.0 |
| 2023-02-05 21:00:00 | YM | Futures | 37775.2 | 37785.2 | 37750.7 | 37756.3 | 1337.0 |
| 2023-02-05 22:00:00 | YM | Futures | 37756.3 | 37764.1 | 37741.8 | 37748.5 | 1144.0 |
| 2023-02-05 23:00:00 | YM | Futures | 37749.6 | 37761.8 | 37734.0 | 37752.9 | 659.0 |
| 2023-02-05 18:00:00 | CL | Futures | 59.73 | 60.1 | 59.71 | 59.93 | 3874.0 |
| 2023-02-05 19:00:00 | CL | Futures | 59.93 | 60.06 | 59.92 | 60.02 | 2172.0 |
| 2023-02-05 20:00:00 | CL | Futures | 60.02 | 60.09 | 59.67 | 59.97 | 5668.0 |
| 2023-02-05 21:00:00 | CL | Futures | 59.96 | 59.98 | 59.86 | 59.97 | 2505.0 |
| 2023-02-05 22:00:00 | CL | Futures | 59.97 | 60.03 | 59.92 | 59.95 | 1532.0 |
| 2023-02-05 23:00:00 | CL | Futures | 59.95 | 60.01 | 59.93 | 59.97 | 1317.0 |
| 2023-02-05 18:00:00 | GC | Futures | 2180.7 | 2185.9 | 2175.2 | 2180.5 | 5557.0 |
| 2023-02-05 19:00:00 | GC | Futures | 2180.5 | 2186.3 | 2178.5 | 2186.1 | 4773.0 |
| 2023-02-05 20:00:00 | GC | Futures | 2186.1 | 2190.0 | 2179.9 | 2189.2 | 8384.0 |
| 2023-02-05 21:00:00 | GC | Futures | 2189.2 | 2193.1 | 2187.9 | 2189.9 | 6979.0 |
| 2023-02-05 22:00:00 | GC | Futures | 2190.0 | 2193.9 | 2188.6 | 2193.6 | 3548.0 |
| 2023-02-05 23:00:00 | GC | Futures | 2193.6 | 2196.1 | 2193.2 | 2195.8 | 4231.0 |
| 2023-02-05 18:00:00 | ZN | Futures | 117.789225 | 117.80532 | 117.628266 | 117.660458 | 33893.0 |
| 2023-02-05 19:00:00 | ZN | Futures | 117.644362 | 117.660458 | 117.531691 | 117.628266 | 36645.0 |
| 2023-02-05 20:00:00 | ZN | Futures | 117.628266 | 117.708745 | 117.612171 | 117.644362 | 17704.0 |
| 2023-02-05 21:00:00 | ZN | Futures | 117.644362 | 117.69265 | 117.596075 | 117.660458 | 23737.0 |
| 2023-02-05 22:00:00 | ZN | Futures | 117.644362 | 117.708745 | 117.628266 | 117.69265 | 13462.0 |
| 2023-02-05 23:00:00 | ZN | Futures | 117.676554 | 117.724841 | 117.660458 | 117.724841 | 16306.0 |
> showing 36 of 448 rows — these rows as CSV