PREVIEW / stock_5min / 2015-06-15
file: by_date/stock_5min/2015/2015-06-15.parquet size: 5.5 MB rows: 369,738 symbols: 3,513
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-06-15 04:00:00 | AAPL | Stock | 31.75 | 31.75 | 31.615 | 31.615 | 82620.0 |
| 2015-06-15 04:05:00 | AAPL | Stock | 31.615 | 31.6625 | 31.615 | 31.6625 | 6776.0 |
| 2015-06-15 04:10:00 | AAPL | Stock | 31.65 | 31.65 | 31.6375 | 31.65 | 26000.0 |
| 2015-06-15 04:15:00 | AAPL | Stock | 31.65 | 31.65 | 31.65 | 31.65 | 600.0 |
| 2015-06-15 04:25:00 | AAPL | Stock | 31.625 | 31.625 | 31.625 | 31.625 | 400.0 |
| 2015-06-15 04:30:00 | AAPL | Stock | 31.625 | 31.625 | 31.625 | 31.625 | 3328.0 |
| 2015-06-15 04:35:00 | AAPL | Stock | 31.65 | 31.65 | 31.65 | 31.65 | 400.0 |
| 2015-06-15 04:45:00 | AAPL | Stock | 31.625 | 31.625 | 31.625 | 31.625 | 2400.0 |
| 2015-06-15 04:50:00 | AAPL | Stock | 31.625 | 31.6375 | 31.625 | 31.6375 | 3628.0 |
| 2015-06-15 04:55:00 | AAPL | Stock | 31.625 | 31.625 | 31.625 | 31.625 | 2336.0 |
| 2015-06-15 05:00:00 | AAPL | Stock | 31.625 | 31.6375 | 31.625 | 31.6375 | 1920.0 |
| 2015-06-15 05:05:00 | AAPL | Stock | 31.6375 | 31.6375 | 31.6375 | 31.6375 | 400.0 |
| 2015-06-15 05:10:00 | AAPL | Stock | 31.6375 | 31.6375 | 31.6375 | 31.6375 | 1200.0 |
| 2015-06-15 05:15:00 | AAPL | Stock | 31.6375 | 31.6375 | 31.6375 | 31.6375 | 1200.0 |
| 2015-06-15 05:30:00 | AAPL | Stock | 31.6425 | 31.6425 | 31.6425 | 31.6425 | 400.0 |
| 2015-06-15 05:35:00 | AAPL | Stock | 31.6375 | 31.6375 | 31.6375 | 31.6375 | 2000.0 |
| 2015-06-15 05:45:00 | AAPL | Stock | 31.6425 | 31.6425 | 31.6425 | 31.6425 | 584.0 |
| 2015-06-15 05:50:00 | AAPL | Stock | 31.6425 | 31.6425 | 31.6175 | 31.625 | 20716.0 |
| 2015-06-15 05:55:00 | AAPL | Stock | 31.6175 | 31.6325 | 31.6175 | 31.6175 | 5392.0 |
| 2015-06-15 06:00:00 | AAPL | Stock | 31.6175 | 31.6175 | 31.615 | 31.615 | 3700.0 |
| 2015-06-15 06:05:00 | AAPL | Stock | 31.625 | 31.625 | 31.6125 | 31.6125 | 4040.0 |
| 2015-06-15 06:10:00 | AAPL | Stock | 31.6125 | 31.6125 | 31.6125 | 31.6125 | 2740.0 |
| 2015-06-15 06:15:00 | AAPL | Stock | 31.6125 | 31.6125 | 31.6125 | 31.6125 | 4680.0 |
| 2015-06-15 06:20:00 | AAPL | Stock | 31.6225 | 31.6225 | 31.62 | 31.6225 | 3480.0 |
| 2015-06-15 06:25:00 | AAPL | Stock | 31.6225 | 31.625 | 31.6125 | 31.625 | 15560.0 |
| 2015-06-15 06:30:00 | AAPL | Stock | 31.625 | 31.65 | 31.625 | 31.645 | 11756.0 |
| 2015-06-15 06:40:00 | AAPL | Stock | 31.6325 | 31.64 | 31.6275 | 31.64 | 4280.0 |
| 2015-06-15 06:45:00 | AAPL | Stock | 31.64 | 31.655 | 31.64 | 31.655 | 2800.0 |
| 2015-06-15 06:55:00 | AAPL | Stock | 31.6425 | 31.6425 | 31.6425 | 31.6425 | 800.0 |
| 2015-06-15 07:00:00 | AAPL | Stock | 31.64 | 31.64 | 31.625 | 31.625 | 4000.0 |
| 2015-06-15 07:05:00 | AAPL | Stock | 31.6275 | 31.6275 | 31.6275 | 31.6275 | 1204.0 |
| 2015-06-15 07:10:00 | AAPL | Stock | 31.6375 | 31.6375 | 31.625 | 31.625 | 3364.0 |
| 2015-06-15 07:15:00 | AAPL | Stock | 31.625 | 31.625 | 31.6125 | 31.6125 | 10420.0 |
| 2015-06-15 07:20:00 | AAPL | Stock | 31.605 | 31.605 | 31.605 | 31.605 | 13600.0 |
| 2015-06-15 07:25:00 | AAPL | Stock | 31.5975 | 31.5975 | 31.595 | 31.595 | 2292.0 |
| 2015-06-15 07:30:00 | AAPL | Stock | 31.595 | 31.595 | 31.575 | 31.575 | 21512.0 |
| 2015-06-15 07:35:00 | AAPL | Stock | 31.58 | 31.5825 | 31.58 | 31.5825 | 2832.0 |
| 2015-06-15 07:40:00 | AAPL | Stock | 31.5825 | 31.585 | 31.575 | 31.575 | 15240.0 |
| 2015-06-15 07:45:00 | AAPL | Stock | 31.565 | 31.575 | 31.565 | 31.565 | 14720.0 |
| 2015-06-15 07:50:00 | AAPL | Stock | 31.5625 | 31.565 | 31.555 | 31.555 | 7404.0 |
| 2015-06-15 07:55:00 | AAPL | Stock | 31.5625 | 31.5675 | 31.5625 | 31.5675 | 7968.0 |
| 2015-06-15 08:00:00 | AAPL | Stock | 31.575 | 31.6475 | 31.5625 | 31.6 | 200672.0 |
| 2015-06-15 08:05:00 | AAPL | Stock | 31.6 | 31.61 | 31.5825 | 31.6 | 48960.0 |
| 2015-06-15 08:10:00 | AAPL | Stock | 31.6 | 31.6 | 31.575 | 31.5775 | 112824.0 |
| 2015-06-15 08:15:00 | AAPL | Stock | 31.5775 | 31.5875 | 31.575 | 31.585 | 73252.0 |
| 2015-06-15 08:20:00 | AAPL | Stock | 31.5825 | 31.595 | 31.5775 | 31.5825 | 42392.0 |
| 2015-06-15 08:25:00 | AAPL | Stock | 31.5825 | 31.585 | 31.5775 | 31.585 | 17200.0 |
| 2015-06-15 08:30:00 | AAPL | Stock | 31.5875 | 31.5875 | 31.565 | 31.565 | 36112.0 |
| 2015-06-15 08:35:00 | AAPL | Stock | 31.565 | 31.57 | 31.5625 | 31.565 | 98784.0 |
| 2015-06-15 08:40:00 | AAPL | Stock | 31.5675 | 31.5675 | 31.565 | 31.5675 | 59840.0 |
> showing 50 of 369,738 rows — these rows as CSV