PREVIEW / stock_5min / 2004-06-29
file: by_date/stock_5min/2004/2004-06-29.parquet size: 2.5 MB rows: 184,978 symbols: 1,791
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.5821 | 0.5759 | 0.5777 | 204400.0 |
| 2004-06-29 08:05:00 | AAPL | Stock | 0.5741 | 0.5741 | 0.5741 | 0.5741 | 16800.0 |
| 2004-06-29 08:15:00 | AAPL | Stock | 0.5759 | 0.5759 | 0.5759 | 0.5759 | 28000.0 |
| 2004-06-29 08:20:00 | AAPL | Stock | 0.5741 | 0.5741 | 0.5734 | 0.5734 | 50400.0 |
| 2004-06-29 08:40:00 | AAPL | Stock | 0.5734 | 0.5734 | 0.5734 | 0.5734 | 56000.0 |
| 2004-06-29 08:45:00 | AAPL | Stock | 0.575 | 0.575 | 0.575 | 0.575 | 28000.0 |
| 2004-06-29 08:55:00 | AAPL | Stock | 0.5741 | 0.5741 | 0.5741 | 0.5741 | 28000.0 |
| 2004-06-29 09:20: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.5725 | 0.5727 | 2229640.0 |
| 2004-06-29 09:30:00 | AAPL | Stock | 0.5732 | 0.5734 | 0.5634 | 0.5641 | 32991896.0 |
| 2004-06-29 09:35:00 | AAPL | Stock | 0.5639 | 0.5682 | 0.5609 | 0.5668 | 31525144.0 |
| 2004-06-29 09:40:00 | AAPL | Stock | 0.5666 | 0.5688 | 0.5659 | 0.5679 | 19234712.0 |
| 2004-06-29 09:45:00 | AAPL | Stock | 0.5679 | 0.5714 | 0.5675 | 0.5704 | 10607856.0 |
| 2004-06-29 09:50:00 | AAPL | Stock | 0.5702 | 0.5711 | 0.5677 | 0.5695 | 12868688.0 |
| 2004-06-29 09:55:00 | AAPL | Stock | 0.5695 | 0.5705 | 0.5686 | 0.57 | 9217264.0 |
| 2004-06-29 10:00:00 | AAPL | Stock | 0.5702 | 0.5705 | 0.5666 | 0.5677 | 14828072.0 |
| 2004-06-29 10:05:00 | AAPL | Stock | 0.5677 | 0.5684 | 0.5654 | 0.5679 | 19796224.0 |
| 2004-06-29 10:10:00 | AAPL | Stock | 0.568 | 0.5686 | 0.5677 | 0.5682 | 7500696.0 |
| 2004-06-29 10:15:00 | AAPL | Stock | 0.5684 | 0.5688 | 0.5652 | 0.5657 | 12464592.0 |
| 2004-06-29 10:20:00 | AAPL | Stock | 0.5654 | 0.5666 | 0.5652 | 0.5661 | 11586008.0 |
| 2004-06-29 10:25:00 | AAPL | Stock | 0.5661 | 0.5663 | 0.5646 | 0.5652 | 7651224.0 |
| 2004-06-29 10:30:00 | AAPL | Stock | 0.5654 | 0.5688 | 0.5652 | 0.5688 | 12174960.0 |
| 2004-06-29 10:35:00 | AAPL | Stock | 0.5688 | 0.5688 | 0.5664 | 0.5668 | 8999256.0 |
| 2004-06-29 10:40:00 | AAPL | Stock | 0.567 | 0.5679 | 0.5664 | 0.5668 | 4396112.0 |
| 2004-06-29 10:45:00 | AAPL | Stock | 0.567 | 0.5675 | 0.5663 | 0.5673 | 6600832.0 |
| 2004-06-29 10:50:00 | AAPL | Stock | 0.5675 | 0.5688 | 0.5671 | 0.5679 | 6532512.0 |
| 2004-06-29 10:55:00 | AAPL | Stock | 0.5677 | 0.5696 | 0.5675 | 0.5693 | 4546248.0 |
| 2004-06-29 11:00:00 | AAPL | Stock | 0.5695 | 0.5711 | 0.5693 | 0.5709 | 4147416.0 |
| 2004-06-29 11:05:00 | AAPL | Stock | 0.5711 | 0.5713 | 0.5707 | 0.5707 | 4771928.0 |
| 2004-06-29 11:10:00 | AAPL | Stock | 0.5709 | 0.5709 | 0.5698 | 0.5707 | 4088784.0 |
| 2004-06-29 11:15:00 | AAPL | Stock | 0.5702 | 0.5704 | 0.5691 | 0.5702 | 6294904.0 |
| 2004-06-29 11:20:00 | AAPL | Stock | 0.5702 | 0.5702 | 0.5691 | 0.5691 | 2923760.0 |
| 2004-06-29 11:25:00 | AAPL | Stock | 0.5689 | 0.5705 | 0.5689 | 0.5704 | 5465880.0 |
| 2004-06-29 11:30:00 | AAPL | Stock | 0.5704 | 0.5711 | 0.57 | 0.5704 | 3733016.0 |
| 2004-06-29 11:35:00 | AAPL | Stock | 0.5705 | 0.5727 | 0.5704 | 0.572 | 6354880.0 |
| 2004-06-29 11:40:00 | AAPL | Stock | 0.5716 | 0.5723 | 0.5707 | 0.5709 | 2880584.0 |
| 2004-06-29 11:45:00 | AAPL | Stock | 0.5711 | 0.5718 | 0.5707 | 0.5709 | 2940000.0 |
| 2004-06-29 11:50:00 | AAPL | Stock | 0.5709 | 0.5714 | 0.5707 | 0.5714 | 1539720.0 |
| 2004-06-29 11:55:00 | AAPL | Stock | 0.5714 | 0.5714 | 0.5705 | 0.5705 | 5415536.0 |
| 2004-06-29 12:00:00 | AAPL | Stock | 0.5707 | 0.5723 | 0.5698 | 0.572 | 9300536.0 |
| 2004-06-29 12:05:00 | AAPL | Stock | 0.572 | 0.5721 | 0.5709 | 0.5713 | 1526112.0 |
| 2004-06-29 12:10:00 | AAPL | Stock | 0.5713 | 0.5716 | 0.5707 | 0.5713 | 2441600.0 |
| 2004-06-29 12:15:00 | AAPL | Stock | 0.5714 | 0.572 | 0.5713 | 0.572 | 3395952.0 |
| 2004-06-29 12:20:00 | AAPL | Stock | 0.5718 | 0.5723 | 0.5713 | 0.5714 | 1397816.0 |
| 2004-06-29 12:25:00 | AAPL | Stock | 0.5714 | 0.5723 | 0.5713 | 0.5713 | 2624496.0 |
| 2004-06-29 12:30:00 | AAPL | Stock | 0.5716 | 0.5718 | 0.5711 | 0.5714 | 2857624.0 |
| 2004-06-29 12:35:00 | AAPL | Stock | 0.5713 | 0.5716 | 0.5709 | 0.5711 | 6531056.0 |
| 2004-06-29 12:40:00 | AAPL | Stock | 0.5711 | 0.5714 | 0.5696 | 0.5709 | 5586840.0 |
| 2004-06-29 12:45:00 | AAPL | Stock | 0.5707 | 0.5723 | 0.5705 | 0.5718 | 2123912.0 |
| 2004-06-29 12:50:00 | AAPL | Stock | 0.572 | 0.5723 | 0.5714 | 0.5716 | 1905456.0 |
> showing 50 of 184,978 rows — these rows as CSV