PREVIEW / stock_1min / 2007-07-06
file: by_date/stock_1min/2007/2007-07-06.parquet size: 10.6 MB rows: 870,477 symbols: 2,486
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-07-06 09:30:00 | AAPL | Stock | 4.7546 | 4.7571 | 4.7421 | 4.7464 | 12577656.0 |
| 2007-07-06 09:31:00 | AAPL | Stock | 4.7464 | 4.7621 | 4.7332 | 4.735 | 13251448.0 |
| 2007-07-06 09:32:00 | AAPL | Stock | 4.7346 | 4.7571 | 4.7293 | 4.7293 | 9468004.0 |
| 2007-07-06 09:33:00 | AAPL | Stock | 4.7289 | 4.7321 | 4.7096 | 4.7164 | 12853876.0 |
| 2007-07-06 09:34:00 | AAPL | Stock | 4.7164 | 4.7186 | 4.6914 | 4.7 | 12632676.0 |
| 2007-07-06 09:35:00 | AAPL | Stock | 4.6996 | 4.7014 | 4.6718 | 4.6786 | 17227952.0 |
| 2007-07-06 09:36:00 | AAPL | Stock | 4.6789 | 4.6857 | 4.6732 | 4.6746 | 11911032.0 |
| 2007-07-06 09:37:00 | AAPL | Stock | 4.6743 | 4.6761 | 4.6571 | 4.6675 | 15981308.0 |
| 2007-07-06 09:38:00 | AAPL | Stock | 4.6679 | 4.6804 | 4.6607 | 4.6743 | 11380796.0 |
| 2007-07-06 09:39:00 | AAPL | Stock | 4.6746 | 4.6761 | 4.6611 | 4.6636 | 7829668.0 |
| 2007-07-06 09:40:00 | AAPL | Stock | 4.6632 | 4.6846 | 4.6632 | 4.6825 | 12577768.0 |
| 2007-07-06 09:41:00 | AAPL | Stock | 4.6829 | 4.6846 | 4.6721 | 4.6796 | 9043300.0 |
| 2007-07-06 09:42:00 | AAPL | Stock | 4.6793 | 4.6814 | 4.6743 | 4.6814 | 6361544.0 |
| 2007-07-06 09:43:00 | AAPL | Stock | 4.6811 | 4.6904 | 4.68 | 4.6871 | 6806100.0 |
| 2007-07-06 09:44:00 | AAPL | Stock | 4.6868 | 4.6893 | 4.6786 | 4.6811 | 6522292.0 |
| 2007-07-06 09:45:00 | AAPL | Stock | 4.6811 | 4.6875 | 4.6796 | 4.6829 | 5915168.0 |
| 2007-07-06 09:46:00 | AAPL | Stock | 4.6829 | 4.6911 | 4.6818 | 4.6818 | 7830480.0 |
| 2007-07-06 09:47:00 | AAPL | Stock | 4.6821 | 4.6864 | 4.6704 | 4.6752 | 11247152.0 |
| 2007-07-06 09:48:00 | AAPL | Stock | 4.6754 | 4.6825 | 4.675 | 4.6821 | 4520796.0 |
| 2007-07-06 09:49:00 | AAPL | Stock | 4.6821 | 4.69 | 4.6818 | 4.6843 | 3371508.0 |
| 2007-07-06 09:50:00 | AAPL | Stock | 4.6832 | 4.6875 | 4.6786 | 4.6793 | 5946976.0 |
| 2007-07-06 09:51:00 | AAPL | Stock | 4.6793 | 4.6836 | 4.6789 | 4.6804 | 3291064.0 |
| 2007-07-06 09:52:00 | AAPL | Stock | 4.68 | 4.6836 | 4.6789 | 4.6807 | 2508072.0 |
| 2007-07-06 09:53:00 | AAPL | Stock | 4.6807 | 4.6829 | 4.6736 | 4.6739 | 4637948.0 |
| 2007-07-06 09:54:00 | AAPL | Stock | 4.6739 | 4.6761 | 4.6714 | 4.6714 | 6773704.0 |
| 2007-07-06 09:55:00 | AAPL | Stock | 4.6714 | 4.6779 | 4.6714 | 4.6771 | 3985492.0 |
| 2007-07-06 09:56:00 | AAPL | Stock | 4.677 | 4.6771 | 4.6739 | 4.675 | 3197068.0 |
| 2007-07-06 09:57:00 | AAPL | Stock | 4.6754 | 4.6875 | 4.6743 | 4.6875 | 7378224.0 |
| 2007-07-06 09:58:00 | AAPL | Stock | 4.6871 | 4.6964 | 4.6868 | 4.6921 | 9007236.0 |
| 2007-07-06 09:59:00 | AAPL | Stock | 4.6921 | 4.6946 | 4.6875 | 4.6904 | 3954832.0 |
| 2007-07-06 10:00:00 | AAPL | Stock | 4.6918 | 4.7018 | 4.68 | 4.6996 | 5198676.0 |
| 2007-07-06 10:01:00 | AAPL | Stock | 4.7 | 4.7179 | 4.6964 | 4.7171 | 9646812.0 |
| 2007-07-06 10:02:00 | AAPL | Stock | 4.7168 | 4.7186 | 4.7064 | 4.7071 | 6750016.0 |
| 2007-07-06 10:03:00 | AAPL | Stock | 4.7071 | 4.7182 | 4.7039 | 4.7118 | 7443072.0 |
| 2007-07-06 10:04:00 | AAPL | Stock | 4.7121 | 4.7136 | 4.7068 | 4.71 | 3078908.0 |
| 2007-07-06 10:05:00 | AAPL | Stock | 4.7107 | 4.7132 | 4.7089 | 4.7114 | 2623712.0 |
| 2007-07-06 10:06:00 | AAPL | Stock | 4.7121 | 4.7143 | 4.7096 | 4.7096 | 4332188.0 |
| 2007-07-06 10:07:00 | AAPL | Stock | 4.7093 | 4.7132 | 4.7061 | 4.7089 | 3713164.0 |
| 2007-07-06 10:08:00 | AAPL | Stock | 4.7093 | 4.7114 | 4.7075 | 4.7093 | 2476152.0 |
| 2007-07-06 10:09:00 | AAPL | Stock | 4.7096 | 4.715 | 4.7094 | 4.7129 | 3885420.0 |
| 2007-07-06 10:10:00 | AAPL | Stock | 4.7125 | 4.7129 | 4.6986 | 4.7046 | 6373724.0 |
| 2007-07-06 10:11:00 | AAPL | Stock | 4.7036 | 4.7082 | 4.6979 | 4.7036 | 4851700.0 |
| 2007-07-06 10:12:00 | AAPL | Stock | 4.7032 | 4.7036 | 4.6954 | 4.7 | 5035548.0 |
| 2007-07-06 10:13:00 | AAPL | Stock | 4.7 | 4.7071 | 4.7 | 4.7032 | 3141908.0 |
| 2007-07-06 10:14:00 | AAPL | Stock | 4.7029 | 4.7065 | 4.7007 | 4.705 | 2792608.0 |
| 2007-07-06 10:15:00 | AAPL | Stock | 4.7047 | 4.7071 | 4.7018 | 4.7046 | 1707328.0 |
| 2007-07-06 10:16:00 | AAPL | Stock | 4.7036 | 4.7054 | 4.7018 | 4.7021 | 1707216.0 |
| 2007-07-06 10:17:00 | AAPL | Stock | 4.7018 | 4.705 | 4.6993 | 4.7 | 1930236.0 |
| 2007-07-06 10:18:00 | AAPL | Stock | 4.7004 | 4.7043 | 4.7004 | 4.7018 | 1941968.0 |
| 2007-07-06 10:19:00 | AAPL | Stock | 4.7018 | 4.7068 | 4.7 | 4.7021 | 1900640.0 |
> showing 50 of 870,477 rows — these rows as CSV