PREVIEW / futures_30min / 2025-11-18
file: by_date/futures_30min/2025/2025-11-18.parquet size: 110 KB rows: 4,042
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-11-18 00:00:00 | ES | Futures | 6711.45 | 6717.75 | 6703.14 | 6709.44 | 10300.0 |
| 2025-11-18 00:30:00 | ES | Futures | 6709.44 | 6715.73 | 6705.91 | 6706.16 | 5940.0 |
| 2025-11-18 01:00:00 | ES | Futures | 6706.42 | 6713.72 | 6703.64 | 6709.94 | 7033.0 |
| 2025-11-18 01:30:00 | ES | Futures | 6709.44 | 6709.44 | 6692.81 | 6696.34 | 10431.0 |
| 2025-11-18 02:00:00 | ES | Futures | 6696.59 | 6701.88 | 6685.26 | 6699.87 | 11960.0 |
| 2025-11-18 02:30:00 | ES | Futures | 6699.61 | 6712.71 | 6698.86 | 6704.9 | 9959.0 |
| 2025-11-18 03:00:00 | ES | Futures | 6705.16 | 6721.02 | 6704.15 | 6715.73 | 15756.0 |
| 2025-11-18 03:30:00 | ES | Futures | 6715.73 | 6735.88 | 6714.22 | 6724.3 | 14037.0 |
| 2025-11-18 04:00:00 | ES | Futures | 6724.3 | 6734.63 | 6719.51 | 6723.79 | 8781.0 |
| 2025-11-18 04:30:00 | ES | Futures | 6723.54 | 6732.86 | 6717.5 | 6730.85 | 7747.0 |
| 2025-11-18 05:00:00 | ES | Futures | 6730.6 | 6732.36 | 6721.02 | 6722.54 | 5074.0 |
| 2025-11-18 05:30:00 | ES | Futures | 6722.79 | 6732.11 | 6720.52 | 6730.34 | 5080.0 |
| 2025-11-18 06:00:00 | ES | Futures | 6729.84 | 6731.85 | 6719.01 | 6723.29 | 7184.0 |
| 2025-11-18 06:30:00 | ES | Futures | 6723.54 | 6725.31 | 6715.23 | 6725.05 | 7820.0 |
| 2025-11-18 07:00:00 | ES | Futures | 6724.8 | 6725.05 | 6703.64 | 6707.67 | 12773.0 |
| 2025-11-18 07:30:00 | ES | Futures | 6707.93 | 6716.24 | 6693.07 | 6700.37 | 16718.0 |
| 2025-11-18 08:00:00 | ES | Futures | 6700.62 | 6715.23 | 6700.37 | 6707.17 | 15730.0 |
| 2025-11-18 08:30:00 | ES | Futures | 6707.17 | 6718.0 | 6705.66 | 6711.7 | 19973.0 |
| 2025-11-18 09:00:00 | ES | Futures | 6711.45 | 6716.24 | 6702.13 | 6706.92 | 27405.0 |
| 2025-11-18 09:30:00 | ES | Futures | 6706.67 | 6729.08 | 6671.15 | 6671.66 | 257816.0 |
| 2025-11-18 10:00:00 | ES | Futures | 6671.66 | 6688.53 | 6652.77 | 6676.19 | 275564.0 |
| 2025-11-18 10:30:00 | ES | Futures | 6676.19 | 6687.52 | 6656.29 | 6657.05 | 191885.0 |
| 2025-11-18 11:00:00 | ES | Futures | 6657.05 | 6704.4 | 6643.45 | 6701.38 | 187472.0 |
| 2025-11-18 11:30:00 | ES | Futures | 6701.63 | 6709.69 | 6692.56 | 6697.1 | 137739.0 |
| 2025-11-18 12:00:00 | ES | Futures | 6697.1 | 6704.4 | 6670.65 | 6671.4 | 99117.0 |
| 2025-11-18 12:30:00 | ES | Futures | 6671.4 | 6729.84 | 6664.35 | 6722.79 | 154635.0 |
| 2025-11-18 13:00:00 | ES | Futures | 6723.04 | 6730.6 | 6716.74 | 6719.26 | 101372.0 |
| 2025-11-18 13:30:00 | ES | Futures | 6719.26 | 6737.65 | 6712.96 | 6716.24 | 111267.0 |
| 2025-11-18 14:00:00 | ES | Futures | 6716.24 | 6728.58 | 6711.45 | 6715.23 | 93286.0 |
| 2025-11-18 14:30:00 | ES | Futures | 6715.23 | 6735.63 | 6710.19 | 6730.09 | 114557.0 |
| 2025-11-18 15:00:00 | ES | Futures | 6730.09 | 6735.63 | 6700.62 | 6710.19 | 115247.0 |
| 2025-11-18 15:30:00 | ES | Futures | 6709.94 | 6713.72 | 6686.27 | 6687.52 | 207109.0 |
| 2025-11-18 16:00:00 | ES | Futures | 6687.27 | 6688.28 | 6674.43 | 6680.47 | 67970.0 |
| 2025-11-18 16:30:00 | ES | Futures | 6680.22 | 6683.49 | 6675.18 | 6677.45 | 11033.0 |
| 2025-11-18 18:00:00 | ES | Futures | 6680.47 | 6696.84 | 6679.21 | 6695.33 | 7443.0 |
| 2025-11-18 18:30:00 | ES | Futures | 6695.58 | 6697.35 | 6689.04 | 6691.55 | 4782.0 |
| 2025-11-18 19:00:00 | ES | Futures | 6691.55 | 6693.57 | 6672.16 | 6675.94 | 9372.0 |
| 2025-11-18 19:30:00 | ES | Futures | 6676.19 | 6688.78 | 6674.18 | 6685.51 | 6647.0 |
| 2025-11-18 20:00:00 | ES | Futures | 6685.51 | 6697.35 | 6677.2 | 6691.55 | 8858.0 |
| 2025-11-18 20:30:00 | ES | Futures | 6691.81 | 6694.33 | 6678.71 | 6683.49 | 6740.0 |
| 2025-11-18 21:00:00 | ES | Futures | 6683.75 | 6698.36 | 6683.75 | 6696.59 | 6693.0 |
| 2025-11-18 21:30:00 | ES | Futures | 6696.84 | 6702.13 | 6696.59 | 6700.37 | 5100.0 |
| 2025-11-18 22:00:00 | ES | Futures | 6700.62 | 6702.39 | 6686.77 | 6691.05 | 4867.0 |
| 2025-11-18 22:30:00 | ES | Futures | 6690.8 | 6691.05 | 6679.46 | 6680.47 | 4449.0 |
| 2025-11-18 23:00:00 | ES | Futures | 6680.47 | 6681.98 | 6671.15 | 6680.47 | 5840.0 |
| 2025-11-18 23:30:00 | ES | Futures | 6680.47 | 6684.25 | 6671.91 | 6676.69 | 5007.0 |
| 2025-11-18 00:00:00 | NQ | Futures | 24947.93 | 24983.99 | 24906.07 | 24943.14 | 5459.0 |
| 2025-11-18 00:30:00 | NQ | Futures | 24945.15 | 24971.38 | 24923.21 | 24925.48 | 3031.0 |
| 2025-11-18 01:00:00 | NQ | Futures | 24926.24 | 24963.82 | 24912.62 | 24936.83 | 3447.0 |
| 2025-11-18 01:30:00 | NQ | Futures | 24936.33 | 24936.33 | 24855.63 | 24875.8 | 5583.0 |
> showing 50 of 4,042 rows — these rows as CSV