PREVIEW / futures_1hour / 2024-10-29
file: by_date/futures_1hour/2024/2024-10-29.parquet size: 68 KB rows: 2,119
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 |
|---|---|---|---|---|---|---|---|
| 2024-10-29 00:00:00 | ES | Futures | 6074.66 | 6080.63 | 6073.37 | 6080.37 | 5670.0 |
| 2024-10-29 01:00:00 | ES | Futures | 6080.63 | 6084.01 | 6078.3 | 6082.71 | 5640.0 |
| 2024-10-29 02:00:00 | ES | Futures | 6082.97 | 6090.75 | 6082.97 | 6089.72 | 5590.0 |
| 2024-10-29 03:00:00 | ES | Futures | 6089.46 | 6093.09 | 6087.12 | 6087.12 | 8563.0 |
| 2024-10-29 04:00:00 | ES | Futures | 6087.38 | 6093.09 | 6077.78 | 6087.64 | 20467.0 |
| 2024-10-29 05:00:00 | ES | Futures | 6087.64 | 6088.68 | 6081.93 | 6086.34 | 12751.0 |
| 2024-10-29 06:00:00 | ES | Futures | 6086.34 | 6086.86 | 6078.56 | 6082.45 | 10578.0 |
| 2024-10-29 07:00:00 | ES | Futures | 6082.45 | 6083.49 | 6076.22 | 6076.74 | 21873.0 |
| 2024-10-29 08:00:00 | ES | Futures | 6076.48 | 6078.04 | 6070.77 | 6073.11 | 34005.0 |
| 2024-10-29 09:00:00 | ES | Futures | 6072.85 | 6077.26 | 6059.87 | 6075.44 | 157331.0 |
| 2024-10-29 10:00:00 | ES | Futures | 6075.7 | 6095.95 | 6071.03 | 6091.53 | 193144.0 |
| 2024-10-29 11:00:00 | ES | Futures | 6091.53 | 6093.61 | 6082.19 | 6091.01 | 107944.0 |
| 2024-10-29 12:00:00 | ES | Futures | 6091.01 | 6098.54 | 6085.3 | 6097.5 | 103215.0 |
| 2024-10-29 13:00:00 | ES | Futures | 6097.5 | 6105.81 | 6092.31 | 6097.24 | 91849.0 |
| 2024-10-29 14:00:00 | ES | Futures | 6097.24 | 6107.1 | 6094.39 | 6102.43 | 79368.0 |
| 2024-10-29 15:00:00 | ES | Futures | 6102.17 | 6107.36 | 6091.01 | 6095.43 | 159736.0 |
| 2024-10-29 16:00:00 | ES | Futures | 6095.43 | 6107.88 | 6094.65 | 6101.91 | 80781.0 |
| 2024-10-29 18:00:00 | ES | Futures | 6107.1 | 6111.78 | 6104.25 | 6110.48 | 7412.0 |
| 2024-10-29 19:00:00 | ES | Futures | 6110.48 | 6111.0 | 6105.55 | 6108.4 | 4439.0 |
| 2024-10-29 20:00:00 | ES | Futures | 6108.66 | 6115.93 | 6107.62 | 6114.89 | 8338.0 |
| 2024-10-29 21:00:00 | ES | Futures | 6114.63 | 6117.49 | 6111.78 | 6116.19 | 5924.0 |
| 2024-10-29 22:00:00 | ES | Futures | 6116.19 | 6116.19 | 6108.66 | 6109.18 | 6489.0 |
| 2024-10-29 23:00:00 | ES | Futures | 6109.18 | 6109.96 | 6103.99 | 6105.55 | 8558.0 |
| 2024-10-29 00:00:00 | NQ | Futures | 21354.37 | 21388.29 | 21343.67 | 21386.46 | 4149.0 |
| 2024-10-29 01:00:00 | NQ | Futures | 21386.2 | 21404.72 | 21376.29 | 21402.12 | 2793.0 |
| 2024-10-29 02:00:00 | NQ | Futures | 21402.12 | 21445.43 | 21401.85 | 21440.99 | 3565.0 |
| 2024-10-29 03:00:00 | NQ | Futures | 21439.69 | 21451.95 | 21421.68 | 21423.77 | 4906.0 |
| 2024-10-29 04:00:00 | NQ | Futures | 21424.29 | 21443.6 | 21375.76 | 21421.95 | 11606.0 |
| 2024-10-29 05:00:00 | NQ | Futures | 21422.73 | 21425.6 | 21385.68 | 21412.55 | 7667.0 |
| 2024-10-29 06:00:00 | NQ | Futures | 21413.07 | 21416.47 | 21385.16 | 21408.64 | 4874.0 |
| 2024-10-29 07:00:00 | NQ | Futures | 21408.64 | 21412.81 | 21376.29 | 21388.81 | 8511.0 |
| 2024-10-29 08:00:00 | NQ | Futures | 21388.03 | 21398.72 | 21354.11 | 21382.29 | 11645.0 |
| 2024-10-29 09:00:00 | NQ | Futures | 21383.59 | 21422.47 | 21324.1 | 21409.68 | 60103.0 |
| 2024-10-29 10:00:00 | NQ | Futures | 21410.47 | 21503.35 | 21389.33 | 21498.91 | 79996.0 |
| 2024-10-29 11:00:00 | NQ | Futures | 21498.65 | 21525.53 | 21468.91 | 21521.61 | 51356.0 |
| 2024-10-29 12:00:00 | NQ | Futures | 21522.14 | 21559.97 | 21483.78 | 21550.05 | 50773.0 |
| 2024-10-29 13:00:00 | NQ | Futures | 21549.53 | 21591.02 | 21548.75 | 21574.32 | 43771.0 |
| 2024-10-29 14:00:00 | NQ | Futures | 21574.58 | 21618.67 | 21561.79 | 21598.58 | 33397.0 |
| 2024-10-29 15:00:00 | NQ | Futures | 21598.06 | 21652.07 | 21584.49 | 21599.1 | 62739.0 |
| 2024-10-29 16:00:00 | NQ | Futures | 21598.58 | 21666.42 | 21591.8 | 21612.15 | 26284.0 |
| 2024-10-29 18:00:00 | NQ | Futures | 21639.02 | 21669.29 | 21623.37 | 21658.59 | 4970.0 |
| 2024-10-29 19:00:00 | NQ | Futures | 21657.81 | 21661.2 | 21632.76 | 21654.68 | 3983.0 |
| 2024-10-29 20:00:00 | NQ | Futures | 21654.42 | 21681.03 | 21646.33 | 21674.25 | 4392.0 |
| 2024-10-29 21:00:00 | NQ | Futures | 21673.46 | 21695.9 | 21660.68 | 21689.64 | 4200.0 |
| 2024-10-29 22:00:00 | NQ | Futures | 21689.9 | 21691.47 | 21659.11 | 21664.85 | 3813.0 |
| 2024-10-29 23:00:00 | NQ | Futures | 21664.85 | 21669.55 | 21625.72 | 21634.33 | 5093.0 |
| 2024-10-29 00:00:00 | YM | Futures | 44253.8 | 44295.5 | 44249.7 | 44292.3 | 462.0 |
| 2024-10-29 01:00:00 | YM | Futures | 44293.4 | 44306.9 | 44279.8 | 44300.7 | 622.0 |
| 2024-10-29 02:00:00 | YM | Futures | 44301.7 | 44339.2 | 44301.7 | 44335.0 | 833.0 |
| 2024-10-29 03:00:00 | YM | Futures | 44331.9 | 44360.0 | 44314.2 | 44316.3 | 1148.0 |
> showing 50 of 2,119 rows — these rows as CSV