PREVIEW / futures_30min / 2025-07-02
file: by_date/futures_30min/2025/2025-07-02.parquet size: 109 KB rows: 3,897
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-02 00:00:00 | ES | Futures | 6306.19 | 6313.49 | 6305.68 | 6312.74 | 2626.0 |
| 2025-07-02 00:30:00 | ES | Futures | 6312.74 | 6314.75 | 6311.73 | 6312.48 | 2470.0 |
| 2025-07-02 01:00:00 | ES | Futures | 6312.23 | 6312.23 | 6307.45 | 6307.7 | 1827.0 |
| 2025-07-02 01:30:00 | ES | Futures | 6307.95 | 6311.73 | 6307.19 | 6311.48 | 2067.0 |
| 2025-07-02 02:00:00 | ES | Futures | 6311.48 | 6314.75 | 6310.47 | 6312.74 | 3880.0 |
| 2025-07-02 02:30:00 | ES | Futures | 6312.74 | 6317.77 | 6312.23 | 6316.51 | 4255.0 |
| 2025-07-02 03:00:00 | ES | Futures | 6316.51 | 6317.27 | 6308.71 | 6308.71 | 5428.0 |
| 2025-07-02 03:30:00 | ES | Futures | 6308.96 | 6311.48 | 6302.41 | 6304.17 | 5097.0 |
| 2025-07-02 04:00:00 | ES | Futures | 6304.42 | 6307.19 | 6300.39 | 6302.41 | 5875.0 |
| 2025-07-02 04:30:00 | ES | Futures | 6302.41 | 6303.92 | 6299.13 | 6301.9 | 4562.0 |
| 2025-07-02 05:00:00 | ES | Futures | 6301.65 | 6303.92 | 6299.89 | 6303.67 | 3052.0 |
| 2025-07-02 05:30:00 | ES | Futures | 6303.42 | 6304.17 | 6300.39 | 6303.92 | 3420.0 |
| 2025-07-02 06:00:00 | ES | Futures | 6303.92 | 6304.17 | 6301.15 | 6301.65 | 2982.0 |
| 2025-07-02 06:30:00 | ES | Futures | 6301.4 | 6303.42 | 6298.88 | 6301.9 | 5730.0 |
| 2025-07-02 07:00:00 | ES | Futures | 6301.65 | 6304.17 | 6300.39 | 6304.17 | 4027.0 |
| 2025-07-02 07:30:00 | ES | Futures | 6303.92 | 6305.43 | 6292.59 | 6296.36 | 11660.0 |
| 2025-07-02 08:00:00 | ES | Futures | 6296.62 | 6300.39 | 6288.81 | 6293.34 | 19921.0 |
| 2025-07-02 08:30:00 | ES | Futures | 6293.34 | 6294.6 | 6282.26 | 6286.79 | 22530.0 |
| 2025-07-02 09:00:00 | ES | Futures | 6286.79 | 6293.09 | 6284.02 | 6291.83 | 23696.0 |
| 2025-07-02 09:30:00 | ES | Futures | 6291.83 | 6295.36 | 6285.03 | 6291.83 | 99571.0 |
| 2025-07-02 10:00:00 | ES | Futures | 6292.08 | 6306.44 | 6291.58 | 6304.93 | 82159.0 |
| 2025-07-02 10:30:00 | ES | Futures | 6304.93 | 6310.97 | 6300.9 | 6306.44 | 100010.0 |
| 2025-07-02 11:00:00 | ES | Futures | 6306.69 | 6310.22 | 6304.42 | 6306.69 | 60730.0 |
| 2025-07-02 11:30:00 | ES | Futures | 6306.69 | 6313.74 | 6306.19 | 6311.73 | 45815.0 |
| 2025-07-02 12:00:00 | ES | Futures | 6311.73 | 6312.23 | 6307.45 | 6310.47 | 41602.0 |
| 2025-07-02 12:30:00 | ES | Futures | 6310.22 | 6315.25 | 6308.71 | 6315.0 | 33258.0 |
| 2025-07-02 13:00:00 | ES | Futures | 6315.0 | 6315.76 | 6309.96 | 6313.49 | 35106.0 |
| 2025-07-02 13:30:00 | ES | Futures | 6313.49 | 6316.26 | 6311.48 | 6312.99 | 33806.0 |
| 2025-07-02 14:00:00 | ES | Futures | 6313.24 | 6316.01 | 6310.97 | 6314.75 | 34498.0 |
| 2025-07-02 14:30:00 | ES | Futures | 6314.75 | 6318.53 | 6314.75 | 6317.52 | 35699.0 |
| 2025-07-02 15:00:00 | ES | Futures | 6317.52 | 6320.8 | 6316.01 | 6316.51 | 34799.0 |
| 2025-07-02 15:30:00 | ES | Futures | 6316.51 | 6323.57 | 6315.0 | 6322.31 | 133904.0 |
| 2025-07-02 16:00:00 | ES | Futures | 6322.31 | 6323.06 | 6318.02 | 6319.28 | 44102.0 |
| 2025-07-02 16:30:00 | ES | Futures | 6319.28 | 6326.59 | 6319.28 | 6324.07 | 11710.0 |
| 2025-07-02 18:00:00 | ES | Futures | 6323.57 | 6325.83 | 6320.04 | 6321.05 | 2175.0 |
| 2025-07-02 18:30:00 | ES | Futures | 6321.05 | 6324.32 | 6320.54 | 6323.82 | 890.0 |
| 2025-07-02 19:00:00 | ES | Futures | 6323.82 | 6324.83 | 6323.06 | 6324.07 | 580.0 |
| 2025-07-02 19:30:00 | ES | Futures | 6324.32 | 6325.33 | 6323.57 | 6324.57 | 884.0 |
| 2025-07-02 20:00:00 | ES | Futures | 6324.57 | 6326.84 | 6322.56 | 6323.57 | 2042.0 |
| 2025-07-02 20:30:00 | ES | Futures | 6323.57 | 6325.58 | 6322.81 | 6324.57 | 1277.0 |
| 2025-07-02 21:00:00 | ES | Futures | 6324.32 | 6326.84 | 6321.8 | 6325.58 | 2001.0 |
| 2025-07-02 21:30:00 | ES | Futures | 6325.58 | 6325.58 | 6323.06 | 6323.57 | 1503.0 |
| 2025-07-02 22:00:00 | ES | Futures | 6323.57 | 6323.57 | 6319.54 | 6319.79 | 2106.0 |
| 2025-07-02 22:30:00 | ES | Futures | 6319.54 | 6322.81 | 6317.52 | 6322.05 | 2624.0 |
| 2025-07-02 23:00:00 | ES | Futures | 6322.05 | 6329.86 | 6321.8 | 6328.35 | 3053.0 |
| 2025-07-02 23:30:00 | ES | Futures | 6328.35 | 6331.12 | 6326.08 | 6326.08 | 2145.0 |
| 2025-07-02 00:00:00 | NQ | Futures | 22937.55 | 22973.36 | 22934.78 | 22968.57 | 2132.0 |
| 2025-07-02 00:30:00 | NQ | Futures | 22968.82 | 22979.67 | 22964.79 | 22970.59 | 1536.0 |
| 2025-07-02 01:00:00 | NQ | Futures | 22970.34 | 22970.84 | 22946.63 | 22948.65 | 1665.0 |
| 2025-07-02 01:30:00 | NQ | Futures | 22948.65 | 22967.56 | 22944.36 | 22967.56 | 1563.0 |
> showing 50 of 3,897 rows — these rows as CSV