PREVIEW / stock_5min / 2016-03-23
file: by_date/stock_5min/2016/2016-03-23.parquet size: 5.3 MB rows: 355,071 symbols: 3,340
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-03-23 04:00:00 | AAPL | Stock | 26.675 | 26.68 | 26.675 | 26.68 | 5600.0 |
| 2016-03-23 04:05:00 | AAPL | Stock | 26.68 | 26.68 | 26.68 | 26.68 | 400.0 |
| 2016-03-23 04:15:00 | AAPL | Stock | 26.735 | 26.735 | 26.735 | 26.735 | 1440.0 |
| 2016-03-23 04:20:00 | AAPL | Stock | 26.74 | 26.74 | 26.74 | 26.74 | 1840.0 |
| 2016-03-23 04:25:00 | AAPL | Stock | 26.7425 | 26.7425 | 26.7425 | 26.7425 | 2960.0 |
| 2016-03-23 04:45:00 | AAPL | Stock | 26.7425 | 26.7425 | 26.7425 | 26.7425 | 400.0 |
| 2016-03-23 04:50:00 | AAPL | Stock | 26.7425 | 26.7425 | 26.7425 | 26.7425 | 560.0 |
| 2016-03-23 05:00:00 | AAPL | Stock | 26.7325 | 26.7325 | 26.7325 | 26.7325 | 800.0 |
| 2016-03-23 05:05:00 | AAPL | Stock | 26.735 | 26.735 | 26.735 | 26.735 | 472.0 |
| 2016-03-23 05:30:00 | AAPL | Stock | 26.715 | 26.715 | 26.715 | 26.715 | 1200.0 |
| 2016-03-23 05:35:00 | AAPL | Stock | 26.715 | 26.715 | 26.715 | 26.715 | 800.0 |
| 2016-03-23 05:55:00 | AAPL | Stock | 26.7 | 26.715 | 26.7 | 26.715 | 7772.0 |
| 2016-03-23 06:20:00 | AAPL | Stock | 26.695 | 26.695 | 26.695 | 26.695 | 400.0 |
| 2016-03-23 07:00:00 | AAPL | Stock | 26.6875 | 26.6875 | 26.68 | 26.68 | 1200.0 |
| 2016-03-23 07:10:00 | AAPL | Stock | 26.685 | 26.685 | 26.685 | 26.685 | 400.0 |
| 2016-03-23 07:15:00 | AAPL | Stock | 26.68 | 26.6925 | 26.68 | 26.6925 | 2800.0 |
| 2016-03-23 07:20:00 | AAPL | Stock | 26.7 | 26.7 | 26.7 | 26.7 | 400.0 |
| 2016-03-23 07:25:00 | AAPL | Stock | 26.7075 | 26.74 | 26.7075 | 26.7375 | 14152.0 |
| 2016-03-23 08:00:00 | AAPL | Stock | 26.7125 | 26.74 | 26.625 | 26.685 | 21332.0 |
| 2016-03-23 08:05:00 | AAPL | Stock | 26.7 | 26.7125 | 26.685 | 26.7125 | 25200.0 |
| 2016-03-23 08:10:00 | AAPL | Stock | 26.72 | 26.7225 | 26.72 | 26.72 | 6172.0 |
| 2016-03-23 08:15:00 | AAPL | Stock | 26.715 | 26.715 | 26.695 | 26.7075 | 7400.0 |
| 2016-03-23 08:20:00 | AAPL | Stock | 26.695 | 26.705 | 26.6875 | 26.705 | 10436.0 |
| 2016-03-23 08:25:00 | AAPL | Stock | 26.705 | 26.705 | 26.6825 | 26.6975 | 7000.0 |
| 2016-03-23 08:30:00 | AAPL | Stock | 26.675 | 26.7 | 26.675 | 26.7 | 13880.0 |
| 2016-03-23 08:35:00 | AAPL | Stock | 26.7025 | 26.7025 | 26.7 | 26.7025 | 5288.0 |
| 2016-03-23 08:40:00 | AAPL | Stock | 26.7075 | 26.7075 | 26.7 | 26.7 | 6800.0 |
| 2016-03-23 08:45:00 | AAPL | Stock | 26.7025 | 26.71 | 26.7025 | 26.71 | 8000.0 |
| 2016-03-23 08:50:00 | AAPL | Stock | 26.71 | 26.71 | 26.7 | 26.71 | 20868.0 |
| 2016-03-23 08:55:00 | AAPL | Stock | 26.7025 | 26.7025 | 26.695 | 26.695 | 31088.0 |
| 2016-03-23 09:00:00 | AAPL | Stock | 26.685 | 26.685 | 26.6725 | 26.6725 | 9760.0 |
| 2016-03-23 09:05:00 | AAPL | Stock | 26.6825 | 26.69 | 26.655 | 26.685 | 23308.0 |
| 2016-03-23 09:10:00 | AAPL | Stock | 26.69 | 26.69 | 26.66 | 26.6775 | 168704.0 |
| 2016-03-23 09:15:00 | AAPL | Stock | 26.6775 | 26.6825 | 26.6675 | 26.6675 | 44356.0 |
| 2016-03-23 09:20:00 | AAPL | Stock | 26.675 | 26.6875 | 26.675 | 26.675 | 27600.0 |
| 2016-03-23 09:25:00 | AAPL | Stock | 26.695 | 26.705 | 26.615 | 26.6175 | 106124.0 |
| 2016-03-23 09:30:00 | AAPL | Stock | 26.6175 | 26.7 | 26.6075 | 26.6825 | 3705756.0 |
| 2016-03-23 09:35:00 | AAPL | Stock | 26.6875 | 26.695 | 26.63 | 26.69 | 2165680.0 |
| 2016-03-23 09:40:00 | AAPL | Stock | 26.685 | 26.685 | 26.565 | 26.605 | 2105580.0 |
| 2016-03-23 09:45:00 | AAPL | Stock | 26.6075 | 26.6275 | 26.575 | 26.5875 | 2093856.0 |
| 2016-03-23 09:50:00 | AAPL | Stock | 26.5878 | 26.6275 | 26.57 | 26.59 | 1812716.0 |
| 2016-03-23 09:55:00 | AAPL | Stock | 26.5925 | 26.5975 | 26.555 | 26.57 | 1606792.0 |
| 2016-03-23 10:00:00 | AAPL | Stock | 26.57 | 26.6125 | 26.565 | 26.58 | 1476504.0 |
| 2016-03-23 10:05:00 | AAPL | Stock | 26.58 | 26.58 | 26.5425 | 26.5625 | 1478324.0 |
| 2016-03-23 10:10:00 | AAPL | Stock | 26.5625 | 26.6125 | 26.5525 | 26.61 | 1819288.0 |
| 2016-03-23 10:15:00 | AAPL | Stock | 26.6125 | 26.635 | 26.59 | 26.615 | 1895708.0 |
| 2016-03-23 10:20:00 | AAPL | Stock | 26.6175 | 26.6275 | 26.59 | 26.6 | 902856.0 |
| 2016-03-23 10:25:00 | AAPL | Stock | 26.6 | 26.6175 | 26.58 | 26.6075 | 793012.0 |
| 2016-03-23 10:30:00 | AAPL | Stock | 26.605 | 26.6375 | 26.5725 | 26.6075 | 1571036.0 |
| 2016-03-23 10:35:00 | AAPL | Stock | 26.6052 | 26.61 | 26.565 | 26.589 | 1284140.0 |
> showing 50 of 355,071 rows — these rows as CSV