PREVIEW / futures_30min / 2023-07-25
file: by_date/futures_30min/2023/2023-07-25.parquet size: 104 KB rows: 3,885
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 |
|---|---|---|---|---|---|---|---|
| 2023-07-25 00:00:00 | ES | Futures | 5032.07 | 5032.62 | 5031.52 | 5032.62 | 855.0 |
| 2023-07-25 00:30:00 | ES | Futures | 5032.62 | 5033.17 | 5031.79 | 5032.07 | 1797.0 |
| 2023-07-25 01:00:00 | ES | Futures | 5032.07 | 5033.44 | 5032.07 | 5032.07 | 2201.0 |
| 2023-07-25 01:30:00 | ES | Futures | 5032.34 | 5034.81 | 5032.07 | 5034.26 | 2666.0 |
| 2023-07-25 02:00:00 | ES | Futures | 5034.54 | 5037.83 | 5032.07 | 5037.56 | 5899.0 |
| 2023-07-25 02:30:00 | ES | Futures | 5037.56 | 5038.38 | 5036.74 | 5038.11 | 3185.0 |
| 2023-07-25 03:00:00 | ES | Futures | 5038.11 | 5038.66 | 5033.72 | 5033.99 | 10380.0 |
| 2023-07-25 03:30:00 | ES | Futures | 5033.99 | 5035.36 | 5032.07 | 5034.54 | 7673.0 |
| 2023-07-25 04:00:00 | ES | Futures | 5034.54 | 5041.95 | 5033.17 | 5041.68 | 9529.0 |
| 2023-07-25 04:30:00 | ES | Futures | 5041.68 | 5043.6 | 5040.85 | 5040.85 | 4979.0 |
| 2023-07-25 05:00:00 | ES | Futures | 5040.85 | 5041.68 | 5038.66 | 5039.21 | 3623.0 |
| 2023-07-25 05:30:00 | ES | Futures | 5039.21 | 5040.03 | 5038.66 | 5039.75 | 4445.0 |
| 2023-07-25 06:00:00 | ES | Futures | 5039.48 | 5040.03 | 5034.54 | 5035.64 | 5310.0 |
| 2023-07-25 06:30:00 | ES | Futures | 5035.64 | 5038.38 | 5034.81 | 5037.28 | 5245.0 |
| 2023-07-25 07:00:00 | ES | Futures | 5037.01 | 5040.03 | 5036.74 | 5039.75 | 6549.0 |
| 2023-07-25 07:30:00 | ES | Futures | 5039.75 | 5040.03 | 5036.74 | 5038.93 | 5315.0 |
| 2023-07-25 08:00:00 | ES | Futures | 5038.66 | 5040.58 | 5033.99 | 5035.64 | 8227.0 |
| 2023-07-25 08:30:00 | ES | Futures | 5035.91 | 5036.46 | 5033.17 | 5033.72 | 8099.0 |
| 2023-07-25 09:00:00 | ES | Futures | 5033.72 | 5033.99 | 5028.23 | 5029.05 | 23672.0 |
| 2023-07-25 09:30:00 | ES | Futures | 5029.05 | 5042.77 | 5028.5 | 5039.21 | 131347.0 |
| 2023-07-25 10:00:00 | ES | Futures | 5039.21 | 5041.95 | 5035.09 | 5038.38 | 78945.0 |
| 2023-07-25 10:30:00 | ES | Futures | 5038.38 | 5039.48 | 5034.54 | 5036.74 | 73285.0 |
| 2023-07-25 11:00:00 | ES | Futures | 5036.74 | 5042.5 | 5035.91 | 5041.4 | 40513.0 |
| 2023-07-25 11:30:00 | ES | Futures | 5041.4 | 5047.99 | 5040.85 | 5045.79 | 57945.0 |
| 2023-07-25 12:00:00 | ES | Futures | 5045.79 | 5047.72 | 5043.6 | 5045.52 | 38057.0 |
| 2023-07-25 12:30:00 | ES | Futures | 5045.25 | 5051.28 | 5044.15 | 5051.01 | 66840.0 |
| 2023-07-25 13:00:00 | ES | Futures | 5051.28 | 5053.75 | 5046.89 | 5052.11 | 93735.0 |
| 2023-07-25 13:30:00 | ES | Futures | 5052.38 | 5053.75 | 5049.36 | 5050.19 | 29973.0 |
| 2023-07-25 14:00:00 | ES | Futures | 5050.19 | 5057.6 | 5048.81 | 5056.77 | 44565.0 |
| 2023-07-25 14:30:00 | ES | Futures | 5056.77 | 5060.62 | 5049.91 | 5050.74 | 65940.0 |
| 2023-07-25 15:00:00 | ES | Futures | 5050.46 | 5055.68 | 5049.91 | 5052.38 | 51528.0 |
| 2023-07-25 15:30:00 | ES | Futures | 5052.11 | 5053.75 | 5044.97 | 5045.79 | 139778.0 |
| 2023-07-25 16:00:00 | ES | Futures | 5045.79 | 5056.77 | 5040.03 | 5054.3 | 83337.0 |
| 2023-07-25 16:30:00 | ES | Futures | 5054.03 | 5057.6 | 5052.66 | 5055.95 | 11536.0 |
| 2023-07-25 18:00:00 | ES | Futures | 5056.23 | 5058.42 | 5041.13 | 5044.15 | 14325.0 |
| 2023-07-25 18:30:00 | ES | Futures | 5044.15 | 5045.79 | 5042.23 | 5044.15 | 3927.0 |
| 2023-07-25 19:00:00 | ES | Futures | 5044.42 | 5044.97 | 5042.5 | 5044.7 | 2280.0 |
| 2023-07-25 19:30:00 | ES | Futures | 5044.42 | 5045.52 | 5043.05 | 5045.25 | 1582.0 |
| 2023-07-25 20:00:00 | ES | Futures | 5045.52 | 5045.79 | 5042.5 | 5043.6 | 3322.0 |
| 2023-07-25 20:30:00 | ES | Futures | 5043.6 | 5044.15 | 5042.77 | 5043.05 | 1590.0 |
| 2023-07-25 21:00:00 | ES | Futures | 5043.05 | 5044.15 | 5042.5 | 5043.32 | 2063.0 |
| 2023-07-25 21:30:00 | ES | Futures | 5043.32 | 5044.97 | 5042.23 | 5044.42 | 4485.0 |
| 2023-07-25 22:00:00 | ES | Futures | 5044.15 | 5045.25 | 5043.05 | 5044.97 | 1848.0 |
| 2023-07-25 22:30:00 | ES | Futures | 5044.97 | 5046.89 | 5044.7 | 5046.07 | 1645.0 |
| 2023-07-25 23:00:00 | ES | Futures | 5046.07 | 5048.54 | 5046.07 | 5047.44 | 2098.0 |
| 2023-07-25 23:30:00 | ES | Futures | 5047.44 | 5047.44 | 5045.52 | 5046.07 | 1415.0 |
| 2023-07-25 00:00:00 | NQ | Futures | 17312.83 | 17313.39 | 17309.21 | 17312.27 | 505.0 |
| 2023-07-25 00:30:00 | NQ | Futures | 17312.27 | 17315.61 | 17305.6 | 17306.99 | 972.0 |
| 2023-07-25 01:00:00 | NQ | Futures | 17307.27 | 17313.11 | 17305.6 | 17306.43 | 1150.0 |
| 2023-07-25 01:30:00 | NQ | Futures | 17306.71 | 17316.44 | 17305.32 | 17315.61 | 1505.0 |
> showing 50 of 3,885 rows — these rows as CSV