PREVIEW / futures_1hour / 2025-11-18
file: by_date/futures_1hour/2025/2025-11-18.parquet size: 66 KB rows: 2,112
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-18 00:00:00 | ES | Futures | 6711.45 | 6717.75 | 6703.14 | 6706.16 | 16240.0 |
| 2025-11-18 01:00:00 | ES | Futures | 6706.42 | 6713.72 | 6692.81 | 6696.34 | 17464.0 |
| 2025-11-18 02:00:00 | ES | Futures | 6696.59 | 6712.71 | 6685.26 | 6704.9 | 21919.0 |
| 2025-11-18 03:00:00 | ES | Futures | 6705.16 | 6735.88 | 6704.15 | 6724.3 | 29793.0 |
| 2025-11-18 04:00:00 | ES | Futures | 6724.3 | 6734.63 | 6717.5 | 6730.85 | 16528.0 |
| 2025-11-18 05:00:00 | ES | Futures | 6730.6 | 6732.36 | 6720.52 | 6730.34 | 10154.0 |
| 2025-11-18 06:00:00 | ES | Futures | 6729.84 | 6731.85 | 6715.23 | 6725.05 | 15004.0 |
| 2025-11-18 07:00:00 | ES | Futures | 6724.8 | 6725.05 | 6693.07 | 6700.37 | 29491.0 |
| 2025-11-18 08:00:00 | ES | Futures | 6700.62 | 6718.0 | 6700.37 | 6711.7 | 35703.0 |
| 2025-11-18 09:00:00 | ES | Futures | 6711.45 | 6729.08 | 6671.15 | 6671.66 | 285221.0 |
| 2025-11-18 10:00:00 | ES | Futures | 6671.66 | 6688.53 | 6652.77 | 6657.05 | 467449.0 |
| 2025-11-18 11:00:00 | ES | Futures | 6657.05 | 6709.69 | 6643.45 | 6697.1 | 325211.0 |
| 2025-11-18 12:00:00 | ES | Futures | 6697.1 | 6729.84 | 6664.35 | 6722.79 | 253752.0 |
| 2025-11-18 13:00:00 | ES | Futures | 6723.04 | 6737.65 | 6712.96 | 6716.24 | 212639.0 |
| 2025-11-18 14:00:00 | ES | Futures | 6716.24 | 6735.63 | 6710.19 | 6730.09 | 207843.0 |
| 2025-11-18 15:00:00 | ES | Futures | 6730.09 | 6735.63 | 6686.27 | 6687.52 | 322356.0 |
| 2025-11-18 16:00:00 | ES | Futures | 6687.27 | 6688.28 | 6674.43 | 6677.45 | 79003.0 |
| 2025-11-18 18:00:00 | ES | Futures | 6680.47 | 6697.35 | 6679.21 | 6691.55 | 12225.0 |
| 2025-11-18 19:00:00 | ES | Futures | 6691.55 | 6693.57 | 6672.16 | 6685.51 | 16019.0 |
| 2025-11-18 20:00:00 | ES | Futures | 6685.51 | 6697.35 | 6677.2 | 6683.49 | 15598.0 |
| 2025-11-18 21:00:00 | ES | Futures | 6683.75 | 6702.13 | 6683.75 | 6700.37 | 11793.0 |
| 2025-11-18 22:00:00 | ES | Futures | 6700.62 | 6702.39 | 6679.46 | 6680.47 | 9316.0 |
| 2025-11-18 23:00:00 | ES | Futures | 6680.47 | 6684.25 | 6671.15 | 6676.69 | 10847.0 |
| 2025-11-18 00:00:00 | NQ | Futures | 24947.93 | 24983.99 | 24906.07 | 24925.48 | 8490.0 |
| 2025-11-18 01:00:00 | NQ | Futures | 24926.24 | 24963.82 | 24855.63 | 24875.8 | 9030.0 |
| 2025-11-18 02:00:00 | NQ | Futures | 24874.54 | 24958.02 | 24818.81 | 24915.65 | 12201.0 |
| 2025-11-18 03:00:00 | NQ | Futures | 24915.4 | 25074.27 | 24912.87 | 25019.04 | 14787.0 |
| 2025-11-18 04:00:00 | NQ | Futures | 25020.05 | 25076.79 | 24983.49 | 25054.35 | 11100.0 |
| 2025-11-18 05:00:00 | NQ | Futures | 25053.85 | 25064.19 | 25004.92 | 25044.52 | 7094.0 |
| 2025-11-18 06:00:00 | NQ | Futures | 25042.25 | 25053.85 | 24976.93 | 25017.53 | 8048.0 |
| 2025-11-18 07:00:00 | NQ | Futures | 25017.53 | 25018.79 | 24875.05 | 24908.33 | 16384.0 |
| 2025-11-18 08:00:00 | NQ | Futures | 24910.35 | 24987.52 | 24910.35 | 24947.93 | 19008.0 |
| 2025-11-18 09:00:00 | NQ | Futures | 24947.93 | 25049.05 | 24736.34 | 24736.85 | 122895.0 |
| 2025-11-18 10:00:00 | NQ | Futures | 24736.09 | 24828.64 | 24643.54 | 24672.29 | 152253.0 |
| 2025-11-18 11:00:00 | NQ | Futures | 24672.54 | 24912.87 | 24589.32 | 24868.74 | 110493.0 |
| 2025-11-18 12:00:00 | NQ | Futures | 24868.49 | 24999.88 | 24707.6 | 24969.11 | 83316.0 |
| 2025-11-18 13:00:00 | NQ | Futures | 24969.87 | 25021.31 | 24907.83 | 24926.24 | 62999.0 |
| 2025-11-18 14:00:00 | NQ | Futures | 24928.01 | 25027.11 | 24901.78 | 24992.06 | 58285.0 |
| 2025-11-18 15:00:00 | NQ | Futures | 24991.81 | 25012.49 | 24792.83 | 24799.64 | 77607.0 |
| 2025-11-18 16:00:00 | NQ | Futures | 24799.39 | 24808.22 | 24738.61 | 24745.68 | 24997.0 |
| 2025-11-18 18:00:00 | NQ | Futures | 24765.6 | 24850.58 | 24755.26 | 24805.44 | 8116.0 |
| 2025-11-18 19:00:00 | NQ | Futures | 24803.43 | 24816.54 | 24711.63 | 24771.65 | 10675.0 |
| 2025-11-18 20:00:00 | NQ | Futures | 24771.9 | 24843.27 | 24724.49 | 24765.6 | 10058.0 |
| 2025-11-18 21:00:00 | NQ | Futures | 24767.11 | 24863.95 | 24766.86 | 24861.93 | 7213.0 |
| 2025-11-18 22:00:00 | NQ | Futures | 24862.44 | 24871.01 | 24749.21 | 24757.28 | 6986.0 |
| 2025-11-18 23:00:00 | NQ | Futures | 24757.28 | 24777.45 | 24706.33 | 24736.34 | 7592.0 |
| 2025-11-18 00:00:00 | YM | Futures | 47177.5 | 47201.8 | 47138.0 | 47151.1 | 1203.0 |
| 2025-11-18 01:00:00 | YM | Futures | 47152.2 | 47191.7 | 47081.2 | 47094.4 | 1200.0 |
| 2025-11-18 02:00:00 | YM | Futures | 47095.4 | 47186.6 | 47034.5 | 47143.0 | 2481.0 |
| 2025-11-18 03:00:00 | YM | Futures | 47144.0 | 47276.9 | 47132.9 | 47211.0 | 3183.0 |
> showing 50 of 2,112 rows — these rows as CSV