PREVIEW / stock_1min / 2016-12-29
file: by_date/stock_1min/2016/2016-12-29.parquet size: 13.8 MB rows: 1,008,022 symbols: 2,602
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:18:00 | AAPL | Stock | 29.1775 | 29.1775 | 29.1775 | 29.1775 | 1584.0 |
| 2016-12-29 05:09:00 | AAPL | Stock | 29.175 | 29.175 | 29.175 | 29.175 | 400.0 |
| 2016-12-29 06:41:00 | AAPL | Stock | 29.15 | 29.15 | 29.15 | 29.15 | 400.0 |
| 2016-12-29 07:09: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.165 | 29.1625 | 29.1625 | 6400.0 |
| 2016-12-29 08:01:00 | AAPL | Stock | 29.1625 | 29.1625 | 29.1625 | 29.1625 | 1200.0 |
| 2016-12-29 08:02:00 | AAPL | Stock | 29.16 | 29.1625 | 29.16 | 29.1625 | 14000.0 |
| 2016-12-29 08:03:00 | AAPL | Stock | 29.1625 | 29.1625 | 29.1625 | 29.1625 | 6800.0 |
| 2016-12-29 08:04:00 | AAPL | Stock | 29.1625 | 29.1725 | 29.1625 | 29.1725 | 1564.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.1725 | 29.1725 | 29.1725 | 2120.0 |
| 2016-12-29 08:11:00 | AAPL | Stock | 29.1725 | 29.1725 | 29.1675 | 29.1675 | 1600.0 |
| 2016-12-29 08:12:00 | AAPL | Stock | 29.1725 | 29.1725 | 29.1725 | 29.1725 | 400.0 |
| 2016-12-29 08:13:00 | AAPL | Stock | 29.1675 | 29.175 | 29.1675 | 29.1725 | 10920.0 |
| 2016-12-29 08:14:00 | AAPL | Stock | 29.1775 | 29.1775 | 29.175 | 29.1775 | 8012.0 |
| 2016-12-29 08:15:00 | AAPL | Stock | 29.175 | 29.175 | 29.1725 | 29.1725 | 3000.0 |
| 2016-12-29 08:16:00 | AAPL | Stock | 29.175 | 29.185 | 29.1725 | 29.1725 | 3280.0 |
| 2016-12-29 08:17:00 | AAPL | Stock | 29.175 | 29.175 | 29.175 | 29.175 | 1600.0 |
| 2016-12-29 08:21:00 | AAPL | Stock | 29.175 | 29.175 | 29.175 | 29.175 | 4000.0 |
| 2016-12-29 08:23:00 | AAPL | Stock | 29.1725 | 29.1725 | 29.1725 | 29.1725 | 5516.0 |
| 2016-12-29 08:24:00 | AAPL | Stock | 29.185 | 29.185 | 29.1675 | 29.1675 | 7200.0 |
| 2016-12-29 08:27: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.1775 | 29.1775 | 800.0 |
| 2016-12-29 08:34:00 | AAPL | Stock | 29.1725 | 29.1725 | 29.1675 | 29.1675 | 2400.0 |
| 2016-12-29 08:35:00 | AAPL | Stock | 29.1625 | 29.1625 | 29.1625 | 29.1625 | 2628.0 |
| 2016-12-29 08:46:00 | AAPL | Stock | 29.1625 | 29.1625 | 29.1625 | 29.1625 | 800.0 |
| 2016-12-29 08:56:00 | AAPL | Stock | 29.15 | 29.15 | 29.15 | 29.15 | 4000.0 |
| 2016-12-29 08:58:00 | AAPL | Stock | 29.1675 | 29.17 | 29.1675 | 29.1675 | 1800.0 |
| 2016-12-29 09:00:00 | AAPL | Stock | 29.1625 | 29.1625 | 29.1625 | 29.1625 | 1200.0 |
| 2016-12-29 09:02:00 | AAPL | Stock | 29.155 | 29.155 | 29.15 | 29.15 | 9632.0 |
| 2016-12-29 09:03:00 | AAPL | Stock | 29.15 | 29.15 | 29.15 | 29.15 | 400.0 |
| 2016-12-29 09:04:00 | AAPL | Stock | 29.15 | 29.15 | 29.15 | 29.15 | 800.0 |
| 2016-12-29 09:16:00 | AAPL | Stock | 29.15 | 29.15 | 29.15 | 29.15 | 1596.0 |
| 2016-12-29 09:18:00 | AAPL | Stock | 29.14 | 29.15 | 29.1375 | 29.15 | 2800.0 |
| 2016-12-29 09:20:00 | AAPL | Stock | 29.14 | 29.14 | 29.14 | 29.14 | 800.0 |
| 2016-12-29 09:21:00 | AAPL | Stock | 29.1375 | 29.14 | 29.1375 | 29.14 | 2800.0 |
| 2016-12-29 09:24:00 | AAPL | Stock | 29.1525 | 29.1525 | 29.1525 | 29.1525 | 2000.0 |
| 2016-12-29 09:25:00 | AAPL | Stock | 29.1525 | 29.1625 | 29.15 | 29.1625 | 18268.0 |
| 2016-12-29 09:27:00 | AAPL | Stock | 29.1625 | 29.17 | 29.1625 | 29.17 | 10420.0 |
| 2016-12-29 09:28:00 | AAPL | Stock | 29.1625 | 29.1625 | 29.12 | 29.12 | 29712.0 |
| 2016-12-29 09:29:00 | AAPL | Stock | 29.1125 | 29.1125 | 29.1025 | 29.1025 | 9800.0 |
| 2016-12-29 09:30:00 | AAPL | Stock | 29.135 | 29.2375 | 29.11 | 29.16 | 1391628.0 |
| 2016-12-29 09:31:00 | AAPL | Stock | 29.15 | 29.1762 | 29.1425 | 29.165 | 189232.0 |
| 2016-12-29 09:32:00 | AAPL | Stock | 29.16 | 29.19 | 29.151 | 29.185 | 459780.0 |
| 2016-12-29 09:33:00 | AAPL | Stock | 29.185 | 29.185 | 29.1425 | 29.1775 | 385912.0 |
| 2016-12-29 09:34:00 | AAPL | Stock | 29.1768 | 29.18 | 29.155 | 29.17 | 194916.0 |
| 2016-12-29 09:35:00 | AAPL | Stock | 29.175 | 29.2225 | 29.1725 | 29.205 | 501828.0 |
| 2016-12-29 09:36:00 | AAPL | Stock | 29.205 | 29.2255 | 29.175 | 29.21 | 407404.0 |
| 2016-12-29 09:37:00 | AAPL | Stock | 29.2075 | 29.24 | 29.205 | 29.2225 | 349132.0 |
> showing 50 of 1,008,022 rows — these rows as CSV