PREVIEW / futures_1hour / 2025-11-20
file: by_date/futures_1hour/2025/2025-11-20.parquet size: 67 KB rows: 2,119
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-20 00:00:00 | ES | Futures | 6799.86 | 6804.65 | 6795.33 | 6797.09 | 8679.0 |
| 2025-11-20 01:00:00 | ES | Futures | 6797.34 | 6800.11 | 6791.05 | 6799.61 | 7449.0 |
| 2025-11-20 02:00:00 | ES | Futures | 6799.61 | 6807.67 | 6793.31 | 6794.82 | 14742.0 |
| 2025-11-20 03:00:00 | ES | Futures | 6794.82 | 6805.65 | 6791.05 | 6794.32 | 20133.0 |
| 2025-11-20 04:00:00 | ES | Futures | 6794.07 | 6796.33 | 6775.93 | 6779.46 | 17914.0 |
| 2025-11-20 05:00:00 | ES | Futures | 6779.46 | 6797.09 | 6774.42 | 6794.82 | 12652.0 |
| 2025-11-20 06:00:00 | ES | Futures | 6794.82 | 6795.08 | 6779.46 | 6783.49 | 15926.0 |
| 2025-11-20 07:00:00 | ES | Futures | 6783.49 | 6797.85 | 6776.69 | 6796.84 | 17653.0 |
| 2025-11-20 08:00:00 | ES | Futures | 6797.09 | 6823.54 | 6787.52 | 6818.5 | 67410.0 |
| 2025-11-20 09:00:00 | ES | Futures | 6818.5 | 6836.89 | 6810.94 | 6835.38 | 238204.0 |
| 2025-11-20 10:00:00 | ES | Futures | 6835.63 | 6842.18 | 6813.46 | 6813.71 | 280093.0 |
| 2025-11-20 11:00:00 | ES | Futures | 6813.97 | 6814.22 | 6677.7 | 6685.76 | 553327.0 |
| 2025-11-20 12:00:00 | ES | Futures | 6685.76 | 6707.93 | 6637.65 | 6656.04 | 495836.0 |
| 2025-11-20 13:00:00 | ES | Futures | 6656.29 | 6703.9 | 6624.3 | 6633.62 | 350968.0 |
| 2025-11-20 14:00:00 | ES | Futures | 6633.62 | 6666.62 | 6621.53 | 6664.6 | 248824.0 |
| 2025-11-20 15:00:00 | ES | Futures | 6664.6 | 6664.86 | 6601.64 | 6607.93 | 375933.0 |
| 2025-11-20 16:00:00 | ES | Futures | 6607.93 | 6611.46 | 6599.62 | 6601.13 | 81015.0 |
| 2025-11-20 18:00:00 | ES | Futures | 6609.19 | 6620.78 | 6588.29 | 6615.24 | 28906.0 |
| 2025-11-20 19:00:00 | ES | Futures | 6614.98 | 6630.6 | 6610.95 | 6626.82 | 18238.0 |
| 2025-11-20 20:00:00 | ES | Futures | 6626.82 | 6638.41 | 6624.3 | 6632.62 | 18665.0 |
| 2025-11-20 21:00:00 | ES | Futures | 6632.87 | 6637.4 | 6626.32 | 6629.85 | 14177.0 |
| 2025-11-20 22:00:00 | ES | Futures | 6629.85 | 6643.45 | 6627.83 | 6633.88 | 13005.0 |
| 2025-11-20 23:00:00 | ES | Futures | 6633.88 | 6635.39 | 6615.49 | 6628.84 | 14327.0 |
| 2025-11-20 00:00:00 | NQ | Futures | 25406.15 | 25429.35 | 25377.65 | 25387.74 | 4282.0 |
| 2025-11-20 01:00:00 | NQ | Futures | 25389.0 | 25405.14 | 25352.69 | 25395.05 | 4846.0 |
| 2025-11-20 02:00:00 | NQ | Futures | 25396.06 | 25427.33 | 25357.22 | 25370.34 | 7107.0 |
| 2025-11-20 03:00:00 | NQ | Futures | 25370.09 | 25405.14 | 25340.33 | 25353.19 | 8390.0 |
| 2025-11-20 04:00:00 | NQ | Futures | 25353.19 | 25364.29 | 25264.67 | 25277.53 | 9092.0 |
| 2025-11-20 05:00:00 | NQ | Futures | 25280.56 | 25345.88 | 25240.97 | 25333.01 | 7686.0 |
| 2025-11-20 06:00:00 | NQ | Futures | 25333.01 | 25351.68 | 25266.19 | 25306.54 | 10661.0 |
| 2025-11-20 07:00:00 | NQ | Futures | 25308.81 | 25378.16 | 25279.8 | 25376.14 | 8368.0 |
| 2025-11-20 08:00:00 | NQ | Futures | 25375.89 | 25485.59 | 25340.33 | 25450.03 | 28889.0 |
| 2025-11-20 09:00:00 | NQ | Futures | 25450.53 | 25512.57 | 25365.8 | 25495.17 | 91961.0 |
| 2025-11-20 10:00:00 | NQ | Futures | 25495.93 | 25531.23 | 25376.64 | 25382.7 | 110923.0 |
| 2025-11-20 11:00:00 | NQ | Futures | 25382.7 | 25384.71 | 24726.26 | 24769.38 | 188790.0 |
| 2025-11-20 12:00:00 | NQ | Futures | 24768.62 | 24856.89 | 24520.98 | 24608.23 | 151884.0 |
| 2025-11-20 13:00:00 | NQ | Futures | 24608.49 | 24813.77 | 24447.34 | 24490.97 | 102086.0 |
| 2025-11-20 14:00:00 | NQ | Futures | 24491.47 | 24615.3 | 24416.57 | 24609.75 | 73043.0 |
| 2025-11-20 15:00:00 | NQ | Futures | 24609.5 | 24609.5 | 24308.64 | 24349.49 | 93068.0 |
| 2025-11-20 16:00:00 | NQ | Futures | 24349.74 | 24353.78 | 24283.67 | 24284.18 | 27036.0 |
| 2025-11-20 18:00:00 | NQ | Futures | 24320.74 | 24377.49 | 24227.94 | 24347.73 | 17253.0 |
| 2025-11-20 19:00:00 | NQ | Futures | 24344.7 | 24417.58 | 24322.0 | 24393.88 | 10831.0 |
| 2025-11-20 20:00:00 | NQ | Futures | 24394.89 | 24447.09 | 24376.48 | 24417.83 | 9866.0 |
| 2025-11-20 21:00:00 | NQ | Futures | 24417.58 | 24431.2 | 24366.89 | 24384.04 | 7701.0 |
| 2025-11-20 22:00:00 | NQ | Futures | 24383.54 | 24450.37 | 24370.68 | 24403.71 | 6775.0 |
| 2025-11-20 23:00:00 | NQ | Futures | 24404.22 | 24414.3 | 24305.61 | 24383.03 | 8661.0 |
| 2025-11-20 00:00:00 | YM | Futures | 47168.4 | 47189.7 | 47125.8 | 47135.9 | 595.0 |
| 2025-11-20 01:00:00 | YM | Futures | 47138.0 | 47154.2 | 47110.6 | 47153.2 | 562.0 |
| 2025-11-20 02:00:00 | YM | Futures | 47153.2 | 47211.0 | 47107.5 | 47111.6 | 1410.0 |
| 2025-11-20 03:00:00 | YM | Futures | 47111.6 | 47203.9 | 47110.6 | 47134.9 | 1484.0 |
> showing 50 of 2,119 rows — these rows as CSV