PREVIEW / stock_1min / 2007-09-13
file: by_date/stock_1min/2007/2007-09-13.parquet size: 10.7 MB rows: 881,341 symbols: 2,532
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-13 09:30:00 | AAPL | Stock | 4.9582 | 4.9589 | 4.9375 | 4.9389 | 9732324.0 |
| 2007-09-13 09:31:00 | AAPL | Stock | 4.9389 | 4.9589 | 4.9382 | 4.955 | 4430580.0 |
| 2007-09-13 09:32:00 | AAPL | Stock | 4.9539 | 4.9564 | 4.9379 | 4.945 | 4259332.0 |
| 2007-09-13 09:33:00 | AAPL | Stock | 4.9446 | 4.9468 | 4.9411 | 4.9451 | 1699572.0 |
| 2007-09-13 09:34:00 | AAPL | Stock | 4.9432 | 4.9432 | 4.9339 | 4.9371 | 3488604.0 |
| 2007-09-13 09:35:00 | AAPL | Stock | 4.9361 | 4.9382 | 4.9232 | 4.9304 | 4263700.0 |
| 2007-09-13 09:36:00 | AAPL | Stock | 4.9293 | 4.9375 | 4.9264 | 4.93 | 3273620.0 |
| 2007-09-13 09:37:00 | AAPL | Stock | 4.9289 | 4.9307 | 4.9196 | 4.9211 | 3290140.0 |
| 2007-09-13 09:38:00 | AAPL | Stock | 4.9211 | 4.9357 | 4.9207 | 4.9357 | 2594732.0 |
| 2007-09-13 09:39:00 | AAPL | Stock | 4.9354 | 4.9439 | 4.9354 | 4.9436 | 3199728.0 |
| 2007-09-13 09:40:00 | AAPL | Stock | 4.9436 | 4.9439 | 4.9307 | 4.9325 | 2800476.0 |
| 2007-09-13 09:41:00 | AAPL | Stock | 4.9329 | 4.9393 | 4.9311 | 4.9393 | 1216936.0 |
| 2007-09-13 09:42:00 | AAPL | Stock | 4.9391 | 4.9393 | 4.9329 | 4.9332 | 1053388.0 |
| 2007-09-13 09:43:00 | AAPL | Stock | 4.9332 | 4.9364 | 4.9286 | 4.9343 | 2279900.0 |
| 2007-09-13 09:44:00 | AAPL | Stock | 4.9329 | 4.9342 | 4.9246 | 4.9282 | 2638552.0 |
| 2007-09-13 09:45:00 | AAPL | Stock | 4.9275 | 4.9275 | 4.9239 | 4.9246 | 2288944.0 |
| 2007-09-13 09:46:00 | AAPL | Stock | 4.9243 | 4.9254 | 4.9218 | 4.9239 | 2970968.0 |
| 2007-09-13 09:47:00 | AAPL | Stock | 4.9231 | 4.925 | 4.9189 | 4.92 | 4145456.0 |
| 2007-09-13 09:48:00 | AAPL | Stock | 4.9211 | 4.935 | 4.9207 | 4.9349 | 3635576.0 |
| 2007-09-13 09:49:00 | AAPL | Stock | 4.9343 | 4.9393 | 4.9339 | 4.9375 | 2783788.0 |
| 2007-09-13 09:50:00 | AAPL | Stock | 4.9375 | 4.9518 | 4.9368 | 4.9514 | 6865404.0 |
| 2007-09-13 09:51:00 | AAPL | Stock | 4.9514 | 4.9518 | 4.9407 | 4.9454 | 2643256.0 |
| 2007-09-13 09:52:00 | AAPL | Stock | 4.9466 | 4.95 | 4.9446 | 4.95 | 2705808.0 |
| 2007-09-13 09:53:00 | AAPL | Stock | 4.9491 | 4.9504 | 4.9432 | 4.9454 | 2462516.0 |
| 2007-09-13 09:54:00 | AAPL | Stock | 4.9454 | 4.9457 | 4.94 | 4.9412 | 1483748.0 |
| 2007-09-13 09:55:00 | AAPL | Stock | 4.9414 | 4.9518 | 4.9409 | 4.9511 | 2280656.0 |
| 2007-09-13 09:56:00 | AAPL | Stock | 4.9511 | 4.9625 | 4.9482 | 4.9611 | 6325368.0 |
| 2007-09-13 09:57:00 | AAPL | Stock | 4.9614 | 4.9643 | 4.9604 | 4.9643 | 6576584.0 |
| 2007-09-13 09:58:00 | AAPL | Stock | 4.9639 | 4.9641 | 4.9504 | 4.9507 | 3897992.0 |
| 2007-09-13 09:59:00 | AAPL | Stock | 4.9504 | 4.9564 | 4.95 | 4.9504 | 2145192.0 |
| 2007-09-13 10:00:00 | AAPL | Stock | 4.9511 | 4.9514 | 4.9411 | 4.9446 | 4443628.0 |
| 2007-09-13 10:01:00 | AAPL | Stock | 4.9443 | 4.9507 | 4.9429 | 4.9496 | 2530948.0 |
| 2007-09-13 10:02:00 | AAPL | Stock | 4.9496 | 4.9543 | 4.9446 | 4.9457 | 3237052.0 |
| 2007-09-13 10:03:00 | AAPL | Stock | 4.9457 | 4.9457 | 4.9368 | 4.9407 | 2581292.0 |
| 2007-09-13 10:04:00 | AAPL | Stock | 4.9414 | 4.9421 | 4.9325 | 4.9379 | 2973292.0 |
| 2007-09-13 10:05:00 | AAPL | Stock | 4.9387 | 4.9393 | 4.9329 | 4.9329 | 2738568.0 |
| 2007-09-13 10:06:00 | AAPL | Stock | 4.9336 | 4.9429 | 4.9331 | 4.9382 | 2353596.0 |
| 2007-09-13 10:07:00 | AAPL | Stock | 4.9386 | 4.9386 | 4.9339 | 4.9354 | 1820616.0 |
| 2007-09-13 10:08:00 | AAPL | Stock | 4.935 | 4.9404 | 4.9321 | 4.94 | 2828224.0 |
| 2007-09-13 10:09:00 | AAPL | Stock | 4.9404 | 4.9432 | 4.9339 | 4.9346 | 2589328.0 |
| 2007-09-13 10:10:00 | AAPL | Stock | 4.9346 | 4.9375 | 4.9321 | 4.9343 | 2640624.0 |
| 2007-09-13 10:11:00 | AAPL | Stock | 4.9346 | 4.9375 | 4.9293 | 4.9303 | 2254420.0 |
| 2007-09-13 10:12:00 | AAPL | Stock | 4.9296 | 4.9311 | 4.9214 | 4.9247 | 4106368.0 |
| 2007-09-13 10:13:00 | AAPL | Stock | 4.9246 | 4.9268 | 4.9232 | 4.9264 | 2494800.0 |
| 2007-09-13 10:14:00 | AAPL | Stock | 4.9257 | 4.9268 | 4.92 | 4.9243 | 3372936.0 |
| 2007-09-13 10:15:00 | AAPL | Stock | 4.9239 | 4.9364 | 4.9239 | 4.9307 | 4050116.0 |
| 2007-09-13 10:16:00 | AAPL | Stock | 4.9311 | 4.9357 | 4.9311 | 4.9329 | 1502676.0 |
| 2007-09-13 10:17:00 | AAPL | Stock | 4.9325 | 4.935 | 4.9304 | 4.9329 | 1393560.0 |
| 2007-09-13 10:18:00 | AAPL | Stock | 4.9336 | 4.9404 | 4.9318 | 4.9354 | 2089528.0 |
| 2007-09-13 10:19:00 | AAPL | Stock | 4.9349 | 4.9386 | 4.9349 | 4.9379 | 1582476.0 |
> showing 50 of 881,341 rows — these rows as CSV