PREVIEW / futures_1hour / 2025-08-05
file: by_date/futures_1hour/2025/2025-08-05.parquet size: 65 KB rows: 2,059
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 |
|---|---|---|---|---|---|---|---|
| 2025-08-05 00:00:00 | ES | Futures | 6412.98 | 6416.76 | 6411.22 | 6416.51 | 2982.0 |
| 2025-08-05 01:00:00 | ES | Futures | 6416.76 | 6419.03 | 6414.49 | 6417.77 | 3508.0 |
| 2025-08-05 02:00:00 | ES | Futures | 6418.02 | 6423.56 | 6416.0 | 6422.55 | 6895.0 |
| 2025-08-05 03:00:00 | ES | Futures | 6422.8 | 6425.32 | 6408.45 | 6409.71 | 13124.0 |
| 2025-08-05 04:00:00 | ES | Futures | 6409.46 | 6413.74 | 6406.18 | 6410.71 | 12728.0 |
| 2025-08-05 05:00:00 | ES | Futures | 6410.71 | 6416.51 | 6409.46 | 6413.49 | 9119.0 |
| 2025-08-05 06:00:00 | ES | Futures | 6413.49 | 6422.3 | 6413.49 | 6420.79 | 11841.0 |
| 2025-08-05 07:00:00 | ES | Futures | 6420.54 | 6422.3 | 6414.74 | 6419.53 | 11598.0 |
| 2025-08-05 08:00:00 | ES | Futures | 6419.78 | 6424.57 | 6410.46 | 6411.97 | 30981.0 |
| 2025-08-05 09:00:00 | ES | Futures | 6411.72 | 6419.53 | 6405.17 | 6412.48 | 138855.0 |
| 2025-08-05 10:00:00 | ES | Futures | 6412.23 | 6412.23 | 6362.86 | 6371.67 | 316067.0 |
| 2025-08-05 11:00:00 | ES | Futures | 6371.42 | 6379.48 | 6364.12 | 6373.19 | 179854.0 |
| 2025-08-05 12:00:00 | ES | Futures | 6373.19 | 6389.56 | 6370.67 | 6382.0 | 134897.0 |
| 2025-08-05 13:00:00 | ES | Futures | 6381.75 | 6396.36 | 6379.48 | 6394.34 | 82572.0 |
| 2025-08-05 14:00:00 | ES | Futures | 6394.34 | 6395.35 | 6371.17 | 6376.96 | 126845.0 |
| 2025-08-05 15:00:00 | ES | Futures | 6377.22 | 6384.27 | 6370.67 | 6372.68 | 184939.0 |
| 2025-08-05 16:00:00 | ES | Futures | 6372.93 | 6379.99 | 6368.15 | 6371.93 | 53020.0 |
| 2025-08-05 18:00:00 | ES | Futures | 6370.41 | 6375.96 | 6360.59 | 6370.41 | 10928.0 |
| 2025-08-05 19:00:00 | ES | Futures | 6370.16 | 6373.44 | 6363.87 | 6364.12 | 6647.0 |
| 2025-08-05 20:00:00 | ES | Futures | 6363.87 | 6373.44 | 6363.36 | 6368.15 | 7753.0 |
| 2025-08-05 21:00:00 | ES | Futures | 6368.4 | 6382.0 | 6366.38 | 6381.5 | 8099.0 |
| 2025-08-05 22:00:00 | ES | Futures | 6381.5 | 6389.05 | 6378.98 | 6386.03 | 6703.0 |
| 2025-08-05 23:00:00 | ES | Futures | 6386.28 | 6388.55 | 6383.01 | 6387.54 | 3558.0 |
| 2025-08-05 00:00:00 | NQ | Futures | 23545.3 | 23563.21 | 23540.26 | 23562.45 | 1622.0 |
| 2025-08-05 01:00:00 | NQ | Futures | 23562.95 | 23571.02 | 23554.63 | 23566.23 | 1960.0 |
| 2025-08-05 02:00:00 | NQ | Futures | 23566.99 | 23598.26 | 23559.42 | 23589.18 | 3770.0 |
| 2025-08-05 03:00:00 | NQ | Futures | 23589.68 | 23601.03 | 23526.64 | 23532.94 | 7378.0 |
| 2025-08-05 04:00:00 | NQ | Futures | 23533.7 | 23546.31 | 23515.54 | 23534.46 | 6782.0 |
| 2025-08-05 05:00:00 | NQ | Futures | 23535.21 | 23553.62 | 23529.16 | 23551.86 | 4912.0 |
| 2025-08-05 06:00:00 | NQ | Futures | 23551.86 | 23596.49 | 23548.07 | 23589.43 | 6864.0 |
| 2025-08-05 07:00:00 | NQ | Futures | 23588.42 | 23600.02 | 23565.47 | 23587.67 | 7954.0 |
| 2025-08-05 08:00:00 | NQ | Futures | 23587.41 | 23608.09 | 23546.31 | 23563.96 | 15224.0 |
| 2025-08-05 09:00:00 | NQ | Futures | 23564.21 | 23601.03 | 23506.47 | 23577.83 | 63722.0 |
| 2025-08-05 10:00:00 | NQ | Futures | 23578.08 | 23578.08 | 23339.78 | 23383.15 | 105525.0 |
| 2025-08-05 11:00:00 | NQ | Futures | 23382.9 | 23421.99 | 23314.81 | 23357.93 | 72574.0 |
| 2025-08-05 12:00:00 | NQ | Futures | 23357.43 | 23427.53 | 23338.51 | 23382.39 | 52017.0 |
| 2025-08-05 13:00:00 | NQ | Futures | 23381.89 | 23454.52 | 23368.52 | 23443.67 | 33963.0 |
| 2025-08-05 14:00:00 | NQ | Futures | 23443.42 | 23451.49 | 23316.32 | 23348.6 | 50802.0 |
| 2025-08-05 15:00:00 | NQ | Futures | 23349.36 | 23380.63 | 23322.63 | 23334.73 | 57133.0 |
| 2025-08-05 16:00:00 | NQ | Futures | 23335.24 | 23368.52 | 23285.56 | 23293.12 | 21189.0 |
| 2025-08-05 18:00:00 | NQ | Futures | 23292.87 | 23314.05 | 23246.22 | 23287.07 | 7487.0 |
| 2025-08-05 19:00:00 | NQ | Futures | 23285.56 | 23298.67 | 23253.78 | 23253.78 | 4674.0 |
| 2025-08-05 20:00:00 | NQ | Futures | 23253.03 | 23295.9 | 23250.51 | 23273.45 | 4773.0 |
| 2025-08-05 21:00:00 | NQ | Futures | 23272.95 | 23341.79 | 23264.88 | 23338.01 | 5675.0 |
| 2025-08-05 22:00:00 | NQ | Futures | 23338.26 | 23370.04 | 23324.39 | 23356.92 | 5605.0 |
| 2025-08-05 23:00:00 | NQ | Futures | 23357.68 | 23371.8 | 23345.83 | 23367.77 | 3074.0 |
| 2025-08-05 00:00:00 | YM | Futures | 45307.7 | 45325.1 | 45293.4 | 45323.1 | 150.0 |
| 2025-08-05 01:00:00 | YM | Futures | 45323.1 | 45335.3 | 45308.8 | 45327.1 | 279.0 |
| 2025-08-05 02:00:00 | YM | Futures | 45328.2 | 45355.7 | 45316.9 | 45354.7 | 883.0 |
| 2025-08-05 03:00:00 | YM | Futures | 45354.7 | 45377.2 | 45264.8 | 45272.0 | 1192.0 |
> showing 50 of 2,059 rows — these rows as CSV