PREVIEW / stock_5min / 2004-09-21
file: by_date/stock_5min/2004/2004-09-21.parquet size: 2.4 MB rows: 175,134 symbols: 1,832
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-21 08:45:00 | AAPL | Stock | 0.6741 | 0.6741 | 0.6741 | 0.6741 | 22400.0 |
| 2004-09-21 08:50:00 | AAPL | Stock | 0.6741 | 0.6741 | 0.6741 | 0.6741 | 24080.0 |
| 2004-09-21 09:15:00 | AAPL | Stock | 0.6757 | 0.6759 | 0.6757 | 0.6759 | 72688.0 |
| 2004-09-21 09:20:00 | AAPL | Stock | 0.6757 | 0.6757 | 0.6757 | 0.6757 | 140840.0 |
| 2004-09-21 09:25:00 | AAPL | Stock | 0.6757 | 0.6757 | 0.6752 | 0.6755 | 413448.0 |
| 2004-09-21 09:30:00 | AAPL | Stock | 0.6732 | 0.6751 | 0.6705 | 0.6711 | 8366120.0 |
| 2004-09-21 09:35:00 | AAPL | Stock | 0.6711 | 0.6741 | 0.6705 | 0.6729 | 5255488.0 |
| 2004-09-21 09:40:00 | AAPL | Stock | 0.673 | 0.6766 | 0.6723 | 0.6757 | 3859968.0 |
| 2004-09-21 09:45:00 | AAPL | Stock | 0.6755 | 0.6795 | 0.675 | 0.6775 | 8831256.0 |
| 2004-09-21 09:50:00 | AAPL | Stock | 0.6775 | 0.6777 | 0.6763 | 0.6766 | 2941120.0 |
| 2004-09-21 09:55:00 | AAPL | Stock | 0.6768 | 0.677 | 0.6741 | 0.6746 | 5196408.0 |
| 2004-09-21 10:00:00 | AAPL | Stock | 0.6745 | 0.6746 | 0.6695 | 0.6696 | 10837288.0 |
| 2004-09-21 10:05:00 | AAPL | Stock | 0.6695 | 0.6746 | 0.6689 | 0.6741 | 4324936.0 |
| 2004-09-21 10:10:00 | AAPL | Stock | 0.6743 | 0.6743 | 0.6714 | 0.6714 | 1866760.0 |
| 2004-09-21 10:15:00 | AAPL | Stock | 0.6714 | 0.6748 | 0.6714 | 0.6741 | 2102464.0 |
| 2004-09-21 10:20:00 | AAPL | Stock | 0.6741 | 0.6757 | 0.6725 | 0.6729 | 7958104.0 |
| 2004-09-21 10:25:00 | AAPL | Stock | 0.6746 | 0.677 | 0.6741 | 0.6755 | 2514008.0 |
| 2004-09-21 10:30:00 | AAPL | Stock | 0.6759 | 0.6763 | 0.6734 | 0.6763 | 3577616.0 |
| 2004-09-21 10:35:00 | AAPL | Stock | 0.6763 | 0.6779 | 0.6762 | 0.6779 | 2474752.0 |
| 2004-09-21 10:40:00 | AAPL | Stock | 0.6779 | 0.678 | 0.6764 | 0.677 | 1471176.0 |
| 2004-09-21 10:45:00 | AAPL | Stock | 0.6766 | 0.6771 | 0.6761 | 0.677 | 1322160.0 |
| 2004-09-21 10:50:00 | AAPL | Stock | 0.6768 | 0.6773 | 0.6764 | 0.6773 | 1192968.0 |
| 2004-09-21 10:55:00 | AAPL | Stock | 0.6773 | 0.6786 | 0.6773 | 0.6782 | 2843960.0 |
| 2004-09-21 11:00:00 | AAPL | Stock | 0.6779 | 0.6809 | 0.6775 | 0.6798 | 7405552.0 |
| 2004-09-21 11:05:00 | AAPL | Stock | 0.6796 | 0.6823 | 0.6796 | 0.6807 | 7814800.0 |
| 2004-09-21 11:10:00 | AAPL | Stock | 0.6807 | 0.6807 | 0.6793 | 0.6795 | 2822400.0 |
| 2004-09-21 11:15:00 | AAPL | Stock | 0.6798 | 0.6804 | 0.6788 | 0.6798 | 2562392.0 |
| 2004-09-21 11:20:00 | AAPL | Stock | 0.68 | 0.68 | 0.6782 | 0.6784 | 1357328.0 |
| 2004-09-21 11:25:00 | AAPL | Stock | 0.6784 | 0.6789 | 0.6773 | 0.6782 | 1488872.0 |
| 2004-09-21 11:30:00 | AAPL | Stock | 0.6782 | 0.6784 | 0.6777 | 0.678 | 906304.0 |
| 2004-09-21 11:35:00 | AAPL | Stock | 0.6784 | 0.6796 | 0.6777 | 0.6796 | 2549456.0 |
| 2004-09-21 11:40:00 | AAPL | Stock | 0.6796 | 0.6796 | 0.6782 | 0.6791 | 1361640.0 |
| 2004-09-21 11:45:00 | AAPL | Stock | 0.6791 | 0.6805 | 0.6791 | 0.6805 | 2262456.0 |
| 2004-09-21 11:50:00 | AAPL | Stock | 0.6807 | 0.6809 | 0.6804 | 0.6805 | 2337776.0 |
| 2004-09-21 11:55:00 | AAPL | Stock | 0.6805 | 0.6805 | 0.6795 | 0.68 | 1443400.0 |
| 2004-09-21 12:00:00 | AAPL | Stock | 0.6802 | 0.6805 | 0.6798 | 0.68 | 1500968.0 |
| 2004-09-21 12:05:00 | AAPL | Stock | 0.6802 | 0.6802 | 0.6795 | 0.6802 | 944496.0 |
| 2004-09-21 12:10:00 | AAPL | Stock | 0.6802 | 0.6804 | 0.6793 | 0.6793 | 2081072.0 |
| 2004-09-21 12:15:00 | AAPL | Stock | 0.6795 | 0.6802 | 0.6788 | 0.6789 | 1002960.0 |
| 2004-09-21 12:20:00 | AAPL | Stock | 0.6788 | 0.6789 | 0.6786 | 0.6788 | 696528.0 |
| 2004-09-21 12:25:00 | AAPL | Stock | 0.6789 | 0.6789 | 0.6782 | 0.6786 | 1144304.0 |
| 2004-09-21 12:30:00 | AAPL | Stock | 0.6786 | 0.6789 | 0.678 | 0.6789 | 929880.0 |
| 2004-09-21 12:35:00 | AAPL | Stock | 0.6789 | 0.6789 | 0.6777 | 0.6777 | 1038296.0 |
| 2004-09-21 12:40:00 | AAPL | Stock | 0.6775 | 0.678 | 0.6775 | 0.6779 | 979440.0 |
| 2004-09-21 12:45:00 | AAPL | Stock | 0.6775 | 0.6779 | 0.677 | 0.6773 | 750792.0 |
| 2004-09-21 12:50:00 | AAPL | Stock | 0.6775 | 0.6788 | 0.6775 | 0.6784 | 2041088.0 |
| 2004-09-21 12:55:00 | AAPL | Stock | 0.6782 | 0.6791 | 0.6782 | 0.6784 | 1825040.0 |
| 2004-09-21 13:00:00 | AAPL | Stock | 0.6786 | 0.6789 | 0.6786 | 0.6786 | 1657264.0 |
| 2004-09-21 13:05:00 | AAPL | Stock | 0.6788 | 0.6791 | 0.6786 | 0.6788 | 705936.0 |
| 2004-09-21 13:10:00 | AAPL | Stock | 0.6789 | 0.6789 | 0.6786 | 0.6786 | 377552.0 |
> showing 50 of 175,134 rows — these rows as CSV