PREVIEW / futures_1hour / 2025-09-17
file: by_date/futures_1hour/2025/2025-09-17.parquet size: 65 KB rows: 2,063
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-17 00:00:00 | ES | Futures | 6715.48 | 6716.74 | 6713.72 | 6715.48 | 1623.0 |
| 2025-09-17 01:00:00 | ES | Futures | 6715.48 | 6716.49 | 6712.21 | 6715.23 | 3221.0 |
| 2025-09-17 02:00:00 | ES | Futures | 6715.23 | 6719.26 | 6713.72 | 6718.51 | 4012.0 |
| 2025-09-17 03:00:00 | ES | Futures | 6718.51 | 6723.04 | 6716.24 | 6721.53 | 8593.0 |
| 2025-09-17 04:00:00 | ES | Futures | 6721.28 | 6721.78 | 6703.64 | 6715.48 | 23965.0 |
| 2025-09-17 05:00:00 | ES | Futures | 6715.73 | 6719.51 | 6714.98 | 6716.74 | 8123.0 |
| 2025-09-17 06:00:00 | ES | Futures | 6716.49 | 6718.0 | 6710.45 | 6711.96 | 8297.0 |
| 2025-09-17 07:00:00 | ES | Futures | 6712.21 | 6715.73 | 6709.69 | 6712.71 | 10853.0 |
| 2025-09-17 08:00:00 | ES | Futures | 6712.96 | 6718.25 | 6711.7 | 6717.75 | 15146.0 |
| 2025-09-17 09:00:00 | ES | Futures | 6717.75 | 6725.81 | 6714.98 | 6717.75 | 138994.0 |
| 2025-09-17 10:00:00 | ES | Futures | 6717.5 | 6718.51 | 6708.93 | 6711.7 | 132455.0 |
| 2025-09-17 11:00:00 | ES | Futures | 6711.7 | 6715.23 | 6706.92 | 6711.2 | 80913.0 |
| 2025-09-17 12:00:00 | ES | Futures | 6711.2 | 6712.21 | 6699.87 | 6701.88 | 87321.0 |
| 2025-09-17 13:00:00 | ES | Futures | 6701.63 | 6716.99 | 6701.63 | 6715.48 | 62061.0 |
| 2025-09-17 14:00:00 | ES | Futures | 6715.48 | 6736.64 | 6660.57 | 6695.58 | 416299.0 |
| 2025-09-17 15:00:00 | ES | Futures | 6695.58 | 6726.06 | 6693.07 | 6710.19 | 336946.0 |
| 2025-09-17 16:00:00 | ES | Futures | 6710.45 | 6719.26 | 6709.94 | 6715.73 | 44373.0 |
| 2025-09-17 18:00:00 | ES | Futures | 6714.48 | 6732.86 | 6713.97 | 6731.1 | 9038.0 |
| 2025-09-17 19:00:00 | ES | Futures | 6731.35 | 6734.63 | 6730.85 | 6733.37 | 8036.0 |
| 2025-09-17 20:00:00 | ES | Futures | 6733.37 | 6733.37 | 6726.82 | 6728.08 | 8028.0 |
| 2025-09-17 21:00:00 | ES | Futures | 6727.82 | 6734.12 | 6727.57 | 6733.37 | 7659.0 |
| 2025-09-17 22:00:00 | ES | Futures | 6733.62 | 6737.9 | 6731.6 | 6737.65 | 7095.0 |
| 2025-09-17 23:00:00 | ES | Futures | 6737.4 | 6741.68 | 6737.4 | 6740.42 | 7573.0 |
| 2025-09-17 00:00:00 | NQ | Futures | 24733.32 | 24736.6 | 24721.97 | 24733.07 | 1382.0 |
| 2025-09-17 01:00:00 | NQ | Futures | 24733.57 | 24741.39 | 24711.63 | 24732.31 | 2384.0 |
| 2025-09-17 02:00:00 | NQ | Futures | 24732.81 | 24749.21 | 24723.74 | 24746.68 | 2087.0 |
| 2025-09-17 03:00:00 | NQ | Futures | 24746.94 | 24767.62 | 24738.87 | 24764.59 | 3216.0 |
| 2025-09-17 04:00:00 | NQ | Futures | 24764.59 | 24765.09 | 24670.02 | 24727.27 | 11919.0 |
| 2025-09-17 05:00:00 | NQ | Futures | 24728.02 | 24742.9 | 24720.71 | 24725.75 | 4015.0 |
| 2025-09-17 06:00:00 | NQ | Futures | 24726.01 | 24734.83 | 24704.06 | 24714.15 | 4221.0 |
| 2025-09-17 07:00:00 | NQ | Futures | 24714.66 | 24730.54 | 24700.53 | 24716.67 | 5301.0 |
| 2025-09-17 08:00:00 | NQ | Futures | 24716.67 | 24740.38 | 24712.64 | 24739.12 | 6444.0 |
| 2025-09-17 09:00:00 | NQ | Futures | 24738.87 | 24755.26 | 24674.05 | 24690.95 | 61144.0 |
| 2025-09-17 10:00:00 | NQ | Futures | 24691.46 | 24694.99 | 24623.37 | 24633.71 | 61010.0 |
| 2025-09-17 11:00:00 | NQ | Futures | 24633.71 | 24658.67 | 24611.26 | 24624.63 | 39210.0 |
| 2025-09-17 12:00:00 | NQ | Futures | 24624.12 | 24635.47 | 24587.81 | 24602.94 | 32938.0 |
| 2025-09-17 13:00:00 | NQ | Futures | 24602.94 | 24675.06 | 24601.17 | 24669.26 | 27204.0 |
| 2025-09-17 14:00:00 | NQ | Futures | 24669.52 | 24738.36 | 24453.9 | 24606.22 | 145683.0 |
| 2025-09-17 15:00:00 | NQ | Futures | 24605.46 | 24765.35 | 24595.88 | 24689.44 | 112990.0 |
| 2025-09-17 16:00:00 | NQ | Futures | 24688.93 | 24738.11 | 24686.16 | 24716.17 | 16583.0 |
| 2025-09-17 18:00:00 | NQ | Futures | 24712.64 | 24789.05 | 24709.36 | 24782.24 | 5557.0 |
| 2025-09-17 19:00:00 | NQ | Futures | 24782.24 | 24803.93 | 24782.24 | 24798.38 | 4303.0 |
| 2025-09-17 20:00:00 | NQ | Futures | 24799.14 | 24799.14 | 24774.68 | 24779.22 | 4240.0 |
| 2025-09-17 21:00:00 | NQ | Futures | 24778.96 | 24813.01 | 24775.18 | 24807.71 | 4118.0 |
| 2025-09-17 22:00:00 | NQ | Futures | 24806.96 | 24838.73 | 24801.66 | 24835.96 | 3476.0 |
| 2025-09-17 23:00:00 | NQ | Futures | 24835.96 | 24860.42 | 24835.2 | 24851.09 | 5370.0 |
| 2025-09-17 00:00:00 | YM | Futures | 46741.4 | 46752.6 | 46731.3 | 46746.5 | 195.0 |
| 2025-09-17 01:00:00 | YM | Futures | 46746.5 | 46752.6 | 46727.2 | 46748.5 | 282.0 |
| 2025-09-17 02:00:00 | YM | Futures | 46748.5 | 46777.9 | 46722.2 | 46766.8 | 507.0 |
| 2025-09-17 03:00:00 | YM | Futures | 46765.8 | 46783.0 | 46739.4 | 46769.8 | 761.0 |
> showing 50 of 2,063 rows — these rows as CSV