PREVIEW / futures_1hour / 2024-06-23
file: by_date/futures_1hour/2024/2024-06-23.parquet size: 19 KB rows: 419
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-06-23 18:00:00 | ES | Futures | 5807.98 | 5809.29 | 5805.88 | 5806.93 | 4532.0 |
| 2024-06-23 19:00:00 | ES | Futures | 5806.93 | 5809.03 | 5805.62 | 5806.14 | 2799.0 |
| 2024-06-23 20:00:00 | ES | Futures | 5806.14 | 5807.72 | 5804.83 | 5806.14 | 3943.0 |
| 2024-06-23 21:00:00 | ES | Futures | 5805.88 | 5806.41 | 5788.32 | 5794.87 | 17412.0 |
| 2024-06-23 22:00:00 | ES | Futures | 5794.87 | 5796.97 | 5792.51 | 5793.82 | 4504.0 |
| 2024-06-23 23:00:00 | ES | Futures | 5793.82 | 5797.76 | 5793.56 | 5795.92 | 3174.0 |
| 2024-06-23 18:00:00 | NQ | Futures | 21134.18 | 21146.58 | 21119.13 | 21135.76 | 3368.0 |
| 2024-06-23 19:00:00 | NQ | Futures | 21135.23 | 21150.54 | 21124.41 | 21127.84 | 2902.0 |
| 2024-06-23 20:00:00 | NQ | Futures | 21127.84 | 21138.4 | 21119.13 | 21127.05 | 2908.0 |
| 2024-06-23 21:00:00 | NQ | Futures | 21127.58 | 21129.95 | 21032.54 | 21068.18 | 10711.0 |
| 2024-06-23 22:00:00 | NQ | Futures | 21068.71 | 21081.64 | 21057.09 | 21065.8 | 3842.0 |
| 2024-06-23 23:00:00 | NQ | Futures | 21065.54 | 21087.19 | 21065.54 | 21079.79 | 2395.0 |
| 2024-06-23 18:00:00 | YM | Futures | 41597.3 | 41616.2 | 41586.8 | 41588.9 | 811.0 |
| 2024-06-23 19:00:00 | YM | Futures | 41588.9 | 41593.1 | 41580.5 | 41582.6 | 653.0 |
| 2024-06-23 20:00:00 | YM | Futures | 41582.6 | 41585.7 | 41568.9 | 41573.1 | 681.0 |
| 2024-06-23 21:00:00 | YM | Futures | 41571.0 | 41575.2 | 41464.9 | 41502.7 | 2086.0 |
| 2024-06-23 22:00:00 | YM | Futures | 41502.7 | 41510.1 | 41485.9 | 41493.2 | 482.0 |
| 2024-06-23 23:00:00 | YM | Futures | 41493.2 | 41513.2 | 41492.2 | 41500.6 | 428.0 |
| 2024-06-23 18:00:00 | CL | Futures | 68.8 | 69.03 | 68.75 | 68.83 | 1411.0 |
| 2024-06-23 19:00:00 | CL | Futures | 68.83 | 68.83 | 68.62 | 68.63 | 1342.0 |
| 2024-06-23 20:00:00 | CL | Futures | 68.63 | 68.8 | 68.62 | 68.78 | 1788.0 |
| 2024-06-23 21:00:00 | CL | Futures | 68.78 | 68.87 | 68.68 | 68.86 | 2271.0 |
| 2024-06-23 22:00:00 | CL | Futures | 68.86 | 68.94 | 68.8 | 68.89 | 1161.0 |
| 2024-06-23 23:00:00 | CL | Futures | 68.89 | 68.99 | 68.88 | 68.98 | 911.0 |
| 2024-06-23 18:00:00 | GC | Futures | 2505.8 | 2508.6 | 2502.2 | 2506.1 | 2412.0 |
| 2024-06-23 19:00:00 | GC | Futures | 2505.9 | 2505.9 | 2501.5 | 2503.5 | 2315.0 |
| 2024-06-23 20:00:00 | GC | Futures | 2503.3 | 2506.2 | 2502.2 | 2505.4 | 2150.0 |
| 2024-06-23 21:00:00 | GC | Futures | 2505.5 | 2511.4 | 2503.3 | 2508.5 | 4728.0 |
| 2024-06-23 22:00:00 | GC | Futures | 2508.4 | 2510.5 | 2504.2 | 2509.8 | 3035.0 |
| 2024-06-23 23:00:00 | GC | Futures | 2509.8 | 2511.8 | 2509.4 | 2510.5 | 2351.0 |
| 2024-06-23 18:00:00 | ZN | Futures | 111.061906 | 111.093328 | 111.030484 | 111.077617 | 8741.0 |
| 2024-06-23 19:00:00 | ZN | Futures | 111.061906 | 111.12475 | 111.061906 | 111.109039 | 7607.0 |
| 2024-06-23 20:00:00 | ZN | Futures | 111.093328 | 111.12475 | 111.077617 | 111.109039 | 8207.0 |
| 2024-06-23 21:00:00 | ZN | Futures | 111.093328 | 111.171884 | 111.093328 | 111.140461 | 11767.0 |
| 2024-06-23 22:00:00 | ZN | Futures | 111.140461 | 111.171884 | 111.12475 | 111.140461 | 23773.0 |
| 2024-06-23 23:00:00 | ZN | Futures | 111.140461 | 111.156173 | 111.12475 | 111.156173 | 2290.0 |
> showing 36 of 419 rows — these rows as CSV