PREVIEW / futures_1hour / 2025-03-24
file: by_date/futures_1hour/2025/2025-03-24.parquet size: 67 KB rows: 2,101
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-03-24 00:00:00 | ES | Futures | 5846.99 | 5848.26 | 5845.21 | 5847.49 | 2342.0 |
| 2025-03-24 01:00:00 | ES | Futures | 5847.49 | 5850.8 | 5847.49 | 5848.76 | 3068.0 |
| 2025-03-24 02:00:00 | ES | Futures | 5848.76 | 5857.91 | 5848.0 | 5857.15 | 6361.0 |
| 2025-03-24 03:00:00 | ES | Futures | 5856.89 | 5862.48 | 5856.13 | 5859.18 | 10541.0 |
| 2025-03-24 04:00:00 | ES | Futures | 5858.93 | 5872.14 | 5858.16 | 5869.6 | 24418.0 |
| 2025-03-24 05:00:00 | ES | Futures | 5869.6 | 5873.91 | 5861.72 | 5865.78 | 23041.0 |
| 2025-03-24 06:00:00 | ES | Futures | 5865.53 | 5875.44 | 5864.01 | 5873.15 | 14388.0 |
| 2025-03-24 07:00:00 | ES | Futures | 5872.9 | 5880.77 | 5871.37 | 5877.47 | 31245.0 |
| 2025-03-24 08:00:00 | ES | Futures | 5877.22 | 5881.54 | 5873.91 | 5880.01 | 24747.0 |
| 2025-03-24 09:00:00 | ES | Futures | 5880.01 | 5898.3 | 5869.34 | 5895.76 | 156867.0 |
| 2025-03-24 10:00:00 | ES | Futures | 5895.76 | 5905.41 | 5888.14 | 5904.4 | 177035.0 |
| 2025-03-24 11:00:00 | ES | Futures | 5904.4 | 5908.97 | 5899.32 | 5907.96 | 111957.0 |
| 2025-03-24 12:00:00 | ES | Futures | 5907.7 | 5913.29 | 5896.27 | 5899.57 | 149796.0 |
| 2025-03-24 13:00:00 | ES | Futures | 5899.83 | 5902.62 | 5892.2 | 5899.57 | 106477.0 |
| 2025-03-24 14:00:00 | ES | Futures | 5899.57 | 5905.16 | 5888.65 | 5904.91 | 150764.0 |
| 2025-03-24 15:00:00 | ES | Futures | 5904.91 | 5919.64 | 5903.13 | 5907.45 | 220329.0 |
| 2025-03-24 16:00:00 | ES | Futures | 5907.7 | 5913.8 | 5906.69 | 5906.94 | 55952.0 |
| 2025-03-24 18:00:00 | ES | Futures | 5906.94 | 5909.23 | 5903.13 | 5904.14 | 5215.0 |
| 2025-03-24 19:00:00 | ES | Futures | 5904.14 | 5908.21 | 5903.13 | 5905.41 | 3899.0 |
| 2025-03-24 20:00:00 | ES | Futures | 5905.67 | 5908.72 | 5900.59 | 5908.21 | 13315.0 |
| 2025-03-24 21:00:00 | ES | Futures | 5907.96 | 5909.99 | 5906.18 | 5907.45 | 7287.0 |
| 2025-03-24 22:00:00 | ES | Futures | 5907.19 | 5907.19 | 5901.6 | 5903.38 | 5515.0 |
| 2025-03-24 23:00:00 | ES | Futures | 5903.64 | 5904.65 | 5900.08 | 5901.1 | 3594.0 |
| 2025-03-24 00:00:00 | NQ | Futures | 20478.16 | 20488.09 | 20470.01 | 20486.82 | 1920.0 |
| 2025-03-24 01:00:00 | NQ | Futures | 20486.05 | 20500.57 | 20486.05 | 20490.89 | 1857.0 |
| 2025-03-24 02:00:00 | NQ | Futures | 20490.89 | 20524.76 | 20484.52 | 20521.7 | 3890.0 |
| 2025-03-24 03:00:00 | NQ | Futures | 20521.45 | 20548.44 | 20515.34 | 20542.84 | 8900.0 |
| 2025-03-24 04:00:00 | NQ | Futures | 20542.08 | 20603.7 | 20533.93 | 20587.15 | 12886.0 |
| 2025-03-24 05:00:00 | NQ | Futures | 20586.13 | 20598.1 | 20555.06 | 20564.99 | 9502.0 |
| 2025-03-24 06:00:00 | NQ | Futures | 20564.23 | 20606.5 | 20558.88 | 20590.97 | 6223.0 |
| 2025-03-24 07:00:00 | NQ | Futures | 20590.21 | 20639.86 | 20586.39 | 20629.93 | 14015.0 |
| 2025-03-24 08:00:00 | NQ | Futures | 20630.7 | 20653.61 | 20614.4 | 20650.3 | 12957.0 |
| 2025-03-24 09:00:00 | NQ | Futures | 20650.05 | 20717.02 | 20605.74 | 20694.1 | 74506.0 |
| 2025-03-24 10:00:00 | NQ | Futures | 20693.59 | 20738.41 | 20652.09 | 20728.23 | 74184.0 |
| 2025-03-24 11:00:00 | NQ | Futures | 20727.97 | 20749.36 | 20706.58 | 20733.32 | 46951.0 |
| 2025-03-24 12:00:00 | NQ | Futures | 20733.83 | 20760.06 | 20697.16 | 20720.08 | 50063.0 |
| 2025-03-24 13:00:00 | NQ | Futures | 20721.1 | 20728.99 | 20686.97 | 20721.1 | 37000.0 |
| 2025-03-24 14:00:00 | NQ | Futures | 20721.35 | 20752.67 | 20686.21 | 20745.03 | 49797.0 |
| 2025-03-24 15:00:00 | NQ | Futures | 20745.29 | 20789.34 | 20738.67 | 20744.78 | 69956.0 |
| 2025-03-24 16:00:00 | NQ | Futures | 20744.78 | 20758.53 | 20735.1 | 20736.12 | 18851.0 |
| 2025-03-24 18:00:00 | NQ | Futures | 20731.79 | 20745.29 | 20720.84 | 20726.95 | 2895.0 |
| 2025-03-24 19:00:00 | NQ | Futures | 20727.21 | 20746.82 | 20722.12 | 20733.83 | 2888.0 |
| 2025-03-24 20:00:00 | NQ | Futures | 20733.58 | 20750.64 | 20712.44 | 20747.84 | 7019.0 |
| 2025-03-24 21:00:00 | NQ | Futures | 20746.82 | 20753.95 | 20737.39 | 20740.45 | 3258.0 |
| 2025-03-24 22:00:00 | NQ | Futures | 20739.69 | 20739.69 | 20716.51 | 20722.88 | 5143.0 |
| 2025-03-24 23:00:00 | NQ | Futures | 20722.12 | 20726.95 | 20708.11 | 20717.28 | 2249.0 |
| 2025-03-24 00:00:00 | YM | Futures | 43778.7 | 43781.8 | 43766.4 | 43775.6 | 204.0 |
| 2025-03-24 01:00:00 | YM | Futures | 43776.7 | 43797.2 | 43776.7 | 43788.0 | 316.0 |
| 2025-03-24 02:00:00 | YM | Futures | 43788.0 | 43856.9 | 43785.9 | 43847.7 | 938.0 |
| 2025-03-24 03:00:00 | YM | Futures | 43847.7 | 43884.7 | 43837.4 | 43839.4 | 1671.0 |
> showing 50 of 2,101 rows — these rows as CSV