PREVIEW / stock_1min / 2004-03-17
file: by_date/stock_1min/2004/2004-03-17.parquet size: 5.6 MB rows: 470,186 symbols: 1,437
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 |
|---|---|---|---|---|---|---|---|
| 2004-03-17 08:28:00 | AAPL | Stock | 0.4607 | 0.4607 | 0.4607 | 0.4607 | 28000.0 |
| 2004-03-17 08:32:00 | AAPL | Stock | 0.4607 | 0.4607 | 0.4607 | 0.4607 | 5600.0 |
| 2004-03-17 08:43:00 | AAPL | Stock | 0.4607 | 0.4607 | 0.4607 | 0.4607 | 28000.0 |
| 2004-03-17 08:45:00 | AAPL | Stock | 0.4598 | 0.4607 | 0.4598 | 0.4607 | 39200.0 |
| 2004-03-17 08:51:00 | AAPL | Stock | 0.4625 | 0.4625 | 0.4625 | 0.4625 | 10080.0 |
| 2004-03-17 08:52:00 | AAPL | Stock | 0.4618 | 0.4618 | 0.4618 | 0.4618 | 5600.0 |
| 2004-03-17 09:20:00 | AAPL | Stock | 0.4616 | 0.4616 | 0.4616 | 0.4616 | 112000.0 |
| 2004-03-17 09:24:00 | AAPL | Stock | 0.4614 | 0.4614 | 0.4614 | 0.4614 | 9520.0 |
| 2004-03-17 09:29:00 | AAPL | Stock | 0.4611 | 0.4634 | 0.4607 | 0.4634 | 954128.0 |
| 2004-03-17 09:30:00 | AAPL | Stock | 0.4613 | 0.4659 | 0.4604 | 0.4623 | 4133696.0 |
| 2004-03-17 09:31:00 | AAPL | Stock | 0.4625 | 0.4638 | 0.4611 | 0.4627 | 977368.0 |
| 2004-03-17 09:32:00 | AAPL | Stock | 0.4632 | 0.4632 | 0.4623 | 0.4625 | 728840.0 |
| 2004-03-17 09:33:00 | AAPL | Stock | 0.4623 | 0.4629 | 0.4616 | 0.462 | 2022496.0 |
| 2004-03-17 09:34:00 | AAPL | Stock | 0.462 | 0.4629 | 0.4618 | 0.4627 | 509824.0 |
| 2004-03-17 09:35:00 | AAPL | Stock | 0.4627 | 0.463 | 0.4625 | 0.463 | 883568.0 |
| 2004-03-17 09:36:00 | AAPL | Stock | 0.4627 | 0.4634 | 0.4627 | 0.4627 | 1346128.0 |
| 2004-03-17 09:37:00 | AAPL | Stock | 0.4627 | 0.4643 | 0.4625 | 0.4634 | 3208240.0 |
| 2004-03-17 09:38:00 | AAPL | Stock | 0.4634 | 0.4634 | 0.463 | 0.4634 | 4763472.0 |
| 2004-03-17 09:39:00 | AAPL | Stock | 0.4634 | 0.4655 | 0.4634 | 0.4641 | 3606344.0 |
| 2004-03-17 09:40:00 | AAPL | Stock | 0.4643 | 0.4643 | 0.4634 | 0.4643 | 5478312.0 |
| 2004-03-17 09:41:00 | AAPL | Stock | 0.4643 | 0.4643 | 0.4634 | 0.4641 | 2704520.0 |
| 2004-03-17 09:42:00 | AAPL | Stock | 0.4641 | 0.4643 | 0.4625 | 0.4625 | 5371016.0 |
| 2004-03-17 09:43:00 | AAPL | Stock | 0.4636 | 0.4641 | 0.4632 | 0.4632 | 676368.0 |
| 2004-03-17 09:44:00 | AAPL | Stock | 0.4632 | 0.4638 | 0.4632 | 0.4638 | 416920.0 |
| 2004-03-17 09:45:00 | AAPL | Stock | 0.4638 | 0.4641 | 0.4638 | 0.4641 | 795200.0 |
| 2004-03-17 09:46:00 | AAPL | Stock | 0.4639 | 0.4641 | 0.4639 | 0.4641 | 1483440.0 |
| 2004-03-17 09:47:00 | AAPL | Stock | 0.4641 | 0.4643 | 0.4641 | 0.4643 | 2234904.0 |
| 2004-03-17 09:48:00 | AAPL | Stock | 0.4643 | 0.4645 | 0.4643 | 0.4643 | 770840.0 |
| 2004-03-17 09:49:00 | AAPL | Stock | 0.4643 | 0.4661 | 0.4643 | 0.4661 | 1205344.0 |
| 2004-03-17 09:50:00 | AAPL | Stock | 0.4661 | 0.4666 | 0.4641 | 0.4666 | 10046120.0 |
| 2004-03-17 09:51:00 | AAPL | Stock | 0.4666 | 0.4682 | 0.4664 | 0.4682 | 2273432.0 |
| 2004-03-17 09:52:00 | AAPL | Stock | 0.4684 | 0.4684 | 0.4677 | 0.4677 | 1821288.0 |
| 2004-03-17 09:53:00 | AAPL | Stock | 0.468 | 0.468 | 0.4673 | 0.4673 | 619808.0 |
| 2004-03-17 09:54:00 | AAPL | Stock | 0.4673 | 0.4677 | 0.4673 | 0.4673 | 1148224.0 |
| 2004-03-17 09:55:00 | AAPL | Stock | 0.4673 | 0.4679 | 0.4673 | 0.4677 | 770000.0 |
| 2004-03-17 09:56:00 | AAPL | Stock | 0.4677 | 0.4686 | 0.4673 | 0.4679 | 842856.0 |
| 2004-03-17 09:57:00 | AAPL | Stock | 0.468 | 0.468 | 0.4661 | 0.4663 | 3623872.0 |
| 2004-03-17 09:58:00 | AAPL | Stock | 0.4663 | 0.4677 | 0.4659 | 0.4661 | 2245600.0 |
| 2004-03-17 09:59:00 | AAPL | Stock | 0.4661 | 0.4661 | 0.465 | 0.4652 | 1513400.0 |
| 2004-03-17 10:00:00 | AAPL | Stock | 0.4652 | 0.4671 | 0.465 | 0.4671 | 2516920.0 |
| 2004-03-17 10:01:00 | AAPL | Stock | 0.4673 | 0.4679 | 0.467 | 0.467 | 859152.0 |
| 2004-03-17 10:02:00 | AAPL | Stock | 0.467 | 0.467 | 0.4645 | 0.4648 | 2352000.0 |
| 2004-03-17 10:03:00 | AAPL | Stock | 0.4648 | 0.4652 | 0.4636 | 0.4641 | 5189016.0 |
| 2004-03-17 10:04:00 | AAPL | Stock | 0.4641 | 0.4643 | 0.4634 | 0.4634 | 3732232.0 |
| 2004-03-17 10:05:00 | AAPL | Stock | 0.4632 | 0.4641 | 0.4627 | 0.4638 | 5113808.0 |
| 2004-03-17 10:06:00 | AAPL | Stock | 0.4638 | 0.4641 | 0.4636 | 0.4636 | 781424.0 |
| 2004-03-17 10:07:00 | AAPL | Stock | 0.4636 | 0.4645 | 0.4636 | 0.4643 | 1357664.0 |
| 2004-03-17 10:08:00 | AAPL | Stock | 0.4643 | 0.4645 | 0.4639 | 0.4641 | 428568.0 |
| 2004-03-17 10:09:00 | AAPL | Stock | 0.4641 | 0.4643 | 0.4639 | 0.4643 | 2027480.0 |
| 2004-03-17 10:10:00 | AAPL | Stock | 0.4643 | 0.4648 | 0.4638 | 0.4643 | 1323000.0 |
> showing 50 of 470,186 rows — these rows as CSV