PREVIEW / futures_30min / 2024-02-27
file: by_date/futures_30min/2024/2024-02-27.parquet size: 103 KB rows: 3,875
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-02-27 00:00:00 | ES | Futures | 5455.61 | 5456.96 | 5454.0 | 5454.27 | 2576.0 |
| 2024-02-27 00:30:00 | ES | Futures | 5454.27 | 5454.81 | 5450.24 | 5452.93 | 2727.0 |
| 2024-02-27 01:00:00 | ES | Futures | 5452.93 | 5453.19 | 5451.58 | 5452.12 | 2239.0 |
| 2024-02-27 01:30:00 | ES | Futures | 5452.12 | 5454.27 | 5451.85 | 5452.93 | 1916.0 |
| 2024-02-27 02:00:00 | ES | Futures | 5453.19 | 5459.1 | 5452.66 | 5459.1 | 3834.0 |
| 2024-02-27 02:30:00 | ES | Futures | 5458.84 | 5460.45 | 5457.49 | 5458.57 | 4530.0 |
| 2024-02-27 03:00:00 | ES | Futures | 5458.57 | 5460.72 | 5457.76 | 5459.37 | 5506.0 |
| 2024-02-27 03:30:00 | ES | Futures | 5459.37 | 5459.64 | 5454.0 | 5454.54 | 5505.0 |
| 2024-02-27 04:00:00 | ES | Futures | 5454.81 | 5465.28 | 5454.54 | 5464.21 | 8744.0 |
| 2024-02-27 04:30:00 | ES | Futures | 5464.21 | 5464.74 | 5462.33 | 5463.67 | 4002.0 |
| 2024-02-27 05:00:00 | ES | Futures | 5463.67 | 5465.01 | 5462.06 | 5463.4 | 4024.0 |
| 2024-02-27 05:30:00 | ES | Futures | 5463.13 | 5464.74 | 5460.98 | 5464.21 | 4091.0 |
| 2024-02-27 06:00:00 | ES | Futures | 5463.94 | 5464.74 | 5460.72 | 5461.79 | 3253.0 |
| 2024-02-27 06:30:00 | ES | Futures | 5461.79 | 5462.6 | 5460.45 | 5461.52 | 3452.0 |
| 2024-02-27 07:00:00 | ES | Futures | 5461.79 | 5466.09 | 5461.52 | 5465.55 | 5453.0 |
| 2024-02-27 07:30:00 | ES | Futures | 5465.55 | 5468.5 | 5465.55 | 5466.62 | 7638.0 |
| 2024-02-27 08:00:00 | ES | Futures | 5466.89 | 5467.43 | 5456.96 | 5459.37 | 15674.0 |
| 2024-02-27 08:30:00 | ES | Futures | 5459.64 | 5466.62 | 5457.76 | 5465.28 | 14835.0 |
| 2024-02-27 09:00:00 | ES | Futures | 5465.28 | 5467.43 | 5462.06 | 5464.74 | 15806.0 |
| 2024-02-27 09:30:00 | ES | Futures | 5464.74 | 5465.28 | 5452.12 | 5458.57 | 115378.0 |
| 2024-02-27 10:00:00 | ES | Futures | 5458.57 | 5463.67 | 5453.19 | 5459.91 | 87130.0 |
| 2024-02-27 10:30:00 | ES | Futures | 5459.91 | 5460.98 | 5452.93 | 5458.84 | 58938.0 |
| 2024-02-27 11:00:00 | ES | Futures | 5458.57 | 5459.37 | 5452.93 | 5453.73 | 42883.0 |
| 2024-02-27 11:30:00 | ES | Futures | 5453.73 | 5456.96 | 5451.05 | 5456.15 | 44349.0 |
| 2024-02-27 12:00:00 | ES | Futures | 5456.42 | 5457.49 | 5449.97 | 5452.12 | 43685.0 |
| 2024-02-27 12:30:00 | ES | Futures | 5452.39 | 5454.81 | 5446.21 | 5447.02 | 42827.0 |
| 2024-02-27 13:00:00 | ES | Futures | 5447.02 | 5454.27 | 5443.79 | 5448.9 | 64326.0 |
| 2024-02-27 13:30:00 | ES | Futures | 5449.17 | 5456.15 | 5447.55 | 5455.08 | 33134.0 |
| 2024-02-27 14:00:00 | ES | Futures | 5455.08 | 5462.33 | 5454.54 | 5460.72 | 52750.0 |
| 2024-02-27 14:30:00 | ES | Futures | 5460.72 | 5465.01 | 5458.03 | 5464.48 | 45558.0 |
| 2024-02-27 15:00:00 | ES | Futures | 5464.21 | 5466.89 | 5459.64 | 5465.55 | 46130.0 |
| 2024-02-27 15:30:00 | ES | Futures | 5465.55 | 5470.38 | 5461.79 | 5466.89 | 106416.0 |
| 2024-02-27 16:00:00 | ES | Futures | 5467.16 | 5471.73 | 5466.36 | 5471.46 | 35668.0 |
| 2024-02-27 16:30:00 | ES | Futures | 5471.19 | 5471.46 | 5468.5 | 5468.77 | 5968.0 |
| 2024-02-27 18:00:00 | ES | Futures | 5469.31 | 5469.85 | 5467.16 | 5468.5 | 2415.0 |
| 2024-02-27 18:30:00 | ES | Futures | 5468.5 | 5468.5 | 5465.55 | 5465.55 | 2144.0 |
| 2024-02-27 19:00:00 | ES | Futures | 5465.82 | 5466.89 | 5465.55 | 5466.89 | 2285.0 |
| 2024-02-27 19:30:00 | ES | Futures | 5466.62 | 5466.62 | 5465.28 | 5465.28 | 1839.0 |
| 2024-02-27 20:00:00 | ES | Futures | 5465.28 | 5467.97 | 5463.94 | 5467.16 | 2912.0 |
| 2024-02-27 20:30:00 | ES | Futures | 5467.16 | 5467.43 | 5465.01 | 5466.89 | 2183.0 |
| 2024-02-27 21:00:00 | ES | Futures | 5466.89 | 5468.5 | 5466.09 | 5468.24 | 2606.0 |
| 2024-02-27 21:30:00 | ES | Futures | 5468.24 | 5468.24 | 5466.36 | 5468.24 | 1663.0 |
| 2024-02-27 22:00:00 | ES | Futures | 5468.24 | 5468.77 | 5466.89 | 5467.7 | 1774.0 |
| 2024-02-27 22:30:00 | ES | Futures | 5467.7 | 5469.58 | 5467.7 | 5469.31 | 2078.0 |
| 2024-02-27 23:00:00 | ES | Futures | 5469.58 | 5469.58 | 5467.43 | 5467.7 | 1329.0 |
| 2024-02-27 23:30:00 | ES | Futures | 5467.7 | 5467.7 | 5465.28 | 5466.09 | 1898.0 |
| 2024-02-27 00:00:00 | NQ | Futures | 19477.17 | 19480.97 | 19467.68 | 19469.04 | 1327.0 |
| 2024-02-27 00:30:00 | NQ | Futures | 19469.58 | 19471.75 | 19448.15 | 19459.27 | 2246.0 |
| 2024-02-27 01:00:00 | NQ | Futures | 19459.82 | 19461.44 | 19453.31 | 19457.92 | 1188.0 |
| 2024-02-27 01:30:00 | NQ | Futures | 19458.46 | 19470.12 | 19457.1 | 19466.05 | 1217.0 |
> showing 50 of 3,875 rows — these rows as CSV