PREVIEW / futures_1hour / 2026-01-27
file: by_date/futures_1hour/2026/2026-01-27.parquet size: 69 KB rows: 2,147
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 |
|---|---|---|---|---|---|---|---|
| 2026-01-27 00:00:00 | ES | Futures | 7053.25 | 7056.02 | 7049.72 | 7055.52 | 4978.0 |
| 2026-01-27 01:00:00 | ES | Futures | 7055.52 | 7059.29 | 7053.0 | 7053.5 | 6662.0 |
| 2026-01-27 02:00:00 | ES | Futures | 7053.5 | 7056.78 | 7051.74 | 7054.76 | 5341.0 |
| 2026-01-27 03:00:00 | ES | Futures | 7054.76 | 7055.77 | 7046.95 | 7049.97 | 10721.0 |
| 2026-01-27 04:00:00 | ES | Futures | 7049.97 | 7051.99 | 7047.46 | 7048.21 | 8636.0 |
| 2026-01-27 05:00:00 | ES | Futures | 7047.96 | 7053.25 | 7047.71 | 7051.74 | 7120.0 |
| 2026-01-27 06:00:00 | ES | Futures | 7051.74 | 7056.27 | 7049.72 | 7055.01 | 10328.0 |
| 2026-01-27 07:00:00 | ES | Futures | 7054.76 | 7055.01 | 7047.2 | 7049.97 | 13788.0 |
| 2026-01-27 08:00:00 | ES | Futures | 7049.72 | 7052.49 | 7046.7 | 7047.71 | 14192.0 |
| 2026-01-27 09:00:00 | ES | Futures | 7047.71 | 7060.55 | 7040.91 | 7057.78 | 136735.0 |
| 2026-01-27 10:00:00 | ES | Futures | 7058.03 | 7067.61 | 7050.73 | 7066.09 | 156319.0 |
| 2026-01-27 11:00:00 | ES | Futures | 7066.09 | 7071.38 | 7065.84 | 7065.84 | 93347.0 |
| 2026-01-27 12:00:00 | ES | Futures | 7065.84 | 7067.35 | 7059.29 | 7059.8 | 90872.0 |
| 2026-01-27 13:00:00 | ES | Futures | 7059.8 | 7068.11 | 7054.26 | 7066.09 | 73018.0 |
| 2026-01-27 14:00:00 | ES | Futures | 7066.35 | 7069.87 | 7063.32 | 7066.6 | 50279.0 |
| 2026-01-27 15:00:00 | ES | Futures | 7066.85 | 7070.12 | 7059.8 | 7061.56 | 156262.0 |
| 2026-01-27 16:00:00 | ES | Futures | 7061.81 | 7064.84 | 7058.29 | 7062.32 | 42220.0 |
| 2026-01-27 18:00:00 | ES | Futures | 7063.07 | 7067.86 | 7062.06 | 7065.59 | 4855.0 |
| 2026-01-27 19:00:00 | ES | Futures | 7065.59 | 7079.44 | 7065.34 | 7077.43 | 11497.0 |
| 2026-01-27 20:00:00 | ES | Futures | 7077.68 | 7080.45 | 7075.41 | 7076.42 | 8606.0 |
| 2026-01-27 21:00:00 | ES | Futures | 7076.42 | 7080.2 | 7075.92 | 7078.94 | 7040.0 |
| 2026-01-27 22:00:00 | ES | Futures | 7078.69 | 7080.2 | 7076.67 | 7077.18 | 4961.0 |
| 2026-01-27 23:00:00 | ES | Futures | 7077.18 | 7080.7 | 7077.18 | 7079.7 | 3709.0 |
| 2026-01-27 00:00:00 | NQ | Futures | 26216.43 | 26237.36 | 26199.28 | 26235.85 | 3011.0 |
| 2026-01-27 01:00:00 | NQ | Futures | 26235.34 | 26256.02 | 26226.52 | 26228.79 | 4387.0 |
| 2026-01-27 02:00:00 | NQ | Futures | 26230.05 | 26248.21 | 26219.46 | 26233.83 | 4042.0 |
| 2026-01-27 03:00:00 | NQ | Futures | 26233.58 | 26239.38 | 26194.24 | 26211.89 | 6336.0 |
| 2026-01-27 04:00:00 | NQ | Futures | 26211.13 | 26222.23 | 26194.49 | 26201.05 | 4993.0 |
| 2026-01-27 05:00:00 | NQ | Futures | 26201.3 | 26235.34 | 26197.26 | 26233.33 | 3843.0 |
| 2026-01-27 06:00:00 | NQ | Futures | 26233.07 | 26270.9 | 26219.2 | 26259.81 | 6608.0 |
| 2026-01-27 07:00:00 | NQ | Futures | 26259.3 | 26261.32 | 26218.45 | 26231.56 | 6602.0 |
| 2026-01-27 08:00:00 | NQ | Futures | 26231.31 | 26245.68 | 26209.87 | 26217.19 | 8592.0 |
| 2026-01-27 09:00:00 | NQ | Futures | 26217.94 | 26286.03 | 26144.05 | 26281.24 | 82103.0 |
| 2026-01-27 10:00:00 | NQ | Futures | 26280.49 | 26326.89 | 26249.21 | 26306.71 | 74113.0 |
| 2026-01-27 11:00:00 | NQ | Futures | 26306.71 | 26335.21 | 26301.42 | 26307.97 | 40315.0 |
| 2026-01-27 12:00:00 | NQ | Futures | 26308.23 | 26320.33 | 26278.22 | 26289.82 | 35458.0 |
| 2026-01-27 13:00:00 | NQ | Futures | 26290.07 | 26326.13 | 26265.86 | 26318.57 | 30473.0 |
| 2026-01-27 14:00:00 | NQ | Futures | 26318.31 | 26328.15 | 26300.91 | 26320.08 | 23273.0 |
| 2026-01-27 15:00:00 | NQ | Futures | 26320.33 | 26342.78 | 26296.37 | 26304.19 | 46873.0 |
| 2026-01-27 16:00:00 | NQ | Futures | 26304.19 | 26346.56 | 26286.79 | 26338.49 | 16657.0 |
| 2026-01-27 18:00:00 | NQ | Futures | 26339.75 | 26376.82 | 26339.75 | 26366.23 | 4649.0 |
| 2026-01-27 19:00:00 | NQ | Futures | 26366.99 | 26437.85 | 26364.21 | 26435.33 | 7405.0 |
| 2026-01-27 20:00:00 | NQ | Futures | 26436.09 | 26457.77 | 26431.04 | 26434.57 | 5297.0 |
| 2026-01-27 21:00:00 | NQ | Futures | 26433.31 | 26451.22 | 26433.06 | 26443.4 | 2960.0 |
| 2026-01-27 22:00:00 | NQ | Futures | 26443.15 | 26448.19 | 26421.71 | 26428.27 | 3142.0 |
| 2026-01-27 23:00:00 | NQ | Futures | 26429.78 | 26457.02 | 26429.78 | 26449.45 | 2735.0 |
| 2026-01-27 00:00:00 | YM | Futures | 49835.53 | 49855.66 | 49819.42 | 49851.63 | 380.0 |
| 2026-01-27 01:00:00 | YM | Futures | 49852.64 | 49873.77 | 49832.51 | 49832.51 | 564.0 |
| 2026-01-27 02:00:00 | YM | Futures | 49835.53 | 49862.7 | 49832.51 | 49854.65 | 806.0 |
| 2026-01-27 03:00:00 | YM | Futures | 49855.66 | 49863.71 | 49803.32 | 49829.49 | 1065.0 |
> showing 50 of 2,147 rows — these rows as CSV