PREVIEW / stock_5min / 2016-10-07
file: by_date/stock_5min/2016/2016-10-07.parquet size: 5.2 MB rows: 339,954 symbols: 3,186
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-10-07 06:10:00 | AAPL | Stock | 28.4525 | 28.4525 | 28.4525 | 28.4525 | 400.0 |
| 2016-10-07 06:30:00 | AAPL | Stock | 28.4075 | 28.4075 | 28.4075 | 28.4075 | 400.0 |
| 2016-10-07 06:45:00 | AAPL | Stock | 28.415 | 28.415 | 28.385 | 28.385 | 2200.0 |
| 2016-10-07 06:55:00 | AAPL | Stock | 28.4375 | 28.445 | 28.4375 | 28.445 | 1200.0 |
| 2016-10-07 07:20:00 | AAPL | Stock | 28.46 | 28.4725 | 28.46 | 28.4725 | 4000.0 |
| 2016-10-07 07:25:00 | AAPL | Stock | 28.4625 | 28.4725 | 28.4625 | 28.4725 | 20400.0 |
| 2016-10-07 07:35:00 | AAPL | Stock | 28.4625 | 28.4625 | 28.4625 | 28.4625 | 740.0 |
| 2016-10-07 07:40:00 | AAPL | Stock | 28.4625 | 28.4625 | 28.4475 | 28.45 | 11540.0 |
| 2016-10-07 07:55:00 | AAPL | Stock | 28.4625 | 28.4625 | 28.4625 | 28.4625 | 8400.0 |
| 2016-10-07 08:00:00 | AAPL | Stock | 28.4625 | 28.4725 | 28.4 | 28.455 | 54400.0 |
| 2016-10-07 08:05:00 | AAPL | Stock | 28.455 | 28.4725 | 28.455 | 28.4725 | 4968.0 |
| 2016-10-07 08:10:00 | AAPL | Stock | 28.49 | 28.49 | 28.475 | 28.475 | 16400.0 |
| 2016-10-07 08:15:00 | AAPL | Stock | 28.4675 | 28.4675 | 28.4675 | 28.4675 | 1200.0 |
| 2016-10-07 08:20:00 | AAPL | Stock | 28.475 | 28.4875 | 28.475 | 28.4875 | 5540.0 |
| 2016-10-07 08:25:00 | AAPL | Stock | 28.4725 | 28.4725 | 28.46 | 28.46 | 39620.0 |
| 2016-10-07 08:30:00 | AAPL | Stock | 28.46 | 28.565 | 28.46 | 28.5125 | 137112.0 |
| 2016-10-07 08:35:00 | AAPL | Stock | 28.5125 | 28.5175 | 28.4625 | 28.4875 | 77496.0 |
| 2016-10-07 08:40:00 | AAPL | Stock | 28.495 | 28.5625 | 28.4925 | 28.535 | 46708.0 |
| 2016-10-07 08:45:00 | AAPL | Stock | 28.545 | 28.5525 | 28.5275 | 28.5475 | 36332.0 |
| 2016-10-07 08:50:00 | AAPL | Stock | 28.5375 | 28.5375 | 28.525 | 28.535 | 33112.0 |
| 2016-10-07 08:55:00 | AAPL | Stock | 28.515 | 28.5575 | 28.515 | 28.5575 | 24600.0 |
| 2016-10-07 09:00:00 | AAPL | Stock | 28.5575 | 28.5825 | 28.5575 | 28.5675 | 112508.0 |
| 2016-10-07 09:05:00 | AAPL | Stock | 28.5625 | 28.575 | 28.5425 | 28.55 | 60576.0 |
| 2016-10-07 09:10:00 | AAPL | Stock | 28.555 | 28.555 | 28.5375 | 28.55 | 43100.0 |
| 2016-10-07 09:15:00 | AAPL | Stock | 28.55 | 28.555 | 28.5175 | 28.525 | 72348.0 |
| 2016-10-07 09:20:00 | AAPL | Stock | 28.53 | 28.535 | 28.525 | 28.535 | 20000.0 |
| 2016-10-07 09:25:00 | AAPL | Stock | 28.5425 | 28.605 | 28.54 | 28.57 | 203644.0 |
| 2016-10-07 09:30:00 | AAPL | Stock | 28.57 | 28.6125 | 28.5175 | 28.5575 | 6833116.0 |
| 2016-10-07 09:35:00 | AAPL | Stock | 28.56 | 28.625 | 28.5025 | 28.6225 | 3286244.0 |
| 2016-10-07 09:40:00 | AAPL | Stock | 28.625 | 28.64 | 28.535 | 28.5425 | 2974024.0 |
| 2016-10-07 09:45:00 | AAPL | Stock | 28.5425 | 28.57 | 28.46 | 28.46 | 2514384.0 |
| 2016-10-07 09:50:00 | AAPL | Stock | 28.46 | 28.534 | 28.455 | 28.5175 | 2092688.0 |
| 2016-10-07 09:55:00 | AAPL | Stock | 28.515 | 28.535 | 28.485 | 28.5325 | 1180408.0 |
| 2016-10-07 10:00:00 | AAPL | Stock | 28.535 | 28.5725 | 28.51 | 28.5225 | 1617704.0 |
| 2016-10-07 10:05:00 | AAPL | Stock | 28.52 | 28.5388 | 28.4975 | 28.5225 | 1281428.0 |
| 2016-10-07 10:10:00 | AAPL | Stock | 28.5238 | 28.5675 | 28.515 | 28.5425 | 1438448.0 |
| 2016-10-07 10:15:00 | AAPL | Stock | 28.5425 | 28.5525 | 28.5075 | 28.5225 | 798624.0 |
| 2016-10-07 10:20:00 | AAPL | Stock | 28.5225 | 28.55 | 28.52 | 28.5425 | 870768.0 |
| 2016-10-07 10:25:00 | AAPL | Stock | 28.545 | 28.595 | 28.545 | 28.585 | 1898812.0 |
| 2016-10-07 10:30:00 | AAPL | Stock | 28.5848 | 28.585 | 28.5575 | 28.56 | 1003516.0 |
| 2016-10-07 10:35:00 | AAPL | Stock | 28.5625 | 28.565 | 28.525 | 28.555 | 900856.0 |
| 2016-10-07 10:40:00 | AAPL | Stock | 28.555 | 28.5725 | 28.535 | 28.54 | 774488.0 |
| 2016-10-07 10:45:00 | AAPL | Stock | 28.54 | 28.545 | 28.5185 | 28.5365 | 1032728.0 |
| 2016-10-07 10:50:00 | AAPL | Stock | 28.535 | 28.5575 | 28.515 | 28.5175 | 657188.0 |
| 2016-10-07 10:55:00 | AAPL | Stock | 28.5175 | 28.5175 | 28.485 | 28.49 | 1121432.0 |
| 2016-10-07 11:00:00 | AAPL | Stock | 28.49 | 28.5 | 28.4775 | 28.49 | 1007128.0 |
| 2016-10-07 11:05:00 | AAPL | Stock | 28.4875 | 28.5225 | 28.4875 | 28.5188 | 1032200.0 |
| 2016-10-07 11:10:00 | AAPL | Stock | 28.5188 | 28.525 | 28.5075 | 28.5125 | 625636.0 |
| 2016-10-07 11:15:00 | AAPL | Stock | 28.5125 | 28.5338 | 28.505 | 28.5338 | 824696.0 |
| 2016-10-07 11:20:00 | AAPL | Stock | 28.5325 | 28.575 | 28.5325 | 28.55 | 1195340.0 |
> showing 50 of 339,954 rows — these rows as CSV