PREVIEW / futures_1hour / 2025-04-27
file: by_date/futures_1hour/2025/2025-04-27.parquet size: 20 KB rows: 452
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-04-27 18:00:00 | ES | Futures | 5633.59 | 5637.15 | 5621.4 | 5622.67 | 9997.0 |
| 2025-04-27 19:00:00 | ES | Futures | 5622.67 | 5624.19 | 5616.32 | 5620.13 | 5102.0 |
| 2025-04-27 20:00:00 | ES | Futures | 5620.38 | 5623.43 | 5608.7 | 5610.73 | 6845.0 |
| 2025-04-27 21:00:00 | ES | Futures | 5610.98 | 5615.56 | 5606.92 | 5613.52 | 5690.0 |
| 2025-04-27 22:00:00 | ES | Futures | 5613.52 | 5618.1 | 5608.7 | 5611.49 | 5834.0 |
| 2025-04-27 23:00:00 | ES | Futures | 5612.0 | 5613.01 | 5605.39 | 5607.43 | 3823.0 |
| 2025-04-27 18:00:00 | NQ | Futures | 19887.87 | 19887.87 | 19811.99 | 19822.68 | 6656.0 |
| 2025-04-27 19:00:00 | NQ | Futures | 19821.92 | 19837.45 | 19796.96 | 19816.82 | 3272.0 |
| 2025-04-27 20:00:00 | NQ | Futures | 19819.12 | 19833.89 | 19763.35 | 19774.81 | 4501.0 |
| 2025-04-27 21:00:00 | NQ | Futures | 19774.3 | 19794.42 | 19753.16 | 19791.11 | 3661.0 |
| 2025-04-27 22:00:00 | NQ | Futures | 19791.61 | 19814.28 | 19767.17 | 19778.88 | 3797.0 |
| 2025-04-27 23:00:00 | NQ | Futures | 19779.14 | 19783.72 | 19756.22 | 19765.39 | 2622.0 |
| 2025-04-27 18:00:00 | YM | Futures | 41404.4 | 41408.5 | 41301.5 | 41330.3 | 777.0 |
| 2025-04-27 19:00:00 | YM | Futures | 41325.2 | 41332.4 | 41285.0 | 41303.6 | 304.0 |
| 2025-04-27 20:00:00 | YM | Futures | 41301.5 | 41318.0 | 41253.1 | 41264.5 | 734.0 |
| 2025-04-27 21:00:00 | YM | Futures | 41259.3 | 41289.2 | 41247.0 | 41268.6 | 447.0 |
| 2025-04-27 22:00:00 | YM | Futures | 41269.6 | 41300.5 | 41255.2 | 41264.5 | 414.0 |
| 2025-04-27 23:00:00 | YM | Futures | 41271.7 | 41278.9 | 41235.6 | 41247.0 | 387.0 |
| 2025-04-27 18:00:00 | CL | Futures | 59.29 | 59.69 | 58.88 | 59.19 | 4464.0 |
| 2025-04-27 19:00:00 | CL | Futures | 59.19 | 59.24 | 58.9 | 58.94 | 2450.0 |
| 2025-04-27 20:00:00 | CL | Futures | 58.94 | 59.09 | 58.9 | 58.98 | 1544.0 |
| 2025-04-27 21:00:00 | CL | Futures | 58.98 | 59.18 | 58.78 | 58.8 | 2207.0 |
| 2025-04-27 22:00:00 | CL | Futures | 58.79 | 58.84 | 58.72 | 58.74 | 1012.0 |
| 2025-04-27 23:00:00 | CL | Futures | 58.74 | 59.11 | 58.74 | 59.0 | 1415.0 |
| 2025-04-27 18:00:00 | GC | Futures | 3446.8 | 3458.9 | 3428.9 | 3430.7 | 8391.0 |
| 2025-04-27 19:00:00 | GC | Futures | 3431.1 | 3438.3 | 3418.9 | 3423.2 | 6766.0 |
| 2025-04-27 20:00:00 | GC | Futures | 3422.9 | 3436.6 | 3421.9 | 3434.5 | 7865.0 |
| 2025-04-27 21:00:00 | GC | Futures | 3434.1 | 3435.7 | 3397.7 | 3399.6 | 15660.0 |
| 2025-04-27 22:00:00 | GC | Futures | 3399.7 | 3406.4 | 3386.4 | 3399.7 | 12628.0 |
| 2025-04-27 23:00:00 | GC | Futures | 3399.8 | 3415.3 | 3399.3 | 3410.8 | 7147.0 |
| 2025-04-27 18:00:00 | ZN | Futures | 111.687516 | 111.703145 | 111.59374 | 111.624998 | 7970.0 |
| 2025-04-27 19:00:00 | ZN | Futures | 111.609369 | 111.687516 | 111.609369 | 111.671887 | 4507.0 |
| 2025-04-27 20:00:00 | ZN | Futures | 111.656257 | 111.718775 | 111.59374 | 111.624998 | 20203.0 |
| 2025-04-27 21:00:00 | ZN | Futures | 111.624998 | 111.734404 | 111.59374 | 111.734404 | 12013.0 |
| 2025-04-27 22:00:00 | ZN | Futures | 111.734404 | 111.734404 | 111.624998 | 111.671887 | 8009.0 |
| 2025-04-27 23:00:00 | ZN | Futures | 111.671887 | 111.687516 | 111.624998 | 111.656257 | 7786.0 |
> showing 36 of 452 rows — these rows as CSV