PREVIEW / futures_1hour / 2024-11-24
file: by_date/futures_1hour/2024/2024-11-24.parquet size: 20 KB rows: 458
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 |
|---|---|---|---|---|---|---|---|
| 2024-11-24 18:00:00 | ES | Futures | 6234.79 | 6239.98 | 6234.27 | 6237.64 | 15765.0 |
| 2024-11-24 19:00:00 | ES | Futures | 6237.9 | 6243.09 | 6237.64 | 6242.84 | 8687.0 |
| 2024-11-24 20:00:00 | ES | Futures | 6242.58 | 6244.39 | 6241.8 | 6242.32 | 8690.0 |
| 2024-11-24 21:00:00 | ES | Futures | 6242.32 | 6243.87 | 6242.06 | 6243.35 | 3894.0 |
| 2024-11-24 22:00:00 | ES | Futures | 6243.61 | 6244.13 | 6241.28 | 6242.32 | 3145.0 |
| 2024-11-24 23:00:00 | ES | Futures | 6242.58 | 6243.61 | 6242.32 | 6242.84 | 3015.0 |
| 2024-11-24 18:00:00 | NQ | Futures | 21848.8 | 21868.89 | 21842.01 | 21849.32 | 6930.0 |
| 2024-11-24 19:00:00 | NQ | Futures | 21849.58 | 21871.24 | 21848.54 | 21869.15 | 3587.0 |
| 2024-11-24 20:00:00 | NQ | Futures | 21869.15 | 21883.24 | 21864.45 | 21867.06 | 4433.0 |
| 2024-11-24 21:00:00 | NQ | Futures | 21867.84 | 21879.59 | 21867.32 | 21874.37 | 2541.0 |
| 2024-11-24 22:00:00 | NQ | Futures | 21874.37 | 21883.24 | 21866.28 | 21875.93 | 2534.0 |
| 2024-11-24 23:00:00 | NQ | Futures | 21875.41 | 21885.85 | 21873.58 | 21880.37 | 2195.0 |
| 2024-11-24 18:00:00 | YM | Futures | 46312.4 | 46450.9 | 46303.1 | 46420.7 | 2514.0 |
| 2024-11-24 19:00:00 | YM | Futures | 46417.6 | 46458.1 | 46416.5 | 46455.0 | 928.0 |
| 2024-11-24 20:00:00 | YM | Futures | 46455.0 | 46474.8 | 46443.6 | 46458.1 | 1092.0 |
| 2024-11-24 21:00:00 | YM | Futures | 46460.2 | 46476.9 | 46457.1 | 46475.8 | 592.0 |
| 2024-11-24 22:00:00 | YM | Futures | 46474.8 | 46480.0 | 46457.1 | 46468.5 | 486.0 |
| 2024-11-24 23:00:00 | YM | Futures | 46469.6 | 46474.8 | 46461.3 | 46468.5 | 691.0 |
| 2024-11-24 18:00:00 | CL | Futures | 64.81 | 64.84 | 64.47 | 64.66 | 2115.0 |
| 2024-11-24 19:00:00 | CL | Futures | 64.67 | 64.73 | 64.59 | 64.64 | 1200.0 |
| 2024-11-24 20:00:00 | CL | Futures | 64.65 | 64.8 | 64.53 | 64.55 | 2080.0 |
| 2024-11-24 21:00:00 | CL | Futures | 64.55 | 64.59 | 64.32 | 64.36 | 2503.0 |
| 2024-11-24 22:00:00 | CL | Futures | 64.36 | 64.44 | 64.25 | 64.43 | 2349.0 |
| 2024-11-24 23:00:00 | CL | Futures | 64.43 | 64.5 | 64.27 | 64.28 | 1556.0 |
| 2024-11-24 18:00:00 | GC | Futures | 2860.8 | 2867.4 | 2832.5 | 2865.8 | 8485.0 |
| 2024-11-24 19:00:00 | GC | Futures | 2865.6 | 2866.1 | 2855.1 | 2856.1 | 4277.0 |
| 2024-11-24 20:00:00 | GC | Futures | 2856.2 | 2856.7 | 2839.5 | 2846.4 | 11288.0 |
| 2024-11-24 21:00:00 | GC | Futures | 2846.5 | 2850.0 | 2836.9 | 2839.8 | 5830.0 |
| 2024-11-24 22:00:00 | GC | Futures | 2839.8 | 2842.2 | 2801.9 | 2815.6 | 17625.0 |
| 2024-11-24 23:00:00 | GC | Futures | 2815.6 | 2819.9 | 2806.7 | 2815.5 | 5740.0 |
| 2024-11-24 18:00:00 | ZN | Futures | 110.279294 | 110.310597 | 110.091478 | 110.23234 | 54767.0 |
| 2024-11-24 19:00:00 | ZN | Futures | 110.247992 | 110.263643 | 110.075827 | 110.091478 | 35184.0 |
| 2024-11-24 20:00:00 | ZN | Futures | 110.091478 | 110.169735 | 110.075827 | 110.138432 | 26830.0 |
| 2024-11-24 21:00:00 | ZN | Futures | 110.154084 | 110.216689 | 110.138432 | 110.169735 | 14975.0 |
| 2024-11-24 22:00:00 | ZN | Futures | 110.185386 | 110.216689 | 110.169735 | 110.201038 | 10649.0 |
| 2024-11-24 23:00:00 | ZN | Futures | 110.185386 | 110.201038 | 110.138432 | 110.185386 | 13256.0 |
> showing 36 of 458 rows — these rows as CSV