PREVIEW / stock_1min / 2013-07-02
file: by_date/stock_1min/2013/2013-07-02.parquet size: 13.7 MB rows: 1,018,841 symbols: 2,838
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-07-02 04:26:00 | AAPL | Stock | 14.6829 | 14.6829 | 14.6829 | 14.6829 | 16800.0 |
| 2013-07-02 04:32:00 | AAPL | Stock | 14.6875 | 14.6875 | 14.6875 | 14.6875 | 2800.0 |
| 2013-07-02 04:42:00 | AAPL | Stock | 14.6882 | 14.6882 | 14.6882 | 14.6882 | 2800.0 |
| 2013-07-02 04:54:00 | AAPL | Stock | 14.6893 | 14.6893 | 14.6893 | 14.6893 | 2800.0 |
| 2013-07-02 05:32:00 | AAPL | Stock | 14.6821 | 14.6821 | 14.6821 | 14.6821 | 2800.0 |
| 2013-07-02 06:00:00 | AAPL | Stock | 14.655 | 14.655 | 14.6518 | 14.655 | 11200.0 |
| 2013-07-02 06:47:00 | AAPL | Stock | 14.6779 | 14.6779 | 14.6779 | 14.6779 | 2800.0 |
| 2013-07-02 07:02:00 | AAPL | Stock | 14.6729 | 14.6729 | 14.6729 | 14.6729 | 2800.0 |
| 2013-07-02 07:05:00 | AAPL | Stock | 14.6729 | 14.6729 | 14.6729 | 14.6729 | 2800.0 |
| 2013-07-02 07:06:00 | AAPL | Stock | 14.6732 | 14.6732 | 14.6732 | 14.6732 | 2800.0 |
| 2013-07-02 07:07:00 | AAPL | Stock | 14.665 | 14.6707 | 14.6607 | 14.6707 | 19600.0 |
| 2013-07-02 07:10:00 | AAPL | Stock | 14.6675 | 14.6675 | 14.6675 | 14.6675 | 2800.0 |
| 2013-07-02 07:11:00 | AAPL | Stock | 14.6661 | 14.6664 | 14.6661 | 14.6664 | 5600.0 |
| 2013-07-02 07:12:00 | AAPL | Stock | 14.6643 | 14.6643 | 14.6643 | 14.6643 | 5600.0 |
| 2013-07-02 07:17:00 | AAPL | Stock | 14.6643 | 14.665 | 14.6643 | 14.665 | 5600.0 |
| 2013-07-02 07:18:00 | AAPL | Stock | 14.6657 | 14.67 | 14.6657 | 14.67 | 25200.0 |
| 2013-07-02 07:20:00 | AAPL | Stock | 14.67 | 14.67 | 14.67 | 14.67 | 2800.0 |
| 2013-07-02 07:21:00 | AAPL | Stock | 14.6736 | 14.6821 | 14.6736 | 14.6821 | 42000.0 |
| 2013-07-02 07:22:00 | AAPL | Stock | 14.6857 | 14.6943 | 14.6857 | 14.6943 | 31500.0 |
| 2013-07-02 07:24:00 | AAPL | Stock | 14.7089 | 14.7132 | 14.7054 | 14.7132 | 47600.0 |
| 2013-07-02 07:25:00 | AAPL | Stock | 14.7118 | 14.7143 | 14.7118 | 14.7143 | 64400.0 |
| 2013-07-02 07:28:00 | AAPL | Stock | 14.7114 | 14.7232 | 14.7114 | 14.7164 | 63392.0 |
| 2013-07-02 07:29:00 | AAPL | Stock | 14.7161 | 14.7311 | 14.715 | 14.7307 | 43680.0 |
| 2013-07-02 07:30:00 | AAPL | Stock | 14.7311 | 14.7357 | 14.7311 | 14.7357 | 5600.0 |
| 2013-07-02 07:31:00 | AAPL | Stock | 14.7321 | 14.7321 | 14.7257 | 14.7268 | 16800.0 |
| 2013-07-02 07:32:00 | AAPL | Stock | 14.7232 | 14.7232 | 14.7232 | 14.7232 | 18200.0 |
| 2013-07-02 07:33:00 | AAPL | Stock | 14.7232 | 14.7268 | 14.7143 | 14.7236 | 56672.0 |
| 2013-07-02 07:34:00 | AAPL | Stock | 14.7232 | 14.7232 | 14.7232 | 14.7232 | 55692.0 |
| 2013-07-02 07:35:00 | AAPL | Stock | 14.7243 | 14.7243 | 14.7054 | 14.7054 | 19600.0 |
| 2013-07-02 07:37:00 | AAPL | Stock | 14.7071 | 14.7071 | 14.7071 | 14.7071 | 5600.0 |
| 2013-07-02 07:40:00 | AAPL | Stock | 14.6986 | 14.7143 | 14.6986 | 14.7143 | 40460.0 |
| 2013-07-02 07:42:00 | AAPL | Stock | 14.7225 | 14.7225 | 14.7204 | 14.7214 | 23716.0 |
| 2013-07-02 07:44:00 | AAPL | Stock | 14.7189 | 14.7196 | 14.7189 | 14.7196 | 18872.0 |
| 2013-07-02 07:47:00 | AAPL | Stock | 14.6975 | 14.6979 | 14.6964 | 14.6964 | 28140.0 |
| 2013-07-02 07:50:00 | AAPL | Stock | 14.7036 | 14.7036 | 14.7036 | 14.7036 | 22232.0 |
| 2013-07-02 07:54:00 | AAPL | Stock | 14.6929 | 14.6929 | 14.6929 | 14.6929 | 5600.0 |
| 2013-07-02 07:55:00 | AAPL | Stock | 14.6929 | 14.6929 | 14.6929 | 14.6929 | 2800.0 |
| 2013-07-02 07:56:00 | AAPL | Stock | 14.6929 | 14.6964 | 14.6929 | 14.6964 | 8400.0 |
| 2013-07-02 07:57:00 | AAPL | Stock | 14.685 | 14.685 | 14.6632 | 14.6632 | 56000.0 |
| 2013-07-02 07:58:00 | AAPL | Stock | 14.6746 | 14.675 | 14.6746 | 14.675 | 44800.0 |
| 2013-07-02 07:59:00 | AAPL | Stock | 14.6743 | 14.6804 | 14.6743 | 14.6804 | 67200.0 |
| 2013-07-02 08:00:00 | AAPL | Stock | 14.6843 | 14.7321 | 14.6671 | 14.6861 | 95620.0 |
| 2013-07-02 08:02:00 | AAPL | Stock | 14.6746 | 14.6746 | 14.6682 | 14.6682 | 33600.0 |
| 2013-07-02 08:03:00 | AAPL | Stock | 14.6721 | 14.6721 | 14.6529 | 14.6529 | 157640.0 |
| 2013-07-02 08:04:00 | AAPL | Stock | 14.6564 | 14.6571 | 14.6464 | 14.6536 | 107520.0 |
| 2013-07-02 08:05:00 | AAPL | Stock | 14.6536 | 14.6536 | 14.6536 | 14.6536 | 47600.0 |
| 2013-07-02 08:06:00 | AAPL | Stock | 14.6468 | 14.6586 | 14.6464 | 14.6586 | 29400.0 |
| 2013-07-02 08:07:00 | AAPL | Stock | 14.6586 | 14.6586 | 14.6471 | 14.6471 | 65044.0 |
| 2013-07-02 08:09:00 | AAPL | Stock | 14.6496 | 14.6568 | 14.6496 | 14.6568 | 38080.0 |
| 2013-07-02 08:10:00 | AAPL | Stock | 14.655 | 14.655 | 14.6518 | 14.6518 | 11200.0 |
> showing 50 of 1,018,841 rows — these rows as CSV