PREVIEW / futures_1hour / 2023-10-31
file: by_date/futures_1hour/2023/2023-10-31.parquet size: 69 KB rows: 2,114
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-10-31 00:00:00 | ES | Futures | 4531.49 | 4535.3 | 4529.32 | 4531.22 | 6550.0 |
| 2023-10-31 01:00:00 | ES | Futures | 4530.95 | 4531.77 | 4527.42 | 4529.05 | 7407.0 |
| 2023-10-31 02:00:00 | ES | Futures | 4529.05 | 4536.38 | 4526.06 | 4535.57 | 9140.0 |
| 2023-10-31 03:00:00 | ES | Futures | 4535.3 | 4540.73 | 4535.02 | 4536.38 | 11891.0 |
| 2023-10-31 04:00:00 | ES | Futures | 4536.11 | 4553.76 | 4534.21 | 4553.49 | 24467.0 |
| 2023-10-31 05:00:00 | ES | Futures | 4553.49 | 4556.48 | 4545.07 | 4555.12 | 28372.0 |
| 2023-10-31 06:00:00 | ES | Futures | 4555.12 | 4560.55 | 4554.03 | 4557.56 | 26014.0 |
| 2023-10-31 07:00:00 | ES | Futures | 4557.29 | 4561.37 | 4554.58 | 4556.48 | 28218.0 |
| 2023-10-31 08:00:00 | ES | Futures | 4556.48 | 4561.91 | 4548.6 | 4551.86 | 57437.0 |
| 2023-10-31 09:00:00 | ES | Futures | 4552.13 | 4556.21 | 4532.04 | 4537.47 | 196403.0 |
| 2023-10-31 10:00:00 | ES | Futures | 4537.47 | 4557.56 | 4531.49 | 4554.58 | 268255.0 |
| 2023-10-31 11:00:00 | ES | Futures | 4554.58 | 4557.29 | 4544.53 | 4556.21 | 169524.0 |
| 2023-10-31 12:00:00 | ES | Futures | 4555.93 | 4560.55 | 4542.63 | 4559.46 | 187098.0 |
| 2023-10-31 13:00:00 | ES | Futures | 4559.46 | 4572.5 | 4554.85 | 4571.69 | 147966.0 |
| 2023-10-31 14:00:00 | ES | Futures | 4571.69 | 4575.76 | 4562.72 | 4574.4 | 131168.0 |
| 2023-10-31 15:00:00 | ES | Futures | 4574.4 | 4578.47 | 4568.15 | 4575.49 | 316676.0 |
| 2023-10-31 16:00:00 | ES | Futures | 4575.49 | 4576.3 | 4564.35 | 4566.53 | 77962.0 |
| 2023-10-31 18:00:00 | ES | Futures | 4567.61 | 4570.06 | 4564.35 | 4567.88 | 6023.0 |
| 2023-10-31 19:00:00 | ES | Futures | 4567.88 | 4567.88 | 4563.27 | 4564.9 | 5603.0 |
| 2023-10-31 20:00:00 | ES | Futures | 4564.62 | 4567.07 | 4561.09 | 4563.54 | 9709.0 |
| 2023-10-31 21:00:00 | ES | Futures | 4563.27 | 4564.08 | 4559.46 | 4561.64 | 8533.0 |
| 2023-10-31 22:00:00 | ES | Futures | 4561.64 | 4569.24 | 4560.82 | 4568.7 | 8081.0 |
| 2023-10-31 23:00:00 | ES | Futures | 4568.97 | 4569.78 | 4567.88 | 4568.15 | 3730.0 |
| 2023-10-31 00:00:00 | NQ | Futures | 15759.68 | 15773.14 | 15749.24 | 15754.19 | 4278.0 |
| 2023-10-31 01:00:00 | NQ | Futures | 15752.54 | 15755.84 | 15739.63 | 15748.15 | 4540.0 |
| 2023-10-31 02:00:00 | NQ | Futures | 15748.7 | 15768.2 | 15733.04 | 15766.82 | 5425.0 |
| 2023-10-31 03:00:00 | NQ | Futures | 15766.27 | 15783.3 | 15763.25 | 15769.57 | 6380.0 |
| 2023-10-31 04:00:00 | NQ | Futures | 15769.57 | 15839.88 | 15759.41 | 15837.69 | 12705.0 |
| 2023-10-31 05:00:00 | NQ | Futures | 15837.41 | 15841.53 | 15798.68 | 15837.69 | 12027.0 |
| 2023-10-31 06:00:00 | NQ | Futures | 15837.41 | 15862.96 | 15832.19 | 15849.5 | 10433.0 |
| 2023-10-31 07:00:00 | NQ | Futures | 15848.67 | 15874.22 | 15842.91 | 15850.05 | 11574.0 |
| 2023-10-31 08:00:00 | NQ | Futures | 15850.6 | 15879.98 | 15823.68 | 15835.21 | 23399.0 |
| 2023-10-31 09:00:00 | NQ | Futures | 15835.76 | 15855.27 | 15723.15 | 15754.74 | 94045.0 |
| 2023-10-31 10:00:00 | NQ | Futures | 15755.56 | 15856.64 | 15734.69 | 15839.06 | 136208.0 |
| 2023-10-31 11:00:00 | NQ | Futures | 15839.61 | 15858.29 | 15783.58 | 15836.59 | 76215.0 |
| 2023-10-31 12:00:00 | NQ | Futures | 15836.31 | 15865.43 | 15786.87 | 15859.66 | 73287.0 |
| 2023-10-31 13:00:00 | NQ | Futures | 15860.48 | 15912.4 | 15834.94 | 15905.8 | 59468.0 |
| 2023-10-31 14:00:00 | NQ | Futures | 15905.8 | 15919.26 | 15866.25 | 15913.49 | 50217.0 |
| 2023-10-31 15:00:00 | NQ | Futures | 15913.22 | 15934.64 | 15896.19 | 15918.99 | 76742.0 |
| 2023-10-31 16:00:00 | NQ | Futures | 15918.99 | 15919.81 | 15867.9 | 15877.79 | 20081.0 |
| 2023-10-31 18:00:00 | NQ | Futures | 15886.58 | 15906.35 | 15879.16 | 15892.07 | 3609.0 |
| 2023-10-31 19:00:00 | NQ | Futures | 15891.25 | 15892.89 | 15872.02 | 15879.16 | 2378.0 |
| 2023-10-31 20:00:00 | NQ | Futures | 15878.89 | 15890.97 | 15868.45 | 15878.34 | 3953.0 |
| 2023-10-31 21:00:00 | NQ | Futures | 15878.61 | 15883.01 | 15863.23 | 15871.75 | 3610.0 |
| 2023-10-31 22:00:00 | NQ | Futures | 15871.2 | 15901.96 | 15868.72 | 15900.86 | 3256.0 |
| 2023-10-31 23:00:00 | NQ | Futures | 15900.31 | 15904.7 | 15896.46 | 15897.56 | 1806.0 |
| 2023-10-31 00:00:00 | YM | Futures | 35766.7 | 35791.7 | 35751.5 | 35763.5 | 820.0 |
| 2023-10-31 01:00:00 | YM | Futures | 35761.3 | 35765.6 | 35738.5 | 35746.1 | 1140.0 |
| 2023-10-31 02:00:00 | YM | Futures | 35745.0 | 35803.6 | 35727.7 | 35797.1 | 1861.0 |
| 2023-10-31 03:00:00 | YM | Futures | 35794.9 | 35839.4 | 35794.9 | 35804.7 | 2518.0 |
> showing 50 of 2,114 rows — these rows as CSV