PREVIEW / stock_5min / 2016-02-18
file: by_date/stock_5min/2016/2016-02-18.parquet size: 5.3 MB rows: 352,780 symbols: 3,338
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-02-18 04:05:00 | AAPL | Stock | 24.5 | 24.5 | 24.5 | 24.5 | 1200.0 |
| 2016-02-18 04:10:00 | AAPL | Stock | 24.475 | 24.5 | 24.475 | 24.5 | 800.0 |
| 2016-02-18 04:25:00 | AAPL | Stock | 24.535 | 24.535 | 24.535 | 24.535 | 3200.0 |
| 2016-02-18 04:30:00 | AAPL | Stock | 24.565 | 24.575 | 24.565 | 24.575 | 8400.0 |
| 2016-02-18 04:45:00 | AAPL | Stock | 24.5775 | 24.5775 | 24.5775 | 24.5775 | 2960.0 |
| 2016-02-18 04:50:00 | AAPL | Stock | 24.5875 | 24.5875 | 24.5625 | 24.5625 | 7720.0 |
| 2016-02-18 04:55:00 | AAPL | Stock | 24.575 | 24.575 | 24.575 | 24.575 | 2000.0 |
| 2016-02-18 05:05:00 | AAPL | Stock | 24.585 | 24.5875 | 24.585 | 24.5875 | 5496.0 |
| 2016-02-18 05:10:00 | AAPL | Stock | 24.5875 | 24.6 | 24.5875 | 24.6 | 3200.0 |
| 2016-02-18 05:15:00 | AAPL | Stock | 24.6 | 24.6 | 24.6 | 24.6 | 2000.0 |
| 2016-02-18 05:20:00 | AAPL | Stock | 24.6125 | 24.6125 | 24.6125 | 24.6125 | 1980.0 |
| 2016-02-18 05:25:00 | AAPL | Stock | 24.6175 | 24.62 | 24.6175 | 24.62 | 3760.0 |
| 2016-02-18 05:30:00 | AAPL | Stock | 24.62 | 24.63 | 24.62 | 24.63 | 6800.0 |
| 2016-02-18 05:35:00 | AAPL | Stock | 24.6725 | 24.675 | 24.67 | 24.67 | 6600.0 |
| 2016-02-18 05:40:00 | AAPL | Stock | 24.65 | 24.65 | 24.65 | 24.65 | 1960.0 |
| 2016-02-18 05:45:00 | AAPL | Stock | 24.625 | 24.625 | 24.625 | 24.625 | 3880.0 |
| 2016-02-18 05:55:00 | AAPL | Stock | 24.65 | 24.65 | 24.65 | 24.65 | 1952.0 |
| 2016-02-18 06:00:00 | AAPL | Stock | 24.65 | 24.65 | 24.625 | 24.625 | 1288.0 |
| 2016-02-18 06:05:00 | AAPL | Stock | 24.6275 | 24.6275 | 24.6275 | 24.6275 | 400.0 |
| 2016-02-18 06:25:00 | AAPL | Stock | 24.6725 | 24.715 | 24.65 | 24.715 | 7600.0 |
| 2016-02-18 06:30:00 | AAPL | Stock | 24.695 | 24.7075 | 24.675 | 24.7075 | 9868.0 |
| 2016-02-18 06:35:00 | AAPL | Stock | 24.7375 | 24.7475 | 24.7375 | 24.7475 | 3632.0 |
| 2016-02-18 06:40:00 | AAPL | Stock | 24.7 | 24.7 | 24.7 | 24.7 | 1900.0 |
| 2016-02-18 06:45:00 | AAPL | Stock | 24.725 | 24.725 | 24.725 | 24.725 | 800.0 |
| 2016-02-18 06:50:00 | AAPL | Stock | 24.7375 | 24.75 | 24.7375 | 24.75 | 12000.0 |
| 2016-02-18 06:55:00 | AAPL | Stock | 24.7525 | 24.775 | 24.75 | 24.75 | 11128.0 |
| 2016-02-18 07:00:00 | AAPL | Stock | 24.75 | 24.75 | 24.7125 | 24.7125 | 8420.0 |
| 2016-02-18 07:05:00 | AAPL | Stock | 24.7025 | 24.7025 | 24.67 | 24.67 | 8800.0 |
| 2016-02-18 07:10:00 | AAPL | Stock | 24.6775 | 24.6775 | 24.6775 | 24.6775 | 600.0 |
| 2016-02-18 07:15:00 | AAPL | Stock | 24.69 | 24.7 | 24.69 | 24.7 | 8100.0 |
| 2016-02-18 07:20:00 | AAPL | Stock | 24.69 | 24.69 | 24.6875 | 24.6875 | 5008.0 |
| 2016-02-18 07:25:00 | AAPL | Stock | 24.6875 | 24.6875 | 24.6675 | 24.6675 | 11600.0 |
| 2016-02-18 07:35:00 | AAPL | Stock | 24.6675 | 24.675 | 24.6625 | 24.6625 | 34900.0 |
| 2016-02-18 07:40:00 | AAPL | Stock | 24.655 | 24.6575 | 24.65 | 24.6575 | 4488.0 |
| 2016-02-18 07:45:00 | AAPL | Stock | 24.66 | 24.6725 | 24.6525 | 24.6525 | 7500.0 |
| 2016-02-18 07:50:00 | AAPL | Stock | 24.6625 | 24.6625 | 24.6475 | 24.6475 | 12624.0 |
| 2016-02-18 07:55:00 | AAPL | Stock | 24.65 | 24.6625 | 24.645 | 24.6625 | 5768.0 |
| 2016-02-18 08:00:00 | AAPL | Stock | 24.6675 | 24.775 | 24.6375 | 24.6525 | 54340.0 |
| 2016-02-18 08:05:00 | AAPL | Stock | 24.6625 | 24.665 | 24.64 | 24.6625 | 49696.0 |
| 2016-02-18 08:10:00 | AAPL | Stock | 24.6625 | 24.67 | 24.655 | 24.655 | 29012.0 |
| 2016-02-18 08:15:00 | AAPL | Stock | 24.6475 | 24.655 | 24.6325 | 24.6375 | 10720.0 |
| 2016-02-18 08:20:00 | AAPL | Stock | 24.6325 | 24.64 | 24.6325 | 24.64 | 7400.0 |
| 2016-02-18 08:25:00 | AAPL | Stock | 24.65 | 24.65 | 24.635 | 24.6375 | 5068.0 |
| 2016-02-18 08:30:00 | AAPL | Stock | 24.6425 | 24.6475 | 24.625 | 24.625 | 19916.0 |
| 2016-02-18 08:35:00 | AAPL | Stock | 24.6475 | 24.6475 | 24.63 | 24.64 | 13760.0 |
| 2016-02-18 08:40:00 | AAPL | Stock | 24.635 | 24.6425 | 24.6225 | 24.6275 | 16520.0 |
| 2016-02-18 08:45:00 | AAPL | Stock | 24.635 | 24.6375 | 24.605 | 24.605 | 34800.0 |
| 2016-02-18 08:50:00 | AAPL | Stock | 24.62 | 24.6575 | 24.62 | 24.65 | 30628.0 |
| 2016-02-18 08:55:00 | AAPL | Stock | 24.655 | 24.6625 | 24.65 | 24.6625 | 22472.0 |
| 2016-02-18 09:00:00 | AAPL | Stock | 24.6675 | 24.67 | 24.65 | 24.65 | 23292.0 |
> showing 50 of 352,780 rows — these rows as CSV