PREVIEW / futures_1hour / 2023-11-05
file: by_date/futures_1hour/2023/2023-11-05.parquet size: 20 KB rows: 446
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-11-05 00:00:00 | ES | Futures | 4754.72 | 4754.72 | 4754.72 | 4754.72 | 10.0 |
| 2023-11-05 18:00:00 | ES | Futures | 4756.89 | 4761.78 | 4752.54 | 4754.44 | 11417.0 |
| 2023-11-05 19:00:00 | ES | Futures | 4754.44 | 4754.99 | 4751.19 | 4752.54 | 8199.0 |
| 2023-11-05 20:00:00 | ES | Futures | 4752.54 | 4754.72 | 4751.73 | 4753.63 | 7821.0 |
| 2023-11-05 21:00:00 | ES | Futures | 4753.9 | 4756.07 | 4753.63 | 4754.72 | 6161.0 |
| 2023-11-05 22:00:00 | ES | Futures | 4754.99 | 4756.89 | 4753.9 | 4755.8 | 4140.0 |
| 2023-11-05 23:00:00 | ES | Futures | 4755.8 | 4757.16 | 4753.9 | 4754.44 | 3651.0 |
| 2023-11-05 18:00:00 | NQ | Futures | 16685.3 | 16702.33 | 16668.82 | 16672.94 | 6346.0 |
| 2023-11-05 19:00:00 | NQ | Futures | 16672.94 | 16674.59 | 16658.66 | 16668.0 | 5183.0 |
| 2023-11-05 20:00:00 | NQ | Futures | 16668.55 | 16679.81 | 16664.15 | 16675.96 | 5158.0 |
| 2023-11-05 21:00:00 | NQ | Futures | 16675.69 | 16683.38 | 16674.59 | 16678.71 | 3070.0 |
| 2023-11-05 22:00:00 | NQ | Futures | 16678.71 | 16688.6 | 16674.86 | 16684.75 | 3008.0 |
| 2023-11-05 23:00:00 | NQ | Futures | 16684.75 | 16688.6 | 16674.31 | 16676.51 | 2146.0 |
| 2023-11-05 18:00:00 | YM | Futures | 37067.4 | 37091.3 | 37033.8 | 37047.9 | 1711.0 |
| 2023-11-05 19:00:00 | YM | Futures | 37047.9 | 37051.1 | 37033.8 | 37043.5 | 1304.0 |
| 2023-11-05 20:00:00 | YM | Futures | 37041.4 | 37058.7 | 37035.9 | 37050.0 | 919.0 |
| 2023-11-05 21:00:00 | YM | Futures | 37051.1 | 37060.9 | 37046.8 | 37055.5 | 760.0 |
| 2023-11-05 22:00:00 | YM | Futures | 37056.5 | 37066.3 | 37049.0 | 37058.7 | 590.0 |
| 2023-11-05 23:00:00 | YM | Futures | 37059.8 | 37068.5 | 37052.2 | 37053.3 | 439.0 |
| 2023-11-05 18:00:00 | CL | Futures | 68.09 | 68.13 | 67.69 | 68.03 | 2769.0 |
| 2023-11-05 19:00:00 | CL | Futures | 68.01 | 68.11 | 67.98 | 68.04 | 1559.0 |
| 2023-11-05 20:00:00 | CL | Futures | 68.04 | 68.06 | 67.84 | 68.0 | 2159.0 |
| 2023-11-05 21:00:00 | CL | Futures | 67.99 | 68.14 | 67.95 | 68.0 | 1297.0 |
| 2023-11-05 22:00:00 | CL | Futures | 68.0 | 68.04 | 67.86 | 67.93 | 1225.0 |
| 2023-11-05 23:00:00 | CL | Futures | 67.92 | 67.99 | 67.89 | 67.95 | 515.0 |
| 2023-11-05 18:00:00 | GC | Futures | 2233.3 | 2234.0 | 2227.4 | 2229.0 | 3079.0 |
| 2023-11-05 19:00:00 | GC | Futures | 2229.1 | 2232.6 | 2227.4 | 2231.8 | 2776.0 |
| 2023-11-05 20:00:00 | GC | Futures | 2231.7 | 2233.9 | 2230.1 | 2232.9 | 4021.0 |
| 2023-11-05 21:00:00 | GC | Futures | 2232.9 | 2233.8 | 2226.7 | 2227.0 | 3145.0 |
| 2023-11-05 22:00:00 | GC | Futures | 2227.1 | 2228.5 | 2221.4 | 2225.2 | 6715.0 |
| 2023-11-05 23:00:00 | GC | Futures | 2225.2 | 2225.2 | 2223.1 | 2223.6 | 1541.0 |
| 2023-11-05 18:00:00 | ZN | Futures | 109.926378 | 109.926378 | 109.815293 | 109.831163 | 19554.0 |
| 2023-11-05 19:00:00 | ZN | Futures | 109.831163 | 109.910509 | 109.815293 | 109.862901 | 23308.0 |
| 2023-11-05 20:00:00 | ZN | Futures | 109.847032 | 109.87877 | 109.799424 | 109.847032 | 18195.0 |
| 2023-11-05 21:00:00 | ZN | Futures | 109.862901 | 109.87877 | 109.831163 | 109.831163 | 9895.0 |
| 2023-11-05 22:00:00 | ZN | Futures | 109.847032 | 109.926378 | 109.847032 | 109.910509 | 13947.0 |
| 2023-11-05 23:00:00 | ZN | Futures | 109.910509 | 109.910509 | 109.847032 | 109.910509 | 10541.0 |
> showing 37 of 446 rows — these rows as CSV