PREVIEW / stock_5min / 2016-12-29
file: by_date/stock_5min/2016/2016-12-29.parquet size: 5.3 MB rows: 351,022 symbols: 3,152
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-12-29 04:15:00 | AAPL | Stock | 29.1775 | 29.1775 | 29.1775 | 29.1775 | 1584.0 |
| 2016-12-29 05:05:00 | AAPL | Stock | 29.175 | 29.175 | 29.175 | 29.175 | 400.0 |
| 2016-12-29 06:40:00 | AAPL | Stock | 29.15 | 29.15 | 29.15 | 29.15 | 400.0 |
| 2016-12-29 07:05:00 | AAPL | Stock | 29.16 | 29.16 | 29.16 | 29.16 | 560.0 |
| 2016-12-29 07:50:00 | AAPL | Stock | 29.16 | 29.16 | 29.16 | 29.16 | 400.0 |
| 2016-12-29 08:00:00 | AAPL | Stock | 29.165 | 29.1725 | 29.16 | 29.1725 | 29964.0 |
| 2016-12-29 08:05:00 | AAPL | Stock | 29.1725 | 29.1725 | 29.165 | 29.165 | 2024.0 |
| 2016-12-29 08:10:00 | AAPL | Stock | 29.1725 | 29.1775 | 29.1675 | 29.1775 | 23052.0 |
| 2016-12-29 08:15:00 | AAPL | Stock | 29.175 | 29.185 | 29.1725 | 29.175 | 7880.0 |
| 2016-12-29 08:20:00 | AAPL | Stock | 29.175 | 29.185 | 29.1675 | 29.1675 | 16716.0 |
| 2016-12-29 08:25:00 | AAPL | Stock | 29.175 | 29.175 | 29.175 | 29.175 | 400.0 |
| 2016-12-29 08:30:00 | AAPL | Stock | 29.1775 | 29.1775 | 29.1675 | 29.1675 | 3200.0 |
| 2016-12-29 08:35:00 | AAPL | Stock | 29.1625 | 29.1625 | 29.1625 | 29.1625 | 2628.0 |
| 2016-12-29 08:45:00 | AAPL | Stock | 29.1625 | 29.1625 | 29.1625 | 29.1625 | 800.0 |
| 2016-12-29 08:55:00 | AAPL | Stock | 29.15 | 29.17 | 29.15 | 29.1675 | 5800.0 |
| 2016-12-29 09:00:00 | AAPL | Stock | 29.1625 | 29.1625 | 29.15 | 29.15 | 12032.0 |
| 2016-12-29 09:15:00 | AAPL | Stock | 29.15 | 29.15 | 29.1375 | 29.15 | 4396.0 |
| 2016-12-29 09:20:00 | AAPL | Stock | 29.14 | 29.1525 | 29.1375 | 29.1525 | 5600.0 |
| 2016-12-29 09:25:00 | AAPL | Stock | 29.1525 | 29.17 | 29.1025 | 29.1025 | 68200.0 |
| 2016-12-29 09:30:00 | AAPL | Stock | 29.135 | 29.2375 | 29.11 | 29.17 | 2621468.0 |
| 2016-12-29 09:35:00 | AAPL | Stock | 29.175 | 29.2675 | 29.1725 | 29.2675 | 2222032.0 |
| 2016-12-29 09:40:00 | AAPL | Stock | 29.2638 | 29.2775 | 29.1765 | 29.195 | 1642620.0 |
| 2016-12-29 09:45:00 | AAPL | Stock | 29.1925 | 29.22 | 29.1725 | 29.185 | 1143516.0 |
| 2016-12-29 09:50:00 | AAPL | Stock | 29.185 | 29.214 | 29.1725 | 29.1962 | 969212.0 |
| 2016-12-29 09:55:00 | AAPL | Stock | 29.1938 | 29.215 | 29.1725 | 29.2075 | 780204.0 |
| 2016-12-29 10:00:00 | AAPL | Stock | 29.2062 | 29.2375 | 29.2025 | 29.2175 | 984032.0 |
| 2016-12-29 10:05:00 | AAPL | Stock | 29.22 | 29.22 | 29.1675 | 29.17 | 874956.0 |
| 2016-12-29 10:10:00 | AAPL | Stock | 29.1675 | 29.2025 | 29.1625 | 29.195 | 675428.0 |
| 2016-12-29 10:15:00 | AAPL | Stock | 29.195 | 29.2325 | 29.1925 | 29.2298 | 719668.0 |
| 2016-12-29 10:20:00 | AAPL | Stock | 29.2275 | 29.245 | 29.2262 | 29.2375 | 656280.0 |
| 2016-12-29 10:25:00 | AAPL | Stock | 29.24 | 29.275 | 29.2375 | 29.2588 | 1134620.0 |
| 2016-12-29 10:30:00 | AAPL | Stock | 29.2588 | 29.26 | 29.2375 | 29.24 | 536176.0 |
| 2016-12-29 10:35:00 | AAPL | Stock | 29.24 | 29.255 | 29.22 | 29.22 | 807008.0 |
| 2016-12-29 10:40:00 | AAPL | Stock | 29.22 | 29.2225 | 29.175 | 29.175 | 1097572.0 |
| 2016-12-29 10:45:00 | AAPL | Stock | 29.1738 | 29.2175 | 29.17 | 29.1775 | 808300.0 |
| 2016-12-29 10:50:00 | AAPL | Stock | 29.1775 | 29.1775 | 29.15 | 29.1675 | 735220.0 |
| 2016-12-29 10:55:00 | AAPL | Stock | 29.1675 | 29.1975 | 29.165 | 29.1772 | 824200.0 |
| 2016-12-29 11:00:00 | AAPL | Stock | 29.1775 | 29.1788 | 29.155 | 29.1625 | 480556.0 |
| 2016-12-29 11:05:00 | AAPL | Stock | 29.1612 | 29.1788 | 29.1475 | 29.1625 | 644812.0 |
| 2016-12-29 11:10:00 | AAPL | Stock | 29.1612 | 29.1688 | 29.1525 | 29.1525 | 532216.0 |
| 2016-12-29 11:15:00 | AAPL | Stock | 29.1512 | 29.16 | 29.1325 | 29.16 | 559940.0 |
| 2016-12-29 11:20:00 | AAPL | Stock | 29.1595 | 29.1675 | 29.135 | 29.1398 | 574792.0 |
| 2016-12-29 11:25:00 | AAPL | Stock | 29.1375 | 29.1625 | 29.1362 | 29.1538 | 474724.0 |
| 2016-12-29 11:30:00 | AAPL | Stock | 29.155 | 29.155 | 29.1275 | 29.135 | 626728.0 |
| 2016-12-29 11:35:00 | AAPL | Stock | 29.135 | 29.16 | 29.135 | 29.15 | 825004.0 |
| 2016-12-29 11:40:00 | AAPL | Stock | 29.15 | 29.1522 | 29.14 | 29.1422 | 280972.0 |
| 2016-12-29 11:45:00 | AAPL | Stock | 29.1408 | 29.1538 | 29.1388 | 29.15 | 490804.0 |
| 2016-12-29 11:50:00 | AAPL | Stock | 29.15 | 29.15 | 29.1 | 29.1188 | 763348.0 |
| 2016-12-29 11:55:00 | AAPL | Stock | 29.119 | 29.14 | 29.1175 | 29.1262 | 473664.0 |
| 2016-12-29 12:00:00 | AAPL | Stock | 29.1262 | 29.16 | 29.1225 | 29.155 | 457600.0 |
> showing 50 of 351,022 rows — these rows as CSV