PREVIEW / stock_5min / 2008-05-15
file: by_date/stock_5min/2008/2008-05-15.parquet size: 4.4 MB rows: 314,619 symbols: 3,306
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-05-15 07:05:00 | AAPL | Stock | 6.6875 | 6.6882 | 6.6875 | 6.6882 | 25200.0 |
| 2008-05-15 07:10:00 | AAPL | Stock | 6.6964 | 6.6964 | 6.6964 | 6.6964 | 28000.0 |
| 2008-05-15 07:15:00 | AAPL | Stock | 6.6961 | 6.6961 | 6.6961 | 6.6961 | 16800.0 |
| 2008-05-15 07:20:00 | AAPL | Stock | 6.7071 | 6.7071 | 6.7036 | 6.7036 | 5600.0 |
| 2008-05-15 07:30:00 | AAPL | Stock | 6.6964 | 6.6964 | 6.6911 | 6.6911 | 18340.0 |
| 2008-05-15 07:35:00 | AAPL | Stock | 6.6964 | 6.7093 | 6.6911 | 6.7093 | 59836.0 |
| 2008-05-15 07:40:00 | AAPL | Stock | 6.7093 | 6.7096 | 6.7061 | 6.7061 | 16800.0 |
| 2008-05-15 07:45:00 | AAPL | Stock | 6.7061 | 6.7061 | 6.6968 | 6.7061 | 58800.0 |
| 2008-05-15 07:50:00 | AAPL | Stock | 6.7096 | 6.7143 | 6.6964 | 6.7139 | 225960.0 |
| 2008-05-15 07:55:00 | AAPL | Stock | 6.7054 | 6.7143 | 6.7054 | 6.71 | 123480.0 |
| 2008-05-15 08:00:00 | AAPL | Stock | 6.7089 | 6.7143 | 6.7036 | 6.7143 | 948836.0 |
| 2008-05-15 08:05:00 | AAPL | Stock | 6.7143 | 6.7189 | 6.7064 | 6.7104 | 794220.0 |
| 2008-05-15 08:10:00 | AAPL | Stock | 6.7107 | 6.715 | 6.7064 | 6.7093 | 487172.0 |
| 2008-05-15 08:15:00 | AAPL | Stock | 6.7089 | 6.7093 | 6.6982 | 6.7025 | 627340.0 |
| 2008-05-15 08:20:00 | AAPL | Stock | 6.7036 | 6.7068 | 6.7032 | 6.7061 | 209160.0 |
| 2008-05-15 08:25:00 | AAPL | Stock | 6.7054 | 6.7071 | 6.7036 | 6.705 | 478996.0 |
| 2008-05-15 08:30:00 | AAPL | Stock | 6.7046 | 6.7046 | 6.6918 | 6.7032 | 524328.0 |
| 2008-05-15 08:35:00 | AAPL | Stock | 6.7018 | 6.7018 | 6.695 | 6.6968 | 204820.0 |
| 2008-05-15 08:40:00 | AAPL | Stock | 6.6968 | 6.7014 | 6.6968 | 6.7014 | 154504.0 |
| 2008-05-15 08:45:00 | AAPL | Stock | 6.7 | 6.7054 | 6.7 | 6.7046 | 340536.0 |
| 2008-05-15 08:50:00 | AAPL | Stock | 6.7046 | 6.7107 | 6.7043 | 6.7071 | 631288.0 |
| 2008-05-15 08:55:00 | AAPL | Stock | 6.7071 | 6.7071 | 6.6968 | 6.6989 | 473284.0 |
| 2008-05-15 09:00:00 | AAPL | Stock | 6.6971 | 6.6996 | 6.6964 | 6.6964 | 169260.0 |
| 2008-05-15 09:05:00 | AAPL | Stock | 6.6982 | 6.6982 | 6.6907 | 6.6925 | 341964.0 |
| 2008-05-15 09:10:00 | AAPL | Stock | 6.6929 | 6.6946 | 6.6921 | 6.6921 | 154700.0 |
| 2008-05-15 09:15:00 | AAPL | Stock | 6.6918 | 6.6918 | 6.6846 | 6.6893 | 302932.0 |
| 2008-05-15 09:20:00 | AAPL | Stock | 6.6921 | 6.6921 | 6.675 | 6.6786 | 591276.0 |
| 2008-05-15 09:25:00 | AAPL | Stock | 6.6764 | 6.6836 | 6.6689 | 6.6729 | 1750252.0 |
| 2008-05-15 09:30:00 | AAPL | Stock | 6.6732 | 6.6732 | 6.6171 | 6.6325 | 36524936.0 |
| 2008-05-15 09:35:00 | AAPL | Stock | 6.6329 | 6.6579 | 6.5786 | 6.6032 | 40079200.0 |
| 2008-05-15 09:40:00 | AAPL | Stock | 6.6032 | 6.6332 | 6.6018 | 6.6136 | 23501856.0 |
| 2008-05-15 09:45:00 | AAPL | Stock | 6.6136 | 6.6782 | 6.6104 | 6.6749 | 25092508.0 |
| 2008-05-15 09:50:00 | AAPL | Stock | 6.6739 | 6.6871 | 6.6536 | 6.6771 | 25043956.0 |
| 2008-05-15 09:55:00 | AAPL | Stock | 6.6761 | 6.6761 | 6.6464 | 6.6639 | 16938068.0 |
| 2008-05-15 10:00:00 | AAPL | Stock | 6.6641 | 6.6743 | 6.6371 | 6.655 | 18499236.0 |
| 2008-05-15 10:05:00 | AAPL | Stock | 6.6554 | 6.6604 | 6.6418 | 6.6482 | 10641652.0 |
| 2008-05-15 10:10:00 | AAPL | Stock | 6.6482 | 6.6518 | 6.6111 | 6.6254 | 17433752.0 |
| 2008-05-15 10:15:00 | AAPL | Stock | 6.625 | 6.6532 | 6.6186 | 6.6525 | 12934992.0 |
| 2008-05-15 10:20:00 | AAPL | Stock | 6.6532 | 6.6814 | 6.6525 | 6.6671 | 20487880.0 |
| 2008-05-15 10:25:00 | AAPL | Stock | 6.6668 | 6.6736 | 6.6493 | 6.6589 | 12879524.0 |
| 2008-05-15 10:30:00 | AAPL | Stock | 6.6596 | 6.6636 | 6.6389 | 6.6518 | 11883564.0 |
| 2008-05-15 10:35:00 | AAPL | Stock | 6.6514 | 6.6686 | 6.6411 | 6.6664 | 9377732.0 |
| 2008-05-15 10:40:00 | AAPL | Stock | 6.6661 | 6.6964 | 6.6657 | 6.6839 | 19616184.0 |
| 2008-05-15 10:45:00 | AAPL | Stock | 6.6842 | 6.7011 | 6.6832 | 6.6861 | 14553336.0 |
| 2008-05-15 10:50:00 | AAPL | Stock | 6.6871 | 6.6886 | 6.6721 | 6.6743 | 10184944.0 |
| 2008-05-15 10:55:00 | AAPL | Stock | 6.6746 | 6.6857 | 6.6739 | 6.6794 | 5265428.0 |
| 2008-05-15 11:00:00 | AAPL | Stock | 6.68 | 6.6964 | 6.6786 | 6.6914 | 9011996.0 |
| 2008-05-15 11:05:00 | AAPL | Stock | 6.6925 | 6.6957 | 6.6846 | 6.6868 | 7411684.0 |
| 2008-05-15 11:10:00 | AAPL | Stock | 6.6875 | 6.6889 | 6.6736 | 6.6807 | 8171072.0 |
| 2008-05-15 11:15:00 | AAPL | Stock | 6.6811 | 6.6875 | 6.6604 | 6.6689 | 12200244.0 |
> showing 50 of 314,619 rows — these rows as CSV