PREVIEW / stock_5min / 2013-02-28
file: by_date/stock_5min/2013/2013-02-28.parquet size: 5.1 MB rows: 337,858 symbols: 3,462
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-02-28 05:50:00 | AAPL | Stock | 15.8964 | 15.8964 | 15.8964 | 15.8964 | 58800.0 |
| 2013-02-28 07:00:00 | AAPL | Stock | 15.8929 | 15.8964 | 15.8929 | 15.8929 | 11200.0 |
| 2013-02-28 07:05:00 | AAPL | Stock | 15.9036 | 15.9036 | 15.9036 | 15.9036 | 11200.0 |
| 2013-02-28 07:10:00 | AAPL | Stock | 15.9043 | 15.9043 | 15.9039 | 15.9039 | 5600.0 |
| 2013-02-28 07:15:00 | AAPL | Stock | 15.91 | 15.9107 | 15.9036 | 15.9036 | 37912.0 |
| 2013-02-28 07:20:00 | AAPL | Stock | 15.9 | 15.9 | 15.8929 | 15.8929 | 11200.0 |
| 2013-02-28 07:35:00 | AAPL | Stock | 15.8996 | 15.9 | 15.8982 | 15.9 | 28000.0 |
| 2013-02-28 07:40:00 | AAPL | Stock | 15.9004 | 15.9093 | 15.9004 | 15.9093 | 5600.0 |
| 2013-02-28 07:45:00 | AAPL | Stock | 15.9 | 15.9 | 15.8982 | 15.8982 | 16996.0 |
| 2013-02-28 07:50:00 | AAPL | Stock | 15.8993 | 15.8993 | 15.8786 | 15.8786 | 69832.0 |
| 2013-02-28 07:55:00 | AAPL | Stock | 15.8796 | 15.8796 | 15.8571 | 15.8746 | 187684.0 |
| 2013-02-28 08:00:00 | AAPL | Stock | 15.9018 | 15.9211 | 15.8571 | 15.8675 | 89404.0 |
| 2013-02-28 08:05:00 | AAPL | Stock | 15.8693 | 15.8893 | 15.85 | 15.85 | 114184.0 |
| 2013-02-28 08:10:00 | AAPL | Stock | 15.8589 | 15.8679 | 15.8589 | 15.8643 | 33488.0 |
| 2013-02-28 08:15:00 | AAPL | Stock | 15.8729 | 15.8929 | 15.8729 | 15.8896 | 54600.0 |
| 2013-02-28 08:20:00 | AAPL | Stock | 15.8821 | 15.8821 | 15.8504 | 15.8639 | 126616.0 |
| 2013-02-28 08:25:00 | AAPL | Stock | 15.8604 | 15.8661 | 15.8525 | 15.8636 | 27160.0 |
| 2013-02-28 08:30:00 | AAPL | Stock | 15.8571 | 15.8643 | 15.8461 | 15.8643 | 147532.0 |
| 2013-02-28 08:35:00 | AAPL | Stock | 15.8582 | 15.8582 | 15.8307 | 15.8493 | 154980.0 |
| 2013-02-28 08:40:00 | AAPL | Stock | 15.8514 | 15.8571 | 15.8464 | 15.8571 | 48860.0 |
| 2013-02-28 08:45:00 | AAPL | Stock | 15.8564 | 15.8664 | 15.8564 | 15.8664 | 39200.0 |
| 2013-02-28 08:50:00 | AAPL | Stock | 15.8607 | 15.8625 | 15.8607 | 15.8625 | 5600.0 |
| 2013-02-28 08:55:00 | AAPL | Stock | 15.8657 | 15.8661 | 15.8589 | 15.865 | 21000.0 |
| 2013-02-28 09:00:00 | AAPL | Stock | 15.8657 | 15.8661 | 15.8468 | 15.8468 | 101780.0 |
| 2013-02-28 09:05:00 | AAPL | Stock | 15.8446 | 15.8525 | 15.8393 | 15.8518 | 44800.0 |
| 2013-02-28 09:10:00 | AAPL | Stock | 15.8525 | 15.8575 | 15.8525 | 15.8575 | 63000.0 |
| 2013-02-28 09:15:00 | AAPL | Stock | 15.865 | 15.8836 | 15.8575 | 15.8821 | 127764.0 |
| 2013-02-28 09:20:00 | AAPL | Stock | 15.8818 | 15.8818 | 15.8571 | 15.8736 | 149184.0 |
| 2013-02-28 09:25:00 | AAPL | Stock | 15.8643 | 15.865 | 15.8571 | 15.865 | 53732.0 |
| 2013-02-28 09:30:00 | AAPL | Stock | 15.8589 | 15.9286 | 15.8214 | 15.9175 | 14263116.0 |
| 2013-02-28 09:35:00 | AAPL | Stock | 15.9164 | 15.9779 | 15.8871 | 15.9643 | 11631228.0 |
| 2013-02-28 09:40:00 | AAPL | Stock | 15.9618 | 15.9777 | 15.9182 | 15.9228 | 8104880.0 |
| 2013-02-28 09:45:00 | AAPL | Stock | 15.92 | 15.9464 | 15.8929 | 15.8993 | 7348796.0 |
| 2013-02-28 09:50:00 | AAPL | Stock | 15.9036 | 15.9118 | 15.8625 | 15.8761 | 7336084.0 |
| 2013-02-28 09:55:00 | AAPL | Stock | 15.8779 | 15.8992 | 15.8761 | 15.8896 | 3890432.0 |
| 2013-02-28 10:00:00 | AAPL | Stock | 15.8843 | 15.8992 | 15.8404 | 15.8686 | 7005516.0 |
| 2013-02-28 10:05:00 | AAPL | Stock | 15.8671 | 15.9286 | 15.8561 | 15.9166 | 6539484.0 |
| 2013-02-28 10:10:00 | AAPL | Stock | 15.9129 | 15.9739 | 15.8936 | 15.9627 | 7111776.0 |
| 2013-02-28 10:15:00 | AAPL | Stock | 15.9604 | 15.9954 | 15.9364 | 15.9518 | 6814724.0 |
| 2013-02-28 10:20:00 | AAPL | Stock | 15.9507 | 15.9586 | 15.9111 | 15.9111 | 3225628.0 |
| 2013-02-28 10:25:00 | AAPL | Stock | 15.9113 | 15.9364 | 15.9111 | 15.9221 | 2236472.0 |
| 2013-02-28 10:30:00 | AAPL | Stock | 15.9214 | 15.9286 | 15.8971 | 15.9075 | 3429020.0 |
| 2013-02-28 10:35:00 | AAPL | Stock | 15.9095 | 15.9236 | 15.8796 | 15.88 | 4025924.0 |
| 2013-02-28 10:40:00 | AAPL | Stock | 15.8804 | 15.9146 | 15.8804 | 15.9093 | 3075296.0 |
| 2013-02-28 10:45:00 | AAPL | Stock | 15.9039 | 15.9159 | 15.8929 | 15.8968 | 2620156.0 |
| 2013-02-28 10:50:00 | AAPL | Stock | 15.8954 | 15.8975 | 15.8571 | 15.8679 | 2985360.0 |
| 2013-02-28 10:55:00 | AAPL | Stock | 15.8643 | 15.8821 | 15.8411 | 15.8779 | 5252828.0 |
| 2013-02-28 11:00:00 | AAPL | Stock | 15.8775 | 15.8821 | 15.8504 | 15.8757 | 2701832.0 |
| 2013-02-28 11:05:00 | AAPL | Stock | 15.8757 | 15.9143 | 15.8757 | 15.9085 | 4122636.0 |
| 2013-02-28 11:10:00 | AAPL | Stock | 15.9082 | 15.9286 | 15.8982 | 15.9054 | 2891364.0 |
> showing 50 of 337,858 rows — these rows as CSV