PREVIEW / futures_30min / 2024-11-17
file: by_date/futures_30min/2024/2024-11-17.parquet size: 31 KB rows: 878
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-11-17 18:00:00 | ES | Futures | 6124.49 | 6129.16 | 6116.19 | 6127.87 | 12674.0 |
| 2024-11-17 18:30:00 | ES | Futures | 6127.87 | 6129.42 | 6125.79 | 6129.16 | 3864.0 |
| 2024-11-17 19:00:00 | ES | Futures | 6129.42 | 6136.43 | 6127.87 | 6134.87 | 8453.0 |
| 2024-11-17 19:30:00 | ES | Futures | 6134.61 | 6139.8 | 6132.54 | 6139.03 | 7336.0 |
| 2024-11-17 20:00:00 | ES | Futures | 6138.77 | 6139.55 | 6136.17 | 6138.51 | 5151.0 |
| 2024-11-17 20:30:00 | ES | Futures | 6138.51 | 6139.29 | 6135.65 | 6137.21 | 3335.0 |
| 2024-11-17 21:00:00 | ES | Futures | 6137.21 | 6138.51 | 6133.84 | 6136.43 | 4939.0 |
| 2024-11-17 21:30:00 | ES | Futures | 6136.43 | 6137.73 | 6135.13 | 6137.21 | 1878.0 |
| 2024-11-17 22:00:00 | ES | Futures | 6137.21 | 6138.51 | 6135.13 | 6135.65 | 2349.0 |
| 2024-11-17 22:30:00 | ES | Futures | 6135.65 | 6137.47 | 6134.87 | 6136.43 | 2821.0 |
| 2024-11-17 23:00:00 | ES | Futures | 6136.43 | 6138.25 | 6136.17 | 6137.47 | 2060.0 |
| 2024-11-17 23:30:00 | ES | Futures | 6137.47 | 6140.84 | 6137.21 | 6139.29 | 4813.0 |
| 2024-11-17 18:00:00 | NQ | Futures | 21398.98 | 21448.82 | 21369.76 | 21447.78 | 6539.0 |
| 2024-11-17 18:30:00 | NQ | Futures | 21446.99 | 21466.56 | 21441.51 | 21466.04 | 2642.0 |
| 2024-11-17 19:00:00 | NQ | Futures | 21465.26 | 21504.39 | 21458.47 | 21501.26 | 4544.0 |
| 2024-11-17 19:30:00 | NQ | Futures | 21500.22 | 21530.22 | 21487.43 | 21528.4 | 3991.0 |
| 2024-11-17 20:00:00 | NQ | Futures | 21528.4 | 21530.48 | 21508.05 | 21526.05 | 3563.0 |
| 2024-11-17 20:30:00 | NQ | Futures | 21526.57 | 21531.01 | 21502.83 | 21509.09 | 3059.0 |
| 2024-11-17 21:00:00 | NQ | Futures | 21508.57 | 21525.79 | 21492.13 | 21516.66 | 3302.0 |
| 2024-11-17 21:30:00 | NQ | Futures | 21517.18 | 21528.66 | 21510.92 | 21528.4 | 1539.0 |
| 2024-11-17 22:00:00 | NQ | Futures | 21528.92 | 21541.96 | 21520.57 | 21522.92 | 2474.0 |
| 2024-11-17 22:30:00 | NQ | Futures | 21522.66 | 21533.35 | 21519.27 | 21529.96 | 1512.0 |
| 2024-11-17 23:00:00 | NQ | Futures | 21530.75 | 21544.83 | 21530.22 | 21538.31 | 1786.0 |
| 2024-11-17 23:30:00 | NQ | Futures | 21538.31 | 21558.66 | 21536.75 | 21550.31 | 2088.0 |
| 2024-11-17 18:00:00 | YM | Futures | 45357.0 | 45362.2 | 45287.3 | 45326.8 | 1855.0 |
| 2024-11-17 18:30:00 | YM | Futures | 45326.8 | 45335.2 | 45317.5 | 45332.0 | 382.0 |
| 2024-11-17 19:00:00 | YM | Futures | 45333.1 | 45375.8 | 45325.8 | 45364.3 | 697.0 |
| 2024-11-17 19:30:00 | YM | Futures | 45365.4 | 45389.3 | 45349.7 | 45384.1 | 556.0 |
| 2024-11-17 20:00:00 | YM | Futures | 45385.1 | 45398.7 | 45376.8 | 45385.1 | 489.0 |
| 2024-11-17 20:30:00 | YM | Futures | 45384.1 | 45391.4 | 45372.6 | 45383.0 | 299.0 |
| 2024-11-17 21:00:00 | YM | Futures | 45381.0 | 45381.0 | 45360.1 | 45361.2 | 375.0 |
| 2024-11-17 21:30:00 | YM | Futures | 45360.1 | 45364.3 | 45348.7 | 45351.8 | 253.0 |
| 2024-11-17 22:00:00 | YM | Futures | 45352.9 | 45354.9 | 45327.9 | 45330.0 | 292.0 |
| 2024-11-17 22:30:00 | YM | Futures | 45328.9 | 45336.2 | 45319.6 | 45323.7 | 293.0 |
| 2024-11-17 23:00:00 | YM | Futures | 45324.8 | 45336.2 | 45323.7 | 45334.1 | 251.0 |
| 2024-11-17 23:30:00 | YM | Futures | 45335.2 | 45359.1 | 45328.9 | 45345.6 | 511.0 |
| 2024-11-17 18:00:00 | CL | Futures | 60.57 | 60.66 | 60.35 | 60.52 | 2784.0 |
| 2024-11-17 18:30:00 | CL | Futures | 60.53 | 60.55 | 60.48 | 60.53 | 581.0 |
| 2024-11-17 19:00:00 | CL | Futures | 60.54 | 60.62 | 60.52 | 60.54 | 949.0 |
| 2024-11-17 19:30:00 | CL | Futures | 60.55 | 60.85 | 60.53 | 60.83 | 700.0 |
| 2024-11-17 20:00:00 | CL | Futures | 60.82 | 60.86 | 60.61 | 60.85 | 1552.0 |
| 2024-11-17 20:30:00 | CL | Futures | 60.86 | 60.86 | 60.73 | 60.79 | 745.0 |
| 2024-11-17 21:00:00 | CL | Futures | 60.79 | 60.89 | 60.72 | 60.85 | 876.0 |
| 2024-11-17 21:30:00 | CL | Futures | 60.87 | 60.89 | 60.79 | 60.85 | 525.0 |
| 2024-11-17 22:00:00 | CL | Futures | 60.85 | 61.03 | 60.85 | 60.97 | 1219.0 |
| 2024-11-17 22:30:00 | CL | Futures | 60.96 | 61.01 | 60.93 | 60.99 | 438.0 |
| 2024-11-17 23:00:00 | CL | Futures | 60.99 | 61.01 | 60.91 | 60.92 | 427.0 |
| 2024-11-17 23:30:00 | CL | Futures | 60.93 | 60.95 | 60.92 | 60.93 | 279.0 |
| 2024-11-17 18:00:00 | GC | Futures | 2707.7 | 2716.7 | 2704.5 | 2715.0 | 3454.0 |
| 2024-11-17 18:30:00 | GC | Futures | 2714.9 | 2716.1 | 2711.2 | 2712.3 | 1813.0 |
> showing 50 of 878 rows — these rows as CSV