PREVIEW / stock_5min / 2015-01-30
file: by_date/stock_5min/2015/2015-01-30.parquet size: 5.6 MB rows: 367,544 symbols: 3,527
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 |
|---|---|---|---|---|---|---|---|
| 2015-01-30 04:00:00 | AAPL | Stock | 29.725 | 29.725 | 29.725 | 29.725 | 400.0 |
| 2015-01-30 04:15:00 | AAPL | Stock | 29.66 | 29.675 | 29.65 | 29.675 | 2688.0 |
| 2015-01-30 04:20:00 | AAPL | Stock | 29.695 | 29.695 | 29.695 | 29.695 | 2000.0 |
| 2015-01-30 04:25:00 | AAPL | Stock | 29.6625 | 29.6625 | 29.6625 | 29.6625 | 400.0 |
| 2015-01-30 04:30:00 | AAPL | Stock | 29.605 | 29.605 | 29.5975 | 29.5975 | 7956.0 |
| 2015-01-30 04:40:00 | AAPL | Stock | 29.6025 | 29.6025 | 29.6025 | 29.6025 | 6920.0 |
| 2015-01-30 04:45:00 | AAPL | Stock | 29.605 | 29.605 | 29.6 | 29.6025 | 4100.0 |
| 2015-01-30 04:55:00 | AAPL | Stock | 29.6 | 29.6025 | 29.6 | 29.6025 | 3000.0 |
| 2015-01-30 05:00:00 | AAPL | Stock | 29.6 | 29.6 | 29.6 | 29.6 | 19696.0 |
| 2015-01-30 05:10:00 | AAPL | Stock | 29.62 | 29.6625 | 29.5925 | 29.5925 | 13480.0 |
| 2015-01-30 05:20:00 | AAPL | Stock | 29.6225 | 29.6225 | 29.6225 | 29.6225 | 1200.0 |
| 2015-01-30 05:25:00 | AAPL | Stock | 29.605 | 29.605 | 29.605 | 29.605 | 1904.0 |
| 2015-01-30 05:35:00 | AAPL | Stock | 29.5875 | 29.5875 | 29.5875 | 29.5875 | 724.0 |
| 2015-01-30 05:40:00 | AAPL | Stock | 29.5875 | 29.5875 | 29.5875 | 29.5875 | 400.0 |
| 2015-01-30 05:45:00 | AAPL | Stock | 29.565 | 29.565 | 29.525 | 29.56 | 3960.0 |
| 2015-01-30 05:50:00 | AAPL | Stock | 29.55 | 29.55 | 29.525 | 29.525 | 5704.0 |
| 2015-01-30 05:55:00 | AAPL | Stock | 29.55 | 29.585 | 29.55 | 29.585 | 3860.0 |
| 2015-01-30 06:00:00 | AAPL | Stock | 29.5875 | 29.5875 | 29.585 | 29.5875 | 12428.0 |
| 2015-01-30 06:05:00 | AAPL | Stock | 29.5875 | 29.5875 | 29.55 | 29.55 | 1372.0 |
| 2015-01-30 06:10:00 | AAPL | Stock | 29.5875 | 29.5875 | 29.565 | 29.565 | 6888.0 |
| 2015-01-30 06:15:00 | AAPL | Stock | 29.6 | 29.6 | 29.575 | 29.575 | 4940.0 |
| 2015-01-30 06:20:00 | AAPL | Stock | 29.5975 | 29.6275 | 29.595 | 29.6275 | 3192.0 |
| 2015-01-30 06:35:00 | AAPL | Stock | 29.6475 | 29.6475 | 29.635 | 29.635 | 5600.0 |
| 2015-01-30 06:40:00 | AAPL | Stock | 29.6375 | 29.65 | 29.635 | 29.635 | 8000.0 |
| 2015-01-30 06:45:00 | AAPL | Stock | 29.62 | 29.62 | 29.58 | 29.58 | 1600.0 |
| 2015-01-30 06:50:00 | AAPL | Stock | 29.5775 | 29.5775 | 29.565 | 29.565 | 6656.0 |
| 2015-01-30 06:55:00 | AAPL | Stock | 29.57 | 29.57 | 29.565 | 29.57 | 2960.0 |
| 2015-01-30 07:00:00 | AAPL | Stock | 29.5975 | 29.6225 | 29.5975 | 29.6 | 12136.0 |
| 2015-01-30 07:05:00 | AAPL | Stock | 29.6025 | 29.6225 | 29.6 | 29.6 | 32680.0 |
| 2015-01-30 07:10:00 | AAPL | Stock | 29.5825 | 29.6 | 29.555 | 29.58 | 51164.0 |
| 2015-01-30 07:15:00 | AAPL | Stock | 29.5875 | 29.595 | 29.5875 | 29.5925 | 11400.0 |
| 2015-01-30 07:20:00 | AAPL | Stock | 29.5925 | 29.6175 | 29.5925 | 29.6175 | 4440.0 |
| 2015-01-30 07:25:00 | AAPL | Stock | 29.6125 | 29.615 | 29.5975 | 29.6125 | 21688.0 |
| 2015-01-30 07:30:00 | AAPL | Stock | 29.61 | 29.6225 | 29.6025 | 29.61 | 20276.0 |
| 2015-01-30 07:35:00 | AAPL | Stock | 29.6 | 29.625 | 29.6 | 29.625 | 30564.0 |
| 2015-01-30 07:40:00 | AAPL | Stock | 29.625 | 29.625 | 29.615 | 29.625 | 79400.0 |
| 2015-01-30 07:45:00 | AAPL | Stock | 29.625 | 29.625 | 29.615 | 29.6175 | 24000.0 |
| 2015-01-30 07:50:00 | AAPL | Stock | 29.615 | 29.615 | 29.605 | 29.6125 | 15200.0 |
| 2015-01-30 07:55:00 | AAPL | Stock | 29.61 | 29.61 | 29.5825 | 29.59 | 43680.0 |
| 2015-01-30 08:00:00 | AAPL | Stock | 29.59 | 29.725 | 29.55 | 29.57 | 463684.0 |
| 2015-01-30 08:05:00 | AAPL | Stock | 29.57 | 29.6 | 29.555 | 29.5975 | 276040.0 |
| 2015-01-30 08:10:00 | AAPL | Stock | 29.5925 | 29.615 | 29.5825 | 29.615 | 178288.0 |
| 2015-01-30 08:15:00 | AAPL | Stock | 29.62 | 29.65 | 29.605 | 29.605 | 168836.0 |
| 2015-01-30 08:20:00 | AAPL | Stock | 29.6025 | 29.635 | 29.6 | 29.6325 | 52972.0 |
| 2015-01-30 08:25:00 | AAPL | Stock | 29.625 | 29.625 | 29.595 | 29.6 | 153128.0 |
| 2015-01-30 08:30:00 | AAPL | Stock | 29.6 | 29.635 | 29.5775 | 29.625 | 229512.0 |
| 2015-01-30 08:35:00 | AAPL | Stock | 29.625 | 29.625 | 29.5775 | 29.5875 | 202252.0 |
| 2015-01-30 08:40:00 | AAPL | Stock | 29.5875 | 29.6175 | 29.5875 | 29.61 | 66788.0 |
| 2015-01-30 08:45:00 | AAPL | Stock | 29.6075 | 29.6425 | 29.6075 | 29.62 | 139636.0 |
| 2015-01-30 08:50:00 | AAPL | Stock | 29.62 | 29.625 | 29.59 | 29.62 | 252100.0 |
> showing 50 of 367,544 rows — these rows as CSV