PREVIEW / stock_5min / 2005-09-15
file: by_date/stock_5min/2005/2005-09-15.parquet size: 2.7 MB rows: 202,421 symbols: 2,072
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 |
|---|---|---|---|---|---|---|---|
| 2005-09-15 08:15:00 | AAPL | Stock | 1.7789 | 1.7789 | 1.7779 | 1.7779 | 11200.0 |
| 2005-09-15 08:20:00 | AAPL | Stock | 1.7793 | 1.7793 | 1.7789 | 1.7789 | 16800.0 |
| 2005-09-15 08:25:00 | AAPL | Stock | 1.7854 | 1.7875 | 1.7854 | 1.7857 | 71120.0 |
| 2005-09-15 08:30:00 | AAPL | Stock | 1.7839 | 1.79 | 1.7839 | 1.7857 | 45220.0 |
| 2005-09-15 08:35:00 | AAPL | Stock | 1.7875 | 1.7893 | 1.7857 | 1.7889 | 67620.0 |
| 2005-09-15 08:40:00 | AAPL | Stock | 1.7886 | 1.7893 | 1.7886 | 1.7893 | 67200.0 |
| 2005-09-15 08:45:00 | AAPL | Stock | 1.7893 | 1.7918 | 1.7893 | 1.7907 | 94976.0 |
| 2005-09-15 08:50:00 | AAPL | Stock | 1.7914 | 1.7943 | 1.7896 | 1.7896 | 404880.0 |
| 2005-09-15 08:55:00 | AAPL | Stock | 1.7911 | 1.7914 | 1.7911 | 1.7914 | 16800.0 |
| 2005-09-15 09:00:00 | AAPL | Stock | 1.7914 | 1.7914 | 1.7879 | 1.7879 | 134624.0 |
| 2005-09-15 09:05:00 | AAPL | Stock | 1.7893 | 1.7893 | 1.7846 | 1.7889 | 258216.0 |
| 2005-09-15 09:10:00 | AAPL | Stock | 1.7875 | 1.7893 | 1.7857 | 1.7857 | 213500.0 |
| 2005-09-15 09:15:00 | AAPL | Stock | 1.7857 | 1.7857 | 1.7857 | 1.7857 | 23240.0 |
| 2005-09-15 09:20:00 | AAPL | Stock | 1.7857 | 1.7861 | 1.7857 | 1.7857 | 138600.0 |
| 2005-09-15 09:25:00 | AAPL | Stock | 1.7854 | 1.7871 | 1.7821 | 1.7821 | 918792.0 |
| 2005-09-15 09:30:00 | AAPL | Stock | 1.7857 | 1.7896 | 1.7825 | 1.7843 | 15129772.0 |
| 2005-09-15 09:35:00 | AAPL | Stock | 1.7843 | 1.7921 | 1.78 | 1.7829 | 14359408.0 |
| 2005-09-15 09:40:00 | AAPL | Stock | 1.7832 | 1.7907 | 1.7814 | 1.7857 | 9420432.0 |
| 2005-09-15 09:45:00 | AAPL | Stock | 1.7857 | 1.7875 | 1.7829 | 1.7829 | 5904724.0 |
| 2005-09-15 09:50:00 | AAPL | Stock | 1.7825 | 1.7825 | 1.7768 | 1.7784 | 12023872.0 |
| 2005-09-15 09:55:00 | AAPL | Stock | 1.7782 | 1.7786 | 1.7679 | 1.7729 | 12479656.0 |
| 2005-09-15 10:00:00 | AAPL | Stock | 1.7729 | 1.7793 | 1.7718 | 1.7757 | 8693188.0 |
| 2005-09-15 10:05:00 | AAPL | Stock | 1.7757 | 1.7768 | 1.7618 | 1.7682 | 11732616.0 |
| 2005-09-15 10:10:00 | AAPL | Stock | 1.7682 | 1.77 | 1.7661 | 1.7696 | 5982480.0 |
| 2005-09-15 10:15:00 | AAPL | Stock | 1.7696 | 1.7696 | 1.7657 | 1.7671 | 6297816.0 |
| 2005-09-15 10:20:00 | AAPL | Stock | 1.7671 | 1.7721 | 1.7661 | 1.7707 | 7102004.0 |
| 2005-09-15 10:25:00 | AAPL | Stock | 1.7708 | 1.7714 | 1.7661 | 1.7668 | 8737092.0 |
| 2005-09-15 10:30:00 | AAPL | Stock | 1.7668 | 1.774 | 1.7664 | 1.7735 | 9401560.0 |
| 2005-09-15 10:35:00 | AAPL | Stock | 1.7729 | 1.7746 | 1.7711 | 1.7732 | 6798232.0 |
| 2005-09-15 10:40:00 | AAPL | Stock | 1.7736 | 1.7757 | 1.77 | 1.7718 | 14308000.0 |
| 2005-09-15 10:45:00 | AAPL | Stock | 1.7721 | 1.7743 | 1.7707 | 1.7721 | 6874336.0 |
| 2005-09-15 10:50:00 | AAPL | Stock | 1.7721 | 1.7786 | 1.7721 | 1.7782 | 5561836.0 |
| 2005-09-15 10:55:00 | AAPL | Stock | 1.7779 | 1.7804 | 1.7764 | 1.7789 | 4199748.0 |
| 2005-09-15 11:00:00 | AAPL | Stock | 1.7786 | 1.7839 | 1.7786 | 1.7821 | 5172496.0 |
| 2005-09-15 11:05:00 | AAPL | Stock | 1.7821 | 1.7825 | 1.78 | 1.7804 | 2610552.0 |
| 2005-09-15 11:10:00 | AAPL | Stock | 1.78 | 1.7804 | 1.7764 | 1.7782 | 3470040.0 |
| 2005-09-15 11:15:00 | AAPL | Stock | 1.7786 | 1.7804 | 1.7764 | 1.78 | 2292864.0 |
| 2005-09-15 11:20:00 | AAPL | Stock | 1.78 | 1.7832 | 1.7789 | 1.7804 | 3664976.0 |
| 2005-09-15 11:25:00 | AAPL | Stock | 1.78 | 1.7818 | 1.7793 | 1.7814 | 1651636.0 |
| 2005-09-15 11:30:00 | AAPL | Stock | 1.7814 | 1.785 | 1.7814 | 1.7832 | 4146128.0 |
| 2005-09-15 11:35:00 | AAPL | Stock | 1.7832 | 1.7839 | 1.7818 | 1.7821 | 2794596.0 |
| 2005-09-15 11:40:00 | AAPL | Stock | 1.7821 | 1.7889 | 1.7818 | 1.7886 | 4696832.0 |
| 2005-09-15 11:45:00 | AAPL | Stock | 1.7882 | 1.7893 | 1.7832 | 1.7839 | 3123064.0 |
| 2005-09-15 11:50:00 | AAPL | Stock | 1.7839 | 1.7893 | 1.7832 | 1.7846 | 1728664.0 |
| 2005-09-15 11:55:00 | AAPL | Stock | 1.7846 | 1.7846 | 1.7779 | 1.7786 | 3017784.0 |
| 2005-09-15 12:00:00 | AAPL | Stock | 1.7786 | 1.7793 | 1.7736 | 1.7779 | 5217324.0 |
| 2005-09-15 12:05:00 | AAPL | Stock | 1.7779 | 1.7786 | 1.77 | 1.7721 | 7045248.0 |
| 2005-09-15 12:10:00 | AAPL | Stock | 1.7721 | 1.775 | 1.77 | 1.7743 | 4889892.0 |
| 2005-09-15 12:15:00 | AAPL | Stock | 1.7746 | 1.7768 | 1.7714 | 1.7718 | 3137148.0 |
| 2005-09-15 12:20:00 | AAPL | Stock | 1.7718 | 1.7736 | 1.77 | 1.7732 | 2614052.0 |
> showing 50 of 202,421 rows — these rows as CSV