PREVIEW / futures_1hour / 2025-07-10
file: by_date/futures_1hour/2025/2025-07-10.parquet size: 65 KB rows: 2,034
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-10 00:00:00 | ES | Futures | 6339.94 | 6340.19 | 6337.67 | 6339.18 | 2969.0 |
| 2025-07-10 01:00:00 | ES | Futures | 6339.18 | 6341.2 | 6337.17 | 6340.44 | 3993.0 |
| 2025-07-10 02:00:00 | ES | Futures | 6340.44 | 6341.45 | 6335.4 | 6337.67 | 7099.0 |
| 2025-07-10 03:00:00 | ES | Futures | 6337.67 | 6342.71 | 6334.65 | 6341.45 | 10291.0 |
| 2025-07-10 04:00:00 | ES | Futures | 6341.2 | 6348.75 | 6340.19 | 6347.75 | 8166.0 |
| 2025-07-10 05:00:00 | ES | Futures | 6347.75 | 6348.75 | 6341.7 | 6345.23 | 7081.0 |
| 2025-07-10 06:00:00 | ES | Futures | 6345.23 | 6351.27 | 6344.22 | 6349.26 | 5103.0 |
| 2025-07-10 07:00:00 | ES | Futures | 6349.26 | 6358.58 | 6348.0 | 6356.31 | 10871.0 |
| 2025-07-10 08:00:00 | ES | Futures | 6356.31 | 6356.56 | 6347.24 | 6349.76 | 18423.0 |
| 2025-07-10 09:00:00 | ES | Futures | 6349.51 | 6357.32 | 6344.22 | 6347.24 | 113182.0 |
| 2025-07-10 10:00:00 | ES | Futures | 6347.24 | 6364.62 | 6343.21 | 6362.1 | 166152.0 |
| 2025-07-10 11:00:00 | ES | Futures | 6362.1 | 6371.93 | 6361.85 | 6370.92 | 105182.0 |
| 2025-07-10 12:00:00 | ES | Futures | 6370.92 | 6371.67 | 6363.87 | 6369.41 | 73701.0 |
| 2025-07-10 13:00:00 | ES | Futures | 6369.41 | 6382.0 | 6369.16 | 6379.99 | 72839.0 |
| 2025-07-10 14:00:00 | ES | Futures | 6379.99 | 6383.01 | 6374.95 | 6376.71 | 62271.0 |
| 2025-07-10 15:00:00 | ES | Futures | 6376.71 | 6380.74 | 6365.63 | 6371.93 | 152480.0 |
| 2025-07-10 16:00:00 | ES | Futures | 6371.93 | 6372.68 | 6366.64 | 6368.9 | 37041.0 |
| 2025-07-10 18:00:00 | ES | Futures | 6370.41 | 6375.96 | 6367.9 | 6375.7 | 5763.0 |
| 2025-07-10 19:00:00 | ES | Futures | 6375.7 | 6377.72 | 6374.19 | 6377.22 | 2938.0 |
| 2025-07-10 20:00:00 | ES | Futures | 6377.22 | 6377.22 | 6330.11 | 6339.43 | 53867.0 |
| 2025-07-10 21:00:00 | ES | Futures | 6339.69 | 6349.51 | 6334.9 | 6346.49 | 13613.0 |
| 2025-07-10 22:00:00 | ES | Futures | 6346.23 | 6351.02 | 6345.23 | 6350.52 | 5785.0 |
| 2025-07-10 23:00:00 | ES | Futures | 6350.52 | 6356.81 | 6350.01 | 6356.31 | 5555.0 |
| 2025-07-10 00:00:00 | NQ | Futures | 23197.04 | 23198.05 | 23184.18 | 23195.28 | 1674.0 |
| 2025-07-10 01:00:00 | NQ | Futures | 23195.53 | 23202.34 | 23176.62 | 23192.76 | 3052.0 |
| 2025-07-10 02:00:00 | NQ | Futures | 23192.25 | 23197.04 | 23180.9 | 23192.76 | 2594.0 |
| 2025-07-10 03:00:00 | NQ | Futures | 23192.76 | 23222.51 | 23183.43 | 23219.99 | 5078.0 |
| 2025-07-10 04:00:00 | NQ | Futures | 23220.5 | 23247.23 | 23216.46 | 23246.72 | 4879.0 |
| 2025-07-10 05:00:00 | NQ | Futures | 23246.47 | 23251.01 | 23212.43 | 23225.54 | 4200.0 |
| 2025-07-10 06:00:00 | NQ | Futures | 23224.53 | 23254.29 | 23222.01 | 23244.7 | 3456.0 |
| 2025-07-10 07:00:00 | NQ | Futures | 23244.2 | 23277.99 | 23238.9 | 23271.94 | 5604.0 |
| 2025-07-10 08:00:00 | NQ | Futures | 23271.44 | 23273.2 | 23235.63 | 23249.5 | 9025.0 |
| 2025-07-10 09:00:00 | NQ | Futures | 23249.75 | 23291.11 | 23138.03 | 23159.97 | 59592.0 |
| 2025-07-10 10:00:00 | NQ | Futures | 23160.73 | 23186.96 | 23100.71 | 23162.75 | 76499.0 |
| 2025-07-10 11:00:00 | NQ | Futures | 23163.25 | 23226.04 | 23139.8 | 23225.04 | 45353.0 |
| 2025-07-10 12:00:00 | NQ | Futures | 23224.78 | 23225.29 | 23163.25 | 23192.25 | 36349.0 |
| 2025-07-10 13:00:00 | NQ | Futures | 23192.25 | 23242.44 | 23188.47 | 23237.64 | 31479.0 |
| 2025-07-10 14:00:00 | NQ | Futures | 23237.64 | 23250.76 | 23224.53 | 23238.15 | 26318.0 |
| 2025-07-10 15:00:00 | NQ | Futures | 23237.9 | 23245.21 | 23190.99 | 23215.7 | 40224.0 |
| 2025-07-10 16:00:00 | NQ | Futures | 23215.7 | 23225.54 | 23197.55 | 23210.41 | 10949.0 |
| 2025-07-10 18:00:00 | NQ | Futures | 23212.17 | 23240.42 | 23204.86 | 23238.15 | 2838.0 |
| 2025-07-10 19:00:00 | NQ | Futures | 23239.41 | 23249.5 | 23230.08 | 23244.96 | 2672.0 |
| 2025-07-10 20:00:00 | NQ | Futures | 23244.96 | 23246.72 | 23030.35 | 23081.8 | 23959.0 |
| 2025-07-10 21:00:00 | NQ | Futures | 23081.8 | 23140.56 | 23064.65 | 23126.94 | 8531.0 |
| 2025-07-10 22:00:00 | NQ | Futures | 23126.94 | 23149.89 | 23117.61 | 23146.1 | 3935.0 |
| 2025-07-10 23:00:00 | NQ | Futures | 23146.36 | 23170.56 | 23144.34 | 23167.79 | 3412.0 |
| 2025-07-10 00:00:00 | YM | Futures | 45570.3 | 45573.3 | 45556.0 | 45567.2 | 161.0 |
| 2025-07-10 01:00:00 | YM | Futures | 45568.2 | 45586.6 | 45560.1 | 45585.6 | 312.0 |
| 2025-07-10 02:00:00 | YM | Futures | 45585.6 | 45592.8 | 45537.6 | 45545.8 | 670.0 |
| 2025-07-10 03:00:00 | YM | Futures | 45546.8 | 45574.4 | 45526.4 | 45556.0 | 779.0 |
> showing 50 of 2,034 rows — these rows as CSV