PREVIEW / futures_1hour / 2025-07-16
file: by_date/futures_1hour/2025/2025-07-16.parquet size: 66 KB rows: 2,049
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-16 00:00:00 | ES | Futures | 6320.29 | 6324.57 | 6320.04 | 6321.55 | 2528.0 |
| 2025-07-16 01:00:00 | ES | Futures | 6321.8 | 6326.59 | 6315.76 | 6319.03 | 7219.0 |
| 2025-07-16 02:00:00 | ES | Futures | 6318.78 | 6319.28 | 6311.22 | 6312.48 | 6055.0 |
| 2025-07-16 03:00:00 | ES | Futures | 6312.23 | 6319.03 | 6304.17 | 6318.78 | 14333.0 |
| 2025-07-16 04:00:00 | ES | Futures | 6318.78 | 6328.35 | 6317.02 | 6326.08 | 9498.0 |
| 2025-07-16 05:00:00 | ES | Futures | 6326.08 | 6327.09 | 6320.8 | 6325.83 | 6126.0 |
| 2025-07-16 06:00:00 | ES | Futures | 6326.08 | 6329.61 | 6324.32 | 6327.6 | 6997.0 |
| 2025-07-16 07:00:00 | ES | Futures | 6327.85 | 6330.62 | 6324.32 | 6330.37 | 11683.0 |
| 2025-07-16 08:00:00 | ES | Futures | 6330.62 | 6347.75 | 6328.35 | 6344.47 | 37816.0 |
| 2025-07-16 09:00:00 | ES | Futures | 6344.72 | 6349.26 | 6328.1 | 6328.86 | 152460.0 |
| 2025-07-16 10:00:00 | ES | Futures | 6329.11 | 6342.2 | 6323.06 | 6329.86 | 227996.0 |
| 2025-07-16 11:00:00 | ES | Futures | 6329.86 | 6342.2 | 6287.8 | 6328.1 | 414369.0 |
| 2025-07-16 12:00:00 | ES | Futures | 6327.85 | 6339.94 | 6318.28 | 6339.43 | 118551.0 |
| 2025-07-16 13:00:00 | ES | Futures | 6339.69 | 6346.74 | 6337.42 | 6339.69 | 86852.0 |
| 2025-07-16 14:00:00 | ES | Futures | 6339.69 | 6352.53 | 6335.66 | 6352.53 | 78395.0 |
| 2025-07-16 15:00:00 | ES | Futures | 6352.28 | 6356.06 | 6346.99 | 6350.01 | 156189.0 |
| 2025-07-16 16:00:00 | ES | Futures | 6350.26 | 6350.77 | 6344.72 | 6346.23 | 39480.0 |
| 2025-07-16 18:00:00 | ES | Futures | 6346.49 | 6347.75 | 6338.43 | 6339.43 | 6695.0 |
| 2025-07-16 19:00:00 | ES | Futures | 6339.69 | 6341.7 | 6338.43 | 6340.19 | 3088.0 |
| 2025-07-16 20:00:00 | ES | Futures | 6340.44 | 6344.47 | 6337.42 | 6343.97 | 5786.0 |
| 2025-07-16 21:00:00 | ES | Futures | 6343.72 | 6344.98 | 6336.66 | 6338.93 | 4512.0 |
| 2025-07-16 22:00:00 | ES | Futures | 6338.93 | 6338.93 | 6336.16 | 6337.17 | 2682.0 |
| 2025-07-16 23:00:00 | ES | Futures | 6337.17 | 6339.94 | 6335.4 | 6339.94 | 2494.0 |
| 2025-07-16 00:00:00 | NQ | Futures | 23216.71 | 23232.6 | 23216.21 | 23221.76 | 1740.0 |
| 2025-07-16 01:00:00 | NQ | Futures | 23221.76 | 23245.97 | 23193.51 | 23207.38 | 5637.0 |
| 2025-07-16 02:00:00 | NQ | Futures | 23206.37 | 23209.15 | 23166.28 | 23171.83 | 4391.0 |
| 2025-07-16 03:00:00 | NQ | Futures | 23171.32 | 23190.74 | 23128.7 | 23182.42 | 8074.0 |
| 2025-07-16 04:00:00 | NQ | Futures | 23182.67 | 23215.2 | 23169.3 | 23202.34 | 5673.0 |
| 2025-07-16 05:00:00 | NQ | Futures | 23202.59 | 23204.86 | 23179.14 | 23200.83 | 4570.0 |
| 2025-07-16 06:00:00 | NQ | Futures | 23200.57 | 23221.5 | 23193.01 | 23214.19 | 3627.0 |
| 2025-07-16 07:00:00 | NQ | Futures | 23214.44 | 23224.53 | 23195.53 | 23220.75 | 5039.0 |
| 2025-07-16 08:00:00 | NQ | Futures | 23221.0 | 23286.06 | 23210.41 | 23274.71 | 16934.0 |
| 2025-07-16 09:00:00 | NQ | Futures | 23274.21 | 23290.6 | 23157.2 | 23168.55 | 66862.0 |
| 2025-07-16 10:00:00 | NQ | Futures | 23168.55 | 23234.37 | 23148.63 | 23190.23 | 86432.0 |
| 2025-07-16 11:00:00 | NQ | Futures | 23189.98 | 23246.47 | 23034.39 | 23190.99 | 136955.0 |
| 2025-07-16 12:00:00 | NQ | Futures | 23190.23 | 23252.02 | 23152.91 | 23246.47 | 46226.0 |
| 2025-07-16 13:00:00 | NQ | Futures | 23246.47 | 23270.43 | 23220.5 | 23228.57 | 31887.0 |
| 2025-07-16 14:00:00 | NQ | Futures | 23229.07 | 23274.97 | 23216.97 | 23273.71 | 29474.0 |
| 2025-07-16 15:00:00 | NQ | Futures | 23273.71 | 23301.19 | 23259.08 | 23275.97 | 48895.0 |
| 2025-07-16 16:00:00 | NQ | Futures | 23276.23 | 23276.73 | 23256.31 | 23264.12 | 11973.0 |
| 2025-07-16 18:00:00 | NQ | Futures | 23266.39 | 23272.95 | 23231.84 | 23235.12 | 3500.0 |
| 2025-07-16 19:00:00 | NQ | Futures | 23236.13 | 23247.23 | 23229.57 | 23241.17 | 2089.0 |
| 2025-07-16 20:00:00 | NQ | Futures | 23240.67 | 23255.04 | 23224.28 | 23252.52 | 3652.0 |
| 2025-07-16 21:00:00 | NQ | Futures | 23251.51 | 23259.58 | 23225.79 | 23234.87 | 3290.0 |
| 2025-07-16 22:00:00 | NQ | Futures | 23234.62 | 23234.87 | 23221.76 | 23224.78 | 2198.0 |
| 2025-07-16 23:00:00 | NQ | Futures | 23225.54 | 23241.17 | 23217.47 | 23239.16 | 2258.0 |
| 2025-07-16 00:00:00 | YM | Futures | 45122.8 | 45149.4 | 45116.7 | 45125.9 | 258.0 |
| 2025-07-16 01:00:00 | YM | Futures | 45130.0 | 45158.6 | 45096.3 | 45119.8 | 655.0 |
| 2025-07-16 02:00:00 | YM | Futures | 45114.7 | 45120.8 | 45073.8 | 45077.9 | 915.0 |
| 2025-07-16 03:00:00 | YM | Futures | 45077.9 | 45156.5 | 45043.1 | 45152.5 | 1632.0 |
> showing 50 of 2,049 rows — these rows as CSV