PREVIEW / stock_1min / 2009-06-16
file: by_date/stock_1min/2009/2009-06-16.parquet size: 12.8 MB rows: 976,464 symbols: 2,710
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 |
|---|---|---|---|---|---|---|---|
| 2009-06-16 05:26:00 | AAPL | Stock | 4.8771 | 4.8771 | 4.8771 | 4.8771 | 14000.0 |
| 2009-06-16 05:27:00 | AAPL | Stock | 4.8725 | 4.8725 | 4.8725 | 4.8725 | 14000.0 |
| 2009-06-16 05:52:00 | AAPL | Stock | 4.8725 | 4.8725 | 4.8725 | 4.8725 | 2800.0 |
| 2009-06-16 05:58:00 | AAPL | Stock | 4.87 | 4.87 | 4.87 | 4.87 | 5600.0 |
| 2009-06-16 06:07:00 | AAPL | Stock | 4.8654 | 4.8654 | 4.8654 | 4.8654 | 5600.0 |
| 2009-06-16 06:55:00 | AAPL | Stock | 4.8632 | 4.8632 | 4.8632 | 4.8632 | 5600.0 |
| 2009-06-16 06:58:00 | AAPL | Stock | 4.8643 | 4.8643 | 4.8571 | 4.8604 | 30800.0 |
| 2009-06-16 06:59:00 | AAPL | Stock | 4.8571 | 4.8571 | 4.8571 | 4.8571 | 11200.0 |
| 2009-06-16 07:15:00 | AAPL | Stock | 4.8679 | 4.8679 | 4.8679 | 4.8679 | 28000.0 |
| 2009-06-16 07:18:00 | AAPL | Stock | 4.865 | 4.865 | 4.8643 | 4.8643 | 33600.0 |
| 2009-06-16 07:20:00 | AAPL | Stock | 4.8814 | 4.8875 | 4.8764 | 4.8768 | 49000.0 |
| 2009-06-16 07:34:00 | AAPL | Stock | 4.8732 | 4.8732 | 4.8732 | 4.8732 | 2800.0 |
| 2009-06-16 07:45:00 | AAPL | Stock | 4.8625 | 4.8625 | 4.8607 | 4.8607 | 18200.0 |
| 2009-06-16 07:55:00 | AAPL | Stock | 4.8693 | 4.8693 | 4.8693 | 4.8693 | 2800.0 |
| 2009-06-16 07:57:00 | AAPL | Stock | 4.8721 | 4.8721 | 4.8721 | 4.8721 | 2800.0 |
| 2009-06-16 08:00:00 | AAPL | Stock | 4.8679 | 4.875 | 4.8664 | 4.875 | 47180.0 |
| 2009-06-16 08:01:00 | AAPL | Stock | 4.875 | 4.875 | 4.875 | 4.875 | 11200.0 |
| 2009-06-16 08:02:00 | AAPL | Stock | 4.875 | 4.875 | 4.875 | 4.875 | 17080.0 |
| 2009-06-16 08:03:00 | AAPL | Stock | 4.8679 | 4.8679 | 4.8679 | 4.8679 | 14000.0 |
| 2009-06-16 08:04:00 | AAPL | Stock | 4.8679 | 4.8679 | 4.8661 | 4.8661 | 23016.0 |
| 2009-06-16 08:05:00 | AAPL | Stock | 4.865 | 4.865 | 4.8643 | 4.8643 | 58800.0 |
| 2009-06-16 08:06:00 | AAPL | Stock | 4.8729 | 4.8729 | 4.8729 | 4.8729 | 2800.0 |
| 2009-06-16 08:08:00 | AAPL | Stock | 4.8664 | 4.8725 | 4.8643 | 4.8725 | 60340.0 |
| 2009-06-16 08:09:00 | AAPL | Stock | 4.8621 | 4.8621 | 4.8618 | 4.8618 | 13160.0 |
| 2009-06-16 08:10:00 | AAPL | Stock | 4.8575 | 4.8575 | 4.8575 | 4.8575 | 13160.0 |
| 2009-06-16 08:11:00 | AAPL | Stock | 4.8693 | 4.8693 | 4.8693 | 4.8693 | 2800.0 |
| 2009-06-16 08:14:00 | AAPL | Stock | 4.8661 | 4.8661 | 4.8661 | 4.8661 | 28000.0 |
| 2009-06-16 08:18:00 | AAPL | Stock | 4.8625 | 4.8625 | 4.8625 | 4.8625 | 5600.0 |
| 2009-06-16 08:19:00 | AAPL | Stock | 4.8657 | 4.8657 | 4.8657 | 4.8657 | 11200.0 |
| 2009-06-16 08:20:00 | AAPL | Stock | 4.8657 | 4.8668 | 4.8657 | 4.8668 | 13412.0 |
| 2009-06-16 08:21:00 | AAPL | Stock | 4.8679 | 4.8679 | 4.8664 | 4.8664 | 13244.0 |
| 2009-06-16 08:22:00 | AAPL | Stock | 4.8679 | 4.8679 | 4.8664 | 4.8664 | 8400.0 |
| 2009-06-16 08:23:00 | AAPL | Stock | 4.8679 | 4.8711 | 4.8679 | 4.8711 | 30800.0 |
| 2009-06-16 08:24:00 | AAPL | Stock | 4.8689 | 4.8689 | 4.8689 | 4.8689 | 3220.0 |
| 2009-06-16 08:26:00 | AAPL | Stock | 4.8696 | 4.8696 | 4.8696 | 4.8696 | 5600.0 |
| 2009-06-16 08:28:00 | AAPL | Stock | 4.8679 | 4.8696 | 4.8679 | 4.8696 | 29120.0 |
| 2009-06-16 08:30:00 | AAPL | Stock | 4.8714 | 4.8732 | 4.8714 | 4.8725 | 67200.0 |
| 2009-06-16 08:31:00 | AAPL | Stock | 4.8696 | 4.8804 | 4.8696 | 4.8786 | 34580.0 |
| 2009-06-16 08:32:00 | AAPL | Stock | 4.8789 | 4.8789 | 4.8786 | 4.8789 | 30800.0 |
| 2009-06-16 08:33:00 | AAPL | Stock | 4.8786 | 4.8804 | 4.8761 | 4.8804 | 58436.0 |
| 2009-06-16 08:34:00 | AAPL | Stock | 4.8821 | 4.8886 | 4.8821 | 4.8857 | 51240.0 |
| 2009-06-16 08:35:00 | AAPL | Stock | 4.8843 | 4.8854 | 4.8843 | 4.8843 | 22400.0 |
| 2009-06-16 08:36:00 | AAPL | Stock | 4.8846 | 4.8846 | 4.8843 | 4.8843 | 14000.0 |
| 2009-06-16 08:37:00 | AAPL | Stock | 4.8843 | 4.8857 | 4.8839 | 4.8857 | 31640.0 |
| 2009-06-16 08:38:00 | AAPL | Stock | 4.8846 | 4.8846 | 4.8843 | 4.8843 | 28000.0 |
| 2009-06-16 08:41:00 | AAPL | Stock | 4.885 | 4.8857 | 4.885 | 4.8857 | 13440.0 |
| 2009-06-16 08:42:00 | AAPL | Stock | 4.8857 | 4.8857 | 4.8857 | 4.8857 | 8400.0 |
| 2009-06-16 08:43:00 | AAPL | Stock | 4.8875 | 4.8875 | 4.8875 | 4.8875 | 6860.0 |
| 2009-06-16 08:44:00 | AAPL | Stock | 4.8886 | 4.8907 | 4.8886 | 4.8907 | 67200.0 |
| 2009-06-16 08:45:00 | AAPL | Stock | 4.8893 | 4.89 | 4.8893 | 4.8893 | 74760.0 |
> showing 50 of 976,464 rows — these rows as CSV