PREVIEW / stock_1min / 2007-02-08
file: by_date/stock_1min/2007/2007-02-08.parquet size: 8.8 MB rows: 712,028 symbols: 2,038
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 |
|---|---|---|---|---|---|---|---|
| 2007-02-08 04:16:00 | AAPL | Stock | 3.0786 | 3.0786 | 3.0786 | 3.0786 | 11844.0 |
| 2007-02-08 04:42:00 | AAPL | Stock | 3.0764 | 3.0764 | 3.0764 | 3.0764 | 5600.0 |
| 2007-02-08 04:43:00 | AAPL | Stock | 3.0764 | 3.0764 | 3.0764 | 3.0764 | 5600.0 |
| 2007-02-08 06:04:00 | AAPL | Stock | 3.0889 | 3.0889 | 3.0889 | 3.0889 | 2800.0 |
| 2007-02-08 06:07:00 | AAPL | Stock | 3.0796 | 3.0796 | 3.0771 | 3.0775 | 70644.0 |
| 2007-02-08 06:08:00 | AAPL | Stock | 3.0718 | 3.0718 | 3.0718 | 3.0718 | 16800.0 |
| 2007-02-08 06:22:00 | AAPL | Stock | 3.0693 | 3.0693 | 3.0689 | 3.0689 | 20860.0 |
| 2007-02-08 06:40:00 | AAPL | Stock | 3.0604 | 3.0604 | 3.0604 | 3.0604 | 2800.0 |
| 2007-02-08 06:46:00 | AAPL | Stock | 3.0679 | 3.0679 | 3.0679 | 3.0679 | 2800.0 |
| 2007-02-08 06:59:00 | AAPL | Stock | 3.0661 | 3.0661 | 3.0661 | 3.0661 | 28000.0 |
| 2007-02-08 07:01:00 | AAPL | Stock | 3.0661 | 3.0661 | 3.0661 | 3.0661 | 28000.0 |
| 2007-02-08 07:04:00 | AAPL | Stock | 3.0629 | 3.0629 | 3.0625 | 3.0625 | 25200.0 |
| 2007-02-08 07:07:00 | AAPL | Stock | 3.0629 | 3.0657 | 3.0629 | 3.0657 | 14000.0 |
| 2007-02-08 07:10:00 | AAPL | Stock | 3.0657 | 3.0657 | 3.0657 | 3.0657 | 2800.0 |
| 2007-02-08 07:14:00 | AAPL | Stock | 3.0657 | 3.0657 | 3.0657 | 3.0657 | 2800.0 |
| 2007-02-08 07:21:00 | AAPL | Stock | 3.0625 | 3.0625 | 3.0604 | 3.0604 | 14140.0 |
| 2007-02-08 07:22:00 | AAPL | Stock | 3.0639 | 3.0639 | 3.0639 | 3.0639 | 2800.0 |
| 2007-02-08 07:23:00 | AAPL | Stock | 3.0657 | 3.0657 | 3.0639 | 3.0639 | 8400.0 |
| 2007-02-08 07:26:00 | AAPL | Stock | 3.0675 | 3.0679 | 3.0675 | 3.0679 | 16800.0 |
| 2007-02-08 07:27:00 | AAPL | Stock | 3.0679 | 3.0679 | 3.0679 | 3.0679 | 30800.0 |
| 2007-02-08 07:28:00 | AAPL | Stock | 3.0679 | 3.0679 | 3.0679 | 3.0679 | 5600.0 |
| 2007-02-08 07:29:00 | AAPL | Stock | 3.0679 | 3.0679 | 3.0589 | 3.0589 | 72660.0 |
| 2007-02-08 07:32:00 | AAPL | Stock | 3.0546 | 3.0629 | 3.0536 | 3.0629 | 39200.0 |
| 2007-02-08 07:33:00 | AAPL | Stock | 3.0536 | 3.0582 | 3.0536 | 3.0582 | 32200.0 |
| 2007-02-08 07:34:00 | AAPL | Stock | 3.0536 | 3.0625 | 3.0536 | 3.0625 | 23800.0 |
| 2007-02-08 07:37:00 | AAPL | Stock | 3.0536 | 3.0536 | 3.0536 | 3.0536 | 2800.0 |
| 2007-02-08 07:40:00 | AAPL | Stock | 3.0618 | 3.0625 | 3.0618 | 3.0618 | 28000.0 |
| 2007-02-08 07:41:00 | AAPL | Stock | 3.0536 | 3.0536 | 3.0536 | 3.0536 | 2800.0 |
| 2007-02-08 07:48:00 | AAPL | Stock | 3.0546 | 3.0546 | 3.0546 | 3.0546 | 14000.0 |
| 2007-02-08 07:53:00 | AAPL | Stock | 3.06 | 3.06 | 3.06 | 3.06 | 5600.0 |
| 2007-02-08 07:54:00 | AAPL | Stock | 3.0554 | 3.0554 | 3.0536 | 3.0536 | 63000.0 |
| 2007-02-08 07:56:00 | AAPL | Stock | 3.0536 | 3.0536 | 3.0536 | 3.0536 | 56000.0 |
| 2007-02-08 07:57:00 | AAPL | Stock | 3.0536 | 3.0536 | 3.0536 | 3.0536 | 14000.0 |
| 2007-02-08 07:58:00 | AAPL | Stock | 3.0536 | 3.0536 | 3.0536 | 3.0536 | 11200.0 |
| 2007-02-08 07:59:00 | AAPL | Stock | 3.0554 | 3.0554 | 3.0554 | 3.0554 | 28000.0 |
| 2007-02-08 08:00:00 | AAPL | Stock | 3.0571 | 3.0589 | 3.0539 | 3.0589 | 337960.0 |
| 2007-02-08 08:01:00 | AAPL | Stock | 3.0589 | 3.06 | 3.0571 | 3.06 | 183260.0 |
| 2007-02-08 08:02:00 | AAPL | Stock | 3.0589 | 3.0607 | 3.0571 | 3.0607 | 230440.0 |
| 2007-02-08 08:03:00 | AAPL | Stock | 3.06 | 3.0607 | 3.0589 | 3.0607 | 64400.0 |
| 2007-02-08 08:04:00 | AAPL | Stock | 3.0625 | 3.0636 | 3.0621 | 3.0636 | 75600.0 |
| 2007-02-08 08:05:00 | AAPL | Stock | 3.0643 | 3.0657 | 3.0632 | 3.065 | 68600.0 |
| 2007-02-08 08:06:00 | AAPL | Stock | 3.0646 | 3.0654 | 3.0636 | 3.0636 | 208880.0 |
| 2007-02-08 08:07:00 | AAPL | Stock | 3.0636 | 3.0643 | 3.0607 | 3.0607 | 363160.0 |
| 2007-02-08 08:08:00 | AAPL | Stock | 3.0625 | 3.0643 | 3.0625 | 3.0643 | 142100.0 |
| 2007-02-08 08:09:00 | AAPL | Stock | 3.0625 | 3.0643 | 3.0625 | 3.0643 | 23660.0 |
| 2007-02-08 08:10:00 | AAPL | Stock | 3.0643 | 3.0643 | 3.0643 | 3.0643 | 5600.0 |
| 2007-02-08 08:11:00 | AAPL | Stock | 3.0661 | 3.0689 | 3.0657 | 3.0679 | 321608.0 |
| 2007-02-08 08:12:00 | AAPL | Stock | 3.0661 | 3.0679 | 3.0661 | 3.0661 | 44100.0 |
| 2007-02-08 08:13:00 | AAPL | Stock | 3.0664 | 3.0671 | 3.0661 | 3.0661 | 53200.0 |
| 2007-02-08 08:14:00 | AAPL | Stock | 3.0661 | 3.0671 | 3.0661 | 3.0661 | 53900.0 |
> showing 50 of 712,028 rows — these rows as CSV