PREVIEW / stock_1min / 2012-10-16
file: by_date/stock_1min/2012/2012-10-16.parquet size: 12.2 MB rows: 902,930 symbols: 2,815
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 |
|---|---|---|---|---|---|---|---|
| 2012-10-16 04:29:00 | AAPL | Stock | 22.7464 | 22.7464 | 22.7464 | 22.7464 | 13440.0 |
| 2012-10-16 04:39:00 | AAPL | Stock | 22.7557 | 22.7557 | 22.7557 | 22.7557 | 2800.0 |
| 2012-10-16 04:59:00 | AAPL | Stock | 22.7679 | 22.7679 | 22.7679 | 22.7679 | 2800.0 |
| 2012-10-16 05:13:00 | AAPL | Stock | 22.7571 | 22.7571 | 22.7429 | 22.7429 | 23044.0 |
| 2012-10-16 05:18:00 | AAPL | Stock | 22.7679 | 22.7679 | 22.7679 | 22.7679 | 2800.0 |
| 2012-10-16 05:32:00 | AAPL | Stock | 22.7607 | 22.7607 | 22.7607 | 22.7607 | 5600.0 |
| 2012-10-16 05:39:00 | AAPL | Stock | 22.7607 | 22.7607 | 22.7607 | 22.7607 | 10360.0 |
| 2012-10-16 05:45:00 | AAPL | Stock | 22.7571 | 22.7571 | 22.7571 | 22.7571 | 4200.0 |
| 2012-10-16 05:47:00 | AAPL | Stock | 22.7854 | 22.7854 | 22.7854 | 22.7854 | 8400.0 |
| 2012-10-16 05:49:00 | AAPL | Stock | 22.7964 | 22.8014 | 22.7936 | 22.7936 | 12432.0 |
| 2012-10-16 06:24:00 | AAPL | Stock | 22.7786 | 22.7786 | 22.7786 | 22.7786 | 2800.0 |
| 2012-10-16 06:25:00 | AAPL | Stock | 22.7786 | 22.7786 | 22.7786 | 22.7786 | 5600.0 |
| 2012-10-16 06:33:00 | AAPL | Stock | 22.7718 | 22.7718 | 22.7714 | 22.7714 | 9632.0 |
| 2012-10-16 06:34:00 | AAPL | Stock | 22.7786 | 22.7786 | 22.7786 | 22.7786 | 2800.0 |
| 2012-10-16 06:36:00 | AAPL | Stock | 22.7786 | 22.7786 | 22.7786 | 22.7786 | 5600.0 |
| 2012-10-16 06:46:00 | AAPL | Stock | 22.7596 | 22.7596 | 22.7593 | 22.7593 | 16156.0 |
| 2012-10-16 06:47:00 | AAPL | Stock | 22.7786 | 22.7786 | 22.7786 | 22.7786 | 5600.0 |
| 2012-10-16 06:49:00 | AAPL | Stock | 22.7786 | 22.7786 | 22.7786 | 22.7786 | 5600.0 |
| 2012-10-16 06:50:00 | AAPL | Stock | 22.7857 | 22.7857 | 22.7857 | 22.7857 | 2800.0 |
| 2012-10-16 06:55:00 | AAPL | Stock | 22.7804 | 22.7936 | 22.7804 | 22.7936 | 8400.0 |
| 2012-10-16 06:56:00 | AAPL | Stock | 22.7804 | 22.7804 | 22.7804 | 22.7804 | 11200.0 |
| 2012-10-16 06:59:00 | AAPL | Stock | 22.7893 | 22.7936 | 22.7893 | 22.7936 | 8848.0 |
| 2012-10-16 07:01:00 | AAPL | Stock | 22.7986 | 22.7986 | 22.7986 | 22.7986 | 2800.0 |
| 2012-10-16 07:02:00 | AAPL | Stock | 22.7964 | 22.7964 | 22.7957 | 22.7957 | 16800.0 |
| 2012-10-16 07:03:00 | AAPL | Stock | 22.7882 | 22.7882 | 22.7804 | 22.7804 | 41580.0 |
| 2012-10-16 07:04:00 | AAPL | Stock | 22.7679 | 22.7679 | 22.7679 | 22.7679 | 4872.0 |
| 2012-10-16 07:05:00 | AAPL | Stock | 22.7536 | 22.7643 | 22.7536 | 22.7643 | 14000.0 |
| 2012-10-16 07:06:00 | AAPL | Stock | 22.7643 | 22.7643 | 22.7643 | 22.7643 | 8400.0 |
| 2012-10-16 07:08:00 | AAPL | Stock | 22.7589 | 22.7625 | 22.7589 | 22.7593 | 19012.0 |
| 2012-10-16 07:09:00 | AAPL | Stock | 22.7643 | 22.7643 | 22.7643 | 22.7643 | 18060.0 |
| 2012-10-16 07:12:00 | AAPL | Stock | 22.7629 | 22.7629 | 22.7625 | 22.7625 | 8400.0 |
| 2012-10-16 07:14:00 | AAPL | Stock | 22.7614 | 22.7614 | 22.7614 | 22.7614 | 2800.0 |
| 2012-10-16 07:16:00 | AAPL | Stock | 22.7593 | 22.7593 | 22.7589 | 22.7589 | 16352.0 |
| 2012-10-16 07:18:00 | AAPL | Stock | 22.7589 | 22.7589 | 22.7589 | 22.7589 | 5600.0 |
| 2012-10-16 07:19:00 | AAPL | Stock | 22.7557 | 22.7557 | 22.7164 | 22.7164 | 20104.0 |
| 2012-10-16 07:22:00 | AAPL | Stock | 22.7318 | 22.7318 | 22.7318 | 22.7318 | 11200.0 |
| 2012-10-16 07:23:00 | AAPL | Stock | 22.7275 | 22.7318 | 22.7275 | 22.7318 | 7700.0 |
| 2012-10-16 07:24:00 | AAPL | Stock | 22.7196 | 22.73 | 22.7196 | 22.73 | 5600.0 |
| 2012-10-16 07:25:00 | AAPL | Stock | 22.73 | 22.73 | 22.73 | 22.73 | 2800.0 |
| 2012-10-16 07:26:00 | AAPL | Stock | 22.725 | 22.725 | 22.725 | 22.725 | 25900.0 |
| 2012-10-16 07:27:00 | AAPL | Stock | 22.7325 | 22.7325 | 22.7325 | 22.7325 | 2800.0 |
| 2012-10-16 07:29:00 | AAPL | Stock | 22.7418 | 22.7418 | 22.7264 | 22.7264 | 14000.0 |
| 2012-10-16 07:30:00 | AAPL | Stock | 22.7418 | 22.7457 | 22.7214 | 22.7457 | 95200.0 |
| 2012-10-16 07:34:00 | AAPL | Stock | 22.7407 | 22.7411 | 22.7407 | 22.7411 | 14000.0 |
| 2012-10-16 07:35:00 | AAPL | Stock | 22.7411 | 22.7589 | 22.7411 | 22.7589 | 31556.0 |
| 2012-10-16 07:36:00 | AAPL | Stock | 22.7332 | 22.7332 | 22.7325 | 22.7325 | 5600.0 |
| 2012-10-16 07:38:00 | AAPL | Stock | 22.7236 | 22.7236 | 22.7214 | 22.7214 | 11200.0 |
| 2012-10-16 07:40:00 | AAPL | Stock | 22.7296 | 22.7296 | 22.7296 | 22.7296 | 22400.0 |
| 2012-10-16 07:41:00 | AAPL | Stock | 22.7164 | 22.7164 | 22.7075 | 22.7075 | 50400.0 |
| 2012-10-16 07:43:00 | AAPL | Stock | 22.7161 | 22.7161 | 22.7161 | 22.7161 | 5600.0 |
> showing 50 of 902,930 rows — these rows as CSV