PREVIEW / stock_1min / 2013-09-12
file: by_date/stock_1min/2013/2013-09-12.parquet size: 13.3 MB rows: 978,406 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 |
|---|---|---|---|---|---|---|---|
| 2013-09-12 04:00:00 | AAPL | Stock | 16.7768 | 16.7768 | 16.7768 | 16.7768 | 2800.0 |
| 2013-09-12 04:14:00 | AAPL | Stock | 16.7082 | 16.7082 | 16.6968 | 16.6968 | 11200.0 |
| 2013-09-12 04:15:00 | AAPL | Stock | 16.7229 | 16.7229 | 16.7229 | 16.7229 | 8400.0 |
| 2013-09-12 04:23:00 | AAPL | Stock | 16.7279 | 16.75 | 16.7279 | 16.7496 | 8400.0 |
| 2013-09-12 04:25:00 | AAPL | Stock | 16.75 | 16.75 | 16.75 | 16.75 | 4256.0 |
| 2013-09-12 04:35:00 | AAPL | Stock | 16.7414 | 16.7414 | 16.7414 | 16.7414 | 2968.0 |
| 2013-09-12 04:37:00 | AAPL | Stock | 16.7489 | 16.7493 | 16.7489 | 16.7493 | 11200.0 |
| 2013-09-12 04:39:00 | AAPL | Stock | 16.75 | 16.75 | 16.75 | 16.75 | 2800.0 |
| 2013-09-12 04:40:00 | AAPL | Stock | 16.7714 | 16.7714 | 16.7714 | 16.7714 | 2800.0 |
| 2013-09-12 04:44:00 | AAPL | Stock | 16.7543 | 16.7568 | 16.75 | 16.75 | 19600.0 |
| 2013-09-12 04:47:00 | AAPL | Stock | 16.7489 | 16.7507 | 16.7489 | 16.7507 | 5600.0 |
| 2013-09-12 04:54:00 | AAPL | Stock | 16.7432 | 16.7432 | 16.7432 | 16.7432 | 4564.0 |
| 2013-09-12 04:59:00 | AAPL | Stock | 16.7482 | 16.7482 | 16.7482 | 16.7482 | 2800.0 |
| 2013-09-12 05:04:00 | AAPL | Stock | 16.7396 | 16.7396 | 16.7396 | 16.7396 | 2800.0 |
| 2013-09-12 05:14:00 | AAPL | Stock | 16.74 | 16.7471 | 16.74 | 16.7471 | 5600.0 |
| 2013-09-12 05:15:00 | AAPL | Stock | 16.7436 | 16.7436 | 16.7436 | 16.7436 | 4480.0 |
| 2013-09-12 05:17:00 | AAPL | Stock | 16.7471 | 16.7475 | 16.7471 | 16.7475 | 5600.0 |
| 2013-09-12 05:20:00 | AAPL | Stock | 16.7457 | 16.7457 | 16.7457 | 16.7457 | 11200.0 |
| 2013-09-12 05:21:00 | AAPL | Stock | 16.7461 | 16.7461 | 16.7461 | 16.7461 | 2800.0 |
| 2013-09-12 05:22:00 | AAPL | Stock | 16.7411 | 16.7411 | 16.7411 | 16.7411 | 13692.0 |
| 2013-09-12 05:23:00 | AAPL | Stock | 16.7393 | 16.7393 | 16.7296 | 16.7296 | 19600.0 |
| 2013-09-12 05:24:00 | AAPL | Stock | 16.7421 | 16.7429 | 16.7421 | 16.7429 | 15596.0 |
| 2013-09-12 05:29:00 | AAPL | Stock | 16.7461 | 16.7461 | 16.7461 | 16.7461 | 2800.0 |
| 2013-09-12 05:30:00 | AAPL | Stock | 16.7461 | 16.7475 | 16.7461 | 16.7475 | 16604.0 |
| 2013-09-12 05:31:00 | AAPL | Stock | 16.7475 | 16.7475 | 16.7475 | 16.7475 | 2800.0 |
| 2013-09-12 05:32:00 | AAPL | Stock | 16.7529 | 16.7529 | 16.7529 | 16.7529 | 11200.0 |
| 2013-09-12 05:33:00 | AAPL | Stock | 16.7529 | 16.7529 | 16.7529 | 16.7529 | 2800.0 |
| 2013-09-12 05:35:00 | AAPL | Stock | 16.7639 | 16.7661 | 16.7639 | 16.7661 | 14840.0 |
| 2013-09-12 05:43:00 | AAPL | Stock | 16.7732 | 16.7732 | 16.7732 | 16.7732 | 2800.0 |
| 2013-09-12 05:46:00 | AAPL | Stock | 16.7743 | 16.7743 | 16.7743 | 16.7743 | 2800.0 |
| 2013-09-12 05:47:00 | AAPL | Stock | 16.7636 | 16.7636 | 16.7636 | 16.7636 | 2800.0 |
| 2013-09-12 05:49:00 | AAPL | Stock | 16.7743 | 16.7821 | 16.7743 | 16.7821 | 14000.0 |
| 2013-09-12 06:02:00 | AAPL | Stock | 16.7939 | 16.7939 | 16.7921 | 16.7921 | 8400.0 |
| 2013-09-12 06:04:00 | AAPL | Stock | 16.81 | 16.81 | 16.81 | 16.81 | 28000.0 |
| 2013-09-12 06:22:00 | AAPL | Stock | 16.7968 | 16.8036 | 16.7968 | 16.8036 | 14000.0 |
| 2013-09-12 06:24:00 | AAPL | Stock | 16.8129 | 16.8129 | 16.8129 | 16.8129 | 5600.0 |
| 2013-09-12 06:25:00 | AAPL | Stock | 16.8129 | 16.8132 | 16.8129 | 16.8132 | 5600.0 |
| 2013-09-12 06:26:00 | AAPL | Stock | 16.8132 | 16.8132 | 16.8132 | 16.8132 | 2800.0 |
| 2013-09-12 06:27:00 | AAPL | Stock | 16.8071 | 16.8071 | 16.8039 | 16.8039 | 14000.0 |
| 2013-09-12 06:28:00 | AAPL | Stock | 16.8021 | 16.8021 | 16.8021 | 16.8021 | 6160.0 |
| 2013-09-12 06:30:00 | AAPL | Stock | 16.8004 | 16.8036 | 16.8004 | 16.8036 | 28000.0 |
| 2013-09-12 06:31:00 | AAPL | Stock | 16.7929 | 16.7929 | 16.7929 | 16.7929 | 2800.0 |
| 2013-09-12 06:33:00 | AAPL | Stock | 16.7911 | 16.7911 | 16.7911 | 16.7911 | 2800.0 |
| 2013-09-12 06:35:00 | AAPL | Stock | 16.7932 | 16.7932 | 16.7911 | 16.7911 | 19600.0 |
| 2013-09-12 06:48:00 | AAPL | Stock | 16.7857 | 16.7857 | 16.7857 | 16.7857 | 5600.0 |
| 2013-09-12 06:49:00 | AAPL | Stock | 16.7857 | 16.7893 | 16.7857 | 16.7893 | 8400.0 |
| 2013-09-12 06:50:00 | AAPL | Stock | 16.7786 | 16.7786 | 16.7786 | 16.7786 | 2800.0 |
| 2013-09-12 06:52:00 | AAPL | Stock | 16.7789 | 16.7789 | 16.7789 | 16.7789 | 2800.0 |
| 2013-09-12 06:53:00 | AAPL | Stock | 16.7786 | 16.7786 | 16.7786 | 16.7786 | 2800.0 |
| 2013-09-12 06:57:00 | AAPL | Stock | 16.7782 | 16.7782 | 16.7782 | 16.7782 | 2800.0 |
> showing 50 of 978,406 rows — these rows as CSV