PREVIEW / stock_1min / 2010-04-20
file: by_date/stock_1min/2010/2010-04-20.parquet size: 12.9 MB rows: 973,422 symbols: 2,835
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-04-20 04:11:00 | AAPL | Stock | 8.8821 | 8.8821 | 8.8821 | 8.8821 | 14000.0 |
| 2010-04-20 04:15:00 | AAPL | Stock | 8.8821 | 8.8821 | 8.8821 | 8.8821 | 11200.0 |
| 2010-04-20 04:21:00 | AAPL | Stock | 8.8893 | 8.8893 | 8.8893 | 8.8893 | 8400.0 |
| 2010-04-20 04:25:00 | AAPL | Stock | 8.8907 | 8.8907 | 8.8907 | 8.8907 | 11200.0 |
| 2010-04-20 04:28:00 | AAPL | Stock | 8.89 | 8.89 | 8.89 | 8.89 | 14000.0 |
| 2010-04-20 05:07:00 | AAPL | Stock | 8.875 | 8.875 | 8.875 | 8.875 | 14000.0 |
| 2010-04-20 05:49:00 | AAPL | Stock | 8.875 | 8.875 | 8.875 | 8.875 | 22400.0 |
| 2010-04-20 06:48:00 | AAPL | Stock | 8.8732 | 8.8732 | 8.8732 | 8.8732 | 10640.0 |
| 2010-04-20 06:49:00 | AAPL | Stock | 8.8732 | 8.8732 | 8.8732 | 8.8732 | 8400.0 |
| 2010-04-20 06:51:00 | AAPL | Stock | 8.8732 | 8.8732 | 8.8732 | 8.8732 | 6328.0 |
| 2010-04-20 06:52:00 | AAPL | Stock | 8.8814 | 8.8925 | 8.8814 | 8.8925 | 68768.0 |
| 2010-04-20 06:53:00 | AAPL | Stock | 8.8925 | 8.8925 | 8.8925 | 8.8925 | 5600.0 |
| 2010-04-20 06:58:00 | AAPL | Stock | 8.8929 | 8.8929 | 8.8929 | 8.8929 | 2800.0 |
| 2010-04-20 07:02:00 | AAPL | Stock | 8.8929 | 8.8929 | 8.8929 | 8.8929 | 41580.0 |
| 2010-04-20 07:03:00 | AAPL | Stock | 8.8929 | 8.8929 | 8.8925 | 8.8925 | 19600.0 |
| 2010-04-20 07:08:00 | AAPL | Stock | 8.8921 | 8.8921 | 8.8921 | 8.8921 | 8064.0 |
| 2010-04-20 07:10:00 | AAPL | Stock | 8.8921 | 8.8921 | 8.8921 | 8.8921 | 8400.0 |
| 2010-04-20 07:11:00 | AAPL | Stock | 8.8754 | 8.8921 | 8.875 | 8.8921 | 19600.0 |
| 2010-04-20 07:14:00 | AAPL | Stock | 8.8736 | 8.8893 | 8.8575 | 8.8575 | 14000.0 |
| 2010-04-20 07:15:00 | AAPL | Stock | 8.8736 | 8.8736 | 8.8736 | 8.8736 | 2800.0 |
| 2010-04-20 07:19:00 | AAPL | Stock | 8.8768 | 8.8768 | 8.8768 | 8.8768 | 7000.0 |
| 2010-04-20 07:20:00 | AAPL | Stock | 8.8732 | 8.8732 | 8.8664 | 8.8664 | 8092.0 |
| 2010-04-20 07:21:00 | AAPL | Stock | 8.8661 | 8.8732 | 8.8661 | 8.8661 | 16800.0 |
| 2010-04-20 07:22:00 | AAPL | Stock | 8.8643 | 8.8643 | 8.8643 | 8.8643 | 2800.0 |
| 2010-04-20 07:24:00 | AAPL | Stock | 8.8639 | 8.8639 | 8.8639 | 8.8639 | 2800.0 |
| 2010-04-20 07:45:00 | AAPL | Stock | 8.8679 | 8.8679 | 8.8679 | 8.8679 | 2800.0 |
| 2010-04-20 07:50:00 | AAPL | Stock | 8.8654 | 8.8654 | 8.865 | 8.865 | 5600.0 |
| 2010-04-20 07:51:00 | AAPL | Stock | 8.8654 | 8.8654 | 8.8654 | 8.8654 | 16800.0 |
| 2010-04-20 07:54:00 | AAPL | Stock | 8.8607 | 8.8607 | 8.8607 | 8.8607 | 13860.0 |
| 2010-04-20 08:00:00 | AAPL | Stock | 8.8643 | 8.8732 | 8.8575 | 8.8679 | 322728.0 |
| 2010-04-20 08:01:00 | AAPL | Stock | 8.8643 | 8.87 | 8.8643 | 8.8643 | 49980.0 |
| 2010-04-20 08:02:00 | AAPL | Stock | 8.87 | 8.8739 | 8.8668 | 8.8725 | 129304.0 |
| 2010-04-20 08:03:00 | AAPL | Stock | 8.8704 | 8.8704 | 8.8679 | 8.8679 | 29232.0 |
| 2010-04-20 08:04:00 | AAPL | Stock | 8.8664 | 8.8664 | 8.8646 | 8.8661 | 63420.0 |
| 2010-04-20 08:05:00 | AAPL | Stock | 8.8661 | 8.8679 | 8.8646 | 8.8654 | 50400.0 |
| 2010-04-20 08:06:00 | AAPL | Stock | 8.8654 | 8.8654 | 8.8589 | 8.8607 | 69524.0 |
| 2010-04-20 08:07:00 | AAPL | Stock | 8.8589 | 8.8604 | 8.8571 | 8.8604 | 56616.0 |
| 2010-04-20 08:08:00 | AAPL | Stock | 8.8607 | 8.8607 | 8.8607 | 8.8607 | 16800.0 |
| 2010-04-20 08:09:00 | AAPL | Stock | 8.8618 | 8.8618 | 8.8618 | 8.8618 | 2800.0 |
| 2010-04-20 08:10:00 | AAPL | Stock | 8.8618 | 8.8643 | 8.8607 | 8.8607 | 38472.0 |
| 2010-04-20 08:11:00 | AAPL | Stock | 8.8607 | 8.8636 | 8.86 | 8.8611 | 33600.0 |
| 2010-04-20 08:12:00 | AAPL | Stock | 8.8614 | 8.8636 | 8.8614 | 8.8636 | 11200.0 |
| 2010-04-20 08:13:00 | AAPL | Stock | 8.8614 | 8.8614 | 8.8571 | 8.8575 | 136360.0 |
| 2010-04-20 08:14:00 | AAPL | Stock | 8.86 | 8.86 | 8.8571 | 8.8571 | 39200.0 |
| 2010-04-20 08:15:00 | AAPL | Stock | 8.86 | 8.8604 | 8.86 | 8.8604 | 61040.0 |
| 2010-04-20 08:16:00 | AAPL | Stock | 8.8604 | 8.8604 | 8.8604 | 8.8604 | 2800.0 |
| 2010-04-20 08:17:00 | AAPL | Stock | 8.8589 | 8.86 | 8.8589 | 8.86 | 28000.0 |
| 2010-04-20 08:18:00 | AAPL | Stock | 8.8586 | 8.8614 | 8.8575 | 8.8589 | 54124.0 |
| 2010-04-20 08:19:00 | AAPL | Stock | 8.8607 | 8.8607 | 8.8607 | 8.8607 | 8260.0 |
| 2010-04-20 08:20:00 | AAPL | Stock | 8.8614 | 8.8614 | 8.8579 | 8.8607 | 36400.0 |
> showing 50 of 973,422 rows — these rows as CSV