PREVIEW / stock_1min / 2001-05-09
file: by_date/stock_1min/2001/2001-05-09.parquet size: 3.1 MB rows: 251,793 symbols: 1,056
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-05-09 08:08:00 | AAPL | Stock | 0.4321 | 0.4321 | 0.4321 | 0.4321 | 22400.0 |
| 2001-05-09 09:00:00 | AAPL | Stock | 0.4286 | 0.4304 | 0.4286 | 0.4304 | 140000.0 |
| 2001-05-09 09:05:00 | AAPL | Stock | 0.4304 | 0.4304 | 0.4304 | 0.4304 | 22400.0 |
| 2001-05-09 09:08:00 | AAPL | Stock | 0.4286 | 0.4286 | 0.4286 | 0.4286 | 112000.0 |
| 2001-05-09 09:15:00 | AAPL | Stock | 0.4321 | 0.4321 | 0.4321 | 0.4321 | 11200.0 |
| 2001-05-09 09:16:00 | AAPL | Stock | 0.4343 | 0.4343 | 0.4343 | 0.4343 | 39200.0 |
| 2001-05-09 09:18:00 | AAPL | Stock | 0.4327 | 0.4327 | 0.4327 | 0.4327 | 39200.0 |
| 2001-05-09 09:21:00 | AAPL | Stock | 0.4339 | 0.4339 | 0.4339 | 0.4339 | 22400.0 |
| 2001-05-09 09:23:00 | AAPL | Stock | 0.4339 | 0.4339 | 0.4339 | 0.4339 | 39200.0 |
| 2001-05-09 09:25:00 | AAPL | Stock | 0.4338 | 0.4338 | 0.4338 | 0.4338 | 28000.0 |
| 2001-05-09 09:27:00 | AAPL | Stock | 0.4343 | 0.4343 | 0.4343 | 0.4343 | 11200.0 |
| 2001-05-09 09:28:00 | AAPL | Stock | 0.4334 | 0.4339 | 0.4334 | 0.4339 | 302400.0 |
| 2001-05-09 09:29:00 | AAPL | Stock | 0.4318 | 0.4318 | 0.4318 | 0.4318 | 5600.0 |
| 2001-05-09 09:30:00 | AAPL | Stock | 0.4311 | 0.4313 | 0.4304 | 0.4304 | 1842400.0 |
| 2001-05-09 09:31:00 | AAPL | Stock | 0.4311 | 0.4313 | 0.4286 | 0.4286 | 3113600.0 |
| 2001-05-09 09:32:00 | AAPL | Stock | 0.4295 | 0.4296 | 0.4268 | 0.4277 | 3964800.0 |
| 2001-05-09 09:33:00 | AAPL | Stock | 0.4271 | 0.4295 | 0.4268 | 0.4268 | 1103200.0 |
| 2001-05-09 09:34:00 | AAPL | Stock | 0.4271 | 0.4289 | 0.4271 | 0.4289 | 739200.0 |
| 2001-05-09 09:35:00 | AAPL | Stock | 0.4275 | 0.4286 | 0.4275 | 0.4286 | 716800.0 |
| 2001-05-09 09:36:00 | AAPL | Stock | 0.428 | 0.4286 | 0.428 | 0.4286 | 571200.0 |
| 2001-05-09 09:37:00 | AAPL | Stock | 0.4284 | 0.4293 | 0.4277 | 0.4286 | 1960000.0 |
| 2001-05-09 09:38:00 | AAPL | Stock | 0.4284 | 0.4286 | 0.4277 | 0.4286 | 1108800.0 |
| 2001-05-09 09:39:00 | AAPL | Stock | 0.4284 | 0.4286 | 0.4282 | 0.4284 | 968800.0 |
| 2001-05-09 09:40:00 | AAPL | Stock | 0.4277 | 0.4282 | 0.4268 | 0.4275 | 4334400.0 |
| 2001-05-09 09:41:00 | AAPL | Stock | 0.4277 | 0.4277 | 0.4271 | 0.4277 | 330400.0 |
| 2001-05-09 09:42:00 | AAPL | Stock | 0.4277 | 0.4291 | 0.4268 | 0.4291 | 2564800.0 |
| 2001-05-09 09:43:00 | AAPL | Stock | 0.4295 | 0.4295 | 0.4277 | 0.4293 | 1209600.0 |
| 2001-05-09 09:44:00 | AAPL | Stock | 0.4293 | 0.4293 | 0.4277 | 0.4277 | 1400000.0 |
| 2001-05-09 09:45:00 | AAPL | Stock | 0.428 | 0.428 | 0.4252 | 0.4259 | 1932000.0 |
| 2001-05-09 09:46:00 | AAPL | Stock | 0.4254 | 0.4254 | 0.4227 | 0.4238 | 5157600.0 |
| 2001-05-09 09:47:00 | AAPL | Stock | 0.4239 | 0.4241 | 0.4227 | 0.4234 | 2318400.0 |
| 2001-05-09 09:48:00 | AAPL | Stock | 0.4234 | 0.4268 | 0.4232 | 0.4268 | 1265600.0 |
| 2001-05-09 09:49:00 | AAPL | Stock | 0.4264 | 0.4273 | 0.4257 | 0.4259 | 1265600.0 |
| 2001-05-09 09:50:00 | AAPL | Stock | 0.4259 | 0.4268 | 0.4252 | 0.4259 | 2060800.0 |
| 2001-05-09 09:51:00 | AAPL | Stock | 0.425 | 0.4277 | 0.4236 | 0.4238 | 2833600.0 |
| 2001-05-09 09:52:00 | AAPL | Stock | 0.4236 | 0.4241 | 0.4229 | 0.4234 | 1965600.0 |
| 2001-05-09 09:53:00 | AAPL | Stock | 0.4227 | 0.425 | 0.4227 | 0.4243 | 1153600.0 |
| 2001-05-09 09:54:00 | AAPL | Stock | 0.4241 | 0.4257 | 0.4241 | 0.4255 | 739200.0 |
| 2001-05-09 09:55:00 | AAPL | Stock | 0.4255 | 0.4257 | 0.4243 | 0.4245 | 812000.0 |
| 2001-05-09 09:56:00 | AAPL | Stock | 0.4252 | 0.4286 | 0.4243 | 0.4286 | 4435200.0 |
| 2001-05-09 09:57:00 | AAPL | Stock | 0.4286 | 0.4286 | 0.4266 | 0.4266 | 672000.0 |
| 2001-05-09 09:58:00 | AAPL | Stock | 0.4275 | 0.428 | 0.4275 | 0.4279 | 632800.0 |
| 2001-05-09 09:59:00 | AAPL | Stock | 0.4286 | 0.4289 | 0.4275 | 0.4282 | 1271200.0 |
| 2001-05-09 10:00:00 | AAPL | Stock | 0.4282 | 0.4284 | 0.427 | 0.4277 | 834400.0 |
| 2001-05-09 10:01:00 | AAPL | Stock | 0.4275 | 0.4277 | 0.425 | 0.4252 | 1461600.0 |
| 2001-05-09 10:02:00 | AAPL | Stock | 0.425 | 0.428 | 0.425 | 0.4279 | 1047200.0 |
| 2001-05-09 10:03:00 | AAPL | Stock | 0.4279 | 0.4286 | 0.4255 | 0.4277 | 6098400.0 |
| 2001-05-09 10:04:00 | AAPL | Stock | 0.4286 | 0.4286 | 0.4268 | 0.4277 | 3337600.0 |
| 2001-05-09 10:05:00 | AAPL | Stock | 0.4277 | 0.4286 | 0.4277 | 0.4279 | 3645600.0 |
| 2001-05-09 10:06:00 | AAPL | Stock | 0.4279 | 0.4289 | 0.4277 | 0.4289 | 705600.0 |
> showing 50 of 251,793 rows — these rows as CSV