PREVIEW / stock_5min / 2016-11-11
file: by_date/stock_5min/2016/2016-11-11.parquet size: 5.7 MB rows: 376,479 symbols: 3,186
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-11 04:00:00 | AAPL | Stock | 26.875 | 26.875 | 26.875 | 26.875 | 1600.0 |
| 2016-11-11 04:10:00 | AAPL | Stock | 26.75 | 26.75 | 26.75 | 26.75 | 400.0 |
| 2016-11-11 04:35:00 | AAPL | Stock | 26.7875 | 26.7875 | 26.75 | 26.75 | 960.0 |
| 2016-11-11 04:45:00 | AAPL | Stock | 26.625 | 26.625 | 26.625 | 26.625 | 1200.0 |
| 2016-11-11 05:00:00 | AAPL | Stock | 26.6625 | 26.6625 | 26.6625 | 26.6625 | 800.0 |
| 2016-11-11 05:10:00 | AAPL | Stock | 26.6875 | 26.6875 | 26.6875 | 26.6875 | 800.0 |
| 2016-11-11 05:15:00 | AAPL | Stock | 26.6875 | 26.6875 | 26.625 | 26.625 | 3996.0 |
| 2016-11-11 05:25:00 | AAPL | Stock | 26.685 | 26.685 | 26.66 | 26.66 | 800.0 |
| 2016-11-11 05:35:00 | AAPL | Stock | 26.625 | 26.625 | 26.625 | 26.625 | 400.0 |
| 2016-11-11 05:40:00 | AAPL | Stock | 26.6275 | 26.6425 | 26.6275 | 26.6425 | 4000.0 |
| 2016-11-11 06:00:00 | AAPL | Stock | 26.65 | 26.68 | 26.65 | 26.68 | 1152.0 |
| 2016-11-11 06:05:00 | AAPL | Stock | 26.68 | 26.68 | 26.6575 | 26.6575 | 2400.0 |
| 2016-11-11 06:10:00 | AAPL | Stock | 26.68 | 26.68 | 26.68 | 26.68 | 800.0 |
| 2016-11-11 06:20:00 | AAPL | Stock | 26.68 | 26.68 | 26.68 | 26.68 | 400.0 |
| 2016-11-11 06:25:00 | AAPL | Stock | 26.6425 | 26.65 | 26.635 | 26.635 | 44800.0 |
| 2016-11-11 06:40:00 | AAPL | Stock | 26.65 | 26.65 | 26.65 | 26.65 | 1376.0 |
| 2016-11-11 06:50:00 | AAPL | Stock | 26.66 | 26.68 | 26.66 | 26.68 | 2400.0 |
| 2016-11-11 06:55:00 | AAPL | Stock | 26.6825 | 26.7075 | 26.6825 | 26.7075 | 6016.0 |
| 2016-11-11 07:00:00 | AAPL | Stock | 26.7075 | 26.7425 | 26.6825 | 26.6825 | 6036.0 |
| 2016-11-11 07:05:00 | AAPL | Stock | 26.69 | 26.7 | 26.68 | 26.7 | 25356.0 |
| 2016-11-11 07:10:00 | AAPL | Stock | 26.7125 | 26.7125 | 26.7125 | 26.7125 | 2000.0 |
| 2016-11-11 07:15:00 | AAPL | Stock | 26.725 | 26.7325 | 26.725 | 26.73 | 5480.0 |
| 2016-11-11 07:20:00 | AAPL | Stock | 26.73 | 26.73 | 26.73 | 26.73 | 400.0 |
| 2016-11-11 07:40:00 | AAPL | Stock | 26.69 | 26.69 | 26.6825 | 26.6825 | 6800.0 |
| 2016-11-11 07:45:00 | AAPL | Stock | 26.6825 | 26.72 | 26.6825 | 26.7 | 3400.0 |
| 2016-11-11 07:50:00 | AAPL | Stock | 26.7 | 26.7325 | 26.7 | 26.7325 | 5400.0 |
| 2016-11-11 07:55:00 | AAPL | Stock | 26.7025 | 26.74 | 26.7025 | 26.74 | 3128.0 |
| 2016-11-11 08:00:00 | AAPL | Stock | 26.7425 | 26.7775 | 26.6825 | 26.775 | 85524.0 |
| 2016-11-11 08:05:00 | AAPL | Stock | 26.775 | 26.8 | 26.7625 | 26.775 | 17416.0 |
| 2016-11-11 08:10:00 | AAPL | Stock | 26.775 | 26.7875 | 26.775 | 26.7775 | 28996.0 |
| 2016-11-11 08:15:00 | AAPL | Stock | 26.7775 | 26.7875 | 26.77 | 26.7875 | 21852.0 |
| 2016-11-11 08:20:00 | AAPL | Stock | 26.795 | 26.8175 | 26.78 | 26.7875 | 24028.0 |
| 2016-11-11 08:25:00 | AAPL | Stock | 26.775 | 26.7975 | 26.77 | 26.7875 | 17140.0 |
| 2016-11-11 08:30:00 | AAPL | Stock | 26.7875 | 26.795 | 26.7775 | 26.7775 | 17380.0 |
| 2016-11-11 08:35:00 | AAPL | Stock | 26.7875 | 26.7875 | 26.7525 | 26.7725 | 6000.0 |
| 2016-11-11 08:40:00 | AAPL | Stock | 26.7825 | 26.7925 | 26.7825 | 26.7925 | 1000.0 |
| 2016-11-11 08:45:00 | AAPL | Stock | 26.7625 | 26.765 | 26.7625 | 26.7625 | 6744.0 |
| 2016-11-11 08:50:00 | AAPL | Stock | 26.7625 | 26.8 | 26.7625 | 26.77 | 27068.0 |
| 2016-11-11 08:55:00 | AAPL | Stock | 26.7925 | 26.8 | 26.7925 | 26.8 | 6120.0 |
| 2016-11-11 09:00:00 | AAPL | Stock | 26.8 | 26.815 | 26.77 | 26.8025 | 14436.0 |
| 2016-11-11 09:05:00 | AAPL | Stock | 26.8025 | 26.8175 | 26.8025 | 26.8175 | 26368.0 |
| 2016-11-11 09:10:00 | AAPL | Stock | 26.825 | 26.825 | 26.8 | 26.825 | 5352.0 |
| 2016-11-11 09:15:00 | AAPL | Stock | 26.805 | 26.835 | 26.805 | 26.835 | 7744.0 |
| 2016-11-11 09:20:00 | AAPL | Stock | 26.81 | 26.835 | 26.79 | 26.79 | 22752.0 |
| 2016-11-11 09:25:00 | AAPL | Stock | 26.79 | 26.8 | 26.7425 | 26.7725 | 110492.0 |
| 2016-11-11 09:30:00 | AAPL | Stock | 26.7575 | 26.8875 | 26.64 | 26.7 | 7134856.0 |
| 2016-11-11 09:35:00 | AAPL | Stock | 26.7 | 26.7925 | 26.6375 | 26.7775 | 3916088.0 |
| 2016-11-11 09:40:00 | AAPL | Stock | 26.7775 | 26.975 | 26.7625 | 26.9662 | 4607604.0 |
| 2016-11-11 09:45:00 | AAPL | Stock | 26.9625 | 27.075 | 26.9425 | 27.0725 | 4957548.0 |
| 2016-11-11 09:50:00 | AAPL | Stock | 27.0728 | 27.0775 | 26.8675 | 26.8675 | 3012748.0 |
> showing 50 of 376,479 rows — these rows as CSV