PREVIEW / stock_5min / 2007-05-14
file: by_date/stock_5min/2007/2007-05-14.parquet size: 3.8 MB rows: 283,525 symbols: 2,759
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 |
|---|---|---|---|---|---|---|---|
| 2007-05-14 09:30:00 | AAPL | Stock | 3.915 | 3.9286 | 3.8429 | 3.9268 | 24608248.0 |
| 2007-05-14 09:35:00 | AAPL | Stock | 3.9264 | 3.9282 | 3.9107 | 3.9207 | 16646308.0 |
| 2007-05-14 09:40:00 | AAPL | Stock | 3.9207 | 3.9271 | 3.9171 | 3.92 | 9625616.0 |
| 2007-05-14 09:45:00 | AAPL | Stock | 3.92 | 3.9236 | 3.9136 | 3.9193 | 13300392.0 |
| 2007-05-14 09:50:00 | AAPL | Stock | 3.9189 | 3.9214 | 3.9129 | 3.9162 | 12340440.0 |
| 2007-05-14 09:55:00 | AAPL | Stock | 3.9168 | 3.9175 | 3.9071 | 3.9154 | 14680428.0 |
| 2007-05-14 10:00:00 | AAPL | Stock | 3.9154 | 3.9196 | 3.9089 | 3.9154 | 14080080.0 |
| 2007-05-14 10:05:00 | AAPL | Stock | 3.9154 | 3.9229 | 3.9146 | 3.9179 | 10734108.0 |
| 2007-05-14 10:10:00 | AAPL | Stock | 3.9179 | 3.9204 | 3.8986 | 3.9025 | 14590996.0 |
| 2007-05-14 10:15:00 | AAPL | Stock | 3.9018 | 3.9111 | 3.9004 | 3.9068 | 12635280.0 |
| 2007-05-14 10:20:00 | AAPL | Stock | 3.9068 | 3.9104 | 3.9025 | 3.9104 | 8773520.0 |
| 2007-05-14 10:25:00 | AAPL | Stock | 3.9104 | 3.9125 | 3.9025 | 3.9068 | 9958424.0 |
| 2007-05-14 10:30:00 | AAPL | Stock | 3.9061 | 3.9136 | 3.905 | 3.9114 | 6104392.0 |
| 2007-05-14 10:35:00 | AAPL | Stock | 3.9114 | 3.9129 | 3.9057 | 3.9114 | 7858704.0 |
| 2007-05-14 10:40:00 | AAPL | Stock | 3.9114 | 3.9125 | 3.9025 | 3.9043 | 8236172.0 |
| 2007-05-14 10:45:00 | AAPL | Stock | 3.9039 | 3.9079 | 3.8971 | 3.9078 | 13815144.0 |
| 2007-05-14 10:50:00 | AAPL | Stock | 3.9075 | 3.9111 | 3.9039 | 3.9064 | 6201776.0 |
| 2007-05-14 10:55:00 | AAPL | Stock | 3.9064 | 3.9075 | 3.9025 | 3.9046 | 4919880.0 |
| 2007-05-14 11:00:00 | AAPL | Stock | 3.905 | 3.905 | 3.8982 | 3.8993 | 7090832.0 |
| 2007-05-14 11:05:00 | AAPL | Stock | 3.8993 | 3.9046 | 3.89 | 3.8925 | 14645204.0 |
| 2007-05-14 11:10:00 | AAPL | Stock | 3.8929 | 3.8996 | 3.8921 | 3.8971 | 6645240.0 |
| 2007-05-14 11:15:00 | AAPL | Stock | 3.8968 | 3.8993 | 3.8936 | 3.8986 | 5763940.0 |
| 2007-05-14 11:20:00 | AAPL | Stock | 3.8981 | 3.9021 | 3.8971 | 3.8986 | 6131328.0 |
| 2007-05-14 11:25:00 | AAPL | Stock | 3.8986 | 3.9057 | 3.8964 | 3.8968 | 7346164.0 |
| 2007-05-14 11:30:00 | AAPL | Stock | 3.8968 | 3.8996 | 3.8946 | 3.899 | 5571692.0 |
| 2007-05-14 11:35:00 | AAPL | Stock | 3.8989 | 3.8993 | 3.8936 | 3.8986 | 4330956.0 |
| 2007-05-14 11:40:00 | AAPL | Stock | 3.8989 | 3.8996 | 3.895 | 3.8964 | 3582684.0 |
| 2007-05-14 11:45:00 | AAPL | Stock | 3.8965 | 3.8993 | 3.8964 | 3.8986 | 3685612.0 |
| 2007-05-14 11:50:00 | AAPL | Stock | 3.8982 | 3.8982 | 3.8846 | 3.8871 | 12010096.0 |
| 2007-05-14 11:55:00 | AAPL | Stock | 3.8871 | 3.8875 | 3.8846 | 3.886 | 6059116.0 |
| 2007-05-14 12:00:00 | AAPL | Stock | 3.8857 | 3.8961 | 3.8857 | 3.8934 | 8927828.0 |
| 2007-05-14 12:05:00 | AAPL | Stock | 3.8936 | 3.8954 | 3.8914 | 3.8929 | 4455836.0 |
| 2007-05-14 12:10:00 | AAPL | Stock | 3.8929 | 3.8954 | 3.8879 | 3.8879 | 6112092.0 |
| 2007-05-14 12:15:00 | AAPL | Stock | 3.8879 | 3.8918 | 3.8861 | 3.8911 | 6049148.0 |
| 2007-05-14 12:20:00 | AAPL | Stock | 3.8911 | 3.8921 | 3.8893 | 3.8896 | 4467512.0 |
| 2007-05-14 12:25:00 | AAPL | Stock | 3.8896 | 3.8907 | 3.8875 | 3.8893 | 3802428.0 |
| 2007-05-14 12:30:00 | AAPL | Stock | 3.8893 | 3.8989 | 3.8893 | 3.8964 | 5569508.0 |
| 2007-05-14 12:35:00 | AAPL | Stock | 3.8968 | 3.8968 | 3.8907 | 3.8936 | 4169452.0 |
| 2007-05-14 12:40:00 | AAPL | Stock | 3.8939 | 3.8968 | 3.8929 | 3.8964 | 3146500.0 |
| 2007-05-14 12:45:00 | AAPL | Stock | 3.8961 | 3.8982 | 3.895 | 3.8954 | 3541356.0 |
| 2007-05-14 12:50:00 | AAPL | Stock | 3.8954 | 3.8957 | 3.8929 | 3.8929 | 2776704.0 |
| 2007-05-14 12:55:00 | AAPL | Stock | 3.8936 | 3.8954 | 3.8929 | 3.8946 | 2171596.0 |
| 2007-05-14 13:00:00 | AAPL | Stock | 3.8943 | 3.895 | 3.8925 | 3.8929 | 2992332.0 |
| 2007-05-14 13:05:00 | AAPL | Stock | 3.8932 | 3.895 | 3.8929 | 3.8929 | 2947364.0 |
| 2007-05-14 13:10:00 | AAPL | Stock | 3.8929 | 3.8954 | 3.8929 | 3.8929 | 2784908.0 |
| 2007-05-14 13:15:00 | AAPL | Stock | 3.8929 | 3.8939 | 3.8857 | 3.8925 | 10550428.0 |
| 2007-05-14 13:20:00 | AAPL | Stock | 3.8925 | 3.8946 | 3.8907 | 3.8929 | 5827388.0 |
| 2007-05-14 13:25:00 | AAPL | Stock | 3.8911 | 3.8964 | 3.8911 | 3.8946 | 4288648.0 |
| 2007-05-14 13:30:00 | AAPL | Stock | 3.8939 | 3.8943 | 3.8907 | 3.8932 | 2357404.0 |
| 2007-05-14 13:35:00 | AAPL | Stock | 3.8925 | 3.8932 | 3.885 | 3.8882 | 10540628.0 |
> showing 50 of 283,525 rows — these rows as CSV