PREVIEW / futures_1hour / 2022-06-13
file: by_date/futures_1hour/2022/2022-06-13.parquet size: 70 KB rows: 2,040
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-06-13 00:00:00 | ES | Futures | 4363.56 | 4370.08 | 4353.07 | 4355.34 | 5017.0 |
| 2022-06-13 01:00:00 | ES | Futures | 4355.06 | 4361.29 | 4345.99 | 4349.11 | 6977.0 |
| 2022-06-13 02:00:00 | ES | Futures | 4348.82 | 4351.94 | 4333.52 | 4337.49 | 17685.0 |
| 2022-06-13 03:00:00 | ES | Futures | 4337.49 | 4353.36 | 4327.0 | 4330.12 | 26728.0 |
| 2022-06-13 04:00:00 | ES | Futures | 4330.12 | 4330.4 | 4305.46 | 4309.14 | 29451.0 |
| 2022-06-13 05:00:00 | ES | Futures | 4308.86 | 4323.88 | 4306.87 | 4316.51 | 22829.0 |
| 2022-06-13 06:00:00 | ES | Futures | 4316.79 | 4328.13 | 4313.68 | 4323.03 | 18972.0 |
| 2022-06-13 07:00:00 | ES | Futures | 4323.03 | 4331.25 | 4309.42 | 4310.84 | 17300.0 |
| 2022-06-13 08:00:00 | ES | Futures | 4310.84 | 4330.12 | 4310.28 | 4314.53 | 29517.0 |
| 2022-06-13 09:00:00 | ES | Futures | 4314.53 | 4328.7 | 4298.65 | 4306.02 | 120713.0 |
| 2022-06-13 10:00:00 | ES | Futures | 4306.02 | 4316.51 | 4256.42 | 4263.79 | 153173.0 |
| 2022-06-13 11:00:00 | ES | Futures | 4264.07 | 4300.07 | 4250.47 | 4288.45 | 135565.0 |
| 2022-06-13 12:00:00 | ES | Futures | 4288.45 | 4323.88 | 4283.35 | 4287.32 | 97784.0 |
| 2022-06-13 13:00:00 | ES | Futures | 4287.6 | 4308.29 | 4272.86 | 4300.92 | 56399.0 |
| 2022-06-13 14:00:00 | ES | Futures | 4300.64 | 4301.21 | 4270.59 | 4273.14 | 59808.0 |
| 2022-06-13 15:00:00 | ES | Futures | 4273.43 | 4286.47 | 4231.76 | 4251.89 | 208751.0 |
| 2022-06-13 16:00:00 | ES | Futures | 4251.89 | 4262.66 | 4241.68 | 4256.42 | 48939.0 |
| 2022-06-13 18:00:00 | ES | Futures | 4260.96 | 4270.88 | 4258.69 | 4265.21 | 5049.0 |
| 2022-06-13 19:00:00 | ES | Futures | 4264.92 | 4266.34 | 4254.72 | 4263.51 | 4262.0 |
| 2022-06-13 20:00:00 | ES | Futures | 4263.51 | 4281.93 | 4259.82 | 4277.68 | 11249.0 |
| 2022-06-13 21:00:00 | ES | Futures | 4277.4 | 4279.1 | 4262.66 | 4265.21 | 7500.0 |
| 2022-06-13 22:00:00 | ES | Futures | 4265.21 | 4276.26 | 4264.36 | 4275.41 | 4534.0 |
| 2022-06-13 23:00:00 | ES | Futures | 4275.7 | 4286.18 | 4275.7 | 4283.06 | 5273.0 |
| 2022-06-13 00:00:00 | NQ | Futures | 13482.68 | 13506.75 | 13451.65 | 13454.26 | 3014.0 |
| 2022-06-13 01:00:00 | NQ | Futures | 13454.84 | 13491.96 | 13425.55 | 13445.85 | 4395.0 |
| 2022-06-13 02:00:00 | NQ | Futures | 13444.69 | 13456.0 | 13398.3 | 13415.12 | 7241.0 |
| 2022-06-13 03:00:00 | NQ | Futures | 13414.25 | 13472.24 | 13386.7 | 13396.85 | 10326.0 |
| 2022-06-13 04:00:00 | NQ | Futures | 13398.3 | 13398.59 | 13262.01 | 13311.01 | 15588.0 |
| 2022-06-13 05:00:00 | NQ | Futures | 13310.72 | 13359.44 | 13291.3 | 13332.18 | 7180.0 |
| 2022-06-13 06:00:00 | NQ | Futures | 13331.6 | 13378.0 | 13321.74 | 13355.09 | 5769.0 |
| 2022-06-13 07:00:00 | NQ | Futures | 13356.25 | 13382.64 | 13291.59 | 13298.84 | 5803.0 |
| 2022-06-13 08:00:00 | NQ | Futures | 13300.87 | 13373.65 | 13298.55 | 13331.02 | 8572.0 |
| 2022-06-13 09:00:00 | NQ | Futures | 13332.18 | 13426.13 | 13294.78 | 13321.16 | 50096.0 |
| 2022-06-13 10:00:00 | NQ | Futures | 13320.58 | 13369.01 | 13157.04 | 13175.02 | 63771.0 |
| 2022-06-13 11:00:00 | NQ | Futures | 13175.89 | 13272.74 | 13127.46 | 13234.17 | 47047.0 |
| 2022-06-13 12:00:00 | NQ | Futures | 13234.17 | 13373.65 | 13208.07 | 13242.58 | 34316.0 |
| 2022-06-13 13:00:00 | NQ | Futures | 13243.74 | 13298.26 | 13192.41 | 13282.6 | 21762.0 |
| 2022-06-13 14:00:00 | NQ | Futures | 13282.02 | 13283.76 | 13170.38 | 13179.66 | 18426.0 |
| 2022-06-13 15:00:00 | NQ | Futures | 13179.95 | 13229.82 | 13054.1 | 13100.49 | 42188.0 |
| 2022-06-13 16:00:00 | NQ | Futures | 13102.52 | 13166.32 | 13075.84 | 13142.83 | 8870.0 |
| 2022-06-13 18:00:00 | NQ | Futures | 13146.6 | 13191.25 | 13146.6 | 13166.9 | 1952.0 |
| 2022-06-13 19:00:00 | NQ | Futures | 13167.48 | 13172.41 | 13123.98 | 13154.43 | 2719.0 |
| 2022-06-13 20:00:00 | NQ | Futures | 13153.85 | 13218.51 | 13135.87 | 13199.08 | 5443.0 |
| 2022-06-13 21:00:00 | NQ | Futures | 13198.79 | 13206.91 | 13149.79 | 13157.04 | 4412.0 |
| 2022-06-13 22:00:00 | NQ | Futures | 13157.04 | 13197.34 | 13152.69 | 13193.86 | 2569.0 |
| 2022-06-13 23:00:00 | NQ | Futures | 13193.57 | 13227.21 | 13193.57 | 13218.8 | 2797.0 |
| 2022-06-13 00:00:00 | YM | Futures | 35044.1 | 35085.8 | 34977.5 | 34994.4 | 1625.0 |
| 2022-06-13 01:00:00 | YM | Futures | 34993.3 | 35021.5 | 34929.0 | 34944.8 | 2197.0 |
| 2022-06-13 02:00:00 | YM | Futures | 34943.7 | 34965.1 | 34821.8 | 34851.1 | 4787.0 |
| 2022-06-13 03:00:00 | YM | Futures | 34851.1 | 34959.5 | 34766.5 | 34788.0 | 5408.0 |
> showing 50 of 2,040 rows — these rows as CSV