PREVIEW / stock_1min / 2012-10-09
file: by_date/stock_1min/2012/2012-10-09.parquet size: 12.3 MB rows: 909,188 symbols: 2,809
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-10-09 04:03:00 | AAPL | Stock | 22.5711 | 22.5711 | 22.5432 | 22.5432 | 8400.0 |
| 2012-10-09 04:04:00 | AAPL | Stock | 22.5711 | 22.5711 | 22.5711 | 22.5711 | 2800.0 |
| 2012-10-09 04:05:00 | AAPL | Stock | 22.5743 | 22.5743 | 22.5743 | 22.5743 | 2800.0 |
| 2012-10-09 04:06:00 | AAPL | Stock | 22.5721 | 22.5721 | 22.5721 | 22.5721 | 2800.0 |
| 2012-10-09 04:07:00 | AAPL | Stock | 22.5721 | 22.5721 | 22.5714 | 22.5714 | 20496.0 |
| 2012-10-09 04:32:00 | AAPL | Stock | 22.5232 | 22.5232 | 22.5232 | 22.5232 | 2800.0 |
| 2012-10-09 04:34:00 | AAPL | Stock | 22.5286 | 22.5286 | 22.5286 | 22.5286 | 2800.0 |
| 2012-10-09 04:36:00 | AAPL | Stock | 22.5179 | 22.5179 | 22.5179 | 22.5179 | 2800.0 |
| 2012-10-09 04:39:00 | AAPL | Stock | 22.5189 | 22.5189 | 22.5189 | 22.5189 | 2800.0 |
| 2012-10-09 04:40:00 | AAPL | Stock | 22.5089 | 22.5089 | 22.5089 | 22.5089 | 5600.0 |
| 2012-10-09 04:43:00 | AAPL | Stock | 22.5179 | 22.5282 | 22.5179 | 22.5282 | 25200.0 |
| 2012-10-09 04:45:00 | AAPL | Stock | 22.5179 | 22.5179 | 22.5179 | 22.5179 | 2800.0 |
| 2012-10-09 04:48:00 | AAPL | Stock | 22.5179 | 22.5179 | 22.5179 | 22.5179 | 2800.0 |
| 2012-10-09 04:49:00 | AAPL | Stock | 22.5179 | 22.5282 | 22.5179 | 22.5282 | 16520.0 |
| 2012-10-09 04:50:00 | AAPL | Stock | 22.5268 | 22.5268 | 22.5268 | 22.5268 | 14000.0 |
| 2012-10-09 04:51:00 | AAPL | Stock | 22.5268 | 22.5268 | 22.5268 | 22.5268 | 22400.0 |
| 2012-10-09 04:52:00 | AAPL | Stock | 22.5268 | 22.5268 | 22.5268 | 22.5268 | 2800.0 |
| 2012-10-09 04:53:00 | AAPL | Stock | 22.5357 | 22.5357 | 22.5357 | 22.5357 | 2800.0 |
| 2012-10-09 04:54:00 | AAPL | Stock | 22.5279 | 22.5279 | 22.5271 | 22.5271 | 8400.0 |
| 2012-10-09 04:55:00 | AAPL | Stock | 22.5286 | 22.5286 | 22.5271 | 22.5271 | 25200.0 |
| 2012-10-09 04:57:00 | AAPL | Stock | 22.5357 | 22.5357 | 22.5357 | 22.5357 | 2800.0 |
| 2012-10-09 04:58:00 | AAPL | Stock | 22.5271 | 22.5271 | 22.5271 | 22.5271 | 5516.0 |
| 2012-10-09 04:59:00 | AAPL | Stock | 22.5286 | 22.5321 | 22.5286 | 22.5321 | 11200.0 |
| 2012-10-09 05:00:00 | AAPL | Stock | 22.5354 | 22.5357 | 22.5321 | 22.5339 | 28000.0 |
| 2012-10-09 05:01:00 | AAPL | Stock | 22.5393 | 22.5393 | 22.5393 | 22.5393 | 2800.0 |
| 2012-10-09 05:02:00 | AAPL | Stock | 22.5393 | 22.5493 | 22.5393 | 22.5493 | 11200.0 |
| 2012-10-09 05:17:00 | AAPL | Stock | 22.5425 | 22.5429 | 22.5425 | 22.5429 | 14000.0 |
| 2012-10-09 05:19:00 | AAPL | Stock | 22.5393 | 22.5393 | 22.5393 | 22.5393 | 4200.0 |
| 2012-10-09 05:24:00 | AAPL | Stock | 22.5411 | 22.5429 | 22.5411 | 22.5429 | 19600.0 |
| 2012-10-09 05:31:00 | AAPL | Stock | 22.5411 | 22.5429 | 22.5411 | 22.5429 | 25200.0 |
| 2012-10-09 05:32:00 | AAPL | Stock | 22.5357 | 22.5357 | 22.5357 | 22.5357 | 11200.0 |
| 2012-10-09 05:33:00 | AAPL | Stock | 22.5429 | 22.5446 | 22.5429 | 22.5446 | 5600.0 |
| 2012-10-09 05:46:00 | AAPL | Stock | 22.5571 | 22.5571 | 22.5536 | 22.5571 | 33600.0 |
| 2012-10-09 05:47:00 | AAPL | Stock | 22.56 | 22.5714 | 22.56 | 22.5714 | 33600.0 |
| 2012-10-09 05:48:00 | AAPL | Stock | 22.5714 | 22.5714 | 22.5714 | 22.5714 | 54040.0 |
| 2012-10-09 05:50:00 | AAPL | Stock | 22.5714 | 22.5714 | 22.5714 | 22.5714 | 3500.0 |
| 2012-10-09 05:51:00 | AAPL | Stock | 22.5732 | 22.5857 | 22.5732 | 22.5857 | 22400.0 |
| 2012-10-09 05:57:00 | AAPL | Stock | 22.5825 | 22.5825 | 22.5825 | 22.5825 | 27300.0 |
| 2012-10-09 05:58:00 | AAPL | Stock | 22.575 | 22.575 | 22.575 | 22.575 | 10556.0 |
| 2012-10-09 06:03:00 | AAPL | Stock | 22.5893 | 22.5964 | 22.5893 | 22.5964 | 17920.0 |
| 2012-10-09 06:07:00 | AAPL | Stock | 22.5979 | 22.5982 | 22.5979 | 22.5982 | 5600.0 |
| 2012-10-09 06:08:00 | AAPL | Stock | 22.5982 | 22.5982 | 22.5982 | 22.5982 | 7700.0 |
| 2012-10-09 06:11:00 | AAPL | Stock | 22.6029 | 22.6029 | 22.6029 | 22.6029 | 8400.0 |
| 2012-10-09 06:12:00 | AAPL | Stock | 22.6029 | 22.6036 | 22.6029 | 22.6036 | 20300.0 |
| 2012-10-09 06:15:00 | AAPL | Stock | 22.62 | 22.62 | 22.62 | 22.62 | 7000.0 |
| 2012-10-09 06:19:00 | AAPL | Stock | 22.6071 | 22.6071 | 22.6071 | 22.6071 | 16800.0 |
| 2012-10-09 06:22:00 | AAPL | Stock | 22.6071 | 22.6071 | 22.6071 | 22.6071 | 2800.0 |
| 2012-10-09 06:41:00 | AAPL | Stock | 22.6071 | 22.6071 | 22.6071 | 22.6071 | 9800.0 |
| 2012-10-09 06:47:00 | AAPL | Stock | 22.6196 | 22.6196 | 22.6196 | 22.6196 | 2800.0 |
| 2012-10-09 06:51:00 | AAPL | Stock | 22.6257 | 22.6268 | 22.6257 | 22.6268 | 72772.0 |
> showing 50 of 909,188 rows — these rows as CSV