PREVIEW / stock_1min / 2013-05-15
file: by_date/stock_1min/2013/2013-05-15.parquet size: 13.7 MB rows: 998,020 symbols: 2,845
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-05-15 04:00:00 | AAPL | Stock | 15.7857 | 15.7857 | 15.7857 | 15.7857 | 5600.0 |
| 2013-05-15 04:39:00 | AAPL | Stock | 15.7857 | 15.7857 | 15.7857 | 15.7857 | 2800.0 |
| 2013-05-15 05:37:00 | AAPL | Stock | 15.7879 | 15.7879 | 15.7857 | 15.7857 | 8400.0 |
| 2013-05-15 06:09:00 | AAPL | Stock | 15.7864 | 15.7864 | 15.7864 | 15.7864 | 5264.0 |
| 2013-05-15 06:14:00 | AAPL | Stock | 15.7968 | 15.7968 | 15.7968 | 15.7968 | 2800.0 |
| 2013-05-15 06:32:00 | AAPL | Stock | 15.8018 | 15.8018 | 15.8018 | 15.8018 | 3556.0 |
| 2013-05-15 06:43:00 | AAPL | Stock | 15.8161 | 15.8161 | 15.8161 | 15.8161 | 5600.0 |
| 2013-05-15 06:53:00 | AAPL | Stock | 15.7957 | 15.7957 | 15.7957 | 15.7957 | 2800.0 |
| 2013-05-15 07:02:00 | AAPL | Stock | 15.8129 | 15.8129 | 15.8129 | 15.8129 | 2800.0 |
| 2013-05-15 07:04:00 | AAPL | Stock | 15.7971 | 15.7971 | 15.7857 | 15.7857 | 18564.0 |
| 2013-05-15 07:05:00 | AAPL | Stock | 15.7857 | 15.7857 | 15.7857 | 15.7857 | 5600.0 |
| 2013-05-15 07:07:00 | AAPL | Stock | 15.7857 | 15.7857 | 15.7857 | 15.7857 | 2800.0 |
| 2013-05-15 07:09:00 | AAPL | Stock | 15.7689 | 15.7689 | 15.7689 | 15.7689 | 2800.0 |
| 2013-05-15 07:10:00 | AAPL | Stock | 15.75 | 15.75 | 15.75 | 15.75 | 27076.0 |
| 2013-05-15 07:12:00 | AAPL | Stock | 15.7593 | 15.7593 | 15.7593 | 15.7593 | 2800.0 |
| 2013-05-15 07:13:00 | AAPL | Stock | 15.7679 | 15.7679 | 15.7679 | 15.7679 | 4088.0 |
| 2013-05-15 07:18:00 | AAPL | Stock | 15.7693 | 15.7732 | 15.7693 | 15.7732 | 22400.0 |
| 2013-05-15 07:19:00 | AAPL | Stock | 15.7679 | 15.7679 | 15.7679 | 15.7679 | 5600.0 |
| 2013-05-15 07:20:00 | AAPL | Stock | 15.7714 | 15.7714 | 15.7714 | 15.7714 | 14000.0 |
| 2013-05-15 07:21:00 | AAPL | Stock | 15.7696 | 15.7714 | 15.7679 | 15.7679 | 27636.0 |
| 2013-05-15 07:25:00 | AAPL | Stock | 15.7821 | 15.785 | 15.7821 | 15.785 | 8400.0 |
| 2013-05-15 07:26:00 | AAPL | Stock | 15.7789 | 15.7789 | 15.7789 | 15.7789 | 2800.0 |
| 2013-05-15 07:29:00 | AAPL | Stock | 15.7857 | 15.7857 | 15.7857 | 15.7857 | 8400.0 |
| 2013-05-15 07:43:00 | AAPL | Stock | 15.7964 | 15.8 | 15.7964 | 15.8 | 5600.0 |
| 2013-05-15 07:47:00 | AAPL | Stock | 15.8014 | 15.8107 | 15.8014 | 15.8107 | 30800.0 |
| 2013-05-15 07:49:00 | AAPL | Stock | 15.82 | 15.82 | 15.82 | 15.82 | 2800.0 |
| 2013-05-15 07:51:00 | AAPL | Stock | 15.8218 | 15.8225 | 15.8161 | 15.8161 | 30800.0 |
| 2013-05-15 07:53:00 | AAPL | Stock | 15.8114 | 15.8139 | 15.8114 | 15.8139 | 5600.0 |
| 2013-05-15 07:54:00 | AAPL | Stock | 15.8104 | 15.8104 | 15.8036 | 15.8036 | 44800.0 |
| 2013-05-15 07:55:00 | AAPL | Stock | 15.8011 | 15.8011 | 15.8011 | 15.8011 | 2800.0 |
| 2013-05-15 07:56:00 | AAPL | Stock | 15.8029 | 15.8032 | 15.8029 | 15.8032 | 5600.0 |
| 2013-05-15 07:59:00 | AAPL | Stock | 15.8071 | 15.8071 | 15.8071 | 15.8071 | 2800.0 |
| 2013-05-15 08:00:00 | AAPL | Stock | 15.8036 | 15.8214 | 15.75 | 15.8043 | 134260.0 |
| 2013-05-15 08:01:00 | AAPL | Stock | 15.8107 | 15.8121 | 15.8039 | 15.8039 | 9912.0 |
| 2013-05-15 08:02:00 | AAPL | Stock | 15.8036 | 15.8214 | 15.8036 | 15.8214 | 29008.0 |
| 2013-05-15 08:03:00 | AAPL | Stock | 15.8143 | 15.8143 | 15.8036 | 15.8036 | 15232.0 |
| 2013-05-15 08:04:00 | AAPL | Stock | 15.8071 | 15.8168 | 15.8071 | 15.8168 | 9268.0 |
| 2013-05-15 08:06:00 | AAPL | Stock | 15.8179 | 15.8179 | 15.8179 | 15.8179 | 6160.0 |
| 2013-05-15 08:07:00 | AAPL | Stock | 15.8214 | 15.8264 | 15.8214 | 15.8264 | 21280.0 |
| 2013-05-15 08:08:00 | AAPL | Stock | 15.8264 | 15.8332 | 15.8264 | 15.8332 | 11200.0 |
| 2013-05-15 08:10:00 | AAPL | Stock | 15.8286 | 15.8286 | 15.8286 | 15.8286 | 2800.0 |
| 2013-05-15 08:11:00 | AAPL | Stock | 15.8286 | 15.8286 | 15.8268 | 15.8268 | 35308.0 |
| 2013-05-15 08:12:00 | AAPL | Stock | 15.8268 | 15.8268 | 15.8268 | 15.8268 | 12180.0 |
| 2013-05-15 08:13:00 | AAPL | Stock | 15.825 | 15.8268 | 15.825 | 15.8268 | 14000.0 |
| 2013-05-15 08:14:00 | AAPL | Stock | 15.8268 | 15.8268 | 15.8268 | 15.8268 | 7000.0 |
| 2013-05-15 08:16:00 | AAPL | Stock | 15.8214 | 15.8214 | 15.8175 | 15.8214 | 60200.0 |
| 2013-05-15 08:17:00 | AAPL | Stock | 15.815 | 15.815 | 15.815 | 15.815 | 5600.0 |
| 2013-05-15 08:19:00 | AAPL | Stock | 15.8214 | 15.8225 | 15.8214 | 15.8225 | 9912.0 |
| 2013-05-15 08:20:00 | AAPL | Stock | 15.8214 | 15.8286 | 15.8214 | 15.8286 | 41832.0 |
| 2013-05-15 08:21:00 | AAPL | Stock | 15.8295 | 15.8295 | 15.8214 | 15.8214 | 5600.0 |
> showing 50 of 998,020 rows — these rows as CSV