PREVIEW / stock_1min / 2009-12-03
file: by_date/stock_1min/2009/2009-12-03.parquet size: 12.5 MB rows: 943,173 symbols: 2,779
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-12-03 04:15:00 | AAPL | Stock | 7.0664 | 7.0664 | 7.0664 | 7.0664 | 2800.0 |
| 2009-12-03 04:32:00 | AAPL | Stock | 7.0686 | 7.0686 | 7.0682 | 7.0682 | 9520.0 |
| 2009-12-03 04:35:00 | AAPL | Stock | 7.085 | 7.085 | 7.085 | 7.085 | 5600.0 |
| 2009-12-03 05:04:00 | AAPL | Stock | 7.0714 | 7.0714 | 7.0714 | 7.0714 | 6104.0 |
| 2009-12-03 05:12:00 | AAPL | Stock | 7.0696 | 7.0696 | 7.0696 | 7.0696 | 2800.0 |
| 2009-12-03 05:21:00 | AAPL | Stock | 7.0718 | 7.0718 | 7.0714 | 7.0714 | 25816.0 |
| 2009-12-03 05:52:00 | AAPL | Stock | 7.0832 | 7.0836 | 7.0832 | 7.0832 | 22540.0 |
| 2009-12-03 06:29:00 | AAPL | Stock | 7.0725 | 7.0725 | 7.0725 | 7.0725 | 13496.0 |
| 2009-12-03 06:59:00 | AAPL | Stock | 7.0582 | 7.0582 | 7.0582 | 7.0582 | 6160.0 |
| 2009-12-03 07:03:00 | AAPL | Stock | 7.0454 | 7.0454 | 7.0454 | 7.0454 | 2800.0 |
| 2009-12-03 07:06:00 | AAPL | Stock | 7.0625 | 7.0625 | 7.0625 | 7.0625 | 8400.0 |
| 2009-12-03 07:09:00 | AAPL | Stock | 7.0618 | 7.0618 | 7.0618 | 7.0618 | 5600.0 |
| 2009-12-03 07:12:00 | AAPL | Stock | 7.0618 | 7.0632 | 7.0618 | 7.0629 | 35000.0 |
| 2009-12-03 07:15:00 | AAPL | Stock | 7.0711 | 7.0711 | 7.0711 | 7.0711 | 7336.0 |
| 2009-12-03 07:17:00 | AAPL | Stock | 7.0696 | 7.0696 | 7.0696 | 7.0696 | 14000.0 |
| 2009-12-03 07:19:00 | AAPL | Stock | 7.0714 | 7.0721 | 7.0714 | 7.0721 | 33600.0 |
| 2009-12-03 07:20:00 | AAPL | Stock | 7.0714 | 7.0714 | 7.0696 | 7.0696 | 25200.0 |
| 2009-12-03 07:21:00 | AAPL | Stock | 7.0714 | 7.0714 | 7.0714 | 7.0714 | 2800.0 |
| 2009-12-03 07:22:00 | AAPL | Stock | 7.0725 | 7.0725 | 7.0725 | 7.0725 | 13608.0 |
| 2009-12-03 07:24:00 | AAPL | Stock | 7.0732 | 7.0732 | 7.0732 | 7.0732 | 2800.0 |
| 2009-12-03 07:30:00 | AAPL | Stock | 7.0629 | 7.0629 | 7.0629 | 7.0629 | 6216.0 |
| 2009-12-03 07:31:00 | AAPL | Stock | 7.0629 | 7.0629 | 7.0625 | 7.0625 | 5600.0 |
| 2009-12-03 07:43:00 | AAPL | Stock | 7.0639 | 7.0639 | 7.0639 | 7.0639 | 6216.0 |
| 2009-12-03 07:44:00 | AAPL | Stock | 7.0639 | 7.0639 | 7.0639 | 7.0639 | 7000.0 |
| 2009-12-03 07:52:00 | AAPL | Stock | 7.0679 | 7.0679 | 7.0679 | 7.0679 | 7000.0 |
| 2009-12-03 07:54:00 | AAPL | Stock | 7.0625 | 7.0625 | 7.0625 | 7.0625 | 6300.0 |
| 2009-12-03 07:55:00 | AAPL | Stock | 7.0625 | 7.0679 | 7.0625 | 7.0625 | 14000.0 |
| 2009-12-03 07:57:00 | AAPL | Stock | 7.0611 | 7.0611 | 7.0575 | 7.0575 | 19600.0 |
| 2009-12-03 07:58:00 | AAPL | Stock | 7.06 | 7.06 | 7.0575 | 7.0575 | 14000.0 |
| 2009-12-03 08:00:00 | AAPL | Stock | 7.06 | 7.0714 | 7.06 | 7.0661 | 180516.0 |
| 2009-12-03 08:01:00 | AAPL | Stock | 7.0611 | 7.0714 | 7.0607 | 7.0646 | 232064.0 |
| 2009-12-03 08:02:00 | AAPL | Stock | 7.0625 | 7.065 | 7.0625 | 7.0646 | 72800.0 |
| 2009-12-03 08:03:00 | AAPL | Stock | 7.0589 | 7.0625 | 7.0589 | 7.0625 | 33600.0 |
| 2009-12-03 08:04:00 | AAPL | Stock | 7.0625 | 7.0625 | 7.0625 | 7.0625 | 2800.0 |
| 2009-12-03 08:05:00 | AAPL | Stock | 7.0593 | 7.0593 | 7.0579 | 7.0579 | 22400.0 |
| 2009-12-03 08:06:00 | AAPL | Stock | 7.0589 | 7.0589 | 7.0589 | 7.0589 | 2800.0 |
| 2009-12-03 08:07:00 | AAPL | Stock | 7.0607 | 7.0607 | 7.0593 | 7.0596 | 19600.0 |
| 2009-12-03 08:08:00 | AAPL | Stock | 7.0593 | 7.0646 | 7.0593 | 7.0641 | 175000.0 |
| 2009-12-03 08:09:00 | AAPL | Stock | 7.0643 | 7.0643 | 7.0643 | 7.0643 | 8400.0 |
| 2009-12-03 08:10:00 | AAPL | Stock | 7.0625 | 7.0632 | 7.0596 | 7.0596 | 25200.0 |
| 2009-12-03 08:11:00 | AAPL | Stock | 7.0596 | 7.0641 | 7.0589 | 7.0607 | 33320.0 |
| 2009-12-03 08:12:00 | AAPL | Stock | 7.0607 | 7.0607 | 7.0607 | 7.0607 | 22400.0 |
| 2009-12-03 08:13:00 | AAPL | Stock | 7.0621 | 7.0625 | 7.0621 | 7.0625 | 11200.0 |
| 2009-12-03 08:14:00 | AAPL | Stock | 7.0621 | 7.0621 | 7.0621 | 7.0621 | 2800.0 |
| 2009-12-03 08:15:00 | AAPL | Stock | 7.0611 | 7.0611 | 7.0611 | 7.0611 | 8400.0 |
| 2009-12-03 08:16:00 | AAPL | Stock | 7.0611 | 7.0611 | 7.0611 | 7.0611 | 8400.0 |
| 2009-12-03 08:17:00 | AAPL | Stock | 7.0611 | 7.0611 | 7.0586 | 7.0586 | 55636.0 |
| 2009-12-03 08:18:00 | AAPL | Stock | 7.0607 | 7.0607 | 7.0607 | 7.0607 | 13020.0 |
| 2009-12-03 08:19:00 | AAPL | Stock | 7.0607 | 7.0611 | 7.0607 | 7.0611 | 8400.0 |
| 2009-12-03 08:20:00 | AAPL | Stock | 7.0607 | 7.0607 | 7.0607 | 7.0607 | 5880.0 |
> showing 50 of 943,173 rows — these rows as CSV