PREVIEW / futures_1hour / 2025-09-30
file: by_date/futures_1hour/2025/2025-09-30.parquet size: 64 KB rows: 2,049
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-09-30 00:00:00 | ES | Futures | 6763.84 | 6764.35 | 6759.06 | 6759.06 | 3564.0 |
| 2025-09-30 01:00:00 | ES | Futures | 6759.06 | 6763.09 | 6757.8 | 6762.08 | 3750.0 |
| 2025-09-30 02:00:00 | ES | Futures | 6762.33 | 6766.11 | 6755.53 | 6756.03 | 6788.0 |
| 2025-09-30 03:00:00 | ES | Futures | 6756.03 | 6757.55 | 6744.45 | 6753.01 | 16415.0 |
| 2025-09-30 04:00:00 | ES | Futures | 6752.51 | 6755.53 | 6745.96 | 6753.26 | 11078.0 |
| 2025-09-30 05:00:00 | ES | Futures | 6753.01 | 6755.78 | 6749.99 | 6751.75 | 9028.0 |
| 2025-09-30 06:00:00 | ES | Futures | 6751.5 | 6754.52 | 6745.96 | 6753.52 | 9196.0 |
| 2025-09-30 07:00:00 | ES | Futures | 6753.52 | 6755.03 | 6748.73 | 6751.75 | 10779.0 |
| 2025-09-30 08:00:00 | ES | Futures | 6751.75 | 6760.82 | 6748.23 | 6758.3 | 21085.0 |
| 2025-09-30 09:00:00 | ES | Futures | 6758.55 | 6760.57 | 6746.97 | 6758.55 | 132347.0 |
| 2025-09-30 10:00:00 | ES | Futures | 6758.05 | 6763.34 | 6744.2 | 6760.06 | 215325.0 |
| 2025-09-30 11:00:00 | ES | Futures | 6759.81 | 6764.09 | 6743.19 | 6757.29 | 163062.0 |
| 2025-09-30 12:00:00 | ES | Futures | 6757.55 | 6768.38 | 6753.01 | 6755.28 | 110255.0 |
| 2025-09-30 13:00:00 | ES | Futures | 6755.28 | 6758.05 | 6744.45 | 6752.26 | 129498.0 |
| 2025-09-30 14:00:00 | ES | Futures | 6752.0 | 6773.67 | 6751.0 | 6771.4 | 138650.0 |
| 2025-09-30 15:00:00 | ES | Futures | 6771.65 | 6794.07 | 6770.9 | 6787.77 | 338048.0 |
| 2025-09-30 16:00:00 | ES | Futures | 6787.52 | 6789.28 | 6772.41 | 6774.42 | 81072.0 |
| 2025-09-30 18:00:00 | ES | Futures | 6775.93 | 6783.74 | 6771.15 | 6774.17 | 10629.0 |
| 2025-09-30 19:00:00 | ES | Futures | 6774.17 | 6777.19 | 6770.64 | 6773.92 | 4443.0 |
| 2025-09-30 20:00:00 | ES | Futures | 6773.92 | 6775.43 | 6763.59 | 6765.1 | 10088.0 |
| 2025-09-30 21:00:00 | ES | Futures | 6765.1 | 6767.37 | 6762.08 | 6765.1 | 6597.0 |
| 2025-09-30 22:00:00 | ES | Futures | 6765.1 | 6765.35 | 6760.32 | 6761.32 | 5247.0 |
| 2025-09-30 23:00:00 | ES | Futures | 6761.32 | 6761.58 | 6756.29 | 6758.55 | 5796.0 |
| 2025-09-30 00:00:00 | NQ | Futures | 25059.9 | 25063.18 | 25039.98 | 25040.23 | 1886.0 |
| 2025-09-30 01:00:00 | NQ | Futures | 25039.98 | 25057.38 | 25033.17 | 25053.34 | 2316.0 |
| 2025-09-30 02:00:00 | NQ | Futures | 25053.59 | 25072.76 | 25026.86 | 25029.13 | 4058.0 |
| 2025-09-30 03:00:00 | NQ | Futures | 25029.13 | 25035.18 | 24971.13 | 25007.44 | 9724.0 |
| 2025-09-30 04:00:00 | NQ | Futures | 25006.69 | 25028.88 | 24979.45 | 25017.78 | 5846.0 |
| 2025-09-30 05:00:00 | NQ | Futures | 25017.28 | 25037.2 | 25002.65 | 25011.48 | 5271.0 |
| 2025-09-30 06:00:00 | NQ | Futures | 25010.97 | 25031.91 | 24990.55 | 25025.35 | 5095.0 |
| 2025-09-30 07:00:00 | NQ | Futures | 25024.59 | 25033.92 | 25006.44 | 25019.8 | 4790.0 |
| 2025-09-30 08:00:00 | NQ | Futures | 25019.8 | 25062.17 | 25004.67 | 25050.82 | 9358.0 |
| 2025-09-30 09:00:00 | NQ | Futures | 25050.06 | 25054.1 | 24938.35 | 25002.15 | 66823.0 |
| 2025-09-30 10:00:00 | NQ | Futures | 25002.15 | 25071.75 | 24963.31 | 25059.39 | 81493.0 |
| 2025-09-30 11:00:00 | NQ | Futures | 25059.65 | 25080.07 | 24971.89 | 25027.62 | 71762.0 |
| 2025-09-30 12:00:00 | NQ | Futures | 25027.37 | 25060.91 | 24984.24 | 24999.88 | 39156.0 |
| 2025-09-30 13:00:00 | NQ | Futures | 24999.63 | 25014.25 | 24947.93 | 24985.5 | 43632.0 |
| 2025-09-30 14:00:00 | NQ | Futures | 24985.0 | 25068.98 | 24978.44 | 25054.85 | 41893.0 |
| 2025-09-30 15:00:00 | NQ | Futures | 25055.11 | 25131.52 | 25038.46 | 25115.63 | 74463.0 |
| 2025-09-30 16:00:00 | NQ | Futures | 25115.88 | 25118.91 | 25051.83 | 25055.36 | 19275.0 |
| 2025-09-30 18:00:00 | NQ | Futures | 25060.15 | 25094.2 | 25038.97 | 25052.58 | 5902.0 |
| 2025-09-30 19:00:00 | NQ | Futures | 25051.58 | 25065.95 | 25037.2 | 25047.29 | 3473.0 |
| 2025-09-30 20:00:00 | NQ | Futures | 25047.79 | 25054.1 | 25002.15 | 25010.97 | 6139.0 |
| 2025-09-30 21:00:00 | NQ | Futures | 25010.97 | 25027.87 | 25000.38 | 25020.81 | 3726.0 |
| 2025-09-30 22:00:00 | NQ | Futures | 25020.81 | 25022.32 | 24997.61 | 25003.91 | 2922.0 |
| 2025-09-30 23:00:00 | NQ | Futures | 25003.91 | 25004.92 | 24979.96 | 24988.03 | 3133.0 |
| 2025-09-30 00:00:00 | YM | Futures | 47262.7 | 47267.8 | 47233.3 | 47235.3 | 348.0 |
| 2025-09-30 01:00:00 | YM | Futures | 47233.3 | 47258.6 | 47224.2 | 47250.5 | 418.0 |
| 2025-09-30 02:00:00 | YM | Futures | 47249.5 | 47266.8 | 47195.8 | 47198.8 | 630.0 |
| 2025-09-30 03:00:00 | YM | Futures | 47199.8 | 47215.0 | 47136.9 | 47190.7 | 1671.0 |
> showing 50 of 2,049 rows — these rows as CSV