PREVIEW / futures_30min / 2024-01-14
file: by_date/futures_30min/2024/2024-01-14.parquet size: 28 KB rows: 759
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 | 5165.8 | 4435.0 |
| 2024-01-14 18:30:00 | ES | Futures | 5165.53 | 5169.56 | 5165.53 | 5167.95 | 2811.0 |
| 2024-01-14 19:00:00 | ES | Futures | 5167.95 | 5169.03 | 5165.27 | 5168.22 | 3118.0 |
| 2024-01-14 19:30:00 | ES | Futures | 5168.22 | 5169.83 | 5167.15 | 5169.29 | 2324.0 |
| 2024-01-14 20:00:00 | ES | Futures | 5169.29 | 5170.37 | 5166.88 | 5167.15 | 3086.0 |
| 2024-01-14 20:30:00 | ES | Futures | 5167.41 | 5170.37 | 5166.07 | 5169.83 | 2808.0 |
| 2024-01-14 21:00:00 | ES | Futures | 5169.83 | 5173.86 | 5169.56 | 5173.32 | 3276.0 |
| 2024-01-14 21:30:00 | ES | Futures | 5173.32 | 5176.28 | 5172.52 | 5175.47 | 2880.0 |
| 2024-01-14 22:00:00 | ES | Futures | 5175.74 | 5176.82 | 5174.67 | 5175.47 | 2465.0 |
| 2024-01-14 22:30:00 | ES | Futures | 5175.47 | 5176.82 | 5175.2 | 5175.47 | 1449.0 |
| 2024-01-14 23:00:00 | ES | Futures | 5175.2 | 5175.74 | 5174.4 | 5174.94 | 2284.0 |
| 2024-01-14 23:30:00 | ES | Futures | 5175.2 | 5177.08 | 5174.94 | 5177.08 | 1993.0 |
| 2024-01-14 18:00:00 | NQ | Futures | 18400.49 | 18402.93 | 18375.54 | 18383.13 | 2190.0 |
| 2024-01-14 18:30:00 | NQ | Futures | 18383.13 | 18396.15 | 18380.15 | 18382.59 | 1546.0 |
| 2024-01-14 19:00:00 | NQ | Futures | 18382.86 | 18388.28 | 18378.52 | 18387.2 | 1482.0 |
| 2024-01-14 19:30:00 | NQ | Futures | 18386.93 | 18395.88 | 18382.86 | 18394.25 | 1132.0 |
| 2024-01-14 20:00:00 | NQ | Futures | 18394.52 | 18400.76 | 18385.03 | 18387.47 | 1618.0 |
| 2024-01-14 20:30:00 | NQ | Futures | 18388.01 | 18398.05 | 18384.22 | 18396.15 | 1439.0 |
| 2024-01-14 21:00:00 | NQ | Futures | 18396.42 | 18413.23 | 18394.52 | 18410.79 | 1553.0 |
| 2024-01-14 21:30:00 | NQ | Futures | 18410.25 | 18422.73 | 18408.62 | 18420.56 | 1816.0 |
| 2024-01-14 22:00:00 | NQ | Futures | 18421.1 | 18427.88 | 18420.56 | 18423.81 | 1592.0 |
| 2024-01-14 22:30:00 | NQ | Futures | 18423.81 | 18430.05 | 18423.27 | 18425.98 | 1075.0 |
| 2024-01-14 23:00:00 | NQ | Futures | 18425.71 | 18428.69 | 18421.64 | 18428.15 | 1334.0 |
| 2024-01-14 23:30:00 | NQ | Futures | 18427.88 | 18434.39 | 18425.44 | 18432.76 | 1080.0 |
| 2024-01-14 18:00:00 | YM | Futures | 40532.5 | 40558.2 | 40516.4 | 40538.9 | 692.0 |
| 2024-01-14 18:30:00 | YM | Futures | 40540.0 | 40570.1 | 40537.8 | 40563.6 | 587.0 |
| 2024-01-14 19:00:00 | YM | Futures | 40563.6 | 40571.1 | 40546.4 | 40563.6 | 487.0 |
| 2024-01-14 19:30:00 | YM | Futures | 40562.5 | 40576.5 | 40557.2 | 40573.3 | 291.0 |
| 2024-01-14 20:00:00 | YM | Futures | 40572.2 | 40581.9 | 40557.2 | 40558.2 | 429.0 |
| 2024-01-14 20:30:00 | YM | Futures | 40558.2 | 40581.9 | 40549.7 | 40576.5 | 405.0 |
| 2024-01-14 21:00:00 | YM | Futures | 40577.6 | 40603.4 | 40577.6 | 40600.1 | 329.0 |
| 2024-01-14 21:30:00 | YM | Futures | 40601.2 | 40619.5 | 40599.1 | 40618.4 | 285.0 |
| 2024-01-14 22:00:00 | YM | Futures | 40618.4 | 40623.8 | 40609.8 | 40616.2 | 438.0 |
| 2024-01-14 22:30:00 | YM | Futures | 40618.4 | 40622.7 | 40614.1 | 40614.1 | 225.0 |
| 2024-01-14 23:00:00 | YM | Futures | 40614.1 | 40614.1 | 40607.7 | 40607.7 | 336.0 |
| 2024-01-14 23:30:00 | YM | Futures | 40608.7 | 40622.7 | 40608.7 | 40621.6 | 197.0 |
| 2024-01-14 18:00:00 | CL | Futures | 60.83 | 60.85 | 60.36 | 60.66 | 1357.0 |
| 2024-01-14 18:30:00 | CL | Futures | 60.65 | 60.79 | 60.52 | 60.79 | 436.0 |
| 2024-01-14 19:00:00 | CL | Futures | 60.8 | 60.84 | 60.71 | 60.82 | 417.0 |
| 2024-01-14 19:30:00 | CL | Futures | 60.81 | 60.87 | 60.75 | 60.82 | 214.0 |
| 2024-01-14 20:00:00 | CL | Futures | 60.83 | 60.95 | 60.57 | 60.73 | 807.0 |
| 2024-01-14 20:30:00 | CL | Futures | 60.72 | 60.83 | 60.58 | 60.77 | 360.0 |
| 2024-01-14 21:00:00 | CL | Futures | 60.78 | 60.95 | 60.77 | 60.92 | 247.0 |
| 2024-01-14 21:30:00 | CL | Futures | 60.93 | 61.06 | 60.93 | 61.04 | 317.0 |
| 2024-01-14 22:00:00 | CL | Futures | 61.03 | 61.09 | 60.99 | 61.07 | 176.0 |
| 2024-01-14 22:30:00 | CL | Futures | 61.07 | 61.08 | 60.94 | 60.95 | 142.0 |
| 2024-01-14 23:00:00 | CL | Futures | 60.94 | 60.96 | 60.92 | 60.95 | 117.0 |
| 2024-01-14 23:30:00 | CL | Futures | 60.96 | 61.0 | 60.93 | 60.98 | 60.0 |
| 2024-01-14 18:00:00 | GC | Futures | 2271.7 | 2271.7 | 2268.8 | 2268.8 | 1333.0 |
| 2024-01-14 18:30:00 | GC | Futures | 2268.8 | 2270.7 | 2268.3 | 2269.4 | 1174.0 |
> showing 50 of 759 rows — these rows as CSV