PREVIEW / stock_1min / 2010-09-20
file: by_date/stock_1min/2010/2010-09-20.parquet size: 12.9 MB rows: 964,024 symbols: 2,839
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 |
|---|---|---|---|---|---|---|---|
| 2010-09-20 04:53:00 | AAPL | Stock | 9.8571 | 9.8571 | 9.8571 | 9.8571 | 5600.0 |
| 2010-09-20 05:26:00 | AAPL | Stock | 9.8571 | 9.8571 | 9.8571 | 9.8571 | 5600.0 |
| 2010-09-20 07:03:00 | AAPL | Stock | 9.8493 | 9.8493 | 9.8493 | 9.8493 | 2800.0 |
| 2010-09-20 07:04:00 | AAPL | Stock | 9.8493 | 9.8493 | 9.8489 | 9.8489 | 5600.0 |
| 2010-09-20 07:11:00 | AAPL | Stock | 9.8746 | 9.8764 | 9.8746 | 9.8764 | 5600.0 |
| 2010-09-20 07:13:00 | AAPL | Stock | 9.8746 | 9.8746 | 9.8746 | 9.8746 | 2800.0 |
| 2010-09-20 07:42:00 | AAPL | Stock | 9.8671 | 9.8671 | 9.8671 | 9.8671 | 2800.0 |
| 2010-09-20 07:45:00 | AAPL | Stock | 9.8686 | 9.8725 | 9.8686 | 9.8693 | 38500.0 |
| 2010-09-20 07:47:00 | AAPL | Stock | 9.8746 | 9.8746 | 9.8746 | 9.8746 | 5600.0 |
| 2010-09-20 07:51:00 | AAPL | Stock | 9.8668 | 9.8668 | 9.8664 | 9.8664 | 5600.0 |
| 2010-09-20 07:52:00 | AAPL | Stock | 9.8746 | 9.8746 | 9.8746 | 9.8746 | 2800.0 |
| 2010-09-20 07:53:00 | AAPL | Stock | 9.8689 | 9.8689 | 9.8689 | 9.8689 | 14000.0 |
| 2010-09-20 07:56:00 | AAPL | Stock | 9.8743 | 9.875 | 9.8743 | 9.875 | 14000.0 |
| 2010-09-20 07:57:00 | AAPL | Stock | 9.8746 | 9.8746 | 9.8746 | 9.8746 | 2800.0 |
| 2010-09-20 07:59:00 | AAPL | Stock | 9.8686 | 9.8686 | 9.8682 | 9.8682 | 5600.0 |
| 2010-09-20 08:00:00 | AAPL | Stock | 9.8739 | 9.8739 | 9.86 | 9.8636 | 228536.0 |
| 2010-09-20 08:01:00 | AAPL | Stock | 9.8671 | 9.8671 | 9.8611 | 9.8643 | 43596.0 |
| 2010-09-20 08:02:00 | AAPL | Stock | 9.8643 | 9.8643 | 9.8629 | 9.8643 | 19600.0 |
| 2010-09-20 08:03:00 | AAPL | Stock | 9.8657 | 9.8657 | 9.8646 | 9.8646 | 7700.0 |
| 2010-09-20 08:04:00 | AAPL | Stock | 9.8675 | 9.8707 | 9.8675 | 9.8707 | 60060.0 |
| 2010-09-20 08:05:00 | AAPL | Stock | 9.8664 | 9.8696 | 9.8664 | 9.8696 | 77224.0 |
| 2010-09-20 08:06:00 | AAPL | Stock | 9.8693 | 9.8693 | 9.8693 | 9.8693 | 11200.0 |
| 2010-09-20 08:08:00 | AAPL | Stock | 9.8675 | 9.8675 | 9.8675 | 9.8675 | 2800.0 |
| 2010-09-20 08:09:00 | AAPL | Stock | 9.8675 | 9.8707 | 9.8675 | 9.8707 | 41440.0 |
| 2010-09-20 08:10:00 | AAPL | Stock | 9.8714 | 9.8721 | 9.8696 | 9.8696 | 16800.0 |
| 2010-09-20 08:11:00 | AAPL | Stock | 9.8696 | 9.8704 | 9.8696 | 9.8696 | 22400.0 |
| 2010-09-20 08:12:00 | AAPL | Stock | 9.87 | 9.87 | 9.8696 | 9.8696 | 16632.0 |
| 2010-09-20 08:13:00 | AAPL | Stock | 9.8675 | 9.8679 | 9.8675 | 9.8679 | 8400.0 |
| 2010-09-20 08:14:00 | AAPL | Stock | 9.8679 | 9.8682 | 9.8679 | 9.8682 | 11200.0 |
| 2010-09-20 08:15:00 | AAPL | Stock | 9.8704 | 9.8704 | 9.8704 | 9.8704 | 2800.0 |
| 2010-09-20 08:16:00 | AAPL | Stock | 9.8704 | 9.8704 | 9.8704 | 9.8704 | 2800.0 |
| 2010-09-20 08:17:00 | AAPL | Stock | 9.8704 | 9.8704 | 9.8661 | 9.8693 | 67200.0 |
| 2010-09-20 08:18:00 | AAPL | Stock | 9.8671 | 9.8671 | 9.8646 | 9.8664 | 11200.0 |
| 2010-09-20 08:19:00 | AAPL | Stock | 9.8643 | 9.8671 | 9.8643 | 9.8661 | 19600.0 |
| 2010-09-20 08:20:00 | AAPL | Stock | 9.8661 | 9.8661 | 9.8661 | 9.8661 | 2800.0 |
| 2010-09-20 08:21:00 | AAPL | Stock | 9.8654 | 9.8654 | 9.8618 | 9.8618 | 28000.0 |
| 2010-09-20 08:22:00 | AAPL | Stock | 9.8618 | 9.8625 | 9.8618 | 9.8625 | 60620.0 |
| 2010-09-20 08:23:00 | AAPL | Stock | 9.8614 | 9.8614 | 9.8614 | 9.8614 | 2800.0 |
| 2010-09-20 08:24:00 | AAPL | Stock | 9.8621 | 9.8639 | 9.8618 | 9.8639 | 8400.0 |
| 2010-09-20 08:25:00 | AAPL | Stock | 9.8621 | 9.8636 | 9.8618 | 9.8636 | 12600.0 |
| 2010-09-20 08:26:00 | AAPL | Stock | 9.8618 | 9.8618 | 9.8614 | 9.8614 | 17080.0 |
| 2010-09-20 08:27:00 | AAPL | Stock | 9.8632 | 9.8643 | 9.8607 | 9.8607 | 34720.0 |
| 2010-09-20 08:28:00 | AAPL | Stock | 9.8621 | 9.8629 | 9.8571 | 9.8618 | 95340.0 |
| 2010-09-20 08:29:00 | AAPL | Stock | 9.8621 | 9.8621 | 9.8571 | 9.8571 | 8400.0 |
| 2010-09-20 08:30:00 | AAPL | Stock | 9.8575 | 9.8575 | 9.8571 | 9.8571 | 5600.0 |
| 2010-09-20 08:31:00 | AAPL | Stock | 9.8575 | 9.8575 | 9.8575 | 9.8575 | 2800.0 |
| 2010-09-20 08:33:00 | AAPL | Stock | 9.8621 | 9.8621 | 9.8618 | 9.8618 | 8400.0 |
| 2010-09-20 08:34:00 | AAPL | Stock | 9.8632 | 9.8643 | 9.8579 | 9.8614 | 121100.0 |
| 2010-09-20 08:35:00 | AAPL | Stock | 9.8582 | 9.8582 | 9.8493 | 9.8543 | 102200.0 |
| 2010-09-20 08:36:00 | AAPL | Stock | 9.8489 | 9.85 | 9.8482 | 9.85 | 28560.0 |
> showing 50 of 964,024 rows — these rows as CSV