PREVIEW / stock_5min / 2004-08-25
file: by_date/stock_5min/2004/2004-08-25.parquet size: 2.4 MB rows: 173,807 symbols: 1,818
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:00:00 | AAPL | Stock | 0.5696 | 0.5696 | 0.5696 | 0.5696 | 11200.0 |
| 2004-08-25 09:00: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:20:00 | AAPL | Stock | 0.5695 | 0.5696 | 0.5695 | 0.5696 | 78400.0 |
| 2004-08-25 09:25:00 | AAPL | Stock | 0.5704 | 0.5709 | 0.5693 | 0.5705 | 771624.0 |
| 2004-08-25 09:30:00 | AAPL | Stock | 0.5698 | 0.5714 | 0.5691 | 0.5709 | 11118688.0 |
| 2004-08-25 09:35:00 | AAPL | Stock | 0.5709 | 0.5713 | 0.568 | 0.57 | 6071240.0 |
| 2004-08-25 09:40:00 | AAPL | Stock | 0.57 | 0.5702 | 0.567 | 0.5682 | 4059832.0 |
| 2004-08-25 09:45:00 | AAPL | Stock | 0.568 | 0.5688 | 0.5673 | 0.5677 | 4285680.0 |
| 2004-08-25 09:50:00 | AAPL | Stock | 0.5679 | 0.5704 | 0.5679 | 0.5695 | 4401208.0 |
| 2004-08-25 09:55:00 | AAPL | Stock | 0.5695 | 0.57 | 0.5673 | 0.5682 | 5866224.0 |
| 2004-08-25 10:00:00 | AAPL | Stock | 0.5684 | 0.5691 | 0.5671 | 0.5675 | 2888536.0 |
| 2004-08-25 10:05:00 | AAPL | Stock | 0.5671 | 0.5688 | 0.567 | 0.5673 | 2721040.0 |
| 2004-08-25 10:10:00 | AAPL | Stock | 0.5675 | 0.5675 | 0.5666 | 0.5675 | 2698528.0 |
| 2004-08-25 10:15:00 | AAPL | Stock | 0.5677 | 0.5698 | 0.5675 | 0.5689 | 1637104.0 |
| 2004-08-25 10:20:00 | AAPL | Stock | 0.5686 | 0.5705 | 0.5686 | 0.5696 | 8040200.0 |
| 2004-08-25 10:25:00 | AAPL | Stock | 0.5698 | 0.5739 | 0.5696 | 0.573 | 19186216.0 |
| 2004-08-25 10:30:00 | AAPL | Stock | 0.5732 | 0.5732 | 0.5711 | 0.5711 | 5755344.0 |
| 2004-08-25 10:35:00 | AAPL | Stock | 0.5711 | 0.5721 | 0.5705 | 0.5714 | 4587352.0 |
| 2004-08-25 10:40:00 | AAPL | Stock | 0.5714 | 0.5727 | 0.5714 | 0.5723 | 10441368.0 |
| 2004-08-25 10:45:00 | AAPL | Stock | 0.5721 | 0.5721 | 0.5711 | 0.5714 | 2151016.0 |
| 2004-08-25 10:50:00 | AAPL | Stock | 0.5716 | 0.5716 | 0.5702 | 0.5704 | 8767864.0 |
| 2004-08-25 10:55:00 | AAPL | Stock | 0.5703 | 0.5721 | 0.5702 | 0.5716 | 5780096.0 |
| 2004-08-25 11:00:00 | AAPL | Stock | 0.5714 | 0.5714 | 0.5704 | 0.5714 | 2465624.0 |
| 2004-08-25 11:05:00 | AAPL | Stock | 0.5716 | 0.5721 | 0.5711 | 0.5711 | 3050488.0 |
| 2004-08-25 11:10:00 | AAPL | Stock | 0.5714 | 0.5718 | 0.5704 | 0.5709 | 3239208.0 |
| 2004-08-25 11:15:00 | AAPL | Stock | 0.5713 | 0.5721 | 0.5711 | 0.5713 | 11966416.0 |
| 2004-08-25 11:20:00 | AAPL | Stock | 0.5714 | 0.572 | 0.5709 | 0.5716 | 3446576.0 |
| 2004-08-25 11:25:00 | AAPL | Stock | 0.5718 | 0.5718 | 0.5704 | 0.5709 | 1511888.0 |
| 2004-08-25 11:30:00 | AAPL | Stock | 0.5711 | 0.5714 | 0.5705 | 0.5709 | 2128616.0 |
| 2004-08-25 11:35:00 | AAPL | Stock | 0.5709 | 0.5725 | 0.5709 | 0.5723 | 3904040.0 |
| 2004-08-25 11:40:00 | AAPL | Stock | 0.5721 | 0.5739 | 0.5721 | 0.5736 | 4622968.0 |
| 2004-08-25 11:45:00 | AAPL | Stock | 0.5736 | 0.5736 | 0.5732 | 0.5734 | 1317064.0 |
| 2004-08-25 11:50:00 | AAPL | Stock | 0.5732 | 0.5741 | 0.573 | 0.5739 | 2243192.0 |
| 2004-08-25 11:55:00 | AAPL | Stock | 0.5741 | 0.5743 | 0.5725 | 0.5729 | 2610832.0 |
| 2004-08-25 12:00:00 | AAPL | Stock | 0.5729 | 0.575 | 0.5725 | 0.575 | 4279296.0 |
| 2004-08-25 12:05:00 | AAPL | Stock | 0.5752 | 0.5771 | 0.5748 | 0.5768 | 7428960.0 |
| 2004-08-25 12:10:00 | AAPL | Stock | 0.577 | 0.5771 | 0.5759 | 0.577 | 4014976.0 |
| 2004-08-25 12:15:00 | AAPL | Stock | 0.5771 | 0.5789 | 0.5771 | 0.5782 | 4809896.0 |
| 2004-08-25 12:20:00 | AAPL | Stock | 0.5782 | 0.5788 | 0.577 | 0.5784 | 3288992.0 |
| 2004-08-25 12:25:00 | AAPL | Stock | 0.5784 | 0.5795 | 0.5766 | 0.5795 | 4167520.0 |
| 2004-08-25 12:30:00 | AAPL | Stock | 0.5793 | 0.5809 | 0.5786 | 0.5807 | 13081376.0 |
| 2004-08-25 12:35:00 | AAPL | Stock | 0.5809 | 0.582 | 0.5793 | 0.5814 | 6665176.0 |
| 2004-08-25 12:40:00 | AAPL | Stock | 0.5816 | 0.5848 | 0.5813 | 0.5834 | 13821752.0 |
| 2004-08-25 12:45:00 | AAPL | Stock | 0.5834 | 0.5838 | 0.5825 | 0.5825 | 6351128.0 |
| 2004-08-25 12:50:00 | AAPL | Stock | 0.5825 | 0.5832 | 0.5809 | 0.5832 | 5907328.0 |
| 2004-08-25 12:55:00 | AAPL | Stock | 0.583 | 0.5836 | 0.5825 | 0.5827 | 3584056.0 |
| 2004-08-25 13:00:00 | AAPL | Stock | 0.5827 | 0.5836 | 0.5807 | 0.5836 | 10484880.0 |
| 2004-08-25 13:05:00 | AAPL | Stock | 0.5836 | 0.5854 | 0.5836 | 0.5854 | 9036496.0 |
| 2004-08-25 13:10:00 | AAPL | Stock | 0.5852 | 0.5852 | 0.5839 | 0.5841 | 3792544.0 |
> showing 50 of 173,807 rows — these rows as CSV