PREVIEW / stock_1min / 2007-09-12
file: by_date/stock_1min/2007/2007-09-12.parquet size: 10.9 MB rows: 892,140 symbols: 2,547
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-09-12 09:30:00 | AAPL | Stock | 4.8571 | 4.8664 | 4.8482 | 4.8639 | 4356408.0 |
| 2007-09-12 09:31:00 | AAPL | Stock | 4.8636 | 4.8775 | 4.8526 | 4.8768 | 6268304.0 |
| 2007-09-12 09:32:00 | AAPL | Stock | 4.8764 | 4.8889 | 4.8633 | 4.8811 | 7943376.0 |
| 2007-09-12 09:33:00 | AAPL | Stock | 4.8807 | 4.8871 | 4.8775 | 4.8782 | 5177312.0 |
| 2007-09-12 09:34:00 | AAPL | Stock | 4.8782 | 4.8789 | 4.8664 | 4.8679 | 5129572.0 |
| 2007-09-12 09:35:00 | AAPL | Stock | 4.8696 | 4.875 | 4.8687 | 4.8718 | 2691668.0 |
| 2007-09-12 09:36:00 | AAPL | Stock | 4.8725 | 4.8731 | 4.8571 | 4.8586 | 5402432.0 |
| 2007-09-12 09:37:00 | AAPL | Stock | 4.8611 | 4.8657 | 4.8579 | 4.8657 | 2484272.0 |
| 2007-09-12 09:38:00 | AAPL | Stock | 4.8661 | 4.87 | 4.8614 | 4.87 | 2091992.0 |
| 2007-09-12 09:39:00 | AAPL | Stock | 4.8707 | 4.8793 | 4.8675 | 4.8718 | 3449152.0 |
| 2007-09-12 09:40:00 | AAPL | Stock | 4.8725 | 4.8782 | 4.8696 | 4.8714 | 2488556.0 |
| 2007-09-12 09:41:00 | AAPL | Stock | 4.8704 | 4.8839 | 4.8682 | 4.8829 | 4529728.0 |
| 2007-09-12 09:42:00 | AAPL | Stock | 4.8825 | 4.8846 | 4.8714 | 4.8718 | 4876396.0 |
| 2007-09-12 09:43:00 | AAPL | Stock | 4.8725 | 4.8936 | 4.8718 | 4.8932 | 8386000.0 |
| 2007-09-12 09:44:00 | AAPL | Stock | 4.8936 | 4.9 | 4.8907 | 4.8982 | 6546680.0 |
| 2007-09-12 09:45:00 | AAPL | Stock | 4.8964 | 4.9071 | 4.8954 | 4.8993 | 6183912.0 |
| 2007-09-12 09:46:00 | AAPL | Stock | 4.8986 | 4.9002 | 4.8929 | 4.8986 | 3973648.0 |
| 2007-09-12 09:47:00 | AAPL | Stock | 4.8989 | 4.8994 | 4.8932 | 4.8932 | 3398808.0 |
| 2007-09-12 09:48:00 | AAPL | Stock | 4.8932 | 4.8989 | 4.8907 | 4.8968 | 4754428.0 |
| 2007-09-12 09:49:00 | AAPL | Stock | 4.8964 | 4.9029 | 4.8964 | 4.8975 | 3556784.0 |
| 2007-09-12 09:50:00 | AAPL | Stock | 4.8975 | 4.9032 | 4.8964 | 4.9021 | 3913756.0 |
| 2007-09-12 09:51:00 | AAPL | Stock | 4.9018 | 4.9029 | 4.8993 | 4.9 | 3758888.0 |
| 2007-09-12 09:52:00 | AAPL | Stock | 4.9 | 4.9015 | 4.8904 | 4.8911 | 5099332.0 |
| 2007-09-12 09:53:00 | AAPL | Stock | 4.8907 | 4.8925 | 4.8868 | 4.8904 | 3546872.0 |
| 2007-09-12 09:54:00 | AAPL | Stock | 4.89 | 4.8909 | 4.8846 | 4.8857 | 3164728.0 |
| 2007-09-12 09:55:00 | AAPL | Stock | 4.8854 | 4.8914 | 4.8852 | 4.8871 | 3175704.0 |
| 2007-09-12 09:56:00 | AAPL | Stock | 4.8871 | 4.8975 | 4.8871 | 4.8968 | 3143980.0 |
| 2007-09-12 09:57:00 | AAPL | Stock | 4.8971 | 4.9018 | 4.8954 | 4.9014 | 2263072.0 |
| 2007-09-12 09:58:00 | AAPL | Stock | 4.9014 | 4.9018 | 4.8946 | 4.8971 | 2858100.0 |
| 2007-09-12 09:59:00 | AAPL | Stock | 4.8968 | 4.9004 | 4.895 | 4.8986 | 1561952.0 |
| 2007-09-12 10:00:00 | AAPL | Stock | 4.8986 | 4.9018 | 4.8971 | 4.9014 | 2546096.0 |
| 2007-09-12 10:01:00 | AAPL | Stock | 4.9018 | 4.9093 | 4.9012 | 4.9093 | 6125504.0 |
| 2007-09-12 10:02:00 | AAPL | Stock | 4.9096 | 4.9157 | 4.9082 | 4.91 | 7108724.0 |
| 2007-09-12 10:03:00 | AAPL | Stock | 4.9107 | 4.9157 | 4.9057 | 4.9146 | 4263252.0 |
| 2007-09-12 10:04:00 | AAPL | Stock | 4.9143 | 4.9161 | 4.9111 | 4.9143 | 3508792.0 |
| 2007-09-12 10:05:00 | AAPL | Stock | 4.9146 | 4.9193 | 4.9086 | 4.9132 | 5415816.0 |
| 2007-09-12 10:06:00 | AAPL | Stock | 4.9124 | 4.9196 | 4.9111 | 4.9186 | 2695924.0 |
| 2007-09-12 10:07:00 | AAPL | Stock | 4.9179 | 4.9264 | 4.9164 | 4.9262 | 5521852.0 |
| 2007-09-12 10:08:00 | AAPL | Stock | 4.9264 | 4.9325 | 4.9246 | 4.9296 | 7280812.0 |
| 2007-09-12 10:09:00 | AAPL | Stock | 4.9286 | 4.93 | 4.9214 | 4.9214 | 4506180.0 |
| 2007-09-12 10:10:00 | AAPL | Stock | 4.9214 | 4.925 | 4.9143 | 4.9232 | 4508728.0 |
| 2007-09-12 10:11:00 | AAPL | Stock | 4.9229 | 4.9257 | 4.9204 | 4.9238 | 2872044.0 |
| 2007-09-12 10:12:00 | AAPL | Stock | 4.925 | 4.9268 | 4.9204 | 4.9218 | 3051020.0 |
| 2007-09-12 10:13:00 | AAPL | Stock | 4.9221 | 4.9232 | 4.9186 | 4.9225 | 2280712.0 |
| 2007-09-12 10:14:00 | AAPL | Stock | 4.9221 | 4.925 | 4.9179 | 4.9193 | 2198924.0 |
| 2007-09-12 10:15:00 | AAPL | Stock | 4.9193 | 4.9225 | 4.9129 | 4.9164 | 3592568.0 |
| 2007-09-12 10:16:00 | AAPL | Stock | 4.9161 | 4.9211 | 4.9157 | 4.9211 | 2831556.0 |
| 2007-09-12 10:17:00 | AAPL | Stock | 4.9196 | 4.9214 | 4.9089 | 4.9161 | 4827704.0 |
| 2007-09-12 10:18:00 | AAPL | Stock | 4.9168 | 4.9182 | 4.9125 | 4.9125 | 1842288.0 |
| 2007-09-12 10:19:00 | AAPL | Stock | 4.9125 | 4.913 | 4.9061 | 4.9086 | 3802988.0 |
> showing 50 of 892,140 rows — these rows as CSV