PREVIEW / futures_1hour / 2022-07-11
file: by_date/futures_1hour/2022/2022-07-11.parquet size: 68 KB rows: 2,020
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-11 00:00:00 | ES | Futures | 4393.54 | 4396.66 | 4391.27 | 4392.12 | 4385.0 |
| 2022-07-11 01:00:00 | ES | Futures | 4391.84 | 4395.24 | 4387.31 | 4389.01 | 5679.0 |
| 2022-07-11 02:00:00 | ES | Futures | 4389.01 | 4392.97 | 4377.68 | 4381.36 | 15401.0 |
| 2022-07-11 03:00:00 | ES | Futures | 4381.36 | 4394.67 | 4377.68 | 4387.88 | 19041.0 |
| 2022-07-11 04:00:00 | ES | Futures | 4387.88 | 4397.22 | 4385.89 | 4392.97 | 13169.0 |
| 2022-07-11 05:00:00 | ES | Futures | 4392.97 | 4400.34 | 4390.42 | 4393.26 | 10695.0 |
| 2022-07-11 06:00:00 | ES | Futures | 4393.26 | 4403.74 | 4390.99 | 4396.94 | 14788.0 |
| 2022-07-11 07:00:00 | ES | Futures | 4396.94 | 4401.76 | 4386.74 | 4389.01 | 11387.0 |
| 2022-07-11 08:00:00 | ES | Futures | 4389.01 | 4395.52 | 4384.48 | 4390.99 | 24222.0 |
| 2022-07-11 09:00:00 | ES | Futures | 4390.99 | 4400.91 | 4364.08 | 4375.13 | 231454.0 |
| 2022-07-11 10:00:00 | ES | Futures | 4374.84 | 4385.04 | 4363.8 | 4368.61 | 250732.0 |
| 2022-07-11 11:00:00 | ES | Futures | 4368.9 | 4383.34 | 4367.48 | 4374.28 | 153056.0 |
| 2022-07-11 12:00:00 | ES | Futures | 4374.0 | 4382.21 | 4370.31 | 4379.38 | 93694.0 |
| 2022-07-11 13:00:00 | ES | Futures | 4379.38 | 4400.06 | 4377.96 | 4395.52 | 111409.0 |
| 2022-07-11 14:00:00 | ES | Futures | 4395.52 | 4396.09 | 4374.28 | 4374.56 | 119928.0 |
| 2022-07-11 15:00:00 | ES | Futures | 4374.28 | 4376.54 | 4362.38 | 4371.16 | 257392.0 |
| 2022-07-11 16:00:00 | ES | Futures | 4371.45 | 4378.24 | 4370.6 | 4375.98 | 50932.0 |
| 2022-07-11 18:00:00 | ES | Futures | 4375.98 | 4375.98 | 4367.48 | 4368.9 | 4836.0 |
| 2022-07-11 19:00:00 | ES | Futures | 4369.18 | 4378.24 | 4368.33 | 4377.68 | 4499.0 |
| 2022-07-11 20:00:00 | ES | Futures | 4377.68 | 4379.38 | 4347.65 | 4348.5 | 17179.0 |
| 2022-07-11 21:00:00 | ES | Futures | 4348.78 | 4354.17 | 4345.38 | 4350.48 | 12673.0 |
| 2022-07-11 22:00:00 | ES | Futures | 4350.2 | 4353.32 | 4346.52 | 4348.5 | 5671.0 |
| 2022-07-11 23:00:00 | ES | Futures | 4348.78 | 4349.63 | 4341.14 | 4348.22 | 6857.0 |
| 2022-07-11 00:00:00 | NQ | Futures | 13940.45 | 13945.95 | 13921.94 | 13925.99 | 3555.0 |
| 2022-07-11 01:00:00 | NQ | Futures | 13925.41 | 13936.41 | 13907.77 | 13916.74 | 4066.0 |
| 2022-07-11 02:00:00 | NQ | Futures | 13916.74 | 13931.2 | 13879.42 | 13906.9 | 8757.0 |
| 2022-07-11 03:00:00 | NQ | Futures | 13908.35 | 13959.83 | 13888.1 | 13934.09 | 11783.0 |
| 2022-07-11 04:00:00 | NQ | Futures | 13934.38 | 13971.4 | 13927.15 | 13950.0 | 8842.0 |
| 2022-07-11 05:00:00 | NQ | Futures | 13950.0 | 13972.56 | 13941.32 | 13943.64 | 5601.0 |
| 2022-07-11 06:00:00 | NQ | Futures | 13942.77 | 13982.68 | 13935.54 | 13958.39 | 6655.0 |
| 2022-07-11 07:00:00 | NQ | Futures | 13958.68 | 13976.03 | 13926.57 | 13934.67 | 5953.0 |
| 2022-07-11 08:00:00 | NQ | Futures | 13934.38 | 13966.49 | 13927.73 | 13962.73 | 12326.0 |
| 2022-07-11 09:00:00 | NQ | Futures | 13962.73 | 13971.4 | 13716.58 | 13749.85 | 98420.0 |
| 2022-07-11 10:00:00 | NQ | Futures | 13750.14 | 13846.16 | 13713.4 | 13777.61 | 93296.0 |
| 2022-07-11 11:00:00 | NQ | Futures | 13777.61 | 13837.2 | 13764.6 | 13786.87 | 60945.0 |
| 2022-07-11 12:00:00 | NQ | Futures | 13787.16 | 13821.58 | 13769.22 | 13803.07 | 36554.0 |
| 2022-07-11 13:00:00 | NQ | Futures | 13802.49 | 13888.97 | 13799.31 | 13866.12 | 47149.0 |
| 2022-07-11 14:00:00 | NQ | Futures | 13866.41 | 13869.01 | 13774.43 | 13774.43 | 46898.0 |
| 2022-07-11 15:00:00 | NQ | Futures | 13774.43 | 13783.11 | 13719.19 | 13757.37 | 71718.0 |
| 2022-07-11 16:00:00 | NQ | Futures | 13757.37 | 13786.87 | 13756.5 | 13768.36 | 13402.0 |
| 2022-07-11 18:00:00 | NQ | Futures | 13768.36 | 13771.25 | 13740.59 | 13744.93 | 3285.0 |
| 2022-07-11 19:00:00 | NQ | Futures | 13745.51 | 13774.43 | 13743.77 | 13771.83 | 2560.0 |
| 2022-07-11 20:00:00 | NQ | Futures | 13772.12 | 13778.48 | 13662.78 | 13668.57 | 8865.0 |
| 2022-07-11 21:00:00 | NQ | Futures | 13668.86 | 13692.58 | 13658.16 | 13678.98 | 7865.0 |
| 2022-07-11 22:00:00 | NQ | Futures | 13678.69 | 13690.84 | 13661.05 | 13671.46 | 4118.0 |
| 2022-07-11 23:00:00 | NQ | Futures | 13672.04 | 13673.78 | 13638.78 | 13669.73 | 4769.0 |
| 2022-07-11 00:00:00 | YM | Futures | 35160.3 | 35189.7 | 35150.2 | 35158.1 | 749.0 |
| 2022-07-11 01:00:00 | YM | Futures | 35155.8 | 35180.6 | 35123.1 | 35131.0 | 954.0 |
| 2022-07-11 02:00:00 | YM | Futures | 35133.2 | 35160.3 | 35043.0 | 35055.4 | 3024.0 |
| 2022-07-11 03:00:00 | YM | Futures | 35057.6 | 35142.3 | 35023.8 | 35098.3 | 2914.0 |
> showing 50 of 2,020 rows — these rows as CSV