PREVIEW / futures_1hour / 2025-10-16
file: by_date/futures_1hour/2025/2025-10-16.parquet size: 67 KB rows: 2,102
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-16 00:00:00 | ES | Futures | 6760.06 | 6765.1 | 6759.06 | 6762.84 | 3425.0 |
| 2025-10-16 01:00:00 | ES | Futures | 6763.09 | 6770.39 | 6761.07 | 6766.36 | 7129.0 |
| 2025-10-16 02:00:00 | ES | Futures | 6766.36 | 6780.72 | 6766.36 | 6779.96 | 10154.0 |
| 2025-10-16 03:00:00 | ES | Futures | 6779.96 | 6786.51 | 6768.63 | 6782.73 | 22064.0 |
| 2025-10-16 04:00:00 | ES | Futures | 6782.48 | 6788.02 | 6776.69 | 6779.71 | 12032.0 |
| 2025-10-16 05:00:00 | ES | Futures | 6779.71 | 6787.52 | 6778.45 | 6786.76 | 10570.0 |
| 2025-10-16 06:00:00 | ES | Futures | 6787.02 | 6794.07 | 6786.26 | 6789.53 | 13180.0 |
| 2025-10-16 07:00:00 | ES | Futures | 6789.53 | 6795.83 | 6788.53 | 6790.29 | 14666.0 |
| 2025-10-16 08:00:00 | ES | Futures | 6790.29 | 6797.09 | 6782.99 | 6792.3 | 29175.0 |
| 2025-10-16 09:00:00 | ES | Futures | 6792.56 | 6794.82 | 6774.67 | 6779.96 | 171594.0 |
| 2025-10-16 10:00:00 | ES | Futures | 6780.21 | 6801.12 | 6767.62 | 6784.24 | 269634.0 |
| 2025-10-16 11:00:00 | ES | Futures | 6784.5 | 6794.32 | 6752.0 | 6757.8 | 267917.0 |
| 2025-10-16 12:00:00 | ES | Futures | 6758.05 | 6764.35 | 6704.65 | 6745.96 | 367379.0 |
| 2025-10-16 13:00:00 | ES | Futures | 6745.71 | 6755.03 | 6723.04 | 6730.09 | 241163.0 |
| 2025-10-16 14:00:00 | ES | Futures | 6730.09 | 6731.6 | 6681.73 | 6716.99 | 321102.0 |
| 2025-10-16 15:00:00 | ES | Futures | 6716.74 | 6724.3 | 6691.3 | 6718.51 | 289964.0 |
| 2025-10-16 16:00:00 | ES | Futures | 6718.76 | 6723.79 | 6700.87 | 6709.19 | 62578.0 |
| 2025-10-16 18:00:00 | ES | Futures | 6709.19 | 6719.26 | 6694.07 | 6694.33 | 11717.0 |
| 2025-10-16 19:00:00 | ES | Futures | 6694.58 | 6701.88 | 6691.55 | 6701.13 | 13242.0 |
| 2025-10-16 20:00:00 | ES | Futures | 6701.13 | 6707.93 | 6698.1 | 6701.38 | 12690.0 |
| 2025-10-16 21:00:00 | ES | Futures | 6701.38 | 6712.96 | 6692.31 | 6698.1 | 12499.0 |
| 2025-10-16 22:00:00 | ES | Futures | 6698.36 | 6700.37 | 6692.56 | 6697.85 | 8046.0 |
| 2025-10-16 23:00:00 | ES | Futures | 6697.85 | 6700.12 | 6686.01 | 6691.81 | 10287.0 |
| 2025-10-16 00:00:00 | NQ | Futures | 25133.03 | 25158.5 | 25128.74 | 25147.15 | 2360.0 |
| 2025-10-16 01:00:00 | NQ | Futures | 25147.66 | 25194.31 | 25136.81 | 25171.87 | 5427.0 |
| 2025-10-16 02:00:00 | NQ | Futures | 25172.37 | 25247.02 | 25171.36 | 25244.25 | 7043.0 |
| 2025-10-16 03:00:00 | NQ | Futures | 25243.24 | 25274.76 | 25191.54 | 25257.86 | 11892.0 |
| 2025-10-16 04:00:00 | NQ | Futures | 25257.86 | 25276.02 | 25223.82 | 25237.69 | 6811.0 |
| 2025-10-16 05:00:00 | NQ | Futures | 25238.7 | 25264.92 | 25224.58 | 25260.39 | 5900.0 |
| 2025-10-16 06:00:00 | NQ | Futures | 25261.39 | 25290.65 | 25258.37 | 25271.99 | 6324.0 |
| 2025-10-16 07:00:00 | NQ | Futures | 25272.49 | 25304.52 | 25264.67 | 25284.34 | 5590.0 |
| 2025-10-16 08:00:00 | NQ | Futures | 25283.33 | 25318.89 | 25238.7 | 25299.22 | 13843.0 |
| 2025-10-16 09:00:00 | NQ | Futures | 25299.47 | 25345.12 | 25245.51 | 25281.32 | 80605.0 |
| 2025-10-16 10:00:00 | NQ | Futures | 25281.32 | 25399.59 | 25232.39 | 25325.95 | 98379.0 |
| 2025-10-16 11:00:00 | NQ | Futures | 25326.71 | 25350.92 | 25164.05 | 25190.53 | 87024.0 |
| 2025-10-16 12:00:00 | NQ | Futures | 25191.03 | 25214.99 | 24948.18 | 25145.39 | 117013.0 |
| 2025-10-16 13:00:00 | NQ | Futures | 25145.14 | 25185.23 | 25043.25 | 25082.85 | 73256.0 |
| 2025-10-16 14:00:00 | NQ | Futures | 25081.84 | 25088.9 | 24858.91 | 25015.26 | 85421.0 |
| 2025-10-16 15:00:00 | NQ | Futures | 25013.75 | 25063.18 | 24908.33 | 25047.79 | 73312.0 |
| 2025-10-16 16:00:00 | NQ | Futures | 25047.54 | 25071.75 | 24961.8 | 25010.97 | 18067.0 |
| 2025-10-16 18:00:00 | NQ | Futures | 25010.47 | 25075.79 | 24956.5 | 24957.76 | 8001.0 |
| 2025-10-16 19:00:00 | NQ | Futures | 24959.02 | 24985.0 | 24936.08 | 24974.66 | 7907.0 |
| 2025-10-16 20:00:00 | NQ | Futures | 24975.67 | 25011.73 | 24961.55 | 24994.58 | 7004.0 |
| 2025-10-16 21:00:00 | NQ | Futures | 24995.09 | 25052.84 | 24945.66 | 24975.16 | 7464.0 |
| 2025-10-16 22:00:00 | NQ | Futures | 24974.91 | 24989.29 | 24945.41 | 24981.72 | 4643.0 |
| 2025-10-16 23:00:00 | NQ | Futures | 24980.96 | 24984.75 | 24921.2 | 24948.43 | 4912.0 |
| 2025-10-16 00:00:00 | YM | Futures | 47130.9 | 47157.2 | 47122.7 | 47153.2 | 470.0 |
| 2025-10-16 01:00:00 | YM | Futures | 47153.2 | 47184.6 | 47129.8 | 47159.3 | 1036.0 |
| 2025-10-16 02:00:00 | YM | Futures | 47160.3 | 47222.1 | 47158.2 | 47215.0 | 1474.0 |
| 2025-10-16 03:00:00 | YM | Futures | 47217.1 | 47271.8 | 47163.3 | 47245.5 | 3122.0 |
> showing 50 of 2,102 rows — these rows as CSV