PREVIEW / stock_1min / 2007-09-14
file: by_date/stock_1min/2007/2007-09-14.parquet size: 10.5 MB rows: 861,408 symbols: 2,527
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-14 09:30:00 | AAPL | Stock | 4.8775 | 4.8804 | 4.8643 | 4.8746 | 7217448.0 |
| 2007-09-14 09:31:00 | AAPL | Stock | 4.8739 | 4.8875 | 4.8681 | 4.8857 | 3554796.0 |
| 2007-09-14 09:32:00 | AAPL | Stock | 4.8861 | 4.8907 | 4.8658 | 4.8768 | 2701804.0 |
| 2007-09-14 09:33:00 | AAPL | Stock | 4.8764 | 4.8846 | 4.8714 | 4.8768 | 2960440.0 |
| 2007-09-14 09:34:00 | AAPL | Stock | 4.8768 | 4.8804 | 4.875 | 4.8771 | 1828036.0 |
| 2007-09-14 09:35:00 | AAPL | Stock | 4.8768 | 4.8793 | 4.875 | 4.8768 | 1839404.0 |
| 2007-09-14 09:36:00 | AAPL | Stock | 4.8771 | 4.8868 | 4.8754 | 4.8839 | 2691332.0 |
| 2007-09-14 09:37:00 | AAPL | Stock | 4.8832 | 4.8954 | 4.8825 | 4.8918 | 4249028.0 |
| 2007-09-14 09:38:00 | AAPL | Stock | 4.8914 | 4.9032 | 4.8904 | 4.8989 | 3732036.0 |
| 2007-09-14 09:39:00 | AAPL | Stock | 4.8996 | 4.9107 | 4.8971 | 4.9057 | 4679668.0 |
| 2007-09-14 09:40:00 | AAPL | Stock | 4.9068 | 4.9214 | 4.905 | 4.9175 | 5515244.0 |
| 2007-09-14 09:41:00 | AAPL | Stock | 4.9171 | 4.9243 | 4.9125 | 4.9232 | 3698100.0 |
| 2007-09-14 09:42:00 | AAPL | Stock | 4.9243 | 4.9254 | 4.9168 | 4.9182 | 4473364.0 |
| 2007-09-14 09:43:00 | AAPL | Stock | 4.9182 | 4.9186 | 4.9114 | 4.9121 | 3894744.0 |
| 2007-09-14 09:44:00 | AAPL | Stock | 4.9114 | 4.9143 | 4.905 | 4.9075 | 2840936.0 |
| 2007-09-14 09:45:00 | AAPL | Stock | 4.9071 | 4.9111 | 4.9057 | 4.91 | 2880388.0 |
| 2007-09-14 09:46:00 | AAPL | Stock | 4.91 | 4.9104 | 4.8966 | 4.9008 | 3003252.0 |
| 2007-09-14 09:47:00 | AAPL | Stock | 4.8982 | 4.905 | 4.8932 | 4.9036 | 3027248.0 |
| 2007-09-14 09:48:00 | AAPL | Stock | 4.9036 | 4.9079 | 4.9 | 4.9011 | 1741320.0 |
| 2007-09-14 09:49:00 | AAPL | Stock | 4.9007 | 4.9057 | 4.9004 | 4.9029 | 1054396.0 |
| 2007-09-14 09:50:00 | AAPL | Stock | 4.9036 | 4.9114 | 4.9004 | 4.9111 | 2446080.0 |
| 2007-09-14 09:51:00 | AAPL | Stock | 4.9111 | 4.9211 | 4.9104 | 4.915 | 2743440.0 |
| 2007-09-14 09:52:00 | AAPL | Stock | 4.9132 | 4.9239 | 4.9125 | 4.9193 | 2387084.0 |
| 2007-09-14 09:53:00 | AAPL | Stock | 4.92 | 4.9214 | 4.9143 | 4.9175 | 1931272.0 |
| 2007-09-14 09:54:00 | AAPL | Stock | 4.9164 | 4.9268 | 4.9164 | 4.9236 | 3623088.0 |
| 2007-09-14 09:55:00 | AAPL | Stock | 4.9236 | 4.9268 | 4.9179 | 4.9196 | 3686704.0 |
| 2007-09-14 09:56:00 | AAPL | Stock | 4.9196 | 4.92 | 4.9107 | 4.9125 | 1898848.0 |
| 2007-09-14 09:57:00 | AAPL | Stock | 4.9114 | 4.9132 | 4.9036 | 4.9079 | 2249520.0 |
| 2007-09-14 09:58:00 | AAPL | Stock | 4.9082 | 4.9141 | 4.9082 | 4.9096 | 1042244.0 |
| 2007-09-14 09:59:00 | AAPL | Stock | 4.9104 | 4.915 | 4.91 | 4.9118 | 919100.0 |
| 2007-09-14 10:00:00 | AAPL | Stock | 4.9118 | 4.9175 | 4.91 | 4.91 | 2117808.0 |
| 2007-09-14 10:01:00 | AAPL | Stock | 4.91 | 4.9232 | 4.9096 | 4.9214 | 2472176.0 |
| 2007-09-14 10:02:00 | AAPL | Stock | 4.9211 | 4.9214 | 4.9111 | 4.9125 | 2291856.0 |
| 2007-09-14 10:03:00 | AAPL | Stock | 4.9125 | 4.9125 | 4.9064 | 4.9082 | 2015664.0 |
| 2007-09-14 10:04:00 | AAPL | Stock | 4.9082 | 4.9164 | 4.9082 | 4.9143 | 5658324.0 |
| 2007-09-14 10:05:00 | AAPL | Stock | 4.9143 | 4.9189 | 4.91 | 4.9182 | 2471532.0 |
| 2007-09-14 10:06:00 | AAPL | Stock | 4.9193 | 4.9236 | 4.9175 | 4.9211 | 2630684.0 |
| 2007-09-14 10:07:00 | AAPL | Stock | 4.9214 | 4.9214 | 4.9186 | 4.9214 | 1924944.0 |
| 2007-09-14 10:08:00 | AAPL | Stock | 4.9211 | 4.9275 | 4.9196 | 4.9271 | 2830772.0 |
| 2007-09-14 10:09:00 | AAPL | Stock | 4.9261 | 4.9286 | 4.9236 | 4.9264 | 3418100.0 |
| 2007-09-14 10:10:00 | AAPL | Stock | 4.9267 | 4.9271 | 4.9196 | 4.9218 | 1673504.0 |
| 2007-09-14 10:11:00 | AAPL | Stock | 4.9232 | 4.9243 | 4.9196 | 4.9229 | 1944432.0 |
| 2007-09-14 10:12:00 | AAPL | Stock | 4.9229 | 4.9282 | 4.9229 | 4.9264 | 2014628.0 |
| 2007-09-14 10:13:00 | AAPL | Stock | 4.9265 | 4.9268 | 4.9214 | 4.9221 | 1221724.0 |
| 2007-09-14 10:14:00 | AAPL | Stock | 4.9218 | 4.9236 | 4.9189 | 4.9225 | 1491084.0 |
| 2007-09-14 10:15:00 | AAPL | Stock | 4.9225 | 4.925 | 4.9211 | 4.9236 | 1717212.0 |
| 2007-09-14 10:16:00 | AAPL | Stock | 4.9236 | 4.9321 | 4.9225 | 4.9318 | 6668396.0 |
| 2007-09-14 10:17:00 | AAPL | Stock | 4.9318 | 4.9318 | 4.9239 | 4.9268 | 3107160.0 |
| 2007-09-14 10:18:00 | AAPL | Stock | 4.9264 | 4.9289 | 4.9189 | 4.92 | 2620296.0 |
| 2007-09-14 10:19:00 | AAPL | Stock | 4.9196 | 4.9225 | 4.9171 | 4.9171 | 2245852.0 |
> showing 50 of 861,408 rows — these rows as CSV