PREVIEW / stock_1min / 2004-08-05
file: by_date/stock_1min/2004/2004-08-05.parquet size: 5.9 MB rows: 494,607 symbols: 1,487
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-08-05 09:11:00 | AAPL | Stock | 0.5677 | 0.5677 | 0.5677 | 0.5677 | 4334400.0 |
| 2004-08-05 09:16:00 | AAPL | Stock | 0.5677 | 0.5677 | 0.5677 | 0.5677 | 4334400.0 |
| 2004-08-05 09:29:00 | AAPL | Stock | 0.5684 | 0.5684 | 0.5679 | 0.5679 | 72800.0 |
| 2004-08-05 09:30:00 | AAPL | Stock | 0.567 | 0.5688 | 0.5661 | 0.5684 | 1956024.0 |
| 2004-08-05 09:31:00 | AAPL | Stock | 0.5688 | 0.5691 | 0.5682 | 0.5689 | 706776.0 |
| 2004-08-05 09:32:00 | AAPL | Stock | 0.5691 | 0.5693 | 0.5689 | 0.5693 | 456568.0 |
| 2004-08-05 09:33:00 | AAPL | Stock | 0.5691 | 0.5713 | 0.5689 | 0.5713 | 1630160.0 |
| 2004-08-05 09:34:00 | AAPL | Stock | 0.5709 | 0.5714 | 0.5709 | 0.5714 | 729008.0 |
| 2004-08-05 09:35:00 | AAPL | Stock | 0.5716 | 0.5732 | 0.5714 | 0.573 | 1849904.0 |
| 2004-08-05 09:36:00 | AAPL | Stock | 0.573 | 0.575 | 0.573 | 0.5748 | 1502984.0 |
| 2004-08-05 09:37:00 | AAPL | Stock | 0.575 | 0.5764 | 0.5741 | 0.5759 | 2708608.0 |
| 2004-08-05 09:38:00 | AAPL | Stock | 0.5764 | 0.5768 | 0.5755 | 0.5756 | 3425632.0 |
| 2004-08-05 09:39:00 | AAPL | Stock | 0.5757 | 0.5757 | 0.5741 | 0.5755 | 1023400.0 |
| 2004-08-05 09:40:00 | AAPL | Stock | 0.5755 | 0.5759 | 0.5752 | 0.5754 | 405832.0 |
| 2004-08-05 09:41:00 | AAPL | Stock | 0.5755 | 0.5755 | 0.5745 | 0.5745 | 784336.0 |
| 2004-08-05 09:42:00 | AAPL | Stock | 0.5743 | 0.575 | 0.5738 | 0.5746 | 487200.0 |
| 2004-08-05 09:43:00 | AAPL | Stock | 0.5746 | 0.5746 | 0.5741 | 0.5743 | 498344.0 |
| 2004-08-05 09:44:00 | AAPL | Stock | 0.5745 | 0.5746 | 0.5745 | 0.5745 | 117600.0 |
| 2004-08-05 09:45:00 | AAPL | Stock | 0.5743 | 0.5746 | 0.5743 | 0.5746 | 613536.0 |
| 2004-08-05 09:46:00 | AAPL | Stock | 0.5746 | 0.575 | 0.5745 | 0.5746 | 1530760.0 |
| 2004-08-05 09:47:00 | AAPL | Stock | 0.5745 | 0.5748 | 0.5741 | 0.5748 | 1038688.0 |
| 2004-08-05 09:48:00 | AAPL | Stock | 0.5745 | 0.5752 | 0.5745 | 0.5752 | 1523648.0 |
| 2004-08-05 09:49:00 | AAPL | Stock | 0.575 | 0.5757 | 0.5748 | 0.575 | 1990184.0 |
| 2004-08-05 09:50:00 | AAPL | Stock | 0.575 | 0.5754 | 0.5748 | 0.575 | 1310400.0 |
| 2004-08-05 09:51:00 | AAPL | Stock | 0.5748 | 0.5748 | 0.5741 | 0.5743 | 285600.0 |
| 2004-08-05 09:52:00 | AAPL | Stock | 0.5746 | 0.5752 | 0.5745 | 0.5752 | 394464.0 |
| 2004-08-05 09:53:00 | AAPL | Stock | 0.5748 | 0.575 | 0.5748 | 0.5748 | 1058400.0 |
| 2004-08-05 09:54:00 | AAPL | Stock | 0.5748 | 0.5748 | 0.5745 | 0.5745 | 217504.0 |
| 2004-08-05 09:55:00 | AAPL | Stock | 0.5746 | 0.575 | 0.5746 | 0.575 | 687120.0 |
| 2004-08-05 09:56:00 | AAPL | Stock | 0.5752 | 0.5752 | 0.5745 | 0.5745 | 912968.0 |
| 2004-08-05 09:57:00 | AAPL | Stock | 0.5746 | 0.5746 | 0.5745 | 0.5746 | 81200.0 |
| 2004-08-05 09:58:00 | AAPL | Stock | 0.5746 | 0.575 | 0.5746 | 0.5748 | 291200.0 |
| 2004-08-05 09:59:00 | AAPL | Stock | 0.575 | 0.5757 | 0.5746 | 0.5755 | 505512.0 |
| 2004-08-05 10:00:00 | AAPL | Stock | 0.5755 | 0.5755 | 0.575 | 0.5752 | 336112.0 |
| 2004-08-05 10:01:00 | AAPL | Stock | 0.5752 | 0.5755 | 0.5748 | 0.5755 | 431200.0 |
| 2004-08-05 10:02:00 | AAPL | Stock | 0.5755 | 0.5768 | 0.5754 | 0.5768 | 5428192.0 |
| 2004-08-05 10:03:00 | AAPL | Stock | 0.5764 | 0.5764 | 0.5757 | 0.5764 | 734048.0 |
| 2004-08-05 10:04:00 | AAPL | Stock | 0.5759 | 0.5768 | 0.5759 | 0.5761 | 1710576.0 |
| 2004-08-05 10:05:00 | AAPL | Stock | 0.5761 | 0.5763 | 0.5757 | 0.5757 | 935200.0 |
| 2004-08-05 10:06:00 | AAPL | Stock | 0.5757 | 0.5764 | 0.5757 | 0.5761 | 750400.0 |
| 2004-08-05 10:07:00 | AAPL | Stock | 0.5761 | 0.5763 | 0.5761 | 0.5761 | 438704.0 |
| 2004-08-05 10:08:00 | AAPL | Stock | 0.5761 | 0.5761 | 0.5757 | 0.5759 | 348656.0 |
| 2004-08-05 10:09:00 | AAPL | Stock | 0.5759 | 0.5763 | 0.5759 | 0.5759 | 912520.0 |
| 2004-08-05 10:10:00 | AAPL | Stock | 0.5759 | 0.5759 | 0.5755 | 0.5756 | 162400.0 |
| 2004-08-05 10:11:00 | AAPL | Stock | 0.5755 | 0.5755 | 0.575 | 0.5754 | 349328.0 |
| 2004-08-05 10:12:00 | AAPL | Stock | 0.5757 | 0.5757 | 0.5754 | 0.5755 | 288904.0 |
| 2004-08-05 10:13:00 | AAPL | Stock | 0.5755 | 0.5757 | 0.5734 | 0.5741 | 1190000.0 |
| 2004-08-05 10:14:00 | AAPL | Stock | 0.5743 | 0.5754 | 0.5734 | 0.575 | 1495200.0 |
| 2004-08-05 10:15:00 | AAPL | Stock | 0.5748 | 0.5759 | 0.5748 | 0.5757 | 1041600.0 |
| 2004-08-05 10:16:00 | AAPL | Stock | 0.5757 | 0.5757 | 0.575 | 0.575 | 294000.0 |
> showing 50 of 494,607 rows — these rows as CSV