PREVIEW / stock_5min / 2016-10-28
file: by_date/stock_5min/2016/2016-10-28.parquet size: 5.2 MB rows: 341,362 symbols: 3,184
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-10-28 04:00:00 | AAPL | Stock | 28.5 | 28.5 | 28.47 | 28.47 | 800.0 |
| 2016-10-28 04:25:00 | AAPL | Stock | 28.4775 | 28.48 | 28.475 | 28.475 | 4400.0 |
| 2016-10-28 04:50:00 | AAPL | Stock | 28.45 | 28.45 | 28.45 | 28.45 | 400.0 |
| 2016-10-28 06:20:00 | AAPL | Stock | 28.495 | 28.5 | 28.495 | 28.5 | 4400.0 |
| 2016-10-28 06:30:00 | AAPL | Stock | 28.505 | 28.505 | 28.505 | 28.505 | 2800.0 |
| 2016-10-28 06:35:00 | AAPL | Stock | 28.5075 | 28.5075 | 28.5075 | 28.5075 | 5880.0 |
| 2016-10-28 06:45:00 | AAPL | Stock | 28.5375 | 28.55 | 28.5375 | 28.55 | 4412.0 |
| 2016-10-28 06:50:00 | AAPL | Stock | 28.555 | 28.56 | 28.555 | 28.56 | 5200.0 |
| 2016-10-28 07:00:00 | AAPL | Stock | 28.55 | 28.55 | 28.53 | 28.53 | 1600.0 |
| 2016-10-28 07:05:00 | AAPL | Stock | 28.5925 | 28.625 | 28.5875 | 28.6225 | 9136.0 |
| 2016-10-28 07:10:00 | AAPL | Stock | 28.5875 | 28.5875 | 28.5875 | 28.5875 | 2000.0 |
| 2016-10-28 07:15:00 | AAPL | Stock | 28.5975 | 28.5975 | 28.5975 | 28.5975 | 1028.0 |
| 2016-10-28 07:20:00 | AAPL | Stock | 28.5925 | 28.5925 | 28.5925 | 28.5925 | 800.0 |
| 2016-10-28 07:25:00 | AAPL | Stock | 28.58 | 28.58 | 28.58 | 28.58 | 800.0 |
| 2016-10-28 07:30:00 | AAPL | Stock | 28.575 | 28.575 | 28.575 | 28.575 | 800.0 |
| 2016-10-28 07:35:00 | AAPL | Stock | 28.5775 | 28.5775 | 28.5675 | 28.5675 | 800.0 |
| 2016-10-28 07:40:00 | AAPL | Stock | 28.5275 | 28.5525 | 28.5275 | 28.5525 | 2736.0 |
| 2016-10-28 07:45:00 | AAPL | Stock | 28.565 | 28.565 | 28.5375 | 28.5375 | 2400.0 |
| 2016-10-28 07:55:00 | AAPL | Stock | 28.565 | 28.565 | 28.55 | 28.55 | 1400.0 |
| 2016-10-28 08:00:00 | AAPL | Stock | 28.535 | 28.5825 | 28.535 | 28.55 | 17620.0 |
| 2016-10-28 08:05:00 | AAPL | Stock | 28.5425 | 28.5425 | 28.5275 | 28.5275 | 7560.0 |
| 2016-10-28 08:10:00 | AAPL | Stock | 28.535 | 28.535 | 28.525 | 28.53 | 3200.0 |
| 2016-10-28 08:15:00 | AAPL | Stock | 28.525 | 28.5425 | 28.525 | 28.5425 | 9276.0 |
| 2016-10-28 08:20:00 | AAPL | Stock | 28.535 | 28.535 | 28.5225 | 28.525 | 15348.0 |
| 2016-10-28 08:25:00 | AAPL | Stock | 28.525 | 28.5425 | 28.525 | 28.5425 | 3800.0 |
| 2016-10-28 08:30:00 | AAPL | Stock | 28.5375 | 28.57 | 28.5375 | 28.5575 | 40216.0 |
| 2016-10-28 08:35:00 | AAPL | Stock | 28.57 | 28.57 | 28.525 | 28.53 | 17636.0 |
| 2016-10-28 08:40:00 | AAPL | Stock | 28.5375 | 28.555 | 28.5375 | 28.555 | 18724.0 |
| 2016-10-28 08:45:00 | AAPL | Stock | 28.555 | 28.555 | 28.54 | 28.545 | 9184.0 |
| 2016-10-28 08:50:00 | AAPL | Stock | 28.55 | 28.55 | 28.5475 | 28.55 | 2400.0 |
| 2016-10-28 08:55:00 | AAPL | Stock | 28.55 | 28.555 | 28.54 | 28.555 | 6900.0 |
| 2016-10-28 09:00:00 | AAPL | Stock | 28.55 | 28.61 | 28.55 | 28.55 | 70900.0 |
| 2016-10-28 09:05:00 | AAPL | Stock | 28.5525 | 28.5625 | 28.5525 | 28.5625 | 6256.0 |
| 2016-10-28 09:10:00 | AAPL | Stock | 28.5425 | 28.5425 | 28.5325 | 28.5325 | 7208.0 |
| 2016-10-28 09:15:00 | AAPL | Stock | 28.5375 | 28.54 | 28.525 | 28.525 | 17820.0 |
| 2016-10-28 09:20:00 | AAPL | Stock | 28.5375 | 28.5375 | 28.525 | 28.5275 | 5992.0 |
| 2016-10-28 09:25:00 | AAPL | Stock | 28.5275 | 28.53 | 28.465 | 28.465 | 218036.0 |
| 2016-10-28 09:30:00 | AAPL | Stock | 28.465 | 28.5925 | 28.4625 | 28.5575 | 4811996.0 |
| 2016-10-28 09:35:00 | AAPL | Stock | 28.5575 | 28.7525 | 28.5575 | 28.7425 | 3287208.0 |
| 2016-10-28 09:40:00 | AAPL | Stock | 28.7425 | 28.7775 | 28.7138 | 28.7688 | 3291284.0 |
| 2016-10-28 09:45:00 | AAPL | Stock | 28.7688 | 28.775 | 28.715 | 28.7325 | 2241176.0 |
| 2016-10-28 09:50:00 | AAPL | Stock | 28.735 | 28.75 | 28.7075 | 28.7075 | 1696532.0 |
| 2016-10-28 09:55:00 | AAPL | Stock | 28.71 | 28.73 | 28.6925 | 28.7025 | 1574044.0 |
| 2016-10-28 10:00:00 | AAPL | Stock | 28.705 | 28.7325 | 28.6625 | 28.685 | 1807872.0 |
| 2016-10-28 10:05:00 | AAPL | Stock | 28.685 | 28.69 | 28.6375 | 28.655 | 1373108.0 |
| 2016-10-28 10:10:00 | AAPL | Stock | 28.6525 | 28.6575 | 28.605 | 28.6452 | 1754468.0 |
| 2016-10-28 10:15:00 | AAPL | Stock | 28.6452 | 28.6562 | 28.59 | 28.6175 | 1648888.0 |
| 2016-10-28 10:20:00 | AAPL | Stock | 28.614 | 28.64 | 28.595 | 28.6325 | 1502648.0 |
| 2016-10-28 10:25:00 | AAPL | Stock | 28.63 | 28.675 | 28.625 | 28.6615 | 1339328.0 |
| 2016-10-28 10:30:00 | AAPL | Stock | 28.66 | 28.7125 | 28.66 | 28.705 | 1489088.0 |
> showing 50 of 341,362 rows — these rows as CSV