PREVIEW / stock_5min / 2015-10-29
file: by_date/stock_5min/2015/2015-10-29.parquet size: 5.4 MB rows: 355,678 symbols: 3,408
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-10-29 04:00:00 | AAPL | Stock | 29.8 | 29.8 | 29.615 | 29.615 | 1536.0 |
| 2015-10-29 04:05:00 | AAPL | Stock | 29.6475 | 29.655 | 29.5925 | 29.6375 | 7992.0 |
| 2015-10-29 04:10:00 | AAPL | Stock | 29.625 | 29.625 | 29.6225 | 29.6225 | 1400.0 |
| 2015-10-29 04:15:00 | AAPL | Stock | 29.6175 | 29.62 | 29.6 | 29.62 | 2048.0 |
| 2015-10-29 04:20:00 | AAPL | Stock | 29.5825 | 29.5875 | 29.5425 | 29.565 | 2620.0 |
| 2015-10-29 04:25:00 | AAPL | Stock | 29.55 | 29.5675 | 29.55 | 29.5675 | 1816.0 |
| 2015-10-29 04:30:00 | AAPL | Stock | 29.59 | 29.59 | 29.565 | 29.565 | 1604.0 |
| 2015-10-29 04:35:00 | AAPL | Stock | 29.6125 | 29.6125 | 29.5825 | 29.5825 | 2000.0 |
| 2015-10-29 04:50:00 | AAPL | Stock | 29.6 | 29.6075 | 29.6 | 29.6075 | 1200.0 |
| 2015-10-29 05:00:00 | AAPL | Stock | 29.5625 | 29.5625 | 29.5625 | 29.5625 | 4000.0 |
| 2015-10-29 05:05:00 | AAPL | Stock | 29.5475 | 29.5625 | 29.545 | 29.5625 | 13824.0 |
| 2015-10-29 05:15:00 | AAPL | Stock | 29.55 | 29.55 | 29.55 | 29.55 | 8000.0 |
| 2015-10-29 05:25:00 | AAPL | Stock | 29.5625 | 29.575 | 29.5625 | 29.575 | 1200.0 |
| 2015-10-29 05:30:00 | AAPL | Stock | 29.5975 | 29.5975 | 29.5625 | 29.5875 | 2468.0 |
| 2015-10-29 05:35:00 | AAPL | Stock | 29.565 | 29.565 | 29.5625 | 29.5625 | 1636.0 |
| 2015-10-29 05:50:00 | AAPL | Stock | 29.5625 | 29.575 | 29.5625 | 29.575 | 1216.0 |
| 2015-10-29 05:55:00 | AAPL | Stock | 29.5975 | 29.6 | 29.5975 | 29.6 | 4000.0 |
| 2015-10-29 06:00:00 | AAPL | Stock | 29.5975 | 29.6 | 29.5975 | 29.6 | 4484.0 |
| 2015-10-29 06:05:00 | AAPL | Stock | 29.6 | 29.6 | 29.6 | 29.6 | 800.0 |
| 2015-10-29 06:10:00 | AAPL | Stock | 29.6 | 29.6 | 29.5975 | 29.6 | 6500.0 |
| 2015-10-29 06:15:00 | AAPL | Stock | 29.6 | 29.6 | 29.5625 | 29.5625 | 5004.0 |
| 2015-10-29 06:25:00 | AAPL | Stock | 29.5625 | 29.6 | 29.5625 | 29.6 | 5400.0 |
| 2015-10-29 06:30:00 | AAPL | Stock | 29.6 | 29.6 | 29.555 | 29.555 | 1600.0 |
| 2015-10-29 06:40:00 | AAPL | Stock | 29.6125 | 29.6125 | 29.5875 | 29.5875 | 4800.0 |
| 2015-10-29 06:45:00 | AAPL | Stock | 29.6125 | 29.6125 | 29.6125 | 29.6125 | 400.0 |
| 2015-10-29 06:50:00 | AAPL | Stock | 29.6 | 29.6 | 29.5875 | 29.5875 | 800.0 |
| 2015-10-29 06:55:00 | AAPL | Stock | 29.5775 | 29.5875 | 29.5775 | 29.5875 | 1200.0 |
| 2015-10-29 07:00:00 | AAPL | Stock | 29.6 | 29.6 | 29.6 | 29.6 | 2000.0 |
| 2015-10-29 07:05:00 | AAPL | Stock | 29.6075 | 29.6075 | 29.5875 | 29.5875 | 13780.0 |
| 2015-10-29 07:10:00 | AAPL | Stock | 29.6125 | 29.625 | 29.605 | 29.605 | 27700.0 |
| 2015-10-29 07:20:00 | AAPL | Stock | 29.6125 | 29.625 | 29.6125 | 29.6125 | 6800.0 |
| 2015-10-29 07:25:00 | AAPL | Stock | 29.6 | 29.6 | 29.6 | 29.6 | 6600.0 |
| 2015-10-29 07:30:00 | AAPL | Stock | 29.6 | 29.6075 | 29.5825 | 29.5825 | 6600.0 |
| 2015-10-29 07:35:00 | AAPL | Stock | 29.575 | 29.5825 | 29.575 | 29.58 | 4532.0 |
| 2015-10-29 07:40:00 | AAPL | Stock | 29.58 | 29.58 | 29.575 | 29.575 | 20400.0 |
| 2015-10-29 07:45:00 | AAPL | Stock | 29.575 | 29.5825 | 29.55 | 29.55 | 71328.0 |
| 2015-10-29 07:50:00 | AAPL | Stock | 29.5625 | 29.575 | 29.55 | 29.55 | 32072.0 |
| 2015-10-29 07:55:00 | AAPL | Stock | 29.5625 | 29.57 | 29.55 | 29.55 | 26124.0 |
| 2015-10-29 08:00:00 | AAPL | Stock | 29.565 | 29.625 | 29.5525 | 29.6075 | 89048.0 |
| 2015-10-29 08:05:00 | AAPL | Stock | 29.61 | 29.625 | 29.6 | 29.6025 | 79384.0 |
| 2015-10-29 08:10:00 | AAPL | Stock | 29.6125 | 29.615 | 29.5975 | 29.605 | 39952.0 |
| 2015-10-29 08:15:00 | AAPL | Stock | 29.6125 | 29.625 | 29.6125 | 29.625 | 66272.0 |
| 2015-10-29 08:20:00 | AAPL | Stock | 29.625 | 29.625 | 29.5975 | 29.5975 | 60512.0 |
| 2015-10-29 08:25:00 | AAPL | Stock | 29.595 | 29.625 | 29.5925 | 29.6175 | 86704.0 |
| 2015-10-29 08:30:00 | AAPL | Stock | 29.6225 | 29.625 | 29.6 | 29.61 | 73244.0 |
| 2015-10-29 08:35:00 | AAPL | Stock | 29.6125 | 29.6275 | 29.61 | 29.6225 | 119408.0 |
| 2015-10-29 08:40:00 | AAPL | Stock | 29.625 | 29.625 | 29.61 | 29.6125 | 25592.0 |
| 2015-10-29 08:45:00 | AAPL | Stock | 29.62 | 29.6225 | 29.61 | 29.6125 | 23804.0 |
| 2015-10-29 08:50:00 | AAPL | Stock | 29.6025 | 29.6175 | 29.6 | 29.6175 | 53916.0 |
| 2015-10-29 08:55:00 | AAPL | Stock | 29.6175 | 29.65 | 29.6125 | 29.65 | 95644.0 |
> showing 50 of 355,678 rows — these rows as CSV