PREVIEW / stock_5min / 2016-09-13
file: by_date/stock_5min/2016/2016-09-13.parquet size: 5.4 MB rows: 358,517 symbols: 3,245
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-09-13 04:00:00 | AAPL | Stock | 26.32 | 26.32 | 26.32 | 26.32 | 2000.0 |
| 2016-09-13 04:10:00 | AAPL | Stock | 26.255 | 26.255 | 26.2525 | 26.2525 | 2000.0 |
| 2016-09-13 04:30:00 | AAPL | Stock | 26.2525 | 26.2525 | 26.25 | 26.25 | 4200.0 |
| 2016-09-13 05:00:00 | AAPL | Stock | 26.245 | 26.245 | 26.245 | 26.245 | 2000.0 |
| 2016-09-13 05:10:00 | AAPL | Stock | 26.225 | 26.245 | 26.225 | 26.245 | 1772.0 |
| 2016-09-13 05:25:00 | AAPL | Stock | 26.255 | 26.26 | 26.255 | 26.26 | 3072.0 |
| 2016-09-13 05:35:00 | AAPL | Stock | 26.26 | 26.26 | 26.26 | 26.26 | 1268.0 |
| 2016-09-13 05:50:00 | AAPL | Stock | 26.26 | 26.26 | 26.26 | 26.26 | 400.0 |
| 2016-09-13 06:00:00 | AAPL | Stock | 26.25 | 26.25 | 26.25 | 26.25 | 4000.0 |
| 2016-09-13 06:10:00 | AAPL | Stock | 26.25 | 26.25 | 26.25 | 26.25 | 1144.0 |
| 2016-09-13 06:15:00 | AAPL | Stock | 26.275 | 26.275 | 26.275 | 26.275 | 800.0 |
| 2016-09-13 06:30:00 | AAPL | Stock | 26.3 | 26.3 | 26.3 | 26.3 | 4000.0 |
| 2016-09-13 06:35:00 | AAPL | Stock | 26.3175 | 26.35 | 26.3175 | 26.35 | 6400.0 |
| 2016-09-13 06:40:00 | AAPL | Stock | 26.3475 | 26.3475 | 26.3275 | 26.3275 | 2000.0 |
| 2016-09-13 06:50:00 | AAPL | Stock | 26.315 | 26.32 | 26.3 | 26.3 | 9152.0 |
| 2016-09-13 06:55:00 | AAPL | Stock | 26.31 | 26.31 | 26.31 | 26.31 | 4000.0 |
| 2016-09-13 07:00:00 | AAPL | Stock | 26.3 | 26.3 | 26.3 | 26.3 | 7800.0 |
| 2016-09-13 07:10:00 | AAPL | Stock | 26.3175 | 26.325 | 26.3175 | 26.325 | 24944.0 |
| 2016-09-13 07:15:00 | AAPL | Stock | 26.3275 | 26.3275 | 26.3275 | 26.3275 | 6428.0 |
| 2016-09-13 07:20:00 | AAPL | Stock | 26.3275 | 26.3275 | 26.3275 | 26.3275 | 14000.0 |
| 2016-09-13 07:25:00 | AAPL | Stock | 26.3275 | 26.35 | 26.3125 | 26.35 | 34064.0 |
| 2016-09-13 07:30:00 | AAPL | Stock | 26.35 | 26.62 | 26.35 | 26.475 | 306764.0 |
| 2016-09-13 07:35:00 | AAPL | Stock | 26.475 | 26.525 | 26.475 | 26.525 | 100316.0 |
| 2016-09-13 07:40:00 | AAPL | Stock | 26.53 | 26.5875 | 26.5125 | 26.545 | 137820.0 |
| 2016-09-13 07:45:00 | AAPL | Stock | 26.5725 | 26.6925 | 26.5725 | 26.655 | 233264.0 |
| 2016-09-13 07:50:00 | AAPL | Stock | 26.6375 | 26.6875 | 26.6325 | 26.6875 | 91144.0 |
| 2016-09-13 07:55:00 | AAPL | Stock | 26.6875 | 26.7475 | 26.6875 | 26.73 | 98736.0 |
| 2016-09-13 08:00:00 | AAPL | Stock | 26.73 | 26.75 | 26.3275 | 26.68 | 316844.0 |
| 2016-09-13 08:05:00 | AAPL | Stock | 26.68 | 26.68 | 26.6125 | 26.64 | 118856.0 |
| 2016-09-13 08:10:00 | AAPL | Stock | 26.6425 | 26.67 | 26.62 | 26.65 | 108572.0 |
| 2016-09-13 08:15:00 | AAPL | Stock | 26.65 | 26.6525 | 26.605 | 26.6225 | 142264.0 |
| 2016-09-13 08:20:00 | AAPL | Stock | 26.62 | 26.65 | 26.6175 | 26.6475 | 65544.0 |
| 2016-09-13 08:25:00 | AAPL | Stock | 26.6475 | 26.6625 | 26.6275 | 26.6275 | 98412.0 |
| 2016-09-13 08:30:00 | AAPL | Stock | 26.625 | 26.775 | 26.625 | 26.7575 | 678412.0 |
| 2016-09-13 08:35:00 | AAPL | Stock | 26.735 | 26.805 | 26.725 | 26.77 | 690232.0 |
| 2016-09-13 08:40:00 | AAPL | Stock | 26.7725 | 26.8625 | 26.755 | 26.86 | 748712.0 |
| 2016-09-13 08:45:00 | AAPL | Stock | 26.85 | 26.9025 | 26.815 | 26.85 | 895860.0 |
| 2016-09-13 08:50:00 | AAPL | Stock | 26.85 | 26.8525 | 26.7975 | 26.82 | 277088.0 |
| 2016-09-13 08:55:00 | AAPL | Stock | 26.82 | 26.85 | 26.785 | 26.84 | 282884.0 |
| 2016-09-13 09:00:00 | AAPL | Stock | 26.845 | 26.85 | 26.8 | 26.815 | 235104.0 |
| 2016-09-13 09:05:00 | AAPL | Stock | 26.8125 | 26.85 | 26.79 | 26.8375 | 303504.0 |
| 2016-09-13 09:10:00 | AAPL | Stock | 26.8425 | 26.8725 | 26.8225 | 26.8275 | 446896.0 |
| 2016-09-13 09:15:00 | AAPL | Stock | 26.8275 | 26.8525 | 26.8175 | 26.8475 | 197604.0 |
| 2016-09-13 09:20:00 | AAPL | Stock | 26.845 | 26.85 | 26.82 | 26.8375 | 328540.0 |
| 2016-09-13 09:25:00 | AAPL | Stock | 26.8425 | 26.895 | 26.8225 | 26.8775 | 452784.0 |
| 2016-09-13 09:30:00 | AAPL | Stock | 26.8725 | 27.03 | 26.81 | 27.005 | 18129800.0 |
| 2016-09-13 09:35:00 | AAPL | Stock | 27.005 | 27.115 | 26.9825 | 27.1 | 11777508.0 |
| 2016-09-13 09:40:00 | AAPL | Stock | 27.1025 | 27.1975 | 27.08 | 27.1075 | 12274956.0 |
| 2016-09-13 09:45:00 | AAPL | Stock | 27.1075 | 27.155 | 27.055 | 27.0562 | 7257308.0 |
| 2016-09-13 09:50:00 | AAPL | Stock | 27.055 | 27.1125 | 27.0425 | 27.1125 | 5635584.0 |
> showing 50 of 358,517 rows — these rows as CSV