PREVIEW / stock_1min / 2011-01-21
file: by_date/stock_1min/2011/2011-01-21.parquet size: 13.3 MB rows: 995,431 symbols: 2,861
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 |
|---|---|---|---|---|---|---|---|
| 2011-01-21 04:25:00 | AAPL | Stock | 11.9118 | 11.9118 | 11.9118 | 11.9118 | 5600.0 |
| 2011-01-21 04:50:00 | AAPL | Stock | 11.9064 | 11.9064 | 11.9064 | 11.9064 | 5600.0 |
| 2011-01-21 05:04:00 | AAPL | Stock | 11.9064 | 11.9064 | 11.9064 | 11.9064 | 2800.0 |
| 2011-01-21 05:29:00 | AAPL | Stock | 11.9471 | 11.9536 | 11.9471 | 11.9536 | 11200.0 |
| 2011-01-21 05:57:00 | AAPL | Stock | 11.9425 | 11.9425 | 11.9425 | 11.9425 | 5600.0 |
| 2011-01-21 05:58:00 | AAPL | Stock | 11.9429 | 11.9429 | 11.9429 | 11.9429 | 2800.0 |
| 2011-01-21 06:04:00 | AAPL | Stock | 11.9429 | 11.9429 | 11.9429 | 11.9429 | 5600.0 |
| 2011-01-21 06:05:00 | AAPL | Stock | 11.9429 | 11.9429 | 11.9429 | 11.9429 | 5600.0 |
| 2011-01-21 06:17:00 | AAPL | Stock | 11.9436 | 11.9536 | 11.9436 | 11.9536 | 5600.0 |
| 2011-01-21 06:25:00 | AAPL | Stock | 11.9464 | 11.9464 | 11.9464 | 11.9464 | 5600.0 |
| 2011-01-21 06:36:00 | AAPL | Stock | 11.9464 | 11.9464 | 11.9464 | 11.9464 | 4200.0 |
| 2011-01-21 06:44:00 | AAPL | Stock | 11.9536 | 11.9536 | 11.9536 | 11.9536 | 2800.0 |
| 2011-01-21 06:47:00 | AAPL | Stock | 11.9536 | 11.9536 | 11.9536 | 11.9536 | 5600.0 |
| 2011-01-21 07:01:00 | AAPL | Stock | 11.9507 | 11.9507 | 11.9468 | 11.9468 | 8400.0 |
| 2011-01-21 07:02:00 | AAPL | Stock | 11.9468 | 11.9471 | 11.9411 | 11.9464 | 22232.0 |
| 2011-01-21 07:03:00 | AAPL | Stock | 11.9432 | 11.9432 | 11.9432 | 11.9432 | 11368.0 |
| 2011-01-21 07:04:00 | AAPL | Stock | 11.9432 | 11.9432 | 11.9432 | 11.9432 | 39032.0 |
| 2011-01-21 07:05:00 | AAPL | Stock | 11.9432 | 11.9436 | 11.9393 | 11.9436 | 16800.0 |
| 2011-01-21 07:06:00 | AAPL | Stock | 11.9471 | 11.9471 | 11.9471 | 11.9471 | 8400.0 |
| 2011-01-21 07:07:00 | AAPL | Stock | 11.9429 | 11.9429 | 11.9429 | 11.9429 | 16800.0 |
| 2011-01-21 07:08:00 | AAPL | Stock | 11.9464 | 11.9471 | 11.9464 | 11.9471 | 15120.0 |
| 2011-01-21 07:13:00 | AAPL | Stock | 11.9418 | 11.9418 | 11.9396 | 11.9396 | 11200.0 |
| 2011-01-21 07:17:00 | AAPL | Stock | 11.9461 | 11.9461 | 11.9461 | 11.9461 | 2800.0 |
| 2011-01-21 07:18:00 | AAPL | Stock | 11.9389 | 11.9389 | 11.9389 | 11.9389 | 2800.0 |
| 2011-01-21 07:20:00 | AAPL | Stock | 11.9411 | 11.9411 | 11.9411 | 11.9411 | 11200.0 |
| 2011-01-21 07:21:00 | AAPL | Stock | 11.9407 | 11.9407 | 11.9407 | 11.9407 | 2800.0 |
| 2011-01-21 07:22:00 | AAPL | Stock | 11.9407 | 11.9407 | 11.9389 | 11.9389 | 16548.0 |
| 2011-01-21 07:26:00 | AAPL | Stock | 11.9407 | 11.9407 | 11.9407 | 11.9407 | 8400.0 |
| 2011-01-21 07:31:00 | AAPL | Stock | 11.9354 | 11.9354 | 11.9354 | 11.9354 | 2800.0 |
| 2011-01-21 07:32:00 | AAPL | Stock | 11.9375 | 11.9375 | 11.9375 | 11.9375 | 2800.0 |
| 2011-01-21 07:35:00 | AAPL | Stock | 11.9393 | 11.9393 | 11.9286 | 11.9286 | 5600.0 |
| 2011-01-21 07:36:00 | AAPL | Stock | 11.9389 | 11.9393 | 11.9389 | 11.9393 | 28000.0 |
| 2011-01-21 07:37:00 | AAPL | Stock | 11.9389 | 11.9393 | 11.9389 | 11.9393 | 50988.0 |
| 2011-01-21 07:39:00 | AAPL | Stock | 11.9407 | 11.9407 | 11.9379 | 11.9379 | 9100.0 |
| 2011-01-21 07:41:00 | AAPL | Stock | 11.9389 | 11.9389 | 11.9357 | 11.9357 | 5600.0 |
| 2011-01-21 07:43:00 | AAPL | Stock | 11.9357 | 11.9357 | 11.9357 | 11.9357 | 8400.0 |
| 2011-01-21 07:44:00 | AAPL | Stock | 11.9357 | 11.9357 | 11.9357 | 11.9357 | 22400.0 |
| 2011-01-21 07:45:00 | AAPL | Stock | 11.9389 | 11.9393 | 11.9389 | 11.9393 | 25200.0 |
| 2011-01-21 07:46:00 | AAPL | Stock | 11.9411 | 11.9461 | 11.9404 | 11.9461 | 46760.0 |
| 2011-01-21 07:50:00 | AAPL | Stock | 11.9446 | 11.9446 | 11.9411 | 11.9411 | 19600.0 |
| 2011-01-21 07:51:00 | AAPL | Stock | 11.9425 | 11.9425 | 11.9425 | 11.9425 | 14000.0 |
| 2011-01-21 07:53:00 | AAPL | Stock | 11.9461 | 11.9464 | 11.9461 | 11.9464 | 16520.0 |
| 2011-01-21 07:54:00 | AAPL | Stock | 11.9414 | 11.9414 | 11.9411 | 11.9414 | 16800.0 |
| 2011-01-21 07:57:00 | AAPL | Stock | 11.9439 | 11.9439 | 11.9411 | 11.9411 | 8400.0 |
| 2011-01-21 07:58:00 | AAPL | Stock | 11.9411 | 11.9411 | 11.9411 | 11.9411 | 28000.0 |
| 2011-01-21 07:59:00 | AAPL | Stock | 11.9411 | 11.9464 | 11.9411 | 11.9464 | 33096.0 |
| 2011-01-21 08:00:00 | AAPL | Stock | 11.9429 | 11.9529 | 11.9329 | 11.9518 | 148232.0 |
| 2011-01-21 08:01:00 | AAPL | Stock | 11.9511 | 11.9525 | 11.9468 | 11.9493 | 79072.0 |
| 2011-01-21 08:02:00 | AAPL | Stock | 11.9464 | 11.9536 | 11.9375 | 11.9457 | 335524.0 |
| 2011-01-21 08:03:00 | AAPL | Stock | 11.9436 | 11.9464 | 11.9396 | 11.9396 | 78736.0 |
> showing 50 of 995,431 rows — these rows as CSV