PREVIEW / stock_1min / 2007-07-17
file: by_date/stock_1min/2007/2007-07-17.parquet size: 11.2 MB rows: 916,333 symbols: 2,517
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-17 09:30:00 | AAPL | Stock | 4.9393 | 4.9443 | 4.9286 | 4.9437 | 4166428.0 |
| 2007-07-17 09:31:00 | AAPL | Stock | 4.9425 | 4.9507 | 4.9325 | 4.9382 | 4030544.0 |
| 2007-07-17 09:32:00 | AAPL | Stock | 4.9393 | 4.9407 | 4.9196 | 4.92 | 5234404.0 |
| 2007-07-17 09:33:00 | AAPL | Stock | 4.9205 | 4.9411 | 4.9186 | 4.9268 | 4531380.0 |
| 2007-07-17 09:34:00 | AAPL | Stock | 4.9268 | 4.9364 | 4.9244 | 4.935 | 2594844.0 |
| 2007-07-17 09:35:00 | AAPL | Stock | 4.935 | 4.9457 | 4.9321 | 4.9422 | 3397100.0 |
| 2007-07-17 09:36:00 | AAPL | Stock | 4.9425 | 4.9454 | 4.9364 | 4.9443 | 3249904.0 |
| 2007-07-17 09:37:00 | AAPL | Stock | 4.9454 | 4.9561 | 4.9414 | 4.9544 | 5731684.0 |
| 2007-07-17 09:38:00 | AAPL | Stock | 4.9546 | 4.9593 | 4.9511 | 4.9514 | 4703664.0 |
| 2007-07-17 09:39:00 | AAPL | Stock | 4.9514 | 4.9521 | 4.9418 | 4.9425 | 3166912.0 |
| 2007-07-17 09:40:00 | AAPL | Stock | 4.9418 | 4.9493 | 4.9332 | 4.941 | 4427612.0 |
| 2007-07-17 09:41:00 | AAPL | Stock | 4.9404 | 4.9404 | 4.9253 | 4.9254 | 6440420.0 |
| 2007-07-17 09:42:00 | AAPL | Stock | 4.925 | 4.9336 | 4.9232 | 4.9286 | 4359712.0 |
| 2007-07-17 09:43:00 | AAPL | Stock | 4.9286 | 4.9318 | 4.9254 | 4.9311 | 2110472.0 |
| 2007-07-17 09:44:00 | AAPL | Stock | 4.9307 | 4.9411 | 4.93 | 4.9393 | 3310832.0 |
| 2007-07-17 09:45:00 | AAPL | Stock | 4.9396 | 4.9411 | 4.9289 | 4.9329 | 3748752.0 |
| 2007-07-17 09:46:00 | AAPL | Stock | 4.9332 | 4.9346 | 4.9268 | 4.93 | 3117884.0 |
| 2007-07-17 09:47:00 | AAPL | Stock | 4.93 | 4.9318 | 4.9264 | 4.9264 | 2101484.0 |
| 2007-07-17 09:48:00 | AAPL | Stock | 4.9271 | 4.9375 | 4.925 | 4.9346 | 2913120.0 |
| 2007-07-17 09:49:00 | AAPL | Stock | 4.935 | 4.9371 | 4.9314 | 4.935 | 1193612.0 |
| 2007-07-17 09:50:00 | AAPL | Stock | 4.935 | 4.9389 | 4.9343 | 4.9389 | 1526364.0 |
| 2007-07-17 09:51:00 | AAPL | Stock | 4.9386 | 4.9411 | 4.9361 | 4.9396 | 2228072.0 |
| 2007-07-17 09:52:00 | AAPL | Stock | 4.9396 | 4.9407 | 4.9304 | 4.9339 | 2051196.0 |
| 2007-07-17 09:53:00 | AAPL | Stock | 4.9336 | 4.9346 | 4.9282 | 4.9304 | 2475452.0 |
| 2007-07-17 09:54:00 | AAPL | Stock | 4.93 | 4.9304 | 4.9268 | 4.9293 | 1190280.0 |
| 2007-07-17 09:55:00 | AAPL | Stock | 4.9289 | 4.9318 | 4.9268 | 4.9296 | 1917328.0 |
| 2007-07-17 09:56:00 | AAPL | Stock | 4.9293 | 4.9346 | 4.9293 | 4.9314 | 1118740.0 |
| 2007-07-17 09:57:00 | AAPL | Stock | 4.9314 | 4.9332 | 4.9286 | 4.9289 | 2097060.0 |
| 2007-07-17 09:58:00 | AAPL | Stock | 4.9286 | 4.9296 | 4.9214 | 4.9243 | 5616604.0 |
| 2007-07-17 09:59:00 | AAPL | Stock | 4.9243 | 4.9246 | 4.9196 | 4.9229 | 3014172.0 |
| 2007-07-17 10:00:00 | AAPL | Stock | 4.9225 | 4.9264 | 4.9214 | 4.9225 | 1912456.0 |
| 2007-07-17 10:01:00 | AAPL | Stock | 4.9229 | 4.9236 | 4.9161 | 4.9196 | 3771320.0 |
| 2007-07-17 10:02:00 | AAPL | Stock | 4.9211 | 4.9225 | 4.9179 | 4.92 | 2118984.0 |
| 2007-07-17 10:03:00 | AAPL | Stock | 4.92 | 4.9268 | 4.9193 | 4.9217 | 2531116.0 |
| 2007-07-17 10:04:00 | AAPL | Stock | 4.9221 | 4.9286 | 4.9214 | 4.9239 | 2022972.0 |
| 2007-07-17 10:05:00 | AAPL | Stock | 4.9246 | 4.925 | 4.9196 | 4.9229 | 1231636.0 |
| 2007-07-17 10:06:00 | AAPL | Stock | 4.9225 | 4.9243 | 4.9211 | 4.9211 | 1262044.0 |
| 2007-07-17 10:07:00 | AAPL | Stock | 4.9211 | 4.9214 | 4.9111 | 4.9136 | 4261488.0 |
| 2007-07-17 10:08:00 | AAPL | Stock | 4.9143 | 4.9164 | 4.9107 | 4.9114 | 3183152.0 |
| 2007-07-17 10:09:00 | AAPL | Stock | 4.9118 | 4.9271 | 4.9114 | 4.9232 | 4986044.0 |
| 2007-07-17 10:10:00 | AAPL | Stock | 4.9225 | 4.9246 | 4.9207 | 4.9214 | 1970640.0 |
| 2007-07-17 10:11:00 | AAPL | Stock | 4.9207 | 4.9318 | 4.92 | 4.9304 | 3306772.0 |
| 2007-07-17 10:12:00 | AAPL | Stock | 4.9296 | 4.9321 | 4.9268 | 4.9271 | 2797480.0 |
| 2007-07-17 10:13:00 | AAPL | Stock | 4.9279 | 4.93 | 4.9257 | 4.9296 | 1684116.0 |
| 2007-07-17 10:14:00 | AAPL | Stock | 4.9291 | 4.9307 | 4.9254 | 4.9254 | 1864352.0 |
| 2007-07-17 10:15:00 | AAPL | Stock | 4.9254 | 4.9268 | 4.9196 | 4.9196 | 1895488.0 |
| 2007-07-17 10:16:00 | AAPL | Stock | 4.9204 | 4.9268 | 4.9193 | 4.9268 | 4230520.0 |
| 2007-07-17 10:17:00 | AAPL | Stock | 4.9268 | 4.935 | 4.9261 | 4.9332 | 4531464.0 |
| 2007-07-17 10:18:00 | AAPL | Stock | 4.9332 | 4.9354 | 4.9307 | 4.9343 | 2530892.0 |
| 2007-07-17 10:19:00 | AAPL | Stock | 4.935 | 4.935 | 4.9307 | 4.9336 | 1588216.0 |
> showing 50 of 916,333 rows — these rows as CSV