PREVIEW / stock_1min / 2009-03-20
file: by_date/stock_1min/2009/2009-03-20.parquet size: 12.2 MB rows: 938,457 symbols: 2,688
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 |
|---|---|---|---|---|---|---|---|
| 2009-03-20 07:03:00 | AAPL | Stock | 3.5996 | 3.5996 | 3.5996 | 3.5996 | 2800.0 |
| 2009-03-20 08:00:00 | AAPL | Stock | 3.6079 | 3.6079 | 3.6079 | 3.6079 | 2800.0 |
| 2009-03-20 08:05:00 | AAPL | Stock | 3.6304 | 3.6304 | 3.6304 | 3.6304 | 11844.0 |
| 2009-03-20 08:09:00 | AAPL | Stock | 3.6196 | 3.6196 | 3.6179 | 3.6179 | 6300.0 |
| 2009-03-20 08:16:00 | AAPL | Stock | 3.61 | 3.61 | 3.61 | 3.61 | 4760.0 |
| 2009-03-20 08:17:00 | AAPL | Stock | 3.6086 | 3.6086 | 3.6071 | 3.6071 | 25900.0 |
| 2009-03-20 08:19:00 | AAPL | Stock | 3.6025 | 3.6025 | 3.6025 | 3.6025 | 2884.0 |
| 2009-03-20 08:20:00 | AAPL | Stock | 3.6054 | 3.6054 | 3.6025 | 3.6025 | 8316.0 |
| 2009-03-20 08:21:00 | AAPL | Stock | 3.6054 | 3.6054 | 3.6054 | 3.6054 | 2800.0 |
| 2009-03-20 08:22:00 | AAPL | Stock | 3.6071 | 3.6086 | 3.6071 | 3.6086 | 32564.0 |
| 2009-03-20 08:24:00 | AAPL | Stock | 3.6143 | 3.6143 | 3.6143 | 3.6143 | 2800.0 |
| 2009-03-20 08:25:00 | AAPL | Stock | 3.6179 | 3.6179 | 3.6179 | 3.6179 | 16800.0 |
| 2009-03-20 08:31:00 | AAPL | Stock | 3.6211 | 3.6211 | 3.6211 | 3.6211 | 2800.0 |
| 2009-03-20 08:36:00 | AAPL | Stock | 3.6179 | 3.6214 | 3.6179 | 3.6214 | 5600.0 |
| 2009-03-20 08:37:00 | AAPL | Stock | 3.6214 | 3.6214 | 3.6214 | 3.6214 | 14000.0 |
| 2009-03-20 08:39:00 | AAPL | Stock | 3.6204 | 3.6243 | 3.6204 | 3.6243 | 8400.0 |
| 2009-03-20 08:40:00 | AAPL | Stock | 3.6254 | 3.6254 | 3.6254 | 3.6254 | 2800.0 |
| 2009-03-20 08:41:00 | AAPL | Stock | 3.6254 | 3.6268 | 3.6254 | 3.6268 | 50400.0 |
| 2009-03-20 08:49:00 | AAPL | Stock | 3.6232 | 3.6232 | 3.6232 | 3.6232 | 5656.0 |
| 2009-03-20 08:55:00 | AAPL | Stock | 3.6232 | 3.6232 | 3.6232 | 3.6232 | 11200.0 |
| 2009-03-20 08:56:00 | AAPL | Stock | 3.6232 | 3.6232 | 3.6232 | 3.6232 | 2800.0 |
| 2009-03-20 09:00:00 | AAPL | Stock | 3.6214 | 3.6214 | 3.6214 | 3.6214 | 2800.0 |
| 2009-03-20 09:06:00 | AAPL | Stock | 3.625 | 3.625 | 3.6246 | 3.625 | 51940.0 |
| 2009-03-20 09:09:00 | AAPL | Stock | 3.6196 | 3.6196 | 3.6196 | 3.6196 | 2800.0 |
| 2009-03-20 09:12:00 | AAPL | Stock | 3.6204 | 3.6204 | 3.6204 | 3.6204 | 8400.0 |
| 2009-03-20 09:13:00 | AAPL | Stock | 3.6207 | 3.6211 | 3.6204 | 3.6204 | 16800.0 |
| 2009-03-20 09:18:00 | AAPL | Stock | 3.6236 | 3.6236 | 3.6236 | 3.6236 | 16800.0 |
| 2009-03-20 09:19:00 | AAPL | Stock | 3.6236 | 3.6236 | 3.6236 | 3.6236 | 2800.0 |
| 2009-03-20 09:21:00 | AAPL | Stock | 3.6236 | 3.6236 | 3.6236 | 3.6236 | 14000.0 |
| 2009-03-20 09:24:00 | AAPL | Stock | 3.625 | 3.625 | 3.6236 | 3.6236 | 5600.0 |
| 2009-03-20 09:25:00 | AAPL | Stock | 3.625 | 3.6304 | 3.625 | 3.6304 | 128044.0 |
| 2009-03-20 09:26:00 | AAPL | Stock | 3.6332 | 3.6339 | 3.6268 | 3.6268 | 82600.0 |
| 2009-03-20 09:27:00 | AAPL | Stock | 3.6268 | 3.6268 | 3.6236 | 3.6236 | 50512.0 |
| 2009-03-20 09:28:00 | AAPL | Stock | 3.6275 | 3.6429 | 3.6261 | 3.6411 | 643412.0 |
| 2009-03-20 09:29:00 | AAPL | Stock | 3.6393 | 3.645 | 3.6375 | 3.6429 | 603092.0 |
| 2009-03-20 09:30:00 | AAPL | Stock | 3.6429 | 3.6482 | 3.6332 | 3.6414 | 4669784.0 |
| 2009-03-20 09:31:00 | AAPL | Stock | 3.6425 | 3.6539 | 3.6404 | 3.6454 | 2593724.0 |
| 2009-03-20 09:32:00 | AAPL | Stock | 3.6457 | 3.6564 | 3.6411 | 3.6546 | 3519348.0 |
| 2009-03-20 09:33:00 | AAPL | Stock | 3.6539 | 3.66 | 3.6511 | 3.6525 | 2805992.0 |
| 2009-03-20 09:34:00 | AAPL | Stock | 3.6529 | 3.6625 | 3.6504 | 3.6575 | 3676316.0 |
| 2009-03-20 09:35:00 | AAPL | Stock | 3.6571 | 3.6575 | 3.6464 | 3.6554 | 2500120.0 |
| 2009-03-20 09:36:00 | AAPL | Stock | 3.6561 | 3.6625 | 3.655 | 3.6552 | 3060484.0 |
| 2009-03-20 09:37:00 | AAPL | Stock | 3.6571 | 3.6671 | 3.6546 | 3.6657 | 2969624.0 |
| 2009-03-20 09:38:00 | AAPL | Stock | 3.6664 | 3.6671 | 3.6482 | 3.6489 | 3288880.0 |
| 2009-03-20 09:39:00 | AAPL | Stock | 3.6489 | 3.6568 | 3.6486 | 3.6546 | 1694000.0 |
| 2009-03-20 09:40:00 | AAPL | Stock | 3.6543 | 3.6561 | 3.6471 | 3.6486 | 2474164.0 |
| 2009-03-20 09:41:00 | AAPL | Stock | 3.6482 | 3.6486 | 3.6404 | 3.6418 | 3131184.0 |
| 2009-03-20 09:42:00 | AAPL | Stock | 3.6414 | 3.6436 | 3.6371 | 3.6404 | 2686348.0 |
| 2009-03-20 09:43:00 | AAPL | Stock | 3.6398 | 3.6429 | 3.6361 | 3.6429 | 1422820.0 |
| 2009-03-20 09:44:00 | AAPL | Stock | 3.6429 | 3.6468 | 3.6386 | 3.6454 | 2355808.0 |
> showing 50 of 938,457 rows — these rows as CSV