PREVIEW / stock_1min / 2013-08-21
file: by_date/stock_1min/2013/2013-08-21.parquet size: 13.2 MB rows: 968,288 symbols: 2,860
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-08-21 04:00:00 | AAPL | Stock | 17.9196 | 17.9196 | 17.9196 | 17.9196 | 11200.0 |
| 2013-08-21 04:02:00 | AAPL | Stock | 17.9089 | 17.9089 | 17.9089 | 17.9089 | 2800.0 |
| 2013-08-21 05:24:00 | AAPL | Stock | 17.9136 | 17.9136 | 17.9136 | 17.9136 | 2800.0 |
| 2013-08-21 05:56:00 | AAPL | Stock | 17.9143 | 17.9143 | 17.9143 | 17.9143 | 2800.0 |
| 2013-08-21 05:58:00 | AAPL | Stock | 17.8775 | 17.8775 | 17.8775 | 17.8775 | 2800.0 |
| 2013-08-21 06:09:00 | AAPL | Stock | 17.8607 | 17.8607 | 17.8607 | 17.8607 | 2800.0 |
| 2013-08-21 06:27:00 | AAPL | Stock | 17.8929 | 17.8929 | 17.8929 | 17.8929 | 2800.0 |
| 2013-08-21 06:35:00 | AAPL | Stock | 17.8571 | 17.8571 | 17.8571 | 17.8571 | 120344.0 |
| 2013-08-21 06:36:00 | AAPL | Stock | 17.8571 | 17.8571 | 17.8571 | 17.8571 | 2800.0 |
| 2013-08-21 06:37:00 | AAPL | Stock | 17.8571 | 17.8571 | 17.8571 | 17.8571 | 56000.0 |
| 2013-08-21 06:39:00 | AAPL | Stock | 17.8575 | 17.8575 | 17.8575 | 17.8575 | 11144.0 |
| 2013-08-21 06:40:00 | AAPL | Stock | 17.8579 | 17.8886 | 17.8571 | 17.8596 | 28000.0 |
| 2013-08-21 06:42:00 | AAPL | Stock | 17.8946 | 17.8946 | 17.8886 | 17.8886 | 8400.0 |
| 2013-08-21 06:43:00 | AAPL | Stock | 17.885 | 17.885 | 17.885 | 17.885 | 2800.0 |
| 2013-08-21 06:44:00 | AAPL | Stock | 17.8929 | 17.8929 | 17.8929 | 17.8929 | 2800.0 |
| 2013-08-21 06:47:00 | AAPL | Stock | 17.8793 | 17.8793 | 17.8793 | 17.8793 | 2800.0 |
| 2013-08-21 06:48:00 | AAPL | Stock | 17.86 | 17.86 | 17.86 | 17.86 | 2800.0 |
| 2013-08-21 06:49:00 | AAPL | Stock | 17.8754 | 17.8754 | 17.8754 | 17.8754 | 2800.0 |
| 2013-08-21 06:53:00 | AAPL | Stock | 17.8618 | 17.8618 | 17.8582 | 17.8582 | 5600.0 |
| 2013-08-21 06:57:00 | AAPL | Stock | 17.8571 | 17.8571 | 17.8571 | 17.8571 | 2800.0 |
| 2013-08-21 06:58:00 | AAPL | Stock | 17.8568 | 17.8811 | 17.8568 | 17.8811 | 11200.0 |
| 2013-08-21 07:05:00 | AAPL | Stock | 17.8575 | 17.8575 | 17.8575 | 17.8575 | 8372.0 |
| 2013-08-21 07:09:00 | AAPL | Stock | 17.8661 | 17.8661 | 17.8661 | 17.8661 | 2800.0 |
| 2013-08-21 07:10:00 | AAPL | Stock | 17.88 | 17.8811 | 17.88 | 17.8811 | 5600.0 |
| 2013-08-21 07:11:00 | AAPL | Stock | 17.88 | 17.88 | 17.8589 | 17.8589 | 19264.0 |
| 2013-08-21 07:16:00 | AAPL | Stock | 17.8643 | 17.8643 | 17.8643 | 17.8643 | 8400.0 |
| 2013-08-21 07:17:00 | AAPL | Stock | 17.8679 | 17.8679 | 17.8679 | 17.8679 | 2800.0 |
| 2013-08-21 07:19:00 | AAPL | Stock | 17.88 | 17.88 | 17.88 | 17.88 | 4200.0 |
| 2013-08-21 07:20:00 | AAPL | Stock | 17.8864 | 17.8864 | 17.8857 | 17.8857 | 5600.0 |
| 2013-08-21 07:23:00 | AAPL | Stock | 17.9007 | 17.9064 | 17.8964 | 17.8964 | 14000.0 |
| 2013-08-21 07:24:00 | AAPL | Stock | 17.9057 | 17.9057 | 17.8971 | 17.8971 | 11760.0 |
| 2013-08-21 07:25:00 | AAPL | Stock | 17.9046 | 17.9107 | 17.9046 | 17.9089 | 19880.0 |
| 2013-08-21 07:26:00 | AAPL | Stock | 17.9236 | 17.9236 | 17.9236 | 17.9236 | 2800.0 |
| 2013-08-21 07:28:00 | AAPL | Stock | 17.9289 | 17.9289 | 17.925 | 17.925 | 18144.0 |
| 2013-08-21 07:30:00 | AAPL | Stock | 17.9146 | 17.925 | 17.9146 | 17.925 | 8148.0 |
| 2013-08-21 07:31:00 | AAPL | Stock | 17.9286 | 17.9286 | 17.9286 | 17.9286 | 28000.0 |
| 2013-08-21 07:40:00 | AAPL | Stock | 17.9368 | 17.9368 | 17.9368 | 17.9368 | 2800.0 |
| 2013-08-21 07:41:00 | AAPL | Stock | 17.9464 | 17.9464 | 17.9325 | 17.9325 | 27216.0 |
| 2013-08-21 07:42:00 | AAPL | Stock | 17.935 | 17.935 | 17.9232 | 17.9232 | 56924.0 |
| 2013-08-21 07:43:00 | AAPL | Stock | 17.9264 | 17.9264 | 17.9196 | 17.9196 | 8064.0 |
| 2013-08-21 07:44:00 | AAPL | Stock | 17.9257 | 17.9286 | 17.9257 | 17.9268 | 22400.0 |
| 2013-08-21 07:45:00 | AAPL | Stock | 17.9321 | 17.9321 | 17.9321 | 17.9321 | 7140.0 |
| 2013-08-21 07:46:00 | AAPL | Stock | 17.9443 | 17.945 | 17.9321 | 17.9321 | 11704.0 |
| 2013-08-21 07:47:00 | AAPL | Stock | 17.9443 | 17.9643 | 17.9443 | 17.9643 | 22064.0 |
| 2013-08-21 07:48:00 | AAPL | Stock | 17.9471 | 17.9554 | 17.9457 | 17.9554 | 38752.0 |
| 2013-08-21 07:49:00 | AAPL | Stock | 17.9554 | 17.9864 | 17.9554 | 17.9786 | 53340.0 |
| 2013-08-21 07:50:00 | AAPL | Stock | 17.9836 | 17.9836 | 17.9793 | 17.9793 | 8400.0 |
| 2013-08-21 07:51:00 | AAPL | Stock | 17.9821 | 17.9821 | 17.9718 | 17.9732 | 40880.0 |
| 2013-08-21 07:52:00 | AAPL | Stock | 17.9807 | 17.9839 | 17.9807 | 17.9839 | 11200.0 |
| 2013-08-21 07:53:00 | AAPL | Stock | 17.9682 | 17.9682 | 17.9654 | 17.9654 | 8400.0 |
> showing 50 of 968,288 rows — these rows as CSV