PREVIEW / stock_5min / 2016-12-28
file: by_date/stock_5min/2016/2016-12-28.parquet size: 5.3 MB rows: 351,634 symbols: 3,165
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-28 05:30:00 | AAPL | Stock | 29.345 | 29.345 | 29.345 | 29.345 | 460.0 |
| 2016-12-28 06:15:00 | AAPL | Stock | 29.325 | 29.325 | 29.3125 | 29.3125 | 1396.0 |
| 2016-12-28 06:55:00 | AAPL | Stock | 29.3375 | 29.3375 | 29.3375 | 29.3375 | 636.0 |
| 2016-12-28 07:05:00 | AAPL | Stock | 29.37 | 29.3725 | 29.37 | 29.3725 | 1200.0 |
| 2016-12-28 07:15:00 | AAPL | Stock | 29.3725 | 29.3725 | 29.3725 | 29.3725 | 800.0 |
| 2016-12-28 07:30:00 | AAPL | Stock | 29.37 | 29.37 | 29.3625 | 29.3625 | 2800.0 |
| 2016-12-28 07:40:00 | AAPL | Stock | 29.365 | 29.365 | 29.365 | 29.365 | 400.0 |
| 2016-12-28 07:45:00 | AAPL | Stock | 29.3725 | 29.3725 | 29.3725 | 29.3725 | 400.0 |
| 2016-12-28 07:55:00 | AAPL | Stock | 29.38 | 29.3925 | 29.38 | 29.3925 | 2688.0 |
| 2016-12-28 08:00:00 | AAPL | Stock | 29.395 | 29.41 | 29.3625 | 29.4075 | 18288.0 |
| 2016-12-28 08:05:00 | AAPL | Stock | 29.4 | 29.4 | 29.39 | 29.39 | 9764.0 |
| 2016-12-28 08:10:00 | AAPL | Stock | 29.3975 | 29.3975 | 29.3875 | 29.39 | 14116.0 |
| 2016-12-28 08:15:00 | AAPL | Stock | 29.385 | 29.4 | 29.385 | 29.4 | 21036.0 |
| 2016-12-28 08:20:00 | AAPL | Stock | 29.4025 | 29.43 | 29.4025 | 29.4275 | 10720.0 |
| 2016-12-28 08:25:00 | AAPL | Stock | 29.4125 | 29.4125 | 29.4125 | 29.4125 | 2060.0 |
| 2016-12-28 08:30:00 | AAPL | Stock | 29.425 | 29.4325 | 29.4225 | 29.43 | 8080.0 |
| 2016-12-28 08:35:00 | AAPL | Stock | 29.4325 | 29.4375 | 29.4125 | 29.4125 | 20752.0 |
| 2016-12-28 08:45:00 | AAPL | Stock | 29.4125 | 29.4125 | 29.4125 | 29.4125 | 6200.0 |
| 2016-12-28 08:50:00 | AAPL | Stock | 29.415 | 29.4175 | 29.4 | 29.4 | 17200.0 |
| 2016-12-28 08:55:00 | AAPL | Stock | 29.405 | 29.415 | 29.405 | 29.4125 | 12764.0 |
| 2016-12-28 09:00:00 | AAPL | Stock | 29.4125 | 29.425 | 29.4 | 29.4 | 23596.0 |
| 2016-12-28 09:05:00 | AAPL | Stock | 29.41 | 29.41 | 29.395 | 29.395 | 33024.0 |
| 2016-12-28 09:10:00 | AAPL | Stock | 29.395 | 29.4075 | 29.395 | 29.4075 | 11140.0 |
| 2016-12-28 09:15:00 | AAPL | Stock | 29.4075 | 29.4075 | 29.3925 | 29.3925 | 55904.0 |
| 2016-12-28 09:20:00 | AAPL | Stock | 29.3925 | 29.3975 | 29.39 | 29.3925 | 14984.0 |
| 2016-12-28 09:25:00 | AAPL | Stock | 29.3925 | 29.3925 | 29.3525 | 29.375 | 20148.0 |
| 2016-12-28 09:30:00 | AAPL | Stock | 29.38 | 29.5042 | 29.3675 | 29.49 | 5025220.0 |
| 2016-12-28 09:35:00 | AAPL | Stock | 29.4888 | 29.5 | 29.4675 | 29.4775 | 1906124.0 |
| 2016-12-28 09:40:00 | AAPL | Stock | 29.475 | 29.4775 | 29.4365 | 29.465 | 1753816.0 |
| 2016-12-28 09:45:00 | AAPL | Stock | 29.4625 | 29.4775 | 29.425 | 29.4425 | 1408352.0 |
| 2016-12-28 09:50:00 | AAPL | Stock | 29.4435 | 29.4465 | 29.3725 | 29.3825 | 1728156.0 |
| 2016-12-28 09:55:00 | AAPL | Stock | 29.385 | 29.39 | 29.3225 | 29.335 | 1819064.0 |
| 2016-12-28 10:00:00 | AAPL | Stock | 29.3375 | 29.3625 | 29.3125 | 29.36 | 1833644.0 |
| 2016-12-28 10:05:00 | AAPL | Stock | 29.3615 | 29.3875 | 29.32 | 29.325 | 1441040.0 |
| 2016-12-28 10:10:00 | AAPL | Stock | 29.3252 | 29.3252 | 29.2525 | 29.3025 | 1704868.0 |
| 2016-12-28 10:15:00 | AAPL | Stock | 29.3012 | 29.3075 | 29.2625 | 29.2675 | 991884.0 |
| 2016-12-28 10:20:00 | AAPL | Stock | 29.27 | 29.3 | 29.26 | 29.29 | 1049516.0 |
| 2016-12-28 10:25:00 | AAPL | Stock | 29.29 | 29.2925 | 29.2575 | 29.2775 | 854004.0 |
| 2016-12-28 10:30:00 | AAPL | Stock | 29.275 | 29.2928 | 29.2432 | 29.2612 | 1180648.0 |
| 2016-12-28 10:35:00 | AAPL | Stock | 29.2622 | 29.3 | 29.26 | 29.27 | 839364.0 |
| 2016-12-28 10:40:00 | AAPL | Stock | 29.2725 | 29.2875 | 29.2375 | 29.2382 | 744824.0 |
| 2016-12-28 10:45:00 | AAPL | Stock | 29.2375 | 29.26 | 29.235 | 29.245 | 864200.0 |
| 2016-12-28 10:50:00 | AAPL | Stock | 29.2458 | 29.2458 | 29.1925 | 29.2068 | 1137476.0 |
| 2016-12-28 10:55:00 | AAPL | Stock | 29.205 | 29.2442 | 29.2 | 29.2375 | 882760.0 |
| 2016-12-28 11:00:00 | AAPL | Stock | 29.2332 | 29.275 | 29.2275 | 29.275 | 1243640.0 |
| 2016-12-28 11:05:00 | AAPL | Stock | 29.2735 | 29.2875 | 29.2625 | 29.2735 | 841872.0 |
| 2016-12-28 11:10:00 | AAPL | Stock | 29.2725 | 29.2975 | 29.2625 | 29.2775 | 1364536.0 |
| 2016-12-28 11:15:00 | AAPL | Stock | 29.28 | 29.2912 | 29.2775 | 29.285 | 510552.0 |
| 2016-12-28 11:20:00 | AAPL | Stock | 29.285 | 29.32 | 29.285 | 29.3072 | 1499816.0 |
| 2016-12-28 11:25:00 | AAPL | Stock | 29.3062 | 29.3218 | 29.3062 | 29.3138 | 628788.0 |
> showing 50 of 351,634 rows — these rows as CSV