PREVIEW / futures_1hour / 2025-01-19
file: by_date/futures_1hour/2025/2025-01-19.parquet size: 18 KB rows: 400
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-19 18:00:00 | ES | Futures | 6186.14 | 6192.54 | 6173.57 | 6177.16 | 10125.0 |
| 2025-01-19 19:00:00 | ES | Futures | 6177.16 | 6181.01 | 6175.88 | 6180.75 | 5030.0 |
| 2025-01-19 20:00:00 | ES | Futures | 6180.75 | 6184.08 | 6177.16 | 6181.52 | 5429.0 |
| 2025-01-19 21:00:00 | ES | Futures | 6181.26 | 6182.29 | 6178.96 | 6181.01 | 2921.0 |
| 2025-01-19 22:00:00 | ES | Futures | 6181.26 | 6184.6 | 6179.21 | 6183.57 | 3278.0 |
| 2025-01-19 23:00:00 | ES | Futures | 6183.57 | 6185.88 | 6182.8 | 6185.88 | 2518.0 |
| 2025-01-19 18:00:00 | NQ | Futures | 22234.75 | 22253.28 | 22159.09 | 22178.14 | 7797.0 |
| 2025-01-19 19:00:00 | NQ | Futures | 22179.17 | 22193.32 | 22168.61 | 22190.49 | 3540.0 |
| 2025-01-19 20:00:00 | NQ | Futures | 22190.49 | 22211.08 | 22173.25 | 22197.7 | 4872.0 |
| 2025-01-19 21:00:00 | NQ | Futures | 22198.21 | 22204.9 | 22183.28 | 22194.86 | 2286.0 |
| 2025-01-19 22:00:00 | NQ | Futures | 22194.86 | 22208.5 | 22178.65 | 22194.35 | 3013.0 |
| 2025-01-19 23:00:00 | NQ | Futures | 22194.86 | 22201.3 | 22187.4 | 22198.72 | 1591.0 |
| 2025-01-19 18:00:00 | YM | Futures | 44959.4 | 45000.5 | 44901.7 | 44927.5 | 1005.0 |
| 2025-01-19 19:00:00 | YM | Futures | 44931.6 | 44941.9 | 44911.0 | 44938.8 | 820.0 |
| 2025-01-19 20:00:00 | YM | Futures | 44937.8 | 44951.1 | 44918.2 | 44937.8 | 613.0 |
| 2025-01-19 21:00:00 | YM | Futures | 44934.7 | 44937.8 | 44922.3 | 44934.7 | 295.0 |
| 2025-01-19 22:00:00 | YM | Futures | 44933.6 | 44964.5 | 44931.6 | 44961.4 | 421.0 |
| 2025-01-19 23:00:00 | YM | Futures | 44962.5 | 44986.1 | 44955.3 | 44986.1 | 401.0 |
| 2025-01-19 18:00:00 | CL | Futures | 71.83 | 72.0 | 71.56 | 71.92 | 2227.0 |
| 2025-01-19 19:00:00 | CL | Futures | 71.91 | 72.1 | 71.9 | 71.94 | 1236.0 |
| 2025-01-19 20:00:00 | CL | Futures | 71.96 | 72.02 | 71.6 | 71.76 | 2096.0 |
| 2025-01-19 21:00:00 | CL | Futures | 71.76 | 71.77 | 71.53 | 71.63 | 1833.0 |
| 2025-01-19 22:00:00 | CL | Futures | 71.63 | 71.8 | 71.57 | 71.71 | 1517.0 |
| 2025-01-19 23:00:00 | CL | Futures | 71.7 | 71.73 | 71.61 | 71.64 | 764.0 |
| 2025-01-19 18:00:00 | GC | Futures | 2858.5 | 2860.1 | 2849.6 | 2855.1 | 3093.0 |
| 2025-01-19 19:00:00 | GC | Futures | 2855.0 | 2856.4 | 2852.9 | 2856.3 | 1651.0 |
| 2025-01-19 20:00:00 | GC | Futures | 2856.2 | 2856.9 | 2850.4 | 2856.3 | 3802.0 |
| 2025-01-19 21:00:00 | GC | Futures | 2856.2 | 2859.2 | 2855.6 | 2858.5 | 1908.0 |
| 2025-01-19 22:00:00 | GC | Futures | 2858.7 | 2864.7 | 2858.6 | 2864.0 | 2040.0 |
| 2025-01-19 23:00:00 | GC | Futures | 2864.0 | 2867.1 | 2861.6 | 2866.5 | 1959.0 |
| 2025-01-19 18:00:00 | ZN | Futures | 108.498453 | 108.498453 | 108.420284 | 108.482819 | 13151.0 |
| 2025-01-19 19:00:00 | ZN | Futures | 108.482819 | 108.498453 | 108.435917 | 108.482819 | 6773.0 |
| 2025-01-19 20:00:00 | ZN | Futures | 108.482819 | 108.52972 | 108.451551 | 108.498453 | 11661.0 |
| 2025-01-19 21:00:00 | ZN | Futures | 108.498453 | 108.52972 | 108.482819 | 108.52972 | 5333.0 |
| 2025-01-19 22:00:00 | ZN | Futures | 108.514086 | 108.560988 | 108.514086 | 108.545354 | 3400.0 |
| 2025-01-19 23:00:00 | ZN | Futures | 108.545354 | 108.560988 | 108.498453 | 108.52972 | 3723.0 |
> showing 36 of 400 rows — these rows as CSV