PREVIEW / futures_30min / 2025-06-19
file: by_date/futures_30min/2025/2025-06-19.parquet size: 89 KB rows: 3,139
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-06-19 00:00:00 | ES | Futures | 6069.93 | 6072.45 | 6068.16 | 6068.42 | 1268.0 |
| 2025-06-19 00:30:00 | ES | Futures | 6068.42 | 6073.96 | 6067.91 | 6073.2 | 1309.0 |
| 2025-06-19 01:00:00 | ES | Futures | 6072.95 | 6072.95 | 6067.16 | 6067.66 | 1240.0 |
| 2025-06-19 01:30:00 | ES | Futures | 6067.91 | 6068.42 | 6060.1 | 6061.11 | 2128.0 |
| 2025-06-19 02:00:00 | ES | Futures | 6060.86 | 6065.14 | 6057.59 | 6060.61 | 3918.0 |
| 2025-06-19 02:30:00 | ES | Futures | 6060.36 | 6061.36 | 6053.56 | 6061.11 | 5209.0 |
| 2025-06-19 03:00:00 | ES | Futures | 6061.36 | 6064.39 | 6047.26 | 6052.3 | 5945.0 |
| 2025-06-19 03:30:00 | ES | Futures | 6052.3 | 6054.82 | 6040.71 | 6043.73 | 6035.0 |
| 2025-06-19 04:00:00 | ES | Futures | 6044.24 | 6055.82 | 6043.98 | 6052.04 | 6073.0 |
| 2025-06-19 04:30:00 | ES | Futures | 6052.04 | 6054.56 | 6049.27 | 6053.81 | 2978.0 |
| 2025-06-19 05:00:00 | ES | Futures | 6053.56 | 6059.1 | 6053.05 | 6057.08 | 3724.0 |
| 2025-06-19 05:30:00 | ES | Futures | 6056.83 | 6059.6 | 6053.3 | 6054.56 | 1795.0 |
| 2025-06-19 06:00:00 | ES | Futures | 6054.31 | 6056.83 | 6049.27 | 6051.79 | 2528.0 |
| 2025-06-19 06:30:00 | ES | Futures | 6051.54 | 6060.1 | 6051.54 | 6057.33 | 2727.0 |
| 2025-06-19 07:00:00 | ES | Futures | 6057.33 | 6058.34 | 6043.73 | 6049.78 | 4236.0 |
| 2025-06-19 07:30:00 | ES | Futures | 6049.27 | 6052.04 | 6047.51 | 6049.02 | 2936.0 |
| 2025-06-19 08:00:00 | ES | Futures | 6049.02 | 6053.56 | 6044.24 | 6047.76 | 4385.0 |
| 2025-06-19 08:30:00 | ES | Futures | 6048.01 | 6049.78 | 6034.16 | 6037.69 | 8699.0 |
| 2025-06-19 09:00:00 | ES | Futures | 6037.69 | 6044.49 | 6032.65 | 6043.98 | 6419.0 |
| 2025-06-19 09:30:00 | ES | Futures | 6043.98 | 6044.24 | 6014.26 | 6023.08 | 26177.0 |
| 2025-06-19 10:00:00 | ES | Futures | 6023.08 | 6030.89 | 6020.81 | 6028.37 | 14902.0 |
| 2025-06-19 10:30:00 | ES | Futures | 6028.62 | 6032.9 | 6022.07 | 6030.64 | 16926.0 |
| 2025-06-19 11:00:00 | ES | Futures | 6030.89 | 6034.92 | 6025.85 | 6028.12 | 17422.0 |
| 2025-06-19 11:30:00 | ES | Futures | 6028.12 | 6029.38 | 6017.79 | 6019.05 | 21341.0 |
| 2025-06-19 12:00:00 | ES | Futures | 6018.8 | 6031.64 | 6018.8 | 6030.89 | 6667.0 |
| 2025-06-19 12:30:00 | ES | Futures | 6030.89 | 6031.64 | 6019.8 | 6023.08 | 6954.0 |
| 2025-06-19 18:00:00 | ES | Futures | 6038.95 | 6056.83 | 6036.43 | 6055.07 | 9910.0 |
| 2025-06-19 18:30:00 | ES | Futures | 6054.82 | 6070.68 | 6053.05 | 6064.39 | 8585.0 |
| 2025-06-19 19:00:00 | ES | Futures | 6064.39 | 6067.16 | 6059.35 | 6060.36 | 3690.0 |
| 2025-06-19 19:30:00 | ES | Futures | 6060.61 | 6065.14 | 6059.35 | 6062.37 | 2054.0 |
| 2025-06-19 20:00:00 | ES | Futures | 6062.12 | 6074.21 | 6061.11 | 6067.91 | 5231.0 |
| 2025-06-19 20:30:00 | ES | Futures | 6067.91 | 6068.67 | 6062.12 | 6063.88 | 3576.0 |
| 2025-06-19 21:00:00 | ES | Futures | 6064.13 | 6065.9 | 6051.79 | 6057.08 | 5558.0 |
| 2025-06-19 21:30:00 | ES | Futures | 6057.08 | 6060.1 | 6052.55 | 6058.34 | 3167.0 |
| 2025-06-19 22:00:00 | ES | Futures | 6058.59 | 6062.62 | 6056.58 | 6061.36 | 1897.0 |
| 2025-06-19 22:30:00 | ES | Futures | 6061.36 | 6064.89 | 6061.11 | 6062.37 | 1429.0 |
| 2025-06-19 23:00:00 | ES | Futures | 6062.37 | 6067.41 | 6060.36 | 6066.4 | 1950.0 |
| 2025-06-19 23:30:00 | ES | Futures | 6066.65 | 6069.42 | 6065.14 | 6066.15 | 1877.0 |
| 2025-06-19 00:00:00 | NQ | Futures | 22073.34 | 22084.94 | 22067.54 | 22068.8 | 905.0 |
| 2025-06-19 00:30:00 | NQ | Futures | 22069.56 | 22094.27 | 22066.03 | 22088.98 | 1160.0 |
| 2025-06-19 01:00:00 | NQ | Futures | 22087.97 | 22089.23 | 22065.52 | 22067.04 | 891.0 |
| 2025-06-19 01:30:00 | NQ | Futures | 22067.79 | 22070.57 | 22038.04 | 22042.58 | 1391.0 |
| 2025-06-19 02:00:00 | NQ | Futures | 22041.57 | 22065.27 | 22030.47 | 22038.79 | 2712.0 |
| 2025-06-19 02:30:00 | NQ | Futures | 22037.53 | 22042.58 | 22007.27 | 22042.07 | 3300.0 |
| 2025-06-19 03:00:00 | NQ | Futures | 22042.07 | 22061.74 | 21997.69 | 22018.87 | 3259.0 |
| 2025-06-19 03:30:00 | NQ | Futures | 22020.64 | 22029.21 | 21972.47 | 21984.57 | 2534.0 |
| 2025-06-19 04:00:00 | NQ | Futures | 21985.84 | 22030.22 | 21985.84 | 22012.06 | 2238.0 |
| 2025-06-19 04:30:00 | NQ | Futures | 22013.32 | 22022.65 | 21999.45 | 22016.35 | 1029.0 |
| 2025-06-19 05:00:00 | NQ | Futures | 22016.1 | 22039.55 | 22013.83 | 22030.22 | 1061.0 |
| 2025-06-19 05:30:00 | NQ | Futures | 22030.98 | 22041.06 | 22015.59 | 22021.9 | 970.0 |
> showing 50 of 3,139 rows — these rows as CSV