PREVIEW / stock_5min / 2016-12-15
file: by_date/stock_5min/2016/2016-12-15.parquet size: 5.6 MB rows: 370,530 symbols: 3,170
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-12-15 04:05:00 | AAPL | Stock | 28.755 | 28.755 | 28.755 | 28.755 | 400.0 |
| 2016-12-15 04:15:00 | AAPL | Stock | 28.7525 | 28.7525 | 28.7525 | 28.7525 | 400.0 |
| 2016-12-15 05:00:00 | AAPL | Stock | 28.75 | 28.75 | 28.72 | 28.72 | 1096.0 |
| 2016-12-15 05:10:00 | AAPL | Stock | 28.705 | 28.705 | 28.6875 | 28.6875 | 3340.0 |
| 2016-12-15 05:35:00 | AAPL | Stock | 28.7075 | 28.7075 | 28.7075 | 28.7075 | 1316.0 |
| 2016-12-15 05:40:00 | AAPL | Stock | 28.7075 | 28.7075 | 28.7075 | 28.7075 | 400.0 |
| 2016-12-15 05:45:00 | AAPL | Stock | 28.725 | 28.725 | 28.725 | 28.725 | 1156.0 |
| 2016-12-15 06:00:00 | AAPL | Stock | 28.7075 | 28.7075 | 28.7075 | 28.7075 | 768.0 |
| 2016-12-15 06:15:00 | AAPL | Stock | 28.74 | 28.74 | 28.72 | 28.72 | 17408.0 |
| 2016-12-15 06:35:00 | AAPL | Stock | 28.74 | 28.74 | 28.675 | 28.68 | 2020.0 |
| 2016-12-15 06:50:00 | AAPL | Stock | 28.6875 | 28.6875 | 28.67 | 28.67 | 5060.0 |
| 2016-12-15 06:55:00 | AAPL | Stock | 28.68 | 28.68 | 28.675 | 28.675 | 2352.0 |
| 2016-12-15 07:00:00 | AAPL | Stock | 28.7 | 28.7 | 28.6775 | 28.6775 | 1664.0 |
| 2016-12-15 07:05:00 | AAPL | Stock | 28.6875 | 28.6875 | 28.6875 | 28.6875 | 400.0 |
| 2016-12-15 07:10:00 | AAPL | Stock | 28.7 | 28.7 | 28.69 | 28.69 | 1156.0 |
| 2016-12-15 07:15:00 | AAPL | Stock | 28.6825 | 28.6825 | 28.6825 | 28.6825 | 2000.0 |
| 2016-12-15 07:25:00 | AAPL | Stock | 28.68 | 28.68 | 28.6775 | 28.6775 | 2000.0 |
| 2016-12-15 07:30:00 | AAPL | Stock | 28.68 | 28.68 | 28.675 | 28.675 | 10496.0 |
| 2016-12-15 07:35:00 | AAPL | Stock | 28.675 | 28.6875 | 28.675 | 28.68 | 18052.0 |
| 2016-12-15 07:40:00 | AAPL | Stock | 28.675 | 28.68 | 28.6725 | 28.68 | 23416.0 |
| 2016-12-15 07:45:00 | AAPL | Stock | 28.675 | 28.6875 | 28.675 | 28.6875 | 2000.0 |
| 2016-12-15 07:50:00 | AAPL | Stock | 28.695 | 28.725 | 28.695 | 28.725 | 14420.0 |
| 2016-12-15 07:55:00 | AAPL | Stock | 28.7225 | 28.7225 | 28.7175 | 28.7175 | 800.0 |
| 2016-12-15 08:00:00 | AAPL | Stock | 28.68 | 28.7275 | 28.68 | 28.72 | 25812.0 |
| 2016-12-15 08:05:00 | AAPL | Stock | 28.72 | 28.72 | 28.7125 | 28.72 | 17640.0 |
| 2016-12-15 08:10:00 | AAPL | Stock | 28.73 | 28.73 | 28.725 | 28.7275 | 2000.0 |
| 2016-12-15 08:15:00 | AAPL | Stock | 28.74 | 28.7425 | 28.73 | 28.7325 | 11040.0 |
| 2016-12-15 08:20:00 | AAPL | Stock | 28.7275 | 28.7325 | 28.7275 | 28.73 | 12440.0 |
| 2016-12-15 08:25:00 | AAPL | Stock | 28.745 | 28.765 | 28.745 | 28.765 | 4000.0 |
| 2016-12-15 08:30:00 | AAPL | Stock | 28.75 | 28.7925 | 28.75 | 28.7875 | 14156.0 |
| 2016-12-15 08:35:00 | AAPL | Stock | 28.7925 | 28.7975 | 28.75 | 28.75 | 93672.0 |
| 2016-12-15 08:40:00 | AAPL | Stock | 28.75 | 28.775 | 28.7375 | 28.775 | 13000.0 |
| 2016-12-15 08:45:00 | AAPL | Stock | 28.755 | 28.7875 | 28.755 | 28.7875 | 27816.0 |
| 2016-12-15 08:50:00 | AAPL | Stock | 28.7875 | 28.7875 | 28.7625 | 28.7625 | 29180.0 |
| 2016-12-15 08:55:00 | AAPL | Stock | 28.7775 | 28.7775 | 28.7775 | 28.7775 | 4000.0 |
| 2016-12-15 09:00:00 | AAPL | Stock | 28.7875 | 28.7875 | 28.7725 | 28.7725 | 32520.0 |
| 2016-12-15 09:05:00 | AAPL | Stock | 28.775 | 28.825 | 28.7725 | 28.8175 | 22360.0 |
| 2016-12-15 09:10:00 | AAPL | Stock | 28.82 | 28.82 | 28.8025 | 28.82 | 4600.0 |
| 2016-12-15 09:15:00 | AAPL | Stock | 28.82 | 28.8425 | 28.82 | 28.825 | 53188.0 |
| 2016-12-15 09:20:00 | AAPL | Stock | 28.825 | 28.84 | 28.8075 | 28.8075 | 33228.0 |
| 2016-12-15 09:25:00 | AAPL | Stock | 28.8075 | 28.8475 | 28.805 | 28.8475 | 53460.0 |
| 2016-12-15 09:30:00 | AAPL | Stock | 28.845 | 29.1402 | 28.8075 | 29.1138 | 8073700.0 |
| 2016-12-15 09:35:00 | AAPL | Stock | 29.115 | 29.1625 | 29.02 | 29.0925 | 4550624.0 |
| 2016-12-15 09:40:00 | AAPL | Stock | 29.0925 | 29.1625 | 29.055 | 29.1375 | 3372836.0 |
| 2016-12-15 09:45:00 | AAPL | Stock | 29.1375 | 29.1825 | 29.1125 | 29.1125 | 3240116.0 |
| 2016-12-15 09:50:00 | AAPL | Stock | 29.1125 | 29.1275 | 29.065 | 29.12 | 2356728.0 |
| 2016-12-15 09:55:00 | AAPL | Stock | 29.12 | 29.15 | 29.0688 | 29.1175 | 2509060.0 |
| 2016-12-15 10:00:00 | AAPL | Stock | 29.12 | 29.125 | 29.0375 | 29.0925 | 1955736.0 |
| 2016-12-15 10:05:00 | AAPL | Stock | 29.0938 | 29.1025 | 29.0425 | 29.055 | 1453964.0 |
| 2016-12-15 10:10:00 | AAPL | Stock | 29.055 | 29.075 | 29.0125 | 29.0425 | 1631576.0 |
> showing 50 of 370,530 rows — these rows as CSV