PREVIEW / futures_1hour / 2024-10-22
file: by_date/futures_1hour/2024/2024-10-22.parquet size: 66 KB rows: 2,088
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-22 00:00:00 | ES | Futures | 6109.96 | 6111.26 | 6106.33 | 6106.59 | 3521.0 |
| 2024-10-22 01:00:00 | ES | Futures | 6106.59 | 6111.0 | 6105.55 | 6107.36 | 4102.0 |
| 2024-10-22 02:00:00 | ES | Futures | 6107.36 | 6109.18 | 6102.95 | 6106.85 | 5289.0 |
| 2024-10-22 03:00:00 | ES | Futures | 6107.1 | 6112.04 | 6105.03 | 6106.59 | 12120.0 |
| 2024-10-22 04:00:00 | ES | Futures | 6106.33 | 6108.92 | 6099.32 | 6099.32 | 10998.0 |
| 2024-10-22 05:00:00 | ES | Futures | 6099.32 | 6101.14 | 6087.12 | 6088.94 | 19152.0 |
| 2024-10-22 06:00:00 | ES | Futures | 6089.2 | 6095.17 | 6087.9 | 6090.24 | 14724.0 |
| 2024-10-22 07:00:00 | ES | Futures | 6090.5 | 6097.24 | 6090.24 | 6093.09 | 15324.0 |
| 2024-10-22 08:00:00 | ES | Futures | 6093.09 | 6100.62 | 6084.79 | 6091.01 | 30698.0 |
| 2024-10-22 09:00:00 | ES | Futures | 6091.27 | 6097.24 | 6084.53 | 6095.17 | 140086.0 |
| 2024-10-22 10:00:00 | ES | Futures | 6095.17 | 6105.03 | 6092.05 | 6102.17 | 163616.0 |
| 2024-10-22 11:00:00 | ES | Futures | 6102.43 | 6108.14 | 6097.76 | 6102.95 | 85207.0 |
| 2024-10-22 12:00:00 | ES | Futures | 6102.95 | 6109.7 | 6098.28 | 6108.92 | 75433.0 |
| 2024-10-22 13:00:00 | ES | Futures | 6108.92 | 6123.97 | 6105.81 | 6123.71 | 88866.0 |
| 2024-10-22 14:00:00 | ES | Futures | 6123.71 | 6129.16 | 6111.78 | 6113.59 | 86497.0 |
| 2024-10-22 15:00:00 | ES | Futures | 6113.59 | 6126.57 | 6112.3 | 6116.97 | 138903.0 |
| 2024-10-22 16:00:00 | ES | Futures | 6116.97 | 6117.23 | 6110.74 | 6111.26 | 70634.0 |
| 2024-10-22 18:00:00 | ES | Futures | 6111.52 | 6111.52 | 6105.03 | 6108.4 | 4561.0 |
| 2024-10-22 19:00:00 | ES | Futures | 6108.66 | 6115.15 | 6107.1 | 6114.37 | 4272.0 |
| 2024-10-22 20:00:00 | ES | Futures | 6114.63 | 6115.15 | 6107.36 | 6108.14 | 3569.0 |
| 2024-10-22 21:00:00 | ES | Futures | 6108.14 | 6111.52 | 6106.07 | 6110.22 | 4704.0 |
| 2024-10-22 22:00:00 | ES | Futures | 6110.22 | 6113.33 | 6109.44 | 6112.04 | 3262.0 |
| 2024-10-22 23:00:00 | ES | Futures | 6112.3 | 6114.37 | 6110.22 | 6111.0 | 3601.0 |
| 2024-10-22 00:00:00 | NQ | Futures | 21361.41 | 21367.94 | 21342.63 | 21343.67 | 2206.0 |
| 2024-10-22 01:00:00 | NQ | Futures | 21344.72 | 21363.5 | 21332.45 | 21345.76 | 2916.0 |
| 2024-10-22 02:00:00 | NQ | Futures | 21346.02 | 21358.28 | 21324.1 | 21339.76 | 3783.0 |
| 2024-10-22 03:00:00 | NQ | Futures | 21341.06 | 21382.29 | 21332.71 | 21359.07 | 5702.0 |
| 2024-10-22 04:00:00 | NQ | Futures | 21358.28 | 21369.24 | 21322.02 | 21322.54 | 6281.0 |
| 2024-10-22 05:00:00 | NQ | Futures | 21322.28 | 21326.71 | 21265.14 | 21273.75 | 11529.0 |
| 2024-10-22 06:00:00 | NQ | Futures | 21274.01 | 21302.71 | 21265.66 | 21286.01 | 7757.0 |
| 2024-10-22 07:00:00 | NQ | Futures | 21287.58 | 21325.93 | 21287.58 | 21301.14 | 8669.0 |
| 2024-10-22 08:00:00 | NQ | Futures | 21301.4 | 21337.41 | 21248.96 | 21284.44 | 18776.0 |
| 2024-10-22 09:00:00 | NQ | Futures | 21284.71 | 21373.42 | 21252.09 | 21353.33 | 70639.0 |
| 2024-10-22 10:00:00 | NQ | Futures | 21354.11 | 21415.68 | 21331.93 | 21386.72 | 75154.0 |
| 2024-10-22 11:00:00 | NQ | Futures | 21387.77 | 21407.07 | 21348.37 | 21366.89 | 39957.0 |
| 2024-10-22 12:00:00 | NQ | Futures | 21366.63 | 21400.03 | 21316.8 | 21393.77 | 45908.0 |
| 2024-10-22 13:00:00 | NQ | Futures | 21393.77 | 21474.65 | 21374.2 | 21472.56 | 45335.0 |
| 2024-10-22 14:00:00 | NQ | Futures | 21472.82 | 21501.52 | 21408.38 | 21416.99 | 41255.0 |
| 2024-10-22 15:00:00 | NQ | Futures | 21416.99 | 21470.47 | 21411.51 | 21436.3 | 42290.0 |
| 2024-10-22 16:00:00 | NQ | Futures | 21436.3 | 21438.12 | 21402.9 | 21414.64 | 16153.0 |
| 2024-10-22 18:00:00 | NQ | Futures | 21416.73 | 21416.73 | 21384.9 | 21400.03 | 2586.0 |
| 2024-10-22 19:00:00 | NQ | Futures | 21400.03 | 21428.47 | 21394.03 | 21425.6 | 2811.0 |
| 2024-10-22 20:00:00 | NQ | Futures | 21426.64 | 21432.38 | 21387.77 | 21391.68 | 2835.0 |
| 2024-10-22 21:00:00 | NQ | Futures | 21393.51 | 21411.25 | 21386.98 | 21402.38 | 2438.0 |
| 2024-10-22 22:00:00 | NQ | Futures | 21403.42 | 21420.64 | 21396.11 | 21415.16 | 2509.0 |
| 2024-10-22 23:00:00 | NQ | Futures | 21415.94 | 21425.86 | 21404.2 | 21407.07 | 1944.0 |
| 2024-10-22 00:00:00 | YM | Futures | 44874.1 | 44880.4 | 44857.5 | 44857.5 | 373.0 |
| 2024-10-22 01:00:00 | YM | Futures | 44858.5 | 44885.6 | 44854.3 | 44856.4 | 608.0 |
| 2024-10-22 02:00:00 | YM | Futures | 44857.5 | 44863.7 | 44832.5 | 44854.3 | 1136.0 |
| 2024-10-22 03:00:00 | YM | Futures | 44855.4 | 44866.8 | 44826.2 | 44830.4 | 1534.0 |
> showing 50 of 2,088 rows — these rows as CSV