PREVIEW / futures_1hour / 2025-06-17
file: by_date/futures_1hour/2025/2025-06-17.parquet size: 67 KB rows: 2,050
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-06-17 00:00:00 | ES | Futures | 6114.51 | 6118.04 | 6107.71 | 6110.98 | 3199.0 |
| 2025-06-17 01:00:00 | ES | Futures | 6110.98 | 6116.02 | 6107.21 | 6113.25 | 4133.0 |
| 2025-06-17 02:00:00 | ES | Futures | 6113.25 | 6120.55 | 6105.69 | 6108.21 | 8031.0 |
| 2025-06-17 03:00:00 | ES | Futures | 6107.96 | 6114.26 | 6090.58 | 6098.64 | 18101.0 |
| 2025-06-17 04:00:00 | ES | Futures | 6098.89 | 6111.49 | 6095.12 | 6106.7 | 15403.0 |
| 2025-06-17 05:00:00 | ES | Futures | 6106.7 | 6111.99 | 6095.62 | 6099.15 | 10300.0 |
| 2025-06-17 06:00:00 | ES | Futures | 6099.15 | 6104.43 | 6090.33 | 6101.66 | 10447.0 |
| 2025-06-17 07:00:00 | ES | Futures | 6101.41 | 6112.49 | 6099.65 | 6111.74 | 10851.0 |
| 2025-06-17 08:00:00 | ES | Futures | 6111.74 | 6116.78 | 6103.18 | 6104.69 | 24015.0 |
| 2025-06-17 09:00:00 | ES | Futures | 6104.69 | 6118.04 | 6101.66 | 6117.03 | 124304.0 |
| 2025-06-17 10:00:00 | ES | Futures | 6117.03 | 6125.34 | 6111.74 | 6113.25 | 122274.0 |
| 2025-06-17 11:00:00 | ES | Futures | 6113.25 | 6126.85 | 6110.48 | 6115.77 | 103873.0 |
| 2025-06-17 12:00:00 | ES | Futures | 6115.52 | 6124.84 | 6102.92 | 6106.45 | 121785.0 |
| 2025-06-17 13:00:00 | ES | Futures | 6106.45 | 6110.48 | 6082.27 | 6088.31 | 149714.0 |
| 2025-06-17 14:00:00 | ES | Futures | 6088.31 | 6090.08 | 6075.47 | 6089.32 | 128027.0 |
| 2025-06-17 15:00:00 | ES | Futures | 6089.57 | 6095.37 | 6081.26 | 6083.53 | 184496.0 |
| 2025-06-17 16:00:00 | ES | Futures | 6083.78 | 6089.83 | 6079.0 | 6083.03 | 49977.0 |
| 2025-06-17 18:00:00 | ES | Futures | 6075.97 | 6081.01 | 6063.13 | 6064.89 | 10029.0 |
| 2025-06-17 19:00:00 | ES | Futures | 6064.64 | 6074.71 | 6062.88 | 6069.68 | 9683.0 |
| 2025-06-17 20:00:00 | ES | Futures | 6069.93 | 6090.33 | 6069.68 | 6088.31 | 12130.0 |
| 2025-06-17 21:00:00 | ES | Futures | 6088.06 | 6094.61 | 6085.04 | 6087.06 | 6662.0 |
| 2025-06-17 22:00:00 | ES | Futures | 6087.56 | 6093.6 | 6085.04 | 6087.81 | 3468.0 |
| 2025-06-17 23:00:00 | ES | Futures | 6087.81 | 6089.32 | 6085.54 | 6086.3 | 2946.0 |
| 2025-06-17 00:00:00 | NQ | Futures | 22272.06 | 22288.7 | 22244.32 | 22261.97 | 3497.0 |
| 2025-06-17 01:00:00 | NQ | Futures | 22262.22 | 22287.44 | 22248.86 | 22274.83 | 3491.0 |
| 2025-06-17 02:00:00 | NQ | Futures | 22274.33 | 22314.93 | 22249.11 | 22257.43 | 5674.0 |
| 2025-06-17 03:00:00 | NQ | Futures | 22256.93 | 22281.89 | 22195.65 | 22233.47 | 7092.0 |
| 2025-06-17 04:00:00 | NQ | Futures | 22231.2 | 22275.59 | 22214.31 | 22257.18 | 4937.0 |
| 2025-06-17 05:00:00 | NQ | Futures | 22257.68 | 22276.34 | 22213.05 | 22224.9 | 3574.0 |
| 2025-06-17 06:00:00 | NQ | Futures | 22224.9 | 22247.09 | 22187.58 | 22231.46 | 4532.0 |
| 2025-06-17 07:00:00 | NQ | Futures | 22230.45 | 22267.27 | 22221.62 | 22264.74 | 4435.0 |
| 2025-06-17 08:00:00 | NQ | Futures | 22265.0 | 22293.49 | 22231.71 | 22243.81 | 8757.0 |
| 2025-06-17 09:00:00 | NQ | Futures | 22243.56 | 22302.57 | 22217.84 | 22287.94 | 42615.0 |
| 2025-06-17 10:00:00 | NQ | Futures | 22287.44 | 22326.27 | 22261.97 | 22268.27 | 42041.0 |
| 2025-06-17 11:00:00 | NQ | Futures | 22268.02 | 22327.79 | 22265.0 | 22289.96 | 39150.0 |
| 2025-06-17 12:00:00 | NQ | Futures | 22289.96 | 22325.01 | 22216.33 | 22227.93 | 42890.0 |
| 2025-06-17 13:00:00 | NQ | Futures | 22228.18 | 22249.87 | 22131.85 | 22153.53 | 50400.0 |
| 2025-06-17 14:00:00 | NQ | Futures | 22153.03 | 22169.92 | 22100.32 | 22168.16 | 40268.0 |
| 2025-06-17 15:00:00 | NQ | Futures | 22168.66 | 22196.66 | 22136.13 | 22147.99 | 43759.0 |
| 2025-06-17 16:00:00 | NQ | Futures | 22148.24 | 22173.96 | 22128.32 | 22143.19 | 12106.0 |
| 2025-06-17 18:00:00 | NQ | Futures | 22118.48 | 22131.59 | 22053.42 | 22063.51 | 4819.0 |
| 2025-06-17 19:00:00 | NQ | Futures | 22062.5 | 22116.97 | 22052.66 | 22096.04 | 5067.0 |
| 2025-06-17 20:00:00 | NQ | Futures | 22096.29 | 22179.26 | 22094.78 | 22169.42 | 6867.0 |
| 2025-06-17 21:00:00 | NQ | Futures | 22169.42 | 22202.46 | 22154.29 | 22165.39 | 5320.0 |
| 2025-06-17 22:00:00 | NQ | Futures | 22165.89 | 22193.63 | 22154.54 | 22168.41 | 2654.0 |
| 2025-06-17 23:00:00 | NQ | Futures | 22169.92 | 22175.98 | 22158.83 | 22161.35 | 2373.0 |
| 2025-06-17 00:00:00 | YM | Futures | 43649.7 | 43671.2 | 43610.9 | 43627.3 | 375.0 |
| 2025-06-17 01:00:00 | YM | Futures | 43629.3 | 43649.7 | 43600.7 | 43633.4 | 588.0 |
| 2025-06-17 02:00:00 | YM | Futures | 43632.4 | 43673.2 | 43580.3 | 43590.5 | 1542.0 |
| 2025-06-17 03:00:00 | YM | Futures | 43591.5 | 43629.3 | 43449.5 | 43505.7 | 3742.0 |
> showing 50 of 2,050 rows — these rows as CSV