PREVIEW / stock_5min / 2016-11-03
file: by_date/stock_5min/2016/2016-11-03.parquet size: 5.3 MB rows: 346,381 symbols: 3,173
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-03 04:00:00 | AAPL | Stock | 27.685 | 27.685 | 27.665 | 27.665 | 2320.0 |
| 2016-11-03 04:05:00 | AAPL | Stock | 27.68 | 27.68 | 27.68 | 27.68 | 4000.0 |
| 2016-11-03 04:30:00 | AAPL | Stock | 27.675 | 27.675 | 27.675 | 27.675 | 400.0 |
| 2016-11-03 04:40:00 | AAPL | Stock | 27.6625 | 27.6625 | 27.6625 | 27.6625 | 2000.0 |
| 2016-11-03 04:55:00 | AAPL | Stock | 27.6825 | 27.6825 | 27.6825 | 27.6825 | 400.0 |
| 2016-11-03 05:05:00 | AAPL | Stock | 27.6825 | 27.685 | 27.6825 | 27.685 | 10296.0 |
| 2016-11-03 05:25:00 | AAPL | Stock | 27.6825 | 27.6825 | 27.6825 | 27.6825 | 400.0 |
| 2016-11-03 05:50:00 | AAPL | Stock | 27.7275 | 27.7325 | 27.7275 | 27.7325 | 1308.0 |
| 2016-11-03 06:05:00 | AAPL | Stock | 27.73 | 27.73 | 27.73 | 27.73 | 960.0 |
| 2016-11-03 06:20:00 | AAPL | Stock | 27.7325 | 27.7325 | 27.7325 | 27.7325 | 1364.0 |
| 2016-11-03 06:25:00 | AAPL | Stock | 27.7175 | 27.7175 | 27.7175 | 27.7175 | 2400.0 |
| 2016-11-03 06:35:00 | AAPL | Stock | 27.7 | 27.7 | 27.7 | 27.7 | 2880.0 |
| 2016-11-03 06:40:00 | AAPL | Stock | 27.7 | 27.7 | 27.7 | 27.7 | 2000.0 |
| 2016-11-03 06:50:00 | AAPL | Stock | 27.7 | 27.7125 | 27.7 | 27.7125 | 5480.0 |
| 2016-11-03 07:00:00 | AAPL | Stock | 27.7225 | 27.745 | 27.7225 | 27.745 | 4480.0 |
| 2016-11-03 07:05:00 | AAPL | Stock | 27.735 | 27.7675 | 27.735 | 27.7675 | 3240.0 |
| 2016-11-03 07:10:00 | AAPL | Stock | 27.79 | 27.7925 | 27.79 | 27.79 | 20508.0 |
| 2016-11-03 07:15:00 | AAPL | Stock | 27.775 | 27.79 | 27.775 | 27.79 | 13212.0 |
| 2016-11-03 07:25:00 | AAPL | Stock | 27.775 | 27.775 | 27.775 | 27.775 | 452.0 |
| 2016-11-03 07:40:00 | AAPL | Stock | 27.76 | 27.7925 | 27.76 | 27.7925 | 6504.0 |
| 2016-11-03 07:45:00 | AAPL | Stock | 27.79 | 27.79 | 27.79 | 27.79 | 400.0 |
| 2016-11-03 08:00:00 | AAPL | Stock | 27.735 | 27.8 | 27.735 | 27.7625 | 12600.0 |
| 2016-11-03 08:05:00 | AAPL | Stock | 27.7525 | 27.7525 | 27.735 | 27.735 | 35884.0 |
| 2016-11-03 08:10:00 | AAPL | Stock | 27.71 | 27.735 | 27.71 | 27.725 | 48600.0 |
| 2016-11-03 08:15:00 | AAPL | Stock | 27.72 | 27.745 | 27.72 | 27.74 | 28616.0 |
| 2016-11-03 08:20:00 | AAPL | Stock | 27.7375 | 27.75 | 27.7375 | 27.75 | 5060.0 |
| 2016-11-03 08:25:00 | AAPL | Stock | 27.745 | 27.745 | 27.7275 | 27.7275 | 4392.0 |
| 2016-11-03 08:30:00 | AAPL | Stock | 27.7275 | 27.7425 | 27.7275 | 27.7425 | 10220.0 |
| 2016-11-03 08:35:00 | AAPL | Stock | 27.75 | 27.75 | 27.7175 | 27.7325 | 21692.0 |
| 2016-11-03 08:40:00 | AAPL | Stock | 27.72 | 27.7375 | 27.72 | 27.725 | 9200.0 |
| 2016-11-03 08:45:00 | AAPL | Stock | 27.745 | 27.745 | 27.7 | 27.71 | 35588.0 |
| 2016-11-03 08:50:00 | AAPL | Stock | 27.725 | 27.7575 | 27.7125 | 27.745 | 62952.0 |
| 2016-11-03 08:55:00 | AAPL | Stock | 27.7375 | 27.745 | 27.725 | 27.7425 | 26060.0 |
| 2016-11-03 09:00:00 | AAPL | Stock | 27.725 | 27.75 | 27.7175 | 27.7375 | 27700.0 |
| 2016-11-03 09:05:00 | AAPL | Stock | 27.7275 | 27.7475 | 27.7275 | 27.7425 | 21960.0 |
| 2016-11-03 09:10:00 | AAPL | Stock | 27.725 | 27.7375 | 27.725 | 27.7375 | 13600.0 |
| 2016-11-03 09:15:00 | AAPL | Stock | 27.73 | 27.7525 | 27.725 | 27.7525 | 21784.0 |
| 2016-11-03 09:20:00 | AAPL | Stock | 27.7625 | 27.7625 | 27.75 | 27.75 | 20456.0 |
| 2016-11-03 09:25:00 | AAPL | Stock | 27.7475 | 27.75 | 27.7325 | 27.7375 | 32516.0 |
| 2016-11-03 09:30:00 | AAPL | Stock | 27.745 | 27.76 | 27.675 | 27.7515 | 3137216.0 |
| 2016-11-03 09:35:00 | AAPL | Stock | 27.7525 | 27.865 | 27.7488 | 27.8448 | 2346308.0 |
| 2016-11-03 09:40:00 | AAPL | Stock | 27.8475 | 27.8575 | 27.7725 | 27.7725 | 1190792.0 |
| 2016-11-03 09:45:00 | AAPL | Stock | 27.7738 | 27.8275 | 27.75 | 27.7775 | 1261580.0 |
| 2016-11-03 09:50:00 | AAPL | Stock | 27.7755 | 27.8112 | 27.735 | 27.745 | 1360180.0 |
| 2016-11-03 09:55:00 | AAPL | Stock | 27.7425 | 27.7825 | 27.74 | 27.75 | 753212.0 |
| 2016-11-03 10:00:00 | AAPL | Stock | 27.7475 | 27.7575 | 27.72 | 27.7325 | 1176816.0 |
| 2016-11-03 10:05:00 | AAPL | Stock | 27.7325 | 27.76 | 27.72 | 27.7378 | 1284500.0 |
| 2016-11-03 10:10:00 | AAPL | Stock | 27.74 | 27.759 | 27.725 | 27.755 | 843296.0 |
| 2016-11-03 10:15:00 | AAPL | Stock | 27.7562 | 27.7562 | 27.68 | 27.69 | 1006348.0 |
| 2016-11-03 10:20:00 | AAPL | Stock | 27.6925 | 27.7225 | 27.68 | 27.685 | 1030704.0 |
> showing 50 of 346,381 rows — these rows as CSV