PREVIEW / stock_5min / 2016-01-20
file: by_date/stock_5min/2016/2016-01-20.parquet size: 6.0 MB rows: 395,256 symbols: 3,415
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-01-20 04:00:00 | AAPL | Stock | 23.875 | 23.875 | 23.5625 | 23.5625 | 24128.0 |
| 2016-01-20 04:05:00 | AAPL | Stock | 23.6 | 23.6225 | 23.575 | 23.6 | 12356.0 |
| 2016-01-20 04:10:00 | AAPL | Stock | 23.575 | 23.575 | 23.5225 | 23.5225 | 17400.0 |
| 2016-01-20 04:15:00 | AAPL | Stock | 23.5225 | 23.55 | 23.4175 | 23.55 | 41416.0 |
| 2016-01-20 04:25:00 | AAPL | Stock | 23.5475 | 23.6225 | 23.5475 | 23.6225 | 4368.0 |
| 2016-01-20 04:35:00 | AAPL | Stock | 23.555 | 23.555 | 23.555 | 23.555 | 780.0 |
| 2016-01-20 04:40:00 | AAPL | Stock | 23.6175 | 23.6175 | 23.6175 | 23.6175 | 520.0 |
| 2016-01-20 04:50:00 | AAPL | Stock | 23.62 | 23.68 | 23.62 | 23.68 | 10840.0 |
| 2016-01-20 04:55:00 | AAPL | Stock | 23.6825 | 23.6825 | 23.6825 | 23.6825 | 800.0 |
| 2016-01-20 05:00:00 | AAPL | Stock | 23.65 | 23.65 | 23.625 | 23.625 | 6600.0 |
| 2016-01-20 05:05:00 | AAPL | Stock | 23.625 | 23.625 | 23.6225 | 23.6225 | 1600.0 |
| 2016-01-20 05:10:00 | AAPL | Stock | 23.625 | 23.625 | 23.5825 | 23.5825 | 4600.0 |
| 2016-01-20 05:20:00 | AAPL | Stock | 23.605 | 23.605 | 23.6 | 23.6 | 1596.0 |
| 2016-01-20 05:25:00 | AAPL | Stock | 23.6375 | 23.6375 | 23.625 | 23.625 | 3800.0 |
| 2016-01-20 05:30:00 | AAPL | Stock | 23.625 | 23.625 | 23.6075 | 23.6075 | 3024.0 |
| 2016-01-20 05:35:00 | AAPL | Stock | 23.625 | 23.625 | 23.59 | 23.59 | 10472.0 |
| 2016-01-20 05:40:00 | AAPL | Stock | 23.59 | 23.615 | 23.585 | 23.615 | 11140.0 |
| 2016-01-20 05:45:00 | AAPL | Stock | 23.615 | 23.6375 | 23.615 | 23.625 | 19552.0 |
| 2016-01-20 05:50:00 | AAPL | Stock | 23.6125 | 23.6125 | 23.6125 | 23.6125 | 400.0 |
| 2016-01-20 05:55:00 | AAPL | Stock | 23.6125 | 23.6125 | 23.6125 | 23.6125 | 6436.0 |
| 2016-01-20 06:00:00 | AAPL | Stock | 23.635 | 23.65 | 23.635 | 23.65 | 23344.0 |
| 2016-01-20 06:05:00 | AAPL | Stock | 23.6375 | 23.64 | 23.625 | 23.625 | 2040.0 |
| 2016-01-20 06:10:00 | AAPL | Stock | 23.625 | 23.6425 | 23.6125 | 23.6425 | 7560.0 |
| 2016-01-20 06:15:00 | AAPL | Stock | 23.6375 | 23.6375 | 23.6325 | 23.6375 | 8304.0 |
| 2016-01-20 06:20:00 | AAPL | Stock | 23.6625 | 23.6725 | 23.65 | 23.65 | 5740.0 |
| 2016-01-20 06:25:00 | AAPL | Stock | 23.6525 | 23.6525 | 23.6425 | 23.6525 | 7624.0 |
| 2016-01-20 06:30:00 | AAPL | Stock | 23.6525 | 23.6675 | 23.6525 | 23.6525 | 3000.0 |
| 2016-01-20 06:35:00 | AAPL | Stock | 23.6525 | 23.6525 | 23.6125 | 23.6125 | 14400.0 |
| 2016-01-20 06:40:00 | AAPL | Stock | 23.6125 | 23.675 | 23.6125 | 23.675 | 12424.0 |
| 2016-01-20 06:45:00 | AAPL | Stock | 23.675 | 23.675 | 23.635 | 23.6575 | 6848.0 |
| 2016-01-20 06:50:00 | AAPL | Stock | 23.6675 | 23.67 | 23.64 | 23.64 | 3200.0 |
| 2016-01-20 06:55:00 | AAPL | Stock | 23.65 | 23.6975 | 23.65 | 23.6525 | 24964.0 |
| 2016-01-20 07:00:00 | AAPL | Stock | 23.67 | 23.775 | 23.67 | 23.7625 | 69252.0 |
| 2016-01-20 07:05:00 | AAPL | Stock | 23.7225 | 23.725 | 23.665 | 23.665 | 13156.0 |
| 2016-01-20 07:10:00 | AAPL | Stock | 23.6975 | 23.6975 | 23.6525 | 23.6525 | 10400.0 |
| 2016-01-20 07:15:00 | AAPL | Stock | 23.645 | 23.6625 | 23.645 | 23.66 | 5600.0 |
| 2016-01-20 07:20:00 | AAPL | Stock | 23.675 | 23.7125 | 23.675 | 23.7025 | 12400.0 |
| 2016-01-20 07:25:00 | AAPL | Stock | 23.7025 | 23.715 | 23.695 | 23.7125 | 22992.0 |
| 2016-01-20 07:30:00 | AAPL | Stock | 23.72 | 23.725 | 23.675 | 23.6875 | 39384.0 |
| 2016-01-20 07:35:00 | AAPL | Stock | 23.6725 | 23.6725 | 23.6625 | 23.6625 | 2300.0 |
| 2016-01-20 07:40:00 | AAPL | Stock | 23.665 | 23.665 | 23.65 | 23.665 | 23516.0 |
| 2016-01-20 07:45:00 | AAPL | Stock | 23.665 | 23.6975 | 23.665 | 23.6875 | 17600.0 |
| 2016-01-20 07:50:00 | AAPL | Stock | 23.7 | 23.75 | 23.7 | 23.7375 | 41680.0 |
| 2016-01-20 07:55:00 | AAPL | Stock | 23.7275 | 23.7475 | 23.6825 | 23.7 | 48812.0 |
| 2016-01-20 08:00:00 | AAPL | Stock | 23.715 | 23.775 | 23.625 | 23.6875 | 174304.0 |
| 2016-01-20 08:05:00 | AAPL | Stock | 23.6875 | 23.725 | 23.6625 | 23.725 | 289736.0 |
| 2016-01-20 08:10:00 | AAPL | Stock | 23.725 | 23.74 | 23.7 | 23.7125 | 81084.0 |
| 2016-01-20 08:15:00 | AAPL | Stock | 23.7 | 23.7125 | 23.7 | 23.71 | 66624.0 |
| 2016-01-20 08:20:00 | AAPL | Stock | 23.7125 | 23.7225 | 23.695 | 23.6975 | 203764.0 |
| 2016-01-20 08:25:00 | AAPL | Stock | 23.695 | 23.71 | 23.6875 | 23.7 | 79776.0 |
> showing 50 of 395,256 rows — these rows as CSV