PREVIEW / futures_1hour / 2025-07-07
file: by_date/futures_1hour/2025/2025-07-07.parquet size: 66 KB rows: 2,043
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-07 00:00:00 | ES | Futures | 6349.01 | 6353.29 | 6343.72 | 6344.72 | 3412.0 |
| 2025-07-07 01:00:00 | ES | Futures | 6344.47 | 6345.73 | 6341.7 | 6344.22 | 3411.0 |
| 2025-07-07 02:00:00 | ES | Futures | 6343.97 | 6344.47 | 6337.92 | 6341.7 | 5833.0 |
| 2025-07-07 03:00:00 | ES | Futures | 6341.95 | 6344.98 | 6339.18 | 6344.72 | 6463.0 |
| 2025-07-07 04:00:00 | ES | Futures | 6344.98 | 6345.48 | 6339.43 | 6341.2 | 9683.0 |
| 2025-07-07 05:00:00 | ES | Futures | 6341.2 | 6354.55 | 6339.94 | 6353.79 | 8684.0 |
| 2025-07-07 06:00:00 | ES | Futures | 6353.79 | 6358.58 | 6352.03 | 6352.28 | 9106.0 |
| 2025-07-07 07:00:00 | ES | Futures | 6352.53 | 6358.58 | 6351.78 | 6358.07 | 8561.0 |
| 2025-07-07 08:00:00 | ES | Futures | 6357.82 | 6362.35 | 6348.25 | 6350.01 | 24304.0 |
| 2025-07-07 09:00:00 | ES | Futures | 6350.01 | 6357.07 | 6344.47 | 6352.53 | 115258.0 |
| 2025-07-07 10:00:00 | ES | Futures | 6352.28 | 6353.79 | 6334.9 | 6337.17 | 145076.0 |
| 2025-07-07 11:00:00 | ES | Futures | 6336.92 | 6339.69 | 6326.84 | 6332.89 | 106833.0 |
| 2025-07-07 12:00:00 | ES | Futures | 6332.63 | 6338.43 | 6307.19 | 6312.99 | 204137.0 |
| 2025-07-07 13:00:00 | ES | Futures | 6312.99 | 6329.61 | 6310.47 | 6315.25 | 118240.0 |
| 2025-07-07 14:00:00 | ES | Futures | 6315.25 | 6318.78 | 6293.09 | 6316.77 | 139055.0 |
| 2025-07-07 15:00:00 | ES | Futures | 6316.51 | 6325.08 | 6308.45 | 6322.31 | 195847.0 |
| 2025-07-07 16:00:00 | ES | Futures | 6322.56 | 6323.06 | 6305.43 | 6310.22 | 49185.0 |
| 2025-07-07 18:00:00 | ES | Futures | 6309.46 | 6313.24 | 6301.4 | 6309.21 | 9356.0 |
| 2025-07-07 19:00:00 | ES | Futures | 6309.21 | 6316.26 | 6308.2 | 6315.25 | 5267.0 |
| 2025-07-07 20:00:00 | ES | Futures | 6315.25 | 6322.81 | 6310.47 | 6320.8 | 8532.0 |
| 2025-07-07 21:00:00 | ES | Futures | 6320.54 | 6324.57 | 6317.27 | 6319.03 | 6470.0 |
| 2025-07-07 22:00:00 | ES | Futures | 6319.03 | 6327.09 | 6318.28 | 6326.59 | 3982.0 |
| 2025-07-07 23:00:00 | ES | Futures | 6326.59 | 6326.84 | 6322.05 | 6323.06 | 2965.0 |
| 2025-07-07 00:00:00 | NQ | Futures | 23174.35 | 23190.49 | 23143.83 | 23146.36 | 3513.0 |
| 2025-07-07 01:00:00 | NQ | Futures | 23146.1 | 23151.65 | 23132.23 | 23148.88 | 2869.0 |
| 2025-07-07 02:00:00 | NQ | Futures | 23148.88 | 23151.9 | 23117.61 | 23137.53 | 3651.0 |
| 2025-07-07 03:00:00 | NQ | Futures | 23137.78 | 23149.38 | 23125.93 | 23148.88 | 3875.0 |
| 2025-07-07 04:00:00 | NQ | Futures | 23149.13 | 23149.13 | 23107.77 | 23111.81 | 5663.0 |
| 2025-07-07 05:00:00 | NQ | Futures | 23112.06 | 23166.28 | 23108.53 | 23164.01 | 4222.0 |
| 2025-07-07 06:00:00 | NQ | Futures | 23164.51 | 23190.23 | 23159.47 | 23161.99 | 5088.0 |
| 2025-07-07 07:00:00 | NQ | Futures | 23161.99 | 23185.19 | 23154.17 | 23181.66 | 4591.0 |
| 2025-07-07 08:00:00 | NQ | Futures | 23180.9 | 23202.09 | 23141.31 | 23151.9 | 9440.0 |
| 2025-07-07 09:00:00 | NQ | Futures | 23151.4 | 23177.63 | 23099.96 | 23145.35 | 53236.0 |
| 2025-07-07 10:00:00 | NQ | Futures | 23144.59 | 23162.75 | 23081.8 | 23094.91 | 56097.0 |
| 2025-07-07 11:00:00 | NQ | Futures | 23094.16 | 23137.28 | 23086.59 | 23128.7 | 41709.0 |
| 2025-07-07 12:00:00 | NQ | Futures | 23128.2 | 23162.5 | 23032.37 | 23069.69 | 73090.0 |
| 2025-07-07 13:00:00 | NQ | Futures | 23069.19 | 23129.71 | 23044.98 | 23070.2 | 45273.0 |
| 2025-07-07 14:00:00 | NQ | Futures | 23070.7 | 23080.54 | 22978.15 | 23076.75 | 51741.0 |
| 2025-07-07 15:00:00 | NQ | Futures | 23076.5 | 23090.62 | 23039.68 | 23082.81 | 51317.0 |
| 2025-07-07 16:00:00 | NQ | Futures | 23083.06 | 23086.34 | 23020.77 | 23037.92 | 13131.0 |
| 2025-07-07 18:00:00 | NQ | Futures | 23036.66 | 23052.55 | 23007.15 | 23045.99 | 4412.0 |
| 2025-07-07 19:00:00 | NQ | Futures | 23046.75 | 23079.02 | 23041.45 | 23073.48 | 3389.0 |
| 2025-07-07 20:00:00 | NQ | Futures | 23072.72 | 23113.57 | 23056.58 | 23105.76 | 4718.0 |
| 2025-07-07 21:00:00 | NQ | Futures | 23105.0 | 23123.41 | 23087.35 | 23093.15 | 4472.0 |
| 2025-07-07 22:00:00 | NQ | Futures | 23092.64 | 23138.79 | 23085.58 | 23136.27 | 4301.0 |
| 2025-07-07 23:00:00 | NQ | Futures | 23136.52 | 23138.29 | 23109.54 | 23115.34 | 2897.0 |
| 2025-07-07 00:00:00 | YM | Futures | 45942.1 | 45970.7 | 45919.7 | 45926.8 | 246.0 |
| 2025-07-07 01:00:00 | YM | Futures | 45923.7 | 45960.5 | 45916.6 | 45943.2 | 526.0 |
| 2025-07-07 02:00:00 | YM | Futures | 45943.2 | 45945.2 | 45903.3 | 45925.8 | 704.0 |
| 2025-07-07 03:00:00 | YM | Futures | 45926.8 | 45950.3 | 45907.4 | 45941.1 | 795.0 |
> showing 50 of 2,043 rows — these rows as CSV