PREVIEW / stock_5min / 2016-10-12
file: by_date/stock_5min/2016/2016-10-12.parquet size: 5.1 MB rows: 338,887 symbols: 3,174
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 |
|---|---|---|---|---|---|---|---|
| 2016-10-12 04:00:00 | AAPL | Stock | 29.2325 | 29.2325 | 29.2325 | 29.2325 | 400.0 |
| 2016-10-12 04:05:00 | AAPL | Stock | 29.175 | 29.175 | 29.175 | 29.175 | 1200.0 |
| 2016-10-12 04:10:00 | AAPL | Stock | 29.2 | 29.2025 | 29.2 | 29.2025 | 4400.0 |
| 2016-10-12 04:40:00 | AAPL | Stock | 29.2475 | 29.25 | 29.22 | 29.22 | 4848.0 |
| 2016-10-12 05:10:00 | AAPL | Stock | 29.24 | 29.25 | 29.24 | 29.25 | 2400.0 |
| 2016-10-12 05:15:00 | AAPL | Stock | 29.2525 | 29.2525 | 29.25 | 29.2525 | 2100.0 |
| 2016-10-12 05:20:00 | AAPL | Stock | 29.24 | 29.24 | 29.24 | 29.24 | 1200.0 |
| 2016-10-12 05:30:00 | AAPL | Stock | 29.2575 | 29.2575 | 29.25 | 29.25 | 2580.0 |
| 2016-10-12 05:40:00 | AAPL | Stock | 29.275 | 29.28 | 29.275 | 29.28 | 2000.0 |
| 2016-10-12 05:45:00 | AAPL | Stock | 29.3075 | 29.3075 | 29.255 | 29.2725 | 34272.0 |
| 2016-10-12 05:50:00 | AAPL | Stock | 29.26 | 29.26 | 29.225 | 29.2325 | 14744.0 |
| 2016-10-12 05:55:00 | AAPL | Stock | 29.235 | 29.235 | 29.235 | 29.235 | 800.0 |
| 2016-10-12 06:00:00 | AAPL | Stock | 29.235 | 29.28 | 29.235 | 29.28 | 4056.0 |
| 2016-10-12 06:05:00 | AAPL | Stock | 29.2375 | 29.2375 | 29.2325 | 29.2325 | 8000.0 |
| 2016-10-12 06:10:00 | AAPL | Stock | 29.2325 | 29.25 | 29.205 | 29.2125 | 2580.0 |
| 2016-10-12 06:15:00 | AAPL | Stock | 29.25 | 29.26 | 29.235 | 29.235 | 6684.0 |
| 2016-10-12 06:20:00 | AAPL | Stock | 29.235 | 29.235 | 29.2325 | 29.2325 | 1600.0 |
| 2016-10-12 06:25:00 | AAPL | Stock | 29.2325 | 29.26 | 29.2325 | 29.25 | 4400.0 |
| 2016-10-12 06:30:00 | AAPL | Stock | 29.2325 | 29.2325 | 29.2325 | 29.2325 | 8236.0 |
| 2016-10-12 06:35:00 | AAPL | Stock | 29.235 | 29.2425 | 29.2325 | 29.2325 | 5200.0 |
| 2016-10-12 06:40:00 | AAPL | Stock | 29.2425 | 29.2425 | 29.2425 | 29.2425 | 12000.0 |
| 2016-10-12 06:45:00 | AAPL | Stock | 29.25 | 29.25 | 29.25 | 29.25 | 1200.0 |
| 2016-10-12 06:50:00 | AAPL | Stock | 29.2425 | 29.2425 | 29.2425 | 29.2425 | 2000.0 |
| 2016-10-12 06:55:00 | AAPL | Stock | 29.2375 | 29.2375 | 29.2375 | 29.2375 | 11772.0 |
| 2016-10-12 07:00:00 | AAPL | Stock | 29.24 | 29.265 | 29.2325 | 29.265 | 13740.0 |
| 2016-10-12 07:05:00 | AAPL | Stock | 29.26 | 29.26 | 29.2375 | 29.25 | 13240.0 |
| 2016-10-12 07:10:00 | AAPL | Stock | 29.26 | 29.26 | 29.245 | 29.25 | 13200.0 |
| 2016-10-12 07:20:00 | AAPL | Stock | 29.2375 | 29.2375 | 29.2325 | 29.2375 | 6400.0 |
| 2016-10-12 07:25:00 | AAPL | Stock | 29.24 | 29.245 | 29.225 | 29.225 | 19096.0 |
| 2016-10-12 07:30:00 | AAPL | Stock | 29.2325 | 29.24 | 29.225 | 29.24 | 13380.0 |
| 2016-10-12 07:35:00 | AAPL | Stock | 29.2275 | 29.2275 | 29.215 | 29.2275 | 15160.0 |
| 2016-10-12 07:40:00 | AAPL | Stock | 29.2275 | 29.2275 | 29.2075 | 29.2075 | 16124.0 |
| 2016-10-12 07:45:00 | AAPL | Stock | 29.2125 | 29.2125 | 29.1875 | 29.195 | 17700.0 |
| 2016-10-12 07:50:00 | AAPL | Stock | 29.1975 | 29.2125 | 29.1975 | 29.2125 | 6600.0 |
| 2016-10-12 07:55:00 | AAPL | Stock | 29.21 | 29.21 | 29.195 | 29.195 | 1744.0 |
| 2016-10-12 08:00:00 | AAPL | Stock | 29.1975 | 29.2725 | 29.0125 | 29.17 | 192304.0 |
| 2016-10-12 08:05:00 | AAPL | Stock | 29.18 | 29.185 | 29.17 | 29.1825 | 22628.0 |
| 2016-10-12 08:10:00 | AAPL | Stock | 29.1825 | 29.1875 | 29.175 | 29.185 | 43664.0 |
| 2016-10-12 08:15:00 | AAPL | Stock | 29.1775 | 29.1825 | 29.1575 | 29.1775 | 31176.0 |
| 2016-10-12 08:20:00 | AAPL | Stock | 29.1675 | 29.1825 | 29.165 | 29.18 | 9140.0 |
| 2016-10-12 08:25:00 | AAPL | Stock | 29.185 | 29.1875 | 29.17 | 29.17 | 18804.0 |
| 2016-10-12 08:30:00 | AAPL | Stock | 29.1775 | 29.1775 | 29.15 | 29.15 | 33648.0 |
| 2016-10-12 08:35:00 | AAPL | Stock | 29.15 | 29.1675 | 29.1475 | 29.165 | 37832.0 |
| 2016-10-12 08:40:00 | AAPL | Stock | 29.1625 | 29.1725 | 29.1625 | 29.1725 | 3200.0 |
| 2016-10-12 08:45:00 | AAPL | Stock | 29.1725 | 29.205 | 29.155 | 29.205 | 53964.0 |
| 2016-10-12 08:50:00 | AAPL | Stock | 29.2125 | 29.3 | 29.2125 | 29.285 | 241684.0 |
| 2016-10-12 08:55:00 | AAPL | Stock | 29.2975 | 29.3125 | 29.2875 | 29.3 | 175420.0 |
| 2016-10-12 09:00:00 | AAPL | Stock | 29.305 | 29.305 | 29.2475 | 29.2525 | 121736.0 |
| 2016-10-12 09:05:00 | AAPL | Stock | 29.2575 | 29.27 | 29.24 | 29.27 | 33576.0 |
| 2016-10-12 09:10:00 | AAPL | Stock | 29.27 | 29.27 | 29.235 | 29.25 | 29284.0 |
> showing 50 of 338,887 rows — these rows as CSV