PREVIEW / stock_5min / 2015-11-17
file: by_date/stock_5min/2015/2015-11-17.parquet size: 5.4 MB rows: 360,071 symbols: 3,409
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 |
|---|---|---|---|---|---|---|---|
| 2015-11-17 04:00:00 | AAPL | Stock | 28.5225 | 28.5225 | 28.5225 | 28.5225 | 400.0 |
| 2015-11-17 04:10:00 | AAPL | Stock | 28.595 | 28.595 | 28.595 | 28.595 | 600.0 |
| 2015-11-17 04:25:00 | AAPL | Stock | 28.595 | 28.595 | 28.595 | 28.595 | 400.0 |
| 2015-11-17 04:35:00 | AAPL | Stock | 28.65 | 28.65 | 28.63 | 28.63 | 2468.0 |
| 2015-11-17 04:45:00 | AAPL | Stock | 28.625 | 28.65 | 28.625 | 28.65 | 2148.0 |
| 2015-11-17 04:55:00 | AAPL | Stock | 28.65 | 28.65 | 28.65 | 28.65 | 400.0 |
| 2015-11-17 05:05:00 | AAPL | Stock | 28.6425 | 28.6425 | 28.6425 | 28.6425 | 400.0 |
| 2015-11-17 05:15:00 | AAPL | Stock | 28.65 | 28.65 | 28.65 | 28.65 | 836.0 |
| 2015-11-17 06:05:00 | AAPL | Stock | 28.6625 | 28.675 | 28.6625 | 28.675 | 4636.0 |
| 2015-11-17 06:10:00 | AAPL | Stock | 28.6425 | 28.6425 | 28.6425 | 28.6425 | 1600.0 |
| 2015-11-17 06:15:00 | AAPL | Stock | 28.675 | 28.6925 | 28.675 | 28.6925 | 900.0 |
| 2015-11-17 06:25:00 | AAPL | Stock | 28.6875 | 28.6875 | 28.6875 | 28.6875 | 400.0 |
| 2015-11-17 06:35:00 | AAPL | Stock | 28.675 | 28.675 | 28.675 | 28.675 | 1144.0 |
| 2015-11-17 06:40:00 | AAPL | Stock | 28.675 | 28.685 | 28.675 | 28.685 | 8000.0 |
| 2015-11-17 06:55:00 | AAPL | Stock | 28.67 | 28.6925 | 28.67 | 28.6775 | 14460.0 |
| 2015-11-17 07:00:00 | AAPL | Stock | 28.675 | 28.675 | 28.675 | 28.675 | 1200.0 |
| 2015-11-17 07:05:00 | AAPL | Stock | 28.6775 | 28.6775 | 28.67 | 28.67 | 16400.0 |
| 2015-11-17 07:10:00 | AAPL | Stock | 28.655 | 28.655 | 28.655 | 28.655 | 5960.0 |
| 2015-11-17 07:15:00 | AAPL | Stock | 28.6675 | 28.6875 | 28.6675 | 28.6875 | 11200.0 |
| 2015-11-17 07:20:00 | AAPL | Stock | 28.685 | 28.705 | 28.675 | 28.7 | 17960.0 |
| 2015-11-17 07:25:00 | AAPL | Stock | 28.69 | 28.7725 | 28.69 | 28.75 | 44020.0 |
| 2015-11-17 07:30:00 | AAPL | Stock | 28.7175 | 28.7225 | 28.705 | 28.705 | 8156.0 |
| 2015-11-17 07:35:00 | AAPL | Stock | 28.71 | 28.7175 | 28.6875 | 28.6875 | 23300.0 |
| 2015-11-17 07:40:00 | AAPL | Stock | 28.6875 | 28.6875 | 28.68 | 28.68 | 1520.0 |
| 2015-11-17 07:45:00 | AAPL | Stock | 28.6975 | 28.7375 | 28.675 | 28.715 | 21776.0 |
| 2015-11-17 07:50:00 | AAPL | Stock | 28.715 | 28.72 | 28.7125 | 28.7125 | 3800.0 |
| 2015-11-17 07:55:00 | AAPL | Stock | 28.7 | 28.71 | 28.6775 | 28.7 | 13568.0 |
| 2015-11-17 08:00:00 | AAPL | Stock | 28.71 | 28.735 | 28.6425 | 28.7075 | 109140.0 |
| 2015-11-17 08:05:00 | AAPL | Stock | 28.6875 | 28.7975 | 28.6875 | 28.7125 | 29428.0 |
| 2015-11-17 08:10:00 | AAPL | Stock | 28.7125 | 28.72 | 28.69 | 28.6975 | 29324.0 |
| 2015-11-17 08:15:00 | AAPL | Stock | 28.7075 | 28.71 | 28.7075 | 28.71 | 11556.0 |
| 2015-11-17 08:20:00 | AAPL | Stock | 28.71 | 28.71 | 28.6875 | 28.6875 | 24028.0 |
| 2015-11-17 08:25:00 | AAPL | Stock | 28.6875 | 28.7125 | 28.6775 | 28.685 | 28000.0 |
| 2015-11-17 08:30:00 | AAPL | Stock | 28.6775 | 28.6875 | 28.6625 | 28.6875 | 32692.0 |
| 2015-11-17 08:35:00 | AAPL | Stock | 28.7025 | 28.7175 | 28.6925 | 28.71 | 26172.0 |
| 2015-11-17 08:40:00 | AAPL | Stock | 28.71 | 28.715 | 28.7 | 28.7 | 13848.0 |
| 2015-11-17 08:45:00 | AAPL | Stock | 28.6975 | 28.715 | 28.6875 | 28.6875 | 34384.0 |
| 2015-11-17 08:50:00 | AAPL | Stock | 28.695 | 28.695 | 28.6875 | 28.6875 | 8724.0 |
| 2015-11-17 08:55:00 | AAPL | Stock | 28.6875 | 28.6975 | 28.6875 | 28.6875 | 31936.0 |
| 2015-11-17 09:00:00 | AAPL | Stock | 28.6875 | 28.69 | 28.67 | 28.68 | 54128.0 |
| 2015-11-17 09:05:00 | AAPL | Stock | 28.675 | 28.6825 | 28.675 | 28.6825 | 7440.0 |
| 2015-11-17 09:10:00 | AAPL | Stock | 28.6875 | 28.6975 | 28.6725 | 28.6725 | 38268.0 |
| 2015-11-17 09:15:00 | AAPL | Stock | 28.685 | 28.685 | 28.6625 | 28.6625 | 7200.0 |
| 2015-11-17 09:20:00 | AAPL | Stock | 28.675 | 28.685 | 28.6675 | 28.685 | 30708.0 |
| 2015-11-17 09:25:00 | AAPL | Stock | 28.685 | 28.73 | 28.6675 | 28.73 | 219716.0 |
| 2015-11-17 09:30:00 | AAPL | Stock | 28.73 | 28.7625 | 28.62 | 28.6375 | 6034716.0 |
| 2015-11-17 09:35:00 | AAPL | Stock | 28.6375 | 28.7025 | 28.5775 | 28.5975 | 2981328.0 |
| 2015-11-17 09:40:00 | AAPL | Stock | 28.5975 | 28.6125 | 28.53 | 28.58 | 2545720.0 |
| 2015-11-17 09:45:00 | AAPL | Stock | 28.58 | 28.6175 | 28.5525 | 28.5625 | 2314500.0 |
| 2015-11-17 09:50:00 | AAPL | Stock | 28.5612 | 28.58 | 28.4788 | 28.48 | 2850124.0 |
> showing 50 of 360,071 rows — these rows as CSV