PREVIEW / stock_5min / 2016-06-09
file: by_date/stock_5min/2016/2016-06-09.parquet size: 5.3 MB rows: 352,361 symbols: 3,288
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-06-09 04:30:00 | AAPL | Stock | 24.625 | 24.625 | 24.625 | 24.625 | 400.0 |
| 2016-06-09 04:40:00 | AAPL | Stock | 24.625 | 24.625 | 24.625 | 24.625 | 400.0 |
| 2016-06-09 05:35:00 | AAPL | Stock | 24.615 | 24.625 | 24.615 | 24.625 | 3644.0 |
| 2016-06-09 05:40:00 | AAPL | Stock | 24.625 | 24.625 | 24.625 | 24.625 | 800.0 |
| 2016-06-09 05:45:00 | AAPL | Stock | 24.6325 | 24.6325 | 24.6325 | 24.6325 | 400.0 |
| 2016-06-09 05:50:00 | AAPL | Stock | 24.625 | 24.625 | 24.625 | 24.625 | 3956.0 |
| 2016-06-09 06:20:00 | AAPL | Stock | 24.625 | 24.625 | 24.625 | 24.625 | 1720.0 |
| 2016-06-09 06:25:00 | AAPL | Stock | 24.625 | 24.625 | 24.625 | 24.625 | 2680.0 |
| 2016-06-09 06:55:00 | AAPL | Stock | 24.625 | 24.625 | 24.625 | 24.625 | 400.0 |
| 2016-06-09 07:00:00 | AAPL | Stock | 24.6375 | 24.645 | 24.635 | 24.645 | 7544.0 |
| 2016-06-09 07:05:00 | AAPL | Stock | 24.6425 | 24.6425 | 24.6375 | 24.6375 | 2100.0 |
| 2016-06-09 07:10:00 | AAPL | Stock | 24.65 | 24.65 | 24.64 | 24.64 | 1600.0 |
| 2016-06-09 07:25:00 | AAPL | Stock | 24.66 | 24.66 | 24.66 | 24.66 | 616.0 |
| 2016-06-09 07:30:00 | AAPL | Stock | 24.65 | 24.65 | 24.65 | 24.65 | 800.0 |
| 2016-06-09 07:50:00 | AAPL | Stock | 24.6425 | 24.6425 | 24.6375 | 24.6375 | 5600.0 |
| 2016-06-09 08:00:00 | AAPL | Stock | 24.625 | 24.675 | 24.625 | 24.6375 | 18276.0 |
| 2016-06-09 08:05:00 | AAPL | Stock | 24.645 | 24.6575 | 24.645 | 24.6575 | 5880.0 |
| 2016-06-09 08:10:00 | AAPL | Stock | 24.6625 | 24.675 | 24.66 | 24.675 | 18836.0 |
| 2016-06-09 08:15:00 | AAPL | Stock | 24.655 | 24.67 | 24.64 | 24.6525 | 7084.0 |
| 2016-06-09 08:20:00 | AAPL | Stock | 24.6475 | 24.6475 | 24.64 | 24.64 | 2736.0 |
| 2016-06-09 08:25:00 | AAPL | Stock | 24.6475 | 24.65 | 24.64 | 24.6425 | 14180.0 |
| 2016-06-09 08:30:00 | AAPL | Stock | 24.6625 | 24.675 | 24.65 | 24.675 | 22000.0 |
| 2016-06-09 08:35:00 | AAPL | Stock | 24.675 | 24.68 | 24.67 | 24.67 | 11200.0 |
| 2016-06-09 08:40:00 | AAPL | Stock | 24.66 | 24.6775 | 24.66 | 24.6725 | 29724.0 |
| 2016-06-09 08:45:00 | AAPL | Stock | 24.6725 | 24.695 | 24.67 | 24.67 | 23552.0 |
| 2016-06-09 08:50:00 | AAPL | Stock | 24.6725 | 24.675 | 24.6625 | 24.6625 | 18956.0 |
| 2016-06-09 08:55:00 | AAPL | Stock | 24.6625 | 24.67 | 24.6575 | 24.67 | 9200.0 |
| 2016-06-09 09:00:00 | AAPL | Stock | 24.6675 | 24.67 | 24.6675 | 24.6675 | 11080.0 |
| 2016-06-09 09:05:00 | AAPL | Stock | 24.67 | 24.675 | 24.66 | 24.6625 | 4000.0 |
| 2016-06-09 09:10:00 | AAPL | Stock | 24.6625 | 24.6675 | 24.6625 | 24.6625 | 25612.0 |
| 2016-06-09 09:15:00 | AAPL | Stock | 24.6625 | 24.6625 | 24.6625 | 24.6625 | 13624.0 |
| 2016-06-09 09:20:00 | AAPL | Stock | 24.6625 | 24.6725 | 24.6625 | 24.6725 | 4800.0 |
| 2016-06-09 09:25:00 | AAPL | Stock | 24.6775 | 24.695 | 24.62 | 24.6225 | 226924.0 |
| 2016-06-09 09:30:00 | AAPL | Stock | 24.625 | 24.785 | 24.615 | 24.755 | 4391020.0 |
| 2016-06-09 09:35:00 | AAPL | Stock | 24.7588 | 24.8725 | 24.755 | 24.845 | 3637740.0 |
| 2016-06-09 09:40:00 | AAPL | Stock | 24.845 | 24.885 | 24.8175 | 24.825 | 3111488.0 |
| 2016-06-09 09:45:00 | AAPL | Stock | 24.8245 | 24.8725 | 24.805 | 24.86 | 2331252.0 |
| 2016-06-09 09:50:00 | AAPL | Stock | 24.86 | 24.88 | 24.845 | 24.88 | 2119752.0 |
| 2016-06-09 09:55:00 | AAPL | Stock | 24.8775 | 24.8875 | 24.8375 | 24.8475 | 2126432.0 |
| 2016-06-09 10:00:00 | AAPL | Stock | 24.8498 | 24.875 | 24.8258 | 24.8412 | 1889816.0 |
| 2016-06-09 10:05:00 | AAPL | Stock | 24.84 | 24.8575 | 24.795 | 24.84 | 2307036.0 |
| 2016-06-09 10:10:00 | AAPL | Stock | 24.84 | 24.855 | 24.8302 | 24.8375 | 1082328.0 |
| 2016-06-09 10:15:00 | AAPL | Stock | 24.8375 | 24.8675 | 24.8375 | 24.84 | 1476476.0 |
| 2016-06-09 10:20:00 | AAPL | Stock | 24.8425 | 24.85 | 24.825 | 24.8325 | 1199480.0 |
| 2016-06-09 10:25:00 | AAPL | Stock | 24.8325 | 24.8375 | 24.8175 | 24.8238 | 798668.0 |
| 2016-06-09 10:30:00 | AAPL | Stock | 24.8225 | 24.837 | 24.81 | 24.8175 | 1292940.0 |
| 2016-06-09 10:35:00 | AAPL | Stock | 24.815 | 24.855 | 24.8125 | 24.8462 | 1450404.0 |
| 2016-06-09 10:40:00 | AAPL | Stock | 24.845 | 24.9125 | 24.835 | 24.9125 | 2083392.0 |
| 2016-06-09 10:45:00 | AAPL | Stock | 24.91 | 24.9125 | 24.885 | 24.912 | 1428304.0 |
| 2016-06-09 10:50:00 | AAPL | Stock | 24.9125 | 24.925 | 24.9075 | 24.9138 | 1519732.0 |
> showing 50 of 352,361 rows — these rows as CSV