PREVIEW / stock_1min / 2013-05-17
file: by_date/stock_1min/2013/2013-05-17.parquet size: 13.1 MB rows: 957,495 symbols: 2,845
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-05-17 05:31:00 | AAPL | Stock | 15.5357 | 15.5357 | 15.5357 | 15.5357 | 2800.0 |
| 2013-05-17 05:51:00 | AAPL | Stock | 15.5354 | 15.5357 | 15.5354 | 15.5357 | 5600.0 |
| 2013-05-17 06:09:00 | AAPL | Stock | 15.5357 | 15.5357 | 15.5357 | 15.5357 | 5600.0 |
| 2013-05-17 06:19:00 | AAPL | Stock | 15.535 | 15.535 | 15.535 | 15.535 | 2800.0 |
| 2013-05-17 06:26:00 | AAPL | Stock | 15.535 | 15.535 | 15.535 | 15.535 | 2800.0 |
| 2013-05-17 06:38:00 | AAPL | Stock | 15.535 | 15.535 | 15.535 | 15.535 | 2800.0 |
| 2013-05-17 06:41:00 | AAPL | Stock | 15.535 | 15.535 | 15.535 | 15.535 | 11200.0 |
| 2013-05-17 06:46:00 | AAPL | Stock | 15.5343 | 15.5518 | 15.5343 | 15.5518 | 26684.0 |
| 2013-05-17 06:58:00 | AAPL | Stock | 15.5861 | 15.5861 | 15.5861 | 15.5861 | 2800.0 |
| 2013-05-17 07:01:00 | AAPL | Stock | 15.5929 | 15.5929 | 15.5929 | 15.5929 | 3500.0 |
| 2013-05-17 07:02:00 | AAPL | Stock | 15.5982 | 15.6032 | 15.5946 | 15.6032 | 16800.0 |
| 2013-05-17 07:03:00 | AAPL | Stock | 15.6036 | 15.6036 | 15.5886 | 15.5914 | 18256.0 |
| 2013-05-17 07:04:00 | AAPL | Stock | 15.5964 | 15.6036 | 15.5964 | 15.6036 | 6384.0 |
| 2013-05-17 07:05:00 | AAPL | Stock | 15.6336 | 15.6336 | 15.6336 | 15.6336 | 3976.0 |
| 2013-05-17 07:06:00 | AAPL | Stock | 15.5971 | 15.5971 | 15.5971 | 15.5971 | 5600.0 |
| 2013-05-17 07:08:00 | AAPL | Stock | 15.6325 | 15.6325 | 15.6143 | 15.6143 | 12880.0 |
| 2013-05-17 07:11:00 | AAPL | Stock | 15.6243 | 15.6243 | 15.6182 | 15.6243 | 10640.0 |
| 2013-05-17 07:12:00 | AAPL | Stock | 15.6239 | 15.6239 | 15.6239 | 15.6239 | 2800.0 |
| 2013-05-17 07:13:00 | AAPL | Stock | 15.6286 | 15.6321 | 15.6286 | 15.6321 | 5600.0 |
| 2013-05-17 07:14:00 | AAPL | Stock | 15.6257 | 15.6257 | 15.625 | 15.625 | 5600.0 |
| 2013-05-17 07:15:00 | AAPL | Stock | 15.6214 | 15.6429 | 15.6214 | 15.6429 | 43400.0 |
| 2013-05-17 07:16:00 | AAPL | Stock | 15.6429 | 15.6429 | 15.6429 | 15.6429 | 2800.0 |
| 2013-05-17 07:17:00 | AAPL | Stock | 15.6321 | 15.6518 | 15.6321 | 15.6518 | 35672.0 |
| 2013-05-17 07:18:00 | AAPL | Stock | 15.6464 | 15.6464 | 15.6429 | 15.6429 | 22232.0 |
| 2013-05-17 07:19:00 | AAPL | Stock | 15.6393 | 15.6393 | 15.6393 | 15.6393 | 4200.0 |
| 2013-05-17 07:20:00 | AAPL | Stock | 15.6411 | 15.6714 | 15.6411 | 15.6714 | 225680.0 |
| 2013-05-17 07:21:00 | AAPL | Stock | 15.6643 | 15.6643 | 15.6625 | 15.6625 | 22400.0 |
| 2013-05-17 07:22:00 | AAPL | Stock | 15.6714 | 15.6714 | 15.6614 | 15.6614 | 6860.0 |
| 2013-05-17 07:23:00 | AAPL | Stock | 15.6714 | 15.6925 | 15.6682 | 15.6836 | 64260.0 |
| 2013-05-17 07:24:00 | AAPL | Stock | 15.6904 | 15.6929 | 15.6904 | 15.6929 | 26460.0 |
| 2013-05-17 07:25:00 | AAPL | Stock | 15.6925 | 15.6979 | 15.6925 | 15.6979 | 29792.0 |
| 2013-05-17 07:26:00 | AAPL | Stock | 15.6979 | 15.6979 | 15.6929 | 15.6929 | 47600.0 |
| 2013-05-17 07:27:00 | AAPL | Stock | 15.6921 | 15.6954 | 15.6911 | 15.6954 | 24500.0 |
| 2013-05-17 07:28:00 | AAPL | Stock | 15.6964 | 15.6964 | 15.6789 | 15.6789 | 30800.0 |
| 2013-05-17 07:29:00 | AAPL | Stock | 15.6789 | 15.6789 | 15.6689 | 15.6789 | 102172.0 |
| 2013-05-17 07:30:00 | AAPL | Stock | 15.6696 | 15.6707 | 15.6671 | 15.6682 | 25004.0 |
| 2013-05-17 07:31:00 | AAPL | Stock | 15.6679 | 15.6679 | 15.6679 | 15.6679 | 3360.0 |
| 2013-05-17 07:32:00 | AAPL | Stock | 15.6661 | 15.6786 | 15.6607 | 15.6786 | 79800.0 |
| 2013-05-17 07:33:00 | AAPL | Stock | 15.6786 | 15.6964 | 15.6786 | 15.6929 | 74200.0 |
| 2013-05-17 07:34:00 | AAPL | Stock | 15.6929 | 15.6964 | 15.6929 | 15.6964 | 11200.0 |
| 2013-05-17 07:35:00 | AAPL | Stock | 15.6964 | 15.7029 | 15.6964 | 15.6968 | 44800.0 |
| 2013-05-17 07:36:00 | AAPL | Stock | 15.7025 | 15.7204 | 15.7025 | 15.7179 | 174608.0 |
| 2013-05-17 07:37:00 | AAPL | Stock | 15.7204 | 15.7286 | 15.7204 | 15.7207 | 50400.0 |
| 2013-05-17 07:38:00 | AAPL | Stock | 15.7268 | 15.7268 | 15.7268 | 15.7268 | 2800.0 |
| 2013-05-17 07:39:00 | AAPL | Stock | 15.7221 | 15.7268 | 15.7214 | 15.7214 | 8400.0 |
| 2013-05-17 07:40:00 | AAPL | Stock | 15.7307 | 15.7432 | 15.7304 | 15.7429 | 127400.0 |
| 2013-05-17 07:41:00 | AAPL | Stock | 15.7443 | 15.7679 | 15.7443 | 15.7486 | 149884.0 |
| 2013-05-17 07:42:00 | AAPL | Stock | 15.7357 | 15.7357 | 15.7357 | 15.7357 | 11200.0 |
| 2013-05-17 07:43:00 | AAPL | Stock | 15.7443 | 15.7443 | 15.7321 | 15.7321 | 67620.0 |
| 2013-05-17 07:44:00 | AAPL | Stock | 15.7329 | 15.7329 | 15.7321 | 15.7321 | 25200.0 |
> showing 50 of 957,495 rows — these rows as CSV