PREVIEW / futures_1hour / 2022-07-06
file: by_date/futures_1hour/2022/2022-07-06.parquet size: 70 KB rows: 2,082
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-07-06 00:00:00 | ES | Futures | 4346.23 | 4346.23 | 4336.04 | 4338.02 | 5535.0 |
| 2022-07-06 01:00:00 | ES | Futures | 4338.02 | 4339.44 | 4325.84 | 4326.12 | 8661.0 |
| 2022-07-06 02:00:00 | ES | Futures | 4326.12 | 4338.02 | 4315.64 | 4337.17 | 19751.0 |
| 2022-07-06 03:00:00 | ES | Futures | 4336.89 | 4360.68 | 4336.6 | 4349.35 | 34790.0 |
| 2022-07-06 04:00:00 | ES | Futures | 4349.07 | 4352.47 | 4328.39 | 4330.37 | 21003.0 |
| 2022-07-06 05:00:00 | ES | Futures | 4330.37 | 4344.53 | 4325.27 | 4342.27 | 14665.0 |
| 2022-07-06 06:00:00 | ES | Futures | 4342.55 | 4348.5 | 4336.04 | 4339.15 | 11086.0 |
| 2022-07-06 07:00:00 | ES | Futures | 4338.87 | 4338.87 | 4324.99 | 4330.09 | 16266.0 |
| 2022-07-06 08:00:00 | ES | Futures | 4330.09 | 4348.5 | 4322.44 | 4341.7 | 39164.0 |
| 2022-07-06 09:00:00 | ES | Futures | 4341.7 | 4364.93 | 4332.35 | 4347.08 | 213362.0 |
| 2022-07-06 10:00:00 | ES | Futures | 4347.65 | 4362.95 | 4330.65 | 4341.42 | 259783.0 |
| 2022-07-06 11:00:00 | ES | Futures | 4341.7 | 4342.84 | 4318.76 | 4331.5 | 166830.0 |
| 2022-07-06 12:00:00 | ES | Futures | 4331.5 | 4335.75 | 4321.87 | 4334.34 | 92604.0 |
| 2022-07-06 13:00:00 | ES | Futures | 4334.34 | 4347.37 | 4333.77 | 4345.1 | 75213.0 |
| 2022-07-06 14:00:00 | ES | Futures | 4345.1 | 4381.64 | 4330.94 | 4375.41 | 282608.0 |
| 2022-07-06 15:00:00 | ES | Futures | 4375.69 | 4390.71 | 4352.18 | 4361.81 | 268524.0 |
| 2022-07-06 16:00:00 | ES | Futures | 4361.53 | 4366.91 | 4360.11 | 4366.91 | 46080.0 |
| 2022-07-06 18:00:00 | ES | Futures | 4366.63 | 4368.05 | 4361.81 | 4362.66 | 4311.0 |
| 2022-07-06 19:00:00 | ES | Futures | 4362.95 | 4367.48 | 4360.96 | 4364.65 | 3879.0 |
| 2022-07-06 20:00:00 | ES | Futures | 4364.65 | 4364.65 | 4352.47 | 4358.42 | 11116.0 |
| 2022-07-06 21:00:00 | ES | Futures | 4358.42 | 4358.7 | 4342.55 | 4350.2 | 13466.0 |
| 2022-07-06 22:00:00 | ES | Futures | 4350.2 | 4367.2 | 4350.2 | 4366.63 | 9056.0 |
| 2022-07-06 23:00:00 | ES | Futures | 4366.63 | 4368.05 | 4361.53 | 4361.81 | 6770.0 |
| 2022-07-06 00:00:00 | NQ | Futures | 13679.27 | 13680.72 | 13644.56 | 13649.48 | 3250.0 |
| 2022-07-06 01:00:00 | NQ | Futures | 13650.64 | 13657.29 | 13608.12 | 13609.28 | 4906.0 |
| 2022-07-06 02:00:00 | NQ | Futures | 13608.99 | 13648.03 | 13572.25 | 13646.3 | 9106.0 |
| 2022-07-06 03:00:00 | NQ | Futures | 13645.14 | 13726.42 | 13644.56 | 13689.97 | 15326.0 |
| 2022-07-06 04:00:00 | NQ | Futures | 13689.97 | 13698.36 | 13607.25 | 13617.66 | 11507.0 |
| 2022-07-06 05:00:00 | NQ | Futures | 13617.66 | 13663.94 | 13599.44 | 13656.71 | 8022.0 |
| 2022-07-06 06:00:00 | NQ | Futures | 13657.58 | 13676.09 | 13626.63 | 13639.36 | 6425.0 |
| 2022-07-06 07:00:00 | NQ | Futures | 13639.36 | 13639.36 | 13584.11 | 13600.89 | 8971.0 |
| 2022-07-06 08:00:00 | NQ | Futures | 13601.76 | 13679.56 | 13568.49 | 13661.63 | 20097.0 |
| 2022-07-06 09:00:00 | NQ | Futures | 13662.21 | 13747.53 | 13598.86 | 13712.24 | 95935.0 |
| 2022-07-06 10:00:00 | NQ | Futures | 13712.82 | 13740.3 | 13618.53 | 13704.72 | 109747.0 |
| 2022-07-06 11:00:00 | NQ | Futures | 13705.59 | 13719.19 | 13598.0 | 13646.88 | 65233.0 |
| 2022-07-06 12:00:00 | NQ | Futures | 13647.17 | 13681.59 | 13625.47 | 13677.54 | 34022.0 |
| 2022-07-06 13:00:00 | NQ | Futures | 13678.11 | 13718.9 | 13676.67 | 13709.06 | 29051.0 |
| 2022-07-06 14:00:00 | NQ | Futures | 13709.64 | 13820.42 | 13642.54 | 13811.74 | 99362.0 |
| 2022-07-06 15:00:00 | NQ | Futures | 13812.03 | 13853.68 | 13707.62 | 13751.58 | 71153.0 |
| 2022-07-06 16:00:00 | NQ | Futures | 13751.58 | 13775.59 | 13744.93 | 13770.67 | 12688.0 |
| 2022-07-06 18:00:00 | NQ | Futures | 13769.22 | 13780.51 | 13751.29 | 13754.47 | 2650.0 |
| 2022-07-06 19:00:00 | NQ | Futures | 13754.76 | 13773.56 | 13746.95 | 13765.75 | 2312.0 |
| 2022-07-06 20:00:00 | NQ | Futures | 13764.89 | 13767.78 | 13724.97 | 13749.85 | 6100.0 |
| 2022-07-06 21:00:00 | NQ | Futures | 13749.27 | 13750.14 | 13694.31 | 13722.66 | 7133.0 |
| 2022-07-06 22:00:00 | NQ | Futures | 13723.81 | 13776.46 | 13722.95 | 13773.85 | 6111.0 |
| 2022-07-06 23:00:00 | NQ | Futures | 13773.85 | 13780.22 | 13756.21 | 13758.81 | 4207.0 |
| 2022-07-06 00:00:00 | YM | Futures | 34907.6 | 34907.6 | 34837.6 | 34847.8 | 789.0 |
| 2022-07-06 01:00:00 | YM | Futures | 34853.4 | 34864.7 | 34759.8 | 34760.9 | 1606.0 |
| 2022-07-06 02:00:00 | YM | Futures | 34762.0 | 34847.8 | 34684.2 | 34842.1 | 3201.0 |
| 2022-07-06 03:00:00 | YM | Futures | 34842.1 | 35003.5 | 34841.0 | 34939.2 | 5293.0 |
> showing 50 of 2,082 rows — these rows as CSV