PREVIEW / stock_5min / 2011-10-11
file: by_date/stock_5min/2011/2011-10-11.parquet size: 4.7 MB rows: 320,796 symbols: 3,491
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 |
|---|---|---|---|---|---|---|---|
| 2011-10-11 04:00:00 | AAPL | Stock | 13.8854 | 13.8854 | 13.8854 | 13.8854 | 5600.0 |
| 2011-10-11 04:05:00 | AAPL | Stock | 13.8989 | 13.8989 | 13.8989 | 13.8989 | 5600.0 |
| 2011-10-11 04:10:00 | AAPL | Stock | 13.8893 | 13.8986 | 13.8857 | 13.8986 | 11200.0 |
| 2011-10-11 04:15:00 | AAPL | Stock | 13.8914 | 13.9111 | 13.8857 | 13.9111 | 16800.0 |
| 2011-10-11 04:20:00 | AAPL | Stock | 13.8957 | 13.8957 | 13.8957 | 13.8957 | 5600.0 |
| 2011-10-11 04:25:00 | AAPL | Stock | 13.9107 | 13.9111 | 13.9107 | 13.9111 | 8400.0 |
| 2011-10-11 04:35:00 | AAPL | Stock | 13.8786 | 13.8786 | 13.8786 | 13.8786 | 2800.0 |
| 2011-10-11 04:40:00 | AAPL | Stock | 13.8786 | 13.8786 | 13.8786 | 13.8786 | 11200.0 |
| 2011-10-11 04:45:00 | AAPL | Stock | 13.8786 | 13.8786 | 13.8611 | 13.8611 | 11200.0 |
| 2011-10-11 04:50:00 | AAPL | Stock | 13.8779 | 13.8821 | 13.8779 | 13.8779 | 10360.0 |
| 2011-10-11 04:55:00 | AAPL | Stock | 13.8836 | 13.8836 | 13.8836 | 13.8836 | 14000.0 |
| 2011-10-11 05:10:00 | AAPL | Stock | 13.8929 | 13.8929 | 13.8929 | 13.8929 | 2800.0 |
| 2011-10-11 05:45:00 | AAPL | Stock | 13.8914 | 13.8914 | 13.8914 | 13.8914 | 2800.0 |
| 2011-10-11 06:05:00 | AAPL | Stock | 13.9082 | 13.9107 | 13.9082 | 13.9107 | 8400.0 |
| 2011-10-11 06:30:00 | AAPL | Stock | 13.8839 | 13.8839 | 13.8839 | 13.8839 | 7000.0 |
| 2011-10-11 07:00:00 | AAPL | Stock | 13.8668 | 13.9107 | 13.8668 | 13.91 | 14000.0 |
| 2011-10-11 07:05:00 | AAPL | Stock | 13.9018 | 13.9236 | 13.8971 | 13.9236 | 30800.0 |
| 2011-10-11 07:10:00 | AAPL | Stock | 13.9239 | 13.9286 | 13.9157 | 13.9286 | 77000.0 |
| 2011-10-11 07:15:00 | AAPL | Stock | 13.9107 | 13.9325 | 13.9107 | 13.9157 | 43932.0 |
| 2011-10-11 07:20:00 | AAPL | Stock | 13.9057 | 13.9207 | 13.8939 | 13.9207 | 26376.0 |
| 2011-10-11 07:25:00 | AAPL | Stock | 13.9129 | 13.9129 | 13.9129 | 13.9129 | 2800.0 |
| 2011-10-11 07:30:00 | AAPL | Stock | 13.9275 | 13.9275 | 13.9043 | 13.9043 | 39060.0 |
| 2011-10-11 07:35:00 | AAPL | Stock | 13.8954 | 13.9036 | 13.8954 | 13.9036 | 8400.0 |
| 2011-10-11 07:40:00 | AAPL | Stock | 13.9168 | 13.9179 | 13.9168 | 13.9175 | 16800.0 |
| 2011-10-11 07:45:00 | AAPL | Stock | 13.9271 | 13.9443 | 13.9179 | 13.9179 | 66108.0 |
| 2011-10-11 07:50:00 | AAPL | Stock | 13.9289 | 13.9289 | 13.9179 | 13.9214 | 36400.0 |
| 2011-10-11 07:55:00 | AAPL | Stock | 13.9279 | 13.9279 | 13.9036 | 13.9036 | 87080.0 |
| 2011-10-11 08:00:00 | AAPL | Stock | 13.9207 | 13.9536 | 13.9111 | 13.9536 | 417508.0 |
| 2011-10-11 08:05:00 | AAPL | Stock | 13.9536 | 13.9732 | 13.95 | 13.9679 | 386904.0 |
| 2011-10-11 08:10:00 | AAPL | Stock | 13.9714 | 14.0232 | 13.9711 | 14.02 | 868336.0 |
| 2011-10-11 08:15:00 | AAPL | Stock | 14.0232 | 14.0468 | 14.0107 | 14.0286 | 1238580.0 |
| 2011-10-11 08:20:00 | AAPL | Stock | 14.0286 | 14.0364 | 14.0111 | 14.0121 | 352156.0 |
| 2011-10-11 08:25:00 | AAPL | Stock | 14.0125 | 14.0179 | 13.9964 | 13.9964 | 458192.0 |
| 2011-10-11 08:30:00 | AAPL | Stock | 14.0029 | 14.0168 | 14.0 | 14.0014 | 325948.0 |
| 2011-10-11 08:35:00 | AAPL | Stock | 14.0 | 14.0004 | 13.9879 | 13.9911 | 391524.0 |
| 2011-10-11 08:40:00 | AAPL | Stock | 13.9946 | 13.9957 | 13.9771 | 13.9889 | 175000.0 |
| 2011-10-11 08:45:00 | AAPL | Stock | 13.9811 | 13.9857 | 13.9671 | 13.9786 | 346192.0 |
| 2011-10-11 08:50:00 | AAPL | Stock | 13.9786 | 13.9918 | 13.975 | 13.9825 | 320180.0 |
| 2011-10-11 08:55:00 | AAPL | Stock | 13.9789 | 13.9854 | 13.9679 | 13.9854 | 730996.0 |
| 2011-10-11 09:00:00 | AAPL | Stock | 13.985 | 13.9879 | 13.9746 | 13.9746 | 171948.0 |
| 2011-10-11 09:05:00 | AAPL | Stock | 13.975 | 13.9775 | 13.9632 | 13.9643 | 396592.0 |
| 2011-10-11 09:10:00 | AAPL | Stock | 13.9671 | 13.9854 | 13.9646 | 13.9854 | 176652.0 |
| 2011-10-11 09:15:00 | AAPL | Stock | 13.9825 | 13.9825 | 13.9643 | 13.9643 | 153524.0 |
| 2011-10-11 09:20:00 | AAPL | Stock | 13.9643 | 13.9821 | 13.9632 | 13.975 | 142800.0 |
| 2011-10-11 09:25:00 | AAPL | Stock | 13.9807 | 14.0282 | 13.9807 | 14.0141 | 615580.0 |
| 2011-10-11 09:30:00 | AAPL | Stock | 14.0204 | 14.0657 | 13.9821 | 14.0575 | 24930696.0 |
| 2011-10-11 09:35:00 | AAPL | Stock | 14.0575 | 14.1696 | 14.0196 | 14.1593 | 29848308.0 |
| 2011-10-11 09:40:00 | AAPL | Stock | 14.1593 | 14.1875 | 14.1307 | 14.1405 | 22425760.0 |
| 2011-10-11 09:45:00 | AAPL | Stock | 14.1386 | 14.1854 | 14.1286 | 14.185 | 17770060.0 |
| 2011-10-11 09:50:00 | AAPL | Stock | 14.1846 | 14.225 | 14.1721 | 14.1918 | 21068208.0 |
> showing 50 of 320,796 rows — these rows as CSV