PREVIEW / futures_1hour / 2022-12-29
file: by_date/futures_1hour/2022/2022-12-29.parquet size: 66 KB rows: 2,028
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-29 00:00:00 | ES | Futures | 4263.44 | 4264.28 | 4259.25 | 4260.64 | 3975.0 |
| 2022-12-29 01:00:00 | ES | Futures | 4260.92 | 4262.88 | 4258.69 | 4262.32 | 5366.0 |
| 2022-12-29 02:00:00 | ES | Futures | 4262.6 | 4266.24 | 4261.48 | 4265.12 | 5341.0 |
| 2022-12-29 03:00:00 | ES | Futures | 4265.4 | 4270.43 | 4262.32 | 4268.19 | 11000.0 |
| 2022-12-29 04:00:00 | ES | Futures | 4268.19 | 4275.74 | 4267.91 | 4273.79 | 10725.0 |
| 2022-12-29 05:00:00 | ES | Futures | 4273.51 | 4275.74 | 4269.87 | 4275.74 | 6973.0 |
| 2022-12-29 06:00:00 | ES | Futures | 4275.46 | 4280.5 | 4273.79 | 4276.86 | 10511.0 |
| 2022-12-29 07:00:00 | ES | Futures | 4277.14 | 4279.1 | 4274.62 | 4276.3 | 9088.0 |
| 2022-12-29 08:00:00 | ES | Futures | 4276.3 | 4294.48 | 4276.02 | 4289.44 | 34644.0 |
| 2022-12-29 09:00:00 | ES | Futures | 4289.16 | 4313.77 | 4282.45 | 4311.25 | 166466.0 |
| 2022-12-29 10:00:00 | ES | Futures | 4311.25 | 4329.99 | 4308.18 | 4328.03 | 194092.0 |
| 2022-12-29 11:00:00 | ES | Futures | 4328.31 | 4341.17 | 4318.8 | 4337.26 | 131705.0 |
| 2022-12-29 12:00:00 | ES | Futures | 4337.26 | 4340.05 | 4330.27 | 4336.14 | 82569.0 |
| 2022-12-29 13:00:00 | ES | Futures | 4336.14 | 4338.38 | 4329.43 | 4336.98 | 66362.0 |
| 2022-12-29 14:00:00 | ES | Futures | 4336.98 | 4342.57 | 4332.22 | 4333.06 | 82612.0 |
| 2022-12-29 15:00:00 | ES | Futures | 4333.06 | 4339.21 | 4328.31 | 4330.83 | 186196.0 |
| 2022-12-29 16:00:00 | ES | Futures | 4330.83 | 4332.5 | 4326.07 | 4327.47 | 47318.0 |
| 2022-12-29 18:00:00 | ES | Futures | 4328.03 | 4329.43 | 4323.28 | 4323.84 | 5908.0 |
| 2022-12-29 19:00:00 | ES | Futures | 4324.12 | 4325.51 | 4321.6 | 4324.12 | 5609.0 |
| 2022-12-29 20:00:00 | ES | Futures | 4324.12 | 4326.35 | 4319.36 | 4322.44 | 6408.0 |
| 2022-12-29 21:00:00 | ES | Futures | 4322.44 | 4324.95 | 4319.36 | 4324.67 | 3391.0 |
| 2022-12-29 22:00:00 | ES | Futures | 4324.39 | 4328.31 | 4324.39 | 4326.63 | 3935.0 |
| 2022-12-29 23:00:00 | ES | Futures | 4326.91 | 4326.91 | 4324.67 | 4326.07 | 1974.0 |
| 2022-12-29 00:00:00 | NQ | Futures | 12294.7 | 12297.26 | 12282.18 | 12290.43 | 1678.0 |
| 2022-12-29 01:00:00 | NQ | Futures | 12291.28 | 12306.93 | 12288.15 | 12306.36 | 3267.0 |
| 2022-12-29 02:00:00 | NQ | Futures | 12306.36 | 12311.2 | 12294.41 | 12306.93 | 2799.0 |
| 2022-12-29 03:00:00 | NQ | Futures | 12307.21 | 12323.43 | 12298.68 | 12315.75 | 6390.0 |
| 2022-12-29 04:00:00 | NQ | Futures | 12315.46 | 12343.06 | 12314.33 | 12334.24 | 6906.0 |
| 2022-12-29 05:00:00 | NQ | Futures | 12333.96 | 12346.76 | 12325.99 | 12344.77 | 4739.0 |
| 2022-12-29 06:00:00 | NQ | Futures | 12344.77 | 12362.4 | 12330.83 | 12341.92 | 7641.0 |
| 2022-12-29 07:00:00 | NQ | Futures | 12342.21 | 12350.17 | 12325.14 | 12334.81 | 5175.0 |
| 2022-12-29 08:00:00 | NQ | Futures | 12333.67 | 12408.78 | 12332.53 | 12392.85 | 18607.0 |
| 2022-12-29 09:00:00 | NQ | Futures | 12392.85 | 12491.28 | 12354.44 | 12475.92 | 80315.0 |
| 2022-12-29 10:00:00 | NQ | Futures | 12476.49 | 12559.84 | 12453.44 | 12553.87 | 79960.0 |
| 2022-12-29 11:00:00 | NQ | Futures | 12554.15 | 12599.1 | 12521.44 | 12584.59 | 58993.0 |
| 2022-12-29 12:00:00 | NQ | Futures | 12584.59 | 12591.14 | 12539.93 | 12560.41 | 38381.0 |
| 2022-12-29 13:00:00 | NQ | Futures | 12560.13 | 12574.35 | 12528.83 | 12570.37 | 30716.0 |
| 2022-12-29 14:00:00 | NQ | Futures | 12570.09 | 12590.57 | 12547.33 | 12551.88 | 32232.0 |
| 2022-12-29 15:00:00 | NQ | Futures | 12552.16 | 12597.4 | 12549.89 | 12554.15 | 53831.0 |
| 2022-12-29 16:00:00 | NQ | Futures | 12553.87 | 12564.96 | 12548.75 | 12551.88 | 13345.0 |
| 2022-12-29 18:00:00 | NQ | Futures | 12555.86 | 12558.99 | 12541.35 | 12543.34 | 2500.0 |
| 2022-12-29 19:00:00 | NQ | Futures | 12543.63 | 12547.61 | 12533.67 | 12536.8 | 2360.0 |
| 2022-12-29 20:00:00 | NQ | Futures | 12537.08 | 12543.63 | 12523.14 | 12533.67 | 3091.0 |
| 2022-12-29 21:00:00 | NQ | Futures | 12533.1 | 12544.2 | 12524.28 | 12542.77 | 2352.0 |
| 2022-12-29 22:00:00 | NQ | Futures | 12543.06 | 12551.88 | 12542.49 | 12545.9 | 1737.0 |
| 2022-12-29 23:00:00 | NQ | Futures | 12546.76 | 12546.76 | 12537.65 | 12542.77 | 1104.0 |
| 2022-12-29 00:00:00 | YM | Futures | 36808.1 | 36817.0 | 36783.6 | 36790.3 | 537.0 |
| 2022-12-29 01:00:00 | YM | Futures | 36790.3 | 36800.3 | 36772.5 | 36795.9 | 749.0 |
| 2022-12-29 02:00:00 | YM | Futures | 36795.9 | 36834.9 | 36795.9 | 36827.1 | 1031.0 |
| 2022-12-29 03:00:00 | YM | Futures | 36828.2 | 36862.7 | 36793.6 | 36851.6 | 2412.0 |
> showing 50 of 2,028 rows — these rows as CSV