PREVIEW / stock_5min / 2016-11-21
file: by_date/stock_5min/2016/2016-11-21.parquet size: 5.5 MB rows: 359,272 symbols: 3,179
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-21 04:00:00 | AAPL | Stock | 27.55 | 27.55 | 27.55 | 27.55 | 800.0 |
| 2016-11-21 04:25:00 | AAPL | Stock | 27.5375 | 27.5375 | 27.5375 | 27.5375 | 400.0 |
| 2016-11-21 04:35:00 | AAPL | Stock | 27.5325 | 27.5325 | 27.52 | 27.52 | 14800.0 |
| 2016-11-21 04:55:00 | AAPL | Stock | 27.5375 | 27.5375 | 27.5375 | 27.5375 | 3200.0 |
| 2016-11-21 05:20:00 | AAPL | Stock | 27.5975 | 27.5975 | 27.5975 | 27.5975 | 516.0 |
| 2016-11-21 05:30:00 | AAPL | Stock | 27.6 | 27.6 | 27.6 | 27.6 | 772.0 |
| 2016-11-21 06:30:00 | AAPL | Stock | 27.5525 | 27.5525 | 27.5525 | 27.5525 | 680.0 |
| 2016-11-21 06:45:00 | AAPL | Stock | 27.5975 | 27.6 | 27.5975 | 27.6 | 3680.0 |
| 2016-11-21 07:00:00 | AAPL | Stock | 27.6 | 27.6 | 27.6 | 27.6 | 1144.0 |
| 2016-11-21 07:10:00 | AAPL | Stock | 27.6125 | 27.6125 | 27.6125 | 27.6125 | 400.0 |
| 2016-11-21 07:25:00 | AAPL | Stock | 27.6 | 27.6 | 27.6 | 27.6 | 400.0 |
| 2016-11-21 07:35:00 | AAPL | Stock | 27.585 | 27.585 | 27.585 | 27.585 | 400.0 |
| 2016-11-21 07:45:00 | AAPL | Stock | 27.585 | 27.585 | 27.58 | 27.58 | 4868.0 |
| 2016-11-21 07:50:00 | AAPL | Stock | 27.58 | 27.58 | 27.575 | 27.575 | 21988.0 |
| 2016-11-21 07:55:00 | AAPL | Stock | 27.5775 | 27.5775 | 27.5775 | 27.5775 | 800.0 |
| 2016-11-21 08:00:00 | AAPL | Stock | 27.5775 | 27.6 | 27.5725 | 27.575 | 79148.0 |
| 2016-11-21 08:05:00 | AAPL | Stock | 27.5725 | 27.5725 | 27.57 | 27.57 | 5844.0 |
| 2016-11-21 08:10:00 | AAPL | Stock | 27.57 | 27.57 | 27.57 | 27.57 | 9208.0 |
| 2016-11-21 08:15:00 | AAPL | Stock | 27.57 | 27.57 | 27.5625 | 27.57 | 16000.0 |
| 2016-11-21 08:20:00 | AAPL | Stock | 27.57 | 27.57 | 27.57 | 27.57 | 3936.0 |
| 2016-11-21 08:25:00 | AAPL | Stock | 27.575 | 27.575 | 27.575 | 27.575 | 1600.0 |
| 2016-11-21 08:30:00 | AAPL | Stock | 27.585 | 27.5925 | 27.585 | 27.5925 | 12992.0 |
| 2016-11-21 08:35:00 | AAPL | Stock | 27.595 | 27.6175 | 27.595 | 27.6175 | 64968.0 |
| 2016-11-21 08:40:00 | AAPL | Stock | 27.6125 | 27.6425 | 27.6125 | 27.6425 | 14660.0 |
| 2016-11-21 08:45:00 | AAPL | Stock | 27.6325 | 27.6375 | 27.62 | 27.62 | 53728.0 |
| 2016-11-21 08:50:00 | AAPL | Stock | 27.615 | 27.615 | 27.605 | 27.61 | 6000.0 |
| 2016-11-21 08:55:00 | AAPL | Stock | 27.605 | 27.605 | 27.58 | 27.58 | 14804.0 |
| 2016-11-21 09:00:00 | AAPL | Stock | 27.58 | 27.5925 | 27.54 | 27.5875 | 52656.0 |
| 2016-11-21 09:05:00 | AAPL | Stock | 27.5725 | 27.585 | 27.565 | 27.565 | 12464.0 |
| 2016-11-21 09:10:00 | AAPL | Stock | 27.565 | 27.5775 | 27.5625 | 27.5775 | 14640.0 |
| 2016-11-21 09:15:00 | AAPL | Stock | 27.5775 | 27.5825 | 27.54 | 27.55 | 38992.0 |
| 2016-11-21 09:20:00 | AAPL | Stock | 27.545 | 27.55 | 27.545 | 27.55 | 12700.0 |
| 2016-11-21 09:25:00 | AAPL | Stock | 27.54 | 27.54 | 27.5 | 27.52 | 49208.0 |
| 2016-11-21 09:30:00 | AAPL | Stock | 27.53 | 27.625 | 27.5025 | 27.575 | 4262840.0 |
| 2016-11-21 09:35:00 | AAPL | Stock | 27.5775 | 27.635 | 27.575 | 27.6102 | 2506020.0 |
| 2016-11-21 09:40:00 | AAPL | Stock | 27.61 | 27.645 | 27.5738 | 27.605 | 2314500.0 |
| 2016-11-21 09:45:00 | AAPL | Stock | 27.6025 | 27.735 | 27.6025 | 27.7075 | 2891328.0 |
| 2016-11-21 09:50:00 | AAPL | Stock | 27.7062 | 27.7375 | 27.6925 | 27.7275 | 2248212.0 |
| 2016-11-21 09:55:00 | AAPL | Stock | 27.7275 | 27.795 | 27.7275 | 27.7875 | 2684804.0 |
| 2016-11-21 10:00:00 | AAPL | Stock | 27.7875 | 27.79 | 27.745 | 27.76 | 1536364.0 |
| 2016-11-21 10:05:00 | AAPL | Stock | 27.7575 | 27.7575 | 27.6925 | 27.695 | 1479748.0 |
| 2016-11-21 10:10:00 | AAPL | Stock | 27.6925 | 27.7315 | 27.6925 | 27.725 | 1063160.0 |
| 2016-11-21 10:15:00 | AAPL | Stock | 27.725 | 27.725 | 27.67 | 27.6725 | 1040684.0 |
| 2016-11-21 10:20:00 | AAPL | Stock | 27.675 | 27.6925 | 27.6675 | 27.6762 | 736568.0 |
| 2016-11-21 10:25:00 | AAPL | Stock | 27.6775 | 27.6825 | 27.6175 | 27.6728 | 1565128.0 |
| 2016-11-21 10:30:00 | AAPL | Stock | 27.6738 | 27.675 | 27.6262 | 27.645 | 1173404.0 |
| 2016-11-21 10:35:00 | AAPL | Stock | 27.6475 | 27.6575 | 27.6325 | 27.6565 | 647056.0 |
| 2016-11-21 10:40:00 | AAPL | Stock | 27.6562 | 27.675 | 27.64 | 27.6732 | 727080.0 |
| 2016-11-21 10:45:00 | AAPL | Stock | 27.6725 | 27.6962 | 27.665 | 27.6925 | 953540.0 |
| 2016-11-21 10:50:00 | AAPL | Stock | 27.6938 | 27.73 | 27.6875 | 27.7175 | 1006916.0 |
> showing 50 of 359,272 rows — these rows as CSV