PREVIEW / stock_1min / 2011-10-27
file: by_date/stock_1min/2011/2011-10-27.parquet size: 15.7 MB rows: 1,141,293 symbols: 2,879
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 |
|---|---|---|---|---|---|---|---|
| 2011-10-27 04:00:00 | AAPL | Stock | 14.3714 | 14.4464 | 14.3714 | 14.4464 | 7000.0 |
| 2011-10-27 04:03:00 | AAPL | Stock | 14.4857 | 14.4857 | 14.4857 | 14.4857 | 2800.0 |
| 2011-10-27 04:05:00 | AAPL | Stock | 14.5 | 14.5 | 14.5 | 14.5 | 2800.0 |
| 2011-10-27 04:07:00 | AAPL | Stock | 14.5 | 14.5 | 14.5 | 14.5 | 2800.0 |
| 2011-10-27 04:16:00 | AAPL | Stock | 14.4639 | 14.4639 | 14.4639 | 14.4639 | 4788.0 |
| 2011-10-27 04:22:00 | AAPL | Stock | 14.4754 | 14.4754 | 14.4754 | 14.4754 | 5600.0 |
| 2011-10-27 04:26:00 | AAPL | Stock | 14.4779 | 14.4779 | 14.4779 | 14.4779 | 5600.0 |
| 2011-10-27 04:31:00 | AAPL | Stock | 14.4961 | 14.4961 | 14.4961 | 14.4961 | 2800.0 |
| 2011-10-27 04:44:00 | AAPL | Stock | 14.4821 | 14.4821 | 14.4821 | 14.4821 | 8400.0 |
| 2011-10-27 04:49:00 | AAPL | Stock | 14.4961 | 14.4961 | 14.4961 | 14.4961 | 9800.0 |
| 2011-10-27 04:51:00 | AAPL | Stock | 14.5161 | 14.5161 | 14.5161 | 14.5161 | 14000.0 |
| 2011-10-27 05:09:00 | AAPL | Stock | 14.5179 | 14.5179 | 14.5179 | 14.5179 | 2800.0 |
| 2011-10-27 05:16:00 | AAPL | Stock | 14.5179 | 14.5179 | 14.5179 | 14.5179 | 2800.0 |
| 2011-10-27 05:19:00 | AAPL | Stock | 14.5179 | 14.5179 | 14.5179 | 14.5179 | 8316.0 |
| 2011-10-27 05:22:00 | AAPL | Stock | 14.5179 | 14.5179 | 14.5179 | 14.5179 | 2800.0 |
| 2011-10-27 05:26:00 | AAPL | Stock | 14.5179 | 14.5179 | 14.5179 | 14.5179 | 2800.0 |
| 2011-10-27 05:32:00 | AAPL | Stock | 14.5179 | 14.5179 | 14.5179 | 14.5179 | 2800.0 |
| 2011-10-27 05:40:00 | AAPL | Stock | 14.5179 | 14.5179 | 14.5179 | 14.5179 | 3724.0 |
| 2011-10-27 05:47:00 | AAPL | Stock | 14.5096 | 14.5096 | 14.5096 | 14.5096 | 2800.0 |
| 2011-10-27 05:49:00 | AAPL | Stock | 14.5 | 14.5 | 14.5 | 14.5 | 2800.0 |
| 2011-10-27 05:51:00 | AAPL | Stock | 14.5089 | 14.5089 | 14.5089 | 14.5089 | 2800.0 |
| 2011-10-27 06:04:00 | AAPL | Stock | 14.5357 | 14.5357 | 14.5357 | 14.5357 | 2800.0 |
| 2011-10-27 06:05:00 | AAPL | Stock | 14.5357 | 14.5357 | 14.5357 | 14.5357 | 5600.0 |
| 2011-10-27 06:07:00 | AAPL | Stock | 14.5357 | 14.5357 | 14.5268 | 14.5268 | 11200.0 |
| 2011-10-27 06:08:00 | AAPL | Stock | 14.5179 | 14.5179 | 14.5179 | 14.5179 | 2800.0 |
| 2011-10-27 06:09:00 | AAPL | Stock | 14.5179 | 14.5354 | 14.5179 | 14.5354 | 5600.0 |
| 2011-10-27 06:10:00 | AAPL | Stock | 14.5179 | 14.5179 | 14.5179 | 14.5179 | 2800.0 |
| 2011-10-27 06:18:00 | AAPL | Stock | 14.5357 | 14.5357 | 14.5357 | 14.5357 | 2800.0 |
| 2011-10-27 06:50:00 | AAPL | Stock | 14.5357 | 14.5536 | 14.5357 | 14.5536 | 19600.0 |
| 2011-10-27 06:52:00 | AAPL | Stock | 14.5536 | 14.5536 | 14.5536 | 14.5536 | 8120.0 |
| 2011-10-27 06:55:00 | AAPL | Stock | 14.5536 | 14.5536 | 14.5536 | 14.5536 | 2800.0 |
| 2011-10-27 06:59:00 | AAPL | Stock | 14.5607 | 14.5607 | 14.5607 | 14.5607 | 2800.0 |
| 2011-10-27 07:00:00 | AAPL | Stock | 14.5625 | 14.5679 | 14.5625 | 14.5679 | 8400.0 |
| 2011-10-27 07:01:00 | AAPL | Stock | 14.5714 | 14.5857 | 14.5714 | 14.5718 | 115920.0 |
| 2011-10-27 07:02:00 | AAPL | Stock | 14.6032 | 14.6032 | 14.5886 | 14.5982 | 166460.0 |
| 2011-10-27 07:03:00 | AAPL | Stock | 14.5893 | 14.5893 | 14.5886 | 14.5886 | 28000.0 |
| 2011-10-27 07:04:00 | AAPL | Stock | 14.5821 | 14.5979 | 14.5821 | 14.5979 | 26404.0 |
| 2011-10-27 07:05:00 | AAPL | Stock | 14.5979 | 14.5982 | 14.5893 | 14.5893 | 33600.0 |
| 2011-10-27 07:06:00 | AAPL | Stock | 14.5893 | 14.5893 | 14.5893 | 14.5893 | 56000.0 |
| 2011-10-27 07:07:00 | AAPL | Stock | 14.5807 | 14.5807 | 14.5714 | 14.5714 | 76944.0 |
| 2011-10-27 07:08:00 | AAPL | Stock | 14.5714 | 14.5786 | 14.5714 | 14.5786 | 35000.0 |
| 2011-10-27 07:09:00 | AAPL | Stock | 14.5714 | 14.5714 | 14.5714 | 14.5714 | 2800.0 |
| 2011-10-27 07:11:00 | AAPL | Stock | 14.5571 | 14.5571 | 14.5536 | 14.5536 | 14000.0 |
| 2011-10-27 07:12:00 | AAPL | Stock | 14.5429 | 14.5536 | 14.5361 | 14.5536 | 99400.0 |
| 2011-10-27 07:13:00 | AAPL | Stock | 14.5571 | 14.5571 | 14.5571 | 14.5571 | 11200.0 |
| 2011-10-27 07:14:00 | AAPL | Stock | 14.5536 | 14.5536 | 14.5536 | 14.5536 | 9520.0 |
| 2011-10-27 07:15:00 | AAPL | Stock | 14.5393 | 14.5393 | 14.53 | 14.5393 | 8400.0 |
| 2011-10-27 07:16:00 | AAPL | Stock | 14.5304 | 14.5393 | 14.5286 | 14.5393 | 28000.0 |
| 2011-10-27 07:18:00 | AAPL | Stock | 14.5371 | 14.5371 | 14.5357 | 14.5357 | 16800.0 |
| 2011-10-27 07:19:00 | AAPL | Stock | 14.5361 | 14.545 | 14.5357 | 14.545 | 16800.0 |
> showing 50 of 1,141,293 rows — these rows as CSV