PREVIEW / futures_1hour / 2025-08-04
file: by_date/futures_1hour/2025/2025-08-04.parquet size: 67 KB rows: 2,063
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-08-04 00:00:00 | ES | Futures | 6336.92 | 6337.17 | 6326.84 | 6332.89 | 6692.0 |
| 2025-08-04 01:00:00 | ES | Futures | 6332.89 | 6338.93 | 6330.62 | 6336.41 | 5946.0 |
| 2025-08-04 02:00:00 | ES | Futures | 6336.41 | 6340.19 | 6326.34 | 6336.16 | 12125.0 |
| 2025-08-04 03:00:00 | ES | Futures | 6336.16 | 6350.77 | 6333.14 | 6343.21 | 22193.0 |
| 2025-08-04 04:00:00 | ES | Futures | 6343.21 | 6354.04 | 6342.46 | 6353.04 | 14726.0 |
| 2025-08-04 05:00:00 | ES | Futures | 6353.29 | 6357.32 | 6351.27 | 6351.52 | 14261.0 |
| 2025-08-04 06:00:00 | ES | Futures | 6351.52 | 6354.8 | 6347.49 | 6348.75 | 14347.0 |
| 2025-08-04 07:00:00 | ES | Futures | 6349.01 | 6351.02 | 6341.7 | 6343.46 | 15644.0 |
| 2025-08-04 08:00:00 | ES | Futures | 6343.72 | 6352.28 | 6341.95 | 6347.24 | 21125.0 |
| 2025-08-04 09:00:00 | ES | Futures | 6347.24 | 6386.53 | 6345.48 | 6384.27 | 203566.0 |
| 2025-08-04 10:00:00 | ES | Futures | 6384.52 | 6392.58 | 6376.96 | 6386.53 | 194220.0 |
| 2025-08-04 11:00:00 | ES | Futures | 6386.28 | 6395.35 | 6379.99 | 6393.08 | 119433.0 |
| 2025-08-04 12:00:00 | ES | Futures | 6393.08 | 6398.88 | 6390.31 | 6395.6 | 85852.0 |
| 2025-08-04 13:00:00 | ES | Futures | 6395.6 | 6399.63 | 6387.54 | 6392.08 | 80589.0 |
| 2025-08-04 14:00:00 | ES | Futures | 6391.82 | 6398.12 | 6391.07 | 6392.83 | 75239.0 |
| 2025-08-04 15:00:00 | ES | Futures | 6392.83 | 6406.18 | 6391.07 | 6404.92 | 220917.0 |
| 2025-08-04 16:00:00 | ES | Futures | 6404.67 | 6417.77 | 6402.65 | 6417.26 | 60333.0 |
| 2025-08-04 18:00:00 | ES | Futures | 6417.77 | 6419.53 | 6410.71 | 6412.73 | 5730.0 |
| 2025-08-04 19:00:00 | ES | Futures | 6412.73 | 6417.01 | 6409.96 | 6411.72 | 5001.0 |
| 2025-08-04 20:00:00 | ES | Futures | 6411.72 | 6423.81 | 6407.94 | 6416.0 | 10381.0 |
| 2025-08-04 21:00:00 | ES | Futures | 6416.26 | 6420.79 | 6411.97 | 6412.98 | 6801.0 |
| 2025-08-04 22:00:00 | ES | Futures | 6412.73 | 6414.74 | 6411.22 | 6413.23 | 3348.0 |
| 2025-08-04 23:00:00 | ES | Futures | 6413.23 | 6416.51 | 6410.21 | 6412.98 | 3782.0 |
| 2025-08-04 00:00:00 | NQ | Futures | 23187.21 | 23187.97 | 23152.41 | 23170.06 | 3491.0 |
| 2025-08-04 01:00:00 | NQ | Futures | 23170.06 | 23196.29 | 23161.23 | 23183.17 | 3998.0 |
| 2025-08-04 02:00:00 | NQ | Futures | 23183.43 | 23200.83 | 23147.36 | 23190.99 | 6404.0 |
| 2025-08-04 03:00:00 | NQ | Futures | 23191.5 | 23245.46 | 23178.38 | 23211.67 | 9991.0 |
| 2025-08-04 04:00:00 | NQ | Futures | 23211.67 | 23264.12 | 23206.37 | 23261.6 | 8057.0 |
| 2025-08-04 05:00:00 | NQ | Futures | 23261.1 | 23278.5 | 23254.79 | 23256.05 | 5578.0 |
| 2025-08-04 06:00:00 | NQ | Futures | 23255.8 | 23279.0 | 23253.03 | 23262.61 | 6033.0 |
| 2025-08-04 07:00:00 | NQ | Futures | 23263.11 | 23276.98 | 23232.1 | 23245.46 | 8378.0 |
| 2025-08-04 08:00:00 | NQ | Futures | 23246.22 | 23282.78 | 23237.39 | 23276.98 | 9607.0 |
| 2025-08-04 09:00:00 | NQ | Futures | 23276.48 | 23460.32 | 23271.44 | 23448.46 | 78331.0 |
| 2025-08-04 10:00:00 | NQ | Futures | 23449.22 | 23466.87 | 23396.01 | 23417.19 | 68164.0 |
| 2025-08-04 11:00:00 | NQ | Futures | 23417.19 | 23466.12 | 23389.71 | 23456.53 | 43965.0 |
| 2025-08-04 12:00:00 | NQ | Futures | 23456.79 | 23482.26 | 23450.48 | 23473.18 | 32284.0 |
| 2025-08-04 13:00:00 | NQ | Futures | 23472.67 | 23488.06 | 23443.67 | 23470.66 | 30663.0 |
| 2025-08-04 14:00:00 | NQ | Futures | 23470.91 | 23486.54 | 23458.3 | 23464.1 | 26604.0 |
| 2025-08-04 15:00:00 | NQ | Futures | 23463.59 | 23510.25 | 23455.78 | 23500.16 | 58346.0 |
| 2025-08-04 16:00:00 | NQ | Futures | 23499.91 | 23555.89 | 23487.8 | 23554.13 | 23816.0 |
| 2025-08-04 18:00:00 | NQ | Futures | 23557.4 | 23563.46 | 23519.33 | 23529.92 | 3885.0 |
| 2025-08-04 19:00:00 | NQ | Futures | 23530.42 | 23552.87 | 23517.81 | 23537.99 | 3661.0 |
| 2025-08-04 20:00:00 | NQ | Futures | 23537.23 | 23578.08 | 23516.8 | 23550.6 | 5818.0 |
| 2025-08-04 21:00:00 | NQ | Futures | 23549.84 | 23576.07 | 23538.24 | 23544.04 | 5060.0 |
| 2025-08-04 22:00:00 | NQ | Futures | 23543.54 | 23551.35 | 23535.47 | 23543.54 | 1692.0 |
| 2025-08-04 23:00:00 | NQ | Futures | 23544.29 | 23560.68 | 23528.15 | 23545.8 | 2659.0 |
| 2025-08-04 00:00:00 | YM | Futures | 44807.2 | 44807.2 | 44744.8 | 44776.5 | 448.0 |
| 2025-08-04 01:00:00 | YM | Futures | 44777.5 | 44824.5 | 44771.4 | 44807.2 | 463.0 |
| 2025-08-04 02:00:00 | YM | Futures | 44806.1 | 44828.6 | 44731.6 | 44794.9 | 1203.0 |
| 2025-08-04 03:00:00 | YM | Futures | 44793.9 | 44898.1 | 44770.4 | 44862.3 | 1871.0 |
> showing 50 of 2,063 rows — these rows as CSV