PREVIEW / futures_1hour / 2025-09-09
file: by_date/futures_1hour/2025/2025-09-09.parquet size: 57 KB rows: 1,821
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-09 00:00:00 | ES | Futures | 6563.6 | 6563.85 | 6560.83 | 6562.34 | 2595.0 |
| 2025-09-09 01:00:00 | ES | Futures | 6562.34 | 6563.1 | 6557.05 | 6561.08 | 4066.0 |
| 2025-09-09 02:00:00 | ES | Futures | 6561.08 | 6566.62 | 6560.33 | 6564.61 | 8268.0 |
| 2025-09-09 03:00:00 | ES | Futures | 6564.61 | 6572.42 | 6562.59 | 6563.35 | 13026.0 |
| 2025-09-09 04:00:00 | ES | Futures | 6563.6 | 6564.86 | 6559.82 | 6561.59 | 11124.0 |
| 2025-09-09 05:00:00 | ES | Futures | 6561.59 | 6564.11 | 6559.82 | 6560.58 | 5423.0 |
| 2025-09-09 06:00:00 | ES | Futures | 6560.58 | 6563.35 | 6558.82 | 6560.58 | 4608.0 |
| 2025-09-09 07:00:00 | ES | Futures | 6560.33 | 6563.35 | 6555.79 | 6562.59 | 8394.0 |
| 2025-09-09 08:00:00 | ES | Futures | 6562.34 | 6563.85 | 6559.32 | 6560.58 | 13080.0 |
| 2025-09-09 09:00:00 | ES | Futures | 6560.33 | 6561.59 | 6550.76 | 6556.3 | 135842.0 |
| 2025-09-09 10:00:00 | ES | Futures | 6556.3 | 6563.85 | 6537.91 | 6549.25 | 238179.0 |
| 2025-09-09 11:00:00 | ES | Futures | 6548.99 | 6554.28 | 6543.7 | 6548.49 | 128963.0 |
| 2025-09-09 12:00:00 | ES | Futures | 6548.49 | 6558.31 | 6547.48 | 6556.55 | 86780.0 |
| 2025-09-09 13:00:00 | ES | Futures | 6556.55 | 6566.12 | 6556.05 | 6564.11 | 107008.0 |
| 2025-09-09 14:00:00 | ES | Futures | 6564.36 | 6567.38 | 6561.84 | 6564.86 | 80875.0 |
| 2025-09-09 15:00:00 | ES | Futures | 6564.86 | 6575.19 | 6561.84 | 6569.9 | 171583.0 |
| 2025-09-09 16:00:00 | ES | Futures | 6569.9 | 6585.26 | 6565.37 | 6579.22 | 63095.0 |
| 2025-09-09 18:00:00 | ES | Futures | 6581.23 | 6586.27 | 6579.97 | 6582.74 | 6015.0 |
| 2025-09-09 19:00:00 | ES | Futures | 6583.0 | 6583.0 | 6575.69 | 6578.71 | 8582.0 |
| 2025-09-09 20:00:00 | ES | Futures | 6578.71 | 6583.0 | 6577.96 | 6580.23 | 5635.0 |
| 2025-09-09 21:00:00 | ES | Futures | 6580.23 | 6586.02 | 6578.71 | 6584.51 | 6120.0 |
| 2025-09-09 22:00:00 | ES | Futures | 6584.51 | 6586.02 | 6582.49 | 6585.26 | 4456.0 |
| 2025-09-09 23:00:00 | ES | Futures | 6585.01 | 6586.77 | 6584.76 | 6586.52 | 2806.0 |
| 2025-09-09 00:00:00 | NQ | Futures | 24047.13 | 24048.39 | 24038.06 | 24045.62 | 1725.0 |
| 2025-09-09 01:00:00 | NQ | Futures | 24044.11 | 24049.91 | 24022.17 | 24042.09 | 3786.0 |
| 2025-09-09 02:00:00 | NQ | Futures | 24042.59 | 24063.53 | 24038.06 | 24056.97 | 5042.0 |
| 2025-09-09 03:00:00 | NQ | Futures | 24058.23 | 24093.28 | 24054.19 | 24063.27 | 5880.0 |
| 2025-09-09 04:00:00 | NQ | Futures | 24062.77 | 24065.04 | 24041.59 | 24051.67 | 4678.0 |
| 2025-09-09 05:00:00 | NQ | Futures | 24050.66 | 24063.78 | 24043.35 | 24051.92 | 2854.0 |
| 2025-09-09 06:00:00 | NQ | Futures | 24052.18 | 24068.06 | 24045.37 | 24053.19 | 3623.0 |
| 2025-09-09 07:00:00 | NQ | Futures | 24052.93 | 24061.0 | 24019.14 | 24057.47 | 7407.0 |
| 2025-09-09 08:00:00 | NQ | Futures | 24057.22 | 24065.04 | 24040.58 | 24047.39 | 6953.0 |
| 2025-09-09 09:00:00 | NQ | Futures | 24046.88 | 24065.54 | 24007.29 | 24022.42 | 66833.0 |
| 2025-09-09 10:00:00 | NQ | Futures | 24022.92 | 24058.48 | 23932.64 | 23992.92 | 101314.0 |
| 2025-09-09 11:00:00 | NQ | Futures | 23992.92 | 24020.15 | 23958.87 | 23991.65 | 54976.0 |
| 2025-09-09 12:00:00 | NQ | Futures | 23991.65 | 24041.33 | 23988.63 | 24028.98 | 37958.0 |
| 2025-09-09 13:00:00 | NQ | Futures | 24028.72 | 24063.27 | 24028.47 | 24047.13 | 37572.0 |
| 2025-09-09 14:00:00 | NQ | Futures | 24047.13 | 24056.72 | 24030.99 | 24051.42 | 31087.0 |
| 2025-09-09 15:00:00 | NQ | Futures | 24051.17 | 24098.07 | 24042.34 | 24075.63 | 49668.0 |
| 2025-09-09 16:00:00 | NQ | Futures | 24075.63 | 24129.6 | 24055.46 | 24097.82 | 27596.0 |
| 2025-09-09 18:00:00 | NQ | Futures | 24106.65 | 24119.76 | 24098.07 | 24103.87 | 4671.0 |
| 2025-09-09 19:00:00 | NQ | Futures | 24104.38 | 24106.14 | 24081.93 | 24093.79 | 3819.0 |
| 2025-09-09 20:00:00 | NQ | Futures | 24092.78 | 24107.66 | 24089.25 | 24094.04 | 2896.0 |
| 2025-09-09 21:00:00 | NQ | Futures | 24094.29 | 24114.46 | 24085.97 | 24111.19 | 2897.0 |
| 2025-09-09 22:00:00 | NQ | Futures | 24111.44 | 24126.07 | 24105.39 | 24119.26 | 2244.0 |
| 2025-09-09 23:00:00 | NQ | Futures | 24119.26 | 24127.07 | 24119.0 | 24126.07 | 1209.0 |
| 2025-09-09 00:00:00 | YM | Futures | 46607.2 | 46607.2 | 46587.8 | 46597.0 | 152.0 |
| 2025-09-09 01:00:00 | YM | Futures | 46593.9 | 46603.1 | 46560.2 | 46590.8 | 348.0 |
| 2025-09-09 02:00:00 | YM | Futures | 46589.8 | 46628.6 | 46584.7 | 46611.3 | 880.0 |
| 2025-09-09 03:00:00 | YM | Futures | 46613.3 | 46651.1 | 46577.5 | 46582.7 | 1420.0 |
> showing 50 of 1,821 rows — these rows as CSV