PREVIEW / futures_1hour / 2025-07-04
file: by_date/futures_1hour/2025/2025-07-04.parquet size: 39 KB rows: 1,140
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-04 00:00:00 | ES | Futures | 6355.55 | 6356.81 | 6351.52 | 6353.79 | 3576.0 |
| 2025-07-04 01:00:00 | ES | Futures | 6354.04 | 6356.06 | 6350.77 | 6355.55 | 2963.0 |
| 2025-07-04 02:00:00 | ES | Futures | 6355.55 | 6356.06 | 6349.51 | 6349.76 | 5083.0 |
| 2025-07-04 03:00:00 | ES | Futures | 6349.76 | 6352.78 | 6337.17 | 6337.92 | 10593.0 |
| 2025-07-04 04:00:00 | ES | Futures | 6337.92 | 6342.71 | 6332.63 | 6333.64 | 12311.0 |
| 2025-07-04 05:00:00 | ES | Futures | 6333.39 | 6337.67 | 6330.87 | 6336.41 | 10546.0 |
| 2025-07-04 06:00:00 | ES | Futures | 6336.41 | 6338.17 | 6323.57 | 6328.6 | 7385.0 |
| 2025-07-04 07:00:00 | ES | Futures | 6328.35 | 6335.15 | 6327.09 | 6332.38 | 6753.0 |
| 2025-07-04 08:00:00 | ES | Futures | 6332.38 | 6334.65 | 6329.36 | 6331.88 | 4747.0 |
| 2025-07-04 09:00:00 | ES | Futures | 6332.13 | 6335.66 | 6326.34 | 6334.65 | 13165.0 |
| 2025-07-04 10:00:00 | ES | Futures | 6334.4 | 6339.94 | 6331.63 | 6337.42 | 8927.0 |
| 2025-07-04 11:00:00 | ES | Futures | 6337.42 | 6339.18 | 6332.13 | 6336.66 | 8094.0 |
| 2025-07-04 12:00:00 | ES | Futures | 6336.66 | 6337.17 | 6329.61 | 6330.62 | 6340.0 |
| 2025-07-04 00:00:00 | NQ | Futures | 23209.4 | 23215.7 | 23194.27 | 23205.62 | 2151.0 |
| 2025-07-04 01:00:00 | NQ | Futures | 23206.37 | 23210.66 | 23186.96 | 23205.87 | 1732.0 |
| 2025-07-04 02:00:00 | NQ | Futures | 23205.37 | 23207.38 | 23182.67 | 23185.19 | 2859.0 |
| 2025-07-04 03:00:00 | NQ | Futures | 23185.95 | 23199.57 | 23142.07 | 23146.86 | 5378.0 |
| 2025-07-04 04:00:00 | NQ | Futures | 23146.1 | 23172.08 | 23122.9 | 23126.18 | 6334.0 |
| 2025-07-04 05:00:00 | NQ | Futures | 23126.43 | 23151.4 | 23109.54 | 23146.1 | 6091.0 |
| 2025-07-04 06:00:00 | NQ | Futures | 23145.09 | 23150.39 | 23081.29 | 23104.75 | 5299.0 |
| 2025-07-04 07:00:00 | NQ | Futures | 23103.74 | 23142.57 | 23097.94 | 23121.39 | 3800.0 |
| 2025-07-04 08:00:00 | NQ | Futures | 23121.39 | 23137.78 | 23110.29 | 23121.39 | 2478.0 |
| 2025-07-04 09:00:00 | NQ | Futures | 23121.14 | 23134.76 | 23087.35 | 23123.16 | 7745.0 |
| 2025-07-04 10:00:00 | NQ | Futures | 23123.41 | 23145.35 | 23108.02 | 23136.52 | 5987.0 |
| 2025-07-04 11:00:00 | NQ | Futures | 23136.02 | 23142.83 | 23110.29 | 23134.0 | 4677.0 |
| 2025-07-04 12:00:00 | NQ | Futures | 23133.49 | 23136.02 | 23095.42 | 23106.26 | 3952.0 |
| 2025-07-04 00:00:00 | YM | Futures | 45955.4 | 45964.6 | 45928.9 | 45941.1 | 443.0 |
| 2025-07-04 01:00:00 | YM | Futures | 45940.1 | 45971.8 | 45929.9 | 45969.7 | 349.0 |
| 2025-07-04 02:00:00 | YM | Futures | 45969.7 | 45970.7 | 45922.7 | 45926.8 | 920.0 |
| 2025-07-04 03:00:00 | YM | Futures | 45929.9 | 45949.3 | 45834.9 | 45836.9 | 1201.0 |
| 2025-07-04 04:00:00 | YM | Futures | 45837.9 | 45858.4 | 45793.0 | 45822.6 | 1001.0 |
| 2025-07-04 05:00:00 | YM | Futures | 45821.6 | 45855.3 | 45807.3 | 45844.1 | 1186.0 |
| 2025-07-04 06:00:00 | YM | Futures | 45844.1 | 45857.3 | 45751.1 | 45788.9 | 754.0 |
| 2025-07-04 07:00:00 | YM | Futures | 45785.8 | 45839.0 | 45779.7 | 45829.8 | 1160.0 |
| 2025-07-04 08:00:00 | YM | Futures | 45831.8 | 45845.1 | 45808.3 | 45826.7 | 470.0 |
| 2025-07-04 09:00:00 | YM | Futures | 45830.8 | 45871.6 | 45810.3 | 45868.6 | 1874.0 |
| 2025-07-04 10:00:00 | YM | Futures | 45868.6 | 45889.0 | 45842.0 | 45869.6 | 1323.0 |
| 2025-07-04 11:00:00 | YM | Futures | 45870.6 | 45883.9 | 45817.5 | 45829.8 | 984.0 |
| 2025-07-04 12:00:00 | YM | Futures | 45833.8 | 45861.4 | 45804.2 | 45814.4 | 1100.0 |
| 2025-07-04 00:00:00 | CL | Futures | 64.1 | 64.22 | 64.06 | 64.21 | 636.0 |
| 2025-07-04 01:00:00 | CL | Futures | 64.21 | 64.27 | 64.13 | 64.22 | 1034.0 |
| 2025-07-04 02:00:00 | CL | Futures | 64.22 | 64.24 | 63.95 | 64.0 | 2311.0 |
| 2025-07-04 03:00:00 | CL | Futures | 64.01 | 64.34 | 63.98 | 64.25 | 2193.0 |
| 2025-07-04 04:00:00 | CL | Futures | 64.25 | 64.25 | 63.76 | 63.82 | 4836.0 |
| 2025-07-04 05:00:00 | CL | Futures | 63.81 | 63.87 | 63.33 | 63.56 | 6065.0 |
| 2025-07-04 06:00:00 | CL | Futures | 63.55 | 63.76 | 63.52 | 63.73 | 2003.0 |
| 2025-07-04 07:00:00 | CL | Futures | 63.73 | 63.81 | 63.62 | 63.76 | 2161.0 |
| 2025-07-04 08:00:00 | CL | Futures | 63.77 | 63.89 | 63.64 | 63.66 | 2373.0 |
| 2025-07-04 09:00:00 | CL | Futures | 63.66 | 63.72 | 63.45 | 63.64 | 5191.0 |
| 2025-07-04 10:00:00 | CL | Futures | 63.64 | 63.8 | 63.52 | 63.71 | 4224.0 |
> showing 50 of 1,140 rows — these rows as CSV