PREVIEW / futures_1hour / 2025-07-09
file: by_date/futures_1hour/2025/2025-07-09.parquet size: 65 KB rows: 2,047
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-09 00:00:00 | ES | Futures | 6311.98 | 6317.27 | 6311.22 | 6315.25 | 2887.0 |
| 2025-07-09 01:00:00 | ES | Futures | 6315.25 | 6316.01 | 6310.47 | 6312.74 | 3447.0 |
| 2025-07-09 02:00:00 | ES | Futures | 6312.74 | 6318.78 | 6307.45 | 6317.77 | 6893.0 |
| 2025-07-09 03:00:00 | ES | Futures | 6318.02 | 6321.3 | 6313.24 | 6318.78 | 7298.0 |
| 2025-07-09 04:00:00 | ES | Futures | 6318.78 | 6321.3 | 6316.51 | 6318.78 | 5972.0 |
| 2025-07-09 05:00:00 | ES | Futures | 6319.03 | 6330.87 | 6319.03 | 6327.34 | 8749.0 |
| 2025-07-09 06:00:00 | ES | Futures | 6327.6 | 6329.36 | 6324.07 | 6327.6 | 6977.0 |
| 2025-07-09 07:00:00 | ES | Futures | 6327.85 | 6333.89 | 6326.34 | 6331.37 | 8488.0 |
| 2025-07-09 08:00:00 | ES | Futures | 6331.37 | 6337.42 | 6329.61 | 6334.14 | 19537.0 |
| 2025-07-09 09:00:00 | ES | Futures | 6333.89 | 6362.61 | 6332.13 | 6357.32 | 152571.0 |
| 2025-07-09 10:00:00 | ES | Futures | 6357.32 | 6360.34 | 6324.57 | 6328.35 | 259589.0 |
| 2025-07-09 11:00:00 | ES | Futures | 6328.6 | 6339.94 | 6323.06 | 6333.64 | 150253.0 |
| 2025-07-09 12:00:00 | ES | Futures | 6333.39 | 6338.43 | 6329.61 | 6334.65 | 80368.0 |
| 2025-07-09 13:00:00 | ES | Futures | 6334.4 | 6342.46 | 6330.11 | 6338.93 | 86200.0 |
| 2025-07-09 14:00:00 | ES | Futures | 6338.68 | 6350.52 | 6338.17 | 6348.75 | 78238.0 |
| 2025-07-09 15:00:00 | ES | Futures | 6348.75 | 6356.81 | 6345.48 | 6354.29 | 140822.0 |
| 2025-07-09 16:00:00 | ES | Futures | 6354.29 | 6357.32 | 6350.01 | 6353.54 | 49228.0 |
| 2025-07-09 18:00:00 | ES | Futures | 6353.29 | 6359.58 | 6350.77 | 6357.07 | 5076.0 |
| 2025-07-09 19:00:00 | ES | Futures | 6356.81 | 6357.32 | 6350.01 | 6350.77 | 4016.0 |
| 2025-07-09 20:00:00 | ES | Futures | 6350.52 | 6350.77 | 6343.21 | 6343.72 | 6853.0 |
| 2025-07-09 21:00:00 | ES | Futures | 6343.97 | 6345.23 | 6339.43 | 6339.94 | 7335.0 |
| 2025-07-09 22:00:00 | ES | Futures | 6339.94 | 6346.74 | 6339.69 | 6345.48 | 3829.0 |
| 2025-07-09 23:00:00 | ES | Futures | 6345.23 | 6345.23 | 6338.68 | 6339.94 | 4686.0 |
| 2025-07-09 00:00:00 | NQ | Futures | 23073.73 | 23094.91 | 23069.44 | 23091.13 | 1789.0 |
| 2025-07-09 01:00:00 | NQ | Futures | 23091.38 | 23095.42 | 23068.69 | 23073.22 | 1967.0 |
| 2025-07-09 02:00:00 | NQ | Futures | 23072.97 | 23098.19 | 23042.46 | 23094.91 | 4513.0 |
| 2025-07-09 03:00:00 | NQ | Futures | 23095.67 | 23102.98 | 23073.73 | 23092.39 | 3903.0 |
| 2025-07-09 04:00:00 | NQ | Futures | 23091.89 | 23100.71 | 23077.26 | 23089.36 | 3265.0 |
| 2025-07-09 05:00:00 | NQ | Futures | 23089.87 | 23142.32 | 23089.87 | 23123.66 | 5289.0 |
| 2025-07-09 06:00:00 | NQ | Futures | 23124.16 | 23134.25 | 23109.54 | 23122.65 | 4524.0 |
| 2025-07-09 07:00:00 | NQ | Futures | 23123.16 | 23152.16 | 23119.12 | 23138.54 | 4825.0 |
| 2025-07-09 08:00:00 | NQ | Futures | 23137.53 | 23155.69 | 23122.4 | 23135.51 | 8215.0 |
| 2025-07-09 09:00:00 | NQ | Futures | 23135.01 | 23298.17 | 23130.72 | 23287.07 | 64838.0 |
| 2025-07-09 10:00:00 | NQ | Futures | 23287.07 | 23313.3 | 23127.69 | 23147.36 | 99695.0 |
| 2025-07-09 11:00:00 | NQ | Futures | 23146.86 | 23190.23 | 23119.37 | 23148.12 | 58015.0 |
| 2025-07-09 12:00:00 | NQ | Futures | 23148.12 | 23208.9 | 23136.77 | 23183.17 | 34069.0 |
| 2025-07-09 13:00:00 | NQ | Futures | 23182.92 | 23200.83 | 23159.97 | 23183.68 | 40743.0 |
| 2025-07-09 14:00:00 | NQ | Futures | 23183.43 | 23240.42 | 23181.91 | 23232.85 | 36032.0 |
| 2025-07-09 15:00:00 | NQ | Futures | 23233.1 | 23258.83 | 23223.27 | 23252.02 | 44184.0 |
| 2025-07-09 16:00:00 | NQ | Futures | 23252.02 | 23261.35 | 23231.59 | 23244.2 | 13452.0 |
| 2025-07-09 18:00:00 | NQ | Futures | 23241.68 | 23266.14 | 23233.86 | 23258.07 | 2589.0 |
| 2025-07-09 19:00:00 | NQ | Futures | 23258.07 | 23260.09 | 23231.34 | 23234.87 | 2477.0 |
| 2025-07-09 20:00:00 | NQ | Futures | 23235.63 | 23235.63 | 23203.85 | 23206.37 | 3932.0 |
| 2025-07-09 21:00:00 | NQ | Futures | 23205.87 | 23212.93 | 23187.71 | 23190.99 | 4091.0 |
| 2025-07-09 22:00:00 | NQ | Futures | 23190.74 | 23222.26 | 23189.98 | 23219.24 | 3147.0 |
| 2025-07-09 23:00:00 | NQ | Futures | 23218.48 | 23218.48 | 23193.26 | 23197.8 | 2818.0 |
| 2025-07-09 00:00:00 | YM | Futures | 45422.2 | 45451.8 | 45415.0 | 45441.6 | 201.0 |
| 2025-07-09 01:00:00 | YM | Futures | 45439.5 | 45442.6 | 45406.8 | 45426.2 | 272.0 |
| 2025-07-09 02:00:00 | YM | Futures | 45425.2 | 45484.5 | 45395.6 | 45469.1 | 1289.0 |
| 2025-07-09 03:00:00 | YM | Futures | 45471.2 | 45503.9 | 45438.5 | 45493.7 | 702.0 |
> showing 50 of 2,047 rows — these rows as CSV