PREVIEW / futures_1hour / 2023-04-10
file: by_date/futures_1hour/2023/2023-04-10.parquet size: 55 KB rows: 1,606
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-04-10 00:00:00 | ES | Futures | 4583.26 | 4584.37 | 4581.88 | 4582.43 | 2908.0 |
| 2023-04-10 01:00:00 | ES | Futures | 4582.71 | 4583.26 | 4579.94 | 4580.77 | 4448.0 |
| 2023-04-10 02:00:00 | ES | Futures | 4580.77 | 4581.6 | 4578.55 | 4578.83 | 4161.0 |
| 2023-04-10 03:00:00 | ES | Futures | 4579.1 | 4582.16 | 4578.27 | 4582.16 | 5038.0 |
| 2023-04-10 04:00:00 | ES | Futures | 4581.88 | 4584.1 | 4580.77 | 4584.1 | 4521.0 |
| 2023-04-10 05:00:00 | ES | Futures | 4584.1 | 4587.43 | 4583.54 | 4585.48 | 5069.0 |
| 2023-04-10 06:00:00 | ES | Futures | 4585.48 | 4586.87 | 4584.65 | 4584.93 | 3732.0 |
| 2023-04-10 07:00:00 | ES | Futures | 4585.21 | 4585.48 | 4572.73 | 4575.78 | 14128.0 |
| 2023-04-10 08:00:00 | ES | Futures | 4576.05 | 4576.33 | 4556.08 | 4557.19 | 39352.0 |
| 2023-04-10 09:00:00 | ES | Futures | 4556.92 | 4559.14 | 4547.21 | 4550.26 | 173789.0 |
| 2023-04-10 10:00:00 | ES | Futures | 4549.98 | 4563.57 | 4548.04 | 4555.81 | 159259.0 |
| 2023-04-10 11:00:00 | ES | Futures | 4556.08 | 4568.01 | 4555.81 | 4559.41 | 104437.0 |
| 2023-04-10 12:00:00 | ES | Futures | 4559.41 | 4574.67 | 4551.09 | 4574.39 | 133913.0 |
| 2023-04-10 13:00:00 | ES | Futures | 4574.39 | 4581.05 | 4573.0 | 4578.0 | 100755.0 |
| 2023-04-10 14:00:00 | ES | Futures | 4578.0 | 4583.54 | 4575.22 | 4582.99 | 91540.0 |
| 2023-04-10 15:00:00 | ES | Futures | 4582.99 | 4590.48 | 4578.27 | 4590.2 | 152293.0 |
| 2023-04-10 16:00:00 | ES | Futures | 4590.2 | 4594.36 | 4587.43 | 4592.14 | 79658.0 |
| 2023-04-10 18:00:00 | ES | Futures | 4591.31 | 4594.08 | 4589.92 | 4592.97 | 4055.0 |
| 2023-04-10 19:00:00 | ES | Futures | 4592.97 | 4595.75 | 4592.42 | 4595.47 | 4771.0 |
| 2023-04-10 20:00:00 | ES | Futures | 4595.19 | 4597.96 | 4591.03 | 4593.53 | 13025.0 |
| 2023-04-10 21:00:00 | ES | Futures | 4593.53 | 4594.91 | 4591.59 | 4593.8 | 7534.0 |
| 2023-04-10 22:00:00 | ES | Futures | 4593.8 | 4597.41 | 4593.53 | 4594.91 | 6363.0 |
| 2023-04-10 23:00:00 | ES | Futures | 4595.19 | 4597.41 | 4592.42 | 4592.97 | 5102.0 |
| 2023-04-10 00:00:00 | NQ | Futures | 14799.27 | 14800.12 | 14790.26 | 14794.48 | 2325.0 |
| 2023-04-10 01:00:00 | NQ | Futures | 14794.77 | 14796.74 | 14780.41 | 14784.07 | 3166.0 |
| 2023-04-10 02:00:00 | NQ | Futures | 14784.07 | 14784.63 | 14761.54 | 14764.64 | 4960.0 |
| 2023-04-10 03:00:00 | NQ | Futures | 14765.2 | 14792.51 | 14762.67 | 14788.85 | 4443.0 |
| 2023-04-10 04:00:00 | NQ | Futures | 14789.14 | 14801.24 | 14786.88 | 14800.4 | 4374.0 |
| 2023-04-10 05:00:00 | NQ | Futures | 14800.68 | 14825.46 | 14797.02 | 14815.04 | 4607.0 |
| 2023-04-10 06:00:00 | NQ | Futures | 14814.76 | 14827.43 | 14808.56 | 14812.79 | 3544.0 |
| 2023-04-10 07:00:00 | NQ | Futures | 14812.79 | 14814.76 | 14744.65 | 14765.2 | 11788.0 |
| 2023-04-10 08:00:00 | NQ | Futures | 14765.48 | 14766.05 | 14700.45 | 14708.05 | 20148.0 |
| 2023-04-10 09:00:00 | NQ | Futures | 14707.48 | 14718.75 | 14604.15 | 14626.12 | 83678.0 |
| 2023-04-10 10:00:00 | NQ | Futures | 14626.12 | 14687.78 | 14608.1 | 14661.31 | 78375.0 |
| 2023-04-10 11:00:00 | NQ | Futures | 14661.87 | 14740.43 | 14661.87 | 14698.76 | 65307.0 |
| 2023-04-10 12:00:00 | NQ | Futures | 14699.6 | 14774.78 | 14656.81 | 14768.86 | 72979.0 |
| 2023-04-10 13:00:00 | NQ | Futures | 14769.15 | 14796.17 | 14763.8 | 14780.97 | 48623.0 |
| 2023-04-10 14:00:00 | NQ | Futures | 14780.97 | 14819.54 | 14773.09 | 14817.85 | 46590.0 |
| 2023-04-10 15:00:00 | NQ | Futures | 14817.85 | 14826.3 | 14792.23 | 14826.02 | 55217.0 |
| 2023-04-10 16:00:00 | NQ | Futures | 14826.02 | 14835.87 | 14817.01 | 14827.71 | 15965.0 |
| 2023-04-10 18:00:00 | NQ | Futures | 14824.61 | 14833.06 | 14818.98 | 14827.14 | 2055.0 |
| 2023-04-10 19:00:00 | NQ | Futures | 14827.71 | 14837.28 | 14824.61 | 14834.75 | 2445.0 |
| 2023-04-10 20:00:00 | NQ | Futures | 14834.47 | 14850.8 | 14809.69 | 14823.2 | 7087.0 |
| 2023-04-10 21:00:00 | NQ | Futures | 14822.64 | 14828.55 | 14812.5 | 14821.8 | 4034.0 |
| 2023-04-10 22:00:00 | NQ | Futures | 14821.23 | 14836.44 | 14819.82 | 14824.05 | 3832.0 |
| 2023-04-10 23:00:00 | NQ | Futures | 14823.77 | 14832.78 | 14808.0 | 14811.66 | 3225.0 |
| 2023-04-10 00:00:00 | YM | Futures | 37224.6 | 37232.3 | 37212.4 | 37217.9 | 702.0 |
| 2023-04-10 01:00:00 | YM | Futures | 37219.0 | 37224.6 | 37205.8 | 37208.0 | 606.0 |
| 2023-04-10 02:00:00 | YM | Futures | 37208.0 | 37223.5 | 37199.2 | 37212.4 | 825.0 |
| 2023-04-10 03:00:00 | YM | Futures | 37214.6 | 37217.9 | 37190.3 | 37209.1 | 1189.0 |
> showing 50 of 1,606 rows — these rows as CSV