PREVIEW / stock_5min / 2014-12-08
file: by_date/stock_5min/2014/2014-12-08.parquet size: 5.7 MB rows: 374,277 symbols: 3,562
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-08 04:05:00 | AAPL | Stock | 28.6875 | 28.695 | 28.6875 | 28.695 | 9780.0 |
| 2014-12-08 04:10:00 | AAPL | Stock | 28.65 | 28.65 | 28.65 | 28.65 | 2000.0 |
| 2014-12-08 05:40:00 | AAPL | Stock | 28.5875 | 28.5925 | 28.575 | 28.5925 | 20640.0 |
| 2014-12-08 06:00:00 | AAPL | Stock | 28.575 | 28.575 | 28.575 | 28.575 | 1156.0 |
| 2014-12-08 06:05:00 | AAPL | Stock | 28.5975 | 28.5975 | 28.5725 | 28.5725 | 4700.0 |
| 2014-12-08 06:10:00 | AAPL | Stock | 28.575 | 28.58 | 28.575 | 28.58 | 20552.0 |
| 2014-12-08 06:20:00 | AAPL | Stock | 28.6125 | 28.6375 | 28.6125 | 28.6375 | 21448.0 |
| 2014-12-08 06:25:00 | AAPL | Stock | 28.6075 | 28.625 | 28.6075 | 28.625 | 1600.0 |
| 2014-12-08 06:30:00 | AAPL | Stock | 28.65 | 28.685 | 28.65 | 28.685 | 13372.0 |
| 2014-12-08 06:35:00 | AAPL | Stock | 28.7025 | 28.7075 | 28.7025 | 28.7075 | 9900.0 |
| 2014-12-08 06:40:00 | AAPL | Stock | 28.665 | 28.665 | 28.65 | 28.65 | 2400.0 |
| 2014-12-08 06:45:00 | AAPL | Stock | 28.65 | 28.65 | 28.65 | 28.65 | 8400.0 |
| 2014-12-08 06:50:00 | AAPL | Stock | 28.6325 | 28.6375 | 28.6 | 28.6 | 20800.0 |
| 2014-12-08 06:55:00 | AAPL | Stock | 28.6075 | 28.61 | 28.575 | 28.5775 | 4648.0 |
| 2014-12-08 07:00:00 | AAPL | Stock | 28.6075 | 28.6325 | 28.6075 | 28.6325 | 33748.0 |
| 2014-12-08 07:05:00 | AAPL | Stock | 28.6325 | 28.66 | 28.6325 | 28.6325 | 26000.0 |
| 2014-12-08 07:10:00 | AAPL | Stock | 28.6325 | 28.6325 | 28.6325 | 28.6325 | 6000.0 |
| 2014-12-08 07:15:00 | AAPL | Stock | 28.6475 | 28.655 | 28.6475 | 28.655 | 10024.0 |
| 2014-12-08 07:20:00 | AAPL | Stock | 28.6675 | 28.6675 | 28.655 | 28.6575 | 9188.0 |
| 2014-12-08 07:25:00 | AAPL | Stock | 28.6375 | 28.65 | 28.6375 | 28.65 | 11572.0 |
| 2014-12-08 07:30:00 | AAPL | Stock | 28.65 | 28.6575 | 28.6475 | 28.6475 | 5600.0 |
| 2014-12-08 07:35:00 | AAPL | Stock | 28.655 | 28.7075 | 28.6525 | 28.6525 | 40636.0 |
| 2014-12-08 07:40:00 | AAPL | Stock | 28.6525 | 28.6525 | 28.625 | 28.625 | 25960.0 |
| 2014-12-08 07:45:00 | AAPL | Stock | 28.635 | 28.635 | 28.635 | 28.635 | 10000.0 |
| 2014-12-08 07:50:00 | AAPL | Stock | 28.63 | 28.635 | 28.625 | 28.625 | 20500.0 |
| 2014-12-08 07:55:00 | AAPL | Stock | 28.625 | 28.625 | 28.5925 | 28.5925 | 21168.0 |
| 2014-12-08 08:00:00 | AAPL | Stock | 28.6025 | 28.67 | 28.6025 | 28.6225 | 171952.0 |
| 2014-12-08 08:05:00 | AAPL | Stock | 28.62 | 28.6375 | 28.615 | 28.6302 | 70400.0 |
| 2014-12-08 08:10:00 | AAPL | Stock | 28.6375 | 28.6375 | 28.615 | 28.615 | 23200.0 |
| 2014-12-08 08:15:00 | AAPL | Stock | 28.615 | 28.615 | 28.61 | 28.6125 | 11304.0 |
| 2014-12-08 08:20:00 | AAPL | Stock | 28.615 | 28.6175 | 28.6125 | 28.615 | 9200.0 |
| 2014-12-08 08:25:00 | AAPL | Stock | 28.615 | 28.62 | 28.61 | 28.62 | 69292.0 |
| 2014-12-08 08:30:00 | AAPL | Stock | 28.62 | 28.62 | 28.6025 | 28.61 | 65400.0 |
| 2014-12-08 08:35:00 | AAPL | Stock | 28.615 | 28.615 | 28.5875 | 28.6025 | 48296.0 |
| 2014-12-08 08:40:00 | AAPL | Stock | 28.6025 | 28.6025 | 28.58 | 28.58 | 21420.0 |
| 2014-12-08 08:45:00 | AAPL | Stock | 28.575 | 28.575 | 28.525 | 28.5402 | 144236.0 |
| 2014-12-08 08:50:00 | AAPL | Stock | 28.5425 | 28.5425 | 28.525 | 28.5375 | 90460.0 |
| 2014-12-08 08:55:00 | AAPL | Stock | 28.53 | 28.5475 | 28.4775 | 28.49 | 174156.0 |
| 2014-12-08 09:00:00 | AAPL | Stock | 28.49 | 28.525 | 28.49 | 28.515 | 97976.0 |
| 2014-12-08 09:05:00 | AAPL | Stock | 28.5225 | 28.5325 | 28.51 | 28.52 | 81424.0 |
| 2014-12-08 09:10:00 | AAPL | Stock | 28.52 | 28.56 | 28.5125 | 28.5275 | 63980.0 |
| 2014-12-08 09:15:00 | AAPL | Stock | 28.5325 | 28.5575 | 28.5125 | 28.5575 | 56728.0 |
| 2014-12-08 09:20:00 | AAPL | Stock | 28.56 | 28.58 | 28.55 | 28.5775 | 75476.0 |
| 2014-12-08 09:25:00 | AAPL | Stock | 28.575 | 28.585 | 28.525 | 28.53 | 67184.0 |
| 2014-12-08 09:30:00 | AAPL | Stock | 28.525 | 28.5775 | 28.2825 | 28.4375 | 11030612.0 |
| 2014-12-08 09:35:00 | AAPL | Stock | 28.44 | 28.51 | 28.4055 | 28.475 | 3971036.0 |
| 2014-12-08 09:40:00 | AAPL | Stock | 28.48 | 28.585 | 28.4775 | 28.52 | 3558996.0 |
| 2014-12-08 09:45:00 | AAPL | Stock | 28.52 | 28.6125 | 28.5125 | 28.5725 | 2820960.0 |
| 2014-12-08 09:50:00 | AAPL | Stock | 28.5725 | 28.6225 | 28.5625 | 28.6125 | 2158808.0 |
| 2014-12-08 09:55:00 | AAPL | Stock | 28.615 | 28.662 | 28.5625 | 28.5628 | 3237156.0 |
> showing 50 of 374,277 rows — these rows as CSV