PREVIEW / futures_1hour / 2023-03-02
file: by_date/futures_1hour/2023/2023-03-02.parquet size: 66 KB rows: 2,060
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 |
|---|---|---|---|---|---|---|---|
| 2023-03-02 00:00:00 | ES | Futures | 4409.4 | 4409.95 | 4401.01 | 4402.96 | 8747.0 |
| 2023-03-02 01:00:00 | ES | Futures | 4402.96 | 4407.16 | 4401.01 | 4401.57 | 9121.0 |
| 2023-03-02 02:00:00 | ES | Futures | 4401.57 | 4403.24 | 4393.18 | 4396.25 | 18739.0 |
| 2023-03-02 03:00:00 | ES | Futures | 4396.25 | 4404.08 | 4389.82 | 4402.13 | 41945.0 |
| 2023-03-02 04:00:00 | ES | Futures | 4401.85 | 4405.76 | 4397.37 | 4398.77 | 17897.0 |
| 2023-03-02 05:00:00 | ES | Futures | 4398.77 | 4404.36 | 4392.06 | 4403.8 | 21169.0 |
| 2023-03-02 06:00:00 | ES | Futures | 4403.52 | 4412.19 | 4403.24 | 4411.07 | 20206.0 |
| 2023-03-02 07:00:00 | ES | Futures | 4411.07 | 4415.27 | 4403.52 | 4406.32 | 26657.0 |
| 2023-03-02 08:00:00 | ES | Futures | 4406.32 | 4411.35 | 4395.14 | 4398.49 | 54393.0 |
| 2023-03-02 09:00:00 | ES | Futures | 4398.21 | 4410.79 | 4396.53 | 4406.6 | 200081.0 |
| 2023-03-02 10:00:00 | ES | Futures | 4406.6 | 4420.86 | 4401.85 | 4418.34 | 273934.0 |
| 2023-03-02 11:00:00 | ES | Futures | 4418.62 | 4422.82 | 4409.12 | 4414.43 | 157016.0 |
| 2023-03-02 12:00:00 | ES | Futures | 4414.43 | 4421.98 | 4409.12 | 4420.02 | 106329.0 |
| 2023-03-02 13:00:00 | ES | Futures | 4420.02 | 4439.87 | 4415.55 | 4439.03 | 158267.0 |
| 2023-03-02 14:00:00 | ES | Futures | 4439.31 | 4451.06 | 4438.19 | 4447.14 | 189103.0 |
| 2023-03-02 15:00:00 | ES | Futures | 4447.14 | 4468.39 | 4442.67 | 4458.33 | 308126.0 |
| 2023-03-02 16:00:00 | ES | Futures | 4458.05 | 4460.0 | 4453.85 | 4454.69 | 64069.0 |
| 2023-03-02 18:00:00 | ES | Futures | 4454.69 | 4454.97 | 4448.82 | 4450.22 | 8828.0 |
| 2023-03-02 19:00:00 | ES | Futures | 4450.22 | 4453.57 | 4447.14 | 4451.34 | 10647.0 |
| 2023-03-02 20:00:00 | ES | Futures | 4451.62 | 4456.09 | 4445.18 | 4446.02 | 13939.0 |
| 2023-03-02 21:00:00 | ES | Futures | 4446.02 | 4448.26 | 4444.63 | 4446.02 | 7721.0 |
| 2023-03-02 22:00:00 | ES | Futures | 4446.02 | 4449.38 | 4445.18 | 4447.7 | 4724.0 |
| 2023-03-02 23:00:00 | ES | Futures | 4447.98 | 4449.38 | 4446.58 | 4448.54 | 3169.0 |
| 2023-03-02 00:00:00 | NQ | Futures | 13546.75 | 13549.88 | 13518.3 | 13527.69 | 3867.0 |
| 2023-03-02 01:00:00 | NQ | Futures | 13527.12 | 13547.32 | 13519.73 | 13523.71 | 4091.0 |
| 2023-03-02 02:00:00 | NQ | Futures | 13523.71 | 13530.25 | 13487.29 | 13503.8 | 9757.0 |
| 2023-03-02 03:00:00 | NQ | Futures | 13504.08 | 13533.38 | 13465.1 | 13522.57 | 16049.0 |
| 2023-03-02 04:00:00 | NQ | Futures | 13521.15 | 13533.38 | 13494.98 | 13502.09 | 8269.0 |
| 2023-03-02 05:00:00 | NQ | Futures | 13500.95 | 13523.43 | 13473.07 | 13521.43 | 9576.0 |
| 2023-03-02 06:00:00 | NQ | Futures | 13521.43 | 13551.59 | 13516.6 | 13545.62 | 9074.0 |
| 2023-03-02 07:00:00 | NQ | Futures | 13547.04 | 13562.97 | 13510.91 | 13518.3 | 11735.0 |
| 2023-03-02 08:00:00 | NQ | Futures | 13518.87 | 13534.81 | 13471.36 | 13476.77 | 25481.0 |
| 2023-03-02 09:00:00 | NQ | Futures | 13476.48 | 13555.0 | 13474.21 | 13538.5 | 86640.0 |
| 2023-03-02 10:00:00 | NQ | Futures | 13538.5 | 13579.47 | 13510.62 | 13568.66 | 114084.0 |
| 2023-03-02 11:00:00 | NQ | Futures | 13568.66 | 13585.44 | 13522.86 | 13549.31 | 79603.0 |
| 2023-03-02 12:00:00 | NQ | Futures | 13549.31 | 13581.75 | 13535.94 | 13570.94 | 55070.0 |
| 2023-03-02 13:00:00 | NQ | Futures | 13571.22 | 13657.14 | 13556.14 | 13654.58 | 69357.0 |
| 2023-03-02 14:00:00 | NQ | Futures | 13654.58 | 13715.46 | 13654.58 | 13692.98 | 78664.0 |
| 2023-03-02 15:00:00 | NQ | Futures | 13693.55 | 13765.25 | 13674.78 | 13730.54 | 103323.0 |
| 2023-03-02 16:00:00 | NQ | Futures | 13730.54 | 13739.07 | 13709.2 | 13715.17 | 16774.0 |
| 2023-03-02 18:00:00 | NQ | Futures | 13711.48 | 13711.48 | 13690.99 | 13698.39 | 4128.0 |
| 2023-03-02 19:00:00 | NQ | Futures | 13697.54 | 13712.9 | 13681.03 | 13699.53 | 5377.0 |
| 2023-03-02 20:00:00 | NQ | Futures | 13698.96 | 13721.15 | 13674.78 | 13677.05 | 6566.0 |
| 2023-03-02 21:00:00 | NQ | Futures | 13676.77 | 13687.58 | 13669.37 | 13675.63 | 3568.0 |
| 2023-03-02 22:00:00 | NQ | Futures | 13675.63 | 13694.12 | 13671.93 | 13686.44 | 2829.0 |
| 2023-03-02 23:00:00 | NQ | Futures | 13687.01 | 13696.4 | 13682.17 | 13693.27 | 1735.0 |
| 2023-03-02 00:00:00 | YM | Futures | 36499.5 | 36505.1 | 36434.9 | 36456.0 | 998.0 |
| 2023-03-02 01:00:00 | YM | Futures | 36454.9 | 36489.5 | 36434.9 | 36447.1 | 1196.0 |
| 2023-03-02 02:00:00 | YM | Futures | 36449.3 | 36458.3 | 36393.6 | 36407.0 | 2786.0 |
| 2023-03-02 03:00:00 | YM | Futures | 36408.1 | 36461.6 | 36365.8 | 36456.0 | 5030.0 |
> showing 50 of 2,060 rows — these rows as CSV