PREVIEW / stock_5min / 2016-04-21
file: by_date/stock_5min/2016/2016-04-21.parquet size: 5.4 MB rows: 356,677 symbols: 3,323
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-04-21 04:40:00 | AAPL | Stock | 26.7875 | 26.7875 | 26.7875 | 26.7875 | 2000.0 |
| 2016-04-21 06:50:00 | AAPL | Stock | 26.7875 | 26.7875 | 26.7875 | 26.7875 | 800.0 |
| 2016-04-21 06:55:00 | AAPL | Stock | 26.8175 | 26.8175 | 26.8175 | 26.8175 | 4680.0 |
| 2016-04-21 07:00:00 | AAPL | Stock | 26.8175 | 26.8175 | 26.8125 | 26.8125 | 4856.0 |
| 2016-04-21 07:15:00 | AAPL | Stock | 26.8 | 26.84 | 26.8 | 26.8 | 10620.0 |
| 2016-04-21 07:20:00 | AAPL | Stock | 26.81 | 26.8325 | 26.8075 | 26.8325 | 20600.0 |
| 2016-04-21 07:25:00 | AAPL | Stock | 26.825 | 26.825 | 26.825 | 26.825 | 7668.0 |
| 2016-04-21 07:30:00 | AAPL | Stock | 26.825 | 26.825 | 26.805 | 26.805 | 4600.0 |
| 2016-04-21 07:35:00 | AAPL | Stock | 26.7875 | 26.7875 | 26.7875 | 26.7875 | 1000.0 |
| 2016-04-21 07:40:00 | AAPL | Stock | 26.8225 | 26.8625 | 26.8225 | 26.8425 | 5000.0 |
| 2016-04-21 07:45:00 | AAPL | Stock | 26.845 | 26.85 | 26.845 | 26.85 | 4400.0 |
| 2016-04-21 07:50:00 | AAPL | Stock | 26.845 | 26.845 | 26.845 | 26.845 | 2500.0 |
| 2016-04-21 07:55:00 | AAPL | Stock | 26.8375 | 26.84 | 26.825 | 26.825 | 5300.0 |
| 2016-04-21 08:00:00 | AAPL | Stock | 26.805 | 26.85 | 26.7875 | 26.8375 | 16236.0 |
| 2016-04-21 08:05:00 | AAPL | Stock | 26.835 | 26.85 | 26.835 | 26.845 | 5660.0 |
| 2016-04-21 08:10:00 | AAPL | Stock | 26.85 | 26.86 | 26.85 | 26.85 | 34452.0 |
| 2016-04-21 08:15:00 | AAPL | Stock | 26.86 | 26.875 | 26.855 | 26.855 | 21536.0 |
| 2016-04-21 08:20:00 | AAPL | Stock | 26.8625 | 26.865 | 26.85 | 26.85 | 4580.0 |
| 2016-04-21 08:25:00 | AAPL | Stock | 26.8625 | 26.875 | 26.8625 | 26.875 | 6800.0 |
| 2016-04-21 08:30:00 | AAPL | Stock | 26.8625 | 26.8725 | 26.8525 | 26.8625 | 27416.0 |
| 2016-04-21 08:35:00 | AAPL | Stock | 26.855 | 26.8825 | 26.84 | 26.875 | 29684.0 |
| 2016-04-21 08:40:00 | AAPL | Stock | 26.8575 | 26.8625 | 26.8375 | 26.845 | 39464.0 |
| 2016-04-21 08:45:00 | AAPL | Stock | 26.845 | 26.8475 | 26.8275 | 26.8475 | 20320.0 |
| 2016-04-21 08:50:00 | AAPL | Stock | 26.8375 | 26.84 | 26.8175 | 26.8325 | 17908.0 |
| 2016-04-21 08:55:00 | AAPL | Stock | 26.845 | 26.845 | 26.845 | 26.845 | 400.0 |
| 2016-04-21 09:00:00 | AAPL | Stock | 26.8125 | 26.83 | 26.8025 | 26.825 | 9420.0 |
| 2016-04-21 09:05:00 | AAPL | Stock | 26.81 | 26.83 | 26.8025 | 26.83 | 35472.0 |
| 2016-04-21 09:10:00 | AAPL | Stock | 26.8325 | 26.8425 | 26.83 | 26.83 | 19992.0 |
| 2016-04-21 09:15:00 | AAPL | Stock | 26.83 | 26.83 | 26.81 | 26.825 | 18540.0 |
| 2016-04-21 09:20:00 | AAPL | Stock | 26.8125 | 26.82 | 26.7875 | 26.7875 | 30712.0 |
| 2016-04-21 09:25:00 | AAPL | Stock | 26.785 | 26.8 | 26.73 | 26.7325 | 155280.0 |
| 2016-04-21 09:30:00 | AAPL | Stock | 26.7325 | 26.7325 | 26.6025 | 26.625 | 5554000.0 |
| 2016-04-21 09:35:00 | AAPL | Stock | 26.62 | 26.625 | 26.5075 | 26.5425 | 4979712.0 |
| 2016-04-21 09:40:00 | AAPL | Stock | 26.5425 | 26.55 | 26.4025 | 26.405 | 6086220.0 |
| 2016-04-21 09:45:00 | AAPL | Stock | 26.405 | 26.4472 | 26.38 | 26.4025 | 3813364.0 |
| 2016-04-21 09:50:00 | AAPL | Stock | 26.4025 | 26.4825 | 26.4 | 26.465 | 3258160.0 |
| 2016-04-21 09:55:00 | AAPL | Stock | 26.465 | 26.52 | 26.45 | 26.49 | 2619484.0 |
| 2016-04-21 10:00:00 | AAPL | Stock | 26.488 | 26.515 | 26.475 | 26.5025 | 2112288.0 |
| 2016-04-21 10:05:00 | AAPL | Stock | 26.5 | 26.5175 | 26.465 | 26.499 | 1913760.0 |
| 2016-04-21 10:10:00 | AAPL | Stock | 26.4975 | 26.515 | 26.47 | 26.4838 | 1621040.0 |
| 2016-04-21 10:15:00 | AAPL | Stock | 26.485 | 26.525 | 26.45 | 26.525 | 1592108.0 |
| 2016-04-21 10:20:00 | AAPL | Stock | 26.5238 | 26.6075 | 26.5238 | 26.5875 | 2268596.0 |
| 2016-04-21 10:25:00 | AAPL | Stock | 26.5865 | 26.625 | 26.565 | 26.6038 | 2150072.0 |
| 2016-04-21 10:30:00 | AAPL | Stock | 26.6028 | 26.6038 | 26.56 | 26.5775 | 1710584.0 |
| 2016-04-21 10:35:00 | AAPL | Stock | 26.5775 | 26.6225 | 26.565 | 26.6125 | 1425392.0 |
| 2016-04-21 10:40:00 | AAPL | Stock | 26.61 | 26.6475 | 26.61 | 26.61 | 1432156.0 |
| 2016-04-21 10:45:00 | AAPL | Stock | 26.6125 | 26.6275 | 26.6075 | 26.62 | 1044280.0 |
| 2016-04-21 10:50:00 | AAPL | Stock | 26.6212 | 26.6638 | 26.61 | 26.64 | 1373916.0 |
| 2016-04-21 10:55:00 | AAPL | Stock | 26.6425 | 26.645 | 26.595 | 26.605 | 1157352.0 |
| 2016-04-21 11:00:00 | AAPL | Stock | 26.6058 | 26.64 | 26.5975 | 26.61 | 1130740.0 |
> showing 50 of 356,677 rows — these rows as CSV