PREVIEW / stock_5min / 2016-12-22
file: by_date/stock_5min/2016/2016-12-22.parquet size: 5.3 MB rows: 350,169 symbols: 3,164
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-22 04:00:00 | AAPL | Stock | 29.0 | 29.05 | 29.0 | 29.05 | 2200.0 |
| 2016-12-22 04:15:00 | AAPL | Stock | 29.07 | 29.07 | 29.07 | 29.07 | 1872.0 |
| 2016-12-22 04:30:00 | AAPL | Stock | 29.0875 | 29.0875 | 29.0875 | 29.0875 | 400.0 |
| 2016-12-22 04:40:00 | AAPL | Stock | 29.0875 | 29.0875 | 29.0875 | 29.0875 | 400.0 |
| 2016-12-22 04:45:00 | AAPL | Stock | 29.0875 | 29.0875 | 29.0875 | 29.0875 | 1200.0 |
| 2016-12-22 04:50:00 | AAPL | Stock | 29.085 | 29.085 | 29.085 | 29.085 | 400.0 |
| 2016-12-22 04:55:00 | AAPL | Stock | 29.01 | 29.01 | 29.01 | 29.01 | 1832.0 |
| 2016-12-22 05:05:00 | AAPL | Stock | 29.025 | 29.045 | 29.025 | 29.045 | 2648.0 |
| 2016-12-22 05:10:00 | AAPL | Stock | 29.0525 | 29.0525 | 29.0525 | 29.0525 | 400.0 |
| 2016-12-22 05:15:00 | AAPL | Stock | 29.025 | 29.025 | 29.0125 | 29.0125 | 1608.0 |
| 2016-12-22 05:20:00 | AAPL | Stock | 29.01 | 29.01 | 29.01 | 29.01 | 3600.0 |
| 2016-12-22 05:40:00 | AAPL | Stock | 29.025 | 29.025 | 29.025 | 29.025 | 1464.0 |
| 2016-12-22 05:45:00 | AAPL | Stock | 29.075 | 29.09 | 29.055 | 29.055 | 8000.0 |
| 2016-12-22 05:50:00 | AAPL | Stock | 29.025 | 29.025 | 29.025 | 29.025 | 800.0 |
| 2016-12-22 05:55:00 | AAPL | Stock | 29.0875 | 29.0875 | 29.0875 | 29.0875 | 400.0 |
| 2016-12-22 06:05:00 | AAPL | Stock | 29.1 | 29.1 | 29.1 | 29.1 | 400.0 |
| 2016-12-22 06:10:00 | AAPL | Stock | 29.1 | 29.1 | 29.1 | 29.1 | 1600.0 |
| 2016-12-22 06:35:00 | AAPL | Stock | 29.1225 | 29.1225 | 29.1225 | 29.1225 | 1200.0 |
| 2016-12-22 06:45:00 | AAPL | Stock | 29.105 | 29.105 | 29.105 | 29.105 | 588.0 |
| 2016-12-22 06:50:00 | AAPL | Stock | 29.0925 | 29.0925 | 29.08 | 29.08 | 2924.0 |
| 2016-12-22 06:55:00 | AAPL | Stock | 29.1 | 29.105 | 29.1 | 29.105 | 9472.0 |
| 2016-12-22 07:00:00 | AAPL | Stock | 29.1225 | 29.1225 | 29.1225 | 29.1225 | 2000.0 |
| 2016-12-22 07:05:00 | AAPL | Stock | 29.125 | 29.125 | 29.125 | 29.125 | 400.0 |
| 2016-12-22 07:10:00 | AAPL | Stock | 29.17 | 29.17 | 29.17 | 29.17 | 400.0 |
| 2016-12-22 07:15:00 | AAPL | Stock | 29.1325 | 29.1325 | 29.125 | 29.125 | 3116.0 |
| 2016-12-22 07:20:00 | AAPL | Stock | 29.1375 | 29.15 | 29.115 | 29.15 | 2340.0 |
| 2016-12-22 07:25:00 | AAPL | Stock | 29.155 | 29.155 | 29.1375 | 29.1375 | 3556.0 |
| 2016-12-22 07:30:00 | AAPL | Stock | 29.14 | 29.14 | 29.12 | 29.12 | 5388.0 |
| 2016-12-22 07:40:00 | AAPL | Stock | 29.125 | 29.125 | 29.125 | 29.125 | 1000.0 |
| 2016-12-22 07:45:00 | AAPL | Stock | 29.1225 | 29.1375 | 29.1225 | 29.1375 | 1600.0 |
| 2016-12-22 07:50:00 | AAPL | Stock | 29.145 | 29.145 | 29.145 | 29.145 | 672.0 |
| 2016-12-22 07:55:00 | AAPL | Stock | 29.1675 | 29.1675 | 29.1625 | 29.1625 | 800.0 |
| 2016-12-22 08:00:00 | AAPL | Stock | 29.1225 | 29.2 | 29.115 | 29.1925 | 55560.0 |
| 2016-12-22 08:05:00 | AAPL | Stock | 29.1925 | 29.1975 | 29.1875 | 29.1975 | 3304.0 |
| 2016-12-22 08:10:00 | AAPL | Stock | 29.2025 | 29.2125 | 29.2 | 29.2125 | 10324.0 |
| 2016-12-22 08:15:00 | AAPL | Stock | 29.2225 | 29.2225 | 29.2125 | 29.2125 | 3076.0 |
| 2016-12-22 08:20:00 | AAPL | Stock | 29.22 | 29.225 | 29.2 | 29.2 | 11348.0 |
| 2016-12-22 08:25:00 | AAPL | Stock | 29.2225 | 29.225 | 29.215 | 29.225 | 5872.0 |
| 2016-12-22 08:30:00 | AAPL | Stock | 29.225 | 29.2425 | 29.2225 | 29.2225 | 7960.0 |
| 2016-12-22 08:35:00 | AAPL | Stock | 29.225 | 29.225 | 29.2125 | 29.2125 | 4280.0 |
| 2016-12-22 08:40:00 | AAPL | Stock | 29.225 | 29.265 | 29.225 | 29.25 | 29756.0 |
| 2016-12-22 08:45:00 | AAPL | Stock | 29.25 | 29.2575 | 29.25 | 29.2575 | 4616.0 |
| 2016-12-22 08:50:00 | AAPL | Stock | 29.2425 | 29.2425 | 29.2425 | 29.2425 | 400.0 |
| 2016-12-22 08:55:00 | AAPL | Stock | 29.235 | 29.235 | 29.2125 | 29.2125 | 16532.0 |
| 2016-12-22 09:00:00 | AAPL | Stock | 29.215 | 29.2225 | 29.215 | 29.2225 | 9600.0 |
| 2016-12-22 09:05:00 | AAPL | Stock | 29.2225 | 29.235 | 29.2225 | 29.235 | 8000.0 |
| 2016-12-22 09:10:00 | AAPL | Stock | 29.2325 | 29.2325 | 29.215 | 29.215 | 18312.0 |
| 2016-12-22 09:15:00 | AAPL | Stock | 29.2275 | 29.23 | 29.2275 | 29.2275 | 4060.0 |
| 2016-12-22 09:20:00 | AAPL | Stock | 29.2175 | 29.2175 | 29.2075 | 29.2075 | 5876.0 |
| 2016-12-22 09:25:00 | AAPL | Stock | 29.205 | 29.215 | 29.0875 | 29.09 | 277000.0 |
> showing 50 of 350,169 rows — these rows as CSV