PREVIEW / stock_5min / 2017-02-06
file: by_date/stock_5min/2017/2017-02-06.parquet size: 5.3 MB rows: 349,471 symbols: 3,106
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-02-06 04:05:00 | AAPL | Stock | 32.25 | 32.25 | 32.215 | 32.25 | 4468.0 |
| 2017-02-06 04:35:00 | AAPL | Stock | 32.2225 | 32.2225 | 32.2225 | 32.2225 | 1200.0 |
| 2017-02-06 05:05:00 | AAPL | Stock | 32.2375 | 32.2375 | 32.2375 | 32.2375 | 400.0 |
| 2017-02-06 05:30:00 | AAPL | Stock | 32.2375 | 32.2375 | 32.2275 | 32.2275 | 3200.0 |
| 2017-02-06 05:35:00 | AAPL | Stock | 32.2375 | 32.2375 | 32.2375 | 32.2375 | 13416.0 |
| 2017-02-06 05:40:00 | AAPL | Stock | 32.275 | 32.275 | 32.275 | 32.275 | 400.0 |
| 2017-02-06 06:05:00 | AAPL | Stock | 32.295 | 32.2975 | 32.295 | 32.2975 | 4000.0 |
| 2017-02-06 06:20:00 | AAPL | Stock | 32.2575 | 32.2575 | 32.2475 | 32.2475 | 13980.0 |
| 2017-02-06 06:25:00 | AAPL | Stock | 32.2475 | 32.2475 | 32.2475 | 32.2475 | 400.0 |
| 2017-02-06 06:30:00 | AAPL | Stock | 32.26 | 32.27 | 32.235 | 32.235 | 4200.0 |
| 2017-02-06 06:40:00 | AAPL | Stock | 32.23 | 32.23 | 32.23 | 32.23 | 400.0 |
| 2017-02-06 06:50:00 | AAPL | Stock | 32.225 | 32.25 | 32.225 | 32.25 | 5520.0 |
| 2017-02-06 07:00:00 | AAPL | Stock | 32.25 | 32.25 | 32.25 | 32.25 | 1796.0 |
| 2017-02-06 07:05:00 | AAPL | Stock | 32.25 | 32.25 | 32.25 | 32.25 | 10412.0 |
| 2017-02-06 07:15:00 | AAPL | Stock | 32.25 | 32.26 | 32.25 | 32.26 | 5416.0 |
| 2017-02-06 07:20:00 | AAPL | Stock | 32.2625 | 32.2625 | 32.2525 | 32.2525 | 5480.0 |
| 2017-02-06 07:25:00 | AAPL | Stock | 32.2425 | 32.2425 | 32.235 | 32.235 | 8780.0 |
| 2017-02-06 07:30:00 | AAPL | Stock | 32.23 | 32.25 | 32.23 | 32.25 | 4868.0 |
| 2017-02-06 07:40:00 | AAPL | Stock | 32.2425 | 32.2425 | 32.23 | 32.23 | 1172.0 |
| 2017-02-06 07:45:00 | AAPL | Stock | 32.24 | 32.24 | 32.23 | 32.23 | 2372.0 |
| 2017-02-06 07:50:00 | AAPL | Stock | 32.23 | 32.23 | 32.2275 | 32.2275 | 2000.0 |
| 2017-02-06 07:55:00 | AAPL | Stock | 32.23 | 32.23 | 32.2125 | 32.2125 | 14968.0 |
| 2017-02-06 08:00:00 | AAPL | Stock | 32.225 | 32.25 | 32.1875 | 32.2125 | 76244.0 |
| 2017-02-06 08:05:00 | AAPL | Stock | 32.2 | 32.2 | 32.2 | 32.2 | 400.0 |
| 2017-02-06 08:10:00 | AAPL | Stock | 32.2 | 32.205 | 32.1925 | 32.205 | 7300.0 |
| 2017-02-06 08:15:00 | AAPL | Stock | 32.205 | 32.2075 | 32.1875 | 32.1875 | 28200.0 |
| 2017-02-06 08:20:00 | AAPL | Stock | 32.1975 | 32.2025 | 32.185 | 32.195 | 15200.0 |
| 2017-02-06 08:25:00 | AAPL | Stock | 32.2075 | 32.2075 | 32.2075 | 32.2075 | 1400.0 |
| 2017-02-06 08:30:00 | AAPL | Stock | 32.2 | 32.2025 | 32.1775 | 32.1775 | 18256.0 |
| 2017-02-06 08:35:00 | AAPL | Stock | 32.1875 | 32.195 | 32.18 | 32.18 | 6800.0 |
| 2017-02-06 08:40:00 | AAPL | Stock | 32.195 | 32.2 | 32.185 | 32.195 | 5812.0 |
| 2017-02-06 08:45:00 | AAPL | Stock | 32.2 | 32.205 | 32.2 | 32.205 | 13936.0 |
| 2017-02-06 08:50:00 | AAPL | Stock | 32.2125 | 32.2125 | 32.1975 | 32.2 | 19512.0 |
| 2017-02-06 08:55:00 | AAPL | Stock | 32.195 | 32.2 | 32.195 | 32.1975 | 16804.0 |
| 2017-02-06 09:00:00 | AAPL | Stock | 32.2 | 32.21 | 32.2 | 32.2075 | 9868.0 |
| 2017-02-06 09:05:00 | AAPL | Stock | 32.2075 | 32.21 | 32.2 | 32.2 | 29516.0 |
| 2017-02-06 09:10:00 | AAPL | Stock | 32.19 | 32.2 | 32.1875 | 32.1975 | 22548.0 |
| 2017-02-06 09:15:00 | AAPL | Stock | 32.1925 | 32.205 | 32.1925 | 32.205 | 5692.0 |
| 2017-02-06 09:20:00 | AAPL | Stock | 32.195 | 32.2075 | 32.1675 | 32.2075 | 40188.0 |
| 2017-02-06 09:25:00 | AAPL | Stock | 32.205 | 32.25 | 32.2025 | 32.25 | 84664.0 |
| 2017-02-06 09:30:00 | AAPL | Stock | 32.2825 | 32.415 | 32.23 | 32.4 | 6433856.0 |
| 2017-02-06 09:35:00 | AAPL | Stock | 32.3975 | 32.41 | 32.3325 | 32.4088 | 1875656.0 |
| 2017-02-06 09:40:00 | AAPL | Stock | 32.4075 | 32.4475 | 32.38 | 32.4462 | 2135896.0 |
| 2017-02-06 09:45:00 | AAPL | Stock | 32.445 | 32.4688 | 32.4375 | 32.459 | 2108104.0 |
| 2017-02-06 09:50:00 | AAPL | Stock | 32.4585 | 32.4975 | 32.4475 | 32.4925 | 2203672.0 |
| 2017-02-06 09:55:00 | AAPL | Stock | 32.4925 | 32.53 | 32.47 | 32.5275 | 4759540.0 |
| 2017-02-06 10:00:00 | AAPL | Stock | 32.53 | 32.57 | 32.515 | 32.5365 | 2920556.0 |
| 2017-02-06 10:05:00 | AAPL | Stock | 32.5375 | 32.5675 | 32.525 | 32.5312 | 1729992.0 |
| 2017-02-06 10:10:00 | AAPL | Stock | 32.5325 | 32.57 | 32.495 | 32.5675 | 2481596.0 |
| 2017-02-06 10:15:00 | AAPL | Stock | 32.57 | 32.615 | 32.5675 | 32.5875 | 2481468.0 |
> showing 50 of 349,471 rows — these rows as CSV