PREVIEW / futures_1hour / 2024-08-11
file: by_date/futures_1hour/2024/2024-08-11.parquet size: 19 KB rows: 418
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-08-11 18:00:00 | ES | Futures | 5625.25 | 5637.05 | 5610.57 | 5626.56 | 16196.0 |
| 2024-08-11 19:00:00 | ES | Futures | 5626.3 | 5634.43 | 5622.89 | 5631.81 | 5307.0 |
| 2024-08-11 20:00:00 | ES | Futures | 5631.54 | 5632.07 | 5623.94 | 5625.78 | 5228.0 |
| 2024-08-11 21:00:00 | ES | Futures | 5625.51 | 5631.54 | 5620.8 | 5627.09 | 5395.0 |
| 2024-08-11 22:00:00 | ES | Futures | 5627.09 | 5639.15 | 5626.3 | 5635.48 | 4956.0 |
| 2024-08-11 23:00:00 | ES | Futures | 5636.0 | 5637.31 | 5625.51 | 5630.23 | 4178.0 |
| 2024-08-11 18:00:00 | NQ | Futures | 19629.74 | 19702.6 | 19550.54 | 19636.34 | 8039.0 |
| 2024-08-11 19:00:00 | NQ | Futures | 19637.13 | 19686.23 | 19621.82 | 19668.54 | 4018.0 |
| 2024-08-11 20:00:00 | NQ | Futures | 19670.92 | 19675.41 | 19628.42 | 19647.16 | 3686.0 |
| 2024-08-11 21:00:00 | NQ | Futures | 19645.31 | 19668.54 | 19621.82 | 19649.27 | 3267.0 |
| 2024-08-11 22:00:00 | NQ | Futures | 19649.27 | 19711.05 | 19648.22 | 19695.73 | 2702.0 |
| 2024-08-11 23:00:00 | NQ | Futures | 19696.0 | 19706.82 | 19652.71 | 19679.63 | 2454.0 |
| 2024-08-11 18:00:00 | YM | Futures | 41627.7 | 41669.8 | 41539.5 | 41599.4 | 1978.0 |
| 2024-08-11 19:00:00 | YM | Futures | 41597.3 | 41633.0 | 41578.4 | 41621.4 | 927.0 |
| 2024-08-11 20:00:00 | YM | Futures | 41620.4 | 41625.6 | 41584.7 | 41601.5 | 907.0 |
| 2024-08-11 21:00:00 | YM | Futures | 41593.1 | 41629.8 | 41576.2 | 41609.9 | 812.0 |
| 2024-08-11 22:00:00 | YM | Futures | 41608.8 | 41660.3 | 41606.7 | 41649.8 | 681.0 |
| 2024-08-11 23:00:00 | YM | Futures | 41649.8 | 41656.1 | 41592.0 | 41616.2 | 597.0 |
| 2024-08-11 18:00:00 | CL | Futures | 66.84 | 66.92 | 66.59 | 66.83 | 2511.0 |
| 2024-08-11 19:00:00 | CL | Futures | 66.82 | 66.85 | 66.66 | 66.66 | 688.0 |
| 2024-08-11 20:00:00 | CL | Futures | 66.66 | 66.9 | 66.59 | 66.84 | 1373.0 |
| 2024-08-11 21:00:00 | CL | Futures | 66.83 | 66.94 | 66.64 | 66.92 | 2969.0 |
| 2024-08-11 22:00:00 | CL | Futures | 66.92 | 67.02 | 66.86 | 66.97 | 1644.0 |
| 2024-08-11 23:00:00 | CL | Futures | 66.97 | 66.98 | 66.86 | 66.91 | 1184.0 |
| 2024-08-11 18:00:00 | GC | Futures | 2600.9 | 2603.2 | 2596.6 | 2600.1 | 2294.0 |
| 2024-08-11 19:00:00 | GC | Futures | 2600.0 | 2600.2 | 2596.8 | 2597.5 | 1748.0 |
| 2024-08-11 20:00:00 | GC | Futures | 2597.5 | 2598.7 | 2596.3 | 2598.0 | 1467.0 |
| 2024-08-11 21:00:00 | GC | Futures | 2598.0 | 2600.0 | 2594.0 | 2595.6 | 2571.0 |
| 2024-08-11 22:00:00 | GC | Futures | 2595.4 | 2597.2 | 2593.1 | 2595.9 | 3012.0 |
| 2024-08-11 23:00:00 | GC | Futures | 2595.6 | 2598.9 | 2595.4 | 2598.1 | 2315.0 |
| 2024-08-11 18:00:00 | ZN | Futures | 113.559974 | 113.559974 | 113.449996 | 113.465707 | 17836.0 |
| 2024-08-11 19:00:00 | ZN | Futures | 113.465707 | 113.512841 | 113.449996 | 113.481418 | 5042.0 |
| 2024-08-11 20:00:00 | ZN | Futures | 113.497129 | 113.559974 | 113.481418 | 113.544263 | 9270.0 |
| 2024-08-11 21:00:00 | ZN | Futures | 113.559974 | 113.591396 | 113.528552 | 113.559974 | 8524.0 |
| 2024-08-11 22:00:00 | ZN | Futures | 113.544263 | 113.607107 | 113.544263 | 113.591396 | 7660.0 |
| 2024-08-11 23:00:00 | ZN | Futures | 113.591396 | 113.607107 | 113.559974 | 113.575685 | 3710.0 |
> showing 36 of 418 rows — these rows as CSV