PREVIEW / futures_1hour / 2024-11-13
file: by_date/futures_1hour/2024/2024-11-13.parquet size: 70 KB rows: 2,139
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 |
|---|---|---|---|---|---|---|---|
| 2024-11-13 00:00:00 | ES | Futures | 6232.19 | 6232.71 | 6227.52 | 6228.04 | 6963.0 |
| 2024-11-13 01:00:00 | ES | Futures | 6228.04 | 6229.34 | 6221.3 | 6224.41 | 10872.0 |
| 2024-11-13 02:00:00 | ES | Futures | 6224.15 | 6229.6 | 6223.11 | 6226.49 | 10908.0 |
| 2024-11-13 03:00:00 | ES | Futures | 6226.75 | 6236.35 | 6224.93 | 6235.83 | 12689.0 |
| 2024-11-13 04:00:00 | ES | Futures | 6235.83 | 6238.68 | 6233.75 | 6237.39 | 7983.0 |
| 2024-11-13 05:00:00 | ES | Futures | 6237.39 | 6238.94 | 6230.12 | 6230.64 | 7745.0 |
| 2024-11-13 06:00:00 | ES | Futures | 6230.9 | 6232.45 | 6224.93 | 6225.19 | 8829.0 |
| 2024-11-13 07:00:00 | ES | Futures | 6225.19 | 6234.27 | 6223.89 | 6229.86 | 19486.0 |
| 2024-11-13 08:00:00 | ES | Futures | 6229.86 | 6259.96 | 6228.3 | 6242.84 | 79605.0 |
| 2024-11-13 09:00:00 | ES | Futures | 6242.84 | 6249.32 | 6234.27 | 6242.58 | 151984.0 |
| 2024-11-13 10:00:00 | ES | Futures | 6242.32 | 6245.69 | 6220.0 | 6243.35 | 229219.0 |
| 2024-11-13 11:00:00 | ES | Futures | 6243.35 | 6255.55 | 6238.16 | 6252.7 | 141120.0 |
| 2024-11-13 12:00:00 | ES | Futures | 6252.96 | 6264.64 | 6251.4 | 6263.86 | 115235.0 |
| 2024-11-13 13:00:00 | ES | Futures | 6264.12 | 6265.15 | 6255.81 | 6261.78 | 90416.0 |
| 2024-11-13 14:00:00 | ES | Futures | 6262.04 | 6262.3 | 6242.32 | 6244.13 | 136429.0 |
| 2024-11-13 15:00:00 | ES | Futures | 6244.13 | 6257.89 | 6236.87 | 6244.91 | 236834.0 |
| 2024-11-13 16:00:00 | ES | Futures | 6244.91 | 6251.92 | 6242.06 | 6247.51 | 57212.0 |
| 2024-11-13 18:00:00 | ES | Futures | 6246.99 | 6251.4 | 6244.65 | 6249.58 | 6184.0 |
| 2024-11-13 19:00:00 | ES | Futures | 6249.58 | 6250.62 | 6242.84 | 6246.47 | 5365.0 |
| 2024-11-13 20:00:00 | ES | Futures | 6246.47 | 6246.47 | 6242.06 | 6242.06 | 6696.0 |
| 2024-11-13 21:00:00 | ES | Futures | 6242.32 | 6242.32 | 6238.42 | 6239.2 | 6359.0 |
| 2024-11-13 22:00:00 | ES | Futures | 6238.94 | 6242.84 | 6237.9 | 6239.72 | 4421.0 |
| 2024-11-13 23:00:00 | ES | Futures | 6239.98 | 6244.39 | 6238.94 | 6241.02 | 4610.0 |
| 2024-11-13 00:00:00 | NQ | Futures | 22063.01 | 22064.83 | 22037.96 | 22042.13 | 3645.0 |
| 2024-11-13 01:00:00 | NQ | Futures | 22042.13 | 22051.79 | 22022.3 | 22040.05 | 4768.0 |
| 2024-11-13 02:00:00 | NQ | Futures | 22039.79 | 22068.22 | 22036.39 | 22052.31 | 4058.0 |
| 2024-11-13 03:00:00 | NQ | Futures | 22053.35 | 22104.23 | 22041.87 | 22101.62 | 5619.0 |
| 2024-11-13 04:00:00 | NQ | Futures | 22102.14 | 22108.14 | 22086.75 | 22100.84 | 4943.0 |
| 2024-11-13 05:00:00 | NQ | Futures | 22101.1 | 22107.88 | 22071.1 | 22075.01 | 4308.0 |
| 2024-11-13 06:00:00 | NQ | Futures | 22075.27 | 22080.49 | 22047.09 | 22048.92 | 4730.0 |
| 2024-11-13 07:00:00 | NQ | Futures | 22048.92 | 22079.18 | 22035.87 | 22054.66 | 8844.0 |
| 2024-11-13 08:00:00 | NQ | Futures | 22054.14 | 22170.76 | 22041.61 | 22097.71 | 28795.0 |
| 2024-11-13 09:00:00 | NQ | Futures | 22098.49 | 22125.36 | 22043.44 | 22063.01 | 65901.0 |
| 2024-11-13 10:00:00 | NQ | Futures | 22063.53 | 22064.31 | 21975.6 | 22037.18 | 86693.0 |
| 2024-11-13 11:00:00 | NQ | Futures | 22037.7 | 22100.84 | 22011.09 | 22089.36 | 60687.0 |
| 2024-11-13 12:00:00 | NQ | Futures | 22089.1 | 22159.81 | 22081.27 | 22155.11 | 49294.0 |
| 2024-11-13 13:00:00 | NQ | Futures | 22155.11 | 22196.85 | 22134.76 | 22185.11 | 39935.0 |
| 2024-11-13 14:00:00 | NQ | Futures | 22185.64 | 22186.16 | 22092.23 | 22107.36 | 55153.0 |
| 2024-11-13 15:00:00 | NQ | Futures | 22107.1 | 22146.24 | 22045.79 | 22082.31 | 65396.0 |
| 2024-11-13 16:00:00 | NQ | Futures | 22082.58 | 22111.01 | 22075.79 | 22089.88 | 13236.0 |
| 2024-11-13 18:00:00 | NQ | Futures | 22090.92 | 22099.53 | 22069.53 | 22090.4 | 3505.0 |
| 2024-11-13 19:00:00 | NQ | Futures | 22090.4 | 22096.93 | 22063.27 | 22076.05 | 2758.0 |
| 2024-11-13 20:00:00 | NQ | Futures | 22076.05 | 22076.31 | 22052.05 | 22056.22 | 4280.0 |
| 2024-11-13 21:00:00 | NQ | Futures | 22055.7 | 22057.79 | 22037.18 | 22042.13 | 3594.0 |
| 2024-11-13 22:00:00 | NQ | Futures | 22041.35 | 22059.09 | 22038.48 | 22049.96 | 3207.0 |
| 2024-11-13 23:00:00 | NQ | Futures | 22050.48 | 22074.75 | 22046.57 | 22061.18 | 2885.0 |
| 2024-11-13 00:00:00 | YM | Futures | 45805.6 | 45812.9 | 45766.0 | 45769.2 | 1237.0 |
| 2024-11-13 01:00:00 | YM | Futures | 45768.1 | 45775.4 | 45707.8 | 45717.1 | 1662.0 |
| 2024-11-13 02:00:00 | YM | Futures | 45716.1 | 45733.8 | 45696.3 | 45706.7 | 2156.0 |
| 2024-11-13 03:00:00 | YM | Futures | 45707.8 | 45774.4 | 45685.9 | 45769.2 | 2475.0 |
> showing 50 of 2,139 rows — these rows as CSV