PREVIEW / futures_1hour / 2025-01-01
file: by_date/futures_1hour/2025/2025-01-01.parquet size: 19 KB rows: 422
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-01 18:00:00 | ES | Futures | 6101.02 | 6107.43 | 6084.87 | 6090.76 | 15385.0 |
| 2025-01-01 19:00:00 | ES | Futures | 6090.76 | 6091.02 | 6061.54 | 6086.15 | 20933.0 |
| 2025-01-01 20:00:00 | ES | Futures | 6086.15 | 6102.56 | 6086.15 | 6098.71 | 12653.0 |
| 2025-01-01 21:00:00 | ES | Futures | 6098.45 | 6110.25 | 6097.17 | 6107.68 | 8778.0 |
| 2025-01-01 22:00:00 | ES | Futures | 6107.68 | 6111.79 | 6102.3 | 6104.35 | 5349.0 |
| 2025-01-01 23:00:00 | ES | Futures | 6104.35 | 6108.97 | 6099.22 | 6106.66 | 4885.0 |
| 2025-01-01 18:00:00 | NQ | Futures | 21894.03 | 21947.04 | 21868.03 | 21893.0 | 6461.0 |
| 2025-01-01 19:00:00 | NQ | Futures | 21891.45 | 21893.0 | 21742.45 | 21854.65 | 12103.0 |
| 2025-01-01 20:00:00 | NQ | Futures | 21855.94 | 21939.83 | 21855.94 | 21920.79 | 8776.0 |
| 2025-01-01 21:00:00 | NQ | Futures | 21920.02 | 21959.91 | 21913.33 | 21948.84 | 5438.0 |
| 2025-01-01 22:00:00 | NQ | Futures | 21948.33 | 21966.86 | 21920.28 | 21932.63 | 5275.0 |
| 2025-01-01 23:00:00 | NQ | Futures | 21932.63 | 21962.48 | 21912.56 | 21950.64 | 4749.0 |
| 2025-01-01 18:00:00 | YM | Futures | 44191.5 | 44244.0 | 44080.4 | 44121.6 | 1674.0 |
| 2025-01-01 19:00:00 | YM | Futures | 44122.6 | 44130.8 | 43957.9 | 44107.1 | 2828.0 |
| 2025-01-01 20:00:00 | YM | Futures | 44109.2 | 44199.8 | 44109.2 | 44174.0 | 1581.0 |
| 2025-01-01 21:00:00 | YM | Futures | 44174.0 | 44256.4 | 44166.8 | 44245.1 | 952.0 |
| 2025-01-01 22:00:00 | YM | Futures | 44246.1 | 44263.6 | 44214.2 | 44223.4 | 697.0 |
| 2025-01-01 23:00:00 | YM | Futures | 44223.4 | 44248.1 | 44198.7 | 44239.9 | 496.0 |
| 2025-01-01 18:00:00 | CL | Futures | 65.26 | 65.46 | 65.22 | 65.45 | 1311.0 |
| 2025-01-01 19:00:00 | CL | Futures | 65.45 | 65.47 | 65.36 | 65.46 | 990.0 |
| 2025-01-01 20:00:00 | CL | Futures | 65.46 | 65.66 | 65.42 | 65.54 | 3150.0 |
| 2025-01-01 21:00:00 | CL | Futures | 65.53 | 65.57 | 65.42 | 65.53 | 1432.0 |
| 2025-01-01 22:00:00 | CL | Futures | 65.53 | 65.53 | 65.4 | 65.43 | 867.0 |
| 2025-01-01 23:00:00 | CL | Futures | 65.43 | 65.43 | 65.31 | 65.35 | 732.0 |
| 2025-01-01 18:00:00 | GC | Futures | 2755.6 | 2756.1 | 2750.5 | 2752.1 | 1593.0 |
| 2025-01-01 19:00:00 | GC | Futures | 2752.6 | 2757.0 | 2751.6 | 2754.1 | 1886.0 |
| 2025-01-01 20:00:00 | GC | Futures | 2754.1 | 2762.4 | 2752.3 | 2760.1 | 5155.0 |
| 2025-01-01 21:00:00 | GC | Futures | 2760.2 | 2763.6 | 2759.5 | 2761.8 | 2728.0 |
| 2025-01-01 22:00:00 | GC | Futures | 2761.7 | 2762.6 | 2759.1 | 2760.2 | 1251.0 |
| 2025-01-01 23:00:00 | GC | Futures | 2760.2 | 2761.0 | 2757.9 | 2760.6 | 1471.0 |
| 2025-01-01 18:00:00 | ZN | Futures | 108.842396 | 108.842396 | 108.65479 | 108.670424 | 18076.0 |
| 2025-01-01 19:00:00 | ZN | Futures | 108.670424 | 108.717326 | 108.65479 | 108.670424 | 10557.0 |
| 2025-01-01 20:00:00 | ZN | Futures | 108.670424 | 108.732959 | 108.639157 | 108.732959 | 11870.0 |
| 2025-01-01 21:00:00 | ZN | Futures | 108.732959 | 108.779861 | 108.717326 | 108.764227 | 12129.0 |
| 2025-01-01 22:00:00 | ZN | Futures | 108.764227 | 108.795494 | 108.764227 | 108.795494 | 5328.0 |
| 2025-01-01 23:00:00 | ZN | Futures | 108.779861 | 108.811128 | 108.764227 | 108.795494 | 5750.0 |
> showing 36 of 422 rows — these rows as CSV