PREVIEW / stock_1min / 2004-08-25
file: by_date/stock_1min/2004/2004-08-25.parquet size: 5.6 MB rows: 476,389 symbols: 1,493
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-25 08:01:00 | AAPL | Stock | 0.5696 | 0.5696 | 0.5696 | 0.5696 | 11200.0 |
| 2004-08-25 09:04:00 | AAPL | Stock | 0.5688 | 0.5688 | 0.5688 | 0.5688 | 44800.0 |
| 2004-08-25 09:15:00 | AAPL | Stock | 0.5695 | 0.5695 | 0.5695 | 0.5695 | 11200.0 |
| 2004-08-25 09:23:00 | AAPL | Stock | 0.5695 | 0.5696 | 0.5695 | 0.5696 | 16800.0 |
| 2004-08-25 09:24:00 | AAPL | Stock | 0.5696 | 0.5696 | 0.5696 | 0.5696 | 61600.0 |
| 2004-08-25 09:25:00 | AAPL | Stock | 0.5704 | 0.5704 | 0.5704 | 0.5704 | 33600.0 |
| 2004-08-25 09:27:00 | AAPL | Stock | 0.57 | 0.57 | 0.57 | 0.57 | 11200.0 |
| 2004-08-25 09:29:00 | AAPL | Stock | 0.57 | 0.5709 | 0.5693 | 0.5705 | 726824.0 |
| 2004-08-25 09:30:00 | AAPL | Stock | 0.5698 | 0.5709 | 0.5691 | 0.5709 | 5939864.0 |
| 2004-08-25 09:31:00 | AAPL | Stock | 0.5709 | 0.5711 | 0.5707 | 0.5707 | 1413496.0 |
| 2004-08-25 09:32:00 | AAPL | Stock | 0.5707 | 0.5707 | 0.5705 | 0.5707 | 464632.0 |
| 2004-08-25 09:33:00 | AAPL | Stock | 0.5707 | 0.5713 | 0.5705 | 0.5709 | 1720152.0 |
| 2004-08-25 09:34:00 | AAPL | Stock | 0.5713 | 0.5714 | 0.5709 | 0.5709 | 1580544.0 |
| 2004-08-25 09:35:00 | AAPL | Stock | 0.5709 | 0.5713 | 0.5705 | 0.5705 | 1397648.0 |
| 2004-08-25 09:36:00 | AAPL | Stock | 0.5705 | 0.5707 | 0.5688 | 0.5689 | 2016896.0 |
| 2004-08-25 09:37:00 | AAPL | Stock | 0.5689 | 0.5696 | 0.5682 | 0.5686 | 1370488.0 |
| 2004-08-25 09:38:00 | AAPL | Stock | 0.5688 | 0.5688 | 0.568 | 0.568 | 773976.0 |
| 2004-08-25 09:39:00 | AAPL | Stock | 0.5682 | 0.57 | 0.568 | 0.57 | 512232.0 |
| 2004-08-25 09:40:00 | AAPL | Stock | 0.57 | 0.5702 | 0.5691 | 0.5691 | 458752.0 |
| 2004-08-25 09:41:00 | AAPL | Stock | 0.5693 | 0.5702 | 0.5689 | 0.5693 | 737352.0 |
| 2004-08-25 09:42:00 | AAPL | Stock | 0.5691 | 0.5691 | 0.567 | 0.5671 | 1881208.0 |
| 2004-08-25 09:43:00 | AAPL | Stock | 0.5673 | 0.5682 | 0.5671 | 0.5682 | 708400.0 |
| 2004-08-25 09:44:00 | AAPL | Stock | 0.5684 | 0.5684 | 0.568 | 0.5682 | 274120.0 |
| 2004-08-25 09:45:00 | AAPL | Stock | 0.568 | 0.5682 | 0.5675 | 0.5682 | 931168.0 |
| 2004-08-25 09:46:00 | AAPL | Stock | 0.5682 | 0.5688 | 0.568 | 0.5684 | 458528.0 |
| 2004-08-25 09:47:00 | AAPL | Stock | 0.5686 | 0.5688 | 0.5679 | 0.5688 | 923888.0 |
| 2004-08-25 09:48:00 | AAPL | Stock | 0.5688 | 0.5688 | 0.5673 | 0.5679 | 1370880.0 |
| 2004-08-25 09:49:00 | AAPL | Stock | 0.5682 | 0.5682 | 0.5675 | 0.5677 | 601216.0 |
| 2004-08-25 09:50:00 | AAPL | Stock | 0.5679 | 0.57 | 0.5679 | 0.5693 | 1046472.0 |
| 2004-08-25 09:51:00 | AAPL | Stock | 0.5691 | 0.5691 | 0.5684 | 0.5686 | 729232.0 |
| 2004-08-25 09:52:00 | AAPL | Stock | 0.5686 | 0.5691 | 0.568 | 0.5691 | 442680.0 |
| 2004-08-25 09:53:00 | AAPL | Stock | 0.5691 | 0.5691 | 0.5684 | 0.5688 | 311024.0 |
| 2004-08-25 09:54:00 | AAPL | Stock | 0.5688 | 0.5704 | 0.5688 | 0.5695 | 1871800.0 |
| 2004-08-25 09:55:00 | AAPL | Stock | 0.5695 | 0.5698 | 0.5689 | 0.5695 | 1525664.0 |
| 2004-08-25 09:56:00 | AAPL | Stock | 0.5696 | 0.57 | 0.5695 | 0.5695 | 980000.0 |
| 2004-08-25 09:57:00 | AAPL | Stock | 0.5696 | 0.5696 | 0.5689 | 0.5689 | 1094128.0 |
| 2004-08-25 09:58:00 | AAPL | Stock | 0.5689 | 0.5689 | 0.5686 | 0.5686 | 296968.0 |
| 2004-08-25 09:59:00 | AAPL | Stock | 0.5686 | 0.5693 | 0.5673 | 0.5682 | 1969464.0 |
| 2004-08-25 10:00:00 | AAPL | Stock | 0.5684 | 0.5691 | 0.5677 | 0.5686 | 1060808.0 |
| 2004-08-25 10:01:00 | AAPL | Stock | 0.5684 | 0.5688 | 0.5682 | 0.5684 | 749840.0 |
| 2004-08-25 10:02:00 | AAPL | Stock | 0.5684 | 0.5684 | 0.5673 | 0.5673 | 292656.0 |
| 2004-08-25 10:03:00 | AAPL | Stock | 0.5677 | 0.5677 | 0.5671 | 0.5671 | 311640.0 |
| 2004-08-25 10:04:00 | AAPL | Stock | 0.5671 | 0.5677 | 0.5671 | 0.5675 | 473592.0 |
| 2004-08-25 10:05:00 | AAPL | Stock | 0.5671 | 0.5673 | 0.567 | 0.5673 | 584192.0 |
| 2004-08-25 10:06:00 | AAPL | Stock | 0.5673 | 0.5675 | 0.567 | 0.5673 | 588000.0 |
| 2004-08-25 10:07:00 | AAPL | Stock | 0.5675 | 0.5688 | 0.5675 | 0.5682 | 808248.0 |
| 2004-08-25 10:08:00 | AAPL | Stock | 0.568 | 0.568 | 0.5677 | 0.5679 | 415744.0 |
| 2004-08-25 10:09:00 | AAPL | Stock | 0.5677 | 0.5677 | 0.5673 | 0.5673 | 324856.0 |
| 2004-08-25 10:10:00 | AAPL | Stock | 0.5675 | 0.5675 | 0.5671 | 0.5671 | 216496.0 |
| 2004-08-25 10:11:00 | AAPL | Stock | 0.5671 | 0.5671 | 0.567 | 0.567 | 202104.0 |
> showing 50 of 476,389 rows — these rows as CSV