PREVIEW / stock_5min / 2004-09-28
file: by_date/stock_5min/2004/2004-09-28.parquet size: 2.4 MB rows: 177,328 symbols: 1,838
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-09-28 08:00:00 | AAPL | Stock | 0.6701 | 0.6701 | 0.6701 | 0.6701 | 280000.0 |
| 2004-09-28 08:15:00 | AAPL | Stock | 0.667 | 0.667 | 0.667 | 0.667 | 5600.0 |
| 2004-09-28 08:25:00 | AAPL | Stock | 0.6713 | 0.6713 | 0.6713 | 0.6713 | 5600.0 |
| 2004-09-28 08:50:00 | AAPL | Stock | 0.6713 | 0.6713 | 0.6713 | 0.6713 | 5600.0 |
| 2004-09-28 09:25:00 | AAPL | Stock | 0.6702 | 0.6702 | 0.6702 | 0.6702 | 61600.0 |
| 2004-09-28 09:30:00 | AAPL | Stock | 0.6696 | 0.6736 | 0.6688 | 0.6734 | 6672680.0 |
| 2004-09-28 09:35:00 | AAPL | Stock | 0.6736 | 0.6738 | 0.6716 | 0.6718 | 2786112.0 |
| 2004-09-28 09:40:00 | AAPL | Stock | 0.6718 | 0.6727 | 0.6707 | 0.6718 | 2476208.0 |
| 2004-09-28 09:45:00 | AAPL | Stock | 0.6718 | 0.6741 | 0.6714 | 0.6741 | 2757832.0 |
| 2004-09-28 09:50:00 | AAPL | Stock | 0.6743 | 0.6773 | 0.6741 | 0.6757 | 6191360.0 |
| 2004-09-28 09:55:00 | AAPL | Stock | 0.6754 | 0.6768 | 0.6736 | 0.6745 | 2062088.0 |
| 2004-09-28 10:00:00 | AAPL | Stock | 0.6745 | 0.6784 | 0.6734 | 0.6773 | 7015176.0 |
| 2004-09-28 10:05:00 | AAPL | Stock | 0.6773 | 0.6773 | 0.675 | 0.6755 | 5311880.0 |
| 2004-09-28 10:10:00 | AAPL | Stock | 0.6754 | 0.6771 | 0.6746 | 0.677 | 3123960.0 |
| 2004-09-28 10:15:00 | AAPL | Stock | 0.6768 | 0.6798 | 0.6768 | 0.6789 | 9804648.0 |
| 2004-09-28 10:20:00 | AAPL | Stock | 0.6789 | 0.6789 | 0.6777 | 0.6777 | 5250616.0 |
| 2004-09-28 10:25:00 | AAPL | Stock | 0.6779 | 0.6784 | 0.6777 | 0.678 | 9571688.0 |
| 2004-09-28 10:30:00 | AAPL | Stock | 0.678 | 0.6788 | 0.678 | 0.6786 | 4168752.0 |
| 2004-09-28 10:35:00 | AAPL | Stock | 0.6788 | 0.6789 | 0.6786 | 0.6788 | 5990768.0 |
| 2004-09-28 10:40:00 | AAPL | Stock | 0.6782 | 0.6786 | 0.6759 | 0.6779 | 6019160.0 |
| 2004-09-28 10:45:00 | AAPL | Stock | 0.6779 | 0.6782 | 0.6773 | 0.6779 | 3510640.0 |
| 2004-09-28 10:50:00 | AAPL | Stock | 0.6779 | 0.678 | 0.6775 | 0.6777 | 2040696.0 |
| 2004-09-28 10:55:00 | AAPL | Stock | 0.6777 | 0.6784 | 0.6777 | 0.6777 | 3003448.0 |
| 2004-09-28 11:00:00 | AAPL | Stock | 0.6779 | 0.6788 | 0.6775 | 0.6788 | 2483488.0 |
| 2004-09-28 11:05:00 | AAPL | Stock | 0.6788 | 0.6789 | 0.6784 | 0.6788 | 3246320.0 |
| 2004-09-28 11:10:00 | AAPL | Stock | 0.6788 | 0.6795 | 0.6786 | 0.6793 | 3550512.0 |
| 2004-09-28 11:15:00 | AAPL | Stock | 0.6793 | 0.6811 | 0.6791 | 0.6805 | 5330696.0 |
| 2004-09-28 11:20:00 | AAPL | Stock | 0.6805 | 0.6821 | 0.6805 | 0.6821 | 5761616.0 |
| 2004-09-28 11:25:00 | AAPL | Stock | 0.682 | 0.683 | 0.6795 | 0.68 | 12379920.0 |
| 2004-09-28 11:30:00 | AAPL | Stock | 0.68 | 0.6804 | 0.6788 | 0.6791 | 5905928.0 |
| 2004-09-28 11:35:00 | AAPL | Stock | 0.6795 | 0.6807 | 0.6788 | 0.6791 | 5146400.0 |
| 2004-09-28 11:40:00 | AAPL | Stock | 0.6795 | 0.6809 | 0.6791 | 0.6809 | 3813320.0 |
| 2004-09-28 11:45:00 | AAPL | Stock | 0.6809 | 0.6834 | 0.6807 | 0.6829 | 9009000.0 |
| 2004-09-28 11:50:00 | AAPL | Stock | 0.6829 | 0.6838 | 0.6805 | 0.682 | 6808760.0 |
| 2004-09-28 11:55:00 | AAPL | Stock | 0.6821 | 0.6834 | 0.6814 | 0.6814 | 5285952.0 |
| 2004-09-28 12:00:00 | AAPL | Stock | 0.6814 | 0.6818 | 0.6804 | 0.6816 | 4624872.0 |
| 2004-09-28 12:05:00 | AAPL | Stock | 0.6816 | 0.6818 | 0.6796 | 0.6809 | 3172568.0 |
| 2004-09-28 12:10:00 | AAPL | Stock | 0.6809 | 0.6816 | 0.6807 | 0.6814 | 860384.0 |
| 2004-09-28 12:15:00 | AAPL | Stock | 0.6813 | 0.6823 | 0.6811 | 0.6811 | 1585136.0 |
| 2004-09-28 12:20:00 | AAPL | Stock | 0.6811 | 0.6813 | 0.6804 | 0.6804 | 870800.0 |
| 2004-09-28 12:25:00 | AAPL | Stock | 0.6804 | 0.6807 | 0.6804 | 0.6805 | 1560832.0 |
| 2004-09-28 12:30:00 | AAPL | Stock | 0.6807 | 0.6811 | 0.6805 | 0.6811 | 1169840.0 |
| 2004-09-28 12:35:00 | AAPL | Stock | 0.6811 | 0.6813 | 0.6796 | 0.6796 | 1695400.0 |
| 2004-09-28 12:40:00 | AAPL | Stock | 0.6796 | 0.68 | 0.6796 | 0.68 | 1611008.0 |
| 2004-09-28 12:45:00 | AAPL | Stock | 0.68 | 0.68 | 0.6791 | 0.6791 | 4466280.0 |
| 2004-09-28 12:50:00 | AAPL | Stock | 0.6793 | 0.6796 | 0.6791 | 0.6795 | 4373712.0 |
| 2004-09-28 12:55:00 | AAPL | Stock | 0.6795 | 0.6795 | 0.6788 | 0.6789 | 3617544.0 |
| 2004-09-28 13:00:00 | AAPL | Stock | 0.6791 | 0.6795 | 0.6788 | 0.6791 | 3304448.0 |
| 2004-09-28 13:05:00 | AAPL | Stock | 0.6791 | 0.6796 | 0.6791 | 0.6793 | 2085048.0 |
| 2004-09-28 13:10:00 | AAPL | Stock | 0.6793 | 0.6795 | 0.6784 | 0.6786 | 3021200.0 |
> showing 50 of 177,328 rows — these rows as CSV