PREVIEW / stock_5min / 2016-11-30
file: by_date/stock_5min/2016/2016-11-30.parquet size: 5.6 MB rows: 366,672 symbols: 3,189
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-11-30 06:15:00 | AAPL | Stock | 27.865 | 27.865 | 27.865 | 27.865 | 800.0 |
| 2016-11-30 07:15:00 | AAPL | Stock | 27.875 | 27.935 | 27.875 | 27.935 | 2128.0 |
| 2016-11-30 07:40:00 | AAPL | Stock | 27.8925 | 27.8925 | 27.8925 | 27.8925 | 1760.0 |
| 2016-11-30 07:55:00 | AAPL | Stock | 27.875 | 27.875 | 27.875 | 27.875 | 1680.0 |
| 2016-11-30 08:00:00 | AAPL | Stock | 27.935 | 27.9525 | 27.85 | 27.875 | 2200.0 |
| 2016-11-30 08:05:00 | AAPL | Stock | 27.8875 | 27.895 | 27.8875 | 27.895 | 8332.0 |
| 2016-11-30 08:10:00 | AAPL | Stock | 27.8875 | 27.91 | 27.8525 | 27.8525 | 21548.0 |
| 2016-11-30 08:15:00 | AAPL | Stock | 27.8475 | 27.8475 | 27.8475 | 27.8475 | 3200.0 |
| 2016-11-30 08:20:00 | AAPL | Stock | 27.855 | 27.855 | 27.855 | 27.855 | 8500.0 |
| 2016-11-30 08:25:00 | AAPL | Stock | 27.85 | 27.85 | 27.85 | 27.85 | 784.0 |
| 2016-11-30 08:30:00 | AAPL | Stock | 27.8825 | 27.8975 | 27.8825 | 27.8975 | 1200.0 |
| 2016-11-30 08:35:00 | AAPL | Stock | 27.8875 | 27.8975 | 27.8875 | 27.895 | 3184.0 |
| 2016-11-30 08:40:00 | AAPL | Stock | 27.89 | 27.9025 | 27.89 | 27.9025 | 7176.0 |
| 2016-11-30 08:45:00 | AAPL | Stock | 27.915 | 27.9275 | 27.9125 | 27.925 | 13928.0 |
| 2016-11-30 08:50:00 | AAPL | Stock | 27.935 | 27.9425 | 27.925 | 27.935 | 33672.0 |
| 2016-11-30 08:55:00 | AAPL | Stock | 27.93 | 27.9375 | 27.925 | 27.9375 | 16452.0 |
| 2016-11-30 09:00:00 | AAPL | Stock | 27.9425 | 27.9425 | 27.9425 | 27.9425 | 2800.0 |
| 2016-11-30 09:05:00 | AAPL | Stock | 27.9425 | 27.9575 | 27.9425 | 27.9575 | 14620.0 |
| 2016-11-30 09:10:00 | AAPL | Stock | 27.9575 | 27.9675 | 27.9575 | 27.9575 | 5404.0 |
| 2016-11-30 09:15:00 | AAPL | Stock | 27.9625 | 27.985 | 27.96 | 27.985 | 7880.0 |
| 2016-11-30 09:20:00 | AAPL | Stock | 27.985 | 27.995 | 27.975 | 27.9875 | 45104.0 |
| 2016-11-30 09:25:00 | AAPL | Stock | 27.99 | 27.9975 | 27.9 | 27.9 | 155784.0 |
| 2016-11-30 09:30:00 | AAPL | Stock | 27.9025 | 28.05 | 27.8875 | 27.9325 | 4349188.0 |
| 2016-11-30 09:35:00 | AAPL | Stock | 27.9375 | 27.9775 | 27.925 | 27.95 | 1518360.0 |
| 2016-11-30 09:40:00 | AAPL | Stock | 27.9525 | 28.02 | 27.9525 | 28.0125 | 1461364.0 |
| 2016-11-30 09:45:00 | AAPL | Stock | 28.0125 | 28.0152 | 27.925 | 27.9375 | 1795912.0 |
| 2016-11-30 09:50:00 | AAPL | Stock | 27.9375 | 27.9425 | 27.89 | 27.905 | 1576492.0 |
| 2016-11-30 09:55:00 | AAPL | Stock | 27.9075 | 27.92 | 27.88 | 27.9175 | 1502364.0 |
| 2016-11-30 10:00:00 | AAPL | Stock | 27.915 | 27.9175 | 27.8848 | 27.8898 | 1536112.0 |
| 2016-11-30 10:05:00 | AAPL | Stock | 27.8875 | 27.905 | 27.855 | 27.9 | 1858592.0 |
| 2016-11-30 10:10:00 | AAPL | Stock | 27.9 | 27.917 | 27.87 | 27.88 | 1210116.0 |
| 2016-11-30 10:15:00 | AAPL | Stock | 27.8825 | 27.885 | 27.7925 | 27.793 | 1777480.0 |
| 2016-11-30 10:20:00 | AAPL | Stock | 27.7925 | 27.7962 | 27.7075 | 27.73 | 3092776.0 |
| 2016-11-30 10:25:00 | AAPL | Stock | 27.732 | 27.77 | 27.715 | 27.755 | 1864328.0 |
| 2016-11-30 10:30:00 | AAPL | Stock | 27.755 | 27.7625 | 27.635 | 27.705 | 3795660.0 |
| 2016-11-30 10:35:00 | AAPL | Stock | 27.7025 | 27.715 | 27.6825 | 27.695 | 1451032.0 |
| 2016-11-30 10:40:00 | AAPL | Stock | 27.6925 | 27.715 | 27.6875 | 27.7 | 1692112.0 |
| 2016-11-30 10:45:00 | AAPL | Stock | 27.6975 | 27.7025 | 27.675 | 27.6875 | 1150984.0 |
| 2016-11-30 10:50:00 | AAPL | Stock | 27.69 | 27.705 | 27.6775 | 27.6992 | 919820.0 |
| 2016-11-30 10:55:00 | AAPL | Stock | 27.7 | 27.735 | 27.6962 | 27.7135 | 1390008.0 |
| 2016-11-30 11:00:00 | AAPL | Stock | 27.7138 | 27.73 | 27.7038 | 27.7088 | 567188.0 |
| 2016-11-30 11:05:00 | AAPL | Stock | 27.7098 | 27.7675 | 27.7025 | 27.755 | 1587316.0 |
| 2016-11-30 11:10:00 | AAPL | Stock | 27.755 | 27.77 | 27.7175 | 27.7275 | 1699196.0 |
| 2016-11-30 11:15:00 | AAPL | Stock | 27.7288 | 27.73 | 27.7 | 27.7125 | 837092.0 |
| 2016-11-30 11:20:00 | AAPL | Stock | 27.7125 | 27.7162 | 27.6925 | 27.7052 | 904728.0 |
| 2016-11-30 11:25:00 | AAPL | Stock | 27.7062 | 27.71 | 27.6625 | 27.6665 | 1022560.0 |
| 2016-11-30 11:30:00 | AAPL | Stock | 27.6675 | 27.6875 | 27.6612 | 27.665 | 1227676.0 |
| 2016-11-30 11:35:00 | AAPL | Stock | 27.666 | 27.6675 | 27.645 | 27.645 | 1585096.0 |
| 2016-11-30 11:40:00 | AAPL | Stock | 27.6425 | 27.6925 | 27.6425 | 27.691 | 1095620.0 |
| 2016-11-30 11:45:00 | AAPL | Stock | 27.69 | 27.705 | 27.6575 | 27.6925 | 1036876.0 |
> showing 50 of 366,672 rows — these rows as CSV