PREVIEW / futures_1hour / 2022-11-08
file: by_date/futures_1hour/2022/2022-11-08.parquet size: 70 KB rows: 2,097
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-08 00:00:00 | ES | Futures | 4299.16 | 4299.16 | 4292.68 | 4295.21 | 6064.0 |
| 2022-11-08 01:00:00 | ES | Futures | 4295.21 | 4300.85 | 4294.93 | 4299.72 | 5601.0 |
| 2022-11-08 02:00:00 | ES | Futures | 4299.44 | 4300.0 | 4291.27 | 4293.24 | 9532.0 |
| 2022-11-08 03:00:00 | ES | Futures | 4293.24 | 4296.34 | 4284.78 | 4294.93 | 18383.0 |
| 2022-11-08 04:00:00 | ES | Futures | 4294.93 | 4311.0 | 4290.7 | 4310.43 | 20162.0 |
| 2022-11-08 05:00:00 | ES | Futures | 4310.43 | 4314.95 | 4303.11 | 4303.67 | 15613.0 |
| 2022-11-08 06:00:00 | ES | Futures | 4303.67 | 4320.3 | 4303.67 | 4318.89 | 21071.0 |
| 2022-11-08 07:00:00 | ES | Futures | 4318.61 | 4319.46 | 4305.64 | 4313.54 | 28662.0 |
| 2022-11-08 08:00:00 | ES | Futures | 4313.54 | 4319.17 | 4306.77 | 4315.23 | 30822.0 |
| 2022-11-08 09:00:00 | ES | Futures | 4315.23 | 4323.97 | 4296.9 | 4306.77 | 196972.0 |
| 2022-11-08 10:00:00 | ES | Futures | 4306.77 | 4340.03 | 4305.92 | 4337.21 | 234814.0 |
| 2022-11-08 11:00:00 | ES | Futures | 4337.21 | 4360.33 | 4330.73 | 4354.13 | 192750.0 |
| 2022-11-08 12:00:00 | ES | Futures | 4354.13 | 4356.67 | 4347.08 | 4353.0 | 120442.0 |
| 2022-11-08 13:00:00 | ES | Futures | 4353.28 | 4359.2 | 4307.62 | 4311.0 | 224301.0 |
| 2022-11-08 14:00:00 | ES | Futures | 4311.0 | 4317.48 | 4276.61 | 4309.31 | 275134.0 |
| 2022-11-08 15:00:00 | ES | Futures | 4309.59 | 4348.77 | 4308.46 | 4324.53 | 298168.0 |
| 2022-11-08 16:00:00 | ES | Futures | 4324.81 | 4324.81 | 4313.25 | 4321.71 | 63103.0 |
| 2022-11-08 18:00:00 | ES | Futures | 4321.43 | 4334.4 | 4319.17 | 4332.42 | 9810.0 |
| 2022-11-08 19:00:00 | ES | Futures | 4332.42 | 4332.42 | 4319.17 | 4322.84 | 12287.0 |
| 2022-11-08 20:00:00 | ES | Futures | 4322.56 | 4339.75 | 4320.02 | 4329.6 | 15868.0 |
| 2022-11-08 21:00:00 | ES | Futures | 4329.6 | 4334.4 | 4323.4 | 4328.19 | 10091.0 |
| 2022-11-08 22:00:00 | ES | Futures | 4327.91 | 4331.3 | 4314.66 | 4318.61 | 14617.0 |
| 2022-11-08 23:00:00 | ES | Futures | 4318.89 | 4332.42 | 4312.97 | 4329.6 | 17338.0 |
| 2022-11-08 00:00:00 | NQ | Futures | 12648.95 | 12649.81 | 12623.09 | 12633.43 | 4412.0 |
| 2022-11-08 01:00:00 | NQ | Futures | 12633.72 | 12656.13 | 12632.28 | 12649.23 | 4998.0 |
| 2022-11-08 02:00:00 | NQ | Futures | 12649.23 | 12651.53 | 12616.77 | 12622.8 | 5638.0 |
| 2022-11-08 03:00:00 | NQ | Futures | 12623.95 | 12656.71 | 12590.33 | 12650.1 | 11472.0 |
| 2022-11-08 04:00:00 | NQ | Futures | 12649.81 | 12709.57 | 12634.29 | 12709.57 | 11732.0 |
| 2022-11-08 05:00:00 | NQ | Futures | 12708.71 | 12729.4 | 12680.55 | 12683.14 | 8691.0 |
| 2022-11-08 06:00:00 | NQ | Futures | 12682.56 | 12750.37 | 12682.56 | 12741.47 | 9730.0 |
| 2022-11-08 07:00:00 | NQ | Futures | 12740.89 | 12742.9 | 12702.96 | 12726.81 | 10979.0 |
| 2022-11-08 08:00:00 | NQ | Futures | 12727.39 | 12749.22 | 12697.79 | 12735.15 | 16639.0 |
| 2022-11-08 09:00:00 | NQ | Futures | 12735.15 | 12762.44 | 12650.1 | 12710.44 | 89938.0 |
| 2022-11-08 10:00:00 | NQ | Futures | 12709.57 | 12800.94 | 12689.46 | 12790.02 | 93386.0 |
| 2022-11-08 11:00:00 | NQ | Futures | 12790.31 | 12908.12 | 12769.34 | 12869.61 | 75163.0 |
| 2022-11-08 12:00:00 | NQ | Futures | 12870.48 | 12891.16 | 12846.05 | 12872.49 | 46481.0 |
| 2022-11-08 13:00:00 | NQ | Futures | 12872.77 | 12894.04 | 12676.53 | 12691.76 | 85804.0 |
| 2022-11-08 14:00:00 | NQ | Futures | 12691.76 | 12717.04 | 12560.45 | 12667.91 | 104950.0 |
| 2022-11-08 15:00:00 | NQ | Futures | 12667.62 | 12824.79 | 12662.16 | 12750.66 | 95258.0 |
| 2022-11-08 16:00:00 | NQ | Futures | 12750.37 | 12756.41 | 12715.61 | 12744.34 | 18770.0 |
| 2022-11-08 18:00:00 | NQ | Futures | 12744.91 | 12792.04 | 12739.17 | 12786.29 | 4620.0 |
| 2022-11-08 19:00:00 | NQ | Futures | 12786.86 | 12786.86 | 12746.64 | 12759.28 | 5033.0 |
| 2022-11-08 20:00:00 | NQ | Futures | 12759.28 | 12831.11 | 12748.94 | 12784.85 | 8079.0 |
| 2022-11-08 21:00:00 | NQ | Futures | 12784.28 | 12812.44 | 12763.3 | 12782.84 | 6273.0 |
| 2022-11-08 22:00:00 | NQ | Futures | 12783.42 | 12792.9 | 12729.69 | 12749.8 | 6754.0 |
| 2022-11-08 23:00:00 | NQ | Futures | 12749.8 | 12802.95 | 12729.11 | 12791.17 | 6743.0 |
| 2022-11-08 00:00:00 | YM | Futures | 36863.1 | 36864.3 | 36818.2 | 36839.6 | 1025.0 |
| 2022-11-08 01:00:00 | YM | Futures | 36841.8 | 36882.2 | 36838.4 | 36869.9 | 849.0 |
| 2022-11-08 02:00:00 | YM | Futures | 36867.6 | 36874.4 | 36814.9 | 36836.2 | 1477.0 |
| 2022-11-08 03:00:00 | YM | Futures | 36836.2 | 36837.3 | 36771.1 | 36818.2 | 3245.0 |
> showing 50 of 2,097 rows — these rows as CSV