PREVIEW / stock_1min / 2012-03-28
file: by_date/stock_1min/2012/2012-03-28.parquet size: 13.2 MB rows: 977,368 symbols: 2,849
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-03-28 04:02:00 | AAPL | Stock | 21.9657 | 21.9657 | 21.9657 | 21.9657 | 2800.0 |
| 2012-03-28 04:15:00 | AAPL | Stock | 22.0343 | 22.0343 | 22.0343 | 22.0343 | 11200.0 |
| 2012-03-28 04:17:00 | AAPL | Stock | 22.0343 | 22.0343 | 22.0343 | 22.0343 | 2800.0 |
| 2012-03-28 04:19:00 | AAPL | Stock | 22.0343 | 22.0346 | 22.0343 | 22.0346 | 15400.0 |
| 2012-03-28 04:44:00 | AAPL | Stock | 22.0107 | 22.0107 | 22.0107 | 22.0107 | 14000.0 |
| 2012-03-28 04:52:00 | AAPL | Stock | 21.9761 | 21.9761 | 21.9732 | 21.9732 | 11060.0 |
| 2012-03-28 04:53:00 | AAPL | Stock | 22.0 | 22.0 | 22.0 | 22.0 | 12040.0 |
| 2012-03-28 04:54:00 | AAPL | Stock | 22.0061 | 22.0061 | 22.0061 | 22.0061 | 2800.0 |
| 2012-03-28 04:58:00 | AAPL | Stock | 22.0 | 22.0 | 22.0 | 22.0 | 7000.0 |
| 2012-03-28 04:59:00 | AAPL | Stock | 22.0 | 22.0 | 22.0 | 22.0 | 19600.0 |
| 2012-03-28 05:23:00 | AAPL | Stock | 21.9754 | 21.9754 | 21.9754 | 21.9754 | 2800.0 |
| 2012-03-28 05:25:00 | AAPL | Stock | 22.0 | 22.0 | 22.0 | 22.0 | 11200.0 |
| 2012-03-28 05:29:00 | AAPL | Stock | 22.0054 | 22.0054 | 22.0054 | 22.0054 | 8400.0 |
| 2012-03-28 05:47:00 | AAPL | Stock | 22.0 | 22.0 | 22.0 | 22.0 | 2800.0 |
| 2012-03-28 05:51:00 | AAPL | Stock | 21.9811 | 21.9811 | 21.9811 | 21.9811 | 2800.0 |
| 2012-03-28 05:53:00 | AAPL | Stock | 22.0025 | 22.0032 | 22.0025 | 22.0032 | 5600.0 |
| 2012-03-28 05:54:00 | AAPL | Stock | 22.0007 | 22.0032 | 22.0007 | 22.0032 | 11200.0 |
| 2012-03-28 05:55:00 | AAPL | Stock | 22.0018 | 22.0032 | 22.0018 | 22.0032 | 8400.0 |
| 2012-03-28 05:59:00 | AAPL | Stock | 22.0036 | 22.0036 | 22.0036 | 22.0036 | 3920.0 |
| 2012-03-28 06:02:00 | AAPL | Stock | 22.0014 | 22.0014 | 22.0014 | 22.0014 | 2800.0 |
| 2012-03-28 06:05:00 | AAPL | Stock | 22.0014 | 22.0014 | 22.0014 | 22.0014 | 2800.0 |
| 2012-03-28 06:14:00 | AAPL | Stock | 22.0036 | 22.0036 | 22.0036 | 22.0036 | 23240.0 |
| 2012-03-28 06:18:00 | AAPL | Stock | 22.0007 | 22.0007 | 22.0007 | 22.0007 | 2800.0 |
| 2012-03-28 06:22:00 | AAPL | Stock | 22.005 | 22.005 | 22.005 | 22.005 | 2800.0 |
| 2012-03-28 06:25:00 | AAPL | Stock | 22.005 | 22.005 | 22.005 | 22.005 | 5600.0 |
| 2012-03-28 06:32:00 | AAPL | Stock | 22.0054 | 22.0071 | 22.0054 | 22.0071 | 25200.0 |
| 2012-03-28 06:33:00 | AAPL | Stock | 22.0071 | 22.0071 | 22.0071 | 22.0071 | 39200.0 |
| 2012-03-28 06:36:00 | AAPL | Stock | 22.0036 | 22.0036 | 22.0036 | 22.0036 | 7000.0 |
| 2012-03-28 06:37:00 | AAPL | Stock | 22.0071 | 22.0071 | 22.0071 | 22.0071 | 11200.0 |
| 2012-03-28 06:42:00 | AAPL | Stock | 22.0071 | 22.0071 | 22.0071 | 22.0071 | 14000.0 |
| 2012-03-28 06:51:00 | AAPL | Stock | 22.0089 | 22.0089 | 22.0089 | 22.0089 | 2800.0 |
| 2012-03-28 06:58:00 | AAPL | Stock | 22.0125 | 22.0125 | 22.0125 | 22.0125 | 12600.0 |
| 2012-03-28 06:59:00 | AAPL | Stock | 22.0125 | 22.0125 | 22.0125 | 22.0125 | 12600.0 |
| 2012-03-28 07:00:00 | AAPL | Stock | 22.0089 | 22.0089 | 22.0036 | 22.0089 | 13692.0 |
| 2012-03-28 07:01:00 | AAPL | Stock | 22.0 | 22.0125 | 21.9929 | 22.0125 | 37940.0 |
| 2012-03-28 07:02:00 | AAPL | Stock | 22.0089 | 22.0089 | 22.0089 | 22.0089 | 8400.0 |
| 2012-03-28 07:06:00 | AAPL | Stock | 22.0125 | 22.0243 | 22.0125 | 22.0243 | 14560.0 |
| 2012-03-28 07:07:00 | AAPL | Stock | 22.0261 | 22.0261 | 22.025 | 22.0261 | 16800.0 |
| 2012-03-28 07:08:00 | AAPL | Stock | 22.0271 | 22.0304 | 22.0271 | 22.0304 | 5600.0 |
| 2012-03-28 07:09:00 | AAPL | Stock | 22.0429 | 22.0429 | 22.0429 | 22.0429 | 2800.0 |
| 2012-03-28 07:10:00 | AAPL | Stock | 22.0429 | 22.0429 | 22.0429 | 22.0429 | 2800.0 |
| 2012-03-28 07:12:00 | AAPL | Stock | 22.0464 | 22.0625 | 22.0464 | 22.0625 | 51800.0 |
| 2012-03-28 07:13:00 | AAPL | Stock | 22.0486 | 22.0486 | 22.0354 | 22.0354 | 63504.0 |
| 2012-03-28 07:14:00 | AAPL | Stock | 22.0371 | 22.0382 | 22.0357 | 22.0357 | 11200.0 |
| 2012-03-28 07:15:00 | AAPL | Stock | 22.0357 | 22.0382 | 22.0357 | 22.0382 | 16800.0 |
| 2012-03-28 07:16:00 | AAPL | Stock | 22.0493 | 22.05 | 22.0493 | 22.05 | 5600.0 |
| 2012-03-28 07:17:00 | AAPL | Stock | 22.0518 | 22.0518 | 22.0429 | 22.0429 | 13748.0 |
| 2012-03-28 07:20:00 | AAPL | Stock | 22.0475 | 22.0475 | 22.0357 | 22.0357 | 17416.0 |
| 2012-03-28 07:21:00 | AAPL | Stock | 22.0321 | 22.0357 | 22.0286 | 22.0357 | 11200.0 |
| 2012-03-28 07:22:00 | AAPL | Stock | 22.0214 | 22.0393 | 22.0214 | 22.0393 | 97076.0 |
> showing 50 of 977,368 rows — these rows as CSV