PREVIEW / stock_5min / 2017-10-04
file: by_date/stock_5min/2017/2017-10-04.parquet size: 5.4 MB rows: 351,898 symbols: 2,956
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-10-04 05:30:00 | AAPL | Stock | 38.625 | 38.65 | 38.625 | 38.65 | 8920.0 |
| 2017-10-04 05:35:00 | AAPL | Stock | 38.6625 | 38.6625 | 38.6625 | 38.6625 | 620.0 |
| 2017-10-04 06:20:00 | AAPL | Stock | 38.635 | 38.635 | 38.635 | 38.635 | 400.0 |
| 2017-10-04 06:25:00 | AAPL | Stock | 38.6325 | 38.6325 | 38.6325 | 38.6325 | 528.0 |
| 2017-10-04 06:45:00 | AAPL | Stock | 38.6275 | 38.6275 | 38.625 | 38.625 | 37200.0 |
| 2017-10-04 06:50:00 | AAPL | Stock | 38.6 | 38.6 | 38.5775 | 38.5775 | 3020.0 |
| 2017-10-04 06:55:00 | AAPL | Stock | 38.585 | 38.585 | 38.585 | 38.585 | 800.0 |
| 2017-10-04 07:00:00 | AAPL | Stock | 38.6 | 38.62 | 38.5975 | 38.6125 | 35516.0 |
| 2017-10-04 07:05:00 | AAPL | Stock | 38.6025 | 38.6025 | 38.58 | 38.58 | 2660.0 |
| 2017-10-04 07:10:00 | AAPL | Stock | 38.58 | 38.5875 | 38.5725 | 38.5875 | 7672.0 |
| 2017-10-04 07:15:00 | AAPL | Stock | 38.575 | 38.575 | 38.5475 | 38.5475 | 8728.0 |
| 2017-10-04 07:20:00 | AAPL | Stock | 38.5375 | 38.55 | 38.4725 | 38.4875 | 36012.0 |
| 2017-10-04 07:25:00 | AAPL | Stock | 38.4825 | 38.4825 | 38.38 | 38.425 | 29572.0 |
| 2017-10-04 07:30:00 | AAPL | Stock | 38.425 | 38.425 | 38.3275 | 38.3275 | 31448.0 |
| 2017-10-04 07:35:00 | AAPL | Stock | 38.375 | 38.375 | 38.35 | 38.35 | 14800.0 |
| 2017-10-04 07:40:00 | AAPL | Stock | 38.375 | 38.4 | 38.375 | 38.4 | 10944.0 |
| 2017-10-04 07:45:00 | AAPL | Stock | 38.4375 | 38.45 | 38.375 | 38.425 | 35408.0 |
| 2017-10-04 07:50:00 | AAPL | Stock | 38.435 | 38.4625 | 38.425 | 38.425 | 17108.0 |
| 2017-10-04 07:55:00 | AAPL | Stock | 38.45 | 38.5 | 38.45 | 38.4675 | 61508.0 |
| 2017-10-04 08:00:00 | AAPL | Stock | 38.575 | 38.705 | 38.3275 | 38.475 | 70092.0 |
| 2017-10-04 08:10:00 | AAPL | Stock | 38.465 | 38.47 | 38.425 | 38.45 | 29020.0 |
| 2017-10-04 08:15:00 | AAPL | Stock | 38.4625 | 38.5 | 38.42 | 38.42 | 45612.0 |
| 2017-10-04 08:20:00 | AAPL | Stock | 38.4225 | 38.46 | 38.4 | 38.4025 | 23752.0 |
| 2017-10-04 08:25:00 | AAPL | Stock | 38.425 | 38.4375 | 38.3975 | 38.415 | 22348.0 |
| 2017-10-04 08:30:00 | AAPL | Stock | 38.415 | 38.415 | 38.35 | 38.355 | 47252.0 |
| 2017-10-04 08:35:00 | AAPL | Stock | 38.375 | 38.385 | 38.35 | 38.35 | 43344.0 |
| 2017-10-04 08:40:00 | AAPL | Stock | 38.35 | 38.3525 | 38.33 | 38.3375 | 45072.0 |
| 2017-10-04 08:45:00 | AAPL | Stock | 38.3425 | 38.3625 | 38.32 | 38.3375 | 99004.0 |
| 2017-10-04 08:50:00 | AAPL | Stock | 38.3325 | 38.3825 | 38.325 | 38.35 | 51240.0 |
| 2017-10-04 08:55:00 | AAPL | Stock | 38.3325 | 38.375 | 38.3325 | 38.335 | 30988.0 |
| 2017-10-04 09:00:00 | AAPL | Stock | 38.35 | 38.37 | 38.3375 | 38.365 | 51616.0 |
| 2017-10-04 09:05:00 | AAPL | Stock | 38.3575 | 38.3575 | 38.34 | 38.3475 | 30336.0 |
| 2017-10-04 09:10:00 | AAPL | Stock | 38.3475 | 38.4 | 38.34 | 38.4 | 53752.0 |
| 2017-10-04 09:15:00 | AAPL | Stock | 38.4 | 38.4275 | 38.3875 | 38.425 | 60408.0 |
| 2017-10-04 09:20:00 | AAPL | Stock | 38.425 | 38.425 | 38.3375 | 38.3475 | 60524.0 |
| 2017-10-04 09:25:00 | AAPL | Stock | 38.3575 | 38.435 | 38.3575 | 38.4175 | 26992.0 |
| 2017-10-04 09:30:00 | AAPL | Stock | 38.4075 | 38.435 | 38.2975 | 38.395 | 4078676.0 |
| 2017-10-04 09:35:00 | AAPL | Stock | 38.4 | 38.435 | 38.3675 | 38.37 | 2113808.0 |
| 2017-10-04 09:40:00 | AAPL | Stock | 38.37 | 38.4225 | 38.2725 | 38.3225 | 2333544.0 |
| 2017-10-04 09:45:00 | AAPL | Stock | 38.32 | 38.3525 | 38.2875 | 38.33 | 1390980.0 |
| 2017-10-04 09:50:00 | AAPL | Stock | 38.3275 | 38.34 | 38.295 | 38.3125 | 1165848.0 |
| 2017-10-04 09:55:00 | AAPL | Stock | 38.315 | 38.39 | 38.305 | 38.3838 | 1591044.0 |
| 2017-10-04 10:00:00 | AAPL | Stock | 38.3875 | 38.39 | 38.335 | 38.37 | 1081064.0 |
| 2017-10-04 10:05:00 | AAPL | Stock | 38.3728 | 38.375 | 38.3175 | 38.3225 | 898308.0 |
| 2017-10-04 10:10:00 | AAPL | Stock | 38.325 | 38.335 | 38.285 | 38.3262 | 1343064.0 |
| 2017-10-04 10:15:00 | AAPL | Stock | 38.325 | 38.3525 | 38.2875 | 38.2962 | 1072556.0 |
| 2017-10-04 10:20:00 | AAPL | Stock | 38.2958 | 38.314 | 38.255 | 38.2625 | 1173124.0 |
| 2017-10-04 10:25:00 | AAPL | Stock | 38.265 | 38.3075 | 38.2275 | 38.295 | 1700320.0 |
| 2017-10-04 10:30:00 | AAPL | Stock | 38.295 | 38.33 | 38.2225 | 38.2322 | 1586752.0 |
| 2017-10-04 10:35:00 | AAPL | Stock | 38.23 | 38.245 | 38.1925 | 38.21 | 1406712.0 |
> showing 50 of 351,898 rows — these rows as CSV