PREVIEW / stock_5min / 2015-04-16
file: by_date/stock_5min/2015/2015-04-16.parquet size: 5.4 MB rows: 354,175 symbols: 3,515
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-04-16 04:00:00 | AAPL | Stock | 31.65 | 31.685 | 31.65 | 31.685 | 7148.0 |
| 2015-04-16 04:05:00 | AAPL | Stock | 31.65 | 31.65 | 31.65 | 31.65 | 4072.0 |
| 2015-04-16 04:20:00 | AAPL | Stock | 31.625 | 31.625 | 31.625 | 31.625 | 800.0 |
| 2015-04-16 05:15:00 | AAPL | Stock | 31.67 | 31.67 | 31.67 | 31.67 | 504.0 |
| 2015-04-16 05:25:00 | AAPL | Stock | 31.6725 | 31.6725 | 31.6725 | 31.6725 | 580.0 |
| 2015-04-16 05:40:00 | AAPL | Stock | 31.6625 | 31.6625 | 31.66 | 31.66 | 1200.0 |
| 2015-04-16 05:45:00 | AAPL | Stock | 31.64 | 31.64 | 31.64 | 31.64 | 800.0 |
| 2015-04-16 05:50:00 | AAPL | Stock | 31.655 | 31.655 | 31.655 | 31.655 | 1188.0 |
| 2015-04-16 05:55:00 | AAPL | Stock | 31.6375 | 31.6375 | 31.6375 | 31.6375 | 756.0 |
| 2015-04-16 06:00:00 | AAPL | Stock | 31.6 | 31.6 | 31.6 | 31.6 | 400.0 |
| 2015-04-16 06:05:00 | AAPL | Stock | 31.6025 | 31.6025 | 31.575 | 31.58 | 8000.0 |
| 2015-04-16 06:10:00 | AAPL | Stock | 31.5775 | 31.5775 | 31.5775 | 31.5775 | 4800.0 |
| 2015-04-16 06:20:00 | AAPL | Stock | 31.58 | 31.58 | 31.5775 | 31.5775 | 800.0 |
| 2015-04-16 06:25:00 | AAPL | Stock | 31.5975 | 31.5975 | 31.5975 | 31.5975 | 400.0 |
| 2015-04-16 06:30:00 | AAPL | Stock | 31.5875 | 31.625 | 31.585 | 31.625 | 6400.0 |
| 2015-04-16 06:40:00 | AAPL | Stock | 31.6175 | 31.6225 | 31.61 | 31.6225 | 5056.0 |
| 2015-04-16 06:55:00 | AAPL | Stock | 31.61 | 31.61 | 31.605 | 31.605 | 800.0 |
| 2015-04-16 07:00:00 | AAPL | Stock | 31.6 | 31.6 | 31.59 | 31.59 | 18184.0 |
| 2015-04-16 07:05:00 | AAPL | Stock | 31.6 | 31.61 | 31.5875 | 31.59 | 7296.0 |
| 2015-04-16 07:10:00 | AAPL | Stock | 31.59 | 31.5925 | 31.5775 | 31.5775 | 22692.0 |
| 2015-04-16 07:15:00 | AAPL | Stock | 31.5875 | 31.5875 | 31.5875 | 31.5875 | 400.0 |
| 2015-04-16 07:20:00 | AAPL | Stock | 31.58 | 31.585 | 31.5775 | 31.5775 | 3720.0 |
| 2015-04-16 07:25:00 | AAPL | Stock | 31.58 | 31.58 | 31.58 | 31.58 | 1000.0 |
| 2015-04-16 07:30:00 | AAPL | Stock | 31.585 | 31.59 | 31.585 | 31.59 | 2400.0 |
| 2015-04-16 07:35:00 | AAPL | Stock | 31.5925 | 31.6075 | 31.5925 | 31.6075 | 8920.0 |
| 2015-04-16 07:40:00 | AAPL | Stock | 31.6025 | 31.6125 | 31.6025 | 31.6125 | 4200.0 |
| 2015-04-16 07:45:00 | AAPL | Stock | 31.5975 | 31.6025 | 31.5925 | 31.5925 | 11600.0 |
| 2015-04-16 07:50:00 | AAPL | Stock | 31.5925 | 31.6 | 31.59 | 31.5925 | 14536.0 |
| 2015-04-16 07:55:00 | AAPL | Stock | 31.5975 | 31.6125 | 31.5925 | 31.6125 | 4500.0 |
| 2015-04-16 08:00:00 | AAPL | Stock | 31.6125 | 31.635 | 31.5775 | 31.63 | 103428.0 |
| 2015-04-16 08:05:00 | AAPL | Stock | 31.625 | 31.635 | 31.625 | 31.635 | 27940.0 |
| 2015-04-16 08:10:00 | AAPL | Stock | 31.635 | 31.67 | 31.635 | 31.6525 | 43460.0 |
| 2015-04-16 08:15:00 | AAPL | Stock | 31.6425 | 31.65 | 31.6328 | 31.65 | 22484.0 |
| 2015-04-16 08:20:00 | AAPL | Stock | 31.6525 | 31.655 | 31.65 | 31.65 | 6124.0 |
| 2015-04-16 08:25:00 | AAPL | Stock | 31.66 | 31.6675 | 31.6525 | 31.6525 | 14720.0 |
| 2015-04-16 08:30:00 | AAPL | Stock | 31.65 | 31.6525 | 31.64 | 31.64 | 15160.0 |
| 2015-04-16 08:35:00 | AAPL | Stock | 31.64 | 31.64 | 31.595 | 31.6 | 76068.0 |
| 2015-04-16 08:40:00 | AAPL | Stock | 31.6 | 31.6 | 31.5875 | 31.59 | 75488.0 |
| 2015-04-16 08:45:00 | AAPL | Stock | 31.6075 | 31.6075 | 31.5975 | 31.5975 | 10000.0 |
| 2015-04-16 08:50:00 | AAPL | Stock | 31.59 | 31.5925 | 31.585 | 31.585 | 16404.0 |
| 2015-04-16 08:55:00 | AAPL | Stock | 31.595 | 31.5975 | 31.59 | 31.595 | 12356.0 |
| 2015-04-16 09:00:00 | AAPL | Stock | 31.6025 | 31.62 | 31.595 | 31.6125 | 28860.0 |
| 2015-04-16 09:05:00 | AAPL | Stock | 31.6225 | 31.625 | 31.6198 | 31.625 | 20624.0 |
| 2015-04-16 09:10:00 | AAPL | Stock | 31.625 | 31.64 | 31.625 | 31.64 | 52508.0 |
| 2015-04-16 09:15:00 | AAPL | Stock | 31.625 | 31.635 | 31.62 | 31.6275 | 13228.0 |
| 2015-04-16 09:20:00 | AAPL | Stock | 31.6325 | 31.6375 | 31.62 | 31.6375 | 14560.0 |
| 2015-04-16 09:25:00 | AAPL | Stock | 31.64 | 31.6675 | 31.5625 | 31.6075 | 191716.0 |
| 2015-04-16 09:30:00 | AAPL | Stock | 31.605 | 31.6575 | 31.5425 | 31.6075 | 5474664.0 |
| 2015-04-16 09:35:00 | AAPL | Stock | 31.6075 | 31.7125 | 31.5875 | 31.6625 | 3139828.0 |
| 2015-04-16 09:40:00 | AAPL | Stock | 31.6602 | 31.775 | 31.6325 | 31.7425 | 3578488.0 |
> showing 50 of 354,175 rows — these rows as CSV