PREVIEW / futures_1hour / 2025-11-07
file: by_date/futures_1hour/2025/2025-11-07.parquet size: 56 KB rows: 1,691
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-11-07 00:00:00 | ES | Futures | 6799.86 | 6815.48 | 6799.61 | 6814.97 | 9292.0 |
| 2025-11-07 01:00:00 | ES | Futures | 6815.23 | 6816.74 | 6810.94 | 6814.47 | 6893.0 |
| 2025-11-07 02:00:00 | ES | Futures | 6814.47 | 6820.26 | 6811.7 | 6817.74 | 8550.0 |
| 2025-11-07 03:00:00 | ES | Futures | 6817.74 | 6821.52 | 6805.65 | 6813.21 | 16823.0 |
| 2025-11-07 04:00:00 | ES | Futures | 6812.96 | 6816.99 | 6798.85 | 6802.63 | 15327.0 |
| 2025-11-07 05:00:00 | ES | Futures | 6802.63 | 6806.66 | 6787.77 | 6794.57 | 15099.0 |
| 2025-11-07 06:00:00 | ES | Futures | 6794.57 | 6794.82 | 6766.11 | 6788.78 | 34588.0 |
| 2025-11-07 07:00:00 | ES | Futures | 6788.53 | 6789.79 | 6762.58 | 6768.12 | 30946.0 |
| 2025-11-07 08:00:00 | ES | Futures | 6768.12 | 6780.97 | 6763.34 | 6773.67 | 48023.0 |
| 2025-11-07 09:00:00 | ES | Futures | 6773.67 | 6775.93 | 6737.4 | 6756.79 | 245590.0 |
| 2025-11-07 10:00:00 | ES | Futures | 6757.04 | 6766.61 | 6726.31 | 6727.07 | 328675.0 |
| 2025-11-07 11:00:00 | ES | Futures | 6727.07 | 6734.12 | 6706.92 | 6713.22 | 234458.0 |
| 2025-11-07 12:00:00 | ES | Futures | 6713.22 | 6736.64 | 6705.41 | 6733.37 | 206155.0 |
| 2025-11-07 13:00:00 | ES | Futures | 6733.11 | 6755.28 | 6729.84 | 6750.49 | 197367.0 |
| 2025-11-07 14:00:00 | ES | Futures | 6750.24 | 6794.57 | 6746.21 | 6793.82 | 211518.0 |
| 2025-11-07 15:00:00 | ES | Futures | 6793.82 | 6806.16 | 6773.67 | 6803.89 | 288580.0 |
| 2025-11-07 16:00:00 | ES | Futures | 6804.14 | 6816.48 | 6803.89 | 6815.73 | 63798.0 |
| 2025-11-07 00:00:00 | NQ | Futures | 25469.19 | 25554.43 | 25468.19 | 25553.42 | 6082.0 |
| 2025-11-07 01:00:00 | NQ | Futures | 25553.93 | 25562.25 | 25528.46 | 25546.87 | 4409.0 |
| 2025-11-07 02:00:00 | NQ | Futures | 25547.62 | 25570.57 | 25534.76 | 25557.71 | 5075.0 |
| 2025-11-07 03:00:00 | NQ | Futures | 25557.71 | 25576.37 | 25492.9 | 25534.51 | 10355.0 |
| 2025-11-07 04:00:00 | NQ | Futures | 25533.0 | 25549.89 | 25461.88 | 25480.8 | 8301.0 |
| 2025-11-07 05:00:00 | NQ | Futures | 25480.54 | 25498.7 | 25405.9 | 25439.69 | 7818.0 |
| 2025-11-07 06:00:00 | NQ | Futures | 25439.69 | 25440.7 | 25303.51 | 25400.35 | 19826.0 |
| 2025-11-07 07:00:00 | NQ | Futures | 25398.58 | 25415.73 | 25280.81 | 25312.08 | 15681.0 |
| 2025-11-07 08:00:00 | NQ | Futures | 25311.83 | 25367.06 | 25285.86 | 25331.0 | 20762.0 |
| 2025-11-07 09:00:00 | NQ | Futures | 25330.75 | 25343.61 | 25135.55 | 25246.77 | 98119.0 |
| 2025-11-07 10:00:00 | NQ | Futures | 25236.68 | 25263.92 | 25039.98 | 25040.48 | 126283.0 |
| 2025-11-07 11:00:00 | NQ | Futures | 25039.72 | 25078.31 | 24934.81 | 24963.06 | 82297.0 |
| 2025-11-07 12:00:00 | NQ | Futures | 24962.05 | 25081.84 | 24925.23 | 25058.39 | 68902.0 |
| 2025-11-07 13:00:00 | NQ | Futures | 25058.64 | 25171.62 | 25038.21 | 25140.35 | 63324.0 |
| 2025-11-07 14:00:00 | NQ | Futures | 25140.35 | 25336.29 | 25118.41 | 25333.01 | 64686.0 |
| 2025-11-07 15:00:00 | NQ | Futures | 25332.76 | 25393.03 | 25242.23 | 25383.7 | 81235.0 |
| 2025-11-07 16:00:00 | NQ | Futures | 25383.96 | 25448.77 | 25380.68 | 25447.25 | 20353.0 |
| 2025-11-07 00:00:00 | YM | Futures | 47721.1 | 47787.0 | 47719.0 | 47779.9 | 1113.0 |
| 2025-11-07 01:00:00 | YM | Futures | 47779.9 | 47794.1 | 47765.7 | 47781.9 | 727.0 |
| 2025-11-07 02:00:00 | YM | Futures | 47783.9 | 47808.3 | 47768.7 | 47795.1 | 1408.0 |
| 2025-11-07 03:00:00 | YM | Futures | 47794.1 | 47808.3 | 47725.1 | 47758.6 | 1706.0 |
| 2025-11-07 04:00:00 | YM | Futures | 47757.6 | 47787.0 | 47685.6 | 47706.9 | 1851.0 |
| 2025-11-07 05:00:00 | YM | Futures | 47705.9 | 47725.1 | 47634.9 | 47669.4 | 1594.0 |
| 2025-11-07 06:00:00 | YM | Futures | 47669.4 | 47671.4 | 47526.4 | 47631.8 | 3782.0 |
| 2025-11-07 07:00:00 | YM | Futures | 47633.9 | 47633.9 | 47507.1 | 47520.3 | 3157.0 |
| 2025-11-07 08:00:00 | YM | Futures | 47520.3 | 47602.4 | 47494.9 | 47574.0 | 3727.0 |
| 2025-11-07 09:00:00 | YM | Futures | 47571.0 | 47605.5 | 47400.6 | 47573.0 | 21521.0 |
| 2025-11-07 10:00:00 | YM | Futures | 47571.0 | 47638.9 | 47449.3 | 47453.3 | 16977.0 |
| 2025-11-07 11:00:00 | YM | Futures | 47451.3 | 47475.7 | 47268.8 | 47304.3 | 13673.0 |
| 2025-11-07 12:00:00 | YM | Futures | 47305.3 | 47416.8 | 47231.3 | 47412.8 | 10690.0 |
| 2025-11-07 13:00:00 | YM | Futures | 47413.8 | 47509.1 | 47394.5 | 47487.8 | 7510.0 |
| 2025-11-07 14:00:00 | YM | Futures | 47488.8 | 47732.2 | 47464.5 | 47723.1 | 10085.0 |
| 2025-11-07 15:00:00 | YM | Futures | 47722.1 | 47758.6 | 47598.4 | 47744.4 | 14840.0 |
> showing 50 of 1,691 rows — these rows as CSV