PREVIEW / stock_1min / 2016-11-16
file: by_date/stock_1min/2016/2016-11-16.parquet size: 15.3 MB rows: 1,097,488 symbols: 2,626
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 |
|---|---|---|---|---|---|---|---|
| 2016-11-16 04:17:00 | AAPL | Stock | 26.7775 | 26.7775 | 26.7775 | 26.7775 | 400.0 |
| 2016-11-16 04:18:00 | AAPL | Stock | 26.75 | 26.75 | 26.75 | 26.75 | 868.0 |
| 2016-11-16 04:19:00 | AAPL | Stock | 26.85 | 26.8525 | 26.85 | 26.8525 | 2960.0 |
| 2016-11-16 04:42:00 | AAPL | Stock | 26.7525 | 26.7525 | 26.7525 | 26.7525 | 460.0 |
| 2016-11-16 04:51:00 | AAPL | Stock | 26.79 | 26.79 | 26.79 | 26.79 | 1600.0 |
| 2016-11-16 04:56:00 | AAPL | Stock | 26.755 | 26.755 | 26.755 | 26.755 | 720.0 |
| 2016-11-16 04:59:00 | AAPL | Stock | 26.7375 | 26.7375 | 26.73 | 26.73 | 800.0 |
| 2016-11-16 05:08:00 | AAPL | Stock | 26.715 | 26.715 | 26.715 | 26.715 | 400.0 |
| 2016-11-16 05:20:00 | AAPL | Stock | 26.715 | 26.715 | 26.715 | 26.715 | 812.0 |
| 2016-11-16 05:37:00 | AAPL | Stock | 26.7125 | 26.7125 | 26.7125 | 26.7125 | 1216.0 |
| 2016-11-16 06:04:00 | AAPL | Stock | 26.7125 | 26.7125 | 26.7125 | 26.7125 | 400.0 |
| 2016-11-16 06:06:00 | AAPL | Stock | 26.7375 | 26.7375 | 26.7375 | 26.7375 | 800.0 |
| 2016-11-16 06:10:00 | AAPL | Stock | 26.7125 | 26.7125 | 26.7125 | 26.7125 | 2800.0 |
| 2016-11-16 06:20:00 | AAPL | Stock | 26.725 | 26.725 | 26.725 | 26.725 | 676.0 |
| 2016-11-16 06:22:00 | AAPL | Stock | 26.725 | 26.725 | 26.725 | 26.725 | 400.0 |
| 2016-11-16 06:27:00 | AAPL | Stock | 26.725 | 26.725 | 26.725 | 26.725 | 400.0 |
| 2016-11-16 06:28:00 | AAPL | Stock | 26.7225 | 26.7225 | 26.7225 | 26.7225 | 2000.0 |
| 2016-11-16 06:32:00 | AAPL | Stock | 26.7225 | 26.7225 | 26.7225 | 26.7225 | 400.0 |
| 2016-11-16 06:33:00 | AAPL | Stock | 26.7225 | 26.7225 | 26.7125 | 26.7125 | 2884.0 |
| 2016-11-16 06:36:00 | AAPL | Stock | 26.7125 | 26.7125 | 26.7125 | 26.7125 | 800.0 |
| 2016-11-16 06:37:00 | AAPL | Stock | 26.7125 | 26.7125 | 26.7125 | 26.7125 | 1200.0 |
| 2016-11-16 06:38:00 | AAPL | Stock | 26.7125 | 26.7125 | 26.7125 | 26.7125 | 800.0 |
| 2016-11-16 06:39:00 | AAPL | Stock | 26.7125 | 26.7125 | 26.7125 | 26.7125 | 1600.0 |
| 2016-11-16 06:46:00 | AAPL | Stock | 26.7125 | 26.7125 | 26.7125 | 26.7125 | 400.0 |
| 2016-11-16 07:05:00 | AAPL | Stock | 26.7025 | 26.7025 | 26.7025 | 26.7025 | 2800.0 |
| 2016-11-16 07:10:00 | AAPL | Stock | 26.695 | 26.695 | 26.695 | 26.695 | 600.0 |
| 2016-11-16 07:12:00 | AAPL | Stock | 26.6825 | 26.6825 | 26.655 | 26.655 | 4000.0 |
| 2016-11-16 07:13:00 | AAPL | Stock | 26.6325 | 26.6325 | 26.63 | 26.63 | 1744.0 |
| 2016-11-16 07:21:00 | AAPL | Stock | 26.63 | 26.63 | 26.63 | 26.63 | 3800.0 |
| 2016-11-16 07:24:00 | AAPL | Stock | 26.64 | 26.64 | 26.64 | 26.64 | 400.0 |
| 2016-11-16 07:25:00 | AAPL | Stock | 26.64 | 26.64 | 26.625 | 26.625 | 6800.0 |
| 2016-11-16 07:26:00 | AAPL | Stock | 26.625 | 26.625 | 26.625 | 26.625 | 764.0 |
| 2016-11-16 07:33:00 | AAPL | Stock | 26.6275 | 26.6275 | 26.625 | 26.625 | 3800.0 |
| 2016-11-16 07:46:00 | AAPL | Stock | 26.66 | 26.6625 | 26.66 | 26.6625 | 800.0 |
| 2016-11-16 07:47:00 | AAPL | Stock | 26.6425 | 26.6425 | 26.64 | 26.64 | 1200.0 |
| 2016-11-16 08:00:00 | AAPL | Stock | 26.665 | 26.7125 | 26.625 | 26.675 | 28856.0 |
| 2016-11-16 08:01:00 | AAPL | Stock | 26.65 | 26.65 | 26.65 | 26.65 | 816.0 |
| 2016-11-16 08:03:00 | AAPL | Stock | 26.675 | 26.675 | 26.65 | 26.65 | 3768.0 |
| 2016-11-16 08:04:00 | AAPL | Stock | 26.65 | 26.65 | 26.65 | 26.65 | 412.0 |
| 2016-11-16 08:05:00 | AAPL | Stock | 26.65 | 26.65 | 26.65 | 26.65 | 1200.0 |
| 2016-11-16 08:06:00 | AAPL | Stock | 26.65 | 26.65 | 26.65 | 26.65 | 2000.0 |
| 2016-11-16 08:07:00 | AAPL | Stock | 26.65 | 26.65 | 26.65 | 26.65 | 400.0 |
| 2016-11-16 08:10:00 | AAPL | Stock | 26.6675 | 26.6675 | 26.6675 | 26.6675 | 1200.0 |
| 2016-11-16 08:15:00 | AAPL | Stock | 26.6675 | 26.6725 | 26.6675 | 26.6725 | 3200.0 |
| 2016-11-16 08:16:00 | AAPL | Stock | 26.6725 | 26.6725 | 26.6725 | 26.6725 | 4400.0 |
| 2016-11-16 08:18:00 | AAPL | Stock | 26.66 | 26.66 | 26.66 | 26.66 | 1600.0 |
| 2016-11-16 08:20:00 | AAPL | Stock | 26.6525 | 26.6525 | 26.65 | 26.65 | 2460.0 |
| 2016-11-16 08:21:00 | AAPL | Stock | 26.65 | 26.65 | 26.6375 | 26.6375 | 11668.0 |
| 2016-11-16 08:22:00 | AAPL | Stock | 26.6425 | 26.6425 | 26.6425 | 26.6425 | 400.0 |
| 2016-11-16 08:23:00 | AAPL | Stock | 26.65 | 26.65 | 26.65 | 26.65 | 4000.0 |
> showing 50 of 1,097,488 rows — these rows as CSV