PREVIEW / stock_5min / 2008-06-17
file: by_date/stock_5min/2008/2008-06-17.parquet size: 4.4 MB rows: 312,033 symbols: 3,312
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 |
|---|---|---|---|---|---|---|---|
| 2008-06-17 07:05:00 | AAPL | Stock | 6.3425 | 6.3425 | 6.3425 | 6.3425 | 5600.0 |
| 2008-06-17 07:10:00 | AAPL | Stock | 6.3518 | 6.3518 | 6.3518 | 6.3518 | 13440.0 |
| 2008-06-17 07:25:00 | AAPL | Stock | 6.3536 | 6.3536 | 6.3536 | 6.3536 | 2800.0 |
| 2008-06-17 07:35:00 | AAPL | Stock | 6.3461 | 6.3536 | 6.3446 | 6.3536 | 58240.0 |
| 2008-06-17 07:45:00 | AAPL | Stock | 6.3464 | 6.3464 | 6.3464 | 6.3464 | 25452.0 |
| 2008-06-17 07:50:00 | AAPL | Stock | 6.3446 | 6.3464 | 6.3393 | 6.3464 | 67200.0 |
| 2008-06-17 07:55:00 | AAPL | Stock | 6.3482 | 6.3482 | 6.3464 | 6.3464 | 58800.0 |
| 2008-06-17 08:00:00 | AAPL | Stock | 6.3482 | 6.35 | 6.3157 | 6.3479 | 512680.0 |
| 2008-06-17 08:05:00 | AAPL | Stock | 6.3482 | 6.3482 | 6.3393 | 6.3475 | 170240.0 |
| 2008-06-17 08:10:00 | AAPL | Stock | 6.3482 | 6.3518 | 6.3464 | 6.3471 | 233828.0 |
| 2008-06-17 08:15:00 | AAPL | Stock | 6.3464 | 6.3464 | 6.3336 | 6.3375 | 256732.0 |
| 2008-06-17 08:20:00 | AAPL | Stock | 6.3379 | 6.3429 | 6.3379 | 6.3393 | 142184.0 |
| 2008-06-17 08:25:00 | AAPL | Stock | 6.3389 | 6.3443 | 6.3214 | 6.3375 | 1337336.0 |
| 2008-06-17 08:30:00 | AAPL | Stock | 6.3375 | 6.3464 | 6.3304 | 6.3357 | 631120.0 |
| 2008-06-17 08:35:00 | AAPL | Stock | 6.3357 | 6.3496 | 6.3354 | 6.3421 | 391468.0 |
| 2008-06-17 08:40:00 | AAPL | Stock | 6.345 | 6.3529 | 6.345 | 6.3521 | 862792.0 |
| 2008-06-17 08:45:00 | AAPL | Stock | 6.3511 | 6.3536 | 6.3493 | 6.3536 | 373240.0 |
| 2008-06-17 08:50:00 | AAPL | Stock | 6.3543 | 6.3586 | 6.3493 | 6.355 | 759920.0 |
| 2008-06-17 08:55:00 | AAPL | Stock | 6.3529 | 6.3571 | 6.3525 | 6.3525 | 432684.0 |
| 2008-06-17 09:00:00 | AAPL | Stock | 6.3529 | 6.3625 | 6.3507 | 6.3611 | 643300.0 |
| 2008-06-17 09:05:00 | AAPL | Stock | 6.3618 | 6.3811 | 6.3618 | 6.3707 | 969892.0 |
| 2008-06-17 09:10:00 | AAPL | Stock | 6.3686 | 6.3754 | 6.3593 | 6.3657 | 500164.0 |
| 2008-06-17 09:15:00 | AAPL | Stock | 6.365 | 6.3664 | 6.3518 | 6.3561 | 540344.0 |
| 2008-06-17 09:20:00 | AAPL | Stock | 6.3561 | 6.3586 | 6.3536 | 6.3586 | 466760.0 |
| 2008-06-17 09:25:00 | AAPL | Stock | 6.3596 | 6.3657 | 6.3564 | 6.3604 | 165256.0 |
| 2008-06-17 09:30:00 | AAPL | Stock | 6.3604 | 6.3907 | 6.3393 | 6.3804 | 34032852.0 |
| 2008-06-17 09:35:00 | AAPL | Stock | 6.3804 | 6.3814 | 6.3393 | 6.3639 | 25697392.0 |
| 2008-06-17 09:40:00 | AAPL | Stock | 6.3636 | 6.3854 | 6.3361 | 6.3504 | 19075168.0 |
| 2008-06-17 09:45:00 | AAPL | Stock | 6.3514 | 6.3964 | 6.3411 | 6.3918 | 24686200.0 |
| 2008-06-17 09:50:00 | AAPL | Stock | 6.3921 | 6.4168 | 6.3866 | 6.4161 | 23166220.0 |
| 2008-06-17 09:55:00 | AAPL | Stock | 6.4161 | 6.4211 | 6.3982 | 6.4111 | 17174500.0 |
| 2008-06-17 10:00:00 | AAPL | Stock | 6.4111 | 6.4393 | 6.4107 | 6.4364 | 19934544.0 |
| 2008-06-17 10:05:00 | AAPL | Stock | 6.4364 | 6.4429 | 6.4161 | 6.4218 | 16687804.0 |
| 2008-06-17 10:10:00 | AAPL | Stock | 6.4211 | 6.4429 | 6.42 | 6.4286 | 19021576.0 |
| 2008-06-17 10:15:00 | AAPL | Stock | 6.4271 | 6.4361 | 6.4168 | 6.43 | 12027428.0 |
| 2008-06-17 10:20:00 | AAPL | Stock | 6.4296 | 6.4321 | 6.3911 | 6.4004 | 19819996.0 |
| 2008-06-17 10:25:00 | AAPL | Stock | 6.4014 | 6.4014 | 6.3775 | 6.395 | 11707724.0 |
| 2008-06-17 10:30:00 | AAPL | Stock | 6.395 | 6.4286 | 6.3863 | 6.4275 | 13037752.0 |
| 2008-06-17 10:35:00 | AAPL | Stock | 6.4278 | 6.4282 | 6.415 | 6.4243 | 8743924.0 |
| 2008-06-17 10:40:00 | AAPL | Stock | 6.4243 | 6.4321 | 6.4132 | 6.4218 | 13242712.0 |
| 2008-06-17 10:45:00 | AAPL | Stock | 6.4218 | 6.4393 | 6.4157 | 6.4361 | 13955032.0 |
| 2008-06-17 10:50:00 | AAPL | Stock | 6.4357 | 6.4514 | 6.4321 | 6.4454 | 15366344.0 |
| 2008-06-17 10:55:00 | AAPL | Stock | 6.4461 | 6.4714 | 6.4461 | 6.4572 | 19260192.0 |
| 2008-06-17 11:00:00 | AAPL | Stock | 6.4579 | 6.4732 | 6.4575 | 6.4646 | 11574276.0 |
| 2008-06-17 11:05:00 | AAPL | Stock | 6.4646 | 6.4739 | 6.4593 | 6.4618 | 12862136.0 |
| 2008-06-17 11:10:00 | AAPL | Stock | 6.4621 | 6.4693 | 6.4536 | 6.4668 | 8403164.0 |
| 2008-06-17 11:15:00 | AAPL | Stock | 6.4681 | 6.4714 | 6.4486 | 6.4582 | 8475208.0 |
| 2008-06-17 11:20:00 | AAPL | Stock | 6.4593 | 6.4682 | 6.4521 | 6.4596 | 7080304.0 |
| 2008-06-17 11:25:00 | AAPL | Stock | 6.4582 | 6.4584 | 6.4379 | 6.4429 | 10936604.0 |
| 2008-06-17 11:30:00 | AAPL | Stock | 6.4429 | 6.4493 | 6.4332 | 6.4421 | 8636684.0 |
> showing 50 of 312,033 rows — these rows as CSV