PREVIEW / stock_5min / 2012-08-30
file: by_date/stock_5min/2012/2012-08-30.parquet size: 4.3 MB rows: 294,833 symbols: 3,429
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-08-30 04:00:00 | AAPL | Stock | 24.0268 | 24.0268 | 24.0 | 24.0107 | 14000.0 |
| 2012-08-30 05:30:00 | AAPL | Stock | 23.9821 | 23.9821 | 23.9821 | 23.9821 | 2800.0 |
| 2012-08-30 05:35:00 | AAPL | Stock | 23.9893 | 23.9893 | 23.9893 | 23.9893 | 5600.0 |
| 2012-08-30 05:40:00 | AAPL | Stock | 23.9893 | 23.9893 | 23.9893 | 23.9893 | 8400.0 |
| 2012-08-30 05:55:00 | AAPL | Stock | 23.9893 | 23.9893 | 23.9768 | 23.9893 | 25200.0 |
| 2012-08-30 06:00:00 | AAPL | Stock | 23.9768 | 23.9768 | 23.9732 | 23.9732 | 12852.0 |
| 2012-08-30 06:05:00 | AAPL | Stock | 23.9646 | 23.9646 | 23.9532 | 23.9532 | 11200.0 |
| 2012-08-30 06:15:00 | AAPL | Stock | 23.9696 | 23.97 | 23.9643 | 23.9679 | 161000.0 |
| 2012-08-30 06:20:00 | AAPL | Stock | 23.9679 | 23.9679 | 23.9464 | 23.9464 | 31360.0 |
| 2012-08-30 06:25:00 | AAPL | Stock | 23.9325 | 23.9325 | 23.9318 | 23.9325 | 8400.0 |
| 2012-08-30 07:00:00 | AAPL | Stock | 23.9464 | 23.9639 | 23.9464 | 23.9607 | 14000.0 |
| 2012-08-30 07:05:00 | AAPL | Stock | 23.9711 | 23.9711 | 23.9711 | 23.9711 | 5460.0 |
| 2012-08-30 07:10:00 | AAPL | Stock | 23.9643 | 23.9821 | 23.9643 | 23.975 | 33600.0 |
| 2012-08-30 07:15:00 | AAPL | Stock | 23.9732 | 23.9821 | 23.9732 | 23.9821 | 12600.0 |
| 2012-08-30 07:20:00 | AAPL | Stock | 23.9821 | 23.9821 | 23.9821 | 23.9821 | 2800.0 |
| 2012-08-30 07:25:00 | AAPL | Stock | 23.9825 | 23.9825 | 23.9825 | 23.9825 | 2800.0 |
| 2012-08-30 07:30:00 | AAPL | Stock | 23.9893 | 24.0 | 23.9893 | 24.0 | 30800.0 |
| 2012-08-30 07:35:00 | AAPL | Stock | 24.0068 | 24.0293 | 24.0 | 24.0036 | 52780.0 |
| 2012-08-30 07:40:00 | AAPL | Stock | 24.0071 | 24.0071 | 24.0 | 24.0 | 21700.0 |
| 2012-08-30 07:45:00 | AAPL | Stock | 23.9964 | 23.9964 | 23.9929 | 23.9929 | 5600.0 |
| 2012-08-30 07:50:00 | AAPL | Stock | 23.9875 | 23.9911 | 23.985 | 23.9911 | 42000.0 |
| 2012-08-30 07:55:00 | AAPL | Stock | 23.9761 | 23.9768 | 23.9761 | 23.9768 | 11200.0 |
| 2012-08-30 08:00:00 | AAPL | Stock | 23.9957 | 23.9957 | 23.9643 | 23.9725 | 143304.0 |
| 2012-08-30 08:05:00 | AAPL | Stock | 23.9686 | 23.9686 | 23.9668 | 23.9668 | 8400.0 |
| 2012-08-30 08:10:00 | AAPL | Stock | 23.9886 | 23.9889 | 23.9886 | 23.9889 | 9884.0 |
| 2012-08-30 08:15:00 | AAPL | Stock | 23.9911 | 24.0096 | 23.9911 | 24.0004 | 47600.0 |
| 2012-08-30 08:20:00 | AAPL | Stock | 24.0007 | 24.0007 | 24.0 | 24.0 | 23632.0 |
| 2012-08-30 08:25:00 | AAPL | Stock | 24.0 | 24.0464 | 23.9957 | 23.9996 | 191660.0 |
| 2012-08-30 08:30:00 | AAPL | Stock | 24.0039 | 24.0064 | 23.9714 | 23.9811 | 236600.0 |
| 2012-08-30 08:35:00 | AAPL | Stock | 23.9857 | 23.9886 | 23.975 | 23.9761 | 100744.0 |
| 2012-08-30 08:40:00 | AAPL | Stock | 23.9864 | 23.99 | 23.9843 | 23.9857 | 19600.0 |
| 2012-08-30 08:45:00 | AAPL | Stock | 23.9886 | 23.9886 | 23.9807 | 23.9821 | 67704.0 |
| 2012-08-30 08:50:00 | AAPL | Stock | 23.9821 | 23.9854 | 23.9721 | 23.9832 | 200340.0 |
| 2012-08-30 08:55:00 | AAPL | Stock | 23.9725 | 23.9729 | 23.9664 | 23.9664 | 60060.0 |
| 2012-08-30 09:00:00 | AAPL | Stock | 23.9664 | 23.9761 | 23.9643 | 23.9725 | 177464.0 |
| 2012-08-30 09:05:00 | AAPL | Stock | 23.9696 | 23.9821 | 23.9696 | 23.9732 | 51520.0 |
| 2012-08-30 09:10:00 | AAPL | Stock | 23.9721 | 23.9786 | 23.9711 | 23.9786 | 42336.0 |
| 2012-08-30 09:15:00 | AAPL | Stock | 23.9775 | 23.9775 | 23.96 | 23.96 | 173656.0 |
| 2012-08-30 09:20:00 | AAPL | Stock | 23.9561 | 23.9707 | 23.9554 | 23.9707 | 166628.0 |
| 2012-08-30 09:25:00 | AAPL | Stock | 23.9704 | 23.9761 | 23.9464 | 23.9482 | 417340.0 |
| 2012-08-30 09:30:00 | AAPL | Stock | 23.9464 | 23.9841 | 23.9089 | 23.9204 | 14680092.0 |
| 2012-08-30 09:35:00 | AAPL | Stock | 23.9159 | 23.9193 | 23.8661 | 23.9054 | 13659716.0 |
| 2012-08-30 09:40:00 | AAPL | Stock | 23.9054 | 23.9446 | 23.8975 | 23.9257 | 8523676.0 |
| 2012-08-30 09:45:00 | AAPL | Stock | 23.9282 | 23.96 | 23.9264 | 23.9371 | 5413520.0 |
| 2012-08-30 09:50:00 | AAPL | Stock | 23.9371 | 23.9689 | 23.9339 | 23.9418 | 5568136.0 |
| 2012-08-30 09:55:00 | AAPL | Stock | 23.9471 | 23.9471 | 23.8968 | 23.8971 | 4928364.0 |
| 2012-08-30 10:00:00 | AAPL | Stock | 23.8968 | 23.9196 | 23.8729 | 23.9089 | 5583396.0 |
| 2012-08-30 10:05:00 | AAPL | Stock | 23.9083 | 23.9154 | 23.8607 | 23.8857 | 4085704.0 |
| 2012-08-30 10:10:00 | AAPL | Stock | 23.8868 | 23.8911 | 23.8661 | 23.8911 | 4124344.0 |
| 2012-08-30 10:15:00 | AAPL | Stock | 23.8929 | 23.8929 | 23.8693 | 23.8764 | 2226280.0 |
> showing 50 of 294,833 rows — these rows as CSV