PREVIEW / stock_5min / 2016-08-08
file: by_date/stock_5min/2016/2016-08-08.parquet size: 5.4 MB rows: 353,686 symbols: 3,260
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-08-08 04:05:00 | AAPL | Stock | 26.895 | 26.895 | 26.895 | 26.895 | 880.0 |
| 2016-08-08 04:40:00 | AAPL | Stock | 26.9125 | 26.9125 | 26.885 | 26.885 | 6476.0 |
| 2016-08-08 05:55:00 | AAPL | Stock | 26.89 | 26.9225 | 26.89 | 26.9225 | 2000.0 |
| 2016-08-08 06:00:00 | AAPL | Stock | 26.89 | 26.8975 | 26.89 | 26.8975 | 1640.0 |
| 2016-08-08 06:05:00 | AAPL | Stock | 26.895 | 26.8975 | 26.895 | 26.8975 | 2800.0 |
| 2016-08-08 06:10:00 | AAPL | Stock | 26.8975 | 26.8975 | 26.8975 | 26.8975 | 400.0 |
| 2016-08-08 06:30:00 | AAPL | Stock | 26.97 | 26.97 | 26.97 | 26.97 | 400.0 |
| 2016-08-08 06:35:00 | AAPL | Stock | 26.98 | 26.98 | 26.9375 | 26.9375 | 2956.0 |
| 2016-08-08 06:55:00 | AAPL | Stock | 26.95 | 26.95 | 26.95 | 26.95 | 1200.0 |
| 2016-08-08 07:00:00 | AAPL | Stock | 26.94 | 26.9425 | 26.9375 | 26.9375 | 1892.0 |
| 2016-08-08 07:05:00 | AAPL | Stock | 26.9275 | 26.9375 | 26.9275 | 26.9375 | 11308.0 |
| 2016-08-08 07:10:00 | AAPL | Stock | 26.925 | 26.925 | 26.925 | 26.925 | 488.0 |
| 2016-08-08 07:15:00 | AAPL | Stock | 26.9675 | 26.9725 | 26.9475 | 26.9475 | 5888.0 |
| 2016-08-08 07:20:00 | AAPL | Stock | 26.9375 | 26.945 | 26.9375 | 26.945 | 15940.0 |
| 2016-08-08 07:25:00 | AAPL | Stock | 26.945 | 26.945 | 26.945 | 26.945 | 3580.0 |
| 2016-08-08 07:30:00 | AAPL | Stock | 26.9375 | 26.945 | 26.935 | 26.935 | 2760.0 |
| 2016-08-08 07:35:00 | AAPL | Stock | 26.9375 | 26.945 | 26.9375 | 26.945 | 2776.0 |
| 2016-08-08 07:40:00 | AAPL | Stock | 26.945 | 26.9625 | 26.945 | 26.9625 | 12708.0 |
| 2016-08-08 07:45:00 | AAPL | Stock | 26.9375 | 26.9375 | 26.9375 | 26.9375 | 4000.0 |
| 2016-08-08 07:55:00 | AAPL | Stock | 26.9325 | 26.9375 | 26.9325 | 26.9375 | 4860.0 |
| 2016-08-08 08:00:00 | AAPL | Stock | 26.9375 | 26.945 | 26.9325 | 26.9325 | 73232.0 |
| 2016-08-08 08:05:00 | AAPL | Stock | 26.945 | 26.95 | 26.9375 | 26.95 | 15600.0 |
| 2016-08-08 08:10:00 | AAPL | Stock | 26.9425 | 26.97 | 26.9425 | 26.9675 | 27388.0 |
| 2016-08-08 08:15:00 | AAPL | Stock | 26.9625 | 26.9675 | 26.95 | 26.95 | 50632.0 |
| 2016-08-08 08:20:00 | AAPL | Stock | 26.945 | 26.96 | 26.945 | 26.95 | 14408.0 |
| 2016-08-08 08:25:00 | AAPL | Stock | 26.955 | 26.955 | 26.955 | 26.955 | 14800.0 |
| 2016-08-08 08:30:00 | AAPL | Stock | 26.955 | 26.9575 | 26.9525 | 26.9575 | 24144.0 |
| 2016-08-08 08:35:00 | AAPL | Stock | 26.9525 | 26.955 | 26.95 | 26.955 | 20580.0 |
| 2016-08-08 08:40:00 | AAPL | Stock | 26.95 | 26.9525 | 26.9325 | 26.94 | 73200.0 |
| 2016-08-08 08:45:00 | AAPL | Stock | 26.94 | 26.94 | 26.93 | 26.93 | 29192.0 |
| 2016-08-08 08:50:00 | AAPL | Stock | 26.93 | 26.935 | 26.92 | 26.92 | 18640.0 |
| 2016-08-08 08:55:00 | AAPL | Stock | 26.9225 | 26.925 | 26.915 | 26.915 | 52800.0 |
| 2016-08-08 09:00:00 | AAPL | Stock | 26.925 | 26.9375 | 26.92 | 26.9325 | 13980.0 |
| 2016-08-08 09:05:00 | AAPL | Stock | 26.94 | 26.94 | 26.9325 | 26.94 | 1600.0 |
| 2016-08-08 09:10:00 | AAPL | Stock | 26.9325 | 26.9375 | 26.92 | 26.9375 | 20716.0 |
| 2016-08-08 09:15:00 | AAPL | Stock | 26.93 | 26.9325 | 26.9275 | 26.9325 | 6720.0 |
| 2016-08-08 09:20:00 | AAPL | Stock | 26.9275 | 26.9375 | 26.92 | 26.925 | 21400.0 |
| 2016-08-08 09:25:00 | AAPL | Stock | 26.925 | 26.925 | 26.875 | 26.8775 | 187948.0 |
| 2016-08-08 09:30:00 | AAPL | Stock | 26.8875 | 26.99 | 26.875 | 26.9425 | 6520508.0 |
| 2016-08-08 09:35:00 | AAPL | Stock | 26.94 | 26.9825 | 26.855 | 26.8875 | 4497104.0 |
| 2016-08-08 09:40:00 | AAPL | Stock | 26.885 | 26.9425 | 26.8825 | 26.895 | 2415760.0 |
| 2016-08-08 09:45:00 | AAPL | Stock | 26.8975 | 26.91 | 26.835 | 26.8475 | 3407788.0 |
| 2016-08-08 09:50:00 | AAPL | Stock | 26.8475 | 26.8525 | 26.79 | 26.8175 | 2368724.0 |
| 2016-08-08 09:55:00 | AAPL | Stock | 26.82 | 26.875 | 26.8175 | 26.8552 | 2039576.0 |
| 2016-08-08 10:00:00 | AAPL | Stock | 26.8562 | 26.8925 | 26.85 | 26.8775 | 1558472.0 |
| 2016-08-08 10:05:00 | AAPL | Stock | 26.88 | 26.925 | 26.875 | 26.9175 | 1978384.0 |
| 2016-08-08 10:10:00 | AAPL | Stock | 26.9175 | 26.925 | 26.89 | 26.895 | 1264512.0 |
| 2016-08-08 10:15:00 | AAPL | Stock | 26.8975 | 26.9 | 26.8725 | 26.875 | 1103092.0 |
| 2016-08-08 10:20:00 | AAPL | Stock | 26.8725 | 26.875 | 26.856 | 26.865 | 1169708.0 |
| 2016-08-08 10:25:00 | AAPL | Stock | 26.865 | 26.8675 | 26.855 | 26.865 | 1251700.0 |
> showing 50 of 353,686 rows — these rows as CSV