PREVIEW / stock_5min / 2008-01-29
file: by_date/stock_5min/2008/2008-01-29.parquet size: 4.4 MB rows: 321,615 symbols: 3,262
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 |
|---|---|---|---|---|---|---|---|
| 2008-01-29 04:15:00 | AAPL | Stock | 4.6518 | 4.6518 | 4.6518 | 4.6518 | 2800.0 |
| 2008-01-29 05:15:00 | AAPL | Stock | 4.6661 | 4.6661 | 4.6661 | 4.6661 | 2800.0 |
| 2008-01-29 05:55:00 | AAPL | Stock | 4.6789 | 4.6789 | 4.6789 | 4.6789 | 25200.0 |
| 2008-01-29 06:05:00 | AAPL | Stock | 4.6929 | 4.7018 | 4.6929 | 4.7018 | 86800.0 |
| 2008-01-29 06:10:00 | AAPL | Stock | 4.7018 | 4.7018 | 4.7018 | 4.7018 | 28000.0 |
| 2008-01-29 06:15:00 | AAPL | Stock | 4.7036 | 4.7036 | 4.7036 | 4.7036 | 5600.0 |
| 2008-01-29 06:20:00 | AAPL | Stock | 4.7 | 4.7064 | 4.7 | 4.7064 | 5600.0 |
| 2008-01-29 06:35:00 | AAPL | Stock | 4.7018 | 4.7018 | 4.7018 | 4.7018 | 2800.0 |
| 2008-01-29 06:40:00 | AAPL | Stock | 4.7004 | 4.7032 | 4.7004 | 4.7032 | 5600.0 |
| 2008-01-29 06:45:00 | AAPL | Stock | 4.7007 | 4.7007 | 4.7007 | 4.7007 | 2800.0 |
| 2008-01-29 06:50:00 | AAPL | Stock | 4.7039 | 4.7039 | 4.7039 | 4.7039 | 2968.0 |
| 2008-01-29 06:55:00 | AAPL | Stock | 4.7079 | 4.7079 | 4.7054 | 4.7054 | 19600.0 |
| 2008-01-29 07:00:00 | AAPL | Stock | 4.7054 | 4.71 | 4.7054 | 4.71 | 99904.0 |
| 2008-01-29 07:05:00 | AAPL | Stock | 4.7054 | 4.7054 | 4.6786 | 4.6786 | 216916.0 |
| 2008-01-29 07:10:00 | AAPL | Stock | 4.6786 | 4.685 | 4.6754 | 4.685 | 114996.0 |
| 2008-01-29 07:15:00 | AAPL | Stock | 4.6786 | 4.6821 | 4.6786 | 4.6821 | 11200.0 |
| 2008-01-29 07:20:00 | AAPL | Stock | 4.6796 | 4.6911 | 4.6796 | 4.6911 | 14700.0 |
| 2008-01-29 07:25:00 | AAPL | Stock | 4.6893 | 4.6893 | 4.6893 | 4.6893 | 14000.0 |
| 2008-01-29 07:30:00 | AAPL | Stock | 4.6839 | 4.6839 | 4.6796 | 4.6811 | 54600.0 |
| 2008-01-29 07:35:00 | AAPL | Stock | 4.6807 | 4.6807 | 4.6718 | 4.6786 | 56000.0 |
| 2008-01-29 07:40:00 | AAPL | Stock | 4.6786 | 4.6786 | 4.6786 | 4.6786 | 2800.0 |
| 2008-01-29 07:45:00 | AAPL | Stock | 4.6786 | 4.6786 | 4.6668 | 4.6668 | 19600.0 |
| 2008-01-29 07:50:00 | AAPL | Stock | 4.6668 | 4.6668 | 4.6668 | 4.6668 | 64624.0 |
| 2008-01-29 07:55:00 | AAPL | Stock | 4.6625 | 4.6711 | 4.6625 | 4.6711 | 5600.0 |
| 2008-01-29 08:00:00 | AAPL | Stock | 4.7071 | 4.7071 | 4.6504 | 4.6607 | 723128.0 |
| 2008-01-29 08:05:00 | AAPL | Stock | 4.6625 | 4.6625 | 4.6439 | 4.6493 | 314384.0 |
| 2008-01-29 08:10:00 | AAPL | Stock | 4.6511 | 4.6589 | 4.65 | 4.6589 | 224644.0 |
| 2008-01-29 08:15:00 | AAPL | Stock | 4.6586 | 4.6607 | 4.655 | 4.6586 | 203700.0 |
| 2008-01-29 08:20:00 | AAPL | Stock | 4.6607 | 4.6671 | 4.6607 | 4.6632 | 188272.0 |
| 2008-01-29 08:25:00 | AAPL | Stock | 4.6618 | 4.6618 | 4.6554 | 4.6571 | 275100.0 |
| 2008-01-29 08:30:00 | AAPL | Stock | 4.6564 | 4.6789 | 4.6521 | 4.6718 | 1411956.0 |
| 2008-01-29 08:35:00 | AAPL | Stock | 4.6757 | 4.6779 | 4.6714 | 4.6718 | 352604.0 |
| 2008-01-29 08:40:00 | AAPL | Stock | 4.6732 | 4.6764 | 4.6696 | 4.6764 | 229208.0 |
| 2008-01-29 08:45:00 | AAPL | Stock | 4.6775 | 4.6811 | 4.6689 | 4.6707 | 879284.0 |
| 2008-01-29 08:50:00 | AAPL | Stock | 4.6696 | 4.6736 | 4.6643 | 4.6643 | 457324.0 |
| 2008-01-29 08:55:00 | AAPL | Stock | 4.6679 | 4.675 | 4.6679 | 4.675 | 256424.0 |
| 2008-01-29 09:00:00 | AAPL | Stock | 4.6707 | 4.6857 | 4.6696 | 4.6843 | 762244.0 |
| 2008-01-29 09:05:00 | AAPL | Stock | 4.6857 | 4.71 | 4.6857 | 4.6986 | 1700216.0 |
| 2008-01-29 09:10:00 | AAPL | Stock | 4.6986 | 4.7046 | 4.6939 | 4.6939 | 716044.0 |
| 2008-01-29 09:15:00 | AAPL | Stock | 4.6921 | 4.6996 | 4.6879 | 4.6914 | 400092.0 |
| 2008-01-29 09:20:00 | AAPL | Stock | 4.6882 | 4.6946 | 4.6729 | 4.6754 | 602812.0 |
| 2008-01-29 09:25:00 | AAPL | Stock | 4.6761 | 4.6964 | 4.6718 | 4.6821 | 1782424.0 |
| 2008-01-29 09:30:00 | AAPL | Stock | 4.6846 | 4.7304 | 4.6429 | 4.7204 | 44171680.0 |
| 2008-01-29 09:35:00 | AAPL | Stock | 4.7193 | 4.7425 | 4.7068 | 4.7293 | 28453320.0 |
| 2008-01-29 09:40:00 | AAPL | Stock | 4.7286 | 4.7332 | 4.6939 | 4.6968 | 28318192.0 |
| 2008-01-29 09:45:00 | AAPL | Stock | 4.6986 | 4.7143 | 4.6861 | 4.7089 | 23251872.0 |
| 2008-01-29 09:50:00 | AAPL | Stock | 4.7082 | 4.7139 | 4.6857 | 4.7114 | 20834100.0 |
| 2008-01-29 09:55:00 | AAPL | Stock | 4.7114 | 4.7207 | 4.6875 | 4.6957 | 23275028.0 |
| 2008-01-29 10:00:00 | AAPL | Stock | 4.6954 | 4.7121 | 4.6643 | 4.68 | 36387736.0 |
| 2008-01-29 10:05:00 | AAPL | Stock | 4.6804 | 4.7054 | 4.6721 | 4.6943 | 25408908.0 |
> showing 50 of 321,615 rows — these rows as CSV