PREVIEW / stock_1min / 2012-09-17
file: by_date/stock_1min/2012/2012-09-17.parquet size: 12.4 MB rows: 912,708 symbols: 2,793
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 |
|---|---|---|---|---|---|---|---|
| 2012-09-17 04:03:00 | AAPL | Stock | 24.7857 | 24.7857 | 24.7857 | 24.7857 | 18200.0 |
| 2012-09-17 04:11:00 | AAPL | Stock | 24.7736 | 24.7736 | 24.7736 | 24.7736 | 2800.0 |
| 2012-09-17 04:23:00 | AAPL | Stock | 24.7679 | 24.7679 | 24.7679 | 24.7679 | 2800.0 |
| 2012-09-17 04:25:00 | AAPL | Stock | 24.7857 | 24.7857 | 24.7857 | 24.7857 | 5600.0 |
| 2012-09-17 04:44:00 | AAPL | Stock | 24.7643 | 24.7643 | 24.7643 | 24.7643 | 6972.0 |
| 2012-09-17 04:54:00 | AAPL | Stock | 24.795 | 24.795 | 24.795 | 24.795 | 2800.0 |
| 2012-09-17 05:37:00 | AAPL | Stock | 24.7679 | 24.7679 | 24.7679 | 24.7679 | 2800.0 |
| 2012-09-17 06:05:00 | AAPL | Stock | 24.8068 | 24.8068 | 24.8068 | 24.8068 | 3584.0 |
| 2012-09-17 06:12:00 | AAPL | Stock | 24.8068 | 24.8068 | 24.8068 | 24.8068 | 2800.0 |
| 2012-09-17 06:25:00 | AAPL | Stock | 24.7857 | 24.7857 | 24.7857 | 24.7857 | 5600.0 |
| 2012-09-17 06:26:00 | AAPL | Stock | 24.7857 | 24.7857 | 24.7857 | 24.7857 | 2800.0 |
| 2012-09-17 06:36:00 | AAPL | Stock | 24.7925 | 24.7925 | 24.7925 | 24.7925 | 57400.0 |
| 2012-09-17 06:55:00 | AAPL | Stock | 24.8036 | 24.8036 | 24.8036 | 24.8036 | 2800.0 |
| 2012-09-17 06:58:00 | AAPL | Stock | 24.8 | 24.8 | 24.7929 | 24.7929 | 23772.0 |
| 2012-09-17 07:00:00 | AAPL | Stock | 24.7857 | 24.7857 | 24.7786 | 24.7786 | 23240.0 |
| 2012-09-17 07:01:00 | AAPL | Stock | 24.7857 | 24.7857 | 24.7786 | 24.7786 | 7420.0 |
| 2012-09-17 07:02:00 | AAPL | Stock | 24.7857 | 24.7857 | 24.7857 | 24.7857 | 2800.0 |
| 2012-09-17 07:03:00 | AAPL | Stock | 24.8011 | 24.8036 | 24.8011 | 24.8036 | 28000.0 |
| 2012-09-17 07:04:00 | AAPL | Stock | 24.8032 | 24.8032 | 24.8011 | 24.8032 | 18480.0 |
| 2012-09-17 07:05:00 | AAPL | Stock | 24.7929 | 24.7929 | 24.7879 | 24.7879 | 11200.0 |
| 2012-09-17 07:06:00 | AAPL | Stock | 24.8 | 24.8036 | 24.8 | 24.8004 | 23800.0 |
| 2012-09-17 07:07:00 | AAPL | Stock | 24.8107 | 24.8118 | 24.7968 | 24.7968 | 59920.0 |
| 2012-09-17 07:08:00 | AAPL | Stock | 24.8114 | 24.8211 | 24.8114 | 24.8211 | 47180.0 |
| 2012-09-17 07:09:00 | AAPL | Stock | 24.8211 | 24.8246 | 24.8211 | 24.8232 | 77700.0 |
| 2012-09-17 07:10:00 | AAPL | Stock | 24.8304 | 24.8304 | 24.8304 | 24.8304 | 2800.0 |
| 2012-09-17 07:11:00 | AAPL | Stock | 24.845 | 24.85 | 24.845 | 24.8482 | 48020.0 |
| 2012-09-17 07:12:00 | AAPL | Stock | 24.8393 | 24.8429 | 24.8357 | 24.8429 | 35280.0 |
| 2012-09-17 07:13:00 | AAPL | Stock | 24.8429 | 24.8429 | 24.8429 | 24.8429 | 34048.0 |
| 2012-09-17 07:14:00 | AAPL | Stock | 24.8429 | 24.8429 | 24.8268 | 24.8268 | 10500.0 |
| 2012-09-17 07:15:00 | AAPL | Stock | 24.8268 | 24.8432 | 24.8268 | 24.8429 | 106400.0 |
| 2012-09-17 07:19:00 | AAPL | Stock | 24.8364 | 24.8364 | 24.8343 | 24.8343 | 30800.0 |
| 2012-09-17 07:20:00 | AAPL | Stock | 24.8393 | 24.8393 | 24.8393 | 24.8393 | 7000.0 |
| 2012-09-17 07:21:00 | AAPL | Stock | 24.8393 | 24.8393 | 24.8393 | 24.8393 | 11200.0 |
| 2012-09-17 07:23:00 | AAPL | Stock | 24.8339 | 24.8339 | 24.8339 | 24.8339 | 2800.0 |
| 2012-09-17 07:25:00 | AAPL | Stock | 24.8232 | 24.8232 | 24.8214 | 24.8218 | 22540.0 |
| 2012-09-17 07:27:00 | AAPL | Stock | 24.8286 | 24.8286 | 24.8286 | 24.8286 | 2800.0 |
| 2012-09-17 07:28:00 | AAPL | Stock | 24.8357 | 24.8357 | 24.8357 | 24.8357 | 2800.0 |
| 2012-09-17 07:30:00 | AAPL | Stock | 24.83 | 24.83 | 24.8171 | 24.8171 | 30520.0 |
| 2012-09-17 07:32:00 | AAPL | Stock | 24.8332 | 24.8332 | 24.8129 | 24.8129 | 6720.0 |
| 2012-09-17 07:36:00 | AAPL | Stock | 24.8132 | 24.8132 | 24.7968 | 24.7968 | 101892.0 |
| 2012-09-17 07:38:00 | AAPL | Stock | 24.7964 | 24.7964 | 24.7964 | 24.7964 | 2800.0 |
| 2012-09-17 07:40:00 | AAPL | Stock | 24.7946 | 24.7946 | 24.7786 | 24.7786 | 53536.0 |
| 2012-09-17 07:41:00 | AAPL | Stock | 24.7857 | 24.7857 | 24.7857 | 24.7857 | 6888.0 |
| 2012-09-17 07:44:00 | AAPL | Stock | 24.7857 | 24.7857 | 24.7682 | 24.7682 | 22400.0 |
| 2012-09-17 07:45:00 | AAPL | Stock | 24.7821 | 24.7821 | 24.7821 | 24.7821 | 5600.0 |
| 2012-09-17 07:46:00 | AAPL | Stock | 24.7732 | 24.7732 | 24.7689 | 24.7689 | 11340.0 |
| 2012-09-17 07:47:00 | AAPL | Stock | 24.7686 | 24.7768 | 24.7686 | 24.7768 | 8400.0 |
| 2012-09-17 07:48:00 | AAPL | Stock | 24.7768 | 24.7821 | 24.7768 | 24.7821 | 14000.0 |
| 2012-09-17 07:55:00 | AAPL | Stock | 24.7929 | 24.7929 | 24.7929 | 24.7929 | 7532.0 |
| 2012-09-17 07:58:00 | AAPL | Stock | 24.8018 | 24.8032 | 24.8018 | 24.8032 | 8400.0 |
> showing 50 of 912,708 rows — these rows as CSV