PREVIEW / futures_1hour / 2023-11-19
file: by_date/futures_1hour/2023/2023-11-19.parquet size: 19 KB rows: 435
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 |
|---|---|---|---|---|---|---|---|
| 2023-11-19 18:00:00 | ES | Futures | 4917.11 | 4919.55 | 4910.32 | 4914.66 | 14774.0 |
| 2023-11-19 19:00:00 | ES | Futures | 4914.66 | 4916.02 | 4913.03 | 4914.39 | 6495.0 |
| 2023-11-19 20:00:00 | ES | Futures | 4914.39 | 4916.84 | 4912.22 | 4913.31 | 6194.0 |
| 2023-11-19 21:00:00 | ES | Futures | 4913.58 | 4916.29 | 4913.31 | 4915.48 | 5145.0 |
| 2023-11-19 22:00:00 | ES | Futures | 4915.48 | 4915.75 | 4912.76 | 4913.03 | 3815.0 |
| 2023-11-19 23:00:00 | ES | Futures | 4913.03 | 4914.39 | 4912.76 | 4913.03 | 2495.0 |
| 2023-11-19 18:00:00 | NQ | Futures | 17463.15 | 17472.76 | 17411.79 | 17429.37 | 9141.0 |
| 2023-11-19 19:00:00 | NQ | Futures | 17429.37 | 17435.13 | 17420.03 | 17428.82 | 4354.0 |
| 2023-11-19 20:00:00 | NQ | Futures | 17428.54 | 17438.43 | 17419.2 | 17424.7 | 4673.0 |
| 2023-11-19 21:00:00 | NQ | Futures | 17424.7 | 17429.91 | 17420.58 | 17426.62 | 3132.0 |
| 2023-11-19 22:00:00 | NQ | Futures | 17426.62 | 17426.62 | 17415.08 | 17416.46 | 3080.0 |
| 2023-11-19 23:00:00 | NQ | Futures | 17416.73 | 17422.77 | 17415.63 | 17418.1 | 2046.0 |
| 2023-11-19 18:00:00 | YM | Futures | 37943.9 | 37985.1 | 37941.7 | 37977.5 | 1813.0 |
| 2023-11-19 19:00:00 | YM | Futures | 37978.6 | 37993.8 | 37973.2 | 37979.7 | 749.0 |
| 2023-11-19 20:00:00 | YM | Futures | 37980.8 | 37987.3 | 37959.1 | 37965.6 | 827.0 |
| 2023-11-19 21:00:00 | YM | Futures | 37966.7 | 37992.7 | 37965.6 | 37986.2 | 650.0 |
| 2023-11-19 22:00:00 | YM | Futures | 37986.2 | 37989.5 | 37967.8 | 37968.9 | 576.0 |
| 2023-11-19 23:00:00 | YM | Futures | 37968.9 | 37977.5 | 37965.6 | 37967.8 | 292.0 |
| 2023-11-19 18:00:00 | CL | Futures | 63.64 | 64.05 | 63.31 | 64.02 | 3884.0 |
| 2023-11-19 19:00:00 | CL | Futures | 64.02 | 64.02 | 63.82 | 63.87 | 1405.0 |
| 2023-11-19 20:00:00 | CL | Futures | 63.87 | 64.18 | 63.75 | 64.06 | 5341.0 |
| 2023-11-19 21:00:00 | CL | Futures | 64.05 | 64.39 | 64.0 | 64.28 | 2875.0 |
| 2023-11-19 22:00:00 | CL | Futures | 64.28 | 64.33 | 64.24 | 64.3 | 1108.0 |
| 2023-11-19 23:00:00 | CL | Futures | 64.3 | 64.38 | 64.29 | 64.3 | 988.0 |
| 2023-11-19 18:00:00 | GC | Futures | 2212.6 | 2213.1 | 2207.1 | 2208.2 | 2911.0 |
| 2023-11-19 19:00:00 | GC | Futures | 2208.2 | 2211.7 | 2206.9 | 2211.6 | 3018.0 |
| 2023-11-19 20:00:00 | GC | Futures | 2211.6 | 2217.8 | 2211.5 | 2215.7 | 5268.0 |
| 2023-11-19 21:00:00 | GC | Futures | 2215.6 | 2220.3 | 2214.2 | 2217.6 | 4874.0 |
| 2023-11-19 22:00:00 | GC | Futures | 2217.5 | 2217.8 | 2214.6 | 2217.1 | 2523.0 |
| 2023-11-19 23:00:00 | GC | Futures | 2217.2 | 2218.4 | 2215.4 | 2215.7 | 2512.0 |
| 2023-11-19 18:00:00 | ZN | Futures | 110.386587 | 110.434195 | 110.275502 | 110.354848 | 22568.0 |
| 2023-11-19 19:00:00 | ZN | Futures | 110.354848 | 110.418325 | 110.291371 | 110.370718 | 15068.0 |
| 2023-11-19 20:00:00 | ZN | Futures | 110.370718 | 110.434195 | 110.370718 | 110.402456 | 12539.0 |
| 2023-11-19 21:00:00 | ZN | Futures | 110.402456 | 110.465933 | 110.370718 | 110.450064 | 9438.0 |
| 2023-11-19 22:00:00 | ZN | Futures | 110.450064 | 110.481802 | 110.418325 | 110.465933 | 6393.0 |
| 2023-11-19 23:00:00 | ZN | Futures | 110.465933 | 110.481802 | 110.402456 | 110.402456 | 5024.0 |
> showing 36 of 435 rows — these rows as CSV