PREVIEW / stock_5min / 2006-10-24
file: by_date/stock_5min/2006/2006-10-24.parquet size: 3.2 MB rows: 231,646 symbols: 2,396
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-24 08:00:00 | AAPL | Stock | 2.9054 | 2.9071 | 2.9054 | 2.9054 | 76216.0 |
| 2006-10-24 08:05:00 | AAPL | Stock | 2.9036 | 2.9036 | 2.9018 | 2.9036 | 97216.0 |
| 2006-10-24 08:15:00 | AAPL | Stock | 2.9046 | 2.9061 | 2.9046 | 2.9054 | 25200.0 |
| 2006-10-24 08:20:00 | AAPL | Stock | 2.9054 | 2.9061 | 2.9036 | 2.9061 | 63000.0 |
| 2006-10-24 08:25:00 | AAPL | Stock | 2.9064 | 2.9064 | 2.9054 | 2.9054 | 58800.0 |
| 2006-10-24 08:30:00 | AAPL | Stock | 2.9054 | 2.9064 | 2.9043 | 2.9043 | 82600.0 |
| 2006-10-24 08:35:00 | AAPL | Stock | 2.9039 | 2.9039 | 2.9036 | 2.9039 | 322280.0 |
| 2006-10-24 08:40:00 | AAPL | Stock | 2.9018 | 2.9029 | 2.9018 | 2.9021 | 25760.0 |
| 2006-10-24 08:45:00 | AAPL | Stock | 2.9021 | 2.9036 | 2.9018 | 2.9036 | 96992.0 |
| 2006-10-24 08:50:00 | AAPL | Stock | 2.9036 | 2.9039 | 2.9036 | 2.9036 | 61600.0 |
| 2006-10-24 08:55:00 | AAPL | Stock | 2.9036 | 2.9043 | 2.9029 | 2.9043 | 36400.0 |
| 2006-10-24 09:00:00 | AAPL | Stock | 2.9029 | 2.9036 | 2.9029 | 2.9036 | 5628.0 |
| 2006-10-24 09:05:00 | AAPL | Stock | 2.9036 | 2.9057 | 2.9029 | 2.9046 | 178164.0 |
| 2006-10-24 09:10:00 | AAPL | Stock | 2.9054 | 2.9068 | 2.9054 | 2.9068 | 33600.0 |
| 2006-10-24 09:15:00 | AAPL | Stock | 2.9068 | 2.9071 | 2.9068 | 2.9071 | 98000.0 |
| 2006-10-24 09:20:00 | AAPL | Stock | 2.9068 | 2.9071 | 2.9068 | 2.9071 | 135660.0 |
| 2006-10-24 09:25:00 | AAPL | Stock | 2.9075 | 2.9104 | 2.9004 | 2.9061 | 211260.0 |
| 2006-10-24 09:30:00 | AAPL | Stock | 2.9004 | 2.9107 | 2.8936 | 2.9018 | 12460728.0 |
| 2006-10-24 09:35:00 | AAPL | Stock | 2.9018 | 2.9171 | 2.9004 | 2.9129 | 13246296.0 |
| 2006-10-24 09:40:00 | AAPL | Stock | 2.9121 | 2.9143 | 2.9079 | 2.9096 | 10765692.0 |
| 2006-10-24 09:45:00 | AAPL | Stock | 2.91 | 2.9125 | 2.9036 | 2.9114 | 9325960.0 |
| 2006-10-24 09:50:00 | AAPL | Stock | 2.9111 | 2.9161 | 2.9043 | 2.9118 | 15429988.0 |
| 2006-10-24 09:55:00 | AAPL | Stock | 2.9118 | 2.9118 | 2.9021 | 2.9043 | 7245448.0 |
| 2006-10-24 10:00:00 | AAPL | Stock | 2.9021 | 2.9054 | 2.8936 | 2.8971 | 9525208.0 |
| 2006-10-24 10:05:00 | AAPL | Stock | 2.8972 | 2.9007 | 2.8889 | 2.8902 | 10861536.0 |
| 2006-10-24 10:10:00 | AAPL | Stock | 2.8907 | 2.8911 | 2.8857 | 2.89 | 10187436.0 |
| 2006-10-24 10:15:00 | AAPL | Stock | 2.89 | 2.8929 | 2.8875 | 2.89 | 7131012.0 |
| 2006-10-24 10:20:00 | AAPL | Stock | 2.89 | 2.8904 | 2.8821 | 2.8871 | 7642040.0 |
| 2006-10-24 10:25:00 | AAPL | Stock | 2.8868 | 2.8989 | 2.8839 | 2.8954 | 11475016.0 |
| 2006-10-24 10:30:00 | AAPL | Stock | 2.8957 | 2.8957 | 2.8868 | 2.89 | 7088508.0 |
| 2006-10-24 10:35:00 | AAPL | Stock | 2.8904 | 2.8968 | 2.8875 | 2.8961 | 5417972.0 |
| 2006-10-24 10:40:00 | AAPL | Stock | 2.8954 | 2.8989 | 2.8818 | 2.8839 | 10242904.0 |
| 2006-10-24 10:45:00 | AAPL | Stock | 2.8839 | 2.8868 | 2.8796 | 2.8846 | 8707272.0 |
| 2006-10-24 10:50:00 | AAPL | Stock | 2.8843 | 2.8861 | 2.8786 | 2.88 | 6337940.0 |
| 2006-10-24 10:55:00 | AAPL | Stock | 2.88 | 2.8879 | 2.8746 | 2.8864 | 10861032.0 |
| 2006-10-24 11:00:00 | AAPL | Stock | 2.8868 | 2.8929 | 2.8839 | 2.8843 | 16895200.0 |
| 2006-10-24 11:05:00 | AAPL | Stock | 2.884 | 2.8875 | 2.8836 | 2.8839 | 7030044.0 |
| 2006-10-24 11:10:00 | AAPL | Stock | 2.8839 | 2.8871 | 2.8836 | 2.8864 | 5736556.0 |
| 2006-10-24 11:15:00 | AAPL | Stock | 2.8864 | 2.8875 | 2.8839 | 2.8861 | 3072720.0 |
| 2006-10-24 11:20:00 | AAPL | Stock | 2.8861 | 2.8911 | 2.8854 | 2.8893 | 4419716.0 |
| 2006-10-24 11:25:00 | AAPL | Stock | 2.8893 | 2.8929 | 2.8893 | 2.8914 | 5960724.0 |
| 2006-10-24 11:30:00 | AAPL | Stock | 2.8918 | 2.8954 | 2.8907 | 2.8925 | 7662564.0 |
| 2006-10-24 11:35:00 | AAPL | Stock | 2.8925 | 2.8925 | 2.8893 | 2.8893 | 4563804.0 |
| 2006-10-24 11:40:00 | AAPL | Stock | 2.8896 | 2.8914 | 2.8893 | 2.8914 | 2258424.0 |
| 2006-10-24 11:45:00 | AAPL | Stock | 2.8914 | 2.8932 | 2.8882 | 2.8882 | 3212972.0 |
| 2006-10-24 11:50:00 | AAPL | Stock | 2.8882 | 2.8936 | 2.8879 | 2.89 | 6310276.0 |
| 2006-10-24 11:55:00 | AAPL | Stock | 2.89 | 2.8921 | 2.8875 | 2.8882 | 3189256.0 |
| 2006-10-24 12:00:00 | AAPL | Stock | 2.8882 | 2.8914 | 2.8857 | 2.8904 | 5878152.0 |
| 2006-10-24 12:05:00 | AAPL | Stock | 2.8907 | 2.8925 | 2.8889 | 2.8889 | 2622312.0 |
| 2006-10-24 12:10:00 | AAPL | Stock | 2.8886 | 2.8907 | 2.8875 | 2.89 | 1752212.0 |
> showing 50 of 231,646 rows — these rows as CSV