PREVIEW / stock_5min / 2016-01-12
file: by_date/stock_5min/2016/2016-01-12.parquet size: 5.6 MB rows: 371,408 symbols: 3,385
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-01-12 04:00:00 | AAPL | Stock | 24.555 | 24.555 | 24.555 | 24.555 | 3996.0 |
| 2016-01-12 04:10:00 | AAPL | Stock | 24.5625 | 24.5625 | 24.5625 | 24.5625 | 400.0 |
| 2016-01-12 04:15:00 | AAPL | Stock | 24.5625 | 24.6725 | 24.555 | 24.6725 | 15200.0 |
| 2016-01-12 04:25:00 | AAPL | Stock | 24.6725 | 24.6725 | 24.6725 | 24.6725 | 520.0 |
| 2016-01-12 04:30:00 | AAPL | Stock | 24.725 | 24.725 | 24.7125 | 24.715 | 4956.0 |
| 2016-01-12 04:35:00 | AAPL | Stock | 24.715 | 24.7175 | 24.715 | 24.7175 | 7200.0 |
| 2016-01-12 04:40:00 | AAPL | Stock | 24.685 | 24.685 | 24.685 | 24.685 | 2000.0 |
| 2016-01-12 05:00:00 | AAPL | Stock | 24.7425 | 24.7425 | 24.7 | 24.7 | 7488.0 |
| 2016-01-12 05:10:00 | AAPL | Stock | 24.7025 | 24.7025 | 24.7025 | 24.7025 | 1200.0 |
| 2016-01-12 05:20:00 | AAPL | Stock | 24.7125 | 24.7125 | 24.7125 | 24.7125 | 1256.0 |
| 2016-01-12 05:30:00 | AAPL | Stock | 24.7125 | 24.7125 | 24.7125 | 24.7125 | 400.0 |
| 2016-01-12 05:35:00 | AAPL | Stock | 24.74 | 24.7575 | 24.74 | 24.7575 | 10040.0 |
| 2016-01-12 05:40:00 | AAPL | Stock | 24.7975 | 24.7975 | 24.7975 | 24.7975 | 920.0 |
| 2016-01-12 05:45:00 | AAPL | Stock | 24.8 | 24.8 | 24.8 | 24.8 | 1800.0 |
| 2016-01-12 05:55:00 | AAPL | Stock | 24.805 | 24.805 | 24.805 | 24.805 | 900.0 |
| 2016-01-12 06:00:00 | AAPL | Stock | 24.825 | 25.0 | 24.825 | 24.95 | 255324.0 |
| 2016-01-12 06:05:00 | AAPL | Stock | 24.98 | 25.0875 | 24.98 | 25.05 | 176772.0 |
| 2016-01-12 06:10:00 | AAPL | Stock | 25.0525 | 25.1125 | 25.0525 | 25.075 | 23584.0 |
| 2016-01-12 06:15:00 | AAPL | Stock | 25.075 | 25.125 | 25.075 | 25.1 | 9416.0 |
| 2016-01-12 06:20:00 | AAPL | Stock | 25.1 | 25.14 | 25.1 | 25.1375 | 25976.0 |
| 2016-01-12 06:25:00 | AAPL | Stock | 25.125 | 25.1575 | 25.1175 | 25.1375 | 13616.0 |
| 2016-01-12 06:30:00 | AAPL | Stock | 25.15 | 25.175 | 25.1 | 25.1 | 97252.0 |
| 2016-01-12 06:35:00 | AAPL | Stock | 25.125 | 25.125 | 25.055 | 25.125 | 53008.0 |
| 2016-01-12 06:40:00 | AAPL | Stock | 25.1125 | 25.125 | 25.1125 | 25.1125 | 9520.0 |
| 2016-01-12 06:45:00 | AAPL | Stock | 25.1 | 25.1 | 25.055 | 25.065 | 21344.0 |
| 2016-01-12 06:50:00 | AAPL | Stock | 25.065 | 25.065 | 25.05 | 25.05 | 800.0 |
| 2016-01-12 06:55:00 | AAPL | Stock | 25.065 | 25.0675 | 25.0475 | 25.065 | 23268.0 |
| 2016-01-12 07:00:00 | AAPL | Stock | 25.0525 | 25.1 | 25.0475 | 25.0825 | 79208.0 |
| 2016-01-12 07:05:00 | AAPL | Stock | 25.0775 | 25.0975 | 25.075 | 25.0775 | 16552.0 |
| 2016-01-12 07:10:00 | AAPL | Stock | 25.08 | 25.08 | 25.065 | 25.065 | 3600.0 |
| 2016-01-12 07:15:00 | AAPL | Stock | 25.075 | 25.085 | 25.0525 | 25.0525 | 7972.0 |
| 2016-01-12 07:20:00 | AAPL | Stock | 25.08 | 25.085 | 25.05 | 25.08 | 23012.0 |
| 2016-01-12 07:25:00 | AAPL | Stock | 25.065 | 25.0975 | 25.0625 | 25.075 | 30340.0 |
| 2016-01-12 07:30:00 | AAPL | Stock | 25.075 | 25.1 | 25.0675 | 25.095 | 12608.0 |
| 2016-01-12 07:35:00 | AAPL | Stock | 25.0875 | 25.1 | 25.0375 | 25.0625 | 33752.0 |
| 2016-01-12 07:40:00 | AAPL | Stock | 25.05 | 25.06 | 25.04 | 25.055 | 26836.0 |
| 2016-01-12 07:45:00 | AAPL | Stock | 25.065 | 25.1025 | 25.05 | 25.05 | 127932.0 |
| 2016-01-12 07:50:00 | AAPL | Stock | 25.0525 | 25.0825 | 25.05 | 25.0625 | 46284.0 |
| 2016-01-12 07:55:00 | AAPL | Stock | 25.0625 | 25.1025 | 25.0625 | 25.075 | 83124.0 |
| 2016-01-12 08:00:00 | AAPL | Stock | 25.08 | 25.125 | 25.05 | 25.105 | 310752.0 |
| 2016-01-12 08:05:00 | AAPL | Stock | 25.095 | 25.11 | 25.0875 | 25.105 | 142776.0 |
| 2016-01-12 08:10:00 | AAPL | Stock | 25.0975 | 25.125 | 25.095 | 25.1225 | 107892.0 |
| 2016-01-12 08:15:00 | AAPL | Stock | 25.1225 | 25.1375 | 25.0925 | 25.115 | 218100.0 |
| 2016-01-12 08:20:00 | AAPL | Stock | 25.0925 | 25.105 | 25.09 | 25.1025 | 122176.0 |
| 2016-01-12 08:25:00 | AAPL | Stock | 25.0975 | 25.0975 | 25.0525 | 25.07 | 85608.0 |
| 2016-01-12 08:30:00 | AAPL | Stock | 25.0575 | 25.0925 | 25.055 | 25.075 | 74664.0 |
| 2016-01-12 08:35:00 | AAPL | Stock | 25.075 | 25.0875 | 25.055 | 25.0575 | 47192.0 |
| 2016-01-12 08:40:00 | AAPL | Stock | 25.0575 | 25.0825 | 25.0475 | 25.0725 | 106188.0 |
| 2016-01-12 08:45:00 | AAPL | Stock | 25.0725 | 25.095 | 25.0625 | 25.095 | 67752.0 |
| 2016-01-12 08:50:00 | AAPL | Stock | 25.095 | 25.1075 | 25.0875 | 25.1075 | 31936.0 |
> showing 50 of 371,408 rows — these rows as CSV