PREVIEW / stock_1min / 2011-09-13
file: by_date/stock_1min/2011/2011-09-13.parquet size: 13.1 MB rows: 994,690 symbols: 2,813
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-09-13 04:02:00 | AAPL | Stock | 13.5029 | 13.5029 | 13.5029 | 13.5029 | 2800.0 |
| 2011-09-13 04:13:00 | AAPL | Stock | 13.4557 | 13.4557 | 13.4411 | 13.4411 | 5600.0 |
| 2011-09-13 04:14:00 | AAPL | Stock | 13.4621 | 13.4643 | 13.4621 | 13.4643 | 33600.0 |
| 2011-09-13 04:19:00 | AAPL | Stock | 13.4325 | 13.4325 | 13.4325 | 13.4325 | 2800.0 |
| 2011-09-13 04:50:00 | AAPL | Stock | 13.4632 | 13.4632 | 13.4632 | 13.4632 | 2800.0 |
| 2011-09-13 04:58:00 | AAPL | Stock | 13.4964 | 13.4964 | 13.4964 | 13.4964 | 2800.0 |
| 2011-09-13 07:02:00 | AAPL | Stock | 13.5032 | 13.5086 | 13.5032 | 13.5086 | 8400.0 |
| 2011-09-13 07:03:00 | AAPL | Stock | 13.5 | 13.5161 | 13.5 | 13.5161 | 50400.0 |
| 2011-09-13 07:04:00 | AAPL | Stock | 13.5161 | 13.5257 | 13.5161 | 13.5182 | 33600.0 |
| 2011-09-13 07:05:00 | AAPL | Stock | 13.5171 | 13.5214 | 13.5171 | 13.5171 | 33880.0 |
| 2011-09-13 07:06:00 | AAPL | Stock | 13.5089 | 13.5089 | 13.5089 | 13.5089 | 2800.0 |
| 2011-09-13 07:07:00 | AAPL | Stock | 13.5143 | 13.5143 | 13.5143 | 13.5143 | 2800.0 |
| 2011-09-13 07:08:00 | AAPL | Stock | 13.5143 | 13.5161 | 13.5089 | 13.5161 | 19600.0 |
| 2011-09-13 07:09:00 | AAPL | Stock | 13.5196 | 13.5196 | 13.5196 | 13.5196 | 2800.0 |
| 2011-09-13 07:11:00 | AAPL | Stock | 13.5279 | 13.5539 | 13.5279 | 13.5429 | 33600.0 |
| 2011-09-13 07:12:00 | AAPL | Stock | 13.5339 | 13.5479 | 13.5339 | 13.5479 | 10920.0 |
| 2011-09-13 07:13:00 | AAPL | Stock | 13.5464 | 13.5482 | 13.5464 | 13.5482 | 8400.0 |
| 2011-09-13 07:14:00 | AAPL | Stock | 13.5564 | 13.5736 | 13.5564 | 13.5732 | 56420.0 |
| 2011-09-13 07:15:00 | AAPL | Stock | 13.5714 | 13.5893 | 13.5714 | 13.5893 | 16800.0 |
| 2011-09-13 07:16:00 | AAPL | Stock | 13.5732 | 13.5732 | 13.5589 | 13.5589 | 61180.0 |
| 2011-09-13 07:17:00 | AAPL | Stock | 13.5561 | 13.5561 | 13.5554 | 13.5554 | 19600.0 |
| 2011-09-13 07:18:00 | AAPL | Stock | 13.5536 | 13.5536 | 13.5529 | 13.5529 | 5600.0 |
| 2011-09-13 07:19:00 | AAPL | Stock | 13.5536 | 13.5536 | 13.5464 | 13.5464 | 5600.0 |
| 2011-09-13 07:20:00 | AAPL | Stock | 13.5468 | 13.55 | 13.5411 | 13.5411 | 26600.0 |
| 2011-09-13 07:21:00 | AAPL | Stock | 13.5446 | 13.5446 | 13.5357 | 13.5364 | 47600.0 |
| 2011-09-13 07:23:00 | AAPL | Stock | 13.5511 | 13.5536 | 13.5511 | 13.5536 | 28000.0 |
| 2011-09-13 07:24:00 | AAPL | Stock | 13.5536 | 13.5668 | 13.5536 | 13.5668 | 109200.0 |
| 2011-09-13 07:25:00 | AAPL | Stock | 13.5604 | 13.5604 | 13.5543 | 13.5543 | 11200.0 |
| 2011-09-13 07:26:00 | AAPL | Stock | 13.5671 | 13.5714 | 13.5671 | 13.5714 | 28000.0 |
| 2011-09-13 07:27:00 | AAPL | Stock | 13.5732 | 13.5836 | 13.5714 | 13.5836 | 36400.0 |
| 2011-09-13 07:28:00 | AAPL | Stock | 13.5836 | 13.5861 | 13.5836 | 13.5839 | 32900.0 |
| 2011-09-13 07:29:00 | AAPL | Stock | 13.5911 | 13.5964 | 13.5893 | 13.5907 | 28000.0 |
| 2011-09-13 07:30:00 | AAPL | Stock | 13.595 | 13.5964 | 13.5786 | 13.5864 | 44800.0 |
| 2011-09-13 07:31:00 | AAPL | Stock | 13.5818 | 13.6032 | 13.5818 | 13.6032 | 28000.0 |
| 2011-09-13 07:32:00 | AAPL | Stock | 13.6 | 13.6254 | 13.6 | 13.6075 | 95200.0 |
| 2011-09-13 07:33:00 | AAPL | Stock | 13.6082 | 13.6289 | 13.6068 | 13.6289 | 112000.0 |
| 2011-09-13 07:34:00 | AAPL | Stock | 13.6371 | 13.6536 | 13.6371 | 13.6536 | 137200.0 |
| 2011-09-13 07:35:00 | AAPL | Stock | 13.6546 | 13.6546 | 13.6254 | 13.6432 | 42000.0 |
| 2011-09-13 07:36:00 | AAPL | Stock | 13.6539 | 13.6539 | 13.6379 | 13.6379 | 64120.0 |
| 2011-09-13 07:37:00 | AAPL | Stock | 13.6379 | 13.6379 | 13.6379 | 13.6379 | 16800.0 |
| 2011-09-13 07:38:00 | AAPL | Stock | 13.6532 | 13.6532 | 13.6532 | 13.6532 | 2800.0 |
| 2011-09-13 07:39:00 | AAPL | Stock | 13.6407 | 13.6589 | 13.6407 | 13.6589 | 30800.0 |
| 2011-09-13 07:40:00 | AAPL | Stock | 13.6429 | 13.6429 | 13.6393 | 13.6393 | 29232.0 |
| 2011-09-13 07:41:00 | AAPL | Stock | 13.6289 | 13.6289 | 13.625 | 13.625 | 16380.0 |
| 2011-09-13 07:42:00 | AAPL | Stock | 13.6254 | 13.6254 | 13.625 | 13.625 | 19600.0 |
| 2011-09-13 07:43:00 | AAPL | Stock | 13.6246 | 13.6246 | 13.6246 | 13.6246 | 2800.0 |
| 2011-09-13 07:45:00 | AAPL | Stock | 13.6229 | 13.625 | 13.6161 | 13.6161 | 28000.0 |
| 2011-09-13 07:46:00 | AAPL | Stock | 13.6143 | 13.6143 | 13.5661 | 13.5718 | 262500.0 |
| 2011-09-13 07:47:00 | AAPL | Stock | 13.5718 | 13.5725 | 13.5396 | 13.5582 | 56000.0 |
| 2011-09-13 07:48:00 | AAPL | Stock | 13.5582 | 13.5714 | 13.5571 | 13.5714 | 137200.0 |
> showing 50 of 994,690 rows — these rows as CSV