PREVIEW / futures_1hour / 2025-07-31
file: by_date/futures_1hour/2025/2025-07-31.parquet size: 67 KB rows: 2,069
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-31 00:00:00 | ES | Futures | 6503.66 | 6507.69 | 6502.14 | 6506.43 | 5721.0 |
| 2025-07-31 01:00:00 | ES | Futures | 6506.43 | 6506.93 | 6501.64 | 6505.67 | 4922.0 |
| 2025-07-31 02:00:00 | ES | Futures | 6505.92 | 6507.69 | 6500.38 | 6502.9 | 8033.0 |
| 2025-07-31 03:00:00 | ES | Futures | 6503.15 | 6517.01 | 6500.13 | 6513.73 | 18700.0 |
| 2025-07-31 04:00:00 | ES | Futures | 6513.73 | 6515.49 | 6508.95 | 6509.95 | 13448.0 |
| 2025-07-31 05:00:00 | ES | Futures | 6510.2 | 6510.96 | 6503.91 | 6505.17 | 9088.0 |
| 2025-07-31 06:00:00 | ES | Futures | 6505.17 | 6509.95 | 6499.63 | 6500.13 | 10906.0 |
| 2025-07-31 07:00:00 | ES | Futures | 6499.88 | 6504.41 | 6497.11 | 6499.37 | 20170.0 |
| 2025-07-31 08:00:00 | ES | Futures | 6499.37 | 6506.93 | 6498.62 | 6504.41 | 31140.0 |
| 2025-07-31 09:00:00 | ES | Futures | 6504.16 | 6504.66 | 6475.7 | 6493.83 | 212336.0 |
| 2025-07-31 10:00:00 | ES | Futures | 6493.83 | 6498.37 | 6465.12 | 6466.13 | 220910.0 |
| 2025-07-31 11:00:00 | ES | Futures | 6465.87 | 6475.7 | 6450.26 | 6475.7 | 203669.0 |
| 2025-07-31 12:00:00 | ES | Futures | 6475.45 | 6483.51 | 6471.92 | 6478.22 | 92009.0 |
| 2025-07-31 13:00:00 | ES | Futures | 6478.22 | 6478.22 | 6430.36 | 6434.39 | 209691.0 |
| 2025-07-31 14:00:00 | ES | Futures | 6434.39 | 6451.01 | 6413.23 | 6441.19 | 184023.0 |
| 2025-07-31 15:00:00 | ES | Futures | 6441.19 | 6447.99 | 6405.93 | 6418.77 | 359011.0 |
| 2025-07-31 16:00:00 | ES | Futures | 6419.03 | 6442.7 | 6405.17 | 6416.51 | 102676.0 |
| 2025-07-31 18:00:00 | ES | Futures | 6407.19 | 6421.29 | 6397.87 | 6406.43 | 16433.0 |
| 2025-07-31 19:00:00 | ES | Futures | 6406.68 | 6411.47 | 6402.65 | 6410.46 | 10601.0 |
| 2025-07-31 20:00:00 | ES | Futures | 6410.21 | 6411.22 | 6393.84 | 6404.42 | 12418.0 |
| 2025-07-31 21:00:00 | ES | Futures | 6404.42 | 6414.49 | 6402.91 | 6412.73 | 8710.0 |
| 2025-07-31 22:00:00 | ES | Futures | 6412.73 | 6417.26 | 6410.21 | 6415.75 | 5264.0 |
| 2025-07-31 23:00:00 | ES | Futures | 6416.0 | 6420.29 | 6409.71 | 6409.96 | 5733.0 |
| 2025-07-31 00:00:00 | NQ | Futures | 24005.52 | 24016.37 | 23990.65 | 24012.59 | 3754.0 |
| 2025-07-31 01:00:00 | NQ | Futures | 24013.09 | 24017.12 | 23991.65 | 24007.54 | 3870.0 |
| 2025-07-31 02:00:00 | NQ | Futures | 24007.04 | 24013.59 | 23984.09 | 24004.26 | 4883.0 |
| 2025-07-31 03:00:00 | NQ | Futures | 24004.77 | 24052.68 | 23990.39 | 24033.01 | 10112.0 |
| 2025-07-31 04:00:00 | NQ | Futures | 24032.76 | 24033.77 | 24001.49 | 24006.53 | 7418.0 |
| 2025-07-31 05:00:00 | NQ | Futures | 24007.29 | 24014.35 | 23989.13 | 23990.9 | 4845.0 |
| 2025-07-31 06:00:00 | NQ | Futures | 23990.65 | 24010.57 | 23980.05 | 23984.09 | 4564.0 |
| 2025-07-31 07:00:00 | NQ | Futures | 23983.33 | 24008.05 | 23959.63 | 23970.47 | 10246.0 |
| 2025-07-31 08:00:00 | NQ | Futures | 23970.47 | 24019.39 | 23962.91 | 24009.05 | 15892.0 |
| 2025-07-31 09:00:00 | NQ | Futures | 24008.8 | 24011.32 | 23814.88 | 23877.42 | 98859.0 |
| 2025-07-31 10:00:00 | NQ | Futures | 23877.42 | 23906.42 | 23739.73 | 23747.04 | 91650.0 |
| 2025-07-31 11:00:00 | NQ | Futures | 23746.29 | 23790.42 | 23687.78 | 23789.66 | 80838.0 |
| 2025-07-31 12:00:00 | NQ | Futures | 23789.16 | 23822.7 | 23762.68 | 23775.29 | 44442.0 |
| 2025-07-31 13:00:00 | NQ | Futures | 23775.54 | 23777.05 | 23568.5 | 23593.21 | 88908.0 |
| 2025-07-31 14:00:00 | NQ | Futures | 23593.47 | 23670.13 | 23508.48 | 23618.68 | 86528.0 |
| 2025-07-31 15:00:00 | NQ | Futures | 23618.68 | 23647.18 | 23514.03 | 23557.4 | 100797.0 |
| 2025-07-31 16:00:00 | NQ | Futures | 23557.66 | 23663.07 | 23493.35 | 23532.69 | 40362.0 |
| 2025-07-31 18:00:00 | NQ | Futures | 23511.51 | 23550.85 | 23444.18 | 23487.8 | 11836.0 |
| 2025-07-31 19:00:00 | NQ | Futures | 23489.32 | 23512.52 | 23467.63 | 23500.41 | 7022.0 |
| 2025-07-31 20:00:00 | NQ | Futures | 23500.41 | 23506.47 | 23433.84 | 23483.01 | 8593.0 |
| 2025-07-31 21:00:00 | NQ | Futures | 23482.51 | 23531.94 | 23474.69 | 23525.38 | 7284.0 |
| 2025-07-31 22:00:00 | NQ | Futures | 23525.63 | 23543.28 | 23517.56 | 23535.72 | 4508.0 |
| 2025-07-31 23:00:00 | NQ | Futures | 23536.22 | 23545.8 | 23505.2 | 23507.47 | 3514.0 |
| 2025-07-31 00:00:00 | YM | Futures | 45719.4 | 45747.0 | 45713.3 | 45730.7 | 311.0 |
| 2025-07-31 01:00:00 | YM | Futures | 45731.7 | 45752.1 | 45713.3 | 45741.9 | 355.0 |
| 2025-07-31 02:00:00 | YM | Futures | 45740.9 | 45754.2 | 45714.3 | 45730.7 | 1100.0 |
| 2025-07-31 03:00:00 | YM | Futures | 45730.7 | 45819.5 | 45712.3 | 45792.0 | 1586.0 |
> showing 50 of 2,069 rows — these rows as CSV