PREVIEW / stock_5min / 2014-12-03
file: by_date/stock_5min/2014/2014-12-03.parquet size: 5.5 MB rows: 367,161 symbols: 3,565
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 |
|---|---|---|---|---|---|---|---|
| 2014-12-03 04:00:00 | AAPL | Stock | 28.6475 | 28.7625 | 28.6175 | 28.6175 | 8220.0 |
| 2014-12-03 04:15:00 | AAPL | Stock | 28.625 | 28.625 | 28.625 | 28.625 | 400.0 |
| 2014-12-03 04:20:00 | AAPL | Stock | 28.625 | 28.625 | 28.625 | 28.625 | 3200.0 |
| 2014-12-03 04:25:00 | AAPL | Stock | 28.645 | 28.645 | 28.645 | 28.645 | 400.0 |
| 2014-12-03 04:35:00 | AAPL | Stock | 28.645 | 28.645 | 28.645 | 28.645 | 4000.0 |
| 2014-12-03 04:40:00 | AAPL | Stock | 28.645 | 28.675 | 28.625 | 28.625 | 15704.0 |
| 2014-12-03 04:45:00 | AAPL | Stock | 28.645 | 28.6775 | 28.645 | 28.6725 | 6124.0 |
| 2014-12-03 04:50:00 | AAPL | Stock | 28.655 | 28.655 | 28.655 | 28.655 | 840.0 |
| 2014-12-03 04:55:00 | AAPL | Stock | 28.6775 | 28.69 | 28.6775 | 28.69 | 8400.0 |
| 2014-12-03 05:05:00 | AAPL | Stock | 28.6775 | 28.6775 | 28.6775 | 28.6775 | 3400.0 |
| 2014-12-03 05:10:00 | AAPL | Stock | 28.6775 | 28.6775 | 28.6775 | 28.6775 | 1480.0 |
| 2014-12-03 05:40:00 | AAPL | Stock | 28.64 | 28.64 | 28.64 | 28.64 | 400.0 |
| 2014-12-03 05:45:00 | AAPL | Stock | 28.6125 | 28.6125 | 28.6125 | 28.6125 | 2000.0 |
| 2014-12-03 05:55:00 | AAPL | Stock | 28.6025 | 28.605 | 28.6025 | 28.6025 | 2000.0 |
| 2014-12-03 06:00:00 | AAPL | Stock | 28.5825 | 28.585 | 28.5825 | 28.5825 | 2080.0 |
| 2014-12-03 06:05:00 | AAPL | Stock | 28.585 | 28.585 | 28.585 | 28.585 | 4000.0 |
| 2014-12-03 06:10:00 | AAPL | Stock | 28.5875 | 28.5875 | 28.5775 | 28.5775 | 1200.0 |
| 2014-12-03 06:15:00 | AAPL | Stock | 28.5925 | 28.595 | 28.5925 | 28.5925 | 5200.0 |
| 2014-12-03 06:20:00 | AAPL | Stock | 28.595 | 28.595 | 28.5825 | 28.5825 | 20240.0 |
| 2014-12-03 06:25:00 | AAPL | Stock | 28.5125 | 28.5475 | 28.51 | 28.5475 | 3200.0 |
| 2014-12-03 06:30:00 | AAPL | Stock | 28.5275 | 28.5275 | 28.5225 | 28.5225 | 4000.0 |
| 2014-12-03 06:35:00 | AAPL | Stock | 28.535 | 28.535 | 28.525 | 28.53 | 5200.0 |
| 2014-12-03 06:40:00 | AAPL | Stock | 28.515 | 28.515 | 28.515 | 28.515 | 800.0 |
| 2014-12-03 06:45:00 | AAPL | Stock | 28.5225 | 28.5425 | 28.5225 | 28.5425 | 6800.0 |
| 2014-12-03 06:50:00 | AAPL | Stock | 28.5575 | 28.58 | 28.5575 | 28.58 | 2628.0 |
| 2014-12-03 06:55:00 | AAPL | Stock | 28.5675 | 28.57 | 28.5575 | 28.57 | 2400.0 |
| 2014-12-03 07:00:00 | AAPL | Stock | 28.57 | 28.595 | 28.5625 | 28.5625 | 23372.0 |
| 2014-12-03 07:05:00 | AAPL | Stock | 28.5375 | 28.57 | 28.5375 | 28.57 | 3600.0 |
| 2014-12-03 07:10:00 | AAPL | Stock | 28.575 | 28.58 | 28.5625 | 28.565 | 24252.0 |
| 2014-12-03 07:15:00 | AAPL | Stock | 28.57 | 28.5925 | 28.57 | 28.585 | 16460.0 |
| 2014-12-03 07:20:00 | AAPL | Stock | 28.57 | 28.5725 | 28.54 | 28.5725 | 27284.0 |
| 2014-12-03 07:25:00 | AAPL | Stock | 28.5625 | 28.5825 | 28.5575 | 28.5825 | 15000.0 |
| 2014-12-03 07:30:00 | AAPL | Stock | 28.5825 | 28.6 | 28.5825 | 28.6 | 2880.0 |
| 2014-12-03 07:35:00 | AAPL | Stock | 28.595 | 28.6125 | 28.595 | 28.605 | 12336.0 |
| 2014-12-03 07:40:00 | AAPL | Stock | 28.5925 | 28.6075 | 28.58 | 28.58 | 17000.0 |
| 2014-12-03 07:45:00 | AAPL | Stock | 28.58 | 28.58 | 28.565 | 28.575 | 22504.0 |
| 2014-12-03 07:50:00 | AAPL | Stock | 28.5825 | 28.585 | 28.5825 | 28.585 | 5600.0 |
| 2014-12-03 07:55:00 | AAPL | Stock | 28.59 | 28.5925 | 28.5875 | 28.5925 | 3800.0 |
| 2014-12-03 08:00:00 | AAPL | Stock | 28.6 | 28.6575 | 28.5375 | 28.5825 | 103516.0 |
| 2014-12-03 08:05:00 | AAPL | Stock | 28.58 | 28.605 | 28.5625 | 28.595 | 87992.0 |
| 2014-12-03 08:10:00 | AAPL | Stock | 28.595 | 28.65 | 28.5925 | 28.6475 | 45088.0 |
| 2014-12-03 08:15:00 | AAPL | Stock | 28.645 | 28.6475 | 28.5775 | 28.58 | 43692.0 |
| 2014-12-03 08:20:00 | AAPL | Stock | 28.59 | 28.59 | 28.575 | 28.5752 | 19900.0 |
| 2014-12-03 08:25:00 | AAPL | Stock | 28.575 | 28.595 | 28.575 | 28.59 | 28868.0 |
| 2014-12-03 08:30:00 | AAPL | Stock | 28.59 | 28.595 | 28.5875 | 28.595 | 16480.0 |
| 2014-12-03 08:35:00 | AAPL | Stock | 28.59 | 28.5975 | 28.555 | 28.575 | 37648.0 |
| 2014-12-03 08:40:00 | AAPL | Stock | 28.5825 | 28.5825 | 28.565 | 28.5725 | 28472.0 |
| 2014-12-03 08:45:00 | AAPL | Stock | 28.5725 | 28.5775 | 28.565 | 28.5775 | 25880.0 |
| 2014-12-03 08:50:00 | AAPL | Stock | 28.5825 | 28.6 | 28.575 | 28.575 | 35876.0 |
| 2014-12-03 08:55:00 | AAPL | Stock | 28.59 | 28.6375 | 28.58 | 28.625 | 46312.0 |
> showing 50 of 367,161 rows — these rows as CSV