PREVIEW / stock_1min / 2010-09-02
file: by_date/stock_1min/2010/2010-09-02.parquet size: 12.1 MB rows: 928,609 symbols: 2,806
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-02 04:24:00 | AAPL | Stock | 8.9729 | 8.9729 | 8.9729 | 8.9729 | 5600.0 |
| 2010-09-02 07:05:00 | AAPL | Stock | 8.9643 | 8.9643 | 8.9643 | 8.9643 | 2800.0 |
| 2010-09-02 07:10:00 | AAPL | Stock | 8.9418 | 8.9418 | 8.9418 | 8.9418 | 2800.0 |
| 2010-09-02 07:11:00 | AAPL | Stock | 8.9521 | 8.9729 | 8.9521 | 8.9729 | 25200.0 |
| 2010-09-02 07:12:00 | AAPL | Stock | 8.9554 | 8.9554 | 8.9554 | 8.9554 | 5600.0 |
| 2010-09-02 07:21:00 | AAPL | Stock | 8.9775 | 8.9786 | 8.9775 | 8.9786 | 18200.0 |
| 2010-09-02 07:22:00 | AAPL | Stock | 8.9782 | 8.9782 | 8.9782 | 8.9782 | 8400.0 |
| 2010-09-02 07:23:00 | AAPL | Stock | 8.9786 | 8.9821 | 8.9782 | 8.9821 | 40600.0 |
| 2010-09-02 07:24:00 | AAPL | Stock | 8.9875 | 8.9875 | 8.9875 | 8.9875 | 2800.0 |
| 2010-09-02 07:29:00 | AAPL | Stock | 8.9786 | 8.9786 | 8.9786 | 8.9786 | 4900.0 |
| 2010-09-02 07:30:00 | AAPL | Stock | 8.9868 | 8.9871 | 8.9868 | 8.9871 | 11200.0 |
| 2010-09-02 07:32:00 | AAPL | Stock | 8.9714 | 8.9714 | 8.9643 | 8.9643 | 22400.0 |
| 2010-09-02 07:33:00 | AAPL | Stock | 8.9643 | 8.9643 | 8.9575 | 8.9575 | 16800.0 |
| 2010-09-02 07:34:00 | AAPL | Stock | 8.9571 | 8.9571 | 8.9464 | 8.9507 | 42000.0 |
| 2010-09-02 07:36:00 | AAPL | Stock | 8.9629 | 8.9686 | 8.9629 | 8.9686 | 11200.0 |
| 2010-09-02 07:38:00 | AAPL | Stock | 8.9518 | 8.9518 | 8.9507 | 8.9507 | 5600.0 |
| 2010-09-02 07:41:00 | AAPL | Stock | 8.9507 | 8.9507 | 8.9507 | 8.9507 | 2800.0 |
| 2010-09-02 07:42:00 | AAPL | Stock | 8.95 | 8.9589 | 8.95 | 8.9589 | 11200.0 |
| 2010-09-02 07:58:00 | AAPL | Stock | 8.9554 | 8.9554 | 8.9554 | 8.9554 | 2800.0 |
| 2010-09-02 08:00:00 | AAPL | Stock | 8.9504 | 8.9504 | 8.9504 | 8.9504 | 2800.0 |
| 2010-09-02 08:01:00 | AAPL | Stock | 8.9618 | 8.9618 | 8.9589 | 8.9589 | 14000.0 |
| 2010-09-02 08:02:00 | AAPL | Stock | 8.9625 | 8.9643 | 8.9625 | 8.9643 | 11200.0 |
| 2010-09-02 08:03:00 | AAPL | Stock | 8.9668 | 8.9696 | 8.9614 | 8.9643 | 186200.0 |
| 2010-09-02 08:04:00 | AAPL | Stock | 8.9643 | 8.9643 | 8.9589 | 8.9611 | 28000.0 |
| 2010-09-02 08:05:00 | AAPL | Stock | 8.9568 | 8.9636 | 8.9568 | 8.9636 | 30800.0 |
| 2010-09-02 08:07:00 | AAPL | Stock | 8.9621 | 8.9621 | 8.9571 | 8.9571 | 19600.0 |
| 2010-09-02 08:08:00 | AAPL | Stock | 8.9568 | 8.9568 | 8.9568 | 8.9568 | 2800.0 |
| 2010-09-02 08:09:00 | AAPL | Stock | 8.9632 | 8.9632 | 8.9611 | 8.9632 | 12600.0 |
| 2010-09-02 08:10:00 | AAPL | Stock | 8.9564 | 8.9564 | 8.9564 | 8.9564 | 31836.0 |
| 2010-09-02 08:11:00 | AAPL | Stock | 8.9564 | 8.9614 | 8.9539 | 8.9604 | 68404.0 |
| 2010-09-02 08:13:00 | AAPL | Stock | 8.9529 | 8.9539 | 8.9468 | 8.9468 | 56532.0 |
| 2010-09-02 08:14:00 | AAPL | Stock | 8.9479 | 8.9564 | 8.9475 | 8.9564 | 33152.0 |
| 2010-09-02 08:15:00 | AAPL | Stock | 8.95 | 8.95 | 8.95 | 8.95 | 8400.0 |
| 2010-09-02 08:16:00 | AAPL | Stock | 8.9518 | 8.9518 | 8.9518 | 8.9518 | 5600.0 |
| 2010-09-02 08:18:00 | AAPL | Stock | 8.95 | 8.95 | 8.95 | 8.95 | 16520.0 |
| 2010-09-02 08:19:00 | AAPL | Stock | 8.9475 | 8.9504 | 8.9468 | 8.9504 | 42560.0 |
| 2010-09-02 08:20:00 | AAPL | Stock | 8.9493 | 8.9493 | 8.9493 | 8.9493 | 5600.0 |
| 2010-09-02 08:21:00 | AAPL | Stock | 8.9479 | 8.9504 | 8.9479 | 8.9504 | 33264.0 |
| 2010-09-02 08:22:00 | AAPL | Stock | 8.9557 | 8.9557 | 8.9557 | 8.9557 | 2800.0 |
| 2010-09-02 08:23:00 | AAPL | Stock | 8.9546 | 8.9546 | 8.9546 | 8.9546 | 2800.0 |
| 2010-09-02 08:24:00 | AAPL | Stock | 8.9514 | 8.9518 | 8.9514 | 8.9518 | 142800.0 |
| 2010-09-02 08:25:00 | AAPL | Stock | 8.9536 | 8.9607 | 8.9536 | 8.9571 | 106400.0 |
| 2010-09-02 08:26:00 | AAPL | Stock | 8.9571 | 8.9571 | 8.9543 | 8.9554 | 27720.0 |
| 2010-09-02 08:27:00 | AAPL | Stock | 8.9521 | 8.9546 | 8.9521 | 8.9536 | 16800.0 |
| 2010-09-02 08:28:00 | AAPL | Stock | 8.9546 | 8.955 | 8.9546 | 8.955 | 8400.0 |
| 2010-09-02 08:29:00 | AAPL | Stock | 8.9536 | 8.9568 | 8.9507 | 8.9568 | 15120.0 |
| 2010-09-02 08:30:00 | AAPL | Stock | 8.9554 | 8.9739 | 8.9554 | 8.965 | 197512.0 |
| 2010-09-02 08:31:00 | AAPL | Stock | 8.9732 | 8.9768 | 8.9696 | 8.9725 | 306600.0 |
| 2010-09-02 08:32:00 | AAPL | Stock | 8.9746 | 8.9854 | 8.9743 | 8.9854 | 235088.0 |
| 2010-09-02 08:33:00 | AAPL | Stock | 8.9871 | 8.9893 | 8.9829 | 8.9893 | 58800.0 |
> showing 50 of 928,609 rows — these rows as CSV