PREVIEW / futures_1hour / 2024-01-14
file: by_date/futures_1hour/2024/2024-01-14.parquet size: 19 KB rows: 398
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-01-14 18:00:00 | ES | Futures | 5169.83 | 5170.91 | 5163.92 | 5167.95 | 7246.0 |
| 2024-01-14 19:00:00 | ES | Futures | 5167.95 | 5169.83 | 5165.27 | 5169.29 | 5442.0 |
| 2024-01-14 20:00:00 | ES | Futures | 5169.29 | 5170.37 | 5166.07 | 5169.83 | 5894.0 |
| 2024-01-14 21:00:00 | ES | Futures | 5169.83 | 5176.28 | 5169.56 | 5175.47 | 6156.0 |
| 2024-01-14 22:00:00 | ES | Futures | 5175.74 | 5176.82 | 5174.67 | 5175.47 | 3914.0 |
| 2024-01-14 23:00:00 | ES | Futures | 5175.2 | 5177.08 | 5174.4 | 5177.08 | 4277.0 |
| 2024-01-14 18:00:00 | NQ | Futures | 18400.49 | 18402.93 | 18375.54 | 18382.59 | 3736.0 |
| 2024-01-14 19:00:00 | NQ | Futures | 18382.86 | 18395.88 | 18378.52 | 18394.25 | 2614.0 |
| 2024-01-14 20:00:00 | NQ | Futures | 18394.52 | 18400.76 | 18384.22 | 18396.15 | 3057.0 |
| 2024-01-14 21:00:00 | NQ | Futures | 18396.42 | 18422.73 | 18394.52 | 18420.56 | 3369.0 |
| 2024-01-14 22:00:00 | NQ | Futures | 18421.1 | 18430.05 | 18420.56 | 18425.98 | 2667.0 |
| 2024-01-14 23:00:00 | NQ | Futures | 18425.71 | 18434.39 | 18421.64 | 18432.76 | 2414.0 |
| 2024-01-14 18:00:00 | YM | Futures | 40532.5 | 40570.1 | 40516.4 | 40563.6 | 1279.0 |
| 2024-01-14 19:00:00 | YM | Futures | 40563.6 | 40576.5 | 40546.4 | 40573.3 | 778.0 |
| 2024-01-14 20:00:00 | YM | Futures | 40572.2 | 40581.9 | 40549.7 | 40576.5 | 834.0 |
| 2024-01-14 21:00:00 | YM | Futures | 40577.6 | 40619.5 | 40577.6 | 40618.4 | 614.0 |
| 2024-01-14 22:00:00 | YM | Futures | 40618.4 | 40623.8 | 40609.8 | 40614.1 | 663.0 |
| 2024-01-14 23:00:00 | YM | Futures | 40614.1 | 40622.7 | 40607.7 | 40621.6 | 533.0 |
| 2024-01-14 18:00:00 | CL | Futures | 60.83 | 60.85 | 60.36 | 60.79 | 1793.0 |
| 2024-01-14 19:00:00 | CL | Futures | 60.8 | 60.87 | 60.71 | 60.82 | 631.0 |
| 2024-01-14 20:00:00 | CL | Futures | 60.83 | 60.95 | 60.57 | 60.77 | 1167.0 |
| 2024-01-14 21:00:00 | CL | Futures | 60.78 | 61.06 | 60.77 | 61.04 | 564.0 |
| 2024-01-14 22:00:00 | CL | Futures | 61.03 | 61.09 | 60.94 | 60.95 | 318.0 |
| 2024-01-14 23:00:00 | CL | Futures | 60.94 | 61.0 | 60.92 | 60.98 | 177.0 |
| 2024-01-14 18:00:00 | GC | Futures | 2271.7 | 2271.7 | 2268.3 | 2269.4 | 2507.0 |
| 2024-01-14 19:00:00 | GC | Futures | 2269.5 | 2270.6 | 2267.4 | 2269.8 | 2311.0 |
| 2024-01-14 20:00:00 | GC | Futures | 2269.8 | 2273.8 | 2269.3 | 2273.2 | 3409.0 |
| 2024-01-14 21:00:00 | GC | Futures | 2273.2 | 2279.3 | 2272.1 | 2279.3 | 5321.0 |
| 2024-01-14 22:00:00 | GC | Futures | 2279.2 | 2281.1 | 2278.2 | 2280.3 | 3832.0 |
| 2024-01-14 23:00:00 | GC | Futures | 2280.3 | 2280.5 | 2276.1 | 2277.0 | 1861.0 |
| 2024-01-14 18:00:00 | ZN | Futures | 114.112812 | 114.128653 | 113.970251 | 113.970251 | 17772.0 |
| 2024-01-14 19:00:00 | ZN | Futures | 113.970251 | 114.065292 | 113.970251 | 114.033611 | 7258.0 |
| 2024-01-14 20:00:00 | ZN | Futures | 114.017771 | 114.081132 | 114.001931 | 114.065292 | 6544.0 |
| 2024-01-14 21:00:00 | ZN | Futures | 114.065292 | 114.096972 | 114.065292 | 114.096972 | 5512.0 |
| 2024-01-14 22:00:00 | ZN | Futures | 114.096972 | 114.096972 | 114.049452 | 114.065292 | 7214.0 |
| 2024-01-14 23:00:00 | ZN | Futures | 114.065292 | 114.065292 | 114.033611 | 114.049452 | 3251.0 |
> showing 36 of 398 rows — these rows as CSV