PREVIEW / futures_1hour / 2025-07-08
file: by_date/futures_1hour/2025/2025-07-08.parquet size: 65 KB rows: 2,055
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-07-08 00:00:00 | ES | Futures | 6323.06 | 6326.84 | 6322.56 | 6323.31 | 2461.0 |
| 2025-07-08 01:00:00 | ES | Futures | 6323.31 | 6328.86 | 6322.31 | 6328.6 | 3799.0 |
| 2025-07-08 02:00:00 | ES | Futures | 6328.6 | 6331.37 | 6325.08 | 6330.37 | 7833.0 |
| 2025-07-08 03:00:00 | ES | Futures | 6330.11 | 6336.16 | 6324.57 | 6334.14 | 10906.0 |
| 2025-07-08 04:00:00 | ES | Futures | 6334.14 | 6334.4 | 6326.84 | 6330.11 | 7569.0 |
| 2025-07-08 05:00:00 | ES | Futures | 6330.11 | 6332.13 | 6323.82 | 6325.08 | 6023.0 |
| 2025-07-08 06:00:00 | ES | Futures | 6325.33 | 6333.14 | 6320.8 | 6330.37 | 8653.0 |
| 2025-07-08 07:00:00 | ES | Futures | 6330.11 | 6333.89 | 6328.1 | 6329.36 | 6909.0 |
| 2025-07-08 08:00:00 | ES | Futures | 6329.36 | 6331.12 | 6324.07 | 6329.36 | 14483.0 |
| 2025-07-08 09:00:00 | ES | Futures | 6329.36 | 6331.63 | 6319.79 | 6321.05 | 109840.0 |
| 2025-07-08 10:00:00 | ES | Futures | 6321.05 | 6329.61 | 6309.46 | 6318.78 | 209359.0 |
| 2025-07-08 11:00:00 | ES | Futures | 6318.78 | 6326.84 | 6311.48 | 6325.08 | 118081.0 |
| 2025-07-08 12:00:00 | ES | Futures | 6325.08 | 6335.91 | 6318.53 | 6322.31 | 141333.0 |
| 2025-07-08 13:00:00 | ES | Futures | 6322.31 | 6327.85 | 6312.74 | 6326.34 | 92575.0 |
| 2025-07-08 14:00:00 | ES | Futures | 6326.08 | 6327.85 | 6317.52 | 6319.79 | 64770.0 |
| 2025-07-08 15:00:00 | ES | Futures | 6319.79 | 6323.31 | 6314.5 | 6317.52 | 153613.0 |
| 2025-07-08 16:00:00 | ES | Futures | 6317.52 | 6321.3 | 6316.26 | 6318.78 | 35874.0 |
| 2025-07-08 18:00:00 | ES | Futures | 6319.03 | 6323.06 | 6317.77 | 6320.29 | 2860.0 |
| 2025-07-08 19:00:00 | ES | Futures | 6320.29 | 6323.82 | 6315.76 | 6317.52 | 4007.0 |
| 2025-07-08 20:00:00 | ES | Futures | 6317.27 | 6317.27 | 6309.21 | 6311.98 | 5439.0 |
| 2025-07-08 21:00:00 | ES | Futures | 6311.73 | 6316.26 | 6306.94 | 6315.76 | 6236.0 |
| 2025-07-08 22:00:00 | ES | Futures | 6315.51 | 6317.77 | 6313.49 | 6313.74 | 2979.0 |
| 2025-07-08 23:00:00 | ES | Futures | 6314.25 | 6315.25 | 6311.22 | 6311.73 | 2605.0 |
| 2025-07-08 00:00:00 | NQ | Futures | 23114.83 | 23126.43 | 23106.01 | 23109.54 | 2021.0 |
| 2025-07-08 01:00:00 | NQ | Futures | 23109.29 | 23134.76 | 23103.23 | 23133.49 | 2416.0 |
| 2025-07-08 02:00:00 | NQ | Futures | 23133.49 | 23152.41 | 23123.16 | 23146.86 | 3746.0 |
| 2025-07-08 03:00:00 | NQ | Futures | 23146.61 | 23172.83 | 23117.36 | 23162.75 | 6000.0 |
| 2025-07-08 04:00:00 | NQ | Futures | 23163.0 | 23163.76 | 23132.99 | 23146.36 | 4497.0 |
| 2025-07-08 05:00:00 | NQ | Futures | 23145.85 | 23153.67 | 23117.1 | 23124.16 | 3658.0 |
| 2025-07-08 06:00:00 | NQ | Futures | 23124.67 | 23152.91 | 23105.0 | 23143.83 | 4661.0 |
| 2025-07-08 07:00:00 | NQ | Futures | 23144.09 | 23156.95 | 23130.22 | 23139.55 | 3758.0 |
| 2025-07-08 08:00:00 | NQ | Futures | 23138.79 | 23155.18 | 23114.33 | 23139.8 | 8717.0 |
| 2025-07-08 09:00:00 | NQ | Futures | 23139.55 | 23156.19 | 23080.29 | 23080.79 | 48795.0 |
| 2025-07-08 10:00:00 | NQ | Futures | 23081.29 | 23142.57 | 23039.94 | 23093.65 | 82641.0 |
| 2025-07-08 11:00:00 | NQ | Futures | 23092.89 | 23114.58 | 23052.8 | 23105.5 | 45794.0 |
| 2025-07-08 12:00:00 | NQ | Futures | 23105.76 | 23162.75 | 23087.35 | 23116.09 | 52764.0 |
| 2025-07-08 13:00:00 | NQ | Futures | 23116.35 | 23138.79 | 23074.99 | 23133.75 | 38439.0 |
| 2025-07-08 14:00:00 | NQ | Futures | 23133.75 | 23142.57 | 23089.62 | 23098.44 | 31055.0 |
| 2025-07-08 15:00:00 | NQ | Futures | 23098.44 | 23103.23 | 23069.44 | 23090.88 | 43784.0 |
| 2025-07-08 16:00:00 | NQ | Futures | 23091.13 | 23108.02 | 23084.32 | 23102.73 | 10099.0 |
| 2025-07-08 18:00:00 | NQ | Futures | 23106.01 | 23122.65 | 23099.96 | 23112.31 | 1953.0 |
| 2025-07-08 19:00:00 | NQ | Futures | 23113.32 | 23124.16 | 23093.9 | 23101.22 | 2156.0 |
| 2025-07-08 20:00:00 | NQ | Futures | 23099.96 | 23099.96 | 23063.14 | 23074.74 | 3026.0 |
| 2025-07-08 21:00:00 | NQ | Futures | 23073.98 | 23091.89 | 23053.3 | 23089.62 | 3966.0 |
| 2025-07-08 22:00:00 | NQ | Futures | 23089.87 | 23100.96 | 23077.76 | 23079.78 | 2394.0 |
| 2025-07-08 23:00:00 | NQ | Futures | 23080.03 | 23085.08 | 23067.68 | 23073.48 | 1979.0 |
| 2025-07-08 00:00:00 | YM | Futures | 45590.7 | 45621.4 | 45590.7 | 45598.9 | 298.0 |
| 2025-07-08 01:00:00 | YM | Futures | 45599.9 | 45639.7 | 45593.8 | 45637.7 | 308.0 |
| 2025-07-08 02:00:00 | YM | Futures | 45636.7 | 45654.0 | 45616.3 | 45642.8 | 670.0 |
| 2025-07-08 03:00:00 | YM | Futures | 45639.7 | 45679.6 | 45611.1 | 45668.4 | 888.0 |
> showing 50 of 2,055 rows — these rows as CSV