PREVIEW / stock_1min / 2013-10-29
file: by_date/stock_1min/2013/2013-10-29.parquet size: 13.6 MB rows: 992,710 symbols: 2,881
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-29 04:00:00 | AAPL | Stock | 19.0575 | 19.0575 | 18.7143 | 18.7143 | 43120.0 |
| 2013-10-29 04:01:00 | AAPL | Stock | 18.75 | 18.75 | 18.75 | 18.75 | 5600.0 |
| 2013-10-29 04:02:00 | AAPL | Stock | 18.8214 | 18.8214 | 18.8214 | 18.8214 | 11200.0 |
| 2013-10-29 04:04:00 | AAPL | Stock | 18.8064 | 18.8111 | 18.8061 | 18.8111 | 14000.0 |
| 2013-10-29 04:06:00 | AAPL | Stock | 18.8021 | 18.8021 | 18.8021 | 18.8021 | 2800.0 |
| 2013-10-29 04:09:00 | AAPL | Stock | 18.815 | 18.8157 | 18.815 | 18.8157 | 14000.0 |
| 2013-10-29 04:10:00 | AAPL | Stock | 18.815 | 18.815 | 18.815 | 18.815 | 16800.0 |
| 2013-10-29 04:11:00 | AAPL | Stock | 18.7914 | 18.8079 | 18.7914 | 18.8079 | 5600.0 |
| 2013-10-29 04:13:00 | AAPL | Stock | 18.8218 | 18.8218 | 18.8218 | 18.8218 | 8400.0 |
| 2013-10-29 04:14:00 | AAPL | Stock | 18.8329 | 18.8393 | 18.8329 | 18.8393 | 8400.0 |
| 2013-10-29 04:16:00 | AAPL | Stock | 18.8093 | 18.8093 | 18.8093 | 18.8093 | 10640.0 |
| 2013-10-29 04:20:00 | AAPL | Stock | 18.8218 | 18.8218 | 18.8218 | 18.8218 | 2800.0 |
| 2013-10-29 04:23:00 | AAPL | Stock | 18.8371 | 18.8429 | 18.8371 | 18.8429 | 30800.0 |
| 2013-10-29 04:25:00 | AAPL | Stock | 18.8514 | 18.8514 | 18.8514 | 18.8514 | 2800.0 |
| 2013-10-29 04:26:00 | AAPL | Stock | 18.875 | 18.8757 | 18.875 | 18.8757 | 5600.0 |
| 2013-10-29 04:27:00 | AAPL | Stock | 18.8768 | 18.8768 | 18.8768 | 18.8768 | 5600.0 |
| 2013-10-29 04:28:00 | AAPL | Stock | 18.8686 | 18.8825 | 18.8686 | 18.8696 | 11200.0 |
| 2013-10-29 04:29:00 | AAPL | Stock | 18.8761 | 18.8775 | 18.8736 | 18.8736 | 15680.0 |
| 2013-10-29 04:31:00 | AAPL | Stock | 18.8775 | 18.8775 | 18.8768 | 18.8775 | 8400.0 |
| 2013-10-29 04:32:00 | AAPL | Stock | 18.8775 | 18.8775 | 18.8775 | 18.8775 | 2800.0 |
| 2013-10-29 04:35:00 | AAPL | Stock | 18.8571 | 18.8571 | 18.8571 | 18.8571 | 2800.0 |
| 2013-10-29 04:40:00 | AAPL | Stock | 18.8729 | 18.875 | 18.8729 | 18.875 | 8400.0 |
| 2013-10-29 04:41:00 | AAPL | Stock | 18.8739 | 18.8911 | 18.8739 | 18.8911 | 14000.0 |
| 2013-10-29 04:43:00 | AAPL | Stock | 18.8921 | 18.8936 | 18.8921 | 18.8936 | 14000.0 |
| 2013-10-29 04:44:00 | AAPL | Stock | 18.9054 | 18.9054 | 18.9054 | 18.9054 | 9800.0 |
| 2013-10-29 04:45:00 | AAPL | Stock | 18.9093 | 18.9179 | 18.9093 | 18.9161 | 19600.0 |
| 2013-10-29 04:50:00 | AAPL | Stock | 18.9161 | 18.9161 | 18.9161 | 18.9161 | 2800.0 |
| 2013-10-29 04:53:00 | AAPL | Stock | 18.9071 | 18.9071 | 18.9071 | 18.9071 | 2800.0 |
| 2013-10-29 04:59:00 | AAPL | Stock | 18.875 | 18.875 | 18.875 | 18.875 | 2800.0 |
| 2013-10-29 05:00:00 | AAPL | Stock | 18.9032 | 18.9068 | 18.9032 | 18.9068 | 11200.0 |
| 2013-10-29 05:07:00 | AAPL | Stock | 18.8754 | 18.8754 | 18.8754 | 18.8754 | 5572.0 |
| 2013-10-29 05:08:00 | AAPL | Stock | 18.875 | 18.875 | 18.875 | 18.875 | 2800.0 |
| 2013-10-29 05:09:00 | AAPL | Stock | 18.875 | 18.875 | 18.875 | 18.875 | 2800.0 |
| 2013-10-29 05:15:00 | AAPL | Stock | 18.8571 | 18.8571 | 18.8571 | 18.8571 | 5600.0 |
| 2013-10-29 05:17:00 | AAPL | Stock | 18.8729 | 18.8729 | 18.8729 | 18.8729 | 2800.0 |
| 2013-10-29 05:19:00 | AAPL | Stock | 18.8839 | 18.8839 | 18.8839 | 18.8839 | 2800.0 |
| 2013-10-29 05:20:00 | AAPL | Stock | 18.875 | 18.875 | 18.875 | 18.875 | 4200.0 |
| 2013-10-29 05:23:00 | AAPL | Stock | 18.8868 | 18.9089 | 18.8868 | 18.9089 | 15960.0 |
| 2013-10-29 05:28:00 | AAPL | Stock | 18.8929 | 18.8929 | 18.8929 | 18.8929 | 2800.0 |
| 2013-10-29 05:31:00 | AAPL | Stock | 18.9039 | 18.9039 | 18.9039 | 18.9039 | 2800.0 |
| 2013-10-29 05:35:00 | AAPL | Stock | 18.9143 | 18.9286 | 18.9118 | 18.9286 | 88760.0 |
| 2013-10-29 05:37:00 | AAPL | Stock | 18.9286 | 18.9286 | 18.9286 | 18.9286 | 2800.0 |
| 2013-10-29 05:41:00 | AAPL | Stock | 18.9464 | 18.9464 | 18.9464 | 18.9464 | 14000.0 |
| 2013-10-29 05:42:00 | AAPL | Stock | 18.9111 | 18.9111 | 18.9 | 18.9 | 14000.0 |
| 2013-10-29 05:43:00 | AAPL | Stock | 18.9282 | 18.9282 | 18.9282 | 18.9282 | 17052.0 |
| 2013-10-29 05:48:00 | AAPL | Stock | 18.9007 | 18.9007 | 18.9007 | 18.9007 | 2800.0 |
| 2013-10-29 05:49:00 | AAPL | Stock | 18.9282 | 18.9286 | 18.9282 | 18.9286 | 8400.0 |
| 2013-10-29 05:53:00 | AAPL | Stock | 18.9364 | 18.9364 | 18.9364 | 18.9364 | 2800.0 |
| 2013-10-29 05:54:00 | AAPL | Stock | 18.9443 | 18.9621 | 18.9443 | 18.9621 | 14000.0 |
| 2013-10-29 06:04:00 | AAPL | Stock | 18.9089 | 18.9268 | 18.9057 | 18.9268 | 28000.0 |
> showing 50 of 992,710 rows — these rows as CSV