PREVIEW / stock_1min / 2012-09-13
file: by_date/stock_1min/2012/2012-09-13.parquet size: 13.4 MB rows: 980,566 symbols: 2,813
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-13 04:06:00 | AAPL | Stock | 23.9161 | 23.9161 | 23.9075 | 23.9075 | 8400.0 |
| 2012-09-13 04:08:00 | AAPL | Stock | 23.8932 | 23.8932 | 23.8932 | 23.8932 | 2800.0 |
| 2012-09-13 04:09:00 | AAPL | Stock | 23.8932 | 23.8932 | 23.8932 | 23.8932 | 7560.0 |
| 2012-09-13 04:23:00 | AAPL | Stock | 23.9107 | 23.9107 | 23.9107 | 23.9107 | 2800.0 |
| 2012-09-13 04:27:00 | AAPL | Stock | 23.9286 | 23.9286 | 23.9286 | 23.9286 | 2800.0 |
| 2012-09-13 04:29:00 | AAPL | Stock | 23.9289 | 23.9289 | 23.9289 | 23.9289 | 2800.0 |
| 2012-09-13 04:40:00 | AAPL | Stock | 23.9286 | 23.9286 | 23.9286 | 23.9286 | 10668.0 |
| 2012-09-13 04:42:00 | AAPL | Stock | 23.9464 | 23.9464 | 23.9464 | 23.9464 | 5600.0 |
| 2012-09-13 04:47:00 | AAPL | Stock | 23.9464 | 23.9464 | 23.9464 | 23.9464 | 11200.0 |
| 2012-09-13 04:50:00 | AAPL | Stock | 23.9464 | 23.9464 | 23.9464 | 23.9464 | 84000.0 |
| 2012-09-13 04:51:00 | AAPL | Stock | 23.9643 | 23.9643 | 23.9643 | 23.9643 | 14000.0 |
| 2012-09-13 04:57:00 | AAPL | Stock | 23.9646 | 23.9646 | 23.9646 | 23.9646 | 2800.0 |
| 2012-09-13 05:04:00 | AAPL | Stock | 23.9679 | 23.9679 | 23.9679 | 23.9679 | 5600.0 |
| 2012-09-13 05:10:00 | AAPL | Stock | 23.9721 | 23.9721 | 23.9721 | 23.9721 | 2800.0 |
| 2012-09-13 05:13:00 | AAPL | Stock | 23.9811 | 23.9811 | 23.9811 | 23.9811 | 2800.0 |
| 2012-09-13 05:17:00 | AAPL | Stock | 23.9911 | 23.9911 | 23.9911 | 23.9911 | 2800.0 |
| 2012-09-13 05:21:00 | AAPL | Stock | 24.0 | 24.0 | 24.0 | 24.0 | 2800.0 |
| 2012-09-13 05:22:00 | AAPL | Stock | 24.0 | 24.0 | 24.0 | 24.0 | 2800.0 |
| 2012-09-13 05:26:00 | AAPL | Stock | 23.9825 | 23.9825 | 23.9825 | 23.9825 | 2800.0 |
| 2012-09-13 05:28:00 | AAPL | Stock | 23.9821 | 23.9821 | 23.9821 | 23.9821 | 2800.0 |
| 2012-09-13 05:36:00 | AAPL | Stock | 24.0 | 24.0 | 24.0 | 24.0 | 9380.0 |
| 2012-09-13 05:38:00 | AAPL | Stock | 23.9821 | 23.9821 | 23.9821 | 23.9821 | 2800.0 |
| 2012-09-13 05:40:00 | AAPL | Stock | 23.9821 | 23.9821 | 23.9821 | 23.9821 | 2800.0 |
| 2012-09-13 05:46:00 | AAPL | Stock | 23.9857 | 23.9857 | 23.9857 | 23.9857 | 2800.0 |
| 2012-09-13 05:49:00 | AAPL | Stock | 24.0 | 24.0 | 24.0 | 24.0 | 8400.0 |
| 2012-09-13 05:51:00 | AAPL | Stock | 24.0 | 24.0143 | 24.0 | 24.0143 | 5600.0 |
| 2012-09-13 05:52:00 | AAPL | Stock | 24.0 | 24.0 | 24.0 | 24.0 | 5600.0 |
| 2012-09-13 05:53:00 | AAPL | Stock | 24.0143 | 24.0143 | 24.0143 | 24.0143 | 8400.0 |
| 2012-09-13 05:55:00 | AAPL | Stock | 24.0 | 24.0 | 24.0 | 24.0 | 2800.0 |
| 2012-09-13 05:57:00 | AAPL | Stock | 24.0 | 24.0 | 24.0 | 24.0 | 2800.0 |
| 2012-09-13 06:00:00 | AAPL | Stock | 23.9857 | 23.9996 | 23.9857 | 23.9857 | 18704.0 |
| 2012-09-13 06:04:00 | AAPL | Stock | 23.9821 | 23.9821 | 23.9821 | 23.9821 | 13076.0 |
| 2012-09-13 06:08:00 | AAPL | Stock | 23.9996 | 23.9996 | 23.9996 | 23.9996 | 2800.0 |
| 2012-09-13 06:13:00 | AAPL | Stock | 23.9982 | 23.9996 | 23.9982 | 23.9996 | 11200.0 |
| 2012-09-13 06:16:00 | AAPL | Stock | 23.9996 | 23.9996 | 23.9996 | 23.9996 | 2800.0 |
| 2012-09-13 06:39:00 | AAPL | Stock | 24.0143 | 24.0143 | 24.0143 | 24.0143 | 5600.0 |
| 2012-09-13 06:41:00 | AAPL | Stock | 24.0143 | 24.0143 | 24.0143 | 24.0143 | 5600.0 |
| 2012-09-13 06:42:00 | AAPL | Stock | 24.0143 | 24.0143 | 24.0143 | 24.0143 | 8400.0 |
| 2012-09-13 06:50:00 | AAPL | Stock | 24.0232 | 24.0232 | 24.0232 | 24.0232 | 2800.0 |
| 2012-09-13 06:51:00 | AAPL | Stock | 24.0146 | 24.0146 | 24.0146 | 24.0146 | 2800.0 |
| 2012-09-13 06:54:00 | AAPL | Stock | 24.0146 | 24.0146 | 24.0146 | 24.0146 | 14000.0 |
| 2012-09-13 06:56:00 | AAPL | Stock | 24.0079 | 24.0079 | 24.0 | 24.0 | 8400.0 |
| 2012-09-13 06:57:00 | AAPL | Stock | 24.0 | 24.0 | 23.9911 | 23.9911 | 14000.0 |
| 2012-09-13 06:58:00 | AAPL | Stock | 23.9907 | 23.9907 | 23.9907 | 23.9907 | 2800.0 |
| 2012-09-13 07:00:00 | AAPL | Stock | 23.9875 | 24.0121 | 23.9875 | 23.9996 | 16940.0 |
| 2012-09-13 07:03:00 | AAPL | Stock | 24.0096 | 24.0096 | 24.0096 | 24.0096 | 2800.0 |
| 2012-09-13 07:04:00 | AAPL | Stock | 24.0107 | 24.0143 | 24.0107 | 24.0143 | 5964.0 |
| 2012-09-13 07:05:00 | AAPL | Stock | 24.0171 | 24.0171 | 24.0171 | 24.0171 | 2800.0 |
| 2012-09-13 07:06:00 | AAPL | Stock | 24.0164 | 24.0339 | 24.0164 | 24.0336 | 78400.0 |
| 2012-09-13 07:07:00 | AAPL | Stock | 24.0332 | 24.0332 | 24.0214 | 24.0214 | 54040.0 |
> showing 50 of 980,566 rows — these rows as CSV