PREVIEW / futures_1hour / 2022-07-05
file: by_date/futures_1hour/2022/2022-07-05.parquet size: 69 KB rows: 2,012
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-05 00:00:00 | ES | Futures | 4347.08 | 4354.45 | 4347.08 | 4354.45 | 3825.0 |
| 2022-07-05 01:00:00 | ES | Futures | 4354.45 | 4358.7 | 4351.05 | 4355.02 | 5735.0 |
| 2022-07-05 02:00:00 | ES | Futures | 4354.73 | 4362.1 | 4353.32 | 4356.43 | 9370.0 |
| 2022-07-05 03:00:00 | ES | Futures | 4356.15 | 4356.43 | 4340.29 | 4340.57 | 19021.0 |
| 2022-07-05 04:00:00 | ES | Futures | 4340.57 | 4346.52 | 4310.26 | 4311.68 | 31359.0 |
| 2022-07-05 05:00:00 | ES | Futures | 4311.96 | 4316.77 | 4305.73 | 4315.64 | 22558.0 |
| 2022-07-05 06:00:00 | ES | Futures | 4315.07 | 4322.16 | 4313.66 | 4317.34 | 14086.0 |
| 2022-07-05 07:00:00 | ES | Futures | 4317.34 | 4319.32 | 4298.08 | 4299.78 | 22721.0 |
| 2022-07-05 08:00:00 | ES | Futures | 4300.06 | 4300.63 | 4276.83 | 4278.53 | 62163.0 |
| 2022-07-05 09:00:00 | ES | Futures | 4278.53 | 4284.2 | 4246.24 | 4253.04 | 253595.0 |
| 2022-07-05 10:00:00 | ES | Futures | 4252.75 | 4280.52 | 4242.27 | 4256.15 | 319447.0 |
| 2022-07-05 11:00:00 | ES | Futures | 4256.15 | 4275.13 | 4243.97 | 4268.9 | 200834.0 |
| 2022-07-05 12:00:00 | ES | Futures | 4269.18 | 4290.43 | 4264.65 | 4271.17 | 168854.0 |
| 2022-07-05 13:00:00 | ES | Futures | 4271.17 | 4301.19 | 4270.03 | 4294.4 | 130544.0 |
| 2022-07-05 14:00:00 | ES | Futures | 4294.68 | 4329.24 | 4291.85 | 4322.16 | 167353.0 |
| 2022-07-05 15:00:00 | ES | Futures | 4322.16 | 4346.23 | 4315.07 | 4345.95 | 272939.0 |
| 2022-07-05 16:00:00 | ES | Futures | 4345.67 | 4346.23 | 4338.02 | 4343.97 | 55183.0 |
| 2022-07-05 18:00:00 | ES | Futures | 4348.78 | 4354.17 | 4341.7 | 4344.53 | 8796.0 |
| 2022-07-05 19:00:00 | ES | Futures | 4344.25 | 4347.08 | 4332.07 | 4334.62 | 7233.0 |
| 2022-07-05 20:00:00 | ES | Futures | 4334.62 | 4356.72 | 4334.62 | 4353.88 | 14058.0 |
| 2022-07-05 21:00:00 | ES | Futures | 4354.17 | 4360.96 | 4334.34 | 4339.44 | 16358.0 |
| 2022-07-05 22:00:00 | ES | Futures | 4339.72 | 4344.82 | 4330.37 | 4334.62 | 9782.0 |
| 2022-07-05 23:00:00 | ES | Futures | 4334.62 | 4347.93 | 4331.79 | 4345.95 | 7688.0 |
| 2022-07-05 00:00:00 | NQ | Futures | 13483.46 | 13508.62 | 13482.01 | 13507.46 | 2751.0 |
| 2022-07-05 01:00:00 | NQ | Futures | 13505.73 | 13522.21 | 13493.87 | 13508.33 | 3511.0 |
| 2022-07-05 02:00:00 | NQ | Futures | 13507.46 | 13541.02 | 13501.1 | 13516.14 | 4858.0 |
| 2022-07-05 03:00:00 | NQ | Futures | 13515.27 | 13517.01 | 13457.43 | 13458.87 | 9827.0 |
| 2022-07-05 04:00:00 | NQ | Futures | 13459.74 | 13478.83 | 13330.74 | 13336.23 | 18237.0 |
| 2022-07-05 05:00:00 | NQ | Futures | 13337.39 | 13353.59 | 13312.52 | 13347.51 | 11684.0 |
| 2022-07-05 06:00:00 | NQ | Futures | 13346.07 | 13375.57 | 13341.73 | 13355.32 | 7498.0 |
| 2022-07-05 07:00:00 | NQ | Futures | 13355.9 | 13362.84 | 13283.88 | 13288.8 | 10037.0 |
| 2022-07-05 08:00:00 | NQ | Futures | 13289.67 | 13294.58 | 13226.32 | 13235.58 | 24438.0 |
| 2022-07-05 09:00:00 | NQ | Futures | 13235.0 | 13288.22 | 13176.86 | 13245.41 | 99069.0 |
| 2022-07-05 10:00:00 | NQ | Futures | 13245.12 | 13431.68 | 13195.37 | 13340.28 | 123304.0 |
| 2022-07-05 11:00:00 | NQ | Futures | 13339.13 | 13406.81 | 13267.68 | 13387.43 | 81529.0 |
| 2022-07-05 12:00:00 | NQ | Futures | 13387.72 | 13475.36 | 13357.35 | 13401.89 | 67992.0 |
| 2022-07-05 13:00:00 | NQ | Futures | 13402.18 | 13539.86 | 13397.84 | 13507.46 | 53066.0 |
| 2022-07-05 14:00:00 | NQ | Futures | 13507.17 | 13632.13 | 13485.48 | 13601.18 | 61732.0 |
| 2022-07-05 15:00:00 | NQ | Futures | 13602.04 | 13669.15 | 13570.81 | 13667.41 | 77096.0 |
| 2022-07-05 16:00:00 | NQ | Futures | 13666.83 | 13670.31 | 13645.14 | 13665.39 | 13070.0 |
| 2022-07-05 18:00:00 | NQ | Futures | 13675.51 | 13696.05 | 13656.13 | 13664.81 | 4963.0 |
| 2022-07-05 19:00:00 | NQ | Futures | 13664.52 | 13672.04 | 13622.87 | 13633.28 | 4496.0 |
| 2022-07-05 20:00:00 | NQ | Futures | 13633.28 | 13722.66 | 13632.13 | 13710.51 | 8190.0 |
| 2022-07-05 21:00:00 | NQ | Futures | 13710.51 | 13737.41 | 13639.94 | 13658.16 | 9788.0 |
| 2022-07-05 22:00:00 | NQ | Futures | 13657.58 | 13676.38 | 13626.05 | 13643.41 | 5374.0 |
| 2022-07-05 23:00:00 | NQ | Futures | 13643.7 | 13683.32 | 13630.68 | 13679.27 | 4298.0 |
| 2022-07-05 00:00:00 | YM | Futures | 35107.3 | 35163.7 | 35107.3 | 35158.1 | 545.0 |
| 2022-07-05 01:00:00 | YM | Futures | 35164.8 | 35197.5 | 35138.9 | 35173.9 | 885.0 |
| 2022-07-05 02:00:00 | YM | Futures | 35163.7 | 35214.5 | 35155.8 | 35178.4 | 1489.0 |
| 2022-07-05 03:00:00 | YM | Futures | 35173.9 | 35177.2 | 35059.9 | 35063.3 | 2645.0 |
> showing 50 of 2,012 rows — these rows as CSV