PREVIEW / stock_1min / 2004-07-27
file: by_date/stock_1min/2004/2004-07-27.parquet size: 6.2 MB rows: 514,995 symbols: 1,489
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-07-27 08:04:00 | AAPL | Stock | 0.5657 | 0.5661 | 0.5657 | 0.5661 | 56000.0 |
| 2004-07-27 08:09:00 | AAPL | Stock | 0.57 | 0.57 | 0.57 | 0.57 | 56000.0 |
| 2004-07-27 08:15:00 | AAPL | Stock | 0.5696 | 0.5714 | 0.5696 | 0.5714 | 445200.0 |
| 2004-07-27 08:18:00 | AAPL | Stock | 0.5668 | 0.5668 | 0.5668 | 0.5668 | 56000.0 |
| 2004-07-27 08:22:00 | AAPL | Stock | 0.5714 | 0.5714 | 0.5714 | 0.5714 | 11200.0 |
| 2004-07-27 08:24:00 | AAPL | Stock | 0.5714 | 0.5714 | 0.5705 | 0.5714 | 319200.0 |
| 2004-07-27 08:27:00 | AAPL | Stock | 0.5716 | 0.5741 | 0.5714 | 0.5741 | 67368.0 |
| 2004-07-27 08:31:00 | AAPL | Stock | 0.5739 | 0.5739 | 0.5739 | 0.5739 | 16800.0 |
| 2004-07-27 08:32:00 | AAPL | Stock | 0.5732 | 0.5738 | 0.5732 | 0.5738 | 106400.0 |
| 2004-07-27 08:34:00 | AAPL | Stock | 0.5714 | 0.5714 | 0.5714 | 0.5714 | 28000.0 |
| 2004-07-27 08:35:00 | AAPL | Stock | 0.5705 | 0.5705 | 0.5705 | 0.5705 | 56000.0 |
| 2004-07-27 08:42:00 | AAPL | Stock | 0.5714 | 0.5714 | 0.5714 | 0.5714 | 5600.0 |
| 2004-07-27 08:43:00 | AAPL | Stock | 0.5714 | 0.5714 | 0.5714 | 0.5714 | 56000.0 |
| 2004-07-27 08:46:00 | AAPL | Stock | 0.5714 | 0.5714 | 0.5714 | 0.5714 | 5600.0 |
| 2004-07-27 08:48:00 | AAPL | Stock | 0.5714 | 0.5714 | 0.5714 | 0.5714 | 28000.0 |
| 2004-07-27 08:51:00 | AAPL | Stock | 0.5675 | 0.5675 | 0.5675 | 0.5675 | 22400.0 |
| 2004-07-27 08:57:00 | AAPL | Stock | 0.5709 | 0.5709 | 0.5709 | 0.5709 | 5600.0 |
| 2004-07-27 09:17:00 | AAPL | Stock | 0.5705 | 0.5705 | 0.5705 | 0.5705 | 168000.0 |
| 2004-07-27 09:19:00 | AAPL | Stock | 0.5705 | 0.5705 | 0.5705 | 0.5705 | 16800.0 |
| 2004-07-27 09:20:00 | AAPL | Stock | 0.5704 | 0.5704 | 0.5704 | 0.5704 | 22400.0 |
| 2004-07-27 09:21:00 | AAPL | Stock | 0.5704 | 0.5704 | 0.5704 | 0.5704 | 16800.0 |
| 2004-07-27 09:22:00 | AAPL | Stock | 0.5705 | 0.5707 | 0.57 | 0.57 | 112168.0 |
| 2004-07-27 09:25:00 | AAPL | Stock | 0.5696 | 0.5696 | 0.5696 | 0.5696 | 28000.0 |
| 2004-07-27 09:27:00 | AAPL | Stock | 0.5696 | 0.5696 | 0.5696 | 0.5696 | 53200.0 |
| 2004-07-27 09:29:00 | AAPL | Stock | 0.5671 | 0.568 | 0.5671 | 0.5679 | 210224.0 |
| 2004-07-27 09:30:00 | AAPL | Stock | 0.567 | 0.568 | 0.567 | 0.5678 | 2238096.0 |
| 2004-07-27 09:31:00 | AAPL | Stock | 0.5679 | 0.5684 | 0.5671 | 0.5671 | 799344.0 |
| 2004-07-27 09:32:00 | AAPL | Stock | 0.5673 | 0.5673 | 0.5671 | 0.5671 | 990808.0 |
| 2004-07-27 09:33:00 | AAPL | Stock | 0.5671 | 0.5671 | 0.5664 | 0.5666 | 1284976.0 |
| 2004-07-27 09:34:00 | AAPL | Stock | 0.5666 | 0.5671 | 0.5657 | 0.5661 | 4855816.0 |
| 2004-07-27 09:35:00 | AAPL | Stock | 0.5657 | 0.5659 | 0.5652 | 0.5655 | 1864800.0 |
| 2004-07-27 09:36:00 | AAPL | Stock | 0.5657 | 0.5657 | 0.565 | 0.5655 | 348712.0 |
| 2004-07-27 09:37:00 | AAPL | Stock | 0.5654 | 0.5654 | 0.5639 | 0.5639 | 333200.0 |
| 2004-07-27 09:38:00 | AAPL | Stock | 0.5641 | 0.5643 | 0.5638 | 0.5638 | 279832.0 |
| 2004-07-27 09:39:00 | AAPL | Stock | 0.5639 | 0.5643 | 0.5639 | 0.5639 | 504168.0 |
| 2004-07-27 09:40:00 | AAPL | Stock | 0.5639 | 0.5646 | 0.5639 | 0.5641 | 522760.0 |
| 2004-07-27 09:41:00 | AAPL | Stock | 0.5641 | 0.5643 | 0.5639 | 0.5641 | 1069600.0 |
| 2004-07-27 09:42:00 | AAPL | Stock | 0.5641 | 0.5645 | 0.5639 | 0.5645 | 1080800.0 |
| 2004-07-27 09:43:00 | AAPL | Stock | 0.5645 | 0.5654 | 0.5645 | 0.5652 | 897344.0 |
| 2004-07-27 09:44:00 | AAPL | Stock | 0.5652 | 0.5661 | 0.565 | 0.5655 | 1489600.0 |
| 2004-07-27 09:45:00 | AAPL | Stock | 0.5654 | 0.5671 | 0.5654 | 0.567 | 1383816.0 |
| 2004-07-27 09:46:00 | AAPL | Stock | 0.567 | 0.568 | 0.567 | 0.5679 | 1204448.0 |
| 2004-07-27 09:47:00 | AAPL | Stock | 0.568 | 0.5682 | 0.5677 | 0.5677 | 399168.0 |
| 2004-07-27 09:48:00 | AAPL | Stock | 0.5679 | 0.5688 | 0.5679 | 0.568 | 481600.0 |
| 2004-07-27 09:49:00 | AAPL | Stock | 0.568 | 0.568 | 0.5664 | 0.5675 | 915488.0 |
| 2004-07-27 09:50:00 | AAPL | Stock | 0.5675 | 0.5675 | 0.5657 | 0.5657 | 1215200.0 |
| 2004-07-27 09:51:00 | AAPL | Stock | 0.5659 | 0.5664 | 0.5654 | 0.5655 | 512568.0 |
| 2004-07-27 09:52:00 | AAPL | Stock | 0.5657 | 0.5671 | 0.5657 | 0.5671 | 1152816.0 |
| 2004-07-27 09:53:00 | AAPL | Stock | 0.567 | 0.5675 | 0.5659 | 0.5659 | 1747200.0 |
| 2004-07-27 09:54:00 | AAPL | Stock | 0.5657 | 0.5663 | 0.5657 | 0.5661 | 330960.0 |
> showing 50 of 514,995 rows — these rows as CSV