PREVIEW / stock_30min / 2001-06-27
file: by_date/stock_30min/2001/2001-06-27.parquet size: 549 KB rows: 29,071 symbols: 1,306
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 |
|---|---|---|---|---|---|---|---|
| 2001-06-27 09:00:00 | AAPL | Stock | 0.4239 | 0.4259 | 0.4232 | 0.4259 | 756000.0 |
| 2001-06-27 09:30:00 | AAPL | Stock | 0.4255 | 0.4286 | 0.4161 | 0.4191 | 30100000.0 |
| 2001-06-27 10:00:00 | AAPL | Stock | 0.4186 | 0.4207 | 0.417 | 0.4196 | 12807200.0 |
| 2001-06-27 10:30:00 | AAPL | Stock | 0.4196 | 0.4205 | 0.4179 | 0.4188 | 9895200.0 |
| 2001-06-27 11:00:00 | AAPL | Stock | 0.4191 | 0.4202 | 0.417 | 0.4171 | 9867200.0 |
| 2001-06-27 11:30:00 | AAPL | Stock | 0.4175 | 0.42 | 0.4161 | 0.4173 | 23508800.0 |
| 2001-06-27 12:00:00 | AAPL | Stock | 0.4171 | 0.4191 | 0.4166 | 0.4177 | 8652000.0 |
| 2001-06-27 12:30:00 | AAPL | Stock | 0.4177 | 0.4184 | 0.4152 | 0.4168 | 7509600.0 |
| 2001-06-27 13:00:00 | AAPL | Stock | 0.4168 | 0.4168 | 0.4118 | 0.4118 | 24203200.0 |
| 2001-06-27 13:30:00 | AAPL | Stock | 0.4116 | 0.4152 | 0.4088 | 0.4109 | 29814400.0 |
| 2001-06-27 14:00:00 | AAPL | Stock | 0.4109 | 0.4116 | 0.4018 | 0.4038 | 42291200.0 |
| 2001-06-27 14:30:00 | AAPL | Stock | 0.4039 | 0.417 | 0.4039 | 0.4154 | 21767200.0 |
| 2001-06-27 15:00:00 | AAPL | Stock | 0.4157 | 0.422 | 0.4143 | 0.4211 | 39569600.0 |
| 2001-06-27 15:30:00 | AAPL | Stock | 0.4213 | 0.4213 | 0.4132 | 0.4163 | 69176800.0 |
| 2001-06-27 16:00:00 | AAPL | Stock | 0.417 | 0.4232 | 0.4091 | 0.4168 | 21179200.0 |
| 2001-06-27 16:30:00 | AAPL | Stock | 0.4168 | 0.4168 | 0.4168 | 0.4168 | 95200.0 |
| 2001-06-27 17:30:00 | AAPL | Stock | 0.4161 | 0.4161 | 0.4161 | 0.4161 | 5600.0 |
| 2001-06-27 18:00:00 | AAPL | Stock | 0.417 | 0.417 | 0.417 | 0.417 | 16800.0 |
| 2001-06-27 08:00:00 | MSFT | Stock | 35.055 | 35.12 | 35.0 | 35.0 | 6800.0 |
| 2001-06-27 08:30:00 | MSFT | Stock | 34.95 | 35.0 | 34.95 | 35.0 | 4200.0 |
| 2001-06-27 09:00:00 | MSFT | Stock | 34.995 | 35.0 | 34.925 | 34.93 | 67800.0 |
| 2001-06-27 09:30:00 | MSFT | Stock | 34.93 | 34.995 | 34.68 | 34.8 | 6799600.0 |
| 2001-06-27 10:00:00 | MSFT | Stock | 34.8 | 35.02 | 34.75 | 35.005 | 4020600.0 |
| 2001-06-27 10:30:00 | MSFT | Stock | 35.015 | 35.025 | 34.875 | 34.91 | 2626800.0 |
| 2001-06-27 11:00:00 | MSFT | Stock | 34.905 | 35.07 | 34.9 | 35.01 | 2939400.0 |
| 2001-06-27 11:30:00 | MSFT | Stock | 35.01 | 35.4 | 35.01 | 35.3 | 3460600.0 |
| 2001-06-27 12:00:00 | MSFT | Stock | 35.315 | 35.35 | 35.145 | 35.19 | 1512200.0 |
| 2001-06-27 12:30:00 | MSFT | Stock | 35.19 | 35.265 | 35.145 | 35.21 | 1283800.0 |
| 2001-06-27 13:00:00 | MSFT | Stock | 35.21 | 35.275 | 35.15 | 35.2 | 5609400.0 |
| 2001-06-27 13:30:00 | MSFT | Stock | 35.15 | 35.225 | 35.055 | 35.095 | 1475800.0 |
| 2001-06-27 14:00:00 | MSFT | Stock | 35.095 | 35.23 | 34.875 | 35.0 | 7991600.0 |
| 2001-06-27 14:30:00 | MSFT | Stock | 34.995 | 35.225 | 34.89 | 35.2 | 5961600.0 |
| 2001-06-27 15:00:00 | MSFT | Stock | 35.2 | 35.545 | 35.045 | 35.485 | 8652800.0 |
| 2001-06-27 15:30:00 | MSFT | Stock | 35.49 | 35.765 | 35.42 | 35.57 | 10156000.0 |
| 2001-06-27 16:00:00 | MSFT | Stock | 35.57 | 35.62 | 34.93 | 35.57 | 3838800.0 |
| 2001-06-27 16:30:00 | MSFT | Stock | 35.57 | 35.57 | 35.335 | 35.55 | 63000.0 |
| 2001-06-27 17:00:00 | MSFT | Stock | 35.55 | 35.61 | 35.55 | 35.57 | 21600.0 |
| 2001-06-27 17:30:00 | MSFT | Stock | 35.57 | 35.57 | 35.57 | 35.57 | 800.0 |
| 2001-06-27 18:00:00 | MSFT | Stock | 35.6 | 35.6 | 35.55 | 35.6 | 1400.0 |
| 2001-06-27 08:00:00 | NVDA | Stock | 0.3906 | 0.3921 | 0.3906 | 0.3921 | 5280000.0 |
| 2001-06-27 08:30:00 | NVDA | Stock | 0.3921 | 0.3921 | 0.3898 | 0.3898 | 144000.0 |
| 2001-06-27 09:00:00 | NVDA | Stock | 0.389 | 0.3896 | 0.3887 | 0.3888 | 2400000.0 |
| 2001-06-27 09:30:00 | NVDA | Stock | 0.3888 | 0.3896 | 0.3819 | 0.3838 | 129792000.0 |
| 2001-06-27 10:00:00 | NVDA | Stock | 0.384 | 0.3854 | 0.38 | 0.3827 | 80856000.0 |
| 2001-06-27 10:30:00 | NVDA | Stock | 0.3827 | 0.3859 | 0.3819 | 0.3829 | 55560000.0 |
| 2001-06-27 11:00:00 | NVDA | Stock | 0.3828 | 0.3854 | 0.3828 | 0.384 | 34248000.0 |
| 2001-06-27 11:30:00 | NVDA | Stock | 0.384 | 0.3857 | 0.3837 | 0.3838 | 30936000.0 |
| 2001-06-27 12:00:00 | NVDA | Stock | 0.3838 | 0.3841 | 0.3813 | 0.3828 | 19320000.0 |
| 2001-06-27 12:30:00 | NVDA | Stock | 0.3829 | 0.385 | 0.3816 | 0.3842 | 25464000.0 |
| 2001-06-27 13:00:00 | NVDA | Stock | 0.3842 | 0.385 | 0.3824 | 0.3835 | 21216000.0 |
> showing 50 of 29,071 rows — these rows as CSV