PREVIEW / futures_30min / 2024-10-20
file: by_date/futures_30min/2024/2024-10-20.parquet size: 29 KB rows: 819
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-10-20 18:00:00 | ES | Futures | 6136.69 | 6139.29 | 6135.91 | 6137.73 | 2831.0 |
| 2024-10-20 18:30:00 | ES | Futures | 6137.99 | 6140.06 | 6137.21 | 6139.03 | 1276.0 |
| 2024-10-20 19:00:00 | ES | Futures | 6139.03 | 6140.84 | 6138.77 | 6139.8 | 1077.0 |
| 2024-10-20 19:30:00 | ES | Futures | 6139.8 | 6140.06 | 6136.95 | 6138.77 | 1534.0 |
| 2024-10-20 20:00:00 | ES | Futures | 6139.03 | 6139.03 | 6135.91 | 6136.69 | 1849.0 |
| 2024-10-20 20:30:00 | ES | Futures | 6136.43 | 6139.29 | 6136.43 | 6137.99 | 1383.0 |
| 2024-10-20 21:00:00 | ES | Futures | 6137.99 | 6139.03 | 6136.95 | 6138.25 | 1346.0 |
| 2024-10-20 21:30:00 | ES | Futures | 6137.99 | 6140.06 | 6136.95 | 6137.21 | 1923.0 |
| 2024-10-20 22:00:00 | ES | Futures | 6137.21 | 6137.73 | 6134.87 | 6136.95 | 1982.0 |
| 2024-10-20 22:30:00 | ES | Futures | 6136.95 | 6136.95 | 6133.84 | 6134.61 | 1165.0 |
| 2024-10-20 23:00:00 | ES | Futures | 6134.61 | 6135.39 | 6133.32 | 6134.61 | 1293.0 |
| 2024-10-20 23:30:00 | ES | Futures | 6134.61 | 6135.65 | 6132.54 | 6133.32 | 1372.0 |
| 2024-10-20 18:00:00 | NQ | Futures | 21390.9 | 21413.6 | 21390.64 | 21407.59 | 2201.0 |
| 2024-10-20 18:30:00 | NQ | Futures | 21407.07 | 21419.6 | 21404.72 | 21412.03 | 1251.0 |
| 2024-10-20 19:00:00 | NQ | Futures | 21411.77 | 21421.95 | 21410.47 | 21415.16 | 1053.0 |
| 2024-10-20 19:30:00 | NQ | Futures | 21415.68 | 21419.6 | 21400.29 | 21409.16 | 1663.0 |
| 2024-10-20 20:00:00 | NQ | Futures | 21409.94 | 21411.77 | 21393.77 | 21399.51 | 1480.0 |
| 2024-10-20 20:30:00 | NQ | Futures | 21399.25 | 21419.34 | 21398.72 | 21405.77 | 1289.0 |
| 2024-10-20 21:00:00 | NQ | Futures | 21405.25 | 21415.68 | 21400.55 | 21410.73 | 942.0 |
| 2024-10-20 21:30:00 | NQ | Futures | 21410.47 | 21415.94 | 21400.55 | 21402.64 | 1446.0 |
| 2024-10-20 22:00:00 | NQ | Futures | 21402.9 | 21406.29 | 21387.5 | 21402.9 | 1506.0 |
| 2024-10-20 22:30:00 | NQ | Futures | 21403.42 | 21403.94 | 21378.89 | 21385.16 | 1572.0 |
| 2024-10-20 23:00:00 | NQ | Futures | 21384.37 | 21391.16 | 21377.59 | 21385.68 | 1230.0 |
| 2024-10-20 23:30:00 | NQ | Futures | 21385.42 | 21395.07 | 21369.5 | 21374.2 | 1546.0 |
| 2024-10-20 18:00:00 | YM | Futures | 45315.4 | 45338.3 | 45306.0 | 45327.9 | 600.0 |
| 2024-10-20 18:30:00 | YM | Futures | 45327.9 | 45341.4 | 45326.8 | 45338.3 | 213.0 |
| 2024-10-20 19:00:00 | YM | Futures | 45338.3 | 45349.7 | 45332.0 | 45346.6 | 327.0 |
| 2024-10-20 19:30:00 | YM | Futures | 45347.7 | 45347.7 | 45334.1 | 45342.5 | 273.0 |
| 2024-10-20 20:00:00 | YM | Futures | 45343.5 | 45348.7 | 45330.0 | 45336.2 | 255.0 |
| 2024-10-20 20:30:00 | YM | Futures | 45335.2 | 45351.8 | 45335.2 | 45346.6 | 263.0 |
| 2024-10-20 21:00:00 | YM | Futures | 45346.6 | 45351.8 | 45343.5 | 45345.6 | 167.0 |
| 2024-10-20 21:30:00 | YM | Futures | 45345.6 | 45353.9 | 45336.2 | 45337.3 | 199.0 |
| 2024-10-20 22:00:00 | YM | Futures | 45339.3 | 45340.4 | 45327.9 | 45333.1 | 187.0 |
| 2024-10-20 22:30:00 | YM | Futures | 45333.1 | 45336.2 | 45325.8 | 45328.9 | 192.0 |
| 2024-10-20 23:00:00 | YM | Futures | 45328.9 | 45331.0 | 45319.6 | 45325.8 | 141.0 |
| 2024-10-20 23:30:00 | YM | Futures | 45323.7 | 45328.9 | 45319.6 | 45321.6 | 167.0 |
| 2024-10-20 18:00:00 | CL | Futures | 62.39 | 62.46 | 62.01 | 62.01 | 2713.0 |
| 2024-10-20 18:30:00 | CL | Futures | 62.01 | 62.19 | 61.96 | 62.18 | 1151.0 |
| 2024-10-20 19:00:00 | CL | Futures | 62.19 | 62.28 | 62.17 | 62.27 | 468.0 |
| 2024-10-20 19:30:00 | CL | Futures | 62.27 | 62.34 | 62.27 | 62.29 | 451.0 |
| 2024-10-20 20:00:00 | CL | Futures | 62.28 | 62.38 | 62.2 | 62.36 | 1078.0 |
| 2024-10-20 20:30:00 | CL | Futures | 62.35 | 62.42 | 62.27 | 62.41 | 761.0 |
| 2024-10-20 21:00:00 | CL | Futures | 62.41 | 62.49 | 62.24 | 62.33 | 1924.0 |
| 2024-10-20 21:30:00 | CL | Futures | 62.33 | 62.36 | 62.04 | 62.05 | 1814.0 |
| 2024-10-20 22:00:00 | CL | Futures | 62.05 | 62.43 | 62.03 | 62.42 | 2121.0 |
| 2024-10-20 22:30:00 | CL | Futures | 62.43 | 62.47 | 62.29 | 62.35 | 1198.0 |
| 2024-10-20 23:00:00 | CL | Futures | 62.33 | 62.51 | 62.31 | 62.5 | 1374.0 |
| 2024-10-20 23:30:00 | CL | Futures | 62.49 | 62.54 | 62.45 | 62.54 | 795.0 |
| 2024-10-20 18:00:00 | GC | Futures | 2881.2 | 2883.3 | 2879.4 | 2882.3 | 1960.0 |
| 2024-10-20 18:30:00 | GC | Futures | 2882.2 | 2884.0 | 2880.8 | 2883.8 | 619.0 |
> showing 50 of 819 rows — these rows as CSV