PREVIEW / stock_1min / 2013-01-09
file: by_date/stock_1min/2013/2013-01-09.parquet size: 12.8 MB rows: 949,418 symbols: 2,796
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-01-09 04:00:00 | AAPL | Stock | 18.8571 | 18.8571 | 18.8571 | 18.8571 | 2800.0 |
| 2013-01-09 04:13:00 | AAPL | Stock | 18.8282 | 18.8282 | 18.8279 | 18.8279 | 5600.0 |
| 2013-01-09 04:23:00 | AAPL | Stock | 18.8107 | 18.8107 | 18.8107 | 18.8107 | 2800.0 |
| 2013-01-09 04:47:00 | AAPL | Stock | 18.8207 | 18.8207 | 18.8207 | 18.8207 | 2800.0 |
| 2013-01-09 04:49:00 | AAPL | Stock | 18.8157 | 18.8157 | 18.8157 | 18.8157 | 2800.0 |
| 2013-01-09 05:19:00 | AAPL | Stock | 18.8161 | 18.8161 | 18.8161 | 18.8161 | 2800.0 |
| 2013-01-09 05:29:00 | AAPL | Stock | 18.8161 | 18.8161 | 18.8161 | 18.8161 | 2800.0 |
| 2013-01-09 05:50:00 | AAPL | Stock | 18.8157 | 18.8157 | 18.8157 | 18.8157 | 8400.0 |
| 2013-01-09 05:52:00 | AAPL | Stock | 18.8057 | 18.8057 | 18.8057 | 18.8057 | 2800.0 |
| 2013-01-09 06:08:00 | AAPL | Stock | 18.8161 | 18.8161 | 18.8161 | 18.8161 | 2800.0 |
| 2013-01-09 06:15:00 | AAPL | Stock | 18.8089 | 18.8161 | 18.8089 | 18.8161 | 15204.0 |
| 2013-01-09 06:16:00 | AAPL | Stock | 18.8161 | 18.8161 | 18.8161 | 18.8161 | 2800.0 |
| 2013-01-09 06:18:00 | AAPL | Stock | 18.8036 | 18.8036 | 18.8036 | 18.8036 | 8400.0 |
| 2013-01-09 06:30:00 | AAPL | Stock | 18.7964 | 18.7964 | 18.7964 | 18.7964 | 4900.0 |
| 2013-01-09 06:33:00 | AAPL | Stock | 18.8036 | 18.8036 | 18.8036 | 18.8036 | 4480.0 |
| 2013-01-09 06:45:00 | AAPL | Stock | 18.7857 | 18.7857 | 18.7857 | 18.7857 | 2800.0 |
| 2013-01-09 06:48:00 | AAPL | Stock | 18.775 | 18.775 | 18.775 | 18.775 | 2800.0 |
| 2013-01-09 06:49:00 | AAPL | Stock | 18.7686 | 18.7686 | 18.7679 | 18.7679 | 61460.0 |
| 2013-01-09 06:50:00 | AAPL | Stock | 18.7671 | 18.7671 | 18.7671 | 18.7671 | 2800.0 |
| 2013-01-09 07:01:00 | AAPL | Stock | 18.7504 | 18.7507 | 18.7504 | 18.7504 | 65436.0 |
| 2013-01-09 07:03:00 | AAPL | Stock | 18.75 | 18.75 | 18.75 | 18.75 | 6300.0 |
| 2013-01-09 07:04:00 | AAPL | Stock | 18.7321 | 18.7321 | 18.7321 | 18.7321 | 2800.0 |
| 2013-01-09 07:06:00 | AAPL | Stock | 18.7321 | 18.7321 | 18.7321 | 18.7321 | 2800.0 |
| 2013-01-09 07:08:00 | AAPL | Stock | 18.7321 | 18.7321 | 18.7321 | 18.7321 | 8400.0 |
| 2013-01-09 07:09:00 | AAPL | Stock | 18.7411 | 18.7411 | 18.7411 | 18.7411 | 2800.0 |
| 2013-01-09 07:10:00 | AAPL | Stock | 18.75 | 18.75 | 18.75 | 18.75 | 5600.0 |
| 2013-01-09 07:11:00 | AAPL | Stock | 18.7518 | 18.7518 | 18.75 | 18.75 | 8400.0 |
| 2013-01-09 07:12:00 | AAPL | Stock | 18.75 | 18.75 | 18.75 | 18.75 | 2800.0 |
| 2013-01-09 07:17:00 | AAPL | Stock | 18.7496 | 18.7496 | 18.7496 | 18.7496 | 2800.0 |
| 2013-01-09 07:19:00 | AAPL | Stock | 18.7629 | 18.7857 | 18.7629 | 18.7857 | 27692.0 |
| 2013-01-09 07:20:00 | AAPL | Stock | 18.7857 | 18.8211 | 18.7857 | 18.7857 | 94640.0 |
| 2013-01-09 07:21:00 | AAPL | Stock | 18.8014 | 18.8018 | 18.7861 | 18.8018 | 22120.0 |
| 2013-01-09 07:23:00 | AAPL | Stock | 18.8036 | 18.8036 | 18.8036 | 18.8036 | 4200.0 |
| 2013-01-09 07:24:00 | AAPL | Stock | 18.8036 | 18.8036 | 18.8036 | 18.8036 | 2800.0 |
| 2013-01-09 07:26:00 | AAPL | Stock | 18.8029 | 18.8029 | 18.8014 | 18.8014 | 8400.0 |
| 2013-01-09 07:27:00 | AAPL | Stock | 18.8104 | 18.8121 | 18.8104 | 18.8121 | 22960.0 |
| 2013-01-09 07:33:00 | AAPL | Stock | 18.8 | 18.8 | 18.8 | 18.8 | 2800.0 |
| 2013-01-09 07:34:00 | AAPL | Stock | 18.8096 | 18.8096 | 18.8096 | 18.8096 | 2800.0 |
| 2013-01-09 07:35:00 | AAPL | Stock | 18.8104 | 18.8104 | 18.8104 | 18.8104 | 2800.0 |
| 2013-01-09 07:37:00 | AAPL | Stock | 18.8107 | 18.8107 | 18.8075 | 18.8075 | 6160.0 |
| 2013-01-09 07:38:00 | AAPL | Stock | 18.8036 | 18.8036 | 18.8036 | 18.8036 | 6804.0 |
| 2013-01-09 07:51:00 | AAPL | Stock | 18.7964 | 18.7964 | 18.7964 | 18.7964 | 5600.0 |
| 2013-01-09 07:55:00 | AAPL | Stock | 18.7975 | 18.7975 | 18.7968 | 18.7968 | 5600.0 |
| 2013-01-09 07:58:00 | AAPL | Stock | 18.7921 | 18.7921 | 18.7921 | 18.7921 | 2800.0 |
| 2013-01-09 08:00:00 | AAPL | Stock | 18.7968 | 18.8107 | 18.745 | 18.7907 | 231140.0 |
| 2013-01-09 08:01:00 | AAPL | Stock | 18.7929 | 18.7929 | 18.7857 | 18.7857 | 14448.0 |
| 2013-01-09 08:02:00 | AAPL | Stock | 18.7893 | 18.7893 | 18.7786 | 18.7786 | 46984.0 |
| 2013-01-09 08:03:00 | AAPL | Stock | 18.7618 | 18.7857 | 18.7611 | 18.7682 | 28028.0 |
| 2013-01-09 08:04:00 | AAPL | Stock | 18.7682 | 18.7682 | 18.7504 | 18.7532 | 42000.0 |
| 2013-01-09 08:05:00 | AAPL | Stock | 18.7529 | 18.7596 | 18.7504 | 18.7529 | 198520.0 |
> showing 50 of 949,418 rows — these rows as CSV