PREVIEW / stock_1min / 2004-06-29
file: by_date/stock_1min/2004/2004-06-29.parquet size: 6.2 MB rows: 528,938 symbols: 1,469
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-06-29 08:00:00 | AAPL | Stock | 0.5759 | 0.5768 | 0.5759 | 0.5759 | 39200.0 |
| 2004-06-29 08:01:00 | AAPL | Stock | 0.5782 | 0.5782 | 0.5764 | 0.5764 | 84000.0 |
| 2004-06-29 08:02:00 | AAPL | Stock | 0.5821 | 0.5821 | 0.5821 | 0.5821 | 56000.0 |
| 2004-06-29 08:03:00 | AAPL | Stock | 0.5759 | 0.5777 | 0.5759 | 0.5777 | 25200.0 |
| 2004-06-29 08:08:00 | AAPL | Stock | 0.5741 | 0.5741 | 0.5741 | 0.5741 | 16800.0 |
| 2004-06-29 08:16:00 | AAPL | Stock | 0.5759 | 0.5759 | 0.5759 | 0.5759 | 5600.0 |
| 2004-06-29 08:19:00 | AAPL | Stock | 0.5759 | 0.5759 | 0.5759 | 0.5759 | 22400.0 |
| 2004-06-29 08:22:00 | AAPL | Stock | 0.5741 | 0.5741 | 0.5741 | 0.5741 | 39200.0 |
| 2004-06-29 08:23:00 | AAPL | Stock | 0.5736 | 0.5736 | 0.5734 | 0.5734 | 11200.0 |
| 2004-06-29 08:42:00 | AAPL | Stock | 0.5734 | 0.5734 | 0.5734 | 0.5734 | 5600.0 |
| 2004-06-29 08:43:00 | AAPL | Stock | 0.5734 | 0.5734 | 0.5734 | 0.5734 | 50400.0 |
| 2004-06-29 08:47:00 | AAPL | Stock | 0.575 | 0.575 | 0.575 | 0.575 | 28000.0 |
| 2004-06-29 08:58:00 | AAPL | Stock | 0.5741 | 0.5741 | 0.5741 | 0.5741 | 28000.0 |
| 2004-06-29 09:21:00 | AAPL | Stock | 0.5745 | 0.5745 | 0.5745 | 0.5745 | 10360.0 |
| 2004-06-29 09:25:00 | AAPL | Stock | 0.5745 | 0.5745 | 0.5745 | 0.5745 | 6440.0 |
| 2004-06-29 09:26:00 | AAPL | Stock | 0.5736 | 0.5736 | 0.5736 | 0.5736 | 28000.0 |
| 2004-06-29 09:27:00 | AAPL | Stock | 0.5736 | 0.5736 | 0.5732 | 0.5732 | 257600.0 |
| 2004-06-29 09:28:00 | AAPL | Stock | 0.5732 | 0.5732 | 0.5727 | 0.5727 | 476000.0 |
| 2004-06-29 09:29:00 | AAPL | Stock | 0.5729 | 0.5734 | 0.5725 | 0.5727 | 1461600.0 |
| 2004-06-29 09:30:00 | AAPL | Stock | 0.5732 | 0.5734 | 0.5689 | 0.5689 | 11194904.0 |
| 2004-06-29 09:31:00 | AAPL | Stock | 0.5689 | 0.5698 | 0.5684 | 0.5684 | 5117056.0 |
| 2004-06-29 09:32:00 | AAPL | Stock | 0.5682 | 0.5693 | 0.5671 | 0.568 | 4826640.0 |
| 2004-06-29 09:33:00 | AAPL | Stock | 0.568 | 0.5682 | 0.5655 | 0.5661 | 5310256.0 |
| 2004-06-29 09:34:00 | AAPL | Stock | 0.5661 | 0.5661 | 0.5634 | 0.5641 | 6543040.0 |
| 2004-06-29 09:35:00 | AAPL | Stock | 0.5639 | 0.5645 | 0.5609 | 0.5614 | 9293984.0 |
| 2004-06-29 09:36:00 | AAPL | Stock | 0.5625 | 0.5652 | 0.5614 | 0.5652 | 5843824.0 |
| 2004-06-29 09:37:00 | AAPL | Stock | 0.5652 | 0.5682 | 0.5646 | 0.5654 | 6643392.0 |
| 2004-06-29 09:38:00 | AAPL | Stock | 0.5655 | 0.5666 | 0.5634 | 0.5661 | 5158384.0 |
| 2004-06-29 09:39:00 | AAPL | Stock | 0.5661 | 0.5668 | 0.5657 | 0.5668 | 4585560.0 |
| 2004-06-29 09:40:00 | AAPL | Stock | 0.5666 | 0.567 | 0.5661 | 0.5666 | 3854200.0 |
| 2004-06-29 09:41:00 | AAPL | Stock | 0.5668 | 0.567 | 0.5659 | 0.5666 | 6242824.0 |
| 2004-06-29 09:42:00 | AAPL | Stock | 0.5663 | 0.5684 | 0.5663 | 0.5682 | 3146136.0 |
| 2004-06-29 09:43:00 | AAPL | Stock | 0.5682 | 0.5682 | 0.5668 | 0.5673 | 2195536.0 |
| 2004-06-29 09:44:00 | AAPL | Stock | 0.5675 | 0.5688 | 0.5675 | 0.5679 | 3796016.0 |
| 2004-06-29 09:45:00 | AAPL | Stock | 0.5679 | 0.5679 | 0.5675 | 0.5679 | 1027208.0 |
| 2004-06-29 09:46:00 | AAPL | Stock | 0.5679 | 0.5698 | 0.5677 | 0.5679 | 4255496.0 |
| 2004-06-29 09:47:00 | AAPL | Stock | 0.5695 | 0.57 | 0.5695 | 0.5698 | 1482992.0 |
| 2004-06-29 09:48:00 | AAPL | Stock | 0.57 | 0.5707 | 0.57 | 0.5704 | 1292480.0 |
| 2004-06-29 09:49:00 | AAPL | Stock | 0.5707 | 0.5714 | 0.5704 | 0.5704 | 2549680.0 |
| 2004-06-29 09:50:00 | AAPL | Stock | 0.5702 | 0.5711 | 0.5677 | 0.5686 | 4417112.0 |
| 2004-06-29 09:51:00 | AAPL | Stock | 0.5688 | 0.5695 | 0.5686 | 0.5686 | 3193960.0 |
| 2004-06-29 09:52:00 | AAPL | Stock | 0.5689 | 0.5695 | 0.5688 | 0.5695 | 1215200.0 |
| 2004-06-29 09:53:00 | AAPL | Stock | 0.5693 | 0.5696 | 0.5688 | 0.5688 | 2248064.0 |
| 2004-06-29 09:54:00 | AAPL | Stock | 0.5686 | 0.5696 | 0.5686 | 0.5695 | 1794352.0 |
| 2004-06-29 09:55:00 | AAPL | Stock | 0.5695 | 0.5705 | 0.5691 | 0.5705 | 1378608.0 |
| 2004-06-29 09:56:00 | AAPL | Stock | 0.5705 | 0.5705 | 0.5686 | 0.5695 | 4242112.0 |
| 2004-06-29 09:57:00 | AAPL | Stock | 0.5696 | 0.5702 | 0.5693 | 0.5698 | 732480.0 |
| 2004-06-29 09:58:00 | AAPL | Stock | 0.5696 | 0.5705 | 0.5696 | 0.5702 | 688744.0 |
| 2004-06-29 09:59:00 | AAPL | Stock | 0.5702 | 0.5705 | 0.57 | 0.57 | 2175320.0 |
| 2004-06-29 10:00:00 | AAPL | Stock | 0.5702 | 0.5705 | 0.5686 | 0.5698 | 4567920.0 |
> showing 50 of 528,938 rows — these rows as CSV