PREVIEW / stock_5min / 2016-09-14
file: by_date/stock_5min/2016/2016-09-14.parquet size: 5.3 MB rows: 356,173 symbols: 3,232
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-09-14 04:05:00 | AAPL | Stock | 27.05 | 27.1975 | 27.05 | 27.065 | 20180.0 |
| 2016-09-14 04:35:00 | AAPL | Stock | 27.11 | 27.11 | 27.105 | 27.105 | 2000.0 |
| 2016-09-14 04:40:00 | AAPL | Stock | 27.1075 | 27.1075 | 27.1075 | 27.1075 | 400.0 |
| 2016-09-14 04:45:00 | AAPL | Stock | 27.0725 | 27.0725 | 27.0725 | 27.0725 | 3820.0 |
| 2016-09-14 04:50:00 | AAPL | Stock | 27.0725 | 27.0725 | 27.0525 | 27.0525 | 4916.0 |
| 2016-09-14 05:00:00 | AAPL | Stock | 27.0725 | 27.0725 | 27.0725 | 27.0725 | 16000.0 |
| 2016-09-14 05:05:00 | AAPL | Stock | 27.0725 | 27.0725 | 27.0725 | 27.0725 | 23084.0 |
| 2016-09-14 05:20:00 | AAPL | Stock | 27.0525 | 27.0525 | 27.0525 | 27.0525 | 2000.0 |
| 2016-09-14 05:25:00 | AAPL | Stock | 27.05 | 27.05 | 27.05 | 27.05 | 400.0 |
| 2016-09-14 05:35:00 | AAPL | Stock | 27.05 | 27.05 | 27.05 | 27.05 | 1200.0 |
| 2016-09-14 05:55:00 | AAPL | Stock | 27.0 | 27.0 | 27.0 | 27.0 | 400.0 |
| 2016-09-14 06:00:00 | AAPL | Stock | 27.0375 | 27.0375 | 27.0375 | 27.0375 | 2740.0 |
| 2016-09-14 06:05:00 | AAPL | Stock | 27.0375 | 27.0625 | 26.9825 | 27.0625 | 23160.0 |
| 2016-09-14 06:10:00 | AAPL | Stock | 27.0625 | 27.065 | 27.0625 | 27.065 | 7760.0 |
| 2016-09-14 06:15:00 | AAPL | Stock | 27.0625 | 27.0625 | 27.0625 | 27.0625 | 2920.0 |
| 2016-09-14 06:20:00 | AAPL | Stock | 27.0625 | 27.0725 | 27.0625 | 27.0725 | 2260.0 |
| 2016-09-14 06:25:00 | AAPL | Stock | 27.0725 | 27.09 | 27.0725 | 27.09 | 3804.0 |
| 2016-09-14 06:30:00 | AAPL | Stock | 27.095 | 27.0975 | 27.095 | 27.0975 | 7500.0 |
| 2016-09-14 06:35:00 | AAPL | Stock | 27.1175 | 27.17 | 27.1175 | 27.1675 | 47644.0 |
| 2016-09-14 06:40:00 | AAPL | Stock | 27.185 | 27.195 | 27.185 | 27.195 | 23220.0 |
| 2016-09-14 06:45:00 | AAPL | Stock | 27.195 | 27.1975 | 27.1875 | 27.1875 | 20400.0 |
| 2016-09-14 06:50:00 | AAPL | Stock | 27.1975 | 27.1975 | 27.1925 | 27.1925 | 1952.0 |
| 2016-09-14 06:55:00 | AAPL | Stock | 27.1875 | 27.1875 | 27.125 | 27.1625 | 30964.0 |
| 2016-09-14 07:00:00 | AAPL | Stock | 27.125 | 27.15 | 27.115 | 27.1375 | 46728.0 |
| 2016-09-14 07:05:00 | AAPL | Stock | 27.1375 | 27.1375 | 27.125 | 27.125 | 9600.0 |
| 2016-09-14 07:10:00 | AAPL | Stock | 27.13 | 27.2 | 27.13 | 27.2 | 15076.0 |
| 2016-09-14 07:15:00 | AAPL | Stock | 27.2 | 27.225 | 27.2 | 27.2025 | 19960.0 |
| 2016-09-14 07:20:00 | AAPL | Stock | 27.2225 | 27.275 | 27.2225 | 27.2625 | 59400.0 |
| 2016-09-14 07:25:00 | AAPL | Stock | 27.25 | 27.255 | 27.2375 | 27.255 | 25000.0 |
| 2016-09-14 07:30:00 | AAPL | Stock | 27.2325 | 27.2325 | 27.2 | 27.2 | 18216.0 |
| 2016-09-14 07:35:00 | AAPL | Stock | 27.2125 | 27.215 | 27.1875 | 27.19 | 49984.0 |
| 2016-09-14 07:45:00 | AAPL | Stock | 27.2125 | 27.2125 | 27.21 | 27.2125 | 5800.0 |
| 2016-09-14 07:50:00 | AAPL | Stock | 27.21 | 27.2125 | 27.2 | 27.2 | 22960.0 |
| 2016-09-14 07:55:00 | AAPL | Stock | 27.2125 | 27.2375 | 27.2125 | 27.2375 | 15660.0 |
| 2016-09-14 08:00:00 | AAPL | Stock | 27.215 | 27.25 | 27.065 | 27.1725 | 652760.0 |
| 2016-09-14 08:05:00 | AAPL | Stock | 27.1625 | 27.22 | 27.1625 | 27.1875 | 105396.0 |
| 2016-09-14 08:10:00 | AAPL | Stock | 27.1875 | 27.2 | 27.1775 | 27.185 | 38464.0 |
| 2016-09-14 08:15:00 | AAPL | Stock | 27.185 | 27.1925 | 27.1825 | 27.1925 | 1896.0 |
| 2016-09-14 08:20:00 | AAPL | Stock | 27.1825 | 27.1875 | 27.1625 | 27.1625 | 14384.0 |
| 2016-09-14 08:25:00 | AAPL | Stock | 27.165 | 27.1875 | 27.165 | 27.1875 | 60740.0 |
| 2016-09-14 08:30:00 | AAPL | Stock | 27.1825 | 27.22 | 27.175 | 27.175 | 176472.0 |
| 2016-09-14 08:35:00 | AAPL | Stock | 27.19 | 27.2025 | 27.19 | 27.1975 | 18000.0 |
| 2016-09-14 08:40:00 | AAPL | Stock | 27.19 | 27.195 | 27.18 | 27.195 | 18628.0 |
| 2016-09-14 08:45:00 | AAPL | Stock | 27.195 | 27.195 | 27.1925 | 27.195 | 67456.0 |
| 2016-09-14 08:50:00 | AAPL | Stock | 27.195 | 27.195 | 27.17 | 27.185 | 54216.0 |
| 2016-09-14 08:55:00 | AAPL | Stock | 27.165 | 27.1775 | 27.16 | 27.17 | 38948.0 |
| 2016-09-14 09:00:00 | AAPL | Stock | 27.1625 | 27.175 | 27.13 | 27.1375 | 68836.0 |
| 2016-09-14 09:05:00 | AAPL | Stock | 27.135 | 27.1625 | 27.12 | 27.15 | 125848.0 |
| 2016-09-14 09:10:00 | AAPL | Stock | 27.15 | 27.17 | 27.1375 | 27.15 | 186228.0 |
| 2016-09-14 09:15:00 | AAPL | Stock | 27.17 | 27.2 | 27.1375 | 27.1375 | 56852.0 |
> showing 50 of 356,173 rows — these rows as CSV