PREVIEW / stock_1min / 2012-01-26
file: by_date/stock_1min/2012/2012-01-26.parquet size: 13.2 MB rows: 975,265 symbols: 2,853
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-01-26 04:00:00 | AAPL | Stock | 15.9754 | 15.9757 | 15.9729 | 15.9729 | 11200.0 |
| 2012-01-26 04:03:00 | AAPL | Stock | 15.9782 | 15.9782 | 15.9782 | 15.9782 | 2800.0 |
| 2012-01-26 04:20:00 | AAPL | Stock | 16.0 | 16.0 | 16.0 | 16.0 | 5600.0 |
| 2012-01-26 04:21:00 | AAPL | Stock | 16.0 | 16.0 | 16.0 | 16.0 | 14000.0 |
| 2012-01-26 04:22:00 | AAPL | Stock | 16.0 | 16.0 | 16.0 | 16.0 | 14000.0 |
| 2012-01-26 04:31:00 | AAPL | Stock | 16.0 | 16.0 | 16.0 | 16.0 | 8400.0 |
| 2012-01-26 04:32:00 | AAPL | Stock | 16.0 | 16.0 | 16.0 | 16.0 | 8400.0 |
| 2012-01-26 04:48:00 | AAPL | Stock | 16.0443 | 16.0443 | 16.0443 | 16.0443 | 2800.0 |
| 2012-01-26 04:49:00 | AAPL | Stock | 16.0382 | 16.0382 | 16.0382 | 16.0382 | 5600.0 |
| 2012-01-26 04:50:00 | AAPL | Stock | 16.0468 | 16.0468 | 16.0443 | 16.0443 | 8400.0 |
| 2012-01-26 04:51:00 | AAPL | Stock | 16.0443 | 16.0443 | 16.0443 | 16.0443 | 5600.0 |
| 2012-01-26 04:52:00 | AAPL | Stock | 16.0489 | 16.0489 | 16.0439 | 16.0439 | 11200.0 |
| 2012-01-26 04:54:00 | AAPL | Stock | 16.0439 | 16.0439 | 16.0439 | 16.0439 | 5600.0 |
| 2012-01-26 04:55:00 | AAPL | Stock | 16.0411 | 16.0411 | 16.0411 | 16.0411 | 5600.0 |
| 2012-01-26 04:57:00 | AAPL | Stock | 16.0382 | 16.0382 | 16.0354 | 16.0354 | 11200.0 |
| 2012-01-26 04:58:00 | AAPL | Stock | 16.0357 | 16.0357 | 16.0357 | 16.0357 | 14000.0 |
| 2012-01-26 04:59:00 | AAPL | Stock | 16.0382 | 16.0382 | 16.0382 | 16.0382 | 5600.0 |
| 2012-01-26 05:02:00 | AAPL | Stock | 16.0304 | 16.0304 | 16.0304 | 16.0304 | 8400.0 |
| 2012-01-26 05:04:00 | AAPL | Stock | 16.0382 | 16.0382 | 16.0382 | 16.0382 | 5600.0 |
| 2012-01-26 05:05:00 | AAPL | Stock | 16.0382 | 16.0382 | 16.0382 | 16.0382 | 11200.0 |
| 2012-01-26 05:10:00 | AAPL | Stock | 16.0461 | 16.0461 | 16.0461 | 16.0461 | 2800.0 |
| 2012-01-26 05:12:00 | AAPL | Stock | 16.0321 | 16.0321 | 16.0321 | 16.0321 | 5600.0 |
| 2012-01-26 05:15:00 | AAPL | Stock | 16.0304 | 16.0304 | 16.0304 | 16.0304 | 8400.0 |
| 2012-01-26 05:21:00 | AAPL | Stock | 16.0268 | 16.0268 | 16.0268 | 16.0268 | 2800.0 |
| 2012-01-26 05:26:00 | AAPL | Stock | 16.0268 | 16.0321 | 16.0268 | 16.0321 | 5600.0 |
| 2012-01-26 05:27:00 | AAPL | Stock | 16.0268 | 16.0268 | 16.0268 | 16.0268 | 5600.0 |
| 2012-01-26 05:41:00 | AAPL | Stock | 16.0321 | 16.0321 | 16.0321 | 16.0321 | 2800.0 |
| 2012-01-26 05:51:00 | AAPL | Stock | 16.0214 | 16.0214 | 16.0214 | 16.0214 | 5600.0 |
| 2012-01-26 05:54:00 | AAPL | Stock | 16.0179 | 16.0179 | 16.0179 | 16.0179 | 5600.0 |
| 2012-01-26 05:57:00 | AAPL | Stock | 16.0179 | 16.0179 | 16.0179 | 16.0179 | 2800.0 |
| 2012-01-26 05:58:00 | AAPL | Stock | 16.0179 | 16.0179 | 16.0179 | 16.0179 | 2800.0 |
| 2012-01-26 06:03:00 | AAPL | Stock | 16.0321 | 16.0321 | 16.0321 | 16.0321 | 8400.0 |
| 2012-01-26 06:07:00 | AAPL | Stock | 16.0321 | 16.0321 | 16.0321 | 16.0321 | 5600.0 |
| 2012-01-26 06:14:00 | AAPL | Stock | 16.0379 | 16.0379 | 16.0304 | 16.0304 | 11200.0 |
| 2012-01-26 06:15:00 | AAPL | Stock | 16.0304 | 16.0304 | 16.0304 | 16.0304 | 2800.0 |
| 2012-01-26 06:16:00 | AAPL | Stock | 16.0357 | 16.0357 | 16.0357 | 16.0357 | 14000.0 |
| 2012-01-26 06:17:00 | AAPL | Stock | 16.0357 | 16.0357 | 16.0357 | 16.0357 | 2800.0 |
| 2012-01-26 06:30:00 | AAPL | Stock | 16.0214 | 16.0214 | 16.0214 | 16.0214 | 14000.0 |
| 2012-01-26 06:39:00 | AAPL | Stock | 16.0179 | 16.0179 | 16.0179 | 16.0179 | 2800.0 |
| 2012-01-26 07:01:00 | AAPL | Stock | 16.0179 | 16.0179 | 16.0064 | 16.0064 | 11200.0 |
| 2012-01-26 07:02:00 | AAPL | Stock | 16.0064 | 16.0064 | 16.0064 | 16.0064 | 5600.0 |
| 2012-01-26 07:04:00 | AAPL | Stock | 16.0107 | 16.0107 | 16.0107 | 16.0107 | 10500.0 |
| 2012-01-26 07:05:00 | AAPL | Stock | 16.0171 | 16.025 | 16.0154 | 16.02 | 77280.0 |
| 2012-01-26 07:06:00 | AAPL | Stock | 16.0179 | 16.025 | 16.0179 | 16.025 | 37520.0 |
| 2012-01-26 07:07:00 | AAPL | Stock | 16.025 | 16.0314 | 16.025 | 16.0314 | 33600.0 |
| 2012-01-26 07:08:00 | AAPL | Stock | 16.0282 | 16.0282 | 16.0282 | 16.0282 | 2800.0 |
| 2012-01-26 07:12:00 | AAPL | Stock | 16.0143 | 16.0143 | 16.0107 | 16.0107 | 34300.0 |
| 2012-01-26 07:13:00 | AAPL | Stock | 16.0107 | 16.0107 | 16.0107 | 16.0107 | 19180.0 |
| 2012-01-26 07:15:00 | AAPL | Stock | 16.0111 | 16.0111 | 16.0089 | 16.0089 | 16520.0 |
| 2012-01-26 07:16:00 | AAPL | Stock | 16.0104 | 16.0107 | 16.0104 | 16.0107 | 8232.0 |
> showing 50 of 975,265 rows — these rows as CSV