PREVIEW / futures_1hour / 2025-10-24
file: by_date/futures_1hour/2025/2025-10-24.parquet size: 54 KB rows: 1,664
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-24 00:00:00 | ES | Futures | 6838.65 | 6839.41 | 6836.13 | 6838.65 | 3243.0 |
| 2025-10-24 01:00:00 | ES | Futures | 6838.65 | 6842.68 | 6837.64 | 6842.43 | 4745.0 |
| 2025-10-24 02:00:00 | ES | Futures | 6842.43 | 6849.23 | 6841.92 | 6845.95 | 8816.0 |
| 2025-10-24 03:00:00 | ES | Futures | 6846.21 | 6846.46 | 6838.4 | 6839.15 | 11161.0 |
| 2025-10-24 04:00:00 | ES | Futures | 6839.15 | 6844.44 | 6834.87 | 6840.66 | 13797.0 |
| 2025-10-24 05:00:00 | ES | Futures | 6840.41 | 6849.73 | 6840.16 | 6845.45 | 9525.0 |
| 2025-10-24 06:00:00 | ES | Futures | 6845.45 | 6848.72 | 6843.44 | 6843.94 | 8922.0 |
| 2025-10-24 07:00:00 | ES | Futures | 6843.94 | 6850.74 | 6843.44 | 6848.47 | 11959.0 |
| 2025-10-24 08:00:00 | ES | Futures | 6848.72 | 6888.52 | 6843.44 | 6863.84 | 70189.0 |
| 2025-10-24 09:00:00 | ES | Futures | 6864.09 | 6886.25 | 6863.59 | 6880.71 | 190980.0 |
| 2025-10-24 10:00:00 | ES | Futures | 6881.22 | 6886.76 | 6866.36 | 6874.16 | 211750.0 |
| 2025-10-24 11:00:00 | ES | Futures | 6874.16 | 6892.55 | 6872.15 | 6887.01 | 145974.0 |
| 2025-10-24 12:00:00 | ES | Futures | 6887.01 | 6892.55 | 6879.45 | 6887.26 | 84761.0 |
| 2025-10-24 13:00:00 | ES | Futures | 6887.01 | 6892.05 | 6883.99 | 6888.02 | 61741.0 |
| 2025-10-24 14:00:00 | ES | Futures | 6888.02 | 6891.04 | 6884.49 | 6889.28 | 73729.0 |
| 2025-10-24 15:00:00 | ES | Futures | 6889.02 | 6892.3 | 6874.92 | 6878.45 | 215392.0 |
| 2025-10-24 16:00:00 | ES | Futures | 6878.45 | 6880.71 | 6875.42 | 6876.43 | 49960.0 |
| 2025-10-24 00:00:00 | NQ | Futures | 25549.89 | 25556.7 | 25541.07 | 25554.18 | 2144.0 |
| 2025-10-24 01:00:00 | NQ | Futures | 25553.42 | 25569.06 | 25548.89 | 25567.8 | 2470.0 |
| 2025-10-24 02:00:00 | NQ | Futures | 25568.3 | 25603.36 | 25566.54 | 25582.43 | 5961.0 |
| 2025-10-24 03:00:00 | NQ | Futures | 25583.43 | 25590.24 | 25554.94 | 25558.72 | 5160.0 |
| 2025-10-24 04:00:00 | NQ | Futures | 25559.48 | 25593.27 | 25545.35 | 25575.36 | 6744.0 |
| 2025-10-24 05:00:00 | NQ | Futures | 25573.6 | 25615.46 | 25573.6 | 25598.82 | 5168.0 |
| 2025-10-24 06:00:00 | NQ | Futures | 25599.07 | 25612.94 | 25586.21 | 25588.48 | 5805.0 |
| 2025-10-24 07:00:00 | NQ | Futures | 25587.72 | 25608.15 | 25584.7 | 25596.04 | 5114.0 |
| 2025-10-24 08:00:00 | NQ | Futures | 25596.3 | 25746.35 | 25565.53 | 25680.27 | 29090.0 |
| 2025-10-24 09:00:00 | NQ | Futures | 25681.53 | 25758.2 | 25652.03 | 25728.95 | 76823.0 |
| 2025-10-24 10:00:00 | NQ | Futures | 25735.75 | 25772.07 | 25653.79 | 25690.61 | 83308.0 |
| 2025-10-24 11:00:00 | NQ | Futures | 25690.36 | 25769.8 | 25679.27 | 25746.09 | 56291.0 |
| 2025-10-24 12:00:00 | NQ | Futures | 25745.59 | 25786.44 | 25743.07 | 25774.34 | 36332.0 |
| 2025-10-24 13:00:00 | NQ | Futures | 25774.34 | 25794.26 | 25761.98 | 25772.57 | 24942.0 |
| 2025-10-24 14:00:00 | NQ | Futures | 25772.32 | 25778.37 | 25751.39 | 25767.28 | 25380.0 |
| 2025-10-24 15:00:00 | NQ | Futures | 25767.03 | 25790.23 | 25720.37 | 25732.48 | 55062.0 |
| 2025-10-24 16:00:00 | NQ | Futures | 25731.97 | 25748.87 | 25720.37 | 25733.23 | 15673.0 |
| 2025-10-24 00:00:00 | YM | Futures | 47634.9 | 47641.0 | 47619.7 | 47634.9 | 574.0 |
| 2025-10-24 01:00:00 | YM | Futures | 47634.9 | 47664.3 | 47628.8 | 47662.3 | 347.0 |
| 2025-10-24 02:00:00 | YM | Futures | 47663.3 | 47696.7 | 47659.2 | 47675.4 | 874.0 |
| 2025-10-24 03:00:00 | YM | Futures | 47675.4 | 47681.5 | 47615.6 | 47620.7 | 1328.0 |
| 2025-10-24 04:00:00 | YM | Futures | 47622.7 | 47627.8 | 47557.8 | 47595.3 | 1520.0 |
| 2025-10-24 05:00:00 | YM | Futures | 47595.3 | 47651.1 | 47594.3 | 47628.8 | 586.0 |
| 2025-10-24 06:00:00 | YM | Futures | 47631.8 | 47655.2 | 47621.7 | 47629.8 | 1078.0 |
| 2025-10-24 07:00:00 | YM | Futures | 47628.8 | 47680.5 | 47628.8 | 47671.4 | 1273.0 |
| 2025-10-24 08:00:00 | YM | Futures | 47669.4 | 47935.1 | 47647.0 | 47780.9 | 4775.0 |
| 2025-10-24 09:00:00 | YM | Futures | 47777.9 | 47997.9 | 47765.7 | 47986.8 | 16594.0 |
| 2025-10-24 10:00:00 | YM | Futures | 47982.7 | 48024.3 | 47905.6 | 47972.6 | 13455.0 |
| 2025-10-24 11:00:00 | YM | Futures | 47971.6 | 48178.4 | 47958.4 | 48133.8 | 12385.0 |
| 2025-10-24 12:00:00 | YM | Futures | 48135.8 | 48159.2 | 48034.4 | 48085.1 | 8070.0 |
| 2025-10-24 13:00:00 | YM | Futures | 48085.1 | 48178.4 | 48068.9 | 48122.7 | 5411.0 |
| 2025-10-24 14:00:00 | YM | Futures | 48119.6 | 48156.1 | 48102.4 | 48153.1 | 3998.0 |
| 2025-10-24 15:00:00 | YM | Futures | 48150.0 | 48163.2 | 48044.6 | 48066.9 | 10123.0 |
> showing 50 of 1,664 rows — these rows as CSV