PREVIEW / stock_5min / 2016-08-25
file: by_date/stock_5min/2016/2016-08-25.parquet size: 5.2 MB rows: 343,588 symbols: 3,252
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-25 04:00:00 | AAPL | Stock | 27.01 | 27.01 | 26.995 | 26.995 | 4004.0 |
| 2016-08-25 04:15:00 | AAPL | Stock | 26.9625 | 26.9625 | 26.9625 | 26.9625 | 400.0 |
| 2016-08-25 04:30:00 | AAPL | Stock | 26.95 | 26.95 | 26.95 | 26.95 | 400.0 |
| 2016-08-25 04:50:00 | AAPL | Stock | 26.9375 | 26.9375 | 26.9375 | 26.9375 | 400.0 |
| 2016-08-25 05:30:00 | AAPL | Stock | 26.9575 | 26.9575 | 26.9575 | 26.9575 | 1968.0 |
| 2016-08-25 05:35:00 | AAPL | Stock | 26.9425 | 26.9425 | 26.9425 | 26.9425 | 1600.0 |
| 2016-08-25 05:45:00 | AAPL | Stock | 26.9425 | 26.9425 | 26.9425 | 26.9425 | 800.0 |
| 2016-08-25 05:50:00 | AAPL | Stock | 26.9275 | 26.9275 | 26.9275 | 26.9275 | 800.0 |
| 2016-08-25 06:00:00 | AAPL | Stock | 26.94 | 26.9425 | 26.94 | 26.9425 | 1800.0 |
| 2016-08-25 07:15:00 | AAPL | Stock | 26.9225 | 26.9225 | 26.9225 | 26.9225 | 3600.0 |
| 2016-08-25 07:35:00 | AAPL | Stock | 26.9075 | 26.9075 | 26.9075 | 26.9075 | 600.0 |
| 2016-08-25 07:45:00 | AAPL | Stock | 26.9 | 26.9025 | 26.8875 | 26.895 | 8692.0 |
| 2016-08-25 07:55:00 | AAPL | Stock | 26.925 | 26.925 | 26.925 | 26.925 | 1000.0 |
| 2016-08-25 08:00:00 | AAPL | Stock | 26.94 | 26.94 | 26.9 | 26.9125 | 18604.0 |
| 2016-08-25 08:05:00 | AAPL | Stock | 26.915 | 26.9175 | 26.9125 | 26.9125 | 5244.0 |
| 2016-08-25 08:10:00 | AAPL | Stock | 26.9125 | 26.9125 | 26.9 | 26.905 | 7936.0 |
| 2016-08-25 08:15:00 | AAPL | Stock | 26.905 | 26.905 | 26.8975 | 26.8975 | 8328.0 |
| 2016-08-25 08:20:00 | AAPL | Stock | 26.8975 | 26.9 | 26.8975 | 26.8975 | 8400.0 |
| 2016-08-25 08:25:00 | AAPL | Stock | 26.9 | 26.9 | 26.895 | 26.8975 | 11132.0 |
| 2016-08-25 08:30:00 | AAPL | Stock | 26.8975 | 26.915 | 26.8975 | 26.905 | 29952.0 |
| 2016-08-25 08:35:00 | AAPL | Stock | 26.91 | 26.9175 | 26.9025 | 26.9175 | 11308.0 |
| 2016-08-25 08:40:00 | AAPL | Stock | 26.915 | 26.915 | 26.9025 | 26.9025 | 8464.0 |
| 2016-08-25 08:45:00 | AAPL | Stock | 26.9125 | 26.915 | 26.905 | 26.915 | 5600.0 |
| 2016-08-25 08:50:00 | AAPL | Stock | 26.9075 | 26.91 | 26.885 | 26.89 | 114164.0 |
| 2016-08-25 08:55:00 | AAPL | Stock | 26.89 | 26.8975 | 26.8875 | 26.89 | 4452.0 |
| 2016-08-25 09:00:00 | AAPL | Stock | 26.8925 | 26.9075 | 26.8925 | 26.9075 | 8568.0 |
| 2016-08-25 09:05:00 | AAPL | Stock | 26.9075 | 26.9075 | 26.88 | 26.8875 | 25432.0 |
| 2016-08-25 09:10:00 | AAPL | Stock | 26.8875 | 26.895 | 26.8875 | 26.895 | 17476.0 |
| 2016-08-25 09:15:00 | AAPL | Stock | 26.89 | 26.905 | 26.89 | 26.905 | 5376.0 |
| 2016-08-25 09:20:00 | AAPL | Stock | 26.9075 | 26.9125 | 26.9025 | 26.9075 | 7200.0 |
| 2016-08-25 09:25:00 | AAPL | Stock | 26.9025 | 26.905 | 26.8375 | 26.85 | 102100.0 |
| 2016-08-25 09:30:00 | AAPL | Stock | 26.8475 | 26.85 | 26.6925 | 26.735 | 7550876.0 |
| 2016-08-25 09:35:00 | AAPL | Stock | 26.7325 | 26.7775 | 26.7225 | 26.76 | 3747948.0 |
| 2016-08-25 09:40:00 | AAPL | Stock | 26.7578 | 26.79 | 26.74 | 26.765 | 3541628.0 |
| 2016-08-25 09:45:00 | AAPL | Stock | 26.7625 | 26.775 | 26.7425 | 26.755 | 2134632.0 |
| 2016-08-25 09:50:00 | AAPL | Stock | 26.755 | 26.755 | 26.7125 | 26.715 | 2167404.0 |
| 2016-08-25 09:55:00 | AAPL | Stock | 26.7125 | 26.7375 | 26.7 | 26.7025 | 2220840.0 |
| 2016-08-25 10:00:00 | AAPL | Stock | 26.705 | 26.705 | 26.67 | 26.691 | 3722636.0 |
| 2016-08-25 10:05:00 | AAPL | Stock | 26.6912 | 26.7425 | 26.6875 | 26.725 | 2103244.0 |
| 2016-08-25 10:10:00 | AAPL | Stock | 26.725 | 26.75 | 26.7125 | 26.73 | 1555624.0 |
| 2016-08-25 10:15:00 | AAPL | Stock | 26.73 | 26.75 | 26.7 | 26.7475 | 1429464.0 |
| 2016-08-25 10:20:00 | AAPL | Stock | 26.7475 | 26.79 | 26.7412 | 26.7768 | 1635516.0 |
| 2016-08-25 10:25:00 | AAPL | Stock | 26.777 | 26.7825 | 26.7575 | 26.775 | 1255408.0 |
| 2016-08-25 10:30:00 | AAPL | Stock | 26.7725 | 26.795 | 26.76 | 26.7725 | 1069608.0 |
| 2016-08-25 10:35:00 | AAPL | Stock | 26.775 | 26.785 | 26.7178 | 26.724 | 1701632.0 |
| 2016-08-25 10:40:00 | AAPL | Stock | 26.7225 | 26.7625 | 26.72 | 26.76 | 829748.0 |
| 2016-08-25 10:45:00 | AAPL | Stock | 26.76 | 26.7612 | 26.7362 | 26.7565 | 699876.0 |
| 2016-08-25 10:50:00 | AAPL | Stock | 26.7552 | 26.7725 | 26.74 | 26.76 | 1067940.0 |
| 2016-08-25 10:55:00 | AAPL | Stock | 26.76 | 26.8062 | 26.7578 | 26.8 | 989652.0 |
| 2016-08-25 11:00:00 | AAPL | Stock | 26.8 | 26.85 | 26.795 | 26.846 | 1433924.0 |
> showing 50 of 343,588 rows — these rows as CSV