PREVIEW / stock_1min / 2012-02-17
file: by_date/stock_1min/2012/2012-02-17.parquet size: 12.7 MB rows: 938,579 symbols: 2,885
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-02-17 04:00:00 | AAPL | Stock | 18.0443 | 18.0532 | 18.0443 | 18.0532 | 15400.0 |
| 2012-02-17 04:02:00 | AAPL | Stock | 18.0789 | 18.0789 | 18.0714 | 18.0714 | 16800.0 |
| 2012-02-17 04:06:00 | AAPL | Stock | 18.0893 | 18.0893 | 18.0893 | 18.0893 | 4200.0 |
| 2012-02-17 04:11:00 | AAPL | Stock | 18.1064 | 18.1068 | 18.1064 | 18.1068 | 8400.0 |
| 2012-02-17 04:20:00 | AAPL | Stock | 18.1068 | 18.1068 | 18.1068 | 18.1068 | 2800.0 |
| 2012-02-17 04:21:00 | AAPL | Stock | 18.1025 | 18.1025 | 18.0939 | 18.1025 | 16800.0 |
| 2012-02-17 04:32:00 | AAPL | Stock | 18.0857 | 18.0857 | 18.0857 | 18.0857 | 2800.0 |
| 2012-02-17 04:33:00 | AAPL | Stock | 18.0829 | 18.0829 | 18.0796 | 18.0796 | 11200.0 |
| 2012-02-17 04:34:00 | AAPL | Stock | 18.0761 | 18.0761 | 18.0714 | 18.0714 | 16800.0 |
| 2012-02-17 04:36:00 | AAPL | Stock | 18.0914 | 18.1071 | 18.0914 | 18.1071 | 8400.0 |
| 2012-02-17 04:37:00 | AAPL | Stock | 18.0986 | 18.0986 | 18.0857 | 18.0857 | 15400.0 |
| 2012-02-17 04:39:00 | AAPL | Stock | 18.0968 | 18.0968 | 18.0893 | 18.0893 | 25200.0 |
| 2012-02-17 04:40:00 | AAPL | Stock | 18.0893 | 18.0893 | 18.0893 | 18.0893 | 8400.0 |
| 2012-02-17 04:41:00 | AAPL | Stock | 18.0893 | 18.0893 | 18.0893 | 18.0893 | 2800.0 |
| 2012-02-17 04:42:00 | AAPL | Stock | 18.0893 | 18.0893 | 18.0893 | 18.0893 | 9800.0 |
| 2012-02-17 04:49:00 | AAPL | Stock | 18.0779 | 18.0779 | 18.0732 | 18.0732 | 8400.0 |
| 2012-02-17 04:51:00 | AAPL | Stock | 18.0729 | 18.0729 | 18.0729 | 18.0729 | 5600.0 |
| 2012-02-17 04:53:00 | AAPL | Stock | 18.0811 | 18.0811 | 18.0729 | 18.0729 | 28560.0 |
| 2012-02-17 04:54:00 | AAPL | Stock | 18.0661 | 18.0696 | 18.0661 | 18.0696 | 14000.0 |
| 2012-02-17 04:55:00 | AAPL | Stock | 18.0643 | 18.0643 | 18.0518 | 18.0518 | 37660.0 |
| 2012-02-17 05:01:00 | AAPL | Stock | 18.0604 | 18.0604 | 18.0561 | 18.0561 | 11200.0 |
| 2012-02-17 05:09:00 | AAPL | Stock | 18.0589 | 18.0589 | 18.0589 | 18.0589 | 5600.0 |
| 2012-02-17 05:10:00 | AAPL | Stock | 18.0571 | 18.0571 | 18.0571 | 18.0571 | 5600.0 |
| 2012-02-17 05:11:00 | AAPL | Stock | 18.0554 | 18.0554 | 18.0464 | 18.0464 | 12600.0 |
| 2012-02-17 05:15:00 | AAPL | Stock | 18.0436 | 18.0436 | 18.0357 | 18.0357 | 21364.0 |
| 2012-02-17 05:16:00 | AAPL | Stock | 18.035 | 18.035 | 18.035 | 18.035 | 2800.0 |
| 2012-02-17 05:23:00 | AAPL | Stock | 18.0396 | 18.0396 | 18.0396 | 18.0396 | 5600.0 |
| 2012-02-17 05:24:00 | AAPL | Stock | 18.0243 | 18.0243 | 18.0243 | 18.0243 | 2800.0 |
| 2012-02-17 05:28:00 | AAPL | Stock | 18.0204 | 18.0204 | 18.0204 | 18.0204 | 14000.0 |
| 2012-02-17 05:29:00 | AAPL | Stock | 18.0204 | 18.0204 | 18.0204 | 18.0204 | 2800.0 |
| 2012-02-17 05:49:00 | AAPL | Stock | 18.0275 | 18.0275 | 18.0275 | 18.0275 | 9800.0 |
| 2012-02-17 05:50:00 | AAPL | Stock | 18.0239 | 18.0239 | 18.0239 | 18.0239 | 2800.0 |
| 2012-02-17 05:53:00 | AAPL | Stock | 18.0268 | 18.0268 | 18.0268 | 18.0268 | 2800.0 |
| 2012-02-17 05:55:00 | AAPL | Stock | 18.0268 | 18.0268 | 18.0268 | 18.0268 | 2800.0 |
| 2012-02-17 06:03:00 | AAPL | Stock | 18.0357 | 18.0357 | 18.0357 | 18.0357 | 5600.0 |
| 2012-02-17 06:09:00 | AAPL | Stock | 18.0446 | 18.0446 | 18.0446 | 18.0446 | 2800.0 |
| 2012-02-17 06:14:00 | AAPL | Stock | 18.0357 | 18.0357 | 18.0357 | 18.0357 | 14000.0 |
| 2012-02-17 06:19:00 | AAPL | Stock | 18.0446 | 18.0446 | 18.0446 | 18.0446 | 5600.0 |
| 2012-02-17 06:44:00 | AAPL | Stock | 18.0393 | 18.0393 | 18.0393 | 18.0393 | 9660.0 |
| 2012-02-17 06:49:00 | AAPL | Stock | 18.0357 | 18.0357 | 18.0357 | 18.0357 | 19600.0 |
| 2012-02-17 06:50:00 | AAPL | Stock | 18.0357 | 18.0357 | 18.0357 | 18.0357 | 22400.0 |
| 2012-02-17 06:51:00 | AAPL | Stock | 18.0357 | 18.0357 | 18.0357 | 18.0357 | 2800.0 |
| 2012-02-17 06:55:00 | AAPL | Stock | 18.0268 | 18.0268 | 18.0268 | 18.0268 | 14000.0 |
| 2012-02-17 07:00:00 | AAPL | Stock | 18.0179 | 18.0214 | 18.0054 | 18.0054 | 34720.0 |
| 2012-02-17 07:01:00 | AAPL | Stock | 18.0175 | 18.0179 | 18.0 | 18.0 | 25760.0 |
| 2012-02-17 07:03:00 | AAPL | Stock | 18.0 | 18.0 | 18.0 | 18.0 | 22400.0 |
| 2012-02-17 07:05:00 | AAPL | Stock | 17.9875 | 17.9875 | 17.9875 | 17.9875 | 2800.0 |
| 2012-02-17 07:06:00 | AAPL | Stock | 18.0057 | 18.0057 | 18.0057 | 18.0057 | 8400.0 |
| 2012-02-17 07:07:00 | AAPL | Stock | 18.0057 | 18.0057 | 18.0057 | 18.0057 | 2800.0 |
| 2012-02-17 07:12:00 | AAPL | Stock | 18.0132 | 18.0179 | 18.0121 | 18.0179 | 22736.0 |
> showing 50 of 938,579 rows — these rows as CSV