PREVIEW / stock_5min / 2013-10-15
file: by_date/stock_5min/2013/2013-10-15.parquet size: 5.2 MB rows: 344,623 symbols: 3,544
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 |
|---|---|---|---|---|---|---|---|
| 2013-10-15 04:00:00 | AAPL | Stock | 17.6786 | 17.7321 | 17.6786 | 17.7321 | 5880.0 |
| 2013-10-15 04:20:00 | AAPL | Stock | 17.7696 | 17.7696 | 17.7696 | 17.7696 | 2800.0 |
| 2013-10-15 04:40:00 | AAPL | Stock | 17.7811 | 17.7829 | 17.7811 | 17.7829 | 5600.0 |
| 2013-10-15 05:00:00 | AAPL | Stock | 17.7743 | 17.7743 | 17.7743 | 17.7743 | 8400.0 |
| 2013-10-15 05:05:00 | AAPL | Stock | 17.775 | 17.775 | 17.775 | 17.775 | 2800.0 |
| 2013-10-15 05:10:00 | AAPL | Stock | 17.7857 | 17.7996 | 17.7857 | 17.7996 | 5600.0 |
| 2013-10-15 05:45:00 | AAPL | Stock | 17.7939 | 17.7939 | 17.7939 | 17.7939 | 6888.0 |
| 2013-10-15 05:50:00 | AAPL | Stock | 17.81 | 17.8107 | 17.81 | 17.8107 | 5600.0 |
| 2013-10-15 06:05:00 | AAPL | Stock | 17.8111 | 17.8179 | 17.8111 | 17.8179 | 22400.0 |
| 2013-10-15 06:25:00 | AAPL | Stock | 17.8057 | 17.8057 | 17.8057 | 17.8057 | 2800.0 |
| 2013-10-15 06:30:00 | AAPL | Stock | 17.8214 | 17.8214 | 17.8107 | 17.8107 | 16800.0 |
| 2013-10-15 06:45:00 | AAPL | Stock | 17.7911 | 17.7918 | 17.7857 | 17.7857 | 57512.0 |
| 2013-10-15 06:50:00 | AAPL | Stock | 17.7893 | 17.7893 | 17.7857 | 17.7893 | 39200.0 |
| 2013-10-15 07:00:00 | AAPL | Stock | 17.7929 | 17.8036 | 17.7929 | 17.8036 | 47600.0 |
| 2013-10-15 07:05:00 | AAPL | Stock | 17.8039 | 17.8125 | 17.8036 | 17.8036 | 43428.0 |
| 2013-10-15 07:10:00 | AAPL | Stock | 17.7893 | 17.7943 | 17.7893 | 17.7943 | 8260.0 |
| 2013-10-15 07:15:00 | AAPL | Stock | 17.7932 | 17.8214 | 17.7857 | 17.8214 | 176456.0 |
| 2013-10-15 07:20:00 | AAPL | Stock | 17.8179 | 17.8179 | 17.8129 | 17.8129 | 14000.0 |
| 2013-10-15 07:25:00 | AAPL | Stock | 17.8129 | 17.8129 | 17.8054 | 17.8068 | 33600.0 |
| 2013-10-15 07:30:00 | AAPL | Stock | 17.7996 | 17.8036 | 17.7996 | 17.8036 | 42336.0 |
| 2013-10-15 07:35:00 | AAPL | Stock | 17.8036 | 17.8204 | 17.8036 | 17.8204 | 33600.0 |
| 2013-10-15 07:40:00 | AAPL | Stock | 17.8139 | 17.8139 | 17.7893 | 17.7893 | 82572.0 |
| 2013-10-15 07:45:00 | AAPL | Stock | 17.7857 | 17.7861 | 17.7714 | 17.7857 | 91840.0 |
| 2013-10-15 07:50:00 | AAPL | Stock | 17.7771 | 17.7771 | 17.7714 | 17.7714 | 36484.0 |
| 2013-10-15 07:55:00 | AAPL | Stock | 17.7629 | 17.7714 | 17.7479 | 17.7479 | 84308.0 |
| 2013-10-15 08:00:00 | AAPL | Stock | 17.7321 | 17.8214 | 17.7143 | 17.7679 | 488936.0 |
| 2013-10-15 08:05:00 | AAPL | Stock | 17.7629 | 17.7679 | 17.7571 | 17.7571 | 35000.0 |
| 2013-10-15 08:10:00 | AAPL | Stock | 17.7679 | 17.8018 | 17.7611 | 17.7896 | 266560.0 |
| 2013-10-15 08:15:00 | AAPL | Stock | 17.7846 | 17.7846 | 17.7829 | 17.7829 | 30800.0 |
| 2013-10-15 08:20:00 | AAPL | Stock | 17.7682 | 17.77 | 17.7182 | 17.7589 | 213192.0 |
| 2013-10-15 08:25:00 | AAPL | Stock | 17.7589 | 17.7618 | 17.7464 | 17.7554 | 199584.0 |
| 2013-10-15 08:30:00 | AAPL | Stock | 17.7489 | 17.7614 | 17.7375 | 17.75 | 72660.0 |
| 2013-10-15 08:35:00 | AAPL | Stock | 17.75 | 17.7614 | 17.7414 | 17.7507 | 87640.0 |
| 2013-10-15 08:40:00 | AAPL | Stock | 17.7586 | 17.7596 | 17.7525 | 17.7582 | 53200.0 |
| 2013-10-15 08:45:00 | AAPL | Stock | 17.7614 | 17.7746 | 17.7614 | 17.7721 | 45276.0 |
| 2013-10-15 08:50:00 | AAPL | Stock | 17.7732 | 17.7793 | 17.7682 | 17.7764 | 164332.0 |
| 2013-10-15 08:55:00 | AAPL | Stock | 17.7732 | 17.7857 | 17.7732 | 17.7821 | 180040.0 |
| 2013-10-15 09:00:00 | AAPL | Stock | 17.7743 | 17.7957 | 17.7696 | 17.7864 | 141400.0 |
| 2013-10-15 09:05:00 | AAPL | Stock | 17.7893 | 17.8107 | 17.7893 | 17.7975 | 303240.0 |
| 2013-10-15 09:10:00 | AAPL | Stock | 17.8032 | 17.8036 | 17.7936 | 17.8029 | 156324.0 |
| 2013-10-15 09:15:00 | AAPL | Stock | 17.8032 | 17.8068 | 17.7193 | 17.7536 | 529816.0 |
| 2013-10-15 09:20:00 | AAPL | Stock | 17.7579 | 17.7857 | 17.7486 | 17.7536 | 680260.0 |
| 2013-10-15 09:25:00 | AAPL | Stock | 17.7689 | 17.7857 | 17.7579 | 17.7625 | 106820.0 |
| 2013-10-15 09:30:00 | AAPL | Stock | 17.7804 | 17.8025 | 17.6971 | 17.7279 | 17204852.0 |
| 2013-10-15 09:35:00 | AAPL | Stock | 17.7304 | 17.8054 | 17.7182 | 17.7607 | 10451616.0 |
| 2013-10-15 09:40:00 | AAPL | Stock | 17.7627 | 17.7821 | 17.7052 | 17.7229 | 6917036.0 |
| 2013-10-15 09:45:00 | AAPL | Stock | 17.7225 | 17.7654 | 17.7161 | 17.7625 | 5295304.0 |
| 2013-10-15 09:50:00 | AAPL | Stock | 17.7594 | 17.7929 | 17.7318 | 17.7343 | 5667816.0 |
| 2013-10-15 09:55:00 | AAPL | Stock | 17.7346 | 17.7914 | 17.7343 | 17.78 | 3747996.0 |
| 2013-10-15 10:00:00 | AAPL | Stock | 17.7854 | 17.8121 | 17.7729 | 17.7929 | 6116712.0 |
> showing 50 of 344,623 rows — these rows as CSV