PREVIEW / stock_5min / 2006-10-02
file: by_date/stock_5min/2006/2006-10-02.parquet size: 3.1 MB rows: 229,520 symbols: 2,384
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 |
|---|---|---|---|---|---|---|---|
| 2006-10-02 04:50:00 | AAPL | Stock | 2.7639 | 2.7679 | 2.7639 | 2.7679 | 10500.0 |
| 2006-10-02 05:20:00 | AAPL | Stock | 2.75 | 2.75 | 2.75 | 2.75 | 5600.0 |
| 2006-10-02 05:25:00 | AAPL | Stock | 2.7511 | 2.7511 | 2.7271 | 2.7271 | 14000.0 |
| 2006-10-02 05:40:00 | AAPL | Stock | 2.7271 | 2.7271 | 2.7271 | 2.7271 | 2800.0 |
| 2006-10-02 05:45:00 | AAPL | Stock | 2.7271 | 2.7271 | 2.7271 | 2.7271 | 2800.0 |
| 2006-10-02 06:00:00 | AAPL | Stock | 2.6979 | 2.6979 | 2.6975 | 2.6979 | 105784.0 |
| 2006-10-02 06:05:00 | AAPL | Stock | 2.6961 | 2.6961 | 2.6961 | 2.6961 | 8400.0 |
| 2006-10-02 06:40:00 | AAPL | Stock | 2.6979 | 2.6979 | 2.6979 | 2.6979 | 56000.0 |
| 2006-10-02 07:05:00 | AAPL | Stock | 2.6982 | 2.6982 | 2.6946 | 2.6946 | 99316.0 |
| 2006-10-02 07:10:00 | AAPL | Stock | 2.685 | 2.685 | 2.6786 | 2.6786 | 386400.0 |
| 2006-10-02 07:25:00 | AAPL | Stock | 2.6839 | 2.6839 | 2.6821 | 2.6821 | 247408.0 |
| 2006-10-02 07:50:00 | AAPL | Stock | 2.6893 | 2.6893 | 2.6843 | 2.6843 | 36400.0 |
| 2006-10-02 07:55:00 | AAPL | Stock | 2.6857 | 2.6857 | 2.6857 | 2.6857 | 5600.0 |
| 2006-10-02 08:00:00 | AAPL | Stock | 2.6839 | 2.6996 | 2.6839 | 2.6911 | 1791440.0 |
| 2006-10-02 08:05:00 | AAPL | Stock | 2.6932 | 2.6964 | 2.6914 | 2.6946 | 338604.0 |
| 2006-10-02 08:10:00 | AAPL | Stock | 2.6946 | 2.6964 | 2.6911 | 2.6911 | 489860.0 |
| 2006-10-02 08:15:00 | AAPL | Stock | 2.6918 | 2.6918 | 2.6875 | 2.6896 | 735420.0 |
| 2006-10-02 08:20:00 | AAPL | Stock | 2.6896 | 2.6946 | 2.6893 | 2.6946 | 498960.0 |
| 2006-10-02 08:25:00 | AAPL | Stock | 2.6929 | 2.6957 | 2.6929 | 2.6943 | 386120.0 |
| 2006-10-02 08:30:00 | AAPL | Stock | 2.6929 | 2.6943 | 2.6929 | 2.6929 | 655872.0 |
| 2006-10-02 08:35:00 | AAPL | Stock | 2.6932 | 2.6964 | 2.6929 | 2.695 | 741132.0 |
| 2006-10-02 08:40:00 | AAPL | Stock | 2.6964 | 2.6964 | 2.6936 | 2.6961 | 490252.0 |
| 2006-10-02 08:45:00 | AAPL | Stock | 2.6957 | 2.6957 | 2.6911 | 2.6914 | 232120.0 |
| 2006-10-02 08:50:00 | AAPL | Stock | 2.6929 | 2.6929 | 2.6875 | 2.69 | 746060.0 |
| 2006-10-02 08:55:00 | AAPL | Stock | 2.6896 | 2.6925 | 2.6893 | 2.6911 | 138880.0 |
| 2006-10-02 09:00:00 | AAPL | Stock | 2.6893 | 2.6911 | 2.6864 | 2.6864 | 519540.0 |
| 2006-10-02 09:05:00 | AAPL | Stock | 2.6864 | 2.6893 | 2.6861 | 2.6893 | 314160.0 |
| 2006-10-02 09:10:00 | AAPL | Stock | 2.6871 | 2.6893 | 2.6832 | 2.6832 | 810180.0 |
| 2006-10-02 09:15:00 | AAPL | Stock | 2.6832 | 2.6839 | 2.6821 | 2.6821 | 203672.0 |
| 2006-10-02 09:20:00 | AAPL | Stock | 2.6821 | 2.6914 | 2.6814 | 2.6875 | 479836.0 |
| 2006-10-02 09:25:00 | AAPL | Stock | 2.6875 | 2.6929 | 2.6789 | 2.6821 | 1251096.0 |
| 2006-10-02 09:30:00 | AAPL | Stock | 2.6821 | 2.6914 | 2.6704 | 2.6714 | 42687876.0 |
| 2006-10-02 09:35:00 | AAPL | Stock | 2.6714 | 2.6725 | 2.6618 | 2.6711 | 24881836.0 |
| 2006-10-02 09:40:00 | AAPL | Stock | 2.6714 | 2.6789 | 2.6661 | 2.6761 | 16467416.0 |
| 2006-10-02 09:45:00 | AAPL | Stock | 2.6761 | 2.6768 | 2.6668 | 2.669 | 13153028.0 |
| 2006-10-02 09:50:00 | AAPL | Stock | 2.6693 | 2.67 | 2.6629 | 2.6643 | 19358864.0 |
| 2006-10-02 09:55:00 | AAPL | Stock | 2.6643 | 2.6657 | 2.6536 | 2.6632 | 24905188.0 |
| 2006-10-02 10:00:00 | AAPL | Stock | 2.6632 | 2.6679 | 2.6564 | 2.6664 | 15047312.0 |
| 2006-10-02 10:05:00 | AAPL | Stock | 2.6668 | 2.6693 | 2.6607 | 2.6618 | 14042084.0 |
| 2006-10-02 10:10:00 | AAPL | Stock | 2.6618 | 2.6686 | 2.6607 | 2.6664 | 10268972.0 |
| 2006-10-02 10:15:00 | AAPL | Stock | 2.6667 | 2.6679 | 2.6607 | 2.6661 | 11448444.0 |
| 2006-10-02 10:20:00 | AAPL | Stock | 2.6664 | 2.6679 | 2.6614 | 2.6621 | 9580116.0 |
| 2006-10-02 10:25:00 | AAPL | Stock | 2.6621 | 2.6668 | 2.6614 | 2.6664 | 7577052.0 |
| 2006-10-02 10:30:00 | AAPL | Stock | 2.6668 | 2.6693 | 2.665 | 2.6682 | 10783248.0 |
| 2006-10-02 10:35:00 | AAPL | Stock | 2.6682 | 2.6714 | 2.6679 | 2.67 | 14279944.0 |
| 2006-10-02 10:40:00 | AAPL | Stock | 2.67 | 2.6711 | 2.6646 | 2.6657 | 8328460.0 |
| 2006-10-02 10:45:00 | AAPL | Stock | 2.6657 | 2.6682 | 2.6643 | 2.665 | 5211668.0 |
| 2006-10-02 10:50:00 | AAPL | Stock | 2.6654 | 2.6679 | 2.6629 | 2.6664 | 7032760.0 |
| 2006-10-02 10:55:00 | AAPL | Stock | 2.6679 | 2.6696 | 2.6654 | 2.6664 | 6688500.0 |
| 2006-10-02 11:00:00 | AAPL | Stock | 2.6664 | 2.6704 | 2.6661 | 2.67 | 5551784.0 |
> showing 50 of 229,520 rows — these rows as CSV