PREVIEW / futures_1hour / 2025-01-02
file: by_date/futures_1hour/2025/2025-01-02.parquet size: 68 KB rows: 2,074
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-01-02 00:00:00 | ES | Futures | 6106.91 | 6117.68 | 6105.89 | 6115.89 | 5924.0 |
| 2025-01-02 01:00:00 | ES | Futures | 6116.14 | 6120.25 | 6114.35 | 6119.22 | 4456.0 |
| 2025-01-02 02:00:00 | ES | Futures | 6119.22 | 6121.78 | 6113.07 | 6113.58 | 6789.0 |
| 2025-01-02 03:00:00 | ES | Futures | 6113.84 | 6127.42 | 6105.12 | 6116.4 | 19658.0 |
| 2025-01-02 04:00:00 | ES | Futures | 6116.66 | 6124.86 | 6112.3 | 6124.35 | 12387.0 |
| 2025-01-02 05:00:00 | ES | Futures | 6124.35 | 6126.4 | 6115.89 | 6124.6 | 11000.0 |
| 2025-01-02 06:00:00 | ES | Futures | 6124.6 | 6142.55 | 6118.71 | 6142.04 | 16210.0 |
| 2025-01-02 07:00:00 | ES | Futures | 6142.29 | 6148.19 | 6128.45 | 6136.14 | 27508.0 |
| 2025-01-02 08:00:00 | ES | Futures | 6136.14 | 6140.76 | 6127.17 | 6130.76 | 23874.0 |
| 2025-01-02 09:00:00 | ES | Futures | 6130.5 | 6131.27 | 6085.89 | 6127.17 | 238437.0 |
| 2025-01-02 10:00:00 | ES | Futures | 6127.17 | 6137.68 | 6086.92 | 6099.74 | 292503.0 |
| 2025-01-02 11:00:00 | ES | Futures | 6099.99 | 6112.04 | 6075.12 | 6103.07 | 175423.0 |
| 2025-01-02 12:00:00 | ES | Futures | 6103.07 | 6111.27 | 6029.74 | 6049.49 | 250514.0 |
| 2025-01-02 13:00:00 | ES | Futures | 6049.74 | 6051.79 | 6024.62 | 6039.23 | 179393.0 |
| 2025-01-02 14:00:00 | ES | Futures | 6039.49 | 6061.79 | 6033.85 | 6042.82 | 134447.0 |
| 2025-01-02 15:00:00 | ES | Futures | 6042.82 | 6076.41 | 6042.56 | 6068.2 | 213430.0 |
| 2025-01-02 16:00:00 | ES | Futures | 6068.46 | 6076.41 | 6067.94 | 6071.02 | 42336.0 |
| 2025-01-02 18:00:00 | ES | Futures | 6072.05 | 6073.84 | 6062.05 | 6065.64 | 7174.0 |
| 2025-01-02 19:00:00 | ES | Futures | 6065.38 | 6080.76 | 6064.1 | 6080.51 | 8561.0 |
| 2025-01-02 20:00:00 | ES | Futures | 6080.51 | 6083.58 | 6073.84 | 6076.92 | 6795.0 |
| 2025-01-02 21:00:00 | ES | Futures | 6076.92 | 6085.12 | 6076.66 | 6081.53 | 6303.0 |
| 2025-01-02 22:00:00 | ES | Futures | 6081.53 | 6085.38 | 6081.53 | 6082.56 | 4256.0 |
| 2025-01-02 23:00:00 | ES | Futures | 6082.56 | 6084.35 | 6078.2 | 6078.2 | 3143.0 |
| 2025-01-02 00:00:00 | NQ | Futures | 21951.41 | 22004.69 | 21947.3 | 21998.51 | 5858.0 |
| 2025-01-02 01:00:00 | NQ | Futures | 21999.02 | 22025.53 | 21983.58 | 22018.07 | 4779.0 |
| 2025-01-02 02:00:00 | NQ | Futures | 22017.81 | 22027.59 | 21973.29 | 21985.38 | 6196.0 |
| 2025-01-02 03:00:00 | NQ | Futures | 21984.87 | 22054.1 | 21944.47 | 22003.66 | 16972.0 |
| 2025-01-02 04:00:00 | NQ | Futures | 22002.63 | 22034.54 | 21977.66 | 22031.45 | 10485.0 |
| 2025-01-02 05:00:00 | NQ | Futures | 22031.71 | 22040.2 | 21987.19 | 22026.56 | 6712.0 |
| 2025-01-02 06:00:00 | NQ | Futures | 22026.82 | 22100.93 | 21998.51 | 22098.62 | 9231.0 |
| 2025-01-02 07:00:00 | NQ | Futures | 22097.84 | 22122.04 | 22043.03 | 22074.43 | 13725.0 |
| 2025-01-02 08:00:00 | NQ | Futures | 22073.91 | 22097.33 | 22033.25 | 22046.89 | 14877.0 |
| 2025-01-02 09:00:00 | NQ | Futures | 22047.15 | 22049.46 | 21788.51 | 22019.87 | 97770.0 |
| 2025-01-02 10:00:00 | NQ | Futures | 22021.16 | 22074.17 | 21833.03 | 21902.52 | 97678.0 |
| 2025-01-02 11:00:00 | NQ | Futures | 21903.55 | 21985.13 | 21808.84 | 21942.66 | 62750.0 |
| 2025-01-02 12:00:00 | NQ | Futures | 21942.66 | 21969.69 | 21600.39 | 21695.1 | 87195.0 |
| 2025-01-02 13:00:00 | NQ | Futures | 21695.87 | 21710.02 | 21604.51 | 21666.02 | 61500.0 |
| 2025-01-02 14:00:00 | NQ | Futures | 21666.27 | 21766.9 | 21645.94 | 21683.0 | 52517.0 |
| 2025-01-02 15:00:00 | NQ | Futures | 21682.23 | 21818.62 | 21680.94 | 21791.09 | 56838.0 |
| 2025-01-02 16:00:00 | NQ | Futures | 21791.6 | 21826.6 | 21790.83 | 21804.98 | 10980.0 |
| 2025-01-02 18:00:00 | NQ | Futures | 21809.36 | 21811.42 | 21765.35 | 21785.43 | 4219.0 |
| 2025-01-02 19:00:00 | NQ | Futures | 21784.65 | 21864.95 | 21774.87 | 21863.14 | 6082.0 |
| 2025-01-02 20:00:00 | NQ | Futures | 21863.4 | 21873.44 | 21829.17 | 21847.7 | 4060.0 |
| 2025-01-02 21:00:00 | NQ | Futures | 21848.22 | 21874.47 | 21844.87 | 21866.75 | 4514.0 |
| 2025-01-02 22:00:00 | NQ | Futures | 21867.26 | 21884.76 | 21866.75 | 21872.41 | 3217.0 |
| 2025-01-02 23:00:00 | NQ | Futures | 21873.44 | 21879.87 | 21846.67 | 21847.45 | 2022.0 |
| 2025-01-02 00:00:00 | YM | Futures | 44240.9 | 44299.6 | 44233.7 | 44286.2 | 632.0 |
| 2025-01-02 01:00:00 | YM | Futures | 44288.3 | 44310.9 | 44282.1 | 44295.5 | 599.0 |
| 2025-01-02 02:00:00 | YM | Futures | 44294.5 | 44334.6 | 44274.9 | 44277.0 | 1441.0 |
| 2025-01-02 03:00:00 | YM | Futures | 44280.1 | 44384.0 | 44222.4 | 44287.3 | 3224.0 |
> showing 50 of 2,074 rows — these rows as CSV