PREVIEW / futures_30min / 2023-08-01
file: by_date/futures_30min/2023/2023-08-01.parquet size: 113 KB rows: 3,923
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-08-01 00:00:00 | ES | Futures | 5070.23 | 5071.05 | 5069.68 | 5070.5 | 1395.0 |
| 2023-08-01 00:30:00 | ES | Futures | 5070.5 | 5071.87 | 5069.95 | 5070.5 | 1799.0 |
| 2023-08-01 01:00:00 | ES | Futures | 5070.23 | 5071.32 | 5068.58 | 5069.4 | 3195.0 |
| 2023-08-01 01:30:00 | ES | Futures | 5069.13 | 5069.4 | 5067.48 | 5068.58 | 1841.0 |
| 2023-08-01 02:00:00 | ES | Futures | 5068.58 | 5068.58 | 5066.38 | 5066.66 | 3464.0 |
| 2023-08-01 02:30:00 | ES | Futures | 5066.66 | 5067.48 | 5064.74 | 5065.56 | 3715.0 |
| 2023-08-01 03:00:00 | ES | Futures | 5065.56 | 5066.38 | 5061.99 | 5063.09 | 11400.0 |
| 2023-08-01 03:30:00 | ES | Futures | 5063.09 | 5064.74 | 5059.25 | 5060.89 | 8759.0 |
| 2023-08-01 04:00:00 | ES | Futures | 5060.89 | 5061.17 | 5054.58 | 5054.85 | 9176.0 |
| 2023-08-01 04:30:00 | ES | Futures | 5054.85 | 5056.77 | 5050.46 | 5054.85 | 15564.0 |
| 2023-08-01 05:00:00 | ES | Futures | 5055.13 | 5055.13 | 5050.19 | 5051.01 | 8115.0 |
| 2023-08-01 05:30:00 | ES | Futures | 5051.28 | 5053.75 | 5049.36 | 5053.21 | 11188.0 |
| 2023-08-01 06:00:00 | ES | Futures | 5053.48 | 5055.68 | 5052.38 | 5054.58 | 5948.0 |
| 2023-08-01 06:30:00 | ES | Futures | 5054.58 | 5059.79 | 5054.3 | 5059.52 | 9913.0 |
| 2023-08-01 07:00:00 | ES | Futures | 5059.52 | 5060.34 | 5054.03 | 5054.58 | 9556.0 |
| 2023-08-01 07:30:00 | ES | Futures | 5054.3 | 5054.58 | 5050.19 | 5051.01 | 16014.0 |
| 2023-08-01 08:00:00 | ES | Futures | 5051.01 | 5052.66 | 5045.79 | 5046.34 | 16394.0 |
| 2023-08-01 08:30:00 | ES | Futures | 5046.07 | 5047.72 | 5042.23 | 5045.79 | 20708.0 |
| 2023-08-01 09:00:00 | ES | Futures | 5045.79 | 5050.46 | 5043.6 | 5050.19 | 25457.0 |
| 2023-08-01 09:30:00 | ES | Futures | 5050.46 | 5057.87 | 5047.99 | 5055.95 | 128191.0 |
| 2023-08-01 10:00:00 | ES | Futures | 5056.23 | 5061.17 | 5041.68 | 5046.07 | 156310.0 |
| 2023-08-01 10:30:00 | ES | Futures | 5046.34 | 5054.3 | 5044.42 | 5051.01 | 90384.0 |
| 2023-08-01 11:00:00 | ES | Futures | 5051.01 | 5052.38 | 5044.7 | 5049.64 | 61034.0 |
| 2023-08-01 11:30:00 | ES | Futures | 5049.91 | 5050.74 | 5044.7 | 5048.54 | 45441.0 |
| 2023-08-01 12:00:00 | ES | Futures | 5048.81 | 5049.91 | 5043.32 | 5044.7 | 35641.0 |
| 2023-08-01 12:30:00 | ES | Futures | 5044.7 | 5051.01 | 5041.13 | 5050.46 | 40602.0 |
| 2023-08-01 13:00:00 | ES | Futures | 5050.74 | 5052.66 | 5048.81 | 5050.46 | 33842.0 |
| 2023-08-01 13:30:00 | ES | Futures | 5050.74 | 5052.38 | 5046.62 | 5051.83 | 28692.0 |
| 2023-08-01 14:00:00 | ES | Futures | 5051.83 | 5057.87 | 5051.56 | 5053.48 | 60078.0 |
| 2023-08-01 14:30:00 | ES | Futures | 5053.48 | 5056.77 | 5052.66 | 5055.13 | 40910.0 |
| 2023-08-01 15:00:00 | ES | Futures | 5054.85 | 5058.15 | 5052.66 | 5054.58 | 37852.0 |
| 2023-08-01 15:30:00 | ES | Futures | 5054.3 | 5057.05 | 5049.09 | 5052.11 | 118463.0 |
| 2023-08-01 16:00:00 | ES | Futures | 5052.11 | 5052.66 | 5048.26 | 5052.11 | 47522.0 |
| 2023-08-01 16:30:00 | ES | Futures | 5052.38 | 5052.38 | 5049.09 | 5049.09 | 6090.0 |
| 2023-08-01 18:00:00 | ES | Futures | 5029.05 | 5037.01 | 5020.26 | 5035.91 | 22726.0 |
| 2023-08-01 18:30:00 | ES | Futures | 5035.91 | 5037.56 | 5033.72 | 5036.74 | 5379.0 |
| 2023-08-01 19:00:00 | ES | Futures | 5036.46 | 5037.83 | 5033.44 | 5034.26 | 2898.0 |
| 2023-08-01 19:30:00 | ES | Futures | 5033.99 | 5036.46 | 5032.62 | 5035.91 | 3866.0 |
| 2023-08-01 20:00:00 | ES | Futures | 5036.19 | 5036.74 | 5030.7 | 5035.64 | 6913.0 |
| 2023-08-01 20:30:00 | ES | Futures | 5035.36 | 5040.3 | 5035.36 | 5038.66 | 4106.0 |
| 2023-08-01 21:00:00 | ES | Futures | 5038.93 | 5043.87 | 5038.38 | 5041.95 | 5324.0 |
| 2023-08-01 21:30:00 | ES | Futures | 5041.95 | 5043.6 | 5041.13 | 5041.4 | 3290.0 |
| 2023-08-01 22:00:00 | ES | Futures | 5041.4 | 5041.68 | 5034.54 | 5034.81 | 6259.0 |
| 2023-08-01 22:30:00 | ES | Futures | 5034.54 | 5035.09 | 5028.5 | 5029.32 | 8113.0 |
| 2023-08-01 23:00:00 | ES | Futures | 5029.6 | 5031.79 | 5028.5 | 5030.15 | 5282.0 |
| 2023-08-01 23:30:00 | ES | Futures | 5030.15 | 5030.42 | 5028.23 | 5029.6 | 2584.0 |
| 2023-08-01 00:00:00 | NQ | Futures | 17652.43 | 17655.76 | 17650.48 | 17653.54 | 689.0 |
| 2023-08-01 00:30:00 | NQ | Futures | 17653.26 | 17660.77 | 17652.43 | 17654.37 | 929.0 |
| 2023-08-01 01:00:00 | NQ | Futures | 17654.65 | 17656.6 | 17644.64 | 17648.26 | 1238.0 |
| 2023-08-01 01:30:00 | NQ | Futures | 17647.7 | 17650.2 | 17640.75 | 17643.81 | 953.0 |
> showing 50 of 3,923 rows — these rows as CSV