PREVIEW / futures_1hour / 2025-07-13
file: by_date/futures_1hour/2025/2025-07-13.parquet size: 19 KB rows: 430
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-13 18:00:00 | ES | Futures | 6321.05 | 6327.6 | 6309.96 | 6325.58 | 18134.0 |
| 2025-07-13 19:00:00 | ES | Futures | 6325.58 | 6326.34 | 6315.25 | 6322.56 | 9200.0 |
| 2025-07-13 20:00:00 | ES | Futures | 6322.56 | 6325.33 | 6317.52 | 6317.77 | 7196.0 |
| 2025-07-13 21:00:00 | ES | Futures | 6318.02 | 6320.29 | 6315.25 | 6319.03 | 5681.0 |
| 2025-07-13 22:00:00 | ES | Futures | 6318.78 | 6321.8 | 6317.27 | 6317.77 | 3722.0 |
| 2025-07-13 23:00:00 | ES | Futures | 6317.52 | 6320.8 | 6316.01 | 6320.29 | 2914.0 |
| 2025-07-13 18:00:00 | NQ | Futures | 23059.86 | 23089.87 | 23001.61 | 23081.29 | 9384.0 |
| 2025-07-13 19:00:00 | NQ | Futures | 23081.29 | 23085.83 | 23036.41 | 23065.91 | 7701.0 |
| 2025-07-13 20:00:00 | NQ | Futures | 23066.16 | 23077.01 | 23048.01 | 23050.02 | 5462.0 |
| 2025-07-13 21:00:00 | NQ | Futures | 23050.02 | 23064.4 | 23040.44 | 23056.58 | 5516.0 |
| 2025-07-13 22:00:00 | NQ | Futures | 23055.82 | 23071.71 | 23054.31 | 23056.33 | 2914.0 |
| 2025-07-13 23:00:00 | NQ | Futures | 23056.58 | 23076.0 | 23049.77 | 23073.48 | 2437.0 |
| 2025-07-13 18:00:00 | YM | Futures | 45410.9 | 45416.0 | 45287.3 | 45404.8 | 1463.0 |
| 2025-07-13 19:00:00 | YM | Futures | 45403.8 | 45410.9 | 45340.4 | 45392.5 | 1037.0 |
| 2025-07-13 20:00:00 | YM | Futures | 45394.6 | 45416.0 | 45355.7 | 45358.8 | 874.0 |
| 2025-07-13 21:00:00 | YM | Futures | 45359.8 | 45378.2 | 45333.3 | 45360.9 | 853.0 |
| 2025-07-13 22:00:00 | YM | Futures | 45363.9 | 45379.2 | 45344.5 | 45348.6 | 543.0 |
| 2025-07-13 23:00:00 | YM | Futures | 45347.6 | 45364.9 | 45334.3 | 45361.9 | 494.0 |
| 2025-07-13 18:00:00 | CL | Futures | 64.58 | 64.75 | 64.3 | 64.32 | 745.0 |
| 2025-07-13 19:00:00 | CL | Futures | 64.33 | 64.42 | 64.31 | 64.41 | 216.0 |
| 2025-07-13 20:00:00 | CL | Futures | 64.42 | 64.48 | 64.32 | 64.43 | 420.0 |
| 2025-07-13 21:00:00 | CL | Futures | 64.43 | 64.48 | 64.26 | 64.31 | 533.0 |
| 2025-07-13 22:00:00 | CL | Futures | 64.32 | 64.39 | 64.27 | 64.39 | 250.0 |
| 2025-07-13 23:00:00 | CL | Futures | 64.39 | 64.42 | 64.34 | 64.41 | 148.0 |
| 2025-07-13 18:00:00 | GC | Futures | 3488.2 | 3499.7 | 3488.2 | 3497.7 | 7109.0 |
| 2025-07-13 19:00:00 | GC | Futures | 3497.8 | 3501.4 | 3493.5 | 3494.6 | 3804.0 |
| 2025-07-13 20:00:00 | GC | Futures | 3494.3 | 3500.0 | 3490.6 | 3494.2 | 4446.0 |
| 2025-07-13 21:00:00 | GC | Futures | 3494.4 | 3497.2 | 3483.6 | 3485.3 | 6254.0 |
| 2025-07-13 22:00:00 | GC | Futures | 3485.3 | 3487.4 | 3480.9 | 3484.3 | 5000.0 |
| 2025-07-13 23:00:00 | GC | Futures | 3484.4 | 3486.7 | 3482.2 | 3484.3 | 2735.0 |
| 2025-07-13 18:00:00 | ZN | Futures | 110.843419 | 110.890301 | 110.827792 | 110.843419 | 12767.0 |
| 2025-07-13 19:00:00 | ZN | Futures | 110.827792 | 110.874674 | 110.812165 | 110.859046 | 7559.0 |
| 2025-07-13 20:00:00 | ZN | Futures | 110.843419 | 110.859046 | 110.780911 | 110.827792 | 10851.0 |
| 2025-07-13 21:00:00 | ZN | Futures | 110.827792 | 110.859046 | 110.796538 | 110.843419 | 9466.0 |
| 2025-07-13 22:00:00 | ZN | Futures | 110.859046 | 110.890301 | 110.843419 | 110.859046 | 7849.0 |
| 2025-07-13 23:00:00 | ZN | Futures | 110.874674 | 110.890301 | 110.843419 | 110.843419 | 19013.0 |
> showing 36 of 430 rows — these rows as CSV