PREVIEW / futures_1hour / 2022-12-22
file: by_date/futures_1hour/2022/2022-12-22.parquet size: 66 KB rows: 2,015
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-22 00:00:00 | ES | Futures | 4381.71 | 4382.55 | 4379.76 | 4380.6 | 3120.0 |
| 2022-12-22 01:00:00 | ES | Futures | 4380.88 | 4381.71 | 4376.68 | 4378.36 | 4519.0 |
| 2022-12-22 02:00:00 | ES | Futures | 4378.36 | 4378.64 | 4373.05 | 4374.72 | 8258.0 |
| 2022-12-22 03:00:00 | ES | Futures | 4374.72 | 4383.67 | 4373.05 | 4376.12 | 14189.0 |
| 2022-12-22 04:00:00 | ES | Futures | 4376.4 | 4377.52 | 4368.29 | 4368.85 | 10387.0 |
| 2022-12-22 05:00:00 | ES | Futures | 4368.85 | 4369.13 | 4362.98 | 4365.5 | 13959.0 |
| 2022-12-22 06:00:00 | ES | Futures | 4365.5 | 4365.78 | 4356.27 | 4361.3 | 12032.0 |
| 2022-12-22 07:00:00 | ES | Futures | 4361.3 | 4364.66 | 4352.91 | 4357.67 | 16338.0 |
| 2022-12-22 08:00:00 | ES | Futures | 4357.95 | 4360.46 | 4328.31 | 4332.22 | 56326.0 |
| 2022-12-22 09:00:00 | ES | Futures | 4332.22 | 4334.46 | 4307.06 | 4314.33 | 185294.0 |
| 2022-12-22 10:00:00 | ES | Futures | 4314.05 | 4314.33 | 4284.13 | 4286.09 | 252524.0 |
| 2022-12-22 11:00:00 | ES | Futures | 4286.09 | 4291.96 | 4276.02 | 4281.34 | 142070.0 |
| 2022-12-22 12:00:00 | ES | Futures | 4281.34 | 4281.89 | 4252.26 | 4257.01 | 175375.0 |
| 2022-12-22 13:00:00 | ES | Futures | 4257.29 | 4257.29 | 4237.16 | 4245.55 | 160672.0 |
| 2022-12-22 14:00:00 | ES | Futures | 4245.27 | 4280.5 | 4244.99 | 4279.1 | 202859.0 |
| 2022-12-22 15:00:00 | ES | Futures | 4279.1 | 4306.78 | 4275.74 | 4305.94 | 387304.0 |
| 2022-12-22 16:00:00 | ES | Futures | 4305.94 | 4313.49 | 4298.67 | 4303.42 | 69615.0 |
| 2022-12-22 18:00:00 | ES | Futures | 4305.94 | 4305.94 | 4300.63 | 4304.26 | 7467.0 |
| 2022-12-22 19:00:00 | ES | Futures | 4304.26 | 4305.94 | 4293.08 | 4294.2 | 8402.0 |
| 2022-12-22 20:00:00 | ES | Futures | 4294.2 | 4310.97 | 4292.24 | 4309.86 | 13131.0 |
| 2022-12-22 21:00:00 | ES | Futures | 4309.58 | 4313.49 | 4306.5 | 4307.62 | 8802.0 |
| 2022-12-22 22:00:00 | ES | Futures | 4307.62 | 4316.01 | 4307.62 | 4314.61 | 6018.0 |
| 2022-12-22 23:00:00 | ES | Futures | 4314.61 | 4314.89 | 4308.74 | 4309.3 | 3719.0 |
| 2022-12-22 00:00:00 | NQ | Futures | 12938.79 | 12946.19 | 12931.68 | 12941.35 | 1521.0 |
| 2022-12-22 01:00:00 | NQ | Futures | 12941.07 | 12943.63 | 12925.13 | 12931.39 | 1952.0 |
| 2022-12-22 02:00:00 | NQ | Futures | 12931.68 | 12935.66 | 12918.02 | 12920.3 | 2971.0 |
| 2022-12-22 03:00:00 | NQ | Futures | 12919.73 | 12955.58 | 12913.47 | 12931.68 | 7142.0 |
| 2022-12-22 04:00:00 | NQ | Futures | 12931.96 | 12933.67 | 12899.53 | 12902.94 | 5598.0 |
| 2022-12-22 05:00:00 | NQ | Futures | 12902.66 | 12902.94 | 12881.61 | 12891.85 | 6479.0 |
| 2022-12-22 06:00:00 | NQ | Futures | 12892.7 | 12892.7 | 12861.41 | 12877.05 | 6077.0 |
| 2022-12-22 07:00:00 | NQ | Futures | 12876.77 | 12888.72 | 12834.67 | 12852.3 | 8998.0 |
| 2022-12-22 08:00:00 | NQ | Futures | 12852.3 | 12860.55 | 12735.38 | 12748.75 | 29519.0 |
| 2022-12-22 09:00:00 | NQ | Futures | 12748.75 | 12754.72 | 12623.29 | 12658.28 | 82899.0 |
| 2022-12-22 10:00:00 | NQ | Futures | 12658.28 | 12658.28 | 12516.03 | 12525.14 | 121755.0 |
| 2022-12-22 11:00:00 | NQ | Futures | 12525.14 | 12552.73 | 12474.5 | 12495.26 | 66091.0 |
| 2022-12-22 12:00:00 | NQ | Futures | 12495.55 | 12498.96 | 12411.05 | 12435.52 | 67989.0 |
| 2022-12-22 13:00:00 | NQ | Futures | 12435.52 | 12435.52 | 12370.37 | 12407.36 | 68870.0 |
| 2022-12-22 14:00:00 | NQ | Futures | 12407.07 | 12507.78 | 12405.08 | 12502.38 | 77056.0 |
| 2022-12-22 15:00:00 | NQ | Futures | 12502.38 | 12585.45 | 12492.99 | 12580.04 | 117935.0 |
| 2022-12-22 16:00:00 | NQ | Futures | 12580.61 | 12608.78 | 12549.6 | 12568.09 | 18535.0 |
| 2022-12-22 18:00:00 | NQ | Futures | 12587.16 | 12591.42 | 12565.25 | 12573.5 | 3683.0 |
| 2022-12-22 19:00:00 | NQ | Futures | 12572.93 | 12579.19 | 12532.53 | 12534.81 | 4684.0 |
| 2022-12-22 20:00:00 | NQ | Futures | 12534.81 | 12591.14 | 12530.26 | 12584.88 | 5387.0 |
| 2022-12-22 21:00:00 | NQ | Futures | 12584.31 | 12602.52 | 12573.5 | 12580.04 | 3784.0 |
| 2022-12-22 22:00:00 | NQ | Futures | 12580.33 | 12607.35 | 12578.62 | 12601.66 | 2693.0 |
| 2022-12-22 23:00:00 | NQ | Futures | 12601.95 | 12603.66 | 12581.47 | 12584.31 | 1738.0 |
| 2022-12-22 00:00:00 | YM | Futures | 37494.4 | 37495.6 | 37478.8 | 37480.0 | 414.0 |
| 2022-12-22 01:00:00 | YM | Futures | 37480.0 | 37484.4 | 37445.4 | 37459.9 | 776.0 |
| 2022-12-22 02:00:00 | YM | Futures | 37456.6 | 37456.6 | 37422.0 | 37427.6 | 1220.0 |
| 2022-12-22 03:00:00 | YM | Futures | 37426.5 | 37498.9 | 37422.0 | 37448.8 | 2220.0 |
> showing 50 of 2,015 rows — these rows as CSV