PREVIEW / stock_5min / 2017-09-22
file: by_date/stock_5min/2017/2017-09-22.parquet size: 5.2 MB rows: 340,708 symbols: 2,958
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 |
|---|---|---|---|---|---|---|---|
| 2017-09-22 04:00:00 | AAPL | Stock | 38.3125 | 38.325 | 38.3125 | 38.325 | 5600.0 |
| 2017-09-22 04:05:00 | AAPL | Stock | 38.305 | 38.305 | 38.275 | 38.305 | 3792.0 |
| 2017-09-22 04:10:00 | AAPL | Stock | 38.3 | 38.3 | 38.3 | 38.3 | 400.0 |
| 2017-09-22 04:20:00 | AAPL | Stock | 38.3 | 38.3075 | 38.3 | 38.3075 | 3284.0 |
| 2017-09-22 04:30:00 | AAPL | Stock | 38.275 | 38.275 | 38.275 | 38.275 | 1068.0 |
| 2017-09-22 04:45:00 | AAPL | Stock | 38.3075 | 38.3075 | 38.255 | 38.3075 | 5072.0 |
| 2017-09-22 05:00:00 | AAPL | Stock | 38.255 | 38.255 | 38.25 | 38.25 | 9036.0 |
| 2017-09-22 05:05:00 | AAPL | Stock | 38.25 | 38.25 | 38.25 | 38.25 | 2916.0 |
| 2017-09-22 05:10:00 | AAPL | Stock | 38.225 | 38.25 | 38.225 | 38.25 | 800.0 |
| 2017-09-22 05:15:00 | AAPL | Stock | 38.205 | 38.205 | 38.205 | 38.205 | 4000.0 |
| 2017-09-22 05:20:00 | AAPL | Stock | 38.165 | 38.165 | 38.12 | 38.1275 | 4400.0 |
| 2017-09-22 05:25:00 | AAPL | Stock | 38.1275 | 38.1275 | 38.1275 | 38.1275 | 400.0 |
| 2017-09-22 05:30:00 | AAPL | Stock | 38.075 | 38.075 | 38.0375 | 38.0375 | 6856.0 |
| 2017-09-22 05:35:00 | AAPL | Stock | 38.0975 | 38.0975 | 38.0375 | 38.05 | 11000.0 |
| 2017-09-22 05:40:00 | AAPL | Stock | 38.1 | 38.1275 | 38.1 | 38.1125 | 12520.0 |
| 2017-09-22 05:45:00 | AAPL | Stock | 38.1025 | 38.1025 | 38.1025 | 38.1025 | 768.0 |
| 2017-09-22 05:50:00 | AAPL | Stock | 38.1125 | 38.1125 | 38.0875 | 38.1 | 13576.0 |
| 2017-09-22 05:55:00 | AAPL | Stock | 38.135 | 38.135 | 38.135 | 38.135 | 400.0 |
| 2017-09-22 06:00:00 | AAPL | Stock | 38.1 | 38.1 | 38.08 | 38.08 | 3428.0 |
| 2017-09-22 06:05:00 | AAPL | Stock | 38.125 | 38.13 | 38.1 | 38.125 | 6200.0 |
| 2017-09-22 06:10:00 | AAPL | Stock | 38.1 | 38.1 | 38.1 | 38.1 | 472.0 |
| 2017-09-22 06:15:00 | AAPL | Stock | 38.0675 | 38.0675 | 38.0625 | 38.0625 | 1036.0 |
| 2017-09-22 06:25:00 | AAPL | Stock | 38.14 | 38.1425 | 38.125 | 38.135 | 3144.0 |
| 2017-09-22 06:40:00 | AAPL | Stock | 38.1 | 38.1 | 38.1 | 38.1 | 400.0 |
| 2017-09-22 06:45:00 | AAPL | Stock | 38.1425 | 38.1425 | 38.1375 | 38.1375 | 2708.0 |
| 2017-09-22 06:50:00 | AAPL | Stock | 38.155 | 38.1625 | 38.1075 | 38.1075 | 12080.0 |
| 2017-09-22 06:55:00 | AAPL | Stock | 38.1125 | 38.145 | 38.1 | 38.1 | 11332.0 |
| 2017-09-22 07:00:00 | AAPL | Stock | 38.125 | 38.125 | 38.0875 | 38.125 | 42952.0 |
| 2017-09-22 07:05:00 | AAPL | Stock | 38.125 | 38.125 | 38.075 | 38.1 | 34060.0 |
| 2017-09-22 07:10:00 | AAPL | Stock | 38.1 | 38.1125 | 38.1 | 38.1125 | 5164.0 |
| 2017-09-22 07:15:00 | AAPL | Stock | 38.1125 | 38.1125 | 38.1 | 38.1 | 3000.0 |
| 2017-09-22 07:20:00 | AAPL | Stock | 38.1 | 38.125 | 38.095 | 38.125 | 41780.0 |
| 2017-09-22 07:25:00 | AAPL | Stock | 38.1125 | 38.1125 | 38.1 | 38.1 | 2860.0 |
| 2017-09-22 07:30:00 | AAPL | Stock | 38.1025 | 38.2 | 38.1025 | 38.15 | 107304.0 |
| 2017-09-22 07:35:00 | AAPL | Stock | 38.18 | 38.18 | 38.125 | 38.125 | 13380.0 |
| 2017-09-22 07:40:00 | AAPL | Stock | 38.125 | 38.1325 | 38.12 | 38.1275 | 22832.0 |
| 2017-09-22 07:45:00 | AAPL | Stock | 38.1325 | 38.1475 | 38.125 | 38.125 | 41520.0 |
| 2017-09-22 07:50:00 | AAPL | Stock | 38.1275 | 38.1825 | 38.125 | 38.1825 | 6420.0 |
| 2017-09-22 07:55:00 | AAPL | Stock | 38.165 | 38.17 | 38.1225 | 38.125 | 61952.0 |
| 2017-09-22 08:00:00 | AAPL | Stock | 38.1188 | 38.165 | 38.09 | 38.1 | 97188.0 |
| 2017-09-22 08:05:00 | AAPL | Stock | 38.1 | 38.1125 | 38.095 | 38.1 | 86764.0 |
| 2017-09-22 08:10:00 | AAPL | Stock | 38.095 | 38.1 | 38.075 | 38.0875 | 50156.0 |
| 2017-09-22 08:15:00 | AAPL | Stock | 38.0875 | 38.105 | 38.065 | 38.1 | 39388.0 |
| 2017-09-22 08:20:00 | AAPL | Stock | 38.1 | 38.1225 | 38.0825 | 38.0825 | 35380.0 |
| 2017-09-22 08:25:00 | AAPL | Stock | 38.0875 | 38.0875 | 38.07 | 38.0725 | 25760.0 |
| 2017-09-22 08:30:00 | AAPL | Stock | 38.08 | 38.1 | 38.0725 | 38.08 | 50128.0 |
| 2017-09-22 08:35:00 | AAPL | Stock | 38.0875 | 38.125 | 38.075 | 38.115 | 142564.0 |
| 2017-09-22 08:40:00 | AAPL | Stock | 38.115 | 38.14 | 38.11 | 38.1375 | 42928.0 |
| 2017-09-22 08:45:00 | AAPL | Stock | 38.15 | 38.2125 | 38.14 | 38.2125 | 83912.0 |
| 2017-09-22 08:50:00 | AAPL | Stock | 38.2125 | 38.2125 | 38.175 | 38.2125 | 52388.0 |
> showing 50 of 340,708 rows — these rows as CSV