PREVIEW / stock_1min / 2004-03-09
file: by_date/stock_1min/2004/2004-03-09.parquet size: 5.2 MB rows: 438,850 symbols: 1,425
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-09 08:01:00 | AAPL | Stock | 0.4661 | 0.4661 | 0.4661 | 0.4661 | 11200.0 |
| 2004-03-09 08:55:00 | AAPL | Stock | 0.4645 | 0.4645 | 0.4645 | 0.4645 | 308000.0 |
| 2004-03-09 08:56:00 | AAPL | Stock | 0.4645 | 0.4645 | 0.4625 | 0.4625 | 397880.0 |
| 2004-03-09 09:02:00 | AAPL | Stock | 0.4625 | 0.4625 | 0.4625 | 0.4625 | 28000.0 |
| 2004-03-09 09:04:00 | AAPL | Stock | 0.4625 | 0.4625 | 0.4625 | 0.4625 | 28000.0 |
| 2004-03-09 09:14:00 | AAPL | Stock | 0.4625 | 0.4625 | 0.4625 | 0.4625 | 56000.0 |
| 2004-03-09 09:18:00 | AAPL | Stock | 0.4625 | 0.463 | 0.4625 | 0.463 | 116200.0 |
| 2004-03-09 09:23:00 | AAPL | Stock | 0.463 | 0.463 | 0.463 | 0.463 | 21000.0 |
| 2004-03-09 09:25:00 | AAPL | Stock | 0.463 | 0.463 | 0.463 | 0.463 | 5600.0 |
| 2004-03-09 09:26:00 | AAPL | Stock | 0.4636 | 0.465 | 0.4636 | 0.465 | 178976.0 |
| 2004-03-09 09:27:00 | AAPL | Stock | 0.4655 | 0.4657 | 0.4655 | 0.4657 | 39200.0 |
| 2004-03-09 09:29:00 | AAPL | Stock | 0.4636 | 0.4636 | 0.4627 | 0.4634 | 202776.0 |
| 2004-03-09 09:30:00 | AAPL | Stock | 0.4625 | 0.4643 | 0.462 | 0.4625 | 3357032.0 |
| 2004-03-09 09:31:00 | AAPL | Stock | 0.463 | 0.4634 | 0.462 | 0.463 | 1073072.0 |
| 2004-03-09 09:32:00 | AAPL | Stock | 0.4627 | 0.4632 | 0.4627 | 0.4629 | 240800.0 |
| 2004-03-09 09:33:00 | AAPL | Stock | 0.463 | 0.463 | 0.4611 | 0.4614 | 418768.0 |
| 2004-03-09 09:34:00 | AAPL | Stock | 0.4609 | 0.462 | 0.4607 | 0.4609 | 945616.0 |
| 2004-03-09 09:35:00 | AAPL | Stock | 0.4607 | 0.4616 | 0.4607 | 0.4611 | 471800.0 |
| 2004-03-09 09:36:00 | AAPL | Stock | 0.4613 | 0.462 | 0.4604 | 0.4604 | 962752.0 |
| 2004-03-09 09:37:00 | AAPL | Stock | 0.4604 | 0.4607 | 0.4604 | 0.4607 | 927192.0 |
| 2004-03-09 09:38:00 | AAPL | Stock | 0.4607 | 0.4609 | 0.4604 | 0.4604 | 355040.0 |
| 2004-03-09 09:39:00 | AAPL | Stock | 0.4604 | 0.4607 | 0.4604 | 0.4605 | 333200.0 |
| 2004-03-09 09:40:00 | AAPL | Stock | 0.4609 | 0.4614 | 0.4598 | 0.4609 | 1349432.0 |
| 2004-03-09 09:41:00 | AAPL | Stock | 0.4609 | 0.4621 | 0.4609 | 0.4614 | 425600.0 |
| 2004-03-09 09:42:00 | AAPL | Stock | 0.4613 | 0.4619 | 0.4611 | 0.4613 | 588616.0 |
| 2004-03-09 09:43:00 | AAPL | Stock | 0.4613 | 0.4632 | 0.4613 | 0.4632 | 688800.0 |
| 2004-03-09 09:44:00 | AAPL | Stock | 0.4632 | 0.4668 | 0.463 | 0.4668 | 918960.0 |
| 2004-03-09 09:45:00 | AAPL | Stock | 0.4664 | 0.4677 | 0.4655 | 0.4677 | 1541008.0 |
| 2004-03-09 09:46:00 | AAPL | Stock | 0.4677 | 0.4698 | 0.4673 | 0.4698 | 1442840.0 |
| 2004-03-09 09:47:00 | AAPL | Stock | 0.47 | 0.4713 | 0.4696 | 0.4713 | 2045064.0 |
| 2004-03-09 09:48:00 | AAPL | Stock | 0.4714 | 0.472 | 0.4707 | 0.4716 | 1419376.0 |
| 2004-03-09 09:49:00 | AAPL | Stock | 0.4714 | 0.4732 | 0.4714 | 0.4732 | 4478096.0 |
| 2004-03-09 09:50:00 | AAPL | Stock | 0.4732 | 0.4732 | 0.4713 | 0.472 | 1468656.0 |
| 2004-03-09 09:51:00 | AAPL | Stock | 0.4709 | 0.4732 | 0.4698 | 0.4704 | 901600.0 |
| 2004-03-09 09:52:00 | AAPL | Stock | 0.4704 | 0.4713 | 0.4704 | 0.4705 | 328272.0 |
| 2004-03-09 09:53:00 | AAPL | Stock | 0.4705 | 0.4705 | 0.4696 | 0.4696 | 680400.0 |
| 2004-03-09 09:54:00 | AAPL | Stock | 0.4696 | 0.4698 | 0.4684 | 0.4684 | 1447880.0 |
| 2004-03-09 09:55:00 | AAPL | Stock | 0.4684 | 0.4689 | 0.4682 | 0.4689 | 1209600.0 |
| 2004-03-09 09:56:00 | AAPL | Stock | 0.4689 | 0.4713 | 0.4689 | 0.4705 | 686000.0 |
| 2004-03-09 09:57:00 | AAPL | Stock | 0.4705 | 0.4713 | 0.4705 | 0.4713 | 546560.0 |
| 2004-03-09 09:58:00 | AAPL | Stock | 0.4713 | 0.4713 | 0.4709 | 0.4713 | 222600.0 |
| 2004-03-09 09:59:00 | AAPL | Stock | 0.4713 | 0.4729 | 0.4713 | 0.4729 | 873600.0 |
| 2004-03-09 10:00:00 | AAPL | Stock | 0.4729 | 0.473 | 0.4718 | 0.472 | 1724800.0 |
| 2004-03-09 10:01:00 | AAPL | Stock | 0.4718 | 0.472 | 0.4702 | 0.4707 | 588000.0 |
| 2004-03-09 10:02:00 | AAPL | Stock | 0.4707 | 0.4714 | 0.4707 | 0.4714 | 544152.0 |
| 2004-03-09 10:03:00 | AAPL | Stock | 0.4711 | 0.4721 | 0.4709 | 0.4711 | 868000.0 |
| 2004-03-09 10:04:00 | AAPL | Stock | 0.4707 | 0.4707 | 0.4707 | 0.4707 | 263200.0 |
| 2004-03-09 10:05:00 | AAPL | Stock | 0.4707 | 0.4709 | 0.4707 | 0.4709 | 286720.0 |
| 2004-03-09 10:06:00 | AAPL | Stock | 0.4707 | 0.472 | 0.4707 | 0.4716 | 1243200.0 |
| 2004-03-09 10:07:00 | AAPL | Stock | 0.4709 | 0.472 | 0.4709 | 0.472 | 44800.0 |
> showing 50 of 438,850 rows — these rows as CSV