PREVIEW / stock_5min / 2016-08-11
file: by_date/stock_5min/2016/2016-08-11.parquet size: 5.3 MB rows: 349,118 symbols: 3,263
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-08-11 06:30:00 | AAPL | Stock | 27.055 | 27.055 | 27.055 | 27.055 | 2800.0 |
| 2016-08-11 06:35:00 | AAPL | Stock | 27.04 | 27.055 | 27.04 | 27.055 | 2400.0 |
| 2016-08-11 06:40:00 | AAPL | Stock | 27.055 | 27.0725 | 27.055 | 27.0725 | 5648.0 |
| 2016-08-11 06:45:00 | AAPL | Stock | 27.07 | 27.0725 | 27.0675 | 27.0725 | 2800.0 |
| 2016-08-11 06:50:00 | AAPL | Stock | 27.05 | 27.05 | 27.035 | 27.035 | 7344.0 |
| 2016-08-11 06:55:00 | AAPL | Stock | 27.035 | 27.035 | 27.035 | 27.035 | 4400.0 |
| 2016-08-11 07:00:00 | AAPL | Stock | 27.05 | 27.05 | 27.05 | 27.05 | 9200.0 |
| 2016-08-11 07:05:00 | AAPL | Stock | 27.055 | 27.055 | 27.055 | 27.055 | 600.0 |
| 2016-08-11 07:10:00 | AAPL | Stock | 27.0625 | 27.0625 | 27.05 | 27.05 | 8160.0 |
| 2016-08-11 07:15:00 | AAPL | Stock | 27.05 | 27.0625 | 27.05 | 27.0625 | 19532.0 |
| 2016-08-11 07:20:00 | AAPL | Stock | 27.05 | 27.05 | 27.035 | 27.035 | 13100.0 |
| 2016-08-11 07:25:00 | AAPL | Stock | 27.0325 | 27.06 | 27.0275 | 27.05 | 26772.0 |
| 2016-08-11 07:40:00 | AAPL | Stock | 27.0575 | 27.0675 | 27.05 | 27.0675 | 27412.0 |
| 2016-08-11 07:45:00 | AAPL | Stock | 27.0625 | 27.0625 | 27.0625 | 27.0625 | 4000.0 |
| 2016-08-11 07:50:00 | AAPL | Stock | 27.07 | 27.0975 | 27.07 | 27.0975 | 8848.0 |
| 2016-08-11 08:00:00 | AAPL | Stock | 27.0725 | 27.0725 | 27.05 | 27.065 | 50116.0 |
| 2016-08-11 08:05:00 | AAPL | Stock | 27.075 | 27.075 | 27.0625 | 27.0625 | 32004.0 |
| 2016-08-11 08:10:00 | AAPL | Stock | 27.0525 | 27.0625 | 27.0525 | 27.0625 | 3080.0 |
| 2016-08-11 08:15:00 | AAPL | Stock | 27.07 | 27.1 | 27.0625 | 27.0775 | 35148.0 |
| 2016-08-11 08:20:00 | AAPL | Stock | 27.0875 | 27.0875 | 27.0875 | 27.0875 | 10172.0 |
| 2016-08-11 08:25:00 | AAPL | Stock | 27.085 | 27.085 | 27.075 | 27.075 | 9080.0 |
| 2016-08-11 08:30:00 | AAPL | Stock | 27.085 | 27.1 | 27.085 | 27.09 | 11460.0 |
| 2016-08-11 08:35:00 | AAPL | Stock | 27.09 | 27.09 | 27.085 | 27.085 | 17804.0 |
| 2016-08-11 08:40:00 | AAPL | Stock | 27.0875 | 27.0875 | 27.0825 | 27.0825 | 14752.0 |
| 2016-08-11 08:45:00 | AAPL | Stock | 27.0875 | 27.0975 | 27.085 | 27.0975 | 22284.0 |
| 2016-08-11 08:50:00 | AAPL | Stock | 27.1 | 27.1 | 27.0875 | 27.0875 | 24424.0 |
| 2016-08-11 08:55:00 | AAPL | Stock | 27.0875 | 27.095 | 27.0875 | 27.095 | 9200.0 |
| 2016-08-11 09:00:00 | AAPL | Stock | 27.0875 | 27.0875 | 27.075 | 27.08 | 11740.0 |
| 2016-08-11 09:05:00 | AAPL | Stock | 27.085 | 27.0925 | 27.0775 | 27.0925 | 18164.0 |
| 2016-08-11 09:10:00 | AAPL | Stock | 27.0875 | 27.0875 | 27.0875 | 27.0875 | 6000.0 |
| 2016-08-11 09:15:00 | AAPL | Stock | 27.095 | 27.1 | 27.0875 | 27.1 | 22200.0 |
| 2016-08-11 09:20:00 | AAPL | Stock | 27.095 | 27.1 | 27.09 | 27.09 | 7200.0 |
| 2016-08-11 09:25:00 | AAPL | Stock | 27.0875 | 27.155 | 27.0875 | 27.1325 | 33100.0 |
| 2016-08-11 09:30:00 | AAPL | Stock | 27.1375 | 27.1975 | 27.1275 | 27.155 | 5980088.0 |
| 2016-08-11 09:35:00 | AAPL | Stock | 27.155 | 27.2325 | 27.155 | 27.2138 | 3641404.0 |
| 2016-08-11 09:40:00 | AAPL | Stock | 27.2148 | 27.2325 | 27.2 | 27.2125 | 2377936.0 |
| 2016-08-11 09:45:00 | AAPL | Stock | 27.2125 | 27.2312 | 27.1898 | 27.1925 | 1398728.0 |
| 2016-08-11 09:50:00 | AAPL | Stock | 27.195 | 27.215 | 27.1725 | 27.1925 | 1708416.0 |
| 2016-08-11 09:55:00 | AAPL | Stock | 27.1925 | 27.194 | 27.135 | 27.14 | 1380904.0 |
| 2016-08-11 10:00:00 | AAPL | Stock | 27.14 | 27.16 | 27.0975 | 27.1015 | 2389144.0 |
| 2016-08-11 10:05:00 | AAPL | Stock | 27.1 | 27.1025 | 27.0325 | 27.0525 | 2383448.0 |
| 2016-08-11 10:10:00 | AAPL | Stock | 27.0525 | 27.065 | 27.0275 | 27.0475 | 1513704.0 |
| 2016-08-11 10:15:00 | AAPL | Stock | 27.05 | 27.092 | 27.045 | 27.0825 | 1827164.0 |
| 2016-08-11 10:20:00 | AAPL | Stock | 27.085 | 27.11 | 27.075 | 27.0985 | 1545516.0 |
| 2016-08-11 10:25:00 | AAPL | Stock | 27.0988 | 27.1175 | 27.0925 | 27.11 | 745452.0 |
| 2016-08-11 10:30:00 | AAPL | Stock | 27.11 | 27.1375 | 27.11 | 27.1222 | 997592.0 |
| 2016-08-11 10:35:00 | AAPL | Stock | 27.12 | 27.159 | 27.12 | 27.1515 | 1313644.0 |
| 2016-08-11 10:40:00 | AAPL | Stock | 27.1518 | 27.16 | 27.1375 | 27.1525 | 926128.0 |
| 2016-08-11 10:45:00 | AAPL | Stock | 27.15 | 27.1515 | 27.115 | 27.1278 | 1286808.0 |
| 2016-08-11 10:50:00 | AAPL | Stock | 27.1285 | 27.1312 | 27.0825 | 27.0825 | 969020.0 |
> showing 50 of 349,118 rows — these rows as CSV