PREVIEW / stock_1min / 2007-05-15
file: by_date/stock_1min/2007/2007-05-15.parquet size: 11.2 MB rows: 918,027 symbols: 2,261
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-15 09:30:00 | AAPL | Stock | 3.9132 | 3.9161 | 3.9032 | 3.9046 | 6409984.0 |
| 2007-05-15 09:31:00 | AAPL | Stock | 3.9032 | 3.9104 | 3.8993 | 3.9104 | 2396100.0 |
| 2007-05-15 09:32:00 | AAPL | Stock | 3.9093 | 3.9104 | 3.9046 | 3.9057 | 1584492.0 |
| 2007-05-15 09:33:00 | AAPL | Stock | 3.9054 | 3.9064 | 3.8971 | 3.9007 | 2468228.0 |
| 2007-05-15 09:34:00 | AAPL | Stock | 3.9004 | 3.9007 | 3.8929 | 3.8964 | 3322200.0 |
| 2007-05-15 09:35:00 | AAPL | Stock | 3.8964 | 3.8982 | 3.8939 | 3.8946 | 2046492.0 |
| 2007-05-15 09:36:00 | AAPL | Stock | 3.8939 | 3.8943 | 3.8893 | 3.8904 | 4909996.0 |
| 2007-05-15 09:37:00 | AAPL | Stock | 3.89 | 3.8929 | 3.8875 | 3.8882 | 3532396.0 |
| 2007-05-15 09:38:00 | AAPL | Stock | 3.8882 | 3.8921 | 3.8868 | 3.8907 | 3393180.0 |
| 2007-05-15 09:39:00 | AAPL | Stock | 3.8911 | 3.895 | 3.89 | 3.8929 | 3492888.0 |
| 2007-05-15 09:40:00 | AAPL | Stock | 3.8932 | 3.8979 | 3.8929 | 3.8943 | 2523080.0 |
| 2007-05-15 09:41:00 | AAPL | Stock | 3.8943 | 3.8964 | 3.8929 | 3.8929 | 2490656.0 |
| 2007-05-15 09:42:00 | AAPL | Stock | 3.8932 | 3.8946 | 3.8929 | 3.8936 | 2402092.0 |
| 2007-05-15 09:43:00 | AAPL | Stock | 3.8936 | 3.9004 | 3.8932 | 3.8989 | 2686544.0 |
| 2007-05-15 09:44:00 | AAPL | Stock | 3.8982 | 3.905 | 3.8979 | 3.9032 | 2613828.0 |
| 2007-05-15 09:45:00 | AAPL | Stock | 3.9021 | 3.9043 | 3.9007 | 3.9021 | 2170812.0 |
| 2007-05-15 09:46:00 | AAPL | Stock | 3.9018 | 3.9018 | 3.8946 | 3.8954 | 3886204.0 |
| 2007-05-15 09:47:00 | AAPL | Stock | 3.8954 | 3.8986 | 3.8946 | 3.8975 | 2601312.0 |
| 2007-05-15 09:48:00 | AAPL | Stock | 3.8975 | 3.9068 | 3.8975 | 3.905 | 3637592.0 |
| 2007-05-15 09:49:00 | AAPL | Stock | 3.905 | 3.9082 | 3.9018 | 3.9039 | 2896740.0 |
| 2007-05-15 09:50:00 | AAPL | Stock | 3.9036 | 3.9068 | 3.9007 | 3.9029 | 3270988.0 |
| 2007-05-15 09:51:00 | AAPL | Stock | 3.9036 | 3.9068 | 3.9018 | 3.9018 | 2628724.0 |
| 2007-05-15 09:52:00 | AAPL | Stock | 3.9018 | 3.905 | 3.9014 | 3.9014 | 2204104.0 |
| 2007-05-15 09:53:00 | AAPL | Stock | 3.9014 | 3.9025 | 3.8993 | 3.9014 | 1192464.0 |
| 2007-05-15 09:54:00 | AAPL | Stock | 3.9011 | 3.905 | 3.9011 | 3.9025 | 2430792.0 |
| 2007-05-15 09:55:00 | AAPL | Stock | 3.9025 | 3.9025 | 3.8961 | 3.9 | 1947904.0 |
| 2007-05-15 09:56:00 | AAPL | Stock | 3.9004 | 3.9018 | 3.8989 | 3.9004 | 1694364.0 |
| 2007-05-15 09:57:00 | AAPL | Stock | 3.9 | 3.9036 | 3.8971 | 3.9036 | 1674876.0 |
| 2007-05-15 09:58:00 | AAPL | Stock | 3.9036 | 3.92 | 3.9032 | 3.9159 | 6331668.0 |
| 2007-05-15 09:59:00 | AAPL | Stock | 3.9165 | 3.9189 | 3.9139 | 3.9171 | 3891440.0 |
| 2007-05-15 10:00:00 | AAPL | Stock | 3.9168 | 3.9196 | 3.9168 | 3.9196 | 4882780.0 |
| 2007-05-15 10:01:00 | AAPL | Stock | 3.9193 | 3.9232 | 3.9192 | 3.9225 | 5344416.0 |
| 2007-05-15 10:02:00 | AAPL | Stock | 3.9225 | 3.9236 | 3.9171 | 3.9214 | 3656632.0 |
| 2007-05-15 10:03:00 | AAPL | Stock | 3.9214 | 3.9286 | 3.9207 | 3.9279 | 5694920.0 |
| 2007-05-15 10:04:00 | AAPL | Stock | 3.9279 | 3.93 | 3.9204 | 3.924 | 8655920.0 |
| 2007-05-15 10:05:00 | AAPL | Stock | 3.925 | 3.925 | 3.9186 | 3.9232 | 2995188.0 |
| 2007-05-15 10:06:00 | AAPL | Stock | 3.9232 | 3.9304 | 3.9229 | 3.9275 | 6049204.0 |
| 2007-05-15 10:07:00 | AAPL | Stock | 3.9271 | 3.9275 | 3.9232 | 3.9236 | 2755480.0 |
| 2007-05-15 10:08:00 | AAPL | Stock | 3.9235 | 3.9271 | 3.9193 | 3.9271 | 3645068.0 |
| 2007-05-15 10:09:00 | AAPL | Stock | 3.9271 | 3.9325 | 3.925 | 3.9268 | 4463984.0 |
| 2007-05-15 10:10:00 | AAPL | Stock | 3.9268 | 3.9357 | 3.9265 | 3.9325 | 4507356.0 |
| 2007-05-15 10:11:00 | AAPL | Stock | 3.9329 | 3.9346 | 3.9286 | 3.9286 | 3418968.0 |
| 2007-05-15 10:12:00 | AAPL | Stock | 3.9289 | 3.9318 | 3.9286 | 3.9307 | 2947896.0 |
| 2007-05-15 10:13:00 | AAPL | Stock | 3.9307 | 3.9307 | 3.9246 | 3.9261 | 3389792.0 |
| 2007-05-15 10:14:00 | AAPL | Stock | 3.9264 | 3.9275 | 3.9232 | 3.9243 | 2212364.0 |
| 2007-05-15 10:15:00 | AAPL | Stock | 3.9246 | 3.9268 | 3.9218 | 3.9246 | 2150456.0 |
| 2007-05-15 10:16:00 | AAPL | Stock | 3.9246 | 3.9286 | 3.9239 | 3.9268 | 2070712.0 |
| 2007-05-15 10:17:00 | AAPL | Stock | 3.9264 | 3.9275 | 3.925 | 3.9264 | 1939140.0 |
| 2007-05-15 10:18:00 | AAPL | Stock | 3.9271 | 3.9304 | 3.9264 | 3.93 | 2509584.0 |
| 2007-05-15 10:19:00 | AAPL | Stock | 3.93 | 3.9339 | 3.9296 | 3.9321 | 3466428.0 |
> showing 50 of 918,027 rows — these rows as CSV