PREVIEW / stock_1min / 2014-02-25
file: by_date/stock_1min/2014/2014-02-25.parquet size: 14.5 MB rows: 1,048,108 symbols: 2,854
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 |
|---|---|---|---|---|---|---|---|
| 2014-02-25 04:00:00 | AAPL | Stock | 18.8429 | 18.8429 | 18.6361 | 18.8232 | 8400.0 |
| 2014-02-25 04:07:00 | AAPL | Stock | 18.8321 | 18.8321 | 18.8321 | 18.8321 | 2800.0 |
| 2014-02-25 04:35:00 | AAPL | Stock | 18.8214 | 18.8214 | 18.8139 | 18.8139 | 5600.0 |
| 2014-02-25 04:37:00 | AAPL | Stock | 18.8036 | 18.8036 | 18.8036 | 18.8036 | 2800.0 |
| 2014-02-25 05:41:00 | AAPL | Stock | 18.8204 | 18.8204 | 18.8204 | 18.8204 | 11200.0 |
| 2014-02-25 06:51:00 | AAPL | Stock | 18.8643 | 18.8661 | 18.8643 | 18.8661 | 14000.0 |
| 2014-02-25 07:06:00 | AAPL | Stock | 18.8661 | 18.8661 | 18.8661 | 18.8661 | 2800.0 |
| 2014-02-25 07:07:00 | AAPL | Stock | 18.8657 | 18.8925 | 18.8571 | 18.8571 | 28000.0 |
| 2014-02-25 07:20:00 | AAPL | Stock | 18.8696 | 18.8696 | 18.8596 | 18.8596 | 11200.0 |
| 2014-02-25 07:21:00 | AAPL | Stock | 18.8571 | 18.8571 | 18.8571 | 18.8571 | 5600.0 |
| 2014-02-25 07:22:00 | AAPL | Stock | 18.845 | 18.845 | 18.8411 | 18.8411 | 11200.0 |
| 2014-02-25 07:32:00 | AAPL | Stock | 18.8429 | 18.8429 | 18.8429 | 18.8429 | 6776.0 |
| 2014-02-25 07:51:00 | AAPL | Stock | 18.8571 | 18.8571 | 18.8571 | 18.8571 | 2800.0 |
| 2014-02-25 07:52:00 | AAPL | Stock | 18.8614 | 18.8621 | 18.8614 | 18.8621 | 5600.0 |
| 2014-02-25 08:00:00 | AAPL | Stock | 18.8411 | 18.8664 | 18.8411 | 18.8411 | 16100.0 |
| 2014-02-25 08:01:00 | AAPL | Stock | 18.8693 | 18.8889 | 18.8693 | 18.8889 | 20720.0 |
| 2014-02-25 08:08:00 | AAPL | Stock | 18.8868 | 18.8868 | 18.8868 | 18.8868 | 3500.0 |
| 2014-02-25 08:11:00 | AAPL | Stock | 18.8875 | 18.8875 | 18.8875 | 18.8875 | 2800.0 |
| 2014-02-25 08:15:00 | AAPL | Stock | 18.8743 | 18.8743 | 18.8743 | 18.8743 | 8400.0 |
| 2014-02-25 08:16:00 | AAPL | Stock | 18.8857 | 18.8871 | 18.8857 | 18.8871 | 5600.0 |
| 2014-02-25 08:17:00 | AAPL | Stock | 18.8857 | 18.8857 | 18.8846 | 18.8846 | 5600.0 |
| 2014-02-25 08:20:00 | AAPL | Stock | 18.8771 | 18.8839 | 18.8771 | 18.8839 | 44800.0 |
| 2014-02-25 08:24:00 | AAPL | Stock | 18.8839 | 18.8839 | 18.8839 | 18.8839 | 14000.0 |
| 2014-02-25 08:25:00 | AAPL | Stock | 18.875 | 18.875 | 18.8607 | 18.8607 | 13524.0 |
| 2014-02-25 08:27:00 | AAPL | Stock | 18.8607 | 18.8607 | 18.8607 | 18.8607 | 14000.0 |
| 2014-02-25 08:28:00 | AAPL | Stock | 18.8825 | 18.8886 | 18.8825 | 18.8839 | 45276.0 |
| 2014-02-25 08:29:00 | AAPL | Stock | 18.8825 | 18.8825 | 18.8786 | 18.8786 | 11200.0 |
| 2014-02-25 08:33:00 | AAPL | Stock | 18.8825 | 18.8857 | 18.8821 | 18.8857 | 8876.0 |
| 2014-02-25 08:34:00 | AAPL | Stock | 18.8857 | 18.8857 | 18.8857 | 18.8857 | 5600.0 |
| 2014-02-25 08:35:00 | AAPL | Stock | 18.8875 | 18.8875 | 18.885 | 18.885 | 14504.0 |
| 2014-02-25 08:37:00 | AAPL | Stock | 18.8746 | 18.8746 | 18.8746 | 18.8746 | 2800.0 |
| 2014-02-25 08:39:00 | AAPL | Stock | 18.8818 | 18.8818 | 18.8818 | 18.8818 | 2800.0 |
| 2014-02-25 08:41:00 | AAPL | Stock | 18.8675 | 18.8679 | 18.8675 | 18.8679 | 5600.0 |
| 2014-02-25 08:42:00 | AAPL | Stock | 18.8636 | 18.8754 | 18.8621 | 18.8754 | 30800.0 |
| 2014-02-25 08:43:00 | AAPL | Stock | 18.8786 | 18.8786 | 18.8786 | 18.8786 | 5600.0 |
| 2014-02-25 08:44:00 | AAPL | Stock | 18.8857 | 18.8875 | 18.8843 | 18.8843 | 16800.0 |
| 2014-02-25 08:45:00 | AAPL | Stock | 18.8843 | 18.8843 | 18.8843 | 18.8843 | 2800.0 |
| 2014-02-25 08:46:00 | AAPL | Stock | 18.8861 | 18.8861 | 18.8861 | 18.8861 | 2800.0 |
| 2014-02-25 08:47:00 | AAPL | Stock | 18.8857 | 18.8882 | 18.8857 | 18.8871 | 47152.0 |
| 2014-02-25 08:48:00 | AAPL | Stock | 18.8864 | 18.8864 | 18.8857 | 18.8857 | 5600.0 |
| 2014-02-25 08:49:00 | AAPL | Stock | 18.8882 | 18.8882 | 18.8882 | 18.8882 | 2800.0 |
| 2014-02-25 08:50:00 | AAPL | Stock | 18.8846 | 18.8854 | 18.875 | 18.875 | 33600.0 |
| 2014-02-25 08:57:00 | AAPL | Stock | 18.8807 | 18.8807 | 18.8807 | 18.8807 | 2800.0 |
| 2014-02-25 08:58:00 | AAPL | Stock | 18.8814 | 18.8839 | 18.8814 | 18.8839 | 5600.0 |
| 2014-02-25 09:02:00 | AAPL | Stock | 18.8836 | 18.8839 | 18.8836 | 18.8839 | 5600.0 |
| 2014-02-25 09:03:00 | AAPL | Stock | 18.8836 | 18.8839 | 18.8836 | 18.8839 | 12320.0 |
| 2014-02-25 09:08:00 | AAPL | Stock | 18.8889 | 18.8964 | 18.8889 | 18.8964 | 100940.0 |
| 2014-02-25 09:09:00 | AAPL | Stock | 18.8993 | 18.8993 | 18.8993 | 18.8993 | 2800.0 |
| 2014-02-25 09:10:00 | AAPL | Stock | 18.91 | 18.9107 | 18.9007 | 18.9007 | 76020.0 |
| 2014-02-25 09:12:00 | AAPL | Stock | 18.9068 | 18.9107 | 18.9068 | 18.9089 | 56000.0 |
> showing 50 of 1,048,108 rows — these rows as CSV