PREVIEW / futures_1hour / 2022-12-21
file: by_date/futures_1hour/2022/2022-12-21.parquet size: 66 KB rows: 2,020
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-12-21 00:00:00 | ES | Futures | 4319.64 | 4327.19 | 4317.96 | 4324.67 | 4557.0 |
| 2022-12-21 01:00:00 | ES | Futures | 4324.67 | 4328.03 | 4321.04 | 4326.91 | 4966.0 |
| 2022-12-21 02:00:00 | ES | Futures | 4326.63 | 4328.87 | 4322.16 | 4326.35 | 7156.0 |
| 2022-12-21 03:00:00 | ES | Futures | 4326.63 | 4327.47 | 4314.33 | 4326.07 | 16043.0 |
| 2022-12-21 04:00:00 | ES | Futures | 4326.07 | 4335.58 | 4325.51 | 4334.46 | 14431.0 |
| 2022-12-21 05:00:00 | ES | Futures | 4334.46 | 4335.3 | 4325.23 | 4326.91 | 9777.0 |
| 2022-12-21 06:00:00 | ES | Futures | 4326.63 | 4331.66 | 4323.84 | 4329.99 | 20172.0 |
| 2022-12-21 07:00:00 | ES | Futures | 4329.71 | 4334.46 | 4319.92 | 4333.62 | 27322.0 |
| 2022-12-21 08:00:00 | ES | Futures | 4333.62 | 4344.25 | 4331.66 | 4340.61 | 38170.0 |
| 2022-12-21 09:00:00 | ES | Futures | 4340.33 | 4343.69 | 4328.87 | 4334.46 | 142869.0 |
| 2022-12-21 10:00:00 | ES | Futures | 4334.46 | 4374.16 | 4332.22 | 4373.33 | 244081.0 |
| 2022-12-21 11:00:00 | ES | Futures | 4373.05 | 4381.43 | 4362.14 | 4366.06 | 175112.0 |
| 2022-12-21 12:00:00 | ES | Futures | 4366.34 | 4371.65 | 4360.18 | 4371.09 | 123859.0 |
| 2022-12-21 13:00:00 | ES | Futures | 4371.09 | 4376.12 | 4362.7 | 4371.09 | 119203.0 |
| 2022-12-21 14:00:00 | ES | Futures | 4371.37 | 4382.83 | 4363.82 | 4368.01 | 151561.0 |
| 2022-12-21 15:00:00 | ES | Futures | 4368.01 | 4372.21 | 4357.95 | 4369.13 | 257198.0 |
| 2022-12-21 16:00:00 | ES | Futures | 4369.13 | 4378.08 | 4367.45 | 4377.52 | 52654.0 |
| 2022-12-21 18:00:00 | ES | Futures | 4378.64 | 4379.48 | 4373.05 | 4374.72 | 6824.0 |
| 2022-12-21 19:00:00 | ES | Futures | 4375.0 | 4376.96 | 4369.97 | 4376.68 | 8871.0 |
| 2022-12-21 20:00:00 | ES | Futures | 4376.68 | 4380.88 | 4374.72 | 4379.48 | 8655.0 |
| 2022-12-21 21:00:00 | ES | Futures | 4379.76 | 4383.95 | 4378.36 | 4380.32 | 6797.0 |
| 2022-12-21 22:00:00 | ES | Futures | 4380.32 | 4383.11 | 4378.08 | 4381.43 | 3749.0 |
| 2022-12-21 23:00:00 | ES | Futures | 4381.71 | 4383.39 | 4380.32 | 4381.99 | 3225.0 |
| 2022-12-21 00:00:00 | NQ | Futures | 12758.42 | 12783.17 | 12753.02 | 12773.5 | 2796.0 |
| 2022-12-21 01:00:00 | NQ | Futures | 12774.07 | 12788.86 | 12766.39 | 12786.59 | 2698.0 |
| 2022-12-21 02:00:00 | NQ | Futures | 12786.02 | 12795.4 | 12771.79 | 12789.43 | 3977.0 |
| 2022-12-21 03:00:00 | NQ | Futures | 12789.43 | 12793.41 | 12744.2 | 12788.29 | 8974.0 |
| 2022-12-21 04:00:00 | NQ | Futures | 12787.72 | 12811.34 | 12787.72 | 12802.23 | 6907.0 |
| 2022-12-21 05:00:00 | NQ | Futures | 12801.95 | 12804.51 | 12762.97 | 12767.81 | 6146.0 |
| 2022-12-21 06:00:00 | NQ | Futures | 12768.38 | 12776.34 | 12748.75 | 12766.67 | 6368.0 |
| 2022-12-21 07:00:00 | NQ | Futures | 12766.39 | 12781.18 | 12730.54 | 12777.77 | 11125.0 |
| 2022-12-21 08:00:00 | NQ | Futures | 12777.77 | 12800.53 | 12770.65 | 12787.15 | 17129.0 |
| 2022-12-21 09:00:00 | NQ | Futures | 12786.87 | 12829.26 | 12723.71 | 12774.92 | 87167.0 |
| 2022-12-21 10:00:00 | NQ | Futures | 12775.77 | 12918.02 | 12767.24 | 12916.31 | 105822.0 |
| 2022-12-21 11:00:00 | NQ | Futures | 12916.6 | 12947.61 | 12872.5 | 12891.85 | 68551.0 |
| 2022-12-21 12:00:00 | NQ | Futures | 12892.13 | 12923.14 | 12863.11 | 12920.58 | 56898.0 |
| 2022-12-21 13:00:00 | NQ | Futures | 12920.58 | 12941.92 | 12889.86 | 12916.6 | 56450.0 |
| 2022-12-21 14:00:00 | NQ | Futures | 12916.88 | 12961.26 | 12891.56 | 12904.94 | 68710.0 |
| 2022-12-21 15:00:00 | NQ | Futures | 12905.5 | 12918.02 | 12867.38 | 12900.38 | 70591.0 |
| 2022-12-21 16:00:00 | NQ | Futures | 12900.1 | 12928.55 | 12893.84 | 12922.29 | 14850.0 |
| 2022-12-21 18:00:00 | NQ | Futures | 12924.0 | 12929.4 | 12908.63 | 12918.59 | 2767.0 |
| 2022-12-21 19:00:00 | NQ | Futures | 12919.44 | 12924.28 | 12902.66 | 12923.14 | 3102.0 |
| 2022-12-21 20:00:00 | NQ | Futures | 12923.71 | 12943.06 | 12915.75 | 12935.66 | 3343.0 |
| 2022-12-21 21:00:00 | NQ | Futures | 12935.66 | 12951.31 | 12933.1 | 12939.36 | 2445.0 |
| 2022-12-21 22:00:00 | NQ | Futures | 12939.07 | 12950.45 | 12933.38 | 12944.2 | 1568.0 |
| 2022-12-21 23:00:00 | NQ | Futures | 12944.2 | 12949.03 | 12937.37 | 12939.36 | 1548.0 |
| 2022-12-21 00:00:00 | YM | Futures | 36989.7 | 37045.4 | 36978.6 | 37026.5 | 960.0 |
| 2022-12-21 01:00:00 | YM | Futures | 37025.4 | 37047.7 | 36997.5 | 37033.2 | 1164.0 |
| 2022-12-21 02:00:00 | YM | Futures | 37029.8 | 37047.7 | 36999.7 | 37025.4 | 1091.0 |
| 2022-12-21 03:00:00 | YM | Futures | 37026.5 | 37044.3 | 36938.5 | 37034.3 | 2769.0 |
> showing 50 of 2,020 rows — these rows as CSV