PREVIEW / futures_30min / 2025-07-17
file: by_date/futures_30min/2025/2025-07-17.parquet size: 107 KB rows: 3,867
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 |
|---|---|---|---|---|---|---|---|
| 2025-07-17 00:00:00 | ES | Futures | 6339.94 | 6340.69 | 6338.93 | 6339.43 | 961.0 |
| 2025-07-17 00:30:00 | ES | Futures | 6339.18 | 6340.95 | 6337.92 | 6340.19 | 1075.0 |
| 2025-07-17 01:00:00 | ES | Futures | 6340.44 | 6343.46 | 6340.19 | 6342.71 | 1829.0 |
| 2025-07-17 01:30:00 | ES | Futures | 6342.71 | 6351.27 | 6342.71 | 6348.25 | 5216.0 |
| 2025-07-17 02:00:00 | ES | Futures | 6348.25 | 6358.58 | 6348.25 | 6358.32 | 5914.0 |
| 2025-07-17 02:30:00 | ES | Futures | 6358.07 | 6358.83 | 6354.8 | 6355.55 | 2706.0 |
| 2025-07-17 03:00:00 | ES | Futures | 6355.81 | 6356.81 | 6349.51 | 6351.78 | 5216.0 |
| 2025-07-17 03:30:00 | ES | Futures | 6351.78 | 6356.81 | 6351.27 | 6351.52 | 3824.0 |
| 2025-07-17 04:00:00 | ES | Futures | 6351.27 | 6354.29 | 6349.01 | 6351.78 | 4585.0 |
| 2025-07-17 04:30:00 | ES | Futures | 6351.78 | 6355.05 | 6349.76 | 6353.29 | 3241.0 |
| 2025-07-17 05:00:00 | ES | Futures | 6353.29 | 6358.32 | 6353.29 | 6356.31 | 3065.0 |
| 2025-07-17 05:30:00 | ES | Futures | 6356.56 | 6358.32 | 6353.79 | 6354.29 | 2351.0 |
| 2025-07-17 06:00:00 | ES | Futures | 6354.29 | 6355.81 | 6352.03 | 6354.29 | 2434.0 |
| 2025-07-17 06:30:00 | ES | Futures | 6354.29 | 6355.05 | 6349.51 | 6350.26 | 3865.0 |
| 2025-07-17 07:00:00 | ES | Futures | 6350.26 | 6351.02 | 6346.49 | 6349.51 | 5803.0 |
| 2025-07-17 07:30:00 | ES | Futures | 6349.51 | 6350.01 | 6344.22 | 6346.23 | 5674.0 |
| 2025-07-17 08:00:00 | ES | Futures | 6346.23 | 6350.52 | 6344.72 | 6348.5 | 6027.0 |
| 2025-07-17 08:30:00 | ES | Futures | 6349.26 | 6362.35 | 6345.48 | 6361.6 | 24383.0 |
| 2025-07-17 09:00:00 | ES | Futures | 6361.35 | 6364.12 | 6351.78 | 6351.78 | 20746.0 |
| 2025-07-17 09:30:00 | ES | Futures | 6351.78 | 6370.16 | 6349.26 | 6366.13 | 112997.0 |
| 2025-07-17 10:00:00 | ES | Futures | 6365.88 | 6370.67 | 6356.06 | 6362.35 | 91638.0 |
| 2025-07-17 10:30:00 | ES | Futures | 6362.35 | 6367.14 | 6357.82 | 6366.38 | 57776.0 |
| 2025-07-17 11:00:00 | ES | Futures | 6366.38 | 6375.7 | 6365.88 | 6374.95 | 53430.0 |
| 2025-07-17 11:30:00 | ES | Futures | 6375.2 | 6381.25 | 6373.94 | 6380.74 | 51014.0 |
| 2025-07-17 12:00:00 | ES | Futures | 6380.74 | 6384.02 | 6376.46 | 6376.96 | 48047.0 |
| 2025-07-17 12:30:00 | ES | Futures | 6376.96 | 6377.97 | 6373.44 | 6376.96 | 33324.0 |
| 2025-07-17 13:00:00 | ES | Futures | 6376.96 | 6379.48 | 6374.95 | 6378.98 | 37638.0 |
| 2025-07-17 13:30:00 | ES | Futures | 6378.98 | 6383.26 | 6378.22 | 6383.01 | 26275.0 |
| 2025-07-17 14:00:00 | ES | Futures | 6383.01 | 6387.54 | 6379.73 | 6387.04 | 40041.0 |
| 2025-07-17 14:30:00 | ES | Futures | 6387.29 | 6390.31 | 6384.77 | 6388.3 | 33307.0 |
| 2025-07-17 15:00:00 | ES | Futures | 6388.55 | 6393.08 | 6388.05 | 6388.55 | 41927.0 |
| 2025-07-17 15:30:00 | ES | Futures | 6388.3 | 6392.58 | 6385.02 | 6389.81 | 176138.0 |
| 2025-07-17 16:00:00 | ES | Futures | 6389.81 | 6392.08 | 6386.03 | 6390.82 | 36501.0 |
| 2025-07-17 16:30:00 | ES | Futures | 6390.82 | 6392.83 | 6388.8 | 6389.81 | 7891.0 |
| 2025-07-17 18:00:00 | ES | Futures | 6390.06 | 6391.32 | 6386.03 | 6390.82 | 2721.0 |
| 2025-07-17 18:30:00 | ES | Futures | 6390.82 | 6391.07 | 6388.3 | 6389.81 | 1176.0 |
| 2025-07-17 19:00:00 | ES | Futures | 6390.06 | 6396.36 | 6389.56 | 6393.08 | 2959.0 |
| 2025-07-17 19:30:00 | ES | Futures | 6393.34 | 6398.37 | 6392.33 | 6396.86 | 2500.0 |
| 2025-07-17 20:00:00 | ES | Futures | 6396.86 | 6398.12 | 6395.35 | 6396.11 | 2673.0 |
| 2025-07-17 20:30:00 | ES | Futures | 6396.11 | 6396.36 | 6393.84 | 6394.59 | 1776.0 |
| 2025-07-17 21:00:00 | ES | Futures | 6394.59 | 6396.11 | 6393.59 | 6393.84 | 1803.0 |
| 2025-07-17 21:30:00 | ES | Futures | 6394.09 | 6395.35 | 6393.08 | 6394.09 | 1530.0 |
| 2025-07-17 22:00:00 | ES | Futures | 6393.84 | 6395.1 | 6392.33 | 6394.34 | 1153.0 |
| 2025-07-17 22:30:00 | ES | Futures | 6394.59 | 6399.38 | 6394.34 | 6397.87 | 2151.0 |
| 2025-07-17 23:00:00 | ES | Futures | 6397.87 | 6399.38 | 6397.37 | 6399.38 | 1938.0 |
| 2025-07-17 23:30:00 | ES | Futures | 6399.13 | 6400.39 | 6396.61 | 6397.62 | 2103.0 |
| 2025-07-17 00:00:00 | NQ | Futures | 23239.66 | 23243.44 | 23233.1 | 23234.11 | 723.0 |
| 2025-07-17 00:30:00 | NQ | Futures | 23234.37 | 23243.95 | 23227.56 | 23241.93 | 1063.0 |
| 2025-07-17 01:00:00 | NQ | Futures | 23241.68 | 23256.56 | 23239.91 | 23255.04 | 1446.0 |
| 2025-07-17 01:30:00 | NQ | Futures | 23255.3 | 23301.19 | 23254.54 | 23288.33 | 4478.0 |
> showing 50 of 3,867 rows — these rows as CSV