PREVIEW / stock_1min / 2014-04-14
file: by_date/stock_1min/2014/2014-04-14.parquet size: 14.6 MB rows: 1,071,067 symbols: 2,884
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 |
|---|---|---|---|---|---|---|---|
| 2014-04-14 04:01:00 | AAPL | Stock | 18.5375 | 18.5375 | 18.5375 | 18.5375 | 2800.0 |
| 2014-04-14 04:32:00 | AAPL | Stock | 18.5382 | 18.5382 | 18.5382 | 18.5382 | 2800.0 |
| 2014-04-14 05:59:00 | AAPL | Stock | 18.5039 | 18.5039 | 18.4989 | 18.4989 | 8400.0 |
| 2014-04-14 06:03:00 | AAPL | Stock | 18.4825 | 18.4825 | 18.4643 | 18.4643 | 5600.0 |
| 2014-04-14 06:19:00 | AAPL | Stock | 18.4707 | 18.4743 | 18.4707 | 18.4743 | 8400.0 |
| 2014-04-14 06:20:00 | AAPL | Stock | 18.4725 | 18.4725 | 18.4725 | 18.4725 | 2800.0 |
| 2014-04-14 06:32:00 | AAPL | Stock | 18.4796 | 18.4796 | 18.4796 | 18.4796 | 11200.0 |
| 2014-04-14 06:33:00 | AAPL | Stock | 18.4804 | 18.4804 | 18.4736 | 18.4736 | 14000.0 |
| 2014-04-14 06:37:00 | AAPL | Stock | 18.4786 | 18.4786 | 18.4779 | 18.4779 | 11200.0 |
| 2014-04-14 06:38:00 | AAPL | Stock | 18.5 | 18.5004 | 18.5 | 18.5004 | 22120.0 |
| 2014-04-14 06:43:00 | AAPL | Stock | 18.5 | 18.5 | 18.5 | 18.5 | 2800.0 |
| 2014-04-14 06:44:00 | AAPL | Stock | 18.5 | 18.5 | 18.5 | 18.5 | 5600.0 |
| 2014-04-14 07:02:00 | AAPL | Stock | 18.5357 | 18.5357 | 18.5357 | 18.5357 | 3360.0 |
| 2014-04-14 07:03:00 | AAPL | Stock | 18.5357 | 18.5357 | 18.5357 | 18.5357 | 2800.0 |
| 2014-04-14 07:14:00 | AAPL | Stock | 18.5107 | 18.5107 | 18.5107 | 18.5107 | 5600.0 |
| 2014-04-14 07:25:00 | AAPL | Stock | 18.5132 | 18.5132 | 18.5125 | 18.5125 | 5600.0 |
| 2014-04-14 07:30:00 | AAPL | Stock | 18.5336 | 18.5336 | 18.5336 | 18.5336 | 2800.0 |
| 2014-04-14 07:45:00 | AAPL | Stock | 18.5536 | 18.5536 | 18.5536 | 18.5536 | 8400.0 |
| 2014-04-14 07:50:00 | AAPL | Stock | 18.5686 | 18.5714 | 18.5686 | 18.5714 | 9632.0 |
| 2014-04-14 07:51:00 | AAPL | Stock | 18.6036 | 18.6036 | 18.6036 | 18.6036 | 2800.0 |
| 2014-04-14 07:53:00 | AAPL | Stock | 18.5893 | 18.5893 | 18.5893 | 18.5893 | 2800.0 |
| 2014-04-14 07:58:00 | AAPL | Stock | 18.5757 | 18.5757 | 18.5757 | 18.5757 | 2800.0 |
| 2014-04-14 07:59:00 | AAPL | Stock | 18.6071 | 18.6071 | 18.6071 | 18.6071 | 8400.0 |
| 2014-04-14 08:00:00 | AAPL | Stock | 18.5893 | 18.5893 | 18.5232 | 18.5821 | 15960.0 |
| 2014-04-14 08:02:00 | AAPL | Stock | 18.6311 | 18.6311 | 18.6311 | 18.6311 | 5348.0 |
| 2014-04-14 08:03:00 | AAPL | Stock | 18.6321 | 18.6321 | 18.6321 | 18.6321 | 2800.0 |
| 2014-04-14 08:04:00 | AAPL | Stock | 18.625 | 18.625 | 18.625 | 18.625 | 2800.0 |
| 2014-04-14 08:05:00 | AAPL | Stock | 18.625 | 18.625 | 18.625 | 18.625 | 2800.0 |
| 2014-04-14 08:06:00 | AAPL | Stock | 18.6318 | 18.6318 | 18.6318 | 18.6318 | 2800.0 |
| 2014-04-14 08:08:00 | AAPL | Stock | 18.6307 | 18.6307 | 18.6307 | 18.6307 | 2800.0 |
| 2014-04-14 08:09:00 | AAPL | Stock | 18.6418 | 18.6418 | 18.6418 | 18.6418 | 2800.0 |
| 2014-04-14 08:10:00 | AAPL | Stock | 18.6418 | 18.6429 | 18.6418 | 18.6429 | 11200.0 |
| 2014-04-14 08:11:00 | AAPL | Stock | 18.6536 | 18.6607 | 18.6536 | 18.6607 | 8400.0 |
| 2014-04-14 08:13:00 | AAPL | Stock | 18.6536 | 18.6643 | 18.6536 | 18.6643 | 5880.0 |
| 2014-04-14 08:14:00 | AAPL | Stock | 18.6536 | 18.6536 | 18.6429 | 18.6429 | 42000.0 |
| 2014-04-14 08:15:00 | AAPL | Stock | 18.6354 | 18.6354 | 18.6354 | 18.6354 | 5600.0 |
| 2014-04-14 08:16:00 | AAPL | Stock | 18.6439 | 18.6439 | 18.6439 | 18.6439 | 11200.0 |
| 2014-04-14 08:19:00 | AAPL | Stock | 18.6439 | 18.6439 | 18.6429 | 18.6429 | 11088.0 |
| 2014-04-14 08:21:00 | AAPL | Stock | 18.6439 | 18.6439 | 18.6429 | 18.6429 | 19600.0 |
| 2014-04-14 08:24:00 | AAPL | Stock | 18.6339 | 18.6339 | 18.6307 | 18.6307 | 16800.0 |
| 2014-04-14 08:25:00 | AAPL | Stock | 18.6264 | 18.6264 | 18.6264 | 18.6264 | 2800.0 |
| 2014-04-14 08:27:00 | AAPL | Stock | 18.6368 | 18.6368 | 18.6368 | 18.6368 | 5600.0 |
| 2014-04-14 08:31:00 | AAPL | Stock | 18.6621 | 18.6621 | 18.6621 | 18.6621 | 2800.0 |
| 2014-04-14 08:32:00 | AAPL | Stock | 18.6629 | 18.6643 | 18.6607 | 18.6607 | 14000.0 |
| 2014-04-14 08:33:00 | AAPL | Stock | 18.6521 | 18.6521 | 18.6521 | 18.6521 | 2800.0 |
| 2014-04-14 08:34:00 | AAPL | Stock | 18.6536 | 18.6536 | 18.6536 | 18.6536 | 8400.0 |
| 2014-04-14 08:36:00 | AAPL | Stock | 18.6525 | 18.6525 | 18.6518 | 18.6518 | 22400.0 |
| 2014-04-14 08:37:00 | AAPL | Stock | 18.6596 | 18.6596 | 18.6596 | 18.6596 | 2800.0 |
| 2014-04-14 08:39:00 | AAPL | Stock | 18.6539 | 18.6586 | 18.6518 | 18.6586 | 30380.0 |
| 2014-04-14 08:40:00 | AAPL | Stock | 18.6586 | 18.6607 | 18.6586 | 18.6607 | 40600.0 |
> showing 50 of 1,071,067 rows — these rows as CSV