PREVIEW / stock_30min / 2002-01-24
file: by_date/stock_30min/2002/2002-01-24.parquet size: 583 KB rows: 29,971 symbols: 1,341
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 |
|---|---|---|---|---|---|---|---|
| 2002-01-24 08:00:00 | AAPL | Stock | 0.411 | 0.4125 | 0.411 | 0.4125 | 1114400.0 |
| 2002-01-24 08:30:00 | AAPL | Stock | 0.4125 | 0.4125 | 0.4125 | 0.4125 | 78400.0 |
| 2002-01-24 09:00:00 | AAPL | Stock | 0.4125 | 0.4125 | 0.4088 | 0.4091 | 1220800.0 |
| 2002-01-24 09:30:00 | AAPL | Stock | 0.4091 | 0.417 | 0.4089 | 0.4139 | 38068800.0 |
| 2002-01-24 10:00:00 | AAPL | Stock | 0.4139 | 0.4188 | 0.4127 | 0.4168 | 39065600.0 |
| 2002-01-24 10:30:00 | AAPL | Stock | 0.4165 | 0.4198 | 0.4152 | 0.4189 | 29870400.0 |
| 2002-01-24 11:00:00 | AAPL | Stock | 0.4184 | 0.4188 | 0.4152 | 0.4155 | 17724000.0 |
| 2002-01-24 11:30:00 | AAPL | Stock | 0.4155 | 0.4171 | 0.4152 | 0.417 | 16452800.0 |
| 2002-01-24 12:00:00 | AAPL | Stock | 0.4161 | 0.4177 | 0.4148 | 0.4161 | 12140800.0 |
| 2002-01-24 12:30:00 | AAPL | Stock | 0.4155 | 0.4182 | 0.4152 | 0.4161 | 3992800.0 |
| 2002-01-24 13:00:00 | AAPL | Stock | 0.4161 | 0.4175 | 0.4155 | 0.4157 | 7196000.0 |
| 2002-01-24 13:30:00 | AAPL | Stock | 0.4159 | 0.4177 | 0.4145 | 0.4146 | 14246400.0 |
| 2002-01-24 14:00:00 | AAPL | Stock | 0.4146 | 0.4161 | 0.4136 | 0.4145 | 19588800.0 |
| 2002-01-24 14:30:00 | AAPL | Stock | 0.4148 | 0.4171 | 0.4138 | 0.4166 | 14442400.0 |
| 2002-01-24 15:00:00 | AAPL | Stock | 0.4166 | 0.4179 | 0.4152 | 0.4157 | 14627200.0 |
| 2002-01-24 15:30:00 | AAPL | Stock | 0.4159 | 0.417 | 0.4143 | 0.4146 | 25076800.0 |
| 2002-01-24 16:00:00 | AAPL | Stock | 0.4145 | 0.4165 | 0.4125 | 0.4125 | 32284000.0 |
| 2002-01-24 16:30:00 | AAPL | Stock | 0.4125 | 0.4158 | 0.4102 | 0.4145 | 34932800.0 |
| 2002-01-24 17:00:00 | AAPL | Stock | 0.4145 | 0.4145 | 0.408 | 0.4145 | 4088000.0 |
| 2002-01-24 08:00:00 | MSFT | Stock | 32.225 | 32.345 | 31.96 | 32.175 | 66400.0 |
| 2002-01-24 08:30:00 | MSFT | Stock | 32.1945 | 32.2 | 31.87 | 32.17 | 82800.0 |
| 2002-01-24 09:00:00 | MSFT | Stock | 32.15 | 32.245 | 32.045 | 32.05 | 329000.0 |
| 2002-01-24 09:30:00 | MSFT | Stock | 32.05 | 32.3805 | 31.9 | 32.26 | 8645000.0 |
| 2002-01-24 10:00:00 | MSFT | Stock | 32.255 | 32.455 | 32.0 | 32.05 | 7767000.0 |
| 2002-01-24 10:30:00 | MSFT | Stock | 32.045 | 32.33 | 31.94 | 32.33 | 5750200.0 |
| 2002-01-24 11:00:00 | MSFT | Stock | 32.3295 | 32.475 | 32.29 | 32.4355 | 7668400.0 |
| 2002-01-24 11:30:00 | MSFT | Stock | 32.435 | 32.59 | 32.4 | 32.485 | 7202200.0 |
| 2002-01-24 12:00:00 | MSFT | Stock | 32.485 | 32.535 | 32.4 | 32.475 | 4677000.0 |
| 2002-01-24 12:30:00 | MSFT | Stock | 32.475 | 32.495 | 32.3 | 32.47 | 2847200.0 |
| 2002-01-24 13:00:00 | MSFT | Stock | 32.475 | 32.475 | 32.3 | 32.315 | 2436400.0 |
| 2002-01-24 13:30:00 | MSFT | Stock | 32.31 | 32.38 | 32.1 | 32.1 | 4682800.0 |
| 2002-01-24 14:00:00 | MSFT | Stock | 32.175 | 32.18 | 31.975 | 32.165 | 4800200.0 |
| 2002-01-24 14:30:00 | MSFT | Stock | 32.175 | 32.345 | 32.125 | 32.245 | 7142200.0 |
| 2002-01-24 15:00:00 | MSFT | Stock | 32.245 | 32.455 | 32.245 | 32.4245 | 4677800.0 |
| 2002-01-24 15:30:00 | MSFT | Stock | 32.425 | 32.455 | 32.265 | 32.325 | 7300000.0 |
| 2002-01-24 16:00:00 | MSFT | Stock | 32.335 | 32.4395 | 32.06 | 32.106 | 3846800.0 |
| 2002-01-24 16:30:00 | MSFT | Stock | 32.335 | 32.335 | 32.105 | 32.3 | 982800.0 |
| 2002-01-24 17:00:00 | MSFT | Stock | 32.21 | 32.3 | 32.19 | 32.19 | 590000.0 |
| 2002-01-24 17:30:00 | MSFT | Stock | 32.185 | 32.22 | 32.155 | 32.22 | 5400.0 |
| 2002-01-24 18:00:00 | MSFT | Stock | 32.2994 | 32.2994 | 32.22 | 32.22 | 74200.0 |
| 2002-01-24 08:00:00 | NVDA | Stock | 0.5296 | 0.5332 | 0.5296 | 0.5309 | 312000.0 |
| 2002-01-24 08:30:00 | NVDA | Stock | 0.5309 | 0.5361 | 0.5309 | 0.5342 | 708000.0 |
| 2002-01-24 09:00:00 | NVDA | Stock | 0.535 | 0.5365 | 0.5329 | 0.5332 | 4560000.0 |
| 2002-01-24 09:30:00 | NVDA | Stock | 0.5333 | 0.5337 | 0.5221 | 0.527 | 108456000.0 |
| 2002-01-24 10:00:00 | NVDA | Stock | 0.527 | 0.5304 | 0.5229 | 0.5231 | 78420000.0 |
| 2002-01-24 10:30:00 | NVDA | Stock | 0.523 | 0.531 | 0.5224 | 0.5277 | 57900000.0 |
| 2002-01-24 11:00:00 | NVDA | Stock | 0.5279 | 0.5296 | 0.525 | 0.5272 | 25032000.0 |
| 2002-01-24 11:30:00 | NVDA | Stock | 0.5272 | 0.5303 | 0.5252 | 0.5296 | 35340000.0 |
| 2002-01-24 12:00:00 | NVDA | Stock | 0.5296 | 0.5408 | 0.5292 | 0.5407 | 109356000.0 |
| 2002-01-24 12:30:00 | NVDA | Stock | 0.5406 | 0.5512 | 0.5393 | 0.5454 | 121044000.0 |
> showing 50 of 29,971 rows — these rows as CSV