PREVIEW / futures_1hour / 2022-09-19
file: by_date/futures_1hour/2022/2022-09-19.parquet size: 64 KB rows: 1,930
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-09-19 00:00:00 | ES | Futures | 4377.24 | 4379.22 | 4373.86 | 4378.09 | 3274.0 |
| 2022-09-19 01:00:00 | ES | Futures | 4378.09 | 4380.63 | 4369.35 | 4369.63 | 6381.0 |
| 2022-09-19 02:00:00 | ES | Futures | 4369.63 | 4370.2 | 4358.36 | 4368.79 | 15869.0 |
| 2022-09-19 03:00:00 | ES | Futures | 4368.51 | 4368.51 | 4353.28 | 4353.85 | 23339.0 |
| 2022-09-19 04:00:00 | ES | Futures | 4354.13 | 4363.15 | 4347.08 | 4348.49 | 19168.0 |
| 2022-09-19 05:00:00 | ES | Futures | 4348.49 | 4354.13 | 4341.44 | 4345.95 | 16275.0 |
| 2022-09-19 06:00:00 | ES | Futures | 4345.95 | 4349.9 | 4336.93 | 4349.62 | 20975.0 |
| 2022-09-19 07:00:00 | ES | Futures | 4349.62 | 4355.82 | 4342.29 | 4342.85 | 20901.0 |
| 2022-09-19 08:00:00 | ES | Futures | 4343.13 | 4360.61 | 4342.29 | 4355.54 | 37771.0 |
| 2022-09-19 09:00:00 | ES | Futures | 4355.54 | 4382.6 | 4344.83 | 4375.27 | 231560.0 |
| 2022-09-19 10:00:00 | ES | Futures | 4375.55 | 4401.77 | 4365.97 | 4390.77 | 335809.0 |
| 2022-09-19 11:00:00 | ES | Futures | 4391.06 | 4400.64 | 4367.66 | 4371.61 | 261277.0 |
| 2022-09-19 12:00:00 | ES | Futures | 4371.61 | 4392.47 | 4364.28 | 4389.93 | 192632.0 |
| 2022-09-19 13:00:00 | ES | Futures | 4390.21 | 4391.62 | 4377.24 | 4382.32 | 163365.0 |
| 2022-09-19 14:00:00 | ES | Futures | 4382.32 | 4387.96 | 4373.58 | 4387.11 | 220329.0 |
| 2022-09-19 15:00:00 | ES | Futures | 4387.39 | 4418.68 | 4387.11 | 4418.68 | 356497.0 |
| 2022-09-19 16:00:00 | ES | Futures | 4418.4 | 4427.98 | 4416.15 | 4423.19 | 64524.0 |
| 2022-09-19 18:00:00 | ES | Futures | 4423.47 | 4429.39 | 4421.78 | 4424.88 | 5872.0 |
| 2022-09-19 19:00:00 | ES | Futures | 4424.88 | 4432.78 | 4424.04 | 4432.78 | 6614.0 |
| 2022-09-19 20:00:00 | ES | Futures | 4432.49 | 4436.44 | 4423.76 | 4426.29 | 13425.0 |
| 2022-09-19 21:00:00 | ES | Futures | 4426.29 | 4426.29 | 4419.25 | 4423.76 | 11280.0 |
| 2022-09-19 22:00:00 | ES | Futures | 4423.76 | 4426.29 | 4421.5 | 4425.45 | 4535.0 |
| 2022-09-19 23:00:00 | ES | Futures | 4425.45 | 4427.98 | 4423.76 | 4427.14 | 4232.0 |
| 2022-09-19 00:00:00 | NQ | Futures | 13657.75 | 13662.35 | 13642.23 | 13654.01 | 2721.0 |
| 2022-09-19 01:00:00 | NQ | Futures | 13654.88 | 13666.37 | 13625.86 | 13627.29 | 3534.0 |
| 2022-09-19 02:00:00 | NQ | Futures | 13627.0 | 13635.34 | 13589.37 | 13632.46 | 8653.0 |
| 2022-09-19 03:00:00 | NQ | Futures | 13631.6 | 13633.04 | 13579.31 | 13593.1 | 11970.0 |
| 2022-09-19 04:00:00 | NQ | Futures | 13593.1 | 13629.59 | 13574.14 | 13579.31 | 10376.0 |
| 2022-09-19 05:00:00 | NQ | Futures | 13579.6 | 13598.56 | 13563.51 | 13582.47 | 8656.0 |
| 2022-09-19 06:00:00 | NQ | Futures | 13582.18 | 13596.26 | 13552.87 | 13595.4 | 9917.0 |
| 2022-09-19 07:00:00 | NQ | Futures | 13594.82 | 13608.04 | 13567.53 | 13568.68 | 10829.0 |
| 2022-09-19 08:00:00 | NQ | Futures | 13569.25 | 13638.79 | 13567.24 | 13617.24 | 16858.0 |
| 2022-09-19 09:00:00 | NQ | Futures | 13617.81 | 13712.05 | 13578.73 | 13693.38 | 77003.0 |
| 2022-09-19 10:00:00 | NQ | Futures | 13693.66 | 13762.34 | 13642.81 | 13729.58 | 101347.0 |
| 2022-09-19 11:00:00 | NQ | Futures | 13730.15 | 13766.93 | 13641.08 | 13649.7 | 76041.0 |
| 2022-09-19 12:00:00 | NQ | Futures | 13649.7 | 13736.48 | 13617.81 | 13725.27 | 56269.0 |
| 2022-09-19 13:00:00 | NQ | Futures | 13725.84 | 13732.17 | 13679.01 | 13697.4 | 46366.0 |
| 2022-09-19 14:00:00 | NQ | Futures | 13697.69 | 13732.17 | 13673.84 | 13729.58 | 50057.0 |
| 2022-09-19 15:00:00 | NQ | Futures | 13729.87 | 13826.98 | 13729.01 | 13822.39 | 85899.0 |
| 2022-09-19 16:00:00 | NQ | Futures | 13822.67 | 13867.78 | 13814.05 | 13843.94 | 16728.0 |
| 2022-09-19 18:00:00 | NQ | Futures | 13844.22 | 13865.77 | 13839.05 | 13850.54 | 2874.0 |
| 2022-09-19 19:00:00 | NQ | Futures | 13850.54 | 13881.58 | 13848.25 | 13881.29 | 3638.0 |
| 2022-09-19 20:00:00 | NQ | Futures | 13880.71 | 13897.95 | 13852.56 | 13862.04 | 7231.0 |
| 2022-09-19 21:00:00 | NQ | Futures | 13861.18 | 13862.61 | 13829.28 | 13847.38 | 5913.0 |
| 2022-09-19 22:00:00 | NQ | Futures | 13847.1 | 13858.3 | 13838.19 | 13852.56 | 3362.0 |
| 2022-09-19 23:00:00 | NQ | Futures | 13852.84 | 13859.45 | 13843.65 | 13856.58 | 2190.0 |
| 2022-09-19 00:00:00 | YM | Futures | 34655.7 | 34666.9 | 34632.1 | 34659.1 | 451.0 |
| 2022-09-19 01:00:00 | YM | Futures | 34660.2 | 34675.9 | 34600.7 | 34600.7 | 854.0 |
| 2022-09-19 02:00:00 | YM | Futures | 34599.6 | 34599.6 | 34525.5 | 34582.8 | 2009.0 |
| 2022-09-19 03:00:00 | YM | Futures | 34579.4 | 34579.4 | 34459.3 | 34463.8 | 3388.0 |
> showing 50 of 1,930 rows — these rows as CSV