PREVIEW / stock_5min / 2019-01-29
file: by_date/stock_5min/2019/2019-01-29.parquet size: 5.5 MB rows: 349,060 symbols: 2,696
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 |
|---|---|---|---|---|---|---|---|
| 2019-01-29 04:00:00 | AAPL | Stock | 38.9125 | 39.0 | 38.9125 | 39.0 | 2000.0 |
| 2019-01-29 04:05:00 | AAPL | Stock | 39.0125 | 39.0125 | 39.0125 | 39.0125 | 400.0 |
| 2019-01-29 04:10:00 | AAPL | Stock | 39.0425 | 39.0425 | 39.0425 | 39.0425 | 816.0 |
| 2019-01-29 04:20:00 | AAPL | Stock | 39.04 | 39.05 | 39.04 | 39.05 | 1028.0 |
| 2019-01-29 04:50:00 | AAPL | Stock | 39.055 | 39.055 | 39.0525 | 39.055 | 2652.0 |
| 2019-01-29 05:20:00 | AAPL | Stock | 39.1 | 39.125 | 39.1 | 39.1 | 1728.0 |
| 2019-01-29 05:30:00 | AAPL | Stock | 39.12 | 39.12 | 39.12 | 39.12 | 1320.0 |
| 2019-01-29 05:35:00 | AAPL | Stock | 39.105 | 39.105 | 39.0875 | 39.0875 | 1100.0 |
| 2019-01-29 05:50:00 | AAPL | Stock | 39.125 | 39.125 | 39.125 | 39.125 | 3680.0 |
| 2019-01-29 06:20:00 | AAPL | Stock | 39.055 | 39.055 | 39.055 | 39.055 | 400.0 |
| 2019-01-29 06:25:00 | AAPL | Stock | 39.0275 | 39.0275 | 39.0275 | 39.0275 | 400.0 |
| 2019-01-29 06:35:00 | AAPL | Stock | 39.0275 | 39.0275 | 39.0275 | 39.0275 | 1964.0 |
| 2019-01-29 06:45:00 | AAPL | Stock | 39.0375 | 39.075 | 39.0375 | 39.075 | 2264.0 |
| 2019-01-29 06:50:00 | AAPL | Stock | 39.075 | 39.075 | 39.075 | 39.075 | 2272.0 |
| 2019-01-29 06:55:00 | AAPL | Stock | 39.075 | 39.075 | 39.075 | 39.075 | 8192.0 |
| 2019-01-29 07:00:00 | AAPL | Stock | 39.04 | 39.0875 | 39.0375 | 39.08 | 4140.0 |
| 2019-01-29 07:05:00 | AAPL | Stock | 39.075 | 39.08 | 39.0725 | 39.075 | 5108.0 |
| 2019-01-29 07:10:00 | AAPL | Stock | 39.0875 | 39.0875 | 39.0575 | 39.0575 | 3112.0 |
| 2019-01-29 07:15:00 | AAPL | Stock | 39.0575 | 39.0575 | 39.0525 | 39.0525 | 948.0 |
| 2019-01-29 07:20:00 | AAPL | Stock | 39.0575 | 39.0575 | 39.0225 | 39.045 | 29456.0 |
| 2019-01-29 07:25:00 | AAPL | Stock | 39.0225 | 39.0375 | 39.0225 | 39.035 | 4896.0 |
| 2019-01-29 07:30:00 | AAPL | Stock | 39.0325 | 39.05 | 39.0325 | 39.05 | 6452.0 |
| 2019-01-29 07:35:00 | AAPL | Stock | 39.07 | 39.1 | 39.07 | 39.1 | 26940.0 |
| 2019-01-29 07:40:00 | AAPL | Stock | 39.11 | 39.1125 | 39.1 | 39.1 | 6628.0 |
| 2019-01-29 07:45:00 | AAPL | Stock | 39.115 | 39.1575 | 39.1 | 39.1475 | 12820.0 |
| 2019-01-29 07:50:00 | AAPL | Stock | 39.155 | 39.1625 | 39.135 | 39.14 | 7544.0 |
| 2019-01-29 07:55:00 | AAPL | Stock | 39.145 | 39.16 | 39.12 | 39.12 | 15424.0 |
| 2019-01-29 08:00:00 | AAPL | Stock | 39.1 | 39.1725 | 39.025 | 39.1425 | 137840.0 |
| 2019-01-29 08:05:00 | AAPL | Stock | 39.125 | 39.1475 | 39.1175 | 39.1475 | 18420.0 |
| 2019-01-29 08:10:00 | AAPL | Stock | 39.135 | 39.15 | 39.125 | 39.125 | 21428.0 |
| 2019-01-29 08:15:00 | AAPL | Stock | 39.1275 | 39.1375 | 39.125 | 39.1375 | 9996.0 |
| 2019-01-29 08:20:00 | AAPL | Stock | 39.15 | 39.17 | 39.125 | 39.17 | 19296.0 |
| 2019-01-29 08:25:00 | AAPL | Stock | 39.1575 | 39.165 | 39.15 | 39.15 | 21576.0 |
| 2019-01-29 08:30:00 | AAPL | Stock | 39.16 | 39.175 | 39.125 | 39.1475 | 25536.0 |
| 2019-01-29 08:35:00 | AAPL | Stock | 39.1475 | 39.1475 | 39.125 | 39.145 | 16788.0 |
| 2019-01-29 08:40:00 | AAPL | Stock | 39.145 | 39.1475 | 39.125 | 39.1475 | 25788.0 |
| 2019-01-29 08:45:00 | AAPL | Stock | 39.1475 | 39.175 | 39.13 | 39.175 | 12696.0 |
| 2019-01-29 08:50:00 | AAPL | Stock | 39.15 | 39.1625 | 39.14 | 39.1425 | 19216.0 |
| 2019-01-29 08:55:00 | AAPL | Stock | 39.1375 | 39.16 | 39.1125 | 39.1275 | 30932.0 |
| 2019-01-29 09:00:00 | AAPL | Stock | 39.125 | 39.16 | 39.125 | 39.125 | 22156.0 |
| 2019-01-29 09:05:00 | AAPL | Stock | 39.125 | 39.15 | 39.0902 | 39.1125 | 62732.0 |
| 2019-01-29 09:10:00 | AAPL | Stock | 39.09 | 39.125 | 39.09 | 39.125 | 24804.0 |
| 2019-01-29 09:15:00 | AAPL | Stock | 39.1325 | 39.1375 | 39.1125 | 39.12 | 19604.0 |
| 2019-01-29 09:20:00 | AAPL | Stock | 39.115 | 39.115 | 39.075 | 39.1 | 30536.0 |
| 2019-01-29 09:25:00 | AAPL | Stock | 39.0875 | 39.1098 | 39.055 | 39.055 | 26576.0 |
| 2019-01-29 09:30:00 | AAPL | Stock | 39.0625 | 39.25 | 38.975 | 39.2178 | 4216184.0 |
| 2019-01-29 09:35:00 | AAPL | Stock | 39.2225 | 39.2575 | 39.16 | 39.1728 | 2042752.0 |
| 2019-01-29 09:40:00 | AAPL | Stock | 39.1748 | 39.2875 | 39.14 | 39.26 | 2149340.0 |
| 2019-01-29 09:45:00 | AAPL | Stock | 39.2625 | 39.5325 | 39.2275 | 39.5112 | 3532324.0 |
| 2019-01-29 09:50:00 | AAPL | Stock | 39.5085 | 39.515 | 39.335 | 39.3525 | 2158092.0 |
> showing 50 of 349,060 rows — these rows as CSV