PREVIEW / futures_1hour / 2025-03-09
file: by_date/futures_1hour/2025/2025-03-09.parquet size: 18 KB rows: 399
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-09 18:00:00 | ES | Futures | 5899.76 | 5903.09 | 5868.74 | 5874.12 | 31715.0 |
| 2025-03-09 19:00:00 | ES | Futures | 5874.12 | 5884.38 | 5856.18 | 5879.51 | 22004.0 |
| 2025-03-09 20:00:00 | ES | Futures | 5879.76 | 5886.17 | 5872.33 | 5884.64 | 27649.0 |
| 2025-03-09 21:00:00 | ES | Futures | 5885.15 | 5899.25 | 5883.87 | 5898.74 | 12995.0 |
| 2025-03-09 22:00:00 | ES | Futures | 5898.48 | 5902.07 | 5894.63 | 5898.99 | 7394.0 |
| 2025-03-09 23:00:00 | ES | Futures | 5898.99 | 5901.56 | 5891.04 | 5897.2 | 6891.0 |
| 2025-03-09 18:00:00 | NQ | Futures | 20739.05 | 20739.05 | 20583.1 | 20600.09 | 12099.0 |
| 2025-03-09 19:00:00 | NQ | Futures | 20602.15 | 20651.04 | 20517.99 | 20623.25 | 7407.0 |
| 2025-03-09 20:00:00 | NQ | Futures | 20621.96 | 20657.22 | 20594.94 | 20656.45 | 9228.0 |
| 2025-03-09 21:00:00 | NQ | Futures | 20656.45 | 20728.25 | 20650.01 | 20724.9 | 8662.0 |
| 2025-03-09 22:00:00 | NQ | Futures | 20725.16 | 20748.83 | 20708.17 | 20728.5 | 5206.0 |
| 2025-03-09 23:00:00 | NQ | Futures | 20728.25 | 20743.94 | 20692.73 | 20717.44 | 4703.0 |
| 2025-03-09 18:00:00 | YM | Futures | 43972.3 | 43972.3 | 43756.2 | 43797.3 | 2190.0 |
| 2025-03-09 19:00:00 | YM | Futures | 43797.3 | 43864.2 | 43677.9 | 43849.8 | 2419.0 |
| 2025-03-09 20:00:00 | YM | Futures | 43849.8 | 43879.7 | 43793.2 | 43861.1 | 2404.0 |
| 2025-03-09 21:00:00 | YM | Futures | 43861.1 | 43932.2 | 43855.0 | 43928.0 | 1491.0 |
| 2025-03-09 22:00:00 | YM | Futures | 43927.0 | 43944.5 | 43904.4 | 43932.2 | 720.0 |
| 2025-03-09 23:00:00 | YM | Futures | 43932.2 | 43952.8 | 43893.1 | 43937.3 | 663.0 |
| 2025-03-09 18:00:00 | CL | Futures | 62.41 | 62.62 | 62.02 | 62.02 | 2238.0 |
| 2025-03-09 19:00:00 | CL | Futures | 62.04 | 62.06 | 61.84 | 61.88 | 1596.0 |
| 2025-03-09 20:00:00 | CL | Futures | 61.88 | 62.17 | 61.87 | 62.14 | 1600.0 |
| 2025-03-09 21:00:00 | CL | Futures | 62.15 | 62.21 | 61.96 | 62.04 | 2029.0 |
| 2025-03-09 22:00:00 | CL | Futures | 62.04 | 62.12 | 61.94 | 61.96 | 1412.0 |
| 2025-03-09 23:00:00 | CL | Futures | 61.97 | 62.02 | 61.87 | 61.96 | 1212.0 |
| 2025-03-09 18:00:00 | GC | Futures | 3015.8 | 3019.6 | 3013.5 | 3015.3 | 1797.0 |
| 2025-03-09 19:00:00 | GC | Futures | 3015.3 | 3021.5 | 3014.8 | 3020.7 | 1612.0 |
| 2025-03-09 20:00:00 | GC | Futures | 3020.7 | 3022.8 | 3016.5 | 3017.2 | 2776.0 |
| 2025-03-09 21:00:00 | GC | Futures | 3017.2 | 3022.1 | 3014.2 | 3014.9 | 3566.0 |
| 2025-03-09 22:00:00 | GC | Futures | 3015.0 | 3017.3 | 3011.8 | 3014.1 | 2698.0 |
| 2025-03-09 23:00:00 | GC | Futures | 3014.0 | 3016.0 | 3010.0 | 3012.9 | 3008.0 |
| 2025-03-09 18:00:00 | ZN | Futures | 110.796642 | 110.999823 | 110.781012 | 110.921677 | 37098.0 |
| 2025-03-09 19:00:00 | ZN | Futures | 110.921677 | 111.031082 | 110.906047 | 110.999823 | 29404.0 |
| 2025-03-09 20:00:00 | ZN | Futures | 110.984194 | 111.031082 | 110.874788 | 110.890418 | 28136.0 |
| 2025-03-09 21:00:00 | ZN | Futures | 110.890418 | 110.906047 | 110.812271 | 110.812271 | 24565.0 |
| 2025-03-09 22:00:00 | ZN | Futures | 110.812271 | 110.874788 | 110.812271 | 110.84353 | 13793.0 |
| 2025-03-09 23:00:00 | ZN | Futures | 110.84353 | 110.874788 | 110.796642 | 110.84353 | 12873.0 |
> showing 36 of 399 rows — these rows as CSV