PREVIEW / stock_1min / 2012-09-11
file: by_date/stock_1min/2012/2012-09-11.parquet size: 12.1 MB rows: 895,579 symbols: 2,806
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 |
|---|---|---|---|---|---|---|---|
| 2012-09-11 04:00:00 | AAPL | Stock | 23.6261 | 23.6357 | 23.6261 | 23.6357 | 19600.0 |
| 2012-09-11 04:01:00 | AAPL | Stock | 23.6357 | 23.6357 | 23.6357 | 23.6357 | 22400.0 |
| 2012-09-11 04:02:00 | AAPL | Stock | 23.6357 | 23.6357 | 23.6357 | 23.6357 | 9240.0 |
| 2012-09-11 04:03:00 | AAPL | Stock | 23.6357 | 23.6357 | 23.6357 | 23.6357 | 2800.0 |
| 2012-09-11 04:04:00 | AAPL | Stock | 23.6357 | 23.6357 | 23.6357 | 23.6357 | 2800.0 |
| 2012-09-11 04:07:00 | AAPL | Stock | 23.6357 | 23.6357 | 23.6357 | 23.6357 | 13916.0 |
| 2012-09-11 04:08:00 | AAPL | Stock | 23.6357 | 23.6357 | 23.6357 | 23.6357 | 28000.0 |
| 2012-09-11 04:09:00 | AAPL | Stock | 23.6429 | 23.6429 | 23.6429 | 23.6429 | 4200.0 |
| 2012-09-11 04:14:00 | AAPL | Stock | 23.6393 | 23.6393 | 23.6393 | 23.6393 | 8400.0 |
| 2012-09-11 04:18:00 | AAPL | Stock | 23.6393 | 23.6393 | 23.6393 | 23.6393 | 5600.0 |
| 2012-09-11 04:34:00 | AAPL | Stock | 23.6554 | 23.6554 | 23.6554 | 23.6554 | 2800.0 |
| 2012-09-11 04:47:00 | AAPL | Stock | 23.6743 | 23.6743 | 23.6743 | 23.6743 | 5600.0 |
| 2012-09-11 04:49:00 | AAPL | Stock | 23.6743 | 23.6743 | 23.6743 | 23.6743 | 14000.0 |
| 2012-09-11 04:51:00 | AAPL | Stock | 23.6743 | 23.6743 | 23.6743 | 23.6743 | 22288.0 |
| 2012-09-11 04:56:00 | AAPL | Stock | 23.6786 | 23.6786 | 23.6786 | 23.6786 | 19600.0 |
| 2012-09-11 05:17:00 | AAPL | Stock | 23.6964 | 23.6964 | 23.6964 | 23.6964 | 9520.0 |
| 2012-09-11 05:23:00 | AAPL | Stock | 23.6986 | 23.6986 | 23.6986 | 23.6986 | 2800.0 |
| 2012-09-11 05:25:00 | AAPL | Stock | 23.6789 | 23.7143 | 23.6789 | 23.7143 | 21000.0 |
| 2012-09-11 05:26:00 | AAPL | Stock | 23.7196 | 23.7196 | 23.7196 | 23.7196 | 5600.0 |
| 2012-09-11 05:37:00 | AAPL | Stock | 23.7107 | 23.7107 | 23.7107 | 23.7107 | 6300.0 |
| 2012-09-11 05:38:00 | AAPL | Stock | 23.7071 | 23.7071 | 23.7071 | 23.7071 | 21700.0 |
| 2012-09-11 05:47:00 | AAPL | Stock | 23.7143 | 23.7143 | 23.7143 | 23.7143 | 2800.0 |
| 2012-09-11 05:58:00 | AAPL | Stock | 23.7143 | 23.7143 | 23.7143 | 23.7143 | 2800.0 |
| 2012-09-11 06:04:00 | AAPL | Stock | 23.6893 | 23.6893 | 23.6893 | 23.6893 | 5600.0 |
| 2012-09-11 06:06:00 | AAPL | Stock | 23.6893 | 23.6893 | 23.6786 | 23.6786 | 12600.0 |
| 2012-09-11 06:09:00 | AAPL | Stock | 23.6786 | 23.6786 | 23.6786 | 23.6786 | 16996.0 |
| 2012-09-11 06:10:00 | AAPL | Stock | 23.6786 | 23.6786 | 23.6786 | 23.6786 | 2800.0 |
| 2012-09-11 06:29:00 | AAPL | Stock | 23.7143 | 23.7279 | 23.7143 | 23.7279 | 19600.0 |
| 2012-09-11 06:32:00 | AAPL | Stock | 23.7411 | 23.7411 | 23.7411 | 23.7411 | 2800.0 |
| 2012-09-11 06:36:00 | AAPL | Stock | 23.7321 | 23.7321 | 23.7143 | 23.7143 | 14000.0 |
| 2012-09-11 06:38:00 | AAPL | Stock | 23.7318 | 23.7321 | 23.7314 | 23.7314 | 10360.0 |
| 2012-09-11 06:39:00 | AAPL | Stock | 23.7321 | 23.7321 | 23.7321 | 23.7321 | 2800.0 |
| 2012-09-11 06:40:00 | AAPL | Stock | 23.7321 | 23.7321 | 23.7321 | 23.7321 | 2800.0 |
| 2012-09-11 06:41:00 | AAPL | Stock | 23.7321 | 23.7321 | 23.7321 | 23.7321 | 2800.0 |
| 2012-09-11 06:42:00 | AAPL | Stock | 23.7393 | 23.7393 | 23.7393 | 23.7393 | 2800.0 |
| 2012-09-11 06:43:00 | AAPL | Stock | 23.745 | 23.745 | 23.745 | 23.745 | 2800.0 |
| 2012-09-11 06:46:00 | AAPL | Stock | 23.75 | 23.75 | 23.7411 | 23.7411 | 8400.0 |
| 2012-09-11 06:54:00 | AAPL | Stock | 23.7321 | 23.7321 | 23.7321 | 23.7321 | 2800.0 |
| 2012-09-11 06:58:00 | AAPL | Stock | 23.7446 | 23.7446 | 23.7446 | 23.7446 | 5600.0 |
| 2012-09-11 07:00:00 | AAPL | Stock | 23.7464 | 23.7468 | 23.7464 | 23.7468 | 8400.0 |
| 2012-09-11 07:01:00 | AAPL | Stock | 23.7321 | 23.7457 | 23.7321 | 23.7457 | 11200.0 |
| 2012-09-11 07:02:00 | AAPL | Stock | 23.7411 | 23.7432 | 23.7411 | 23.7432 | 5600.0 |
| 2012-09-11 07:03:00 | AAPL | Stock | 23.7482 | 23.7693 | 23.7482 | 23.7693 | 22960.0 |
| 2012-09-11 07:04:00 | AAPL | Stock | 23.7607 | 23.7607 | 23.7496 | 23.75 | 42000.0 |
| 2012-09-11 07:05:00 | AAPL | Stock | 23.7504 | 23.7504 | 23.7504 | 23.7504 | 2800.0 |
| 2012-09-11 07:06:00 | AAPL | Stock | 23.75 | 23.7604 | 23.7446 | 23.75 | 36400.0 |
| 2012-09-11 07:09:00 | AAPL | Stock | 23.7446 | 23.75 | 23.7339 | 23.7339 | 18200.0 |
| 2012-09-11 07:10:00 | AAPL | Stock | 23.7393 | 23.7393 | 23.7321 | 23.7321 | 11200.0 |
| 2012-09-11 07:11:00 | AAPL | Stock | 23.7289 | 23.7289 | 23.7286 | 23.7286 | 5600.0 |
| 2012-09-11 07:12:00 | AAPL | Stock | 23.7179 | 23.7179 | 23.7179 | 23.7179 | 2800.0 |
> showing 50 of 895,579 rows — these rows as CSV