PREVIEW / stock_5min / 2013-04-17
file: by_date/stock_5min/2013/2013-04-17.parquet size: 5.1 MB rows: 343,549 symbols: 3,485
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-04-17 04:10:00 | AAPL | Stock | 15.0893 | 15.0893 | 15.0893 | 15.0893 | 5768.0 |
| 2013-04-17 04:20:00 | AAPL | Stock | 15.0811 | 15.0811 | 15.0811 | 15.0811 | 5600.0 |
| 2013-04-17 04:35:00 | AAPL | Stock | 15.0636 | 15.0636 | 15.0632 | 15.0632 | 5600.0 |
| 2013-04-17 04:40:00 | AAPL | Stock | 15.0571 | 15.0675 | 15.0571 | 15.0675 | 5600.0 |
| 2013-04-17 05:00:00 | AAPL | Stock | 15.0893 | 15.0893 | 15.0893 | 15.0893 | 4200.0 |
| 2013-04-17 05:50:00 | AAPL | Stock | 15.0821 | 15.0821 | 15.0821 | 15.0821 | 2800.0 |
| 2013-04-17 05:55:00 | AAPL | Stock | 15.0821 | 15.0821 | 15.0821 | 15.0821 | 7112.0 |
| 2013-04-17 06:45:00 | AAPL | Stock | 15.1175 | 15.1175 | 15.1175 | 15.1175 | 4200.0 |
| 2013-04-17 06:55:00 | AAPL | Stock | 15.1025 | 15.1025 | 15.0832 | 15.0832 | 20020.0 |
| 2013-04-17 07:00:00 | AAPL | Stock | 15.0796 | 15.0929 | 15.0707 | 15.0775 | 54908.0 |
| 2013-04-17 07:05:00 | AAPL | Stock | 15.0611 | 15.0775 | 15.0611 | 15.0775 | 19768.0 |
| 2013-04-17 07:10:00 | AAPL | Stock | 15.0789 | 15.0789 | 15.0571 | 15.0571 | 14000.0 |
| 2013-04-17 07:15:00 | AAPL | Stock | 15.0439 | 15.0439 | 15.0286 | 15.0368 | 95760.0 |
| 2013-04-17 07:20:00 | AAPL | Stock | 15.0364 | 15.0446 | 15.0364 | 15.0386 | 72884.0 |
| 2013-04-17 07:25:00 | AAPL | Stock | 15.0386 | 15.04 | 15.0268 | 15.0268 | 106372.0 |
| 2013-04-17 07:30:00 | AAPL | Stock | 15.0275 | 15.0411 | 15.0275 | 15.0357 | 185668.0 |
| 2013-04-17 07:35:00 | AAPL | Stock | 15.0357 | 15.0411 | 15.0268 | 15.0268 | 55272.0 |
| 2013-04-17 07:40:00 | AAPL | Stock | 15.0286 | 15.0357 | 15.0071 | 15.0304 | 200676.0 |
| 2013-04-17 07:45:00 | AAPL | Stock | 15.0314 | 15.0407 | 15.0214 | 15.0375 | 171948.0 |
| 2013-04-17 07:50:00 | AAPL | Stock | 15.0446 | 15.0532 | 15.0432 | 15.0432 | 35252.0 |
| 2013-04-17 07:55:00 | AAPL | Stock | 15.04 | 15.0604 | 15.0393 | 15.0604 | 57316.0 |
| 2013-04-17 08:00:00 | AAPL | Stock | 15.055 | 15.0775 | 15.0339 | 15.0693 | 243068.0 |
| 2013-04-17 08:05:00 | AAPL | Stock | 15.07 | 15.0707 | 15.0482 | 15.0643 | 205268.0 |
| 2013-04-17 08:10:00 | AAPL | Stock | 15.0643 | 15.0679 | 15.0579 | 15.0625 | 102200.0 |
| 2013-04-17 08:15:00 | AAPL | Stock | 15.0625 | 15.0729 | 15.0625 | 15.0714 | 210616.0 |
| 2013-04-17 08:20:00 | AAPL | Stock | 15.0714 | 15.0836 | 15.0668 | 15.0836 | 322280.0 |
| 2013-04-17 08:25:00 | AAPL | Stock | 15.0793 | 15.0929 | 15.0786 | 15.0929 | 171136.0 |
| 2013-04-17 08:30:00 | AAPL | Stock | 15.0943 | 15.0982 | 15.0686 | 15.0714 | 113428.0 |
| 2013-04-17 08:35:00 | AAPL | Stock | 15.0714 | 15.075 | 15.0536 | 15.0704 | 203056.0 |
| 2013-04-17 08:40:00 | AAPL | Stock | 15.0707 | 15.0714 | 15.0539 | 15.0546 | 152460.0 |
| 2013-04-17 08:45:00 | AAPL | Stock | 15.0536 | 15.0621 | 15.0461 | 15.0539 | 220864.0 |
| 2013-04-17 08:50:00 | AAPL | Stock | 15.0539 | 15.0571 | 15.0482 | 15.0482 | 172284.0 |
| 2013-04-17 08:55:00 | AAPL | Stock | 15.05 | 15.05 | 15.0446 | 15.05 | 142800.0 |
| 2013-04-17 09:00:00 | AAPL | Stock | 15.045 | 15.0482 | 15.0411 | 15.0468 | 199780.0 |
| 2013-04-17 09:05:00 | AAPL | Stock | 15.0493 | 15.0496 | 15.0321 | 15.0357 | 390012.0 |
| 2013-04-17 09:10:00 | AAPL | Stock | 15.0357 | 15.045 | 15.0321 | 15.0418 | 200928.0 |
| 2013-04-17 09:15:00 | AAPL | Stock | 15.0393 | 15.0393 | 15.0261 | 15.035 | 173992.0 |
| 2013-04-17 09:20:00 | AAPL | Stock | 15.0286 | 15.0371 | 15.0232 | 15.0318 | 351596.0 |
| 2013-04-17 09:25:00 | AAPL | Stock | 15.0321 | 15.0357 | 14.9871 | 15.0139 | 1117956.0 |
| 2013-04-17 09:30:00 | AAPL | Stock | 15.0139 | 15.0214 | 14.8443 | 14.8843 | 40002256.0 |
| 2013-04-17 09:35:00 | AAPL | Stock | 14.8825 | 14.9036 | 14.8482 | 14.8611 | 16470244.0 |
| 2013-04-17 09:40:00 | AAPL | Stock | 14.8622 | 14.8714 | 14.8125 | 14.8332 | 18452840.0 |
| 2013-04-17 09:45:00 | AAPL | Stock | 14.8293 | 14.8982 | 14.8221 | 14.8776 | 11519844.0 |
| 2013-04-17 09:50:00 | AAPL | Stock | 14.8754 | 14.8918 | 14.8168 | 14.8185 | 13691384.0 |
| 2013-04-17 09:55:00 | AAPL | Stock | 14.8179 | 14.8393 | 14.7321 | 14.7482 | 25519172.0 |
| 2013-04-17 10:00:00 | AAPL | Stock | 14.7474 | 14.7725 | 14.6825 | 14.6882 | 18725448.0 |
| 2013-04-17 10:05:00 | AAPL | Stock | 14.6861 | 14.7116 | 14.6646 | 14.6996 | 17268384.0 |
| 2013-04-17 10:10:00 | AAPL | Stock | 14.7037 | 14.7082 | 14.5357 | 14.5404 | 28242592.0 |
| 2013-04-17 10:15:00 | AAPL | Stock | 14.5402 | 14.5979 | 14.4732 | 14.4746 | 32443488.0 |
| 2013-04-17 10:20:00 | AAPL | Stock | 14.4793 | 14.5357 | 14.4168 | 14.5275 | 33663028.0 |
> showing 50 of 343,549 rows — these rows as CSV