PREVIEW / futures_1hour / 2022-08-16
file: by_date/futures_1hour/2022/2022-08-16.parquet size: 66 KB rows: 2,034
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-08-16 00:00:00 | ES | Futures | 4865.19 | 4867.45 | 4864.34 | 4866.6 | 2333.0 |
| 2022-08-16 01:00:00 | ES | Futures | 4866.89 | 4868.59 | 4862.07 | 4867.45 | 3690.0 |
| 2022-08-16 02:00:00 | ES | Futures | 4867.45 | 4867.45 | 4859.52 | 4859.81 | 6832.0 |
| 2022-08-16 03:00:00 | ES | Futures | 4859.52 | 4864.9 | 4855.27 | 4864.34 | 15026.0 |
| 2022-08-16 04:00:00 | ES | Futures | 4864.34 | 4871.14 | 4861.79 | 4867.17 | 12757.0 |
| 2022-08-16 05:00:00 | ES | Futures | 4867.45 | 4868.3 | 4858.67 | 4862.92 | 9753.0 |
| 2022-08-16 06:00:00 | ES | Futures | 4862.92 | 4863.2 | 4857.26 | 4859.81 | 8662.0 |
| 2022-08-16 07:00:00 | ES | Futures | 4859.52 | 4868.87 | 4857.26 | 4866.6 | 15540.0 |
| 2022-08-16 08:00:00 | ES | Futures | 4866.6 | 4869.72 | 4853.86 | 4858.39 | 26818.0 |
| 2022-08-16 09:00:00 | ES | Futures | 4858.11 | 4869.72 | 4855.84 | 4865.75 | 153243.0 |
| 2022-08-16 10:00:00 | ES | Futures | 4865.47 | 4866.89 | 4848.19 | 4855.27 | 201163.0 |
| 2022-08-16 11:00:00 | ES | Futures | 4855.56 | 4888.13 | 4854.42 | 4885.87 | 162317.0 |
| 2022-08-16 12:00:00 | ES | Futures | 4885.87 | 4889.83 | 4879.63 | 4881.62 | 99210.0 |
| 2022-08-16 13:00:00 | ES | Futures | 4881.9 | 4896.06 | 4879.92 | 4894.93 | 91610.0 |
| 2022-08-16 14:00:00 | ES | Futures | 4895.21 | 4903.43 | 4862.64 | 4873.69 | 198886.0 |
| 2022-08-16 15:00:00 | ES | Futures | 4873.69 | 4888.7 | 4865.19 | 4880.2 | 224319.0 |
| 2022-08-16 16:00:00 | ES | Futures | 4880.2 | 4884.17 | 4874.54 | 4883.88 | 51036.0 |
| 2022-08-16 18:00:00 | ES | Futures | 4882.75 | 4883.03 | 4877.09 | 4879.07 | 5272.0 |
| 2022-08-16 19:00:00 | ES | Futures | 4879.07 | 4882.18 | 4876.24 | 4880.77 | 5019.0 |
| 2022-08-16 20:00:00 | ES | Futures | 4880.48 | 4886.43 | 4877.94 | 4881.33 | 7633.0 |
| 2022-08-16 21:00:00 | ES | Futures | 4881.33 | 4881.62 | 4876.8 | 4880.77 | 6299.0 |
| 2022-08-16 22:00:00 | ES | Futures | 4880.77 | 4882.75 | 4878.22 | 4879.63 | 3797.0 |
| 2022-08-16 23:00:00 | ES | Futures | 4879.92 | 4881.05 | 4878.5 | 4880.48 | 2442.0 |
| 2022-08-16 00:00:00 | NQ | Futures | 15807.78 | 15823.69 | 15806.91 | 15816.17 | 1319.0 |
| 2022-08-16 01:00:00 | NQ | Futures | 15816.17 | 15819.06 | 15799.68 | 15816.75 | 1682.0 |
| 2022-08-16 02:00:00 | NQ | Futures | 15815.59 | 15818.19 | 15791.01 | 15791.58 | 2446.0 |
| 2022-08-16 03:00:00 | NQ | Futures | 15791.3 | 15798.82 | 15765.26 | 15797.08 | 6667.0 |
| 2022-08-16 04:00:00 | NQ | Futures | 15796.5 | 15836.42 | 15790.72 | 15822.24 | 7545.0 |
| 2022-08-16 05:00:00 | NQ | Futures | 15821.67 | 15825.14 | 15786.38 | 15797.95 | 5258.0 |
| 2022-08-16 06:00:00 | NQ | Futures | 15797.66 | 15803.44 | 15780.88 | 15798.53 | 4221.0 |
| 2022-08-16 07:00:00 | NQ | Futures | 15797.66 | 15824.85 | 15787.53 | 15808.94 | 6359.0 |
| 2022-08-16 08:00:00 | NQ | Futures | 15809.81 | 15829.19 | 15767.87 | 15789.85 | 12702.0 |
| 2022-08-16 09:00:00 | NQ | Futures | 15789.27 | 15803.15 | 15714.94 | 15748.2 | 69799.0 |
| 2022-08-16 10:00:00 | NQ | Futures | 15748.49 | 15750.22 | 15645.23 | 15684.86 | 95594.0 |
| 2022-08-16 11:00:00 | NQ | Futures | 15685.14 | 15828.61 | 15679.36 | 15819.64 | 72916.0 |
| 2022-08-16 12:00:00 | NQ | Futures | 15819.93 | 15832.08 | 15771.05 | 15792.16 | 50096.0 |
| 2022-08-16 13:00:00 | NQ | Futures | 15792.45 | 15852.9 | 15788.11 | 15848.28 | 39674.0 |
| 2022-08-16 14:00:00 | NQ | Futures | 15848.56 | 15897.45 | 15712.62 | 15759.19 | 75877.0 |
| 2022-08-16 15:00:00 | NQ | Futures | 15758.32 | 15837.57 | 15725.93 | 15796.79 | 72632.0 |
| 2022-08-16 16:00:00 | NQ | Futures | 15797.08 | 15808.94 | 15780.88 | 15808.07 | 11535.0 |
| 2022-08-16 18:00:00 | NQ | Futures | 15801.71 | 15806.05 | 15784.06 | 15789.56 | 2266.0 |
| 2022-08-16 19:00:00 | NQ | Futures | 15788.11 | 15800.84 | 15780.3 | 15794.19 | 2045.0 |
| 2022-08-16 20:00:00 | NQ | Futures | 15794.19 | 15816.75 | 15785.22 | 15798.53 | 3693.0 |
| 2022-08-16 21:00:00 | NQ | Futures | 15798.53 | 15799.1 | 15778.28 | 15793.9 | 3636.0 |
| 2022-08-16 22:00:00 | NQ | Futures | 15793.61 | 15795.92 | 15780.59 | 15784.93 | 2059.0 |
| 2022-08-16 23:00:00 | NQ | Futures | 15786.09 | 15791.87 | 15782.04 | 15788.11 | 1443.0 |
| 2022-08-16 00:00:00 | YM | Futures | 38220.4 | 38232.8 | 38211.4 | 38228.3 | 422.0 |
| 2022-08-16 01:00:00 | YM | Futures | 38227.2 | 38233.9 | 38195.6 | 38231.7 | 615.0 |
| 2022-08-16 02:00:00 | YM | Futures | 38230.5 | 38231.7 | 38178.6 | 38180.9 | 1213.0 |
| 2022-08-16 03:00:00 | YM | Futures | 38179.8 | 38224.9 | 38156.1 | 38222.6 | 2712.0 |
> showing 50 of 2,034 rows — these rows as CSV