PREVIEW / stock_1min / 2013-03-26
file: by_date/stock_1min/2013/2013-03-26.parquet size: 12.9 MB rows: 950,869 symbols: 2,829
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 |
|---|---|---|---|---|---|---|---|
| 2013-03-26 05:04:00 | AAPL | Stock | 16.5704 | 16.5704 | 16.5704 | 16.5704 | 7000.0 |
| 2013-03-26 06:21:00 | AAPL | Stock | 16.5761 | 16.5761 | 16.5761 | 16.5761 | 2800.0 |
| 2013-03-26 07:04:00 | AAPL | Stock | 16.5893 | 16.5893 | 16.5861 | 16.5861 | 5600.0 |
| 2013-03-26 07:06:00 | AAPL | Stock | 16.5889 | 16.5889 | 16.5889 | 16.5889 | 5152.0 |
| 2013-03-26 07:11:00 | AAPL | Stock | 16.5989 | 16.6036 | 16.5989 | 16.6036 | 16968.0 |
| 2013-03-26 07:13:00 | AAPL | Stock | 16.6079 | 16.6079 | 16.6071 | 16.6071 | 13972.0 |
| 2013-03-26 07:17:00 | AAPL | Stock | 16.6193 | 16.6268 | 16.6193 | 16.6268 | 73780.0 |
| 2013-03-26 07:18:00 | AAPL | Stock | 16.6268 | 16.6354 | 16.6268 | 16.6354 | 50400.0 |
| 2013-03-26 07:19:00 | AAPL | Stock | 16.6357 | 16.6364 | 16.6357 | 16.6364 | 29512.0 |
| 2013-03-26 07:20:00 | AAPL | Stock | 16.6357 | 16.6357 | 16.6325 | 16.6357 | 14000.0 |
| 2013-03-26 07:21:00 | AAPL | Stock | 16.6518 | 16.6568 | 16.6518 | 16.6568 | 16800.0 |
| 2013-03-26 07:22:00 | AAPL | Stock | 16.6464 | 16.6564 | 16.6464 | 16.6564 | 5600.0 |
| 2013-03-26 07:24:00 | AAPL | Stock | 16.6296 | 16.6296 | 16.6296 | 16.6296 | 2800.0 |
| 2013-03-26 07:25:00 | AAPL | Stock | 16.6304 | 16.6304 | 16.625 | 16.6304 | 31780.0 |
| 2013-03-26 07:27:00 | AAPL | Stock | 16.6357 | 16.6486 | 16.6357 | 16.6486 | 70392.0 |
| 2013-03-26 07:28:00 | AAPL | Stock | 16.6486 | 16.6486 | 16.6464 | 16.6464 | 11200.0 |
| 2013-03-26 07:29:00 | AAPL | Stock | 16.65 | 16.65 | 16.65 | 16.65 | 2800.0 |
| 2013-03-26 07:30:00 | AAPL | Stock | 16.6464 | 16.6464 | 16.6421 | 16.6421 | 27804.0 |
| 2013-03-26 07:33:00 | AAPL | Stock | 16.6425 | 16.6429 | 16.6304 | 16.64 | 11200.0 |
| 2013-03-26 07:34:00 | AAPL | Stock | 16.6279 | 16.6279 | 16.6268 | 16.6268 | 26320.0 |
| 2013-03-26 07:36:00 | AAPL | Stock | 16.6361 | 16.6368 | 16.6361 | 16.6368 | 5600.0 |
| 2013-03-26 07:41:00 | AAPL | Stock | 16.6339 | 16.6414 | 16.6339 | 16.6414 | 28056.0 |
| 2013-03-26 07:43:00 | AAPL | Stock | 16.6346 | 16.6346 | 16.6336 | 16.6336 | 29848.0 |
| 2013-03-26 07:44:00 | AAPL | Stock | 16.6289 | 16.6289 | 16.6268 | 16.6268 | 6860.0 |
| 2013-03-26 07:45:00 | AAPL | Stock | 16.6268 | 16.6268 | 16.625 | 16.625 | 13160.0 |
| 2013-03-26 07:48:00 | AAPL | Stock | 16.6232 | 16.6243 | 16.6161 | 16.6161 | 31584.0 |
| 2013-03-26 07:49:00 | AAPL | Stock | 16.6125 | 16.6125 | 16.6071 | 16.6071 | 22400.0 |
| 2013-03-26 07:50:00 | AAPL | Stock | 16.6093 | 16.6157 | 16.6075 | 16.6075 | 8400.0 |
| 2013-03-26 07:51:00 | AAPL | Stock | 16.6075 | 16.6075 | 16.6075 | 16.6075 | 4060.0 |
| 2013-03-26 07:52:00 | AAPL | Stock | 16.6071 | 16.6071 | 16.6054 | 16.6054 | 14000.0 |
| 2013-03-26 07:53:00 | AAPL | Stock | 16.5968 | 16.5968 | 16.5957 | 16.5957 | 14000.0 |
| 2013-03-26 07:56:00 | AAPL | Stock | 16.6011 | 16.6011 | 16.6011 | 16.6011 | 2800.0 |
| 2013-03-26 07:57:00 | AAPL | Stock | 16.5968 | 16.5968 | 16.5821 | 16.5821 | 76440.0 |
| 2013-03-26 08:00:00 | AAPL | Stock | 16.585 | 16.6464 | 16.5771 | 16.5839 | 170632.0 |
| 2013-03-26 08:01:00 | AAPL | Stock | 16.5786 | 16.5911 | 16.5764 | 16.5804 | 80920.0 |
| 2013-03-26 08:02:00 | AAPL | Stock | 16.5768 | 16.5804 | 16.5768 | 16.5804 | 16800.0 |
| 2013-03-26 08:03:00 | AAPL | Stock | 16.58 | 16.5904 | 16.58 | 16.5896 | 41860.0 |
| 2013-03-26 08:04:00 | AAPL | Stock | 16.5979 | 16.6036 | 16.5786 | 16.5786 | 170604.0 |
| 2013-03-26 08:05:00 | AAPL | Stock | 16.5771 | 16.5771 | 16.5532 | 16.5536 | 208936.0 |
| 2013-03-26 08:06:00 | AAPL | Stock | 16.5532 | 16.5621 | 16.5339 | 16.5621 | 159684.0 |
| 2013-03-26 08:08:00 | AAPL | Stock | 16.5589 | 16.5714 | 16.5589 | 16.5625 | 56140.0 |
| 2013-03-26 08:09:00 | AAPL | Stock | 16.5557 | 16.5557 | 16.5554 | 16.5557 | 32200.0 |
| 2013-03-26 08:10:00 | AAPL | Stock | 16.54 | 16.54 | 16.5379 | 16.5379 | 8400.0 |
| 2013-03-26 08:11:00 | AAPL | Stock | 16.5375 | 16.5375 | 16.5357 | 16.5364 | 31640.0 |
| 2013-03-26 08:12:00 | AAPL | Stock | 16.5496 | 16.5536 | 16.5496 | 16.5536 | 21980.0 |
| 2013-03-26 08:13:00 | AAPL | Stock | 16.5625 | 16.5654 | 16.5625 | 16.5625 | 55160.0 |
| 2013-03-26 08:14:00 | AAPL | Stock | 16.5604 | 16.5607 | 16.5557 | 16.5589 | 16380.0 |
| 2013-03-26 08:15:00 | AAPL | Stock | 16.5625 | 16.5625 | 16.5625 | 16.5625 | 8400.0 |
| 2013-03-26 08:16:00 | AAPL | Stock | 16.5646 | 16.5679 | 16.5582 | 16.5643 | 27300.0 |
| 2013-03-26 08:18:00 | AAPL | Stock | 16.5696 | 16.5696 | 16.5675 | 16.5675 | 5600.0 |
> showing 50 of 950,869 rows — these rows as CSV