PREVIEW / stock_5min / 2016-11-14
file: by_date/stock_5min/2016/2016-11-14.parquet size: 5.8 MB rows: 379,605 symbols: 3,183
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-14 04:15:00 | AAPL | Stock | 27.195 | 27.195 | 27.195 | 27.195 | 400.0 |
| 2016-11-14 04:30:00 | AAPL | Stock | 27.195 | 27.195 | 27.195 | 27.195 | 7140.0 |
| 2016-11-14 05:00:00 | AAPL | Stock | 27.2125 | 27.2125 | 27.21 | 27.21 | 2400.0 |
| 2016-11-14 05:40:00 | AAPL | Stock | 27.205 | 27.205 | 27.1725 | 27.1725 | 4568.0 |
| 2016-11-14 06:15:00 | AAPL | Stock | 27.1425 | 27.1425 | 27.08 | 27.08 | 5452.0 |
| 2016-11-14 06:20:00 | AAPL | Stock | 27.08 | 27.08 | 27.0575 | 27.0575 | 1680.0 |
| 2016-11-14 06:25:00 | AAPL | Stock | 27.075 | 27.075 | 27.075 | 27.075 | 800.0 |
| 2016-11-14 06:45:00 | AAPL | Stock | 27.0325 | 27.0325 | 27.0325 | 27.0325 | 1600.0 |
| 2016-11-14 06:50:00 | AAPL | Stock | 27.0725 | 27.0725 | 27.0725 | 27.0725 | 1200.0 |
| 2016-11-14 07:00:00 | AAPL | Stock | 27.055 | 27.065 | 27.055 | 27.065 | 2000.0 |
| 2016-11-14 07:05:00 | AAPL | Stock | 27.0625 | 27.0625 | 27.0625 | 27.0625 | 3760.0 |
| 2016-11-14 07:10:00 | AAPL | Stock | 27.0825 | 27.0825 | 27.0825 | 27.0825 | 640.0 |
| 2016-11-14 07:15:00 | AAPL | Stock | 27.0625 | 27.0625 | 27.0625 | 27.0625 | 400.0 |
| 2016-11-14 07:20:00 | AAPL | Stock | 27.065 | 27.065 | 27.0625 | 27.0625 | 3552.0 |
| 2016-11-14 07:25:00 | AAPL | Stock | 27.085 | 27.085 | 27.085 | 27.085 | 2000.0 |
| 2016-11-14 07:30:00 | AAPL | Stock | 27.075 | 27.075 | 27.05 | 27.05 | 4044.0 |
| 2016-11-14 07:40:00 | AAPL | Stock | 27.0925 | 27.095 | 27.0925 | 27.095 | 1600.0 |
| 2016-11-14 07:50:00 | AAPL | Stock | 27.0875 | 27.0875 | 27.0875 | 27.0875 | 4000.0 |
| 2016-11-14 07:55:00 | AAPL | Stock | 27.1 | 27.11 | 27.1 | 27.11 | 5484.0 |
| 2016-11-14 08:00:00 | AAPL | Stock | 27.1 | 27.11 | 27.0875 | 27.1 | 35036.0 |
| 2016-11-14 08:05:00 | AAPL | Stock | 27.1 | 27.1 | 27.06 | 27.0625 | 21300.0 |
| 2016-11-14 08:10:00 | AAPL | Stock | 27.0525 | 27.0525 | 27.04 | 27.04 | 30828.0 |
| 2016-11-14 08:15:00 | AAPL | Stock | 27.05 | 27.05 | 27.035 | 27.04 | 17604.0 |
| 2016-11-14 08:20:00 | AAPL | Stock | 27.0475 | 27.0475 | 27.025 | 27.0475 | 25816.0 |
| 2016-11-14 08:25:00 | AAPL | Stock | 27.05 | 27.065 | 27.05 | 27.065 | 21644.0 |
| 2016-11-14 08:30:00 | AAPL | Stock | 27.065 | 27.07 | 27.0625 | 27.07 | 19164.0 |
| 2016-11-14 08:35:00 | AAPL | Stock | 27.065 | 27.065 | 27.035 | 27.035 | 47748.0 |
| 2016-11-14 08:40:00 | AAPL | Stock | 27.0325 | 27.0375 | 27.0125 | 27.02 | 27820.0 |
| 2016-11-14 08:45:00 | AAPL | Stock | 27.02 | 27.025 | 27.01 | 27.025 | 45996.0 |
| 2016-11-14 08:50:00 | AAPL | Stock | 27.0275 | 27.05 | 27.0275 | 27.0275 | 17600.0 |
| 2016-11-14 08:55:00 | AAPL | Stock | 27.0375 | 27.0375 | 27.01 | 27.0125 | 11800.0 |
| 2016-11-14 09:00:00 | AAPL | Stock | 27.0125 | 27.025 | 27.0125 | 27.025 | 11376.0 |
| 2016-11-14 09:05:00 | AAPL | Stock | 27.02 | 27.02 | 27.01 | 27.015 | 37816.0 |
| 2016-11-14 09:10:00 | AAPL | Stock | 27.0125 | 27.015 | 26.9675 | 26.9725 | 93584.0 |
| 2016-11-14 09:15:00 | AAPL | Stock | 26.9675 | 26.975 | 26.9625 | 26.975 | 12908.0 |
| 2016-11-14 09:20:00 | AAPL | Stock | 26.9975 | 27.03 | 26.9625 | 26.99 | 66132.0 |
| 2016-11-14 09:25:00 | AAPL | Stock | 26.985 | 26.985 | 26.9225 | 26.94 | 91060.0 |
| 2016-11-14 09:30:00 | AAPL | Stock | 26.9275 | 26.9522 | 26.7175 | 26.7375 | 5877424.0 |
| 2016-11-14 09:35:00 | AAPL | Stock | 26.735 | 26.8075 | 26.7025 | 26.7175 | 4451392.0 |
| 2016-11-14 09:40:00 | AAPL | Stock | 26.7225 | 26.73 | 26.6675 | 26.685 | 3272460.0 |
| 2016-11-14 09:45:00 | AAPL | Stock | 26.68 | 26.7175 | 26.635 | 26.635 | 3419576.0 |
| 2016-11-14 09:50:00 | AAPL | Stock | 26.6375 | 26.665 | 26.56 | 26.5822 | 3762808.0 |
| 2016-11-14 09:55:00 | AAPL | Stock | 26.5822 | 26.6275 | 26.5 | 26.51 | 3617916.0 |
| 2016-11-14 10:00:00 | AAPL | Stock | 26.5125 | 26.5125 | 26.3475 | 26.3525 | 5706240.0 |
| 2016-11-14 10:05:00 | AAPL | Stock | 26.355 | 26.48 | 26.3475 | 26.4598 | 6518448.0 |
| 2016-11-14 10:10:00 | AAPL | Stock | 26.4575 | 26.555 | 26.415 | 26.55 | 3636308.0 |
| 2016-11-14 10:15:00 | AAPL | Stock | 26.5502 | 26.58 | 26.4625 | 26.5025 | 3067740.0 |
| 2016-11-14 10:20:00 | AAPL | Stock | 26.5038 | 26.505 | 26.4275 | 26.47 | 2718896.0 |
| 2016-11-14 10:25:00 | AAPL | Stock | 26.4725 | 26.4838 | 26.38 | 26.4078 | 3395424.0 |
| 2016-11-14 10:30:00 | AAPL | Stock | 26.4075 | 26.415 | 26.3375 | 26.364 | 3360396.0 |
> showing 50 of 379,605 rows — these rows as CSV