PREVIEW / stock_5min / 2012-11-12
file: by_date/stock_5min/2012/2012-11-12.parquet size: 4.6 MB rows: 310,078 symbols: 3,447
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 |
|---|---|---|---|---|---|---|---|
| 2012-11-12 04:00:00 | AAPL | Stock | 19.8214 | 19.8214 | 19.6429 | 19.6429 | 32200.0 |
| 2012-11-12 04:25:00 | AAPL | Stock | 19.6604 | 19.6604 | 19.6604 | 19.6604 | 2800.0 |
| 2012-11-12 04:30:00 | AAPL | Stock | 19.6607 | 19.6607 | 19.6607 | 19.6607 | 10640.0 |
| 2012-11-12 04:45:00 | AAPL | Stock | 19.6429 | 19.6429 | 19.6429 | 19.6429 | 19600.0 |
| 2012-11-12 05:00:00 | AAPL | Stock | 19.6429 | 19.6429 | 19.6429 | 19.6429 | 2800.0 |
| 2012-11-12 05:05:00 | AAPL | Stock | 19.6429 | 19.6429 | 19.6429 | 19.6429 | 16800.0 |
| 2012-11-12 05:50:00 | AAPL | Stock | 19.6464 | 19.6464 | 19.6464 | 19.6464 | 2800.0 |
| 2012-11-12 06:05:00 | AAPL | Stock | 19.6679 | 19.6679 | 19.6679 | 19.6679 | 16800.0 |
| 2012-11-12 06:10:00 | AAPL | Stock | 19.6711 | 19.675 | 19.6711 | 19.675 | 18760.0 |
| 2012-11-12 06:15:00 | AAPL | Stock | 19.6746 | 19.675 | 19.6746 | 19.675 | 5684.0 |
| 2012-11-12 06:20:00 | AAPL | Stock | 19.6964 | 19.7071 | 19.6964 | 19.7071 | 5600.0 |
| 2012-11-12 06:30:00 | AAPL | Stock | 19.7054 | 19.7054 | 19.7054 | 19.7054 | 28000.0 |
| 2012-11-12 06:35:00 | AAPL | Stock | 19.7107 | 19.7107 | 19.7107 | 19.7107 | 3080.0 |
| 2012-11-12 07:00:00 | AAPL | Stock | 19.7054 | 19.7439 | 19.7054 | 19.7321 | 18200.0 |
| 2012-11-12 07:05:00 | AAPL | Stock | 19.7289 | 19.7536 | 19.7289 | 19.75 | 27944.0 |
| 2012-11-12 07:10:00 | AAPL | Stock | 19.7339 | 19.7411 | 19.7164 | 19.7218 | 125496.0 |
| 2012-11-12 07:15:00 | AAPL | Stock | 19.7261 | 19.7321 | 19.7204 | 19.7282 | 28280.0 |
| 2012-11-12 07:20:00 | AAPL | Stock | 19.7179 | 19.7318 | 19.7054 | 19.7054 | 68936.0 |
| 2012-11-12 07:25:00 | AAPL | Stock | 19.7136 | 19.7143 | 19.6964 | 19.7143 | 44800.0 |
| 2012-11-12 07:30:00 | AAPL | Stock | 19.6964 | 19.7 | 19.6964 | 19.7 | 7028.0 |
| 2012-11-12 07:35:00 | AAPL | Stock | 19.7057 | 19.7143 | 19.7054 | 19.7143 | 46900.0 |
| 2012-11-12 07:40:00 | AAPL | Stock | 19.7143 | 19.7321 | 19.7143 | 19.7282 | 55160.0 |
| 2012-11-12 07:45:00 | AAPL | Stock | 19.7286 | 19.7321 | 19.7179 | 19.7179 | 11648.0 |
| 2012-11-12 07:50:00 | AAPL | Stock | 19.7146 | 19.7146 | 19.6911 | 19.7 | 61600.0 |
| 2012-11-12 07:55:00 | AAPL | Stock | 19.6921 | 19.7036 | 19.6857 | 19.6961 | 94388.0 |
| 2012-11-12 08:00:00 | AAPL | Stock | 19.6964 | 19.7429 | 19.65 | 19.6546 | 404740.0 |
| 2012-11-12 08:05:00 | AAPL | Stock | 19.6589 | 19.6786 | 19.6432 | 19.6786 | 242844.0 |
| 2012-11-12 08:10:00 | AAPL | Stock | 19.6768 | 19.6964 | 19.6764 | 19.6907 | 160972.0 |
| 2012-11-12 08:15:00 | AAPL | Stock | 19.6821 | 19.6889 | 19.6714 | 19.6714 | 73080.0 |
| 2012-11-12 08:20:00 | AAPL | Stock | 19.6718 | 19.6857 | 19.6607 | 19.6611 | 235928.0 |
| 2012-11-12 08:25:00 | AAPL | Stock | 19.6679 | 19.6707 | 19.6618 | 19.6686 | 156044.0 |
| 2012-11-12 08:30:00 | AAPL | Stock | 19.6689 | 19.6911 | 19.6689 | 19.6786 | 364840.0 |
| 2012-11-12 08:35:00 | AAPL | Stock | 19.6825 | 19.6843 | 19.67 | 19.6786 | 96908.0 |
| 2012-11-12 08:40:00 | AAPL | Stock | 19.6782 | 19.6782 | 19.6643 | 19.6707 | 95144.0 |
| 2012-11-12 08:45:00 | AAPL | Stock | 19.6711 | 19.6782 | 19.6643 | 19.6718 | 84336.0 |
| 2012-11-12 08:50:00 | AAPL | Stock | 19.6714 | 19.6786 | 19.6646 | 19.6782 | 134036.0 |
| 2012-11-12 08:55:00 | AAPL | Stock | 19.6754 | 19.6782 | 19.6696 | 19.6711 | 28000.0 |
| 2012-11-12 09:00:00 | AAPL | Stock | 19.6704 | 19.6804 | 19.6679 | 19.68 | 258384.0 |
| 2012-11-12 09:05:00 | AAPL | Stock | 19.6832 | 19.7214 | 19.6832 | 19.715 | 274176.0 |
| 2012-11-12 09:10:00 | AAPL | Stock | 19.7193 | 19.7229 | 19.6989 | 19.71 | 462672.0 |
| 2012-11-12 09:15:00 | AAPL | Stock | 19.7014 | 19.7032 | 19.6875 | 19.6961 | 182588.0 |
| 2012-11-12 09:20:00 | AAPL | Stock | 19.6914 | 19.7121 | 19.6889 | 19.7021 | 177324.0 |
| 2012-11-12 09:25:00 | AAPL | Stock | 19.7061 | 19.8 | 19.7061 | 19.7946 | 1456532.0 |
| 2012-11-12 09:30:00 | AAPL | Stock | 19.7946 | 19.8036 | 19.6696 | 19.6877 | 22434888.0 |
| 2012-11-12 09:35:00 | AAPL | Stock | 19.6839 | 19.7243 | 19.6539 | 19.7082 | 13299888.0 |
| 2012-11-12 09:40:00 | AAPL | Stock | 19.7125 | 19.7579 | 19.6857 | 19.7125 | 10952480.0 |
| 2012-11-12 09:45:00 | AAPL | Stock | 19.7107 | 19.7429 | 19.6471 | 19.6496 | 8802304.0 |
| 2012-11-12 09:50:00 | AAPL | Stock | 19.6491 | 19.685 | 19.6111 | 19.65 | 10425352.0 |
| 2012-11-12 09:55:00 | AAPL | Stock | 19.6407 | 19.6964 | 19.6375 | 19.6689 | 5680668.0 |
| 2012-11-12 10:00:00 | AAPL | Stock | 19.6618 | 19.6732 | 19.6311 | 19.6607 | 5467644.0 |
> showing 50 of 310,078 rows — these rows as CSV