PREVIEW / stock_1min / 2007-05-07
file: by_date/stock_1min/2007/2007-05-07.parquet size: 10.3 MB rows: 860,489 symbols: 2,228
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-07 09:30:00 | AAPL | Stock | 3.61 | 3.6164 | 3.6075 | 3.6143 | 6025684.0 |
| 2007-05-07 09:31:00 | AAPL | Stock | 3.6143 | 3.6429 | 3.6125 | 3.6184 | 3248336.0 |
| 2007-05-07 09:32:00 | AAPL | Stock | 3.6182 | 3.6211 | 3.6143 | 3.6154 | 1897924.0 |
| 2007-05-07 09:33:00 | AAPL | Stock | 3.615 | 3.6168 | 3.6089 | 3.615 | 2384816.0 |
| 2007-05-07 09:34:00 | AAPL | Stock | 3.6146 | 3.6161 | 3.6139 | 3.6143 | 1006544.0 |
| 2007-05-07 09:35:00 | AAPL | Stock | 3.6143 | 3.6154 | 3.6132 | 3.6136 | 1003492.0 |
| 2007-05-07 09:36:00 | AAPL | Stock | 3.6132 | 3.6139 | 3.6121 | 3.6129 | 1321740.0 |
| 2007-05-07 09:37:00 | AAPL | Stock | 3.6129 | 3.6136 | 3.6123 | 3.6125 | 645680.0 |
| 2007-05-07 09:38:00 | AAPL | Stock | 3.6125 | 3.6139 | 3.6121 | 3.6132 | 1374324.0 |
| 2007-05-07 09:39:00 | AAPL | Stock | 3.6129 | 3.6161 | 3.6129 | 3.6143 | 1561140.0 |
| 2007-05-07 09:40:00 | AAPL | Stock | 3.615 | 3.6164 | 3.6143 | 3.6161 | 899136.0 |
| 2007-05-07 09:41:00 | AAPL | Stock | 3.6164 | 3.6179 | 3.6161 | 3.6164 | 1535520.0 |
| 2007-05-07 09:42:00 | AAPL | Stock | 3.6164 | 3.6167 | 3.6143 | 3.615 | 1438080.0 |
| 2007-05-07 09:43:00 | AAPL | Stock | 3.6154 | 3.6154 | 3.6107 | 3.6136 | 1725248.0 |
| 2007-05-07 09:44:00 | AAPL | Stock | 3.6111 | 3.6154 | 3.6111 | 3.6154 | 861448.0 |
| 2007-05-07 09:45:00 | AAPL | Stock | 3.615 | 3.6164 | 3.6143 | 3.615 | 581000.0 |
| 2007-05-07 09:46:00 | AAPL | Stock | 3.615 | 3.6154 | 3.6129 | 3.6136 | 787668.0 |
| 2007-05-07 09:47:00 | AAPL | Stock | 3.6139 | 3.6164 | 3.6136 | 3.6161 | 992600.0 |
| 2007-05-07 09:48:00 | AAPL | Stock | 3.6164 | 3.6207 | 3.6154 | 3.6204 | 2224740.0 |
| 2007-05-07 09:49:00 | AAPL | Stock | 3.62 | 3.6207 | 3.6168 | 3.6182 | 2214016.0 |
| 2007-05-07 09:50:00 | AAPL | Stock | 3.6182 | 3.6304 | 3.6168 | 3.6289 | 8359792.0 |
| 2007-05-07 09:51:00 | AAPL | Stock | 3.6292 | 3.6292 | 3.625 | 3.6254 | 3137596.0 |
| 2007-05-07 09:52:00 | AAPL | Stock | 3.6261 | 3.6275 | 3.6232 | 3.6264 | 1805692.0 |
| 2007-05-07 09:53:00 | AAPL | Stock | 3.6268 | 3.6268 | 3.6146 | 3.6179 | 2727872.0 |
| 2007-05-07 09:54:00 | AAPL | Stock | 3.6182 | 3.6207 | 3.615 | 3.6186 | 3223696.0 |
| 2007-05-07 09:55:00 | AAPL | Stock | 3.6189 | 3.62 | 3.6168 | 3.6186 | 1245412.0 |
| 2007-05-07 09:56:00 | AAPL | Stock | 3.6186 | 3.6189 | 3.6161 | 3.6179 | 1496068.0 |
| 2007-05-07 09:57:00 | AAPL | Stock | 3.6179 | 3.6193 | 3.6168 | 3.6193 | 1002988.0 |
| 2007-05-07 09:58:00 | AAPL | Stock | 3.6193 | 3.6261 | 3.6193 | 3.625 | 3427956.0 |
| 2007-05-07 09:59:00 | AAPL | Stock | 3.625 | 3.6268 | 3.6243 | 3.625 | 1656284.0 |
| 2007-05-07 10:00:00 | AAPL | Stock | 3.6254 | 3.6268 | 3.6232 | 3.6268 | 1172304.0 |
| 2007-05-07 10:01:00 | AAPL | Stock | 3.6268 | 3.6268 | 3.6225 | 3.6225 | 1631924.0 |
| 2007-05-07 10:02:00 | AAPL | Stock | 3.6221 | 3.6232 | 3.6168 | 3.6187 | 2391508.0 |
| 2007-05-07 10:03:00 | AAPL | Stock | 3.6193 | 3.6218 | 3.6186 | 3.6207 | 892164.0 |
| 2007-05-07 10:04:00 | AAPL | Stock | 3.6207 | 3.6218 | 3.6196 | 3.6211 | 687764.0 |
| 2007-05-07 10:05:00 | AAPL | Stock | 3.6211 | 3.6218 | 3.62 | 3.6207 | 531076.0 |
| 2007-05-07 10:06:00 | AAPL | Stock | 3.6207 | 3.6246 | 3.6207 | 3.6236 | 1230516.0 |
| 2007-05-07 10:07:00 | AAPL | Stock | 3.6236 | 3.6239 | 3.6211 | 3.6218 | 1302980.0 |
| 2007-05-07 10:08:00 | AAPL | Stock | 3.6218 | 3.6229 | 3.6211 | 3.6225 | 736820.0 |
| 2007-05-07 10:09:00 | AAPL | Stock | 3.6221 | 3.6261 | 3.6221 | 3.625 | 1768172.0 |
| 2007-05-07 10:10:00 | AAPL | Stock | 3.625 | 3.625 | 3.6229 | 3.6236 | 633500.0 |
| 2007-05-07 10:11:00 | AAPL | Stock | 3.6236 | 3.625 | 3.6218 | 3.6221 | 831712.0 |
| 2007-05-07 10:12:00 | AAPL | Stock | 3.6221 | 3.6225 | 3.6196 | 3.6196 | 1830080.0 |
| 2007-05-07 10:13:00 | AAPL | Stock | 3.62 | 3.6246 | 3.6196 | 3.6221 | 2748928.0 |
| 2007-05-07 10:14:00 | AAPL | Stock | 3.6221 | 3.6232 | 3.6207 | 3.6218 | 1077860.0 |
| 2007-05-07 10:15:00 | AAPL | Stock | 3.6218 | 3.6225 | 3.6214 | 3.622 | 626556.0 |
| 2007-05-07 10:16:00 | AAPL | Stock | 3.6218 | 3.6243 | 3.6218 | 3.6232 | 1781164.0 |
| 2007-05-07 10:17:00 | AAPL | Stock | 3.6232 | 3.6236 | 3.6218 | 3.6229 | 883820.0 |
| 2007-05-07 10:18:00 | AAPL | Stock | 3.6232 | 3.625 | 3.6225 | 3.6239 | 2972032.0 |
| 2007-05-07 10:19:00 | AAPL | Stock | 3.6239 | 3.6243 | 3.6232 | 3.6236 | 483560.0 |
> showing 50 of 860,489 rows — these rows as CSV