PREVIEW / stock_5min / 2016-11-04
file: by_date/stock_5min/2016/2016-11-04.parquet size: 5.3 MB rows: 347,594 symbols: 3,176
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-11-04 04:00:00 | AAPL | Stock | 27.4575 | 27.5025 | 27.4575 | 27.5025 | 3732.0 |
| 2016-11-04 04:25:00 | AAPL | Stock | 27.4575 | 27.4575 | 27.4575 | 27.4575 | 1200.0 |
| 2016-11-04 04:55:00 | AAPL | Stock | 27.415 | 27.415 | 27.415 | 27.415 | 1200.0 |
| 2016-11-04 05:05:00 | AAPL | Stock | 27.4175 | 27.4175 | 27.415 | 27.415 | 1592.0 |
| 2016-11-04 05:15:00 | AAPL | Stock | 27.395 | 27.395 | 27.395 | 27.395 | 2020.0 |
| 2016-11-04 05:20:00 | AAPL | Stock | 27.395 | 27.395 | 27.395 | 27.395 | 1988.0 |
| 2016-11-04 05:35:00 | AAPL | Stock | 27.395 | 27.395 | 27.395 | 27.395 | 400.0 |
| 2016-11-04 05:50:00 | AAPL | Stock | 27.35 | 27.35 | 27.35 | 27.35 | 880.0 |
| 2016-11-04 05:55:00 | AAPL | Stock | 27.325 | 27.325 | 27.325 | 27.325 | 400.0 |
| 2016-11-04 06:10:00 | AAPL | Stock | 27.35 | 27.35 | 27.35 | 27.35 | 1600.0 |
| 2016-11-04 06:40:00 | AAPL | Stock | 27.325 | 27.325 | 27.325 | 27.325 | 400.0 |
| 2016-11-04 06:50:00 | AAPL | Stock | 27.35 | 27.35 | 27.35 | 27.35 | 6428.0 |
| 2016-11-04 06:55:00 | AAPL | Stock | 27.35 | 27.375 | 27.35 | 27.375 | 3948.0 |
| 2016-11-04 07:15:00 | AAPL | Stock | 27.37 | 27.4 | 27.37 | 27.4 | 3692.0 |
| 2016-11-04 07:20:00 | AAPL | Stock | 27.375 | 27.375 | 27.375 | 27.375 | 1400.0 |
| 2016-11-04 07:25:00 | AAPL | Stock | 27.375 | 27.375 | 27.375 | 27.375 | 1060.0 |
| 2016-11-04 07:35:00 | AAPL | Stock | 27.3925 | 27.3925 | 27.3925 | 27.3925 | 2972.0 |
| 2016-11-04 07:45:00 | AAPL | Stock | 27.3925 | 27.4 | 27.3925 | 27.3925 | 7548.0 |
| 2016-11-04 07:50:00 | AAPL | Stock | 27.3925 | 27.3925 | 27.39 | 27.39 | 4116.0 |
| 2016-11-04 07:55:00 | AAPL | Stock | 27.405 | 27.4075 | 27.405 | 27.4075 | 1160.0 |
| 2016-11-04 08:00:00 | AAPL | Stock | 27.395 | 27.395 | 27.3525 | 27.365 | 21628.0 |
| 2016-11-04 08:05:00 | AAPL | Stock | 27.365 | 27.365 | 27.35 | 27.35 | 11324.0 |
| 2016-11-04 08:10:00 | AAPL | Stock | 27.33 | 27.365 | 27.33 | 27.365 | 14312.0 |
| 2016-11-04 08:15:00 | AAPL | Stock | 27.35 | 27.3725 | 27.35 | 27.3725 | 28284.0 |
| 2016-11-04 08:20:00 | AAPL | Stock | 27.35 | 27.35 | 27.35 | 27.35 | 2000.0 |
| 2016-11-04 08:25:00 | AAPL | Stock | 27.3625 | 27.375 | 27.355 | 27.365 | 26012.0 |
| 2016-11-04 08:30:00 | AAPL | Stock | 27.375 | 27.4 | 27.375 | 27.4 | 20800.0 |
| 2016-11-04 08:35:00 | AAPL | Stock | 27.375 | 27.3875 | 27.365 | 27.365 | 7580.0 |
| 2016-11-04 08:40:00 | AAPL | Stock | 27.355 | 27.3875 | 27.34 | 27.385 | 24864.0 |
| 2016-11-04 08:45:00 | AAPL | Stock | 27.4 | 27.4475 | 27.3875 | 27.4425 | 23688.0 |
| 2016-11-04 08:50:00 | AAPL | Stock | 27.445 | 27.46 | 27.4125 | 27.4125 | 35448.0 |
| 2016-11-04 08:55:00 | AAPL | Stock | 27.435 | 27.435 | 27.435 | 27.435 | 800.0 |
| 2016-11-04 09:00:00 | AAPL | Stock | 27.4175 | 27.435 | 27.4175 | 27.4325 | 13600.0 |
| 2016-11-04 09:05:00 | AAPL | Stock | 27.4175 | 27.4175 | 27.4025 | 27.4025 | 10652.0 |
| 2016-11-04 09:10:00 | AAPL | Stock | 27.4 | 27.4125 | 27.3975 | 27.4125 | 7492.0 |
| 2016-11-04 09:15:00 | AAPL | Stock | 27.41 | 27.415 | 27.3925 | 27.3925 | 30760.0 |
| 2016-11-04 09:20:00 | AAPL | Stock | 27.4075 | 27.4125 | 27.365 | 27.365 | 27036.0 |
| 2016-11-04 09:25:00 | AAPL | Stock | 27.3675 | 27.4575 | 26.9275 | 27.075 | 2298096.0 |
| 2016-11-04 09:30:00 | AAPL | Stock | 27.1325 | 27.325 | 27.0275 | 27.2925 | 13768176.0 |
| 2016-11-04 09:35:00 | AAPL | Stock | 27.295 | 27.385 | 27.277 | 27.3212 | 3232696.0 |
| 2016-11-04 09:40:00 | AAPL | Stock | 27.32 | 27.3325 | 27.265 | 27.2825 | 2220204.0 |
| 2016-11-04 09:45:00 | AAPL | Stock | 27.2825 | 27.3288 | 27.2675 | 27.2775 | 1307548.0 |
| 2016-11-04 09:50:00 | AAPL | Stock | 27.2775 | 27.2825 | 27.1825 | 27.2295 | 2469548.0 |
| 2016-11-04 09:55:00 | AAPL | Stock | 27.2325 | 27.2335 | 27.11 | 27.1425 | 2532804.0 |
| 2016-11-04 10:00:00 | AAPL | Stock | 27.145 | 27.2275 | 27.14 | 27.205 | 2222472.0 |
| 2016-11-04 10:05:00 | AAPL | Stock | 27.205 | 27.3125 | 27.2025 | 27.295 | 1868688.0 |
| 2016-11-04 10:10:00 | AAPL | Stock | 27.295 | 27.3225 | 27.2678 | 27.27 | 1582508.0 |
| 2016-11-04 10:15:00 | AAPL | Stock | 27.2725 | 27.32 | 27.245 | 27.3075 | 1663084.0 |
| 2016-11-04 10:20:00 | AAPL | Stock | 27.3075 | 27.3525 | 27.304 | 27.345 | 1182316.0 |
| 2016-11-04 10:25:00 | AAPL | Stock | 27.344 | 27.36 | 27.3025 | 27.325 | 1171712.0 |
> showing 50 of 347,594 rows — these rows as CSV