PREVIEW / stock_5min / 2016-05-17
file: by_date/stock_5min/2016/2016-05-17.parquet size: 5.4 MB rows: 361,542 symbols: 3,324
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-05-17 04:00:00 | AAPL | Stock | 23.5 | 23.75 | 23.5 | 23.6925 | 43308.0 |
| 2016-05-17 04:05:00 | AAPL | Stock | 23.7125 | 23.7375 | 23.7125 | 23.7125 | 12312.0 |
| 2016-05-17 04:10:00 | AAPL | Stock | 23.735 | 23.735 | 23.7125 | 23.7125 | 1700.0 |
| 2016-05-17 04:15:00 | AAPL | Stock | 23.705 | 23.705 | 23.705 | 23.705 | 800.0 |
| 2016-05-17 04:20:00 | AAPL | Stock | 23.705 | 23.705 | 23.7025 | 23.7025 | 2416.0 |
| 2016-05-17 04:25:00 | AAPL | Stock | 23.7 | 23.7 | 23.675 | 23.675 | 11924.0 |
| 2016-05-17 04:30:00 | AAPL | Stock | 23.7 | 23.7 | 23.7 | 23.7 | 400.0 |
| 2016-05-17 04:35:00 | AAPL | Stock | 23.7 | 23.7 | 23.6975 | 23.6975 | 4800.0 |
| 2016-05-17 04:40:00 | AAPL | Stock | 23.7 | 23.7 | 23.7 | 23.7 | 800.0 |
| 2016-05-17 04:45:00 | AAPL | Stock | 23.7 | 23.7 | 23.7 | 23.7 | 2800.0 |
| 2016-05-17 04:55:00 | AAPL | Stock | 23.6975 | 23.7 | 23.6975 | 23.7 | 14608.0 |
| 2016-05-17 05:00:00 | AAPL | Stock | 23.6975 | 23.6975 | 23.6975 | 23.6975 | 800.0 |
| 2016-05-17 05:05:00 | AAPL | Stock | 23.6875 | 23.6875 | 23.6875 | 23.6875 | 3216.0 |
| 2016-05-17 05:10:00 | AAPL | Stock | 23.6875 | 23.7125 | 23.6875 | 23.7 | 58624.0 |
| 2016-05-17 05:15:00 | AAPL | Stock | 23.7 | 23.7 | 23.685 | 23.685 | 45212.0 |
| 2016-05-17 05:20:00 | AAPL | Stock | 23.68 | 23.68 | 23.675 | 23.675 | 18400.0 |
| 2016-05-17 05:25:00 | AAPL | Stock | 23.665 | 23.665 | 23.665 | 23.665 | 24000.0 |
| 2016-05-17 05:30:00 | AAPL | Stock | 23.685 | 23.685 | 23.685 | 23.685 | 2216.0 |
| 2016-05-17 05:35:00 | AAPL | Stock | 23.675 | 23.675 | 23.675 | 23.675 | 10000.0 |
| 2016-05-17 05:40:00 | AAPL | Stock | 23.67 | 23.685 | 23.67 | 23.685 | 6784.0 |
| 2016-05-17 05:45:00 | AAPL | Stock | 23.67 | 23.67 | 23.67 | 23.67 | 9132.0 |
| 2016-05-17 05:50:00 | AAPL | Stock | 23.665 | 23.6875 | 23.655 | 23.6875 | 3848.0 |
| 2016-05-17 05:55:00 | AAPL | Stock | 23.675 | 23.675 | 23.6625 | 23.6625 | 4000.0 |
| 2016-05-17 06:00:00 | AAPL | Stock | 23.6875 | 23.7225 | 23.6875 | 23.7225 | 27280.0 |
| 2016-05-17 06:05:00 | AAPL | Stock | 23.7125 | 23.7225 | 23.7125 | 23.7225 | 10484.0 |
| 2016-05-17 06:10:00 | AAPL | Stock | 23.7 | 23.7475 | 23.7 | 23.745 | 10396.0 |
| 2016-05-17 06:20:00 | AAPL | Stock | 23.725 | 23.745 | 23.7175 | 23.725 | 13560.0 |
| 2016-05-17 06:25:00 | AAPL | Stock | 23.7425 | 23.7425 | 23.7 | 23.7 | 11504.0 |
| 2016-05-17 06:35:00 | AAPL | Stock | 23.73 | 23.73 | 23.73 | 23.73 | 420.0 |
| 2016-05-17 06:40:00 | AAPL | Stock | 23.72 | 23.72 | 23.6975 | 23.6975 | 7708.0 |
| 2016-05-17 06:45:00 | AAPL | Stock | 23.6975 | 23.6975 | 23.6525 | 23.665 | 22500.0 |
| 2016-05-17 06:50:00 | AAPL | Stock | 23.665 | 23.675 | 23.6525 | 23.675 | 13380.0 |
| 2016-05-17 06:55:00 | AAPL | Stock | 23.66 | 23.675 | 23.625 | 23.625 | 53964.0 |
| 2016-05-17 07:00:00 | AAPL | Stock | 23.66 | 23.66 | 23.625 | 23.645 | 17840.0 |
| 2016-05-17 07:05:00 | AAPL | Stock | 23.6275 | 23.6375 | 23.6175 | 23.6175 | 31292.0 |
| 2016-05-17 07:10:00 | AAPL | Stock | 23.615 | 23.6175 | 23.5775 | 23.5775 | 43672.0 |
| 2016-05-17 07:15:00 | AAPL | Stock | 23.5775 | 23.5925 | 23.5675 | 23.5675 | 35040.0 |
| 2016-05-17 07:20:00 | AAPL | Stock | 23.5725 | 23.585 | 23.5525 | 23.575 | 35556.0 |
| 2016-05-17 07:25:00 | AAPL | Stock | 23.57 | 23.6 | 23.57 | 23.585 | 15248.0 |
| 2016-05-17 07:30:00 | AAPL | Stock | 23.59 | 23.61 | 23.565 | 23.5825 | 7512.0 |
| 2016-05-17 07:35:00 | AAPL | Stock | 23.5825 | 23.5825 | 23.565 | 23.565 | 3952.0 |
| 2016-05-17 07:40:00 | AAPL | Stock | 23.5825 | 23.5875 | 23.5825 | 23.5875 | 4080.0 |
| 2016-05-17 07:45:00 | AAPL | Stock | 23.5925 | 23.6075 | 23.5925 | 23.6075 | 8140.0 |
| 2016-05-17 07:50:00 | AAPL | Stock | 23.6075 | 23.6125 | 23.6 | 23.6125 | 11564.0 |
| 2016-05-17 07:55:00 | AAPL | Stock | 23.6125 | 23.6125 | 23.6125 | 23.6125 | 800.0 |
| 2016-05-17 08:00:00 | AAPL | Stock | 23.6 | 23.66 | 23.5675 | 23.5775 | 130852.0 |
| 2016-05-17 08:05:00 | AAPL | Stock | 23.5875 | 23.59 | 23.575 | 23.5775 | 21264.0 |
| 2016-05-17 08:10:00 | AAPL | Stock | 23.5775 | 23.6025 | 23.5775 | 23.6025 | 15524.0 |
| 2016-05-17 08:15:00 | AAPL | Stock | 23.6025 | 23.6025 | 23.5775 | 23.5775 | 18516.0 |
| 2016-05-17 08:20:00 | AAPL | Stock | 23.5825 | 23.5875 | 23.5625 | 23.5775 | 51828.0 |
> showing 50 of 361,542 rows — these rows as CSV