PREVIEW / futures_1hour / 2025-10-09
file: by_date/futures_1hour/2025/2025-10-09.parquet size: 65 KB rows: 2,062
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-10-09 00:00:00 | ES | Futures | 6848.47 | 6853.01 | 6848.22 | 6852.75 | 3202.0 |
| 2025-10-09 01:00:00 | ES | Futures | 6852.5 | 6857.54 | 6851.5 | 6855.78 | 4350.0 |
| 2025-10-09 02:00:00 | ES | Futures | 6856.03 | 6858.55 | 6850.24 | 6852.5 | 6651.0 |
| 2025-10-09 03:00:00 | ES | Futures | 6852.75 | 6855.27 | 6850.24 | 6852.5 | 11454.0 |
| 2025-10-09 04:00:00 | ES | Futures | 6852.25 | 6853.76 | 6846.71 | 6848.22 | 11198.0 |
| 2025-10-09 05:00:00 | ES | Futures | 6848.47 | 6854.77 | 6846.46 | 6851.5 | 8629.0 |
| 2025-10-09 06:00:00 | ES | Futures | 6851.5 | 6853.51 | 6847.97 | 6850.49 | 6825.0 |
| 2025-10-09 07:00:00 | ES | Futures | 6850.49 | 6856.78 | 6850.49 | 6850.74 | 11201.0 |
| 2025-10-09 08:00:00 | ES | Futures | 6850.99 | 6856.28 | 6850.99 | 6856.03 | 16002.0 |
| 2025-10-09 09:00:00 | ES | Futures | 6856.03 | 6860.56 | 6836.13 | 6839.91 | 155663.0 |
| 2025-10-09 10:00:00 | ES | Futures | 6839.66 | 6842.93 | 6819.26 | 6833.61 | 232982.0 |
| 2025-10-09 11:00:00 | ES | Futures | 6833.61 | 6838.9 | 6819.76 | 6833.11 | 157322.0 |
| 2025-10-09 12:00:00 | ES | Futures | 6833.36 | 6836.13 | 6816.23 | 6817.74 | 133423.0 |
| 2025-10-09 13:00:00 | ES | Futures | 6817.74 | 6823.54 | 6811.45 | 6821.52 | 160870.0 |
| 2025-10-09 14:00:00 | ES | Futures | 6821.52 | 6823.03 | 6812.96 | 6818.5 | 100378.0 |
| 2025-10-09 15:00:00 | ES | Futures | 6818.5 | 6832.86 | 6817.74 | 6832.1 | 211497.0 |
| 2025-10-09 16:00:00 | ES | Futures | 6832.1 | 6833.36 | 6826.31 | 6830.59 | 44995.0 |
| 2025-10-09 18:00:00 | ES | Futures | 6830.34 | 6837.39 | 6829.83 | 6836.13 | 5322.0 |
| 2025-10-09 19:00:00 | ES | Futures | 6836.38 | 6840.41 | 6834.87 | 6840.16 | 3522.0 |
| 2025-10-09 20:00:00 | ES | Futures | 6840.16 | 6842.68 | 6836.63 | 6840.92 | 7018.0 |
| 2025-10-09 21:00:00 | ES | Futures | 6841.17 | 6843.69 | 6840.16 | 6843.44 | 4963.0 |
| 2025-10-09 22:00:00 | ES | Futures | 6843.18 | 6843.69 | 6839.66 | 6840.16 | 2822.0 |
| 2025-10-09 23:00:00 | ES | Futures | 6840.16 | 6841.17 | 6835.38 | 6836.63 | 4662.0 |
| 2025-10-09 00:00:00 | NQ | Futures | 25548.38 | 25563.76 | 25545.61 | 25561.75 | 2130.0 |
| 2025-10-09 01:00:00 | NQ | Futures | 25561.75 | 25586.46 | 25557.46 | 25576.88 | 3324.0 |
| 2025-10-09 02:00:00 | NQ | Futures | 25577.89 | 25589.49 | 25547.62 | 25558.72 | 3496.0 |
| 2025-10-09 03:00:00 | NQ | Futures | 25558.22 | 25570.83 | 25544.35 | 25558.97 | 4147.0 |
| 2025-10-09 04:00:00 | NQ | Futures | 25558.22 | 25565.53 | 25515.34 | 25521.9 | 6601.0 |
| 2025-10-09 05:00:00 | NQ | Futures | 25521.65 | 25560.74 | 25516.35 | 25542.58 | 4227.0 |
| 2025-10-09 06:00:00 | NQ | Futures | 25542.58 | 25554.18 | 25524.68 | 25539.55 | 4359.0 |
| 2025-10-09 07:00:00 | NQ | Futures | 25539.05 | 25562.76 | 25533.0 | 25535.02 | 4889.0 |
| 2025-10-09 08:00:00 | NQ | Futures | 25535.52 | 25555.69 | 25531.74 | 25553.93 | 6353.0 |
| 2025-10-09 09:00:00 | NQ | Futures | 25554.18 | 25559.23 | 25472.22 | 25499.71 | 72472.0 |
| 2025-10-09 10:00:00 | NQ | Futures | 25500.47 | 25509.8 | 25413.71 | 25471.21 | 84101.0 |
| 2025-10-09 11:00:00 | NQ | Futures | 25472.22 | 25495.42 | 25418.0 | 25483.82 | 64165.0 |
| 2025-10-09 12:00:00 | NQ | Futures | 25484.07 | 25494.92 | 25416.24 | 25424.05 | 49044.0 |
| 2025-10-09 13:00:00 | NQ | Futures | 25424.56 | 25454.32 | 25380.68 | 25435.91 | 57276.0 |
| 2025-10-09 14:00:00 | NQ | Futures | 25435.91 | 25464.66 | 25402.62 | 25455.58 | 36028.0 |
| 2025-10-09 15:00:00 | NQ | Futures | 25455.83 | 25516.86 | 25453.81 | 25515.6 | 53381.0 |
| 2025-10-09 16:00:00 | NQ | Futures | 25515.85 | 25520.89 | 25491.14 | 25508.28 | 12370.0 |
| 2025-10-09 18:00:00 | NQ | Futures | 25508.79 | 25542.83 | 25507.53 | 25540.56 | 3590.0 |
| 2025-10-09 19:00:00 | NQ | Futures | 25540.82 | 25557.46 | 25529.97 | 25556.45 | 3152.0 |
| 2025-10-09 20:00:00 | NQ | Futures | 25556.45 | 25568.3 | 25542.58 | 25557.96 | 3422.0 |
| 2025-10-09 21:00:00 | NQ | Futures | 25558.22 | 25574.61 | 25554.43 | 25573.35 | 2265.0 |
| 2025-10-09 22:00:00 | NQ | Futures | 25572.84 | 25576.88 | 25557.71 | 25559.73 | 1976.0 |
| 2025-10-09 23:00:00 | NQ | Futures | 25559.48 | 25563.26 | 25531.48 | 25538.29 | 3364.0 |
| 2025-10-09 00:00:00 | YM | Futures | 47475.7 | 47509.1 | 47470.6 | 47508.1 | 327.0 |
| 2025-10-09 01:00:00 | YM | Futures | 47509.1 | 47545.6 | 47501.0 | 47536.5 | 587.0 |
| 2025-10-09 02:00:00 | YM | Futures | 47535.5 | 47555.8 | 47509.1 | 47527.4 | 780.0 |
| 2025-10-09 03:00:00 | YM | Futures | 47527.4 | 47549.7 | 47519.3 | 47519.3 | 1125.0 |
> showing 50 of 2,062 rows — these rows as CSV