PREVIEW / futures_1hour / 2022-07-13
file: by_date/futures_1hour/2022/2022-07-13.parquet size: 70 KB rows: 2,051
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-13 00:00:00 | ES | Futures | 4340.0 | 4340.57 | 4336.89 | 4338.3 | 4015.0 |
| 2022-07-13 01:00:00 | ES | Futures | 4338.02 | 4340.0 | 4334.62 | 4338.3 | 7539.0 |
| 2022-07-13 02:00:00 | ES | Futures | 4338.59 | 4349.63 | 4332.92 | 4346.8 | 14936.0 |
| 2022-07-13 03:00:00 | ES | Futures | 4347.08 | 4347.37 | 4329.52 | 4331.22 | 19519.0 |
| 2022-07-13 04:00:00 | ES | Futures | 4331.22 | 4347.93 | 4326.69 | 4347.08 | 14619.0 |
| 2022-07-13 05:00:00 | ES | Futures | 4347.08 | 4347.65 | 4340.85 | 4342.27 | 9354.0 |
| 2022-07-13 06:00:00 | ES | Futures | 4342.27 | 4343.4 | 4335.47 | 4341.42 | 9223.0 |
| 2022-07-13 07:00:00 | ES | Futures | 4341.42 | 4349.07 | 4338.3 | 4347.08 | 14505.0 |
| 2022-07-13 08:00:00 | ES | Futures | 4346.8 | 4388.44 | 4251.34 | 4272.3 | 210269.0 |
| 2022-07-13 09:00:00 | ES | Futures | 4272.3 | 4301.19 | 4260.97 | 4294.68 | 340281.0 |
| 2022-07-13 10:00:00 | ES | Futures | 4294.68 | 4324.71 | 4265.79 | 4317.62 | 387842.0 |
| 2022-07-13 11:00:00 | ES | Futures | 4317.62 | 4332.64 | 4299.49 | 4308.28 | 209233.0 |
| 2022-07-13 12:00:00 | ES | Futures | 4308.56 | 4332.07 | 4306.58 | 4331.79 | 135126.0 |
| 2022-07-13 13:00:00 | ES | Futures | 4332.07 | 4345.1 | 4321.59 | 4332.35 | 148846.0 |
| 2022-07-13 14:00:00 | ES | Futures | 4332.35 | 4339.15 | 4306.01 | 4339.15 | 240193.0 |
| 2022-07-13 15:00:00 | ES | Futures | 4339.15 | 4339.72 | 4309.13 | 4309.13 | 225361.0 |
| 2022-07-13 16:00:00 | ES | Futures | 4309.41 | 4311.39 | 4299.78 | 4301.19 | 55687.0 |
| 2022-07-13 18:00:00 | ES | Futures | 4300.91 | 4301.76 | 4286.46 | 4290.43 | 9374.0 |
| 2022-07-13 19:00:00 | ES | Futures | 4290.15 | 4295.81 | 4277.97 | 4281.65 | 10135.0 |
| 2022-07-13 20:00:00 | ES | Futures | 4281.65 | 4292.7 | 4278.53 | 4290.15 | 10902.0 |
| 2022-07-13 21:00:00 | ES | Futures | 4290.15 | 4300.63 | 4288.73 | 4297.8 | 10692.0 |
| 2022-07-13 22:00:00 | ES | Futures | 4298.08 | 4306.58 | 4296.95 | 4302.04 | 6838.0 |
| 2022-07-13 23:00:00 | ES | Futures | 4302.33 | 4312.81 | 4302.04 | 4306.86 | 9835.0 |
| 2022-07-13 00:00:00 | NQ | Futures | 13660.47 | 13668.28 | 13652.95 | 13659.02 | 2038.0 |
| 2022-07-13 01:00:00 | NQ | Futures | 13657.87 | 13665.68 | 13640.51 | 13659.02 | 3231.0 |
| 2022-07-13 02:00:00 | NQ | Futures | 13659.02 | 13701.54 | 13628.08 | 13691.71 | 7429.0 |
| 2022-07-13 03:00:00 | NQ | Futures | 13692.87 | 13693.73 | 13636.46 | 13645.14 | 9577.0 |
| 2022-07-13 04:00:00 | NQ | Futures | 13644.56 | 13692.87 | 13616.8 | 13690.84 | 8920.0 |
| 2022-07-13 05:00:00 | NQ | Futures | 13690.55 | 13692.58 | 13662.78 | 13668.57 | 5303.0 |
| 2022-07-13 06:00:00 | NQ | Futures | 13668.28 | 13672.33 | 13644.56 | 13670.88 | 4626.0 |
| 2022-07-13 07:00:00 | NQ | Futures | 13670.31 | 13692.29 | 13654.11 | 13683.61 | 8450.0 |
| 2022-07-13 08:00:00 | NQ | Futures | 13683.61 | 13848.77 | 13280.99 | 13374.99 | 91837.0 |
| 2022-07-13 09:00:00 | NQ | Futures | 13374.99 | 13536.39 | 13331.03 | 13512.67 | 123519.0 |
| 2022-07-13 10:00:00 | NQ | Futures | 13512.67 | 13689.39 | 13418.38 | 13639.07 | 143259.0 |
| 2022-07-13 11:00:00 | NQ | Futures | 13639.07 | 13686.5 | 13541.88 | 13589.9 | 65960.0 |
| 2022-07-13 12:00:00 | NQ | Futures | 13590.48 | 13676.09 | 13574.28 | 13673.78 | 45415.0 |
| 2022-07-13 13:00:00 | NQ | Futures | 13674.07 | 13715.14 | 13632.13 | 13678.4 | 49398.0 |
| 2022-07-13 14:00:00 | NQ | Futures | 13678.11 | 13698.07 | 13580.93 | 13698.07 | 59485.0 |
| 2022-07-13 15:00:00 | NQ | Futures | 13697.49 | 13700.1 | 13598.0 | 13600.6 | 59069.0 |
| 2022-07-13 16:00:00 | NQ | Futures | 13601.18 | 13609.28 | 13567.63 | 13574.28 | 14385.0 |
| 2022-07-13 18:00:00 | NQ | Futures | 13570.52 | 13574.57 | 13521.35 | 13535.81 | 5086.0 |
| 2022-07-13 19:00:00 | NQ | Futures | 13535.81 | 13550.27 | 13493.87 | 13508.33 | 6159.0 |
| 2022-07-13 20:00:00 | NQ | Futures | 13507.46 | 13540.15 | 13498.21 | 13530.02 | 5711.0 |
| 2022-07-13 21:00:00 | NQ | Futures | 13530.89 | 13571.96 | 13523.66 | 13562.71 | 5488.0 |
| 2022-07-13 22:00:00 | NQ | Futures | 13562.71 | 13595.97 | 13557.5 | 13579.48 | 4329.0 |
| 2022-07-13 23:00:00 | NQ | Futures | 13579.77 | 13611.88 | 13577.46 | 13589.9 | 4312.0 |
| 2022-07-13 00:00:00 | YM | Futures | 34999.0 | 34999.0 | 34969.6 | 34976.4 | 465.0 |
| 2022-07-13 01:00:00 | YM | Futures | 34979.8 | 34994.4 | 34956.1 | 34984.3 | 856.0 |
| 2022-07-13 02:00:00 | YM | Futures | 34983.2 | 35057.6 | 34949.3 | 35038.5 | 2399.0 |
| 2022-07-13 03:00:00 | YM | Futures | 35039.6 | 35041.8 | 34908.7 | 34922.2 | 2916.0 |
> showing 50 of 2,051 rows — these rows as CSV