PREVIEW / futures_1hour / 2022-06-29
file: by_date/futures_1hour/2022/2022-06-29.parquet size: 68 KB rows: 2,039
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-29 00:00:00 | ES | Futures | 4340.85 | 4345.38 | 4338.3 | 4342.27 | 9564.0 |
| 2022-06-29 01:00:00 | ES | Futures | 4342.27 | 4345.38 | 4338.3 | 4340.57 | 10406.0 |
| 2022-06-29 02:00:00 | ES | Futures | 4340.57 | 4343.69 | 4322.16 | 4324.71 | 20424.0 |
| 2022-06-29 03:00:00 | ES | Futures | 4324.42 | 4341.42 | 4321.59 | 4331.79 | 28664.0 |
| 2022-06-29 04:00:00 | ES | Futures | 4331.79 | 4342.84 | 4328.95 | 4338.02 | 15377.0 |
| 2022-06-29 05:00:00 | ES | Futures | 4337.74 | 4341.7 | 4319.32 | 4320.74 | 16460.0 |
| 2022-06-29 06:00:00 | ES | Futures | 4321.02 | 4330.94 | 4321.02 | 4324.42 | 16810.0 |
| 2022-06-29 07:00:00 | ES | Futures | 4324.71 | 4343.69 | 4319.89 | 4341.99 | 21822.0 |
| 2022-06-29 08:00:00 | ES | Futures | 4341.99 | 4351.05 | 4328.67 | 4334.34 | 53095.0 |
| 2022-06-29 09:00:00 | ES | Futures | 4334.05 | 4347.37 | 4307.14 | 4337.45 | 243935.0 |
| 2022-06-29 10:00:00 | ES | Futures | 4337.17 | 4351.05 | 4321.02 | 4334.9 | 273522.0 |
| 2022-06-29 11:00:00 | ES | Futures | 4334.62 | 4338.3 | 4316.21 | 4331.22 | 203881.0 |
| 2022-06-29 12:00:00 | ES | Futures | 4331.22 | 4333.49 | 4307.43 | 4320.46 | 153893.0 |
| 2022-06-29 13:00:00 | ES | Futures | 4320.46 | 4335.75 | 4310.83 | 4334.62 | 141334.0 |
| 2022-06-29 14:00:00 | ES | Futures | 4334.62 | 4344.82 | 4321.59 | 4326.12 | 135750.0 |
| 2022-06-29 15:00:00 | ES | Futures | 4326.12 | 4342.84 | 4319.61 | 4328.95 | 229855.0 |
| 2022-06-29 16:00:00 | ES | Futures | 4329.24 | 4333.2 | 4325.56 | 4331.79 | 48782.0 |
| 2022-06-29 18:00:00 | ES | Futures | 4331.5 | 4334.05 | 4328.39 | 4330.37 | 4602.0 |
| 2022-06-29 19:00:00 | ES | Futures | 4330.37 | 4330.65 | 4323.01 | 4325.27 | 4867.0 |
| 2022-06-29 20:00:00 | ES | Futures | 4324.99 | 4328.39 | 4317.06 | 4324.42 | 8028.0 |
| 2022-06-29 21:00:00 | ES | Futures | 4324.42 | 4324.42 | 4311.96 | 4313.37 | 9167.0 |
| 2022-06-29 22:00:00 | ES | Futures | 4313.09 | 4324.99 | 4313.09 | 4322.16 | 7016.0 |
| 2022-06-29 23:00:00 | ES | Futures | 4322.44 | 4324.14 | 4315.07 | 4317.06 | 5514.0 |
| 2022-06-29 00:00:00 | NQ | Futures | 13528.0 | 13558.95 | 13520.48 | 13548.25 | 4381.0 |
| 2022-06-29 01:00:00 | NQ | Futures | 13548.54 | 13563.58 | 13538.41 | 13544.49 | 4337.0 |
| 2022-06-29 02:00:00 | NQ | Futures | 13544.78 | 13554.03 | 13457.71 | 13468.13 | 8224.0 |
| 2022-06-29 03:00:00 | NQ | Futures | 13466.68 | 13524.53 | 13452.22 | 13496.76 | 12753.0 |
| 2022-06-29 04:00:00 | NQ | Futures | 13497.92 | 13540.44 | 13490.4 | 13515.85 | 8667.0 |
| 2022-06-29 05:00:00 | NQ | Futures | 13515.27 | 13532.63 | 13439.78 | 13446.14 | 9120.0 |
| 2022-06-29 06:00:00 | NQ | Futures | 13447.59 | 13483.46 | 13444.7 | 13463.5 | 9144.0 |
| 2022-06-29 07:00:00 | NQ | Futures | 13464.37 | 13530.02 | 13444.99 | 13523.95 | 9537.0 |
| 2022-06-29 08:00:00 | NQ | Futures | 13523.37 | 13562.71 | 13463.79 | 13489.24 | 22826.0 |
| 2022-06-29 09:00:00 | NQ | Futures | 13489.24 | 13557.79 | 13379.62 | 13522.79 | 100618.0 |
| 2022-06-29 10:00:00 | NQ | Futures | 13523.37 | 13593.08 | 13455.98 | 13526.26 | 99561.0 |
| 2022-06-29 11:00:00 | NQ | Futures | 13526.26 | 13556.06 | 13464.37 | 13528.0 | 60772.0 |
| 2022-06-29 12:00:00 | NQ | Futures | 13527.42 | 13532.92 | 13425.61 | 13480.85 | 54217.0 |
| 2022-06-29 13:00:00 | NQ | Futures | 13481.43 | 13528.87 | 13445.28 | 13525.97 | 40030.0 |
| 2022-06-29 14:00:00 | NQ | Futures | 13525.69 | 13568.78 | 13474.78 | 13489.82 | 40670.0 |
| 2022-06-29 15:00:00 | NQ | Futures | 13490.4 | 13559.53 | 13472.47 | 13523.08 | 56618.0 |
| 2022-06-29 16:00:00 | NQ | Futures | 13523.66 | 13532.05 | 13499.36 | 13525.97 | 11254.0 |
| 2022-06-29 18:00:00 | NQ | Futures | 13526.55 | 13532.63 | 13516.72 | 13524.82 | 2007.0 |
| 2022-06-29 19:00:00 | NQ | Futures | 13526.26 | 13526.84 | 13501.39 | 13510.36 | 1780.0 |
| 2022-06-29 20:00:00 | NQ | Futures | 13509.78 | 13522.79 | 13480.56 | 13508.33 | 3436.0 |
| 2022-06-29 21:00:00 | NQ | Futures | 13507.17 | 13507.17 | 13455.69 | 13467.26 | 5410.0 |
| 2022-06-29 22:00:00 | NQ | Futures | 13467.55 | 13507.46 | 13465.52 | 13497.92 | 3597.0 |
| 2022-06-29 23:00:00 | NQ | Futures | 13499.08 | 13505.15 | 13472.75 | 13481.43 | 2242.0 |
| 2022-06-29 00:00:00 | YM | Futures | 34955.0 | 34984.3 | 34933.5 | 34948.2 | 1208.0 |
| 2022-06-29 01:00:00 | YM | Futures | 34944.8 | 34971.9 | 34917.7 | 34938.0 | 1201.0 |
| 2022-06-29 02:00:00 | YM | Futures | 34936.9 | 34960.6 | 34821.8 | 34841.0 | 3346.0 |
| 2022-06-29 03:00:00 | YM | Futures | 34839.9 | 34961.7 | 34827.5 | 34882.7 | 4355.0 |
> showing 50 of 2,039 rows — these rows as CSV