PREVIEW / futures_1hour / 2025-10-19
file: by_date/futures_1hour/2025/2025-10-19.parquet size: 17 KB rows: 360
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-10-19 18:00:00 | ES | Futures | 6771.4 | 6776.44 | 6763.09 | 6766.11 | 11240.0 |
| 2025-10-19 19:00:00 | ES | Futures | 6766.61 | 6766.87 | 6751.75 | 6756.03 | 9252.0 |
| 2025-10-19 20:00:00 | ES | Futures | 6755.78 | 6766.87 | 6744.2 | 6764.85 | 17565.0 |
| 2025-10-19 21:00:00 | ES | Futures | 6764.85 | 6771.15 | 6760.32 | 6763.59 | 10511.0 |
| 2025-10-19 22:00:00 | ES | Futures | 6763.34 | 6767.37 | 6759.56 | 6765.35 | 5624.0 |
| 2025-10-19 23:00:00 | ES | Futures | 6765.35 | 6775.18 | 6765.35 | 6773.67 | 4881.0 |
| 2025-10-19 18:00:00 | NQ | Futures | 25284.85 | 25318.64 | 25258.62 | 25279.3 | 5823.0 |
| 2025-10-19 19:00:00 | NQ | Futures | 25280.56 | 25283.08 | 25205.66 | 25230.63 | 5603.0 |
| 2025-10-19 20:00:00 | NQ | Futures | 25230.38 | 25275.01 | 25173.89 | 25265.93 | 10609.0 |
| 2025-10-19 21:00:00 | NQ | Futures | 25266.69 | 25295.69 | 25249.54 | 25265.68 | 6601.0 |
| 2025-10-19 22:00:00 | NQ | Futures | 25265.18 | 25278.04 | 25245.51 | 25270.73 | 3591.0 |
| 2025-10-19 23:00:00 | NQ | Futures | 25272.49 | 25318.39 | 25270.47 | 25314.61 | 3297.0 |
| 2025-10-19 18:00:00 | YM | Futures | 47145.1 | 47167.4 | 47098.4 | 47113.6 | 386.0 |
| 2025-10-19 19:00:00 | YM | Futures | 47116.7 | 47116.7 | 47024.4 | 47042.6 | 607.0 |
| 2025-10-19 20:00:00 | YM | Futures | 47041.6 | 47102.5 | 46969.6 | 47093.3 | 2519.0 |
| 2025-10-19 21:00:00 | YM | Futures | 47091.3 | 47132.9 | 47068.0 | 47086.2 | 956.0 |
| 2025-10-19 22:00:00 | YM | Futures | 47086.2 | 47107.5 | 47066.0 | 47102.5 | 483.0 |
| 2025-10-19 23:00:00 | YM | Futures | 47102.5 | 47151.1 | 47097.4 | 47140.0 | 382.0 |
| 2025-10-19 18:00:00 | CL | Futures | 56.25 | 56.36 | 56.02 | 56.08 | 2741.0 |
| 2025-10-19 19:00:00 | CL | Futures | 56.08 | 56.15 | 55.88 | 55.89 | 917.0 |
| 2025-10-19 20:00:00 | CL | Futures | 55.89 | 55.96 | 55.83 | 55.93 | 1395.0 |
| 2025-10-19 21:00:00 | CL | Futures | 55.92 | 56.0 | 55.7 | 55.83 | 2094.0 |
| 2025-10-19 22:00:00 | CL | Futures | 55.83 | 55.97 | 55.82 | 55.88 | 919.0 |
| 2025-10-19 23:00:00 | CL | Futures | 55.89 | 55.95 | 55.85 | 55.91 | 920.0 |
| 2025-10-19 18:00:00 | GC | Futures | 4336.1 | 4357.3 | 4320.0 | 4336.8 | 10444.0 |
| 2025-10-19 19:00:00 | GC | Futures | 4336.8 | 4337.5 | 4310.0 | 4316.8 | 5814.0 |
| 2025-10-19 20:00:00 | GC | Futures | 4316.2 | 4329.4 | 4296.1 | 4327.7 | 12024.0 |
| 2025-10-19 21:00:00 | GC | Futures | 4327.4 | 4348.3 | 4307.3 | 4341.4 | 14511.0 |
| 2025-10-19 22:00:00 | GC | Futures | 4341.9 | 4350.3 | 4331.2 | 4333.8 | 7673.0 |
| 2025-10-19 23:00:00 | GC | Futures | 4333.8 | 4345.7 | 4327.9 | 4344.8 | 7159.0 |
| 2025-10-19 18:00:00 | ZN | Futures | 113.421875 | 113.4375 | 113.34375 | 113.40625 | 12297.0 |
| 2025-10-19 19:00:00 | ZN | Futures | 113.40625 | 113.4375 | 113.40625 | 113.421875 | 4005.0 |
| 2025-10-19 20:00:00 | ZN | Futures | 113.421875 | 113.453125 | 113.375 | 113.40625 | 25045.0 |
| 2025-10-19 21:00:00 | ZN | Futures | 113.40625 | 113.421875 | 113.359375 | 113.375 | 14753.0 |
| 2025-10-19 22:00:00 | ZN | Futures | 113.375 | 113.421875 | 113.375 | 113.40625 | 6102.0 |
| 2025-10-19 23:00:00 | ZN | Futures | 113.421875 | 113.421875 | 113.390625 | 113.390625 | 3928.0 |
> showing 36 of 360 rows — these rows as CSV