PREVIEW / stock_5min / 2009-11-17
file: by_date/stock_5min/2009/2009-11-17.parquet size: 4.6 MB rows: 315,556 symbols: 3,421
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-17 07:05:00 | AAPL | Stock | 7.35 | 7.35 | 7.35 | 7.35 | 2800.0 |
| 2009-11-17 07:15:00 | AAPL | Stock | 7.3571 | 7.3571 | 7.3571 | 7.3571 | 2800.0 |
| 2009-11-17 07:20:00 | AAPL | Stock | 7.3571 | 7.3571 | 7.3571 | 7.3571 | 5600.0 |
| 2009-11-17 07:30:00 | AAPL | Stock | 7.3571 | 7.3571 | 7.3411 | 7.3411 | 25200.0 |
| 2009-11-17 07:35:00 | AAPL | Stock | 7.3414 | 7.3414 | 7.3414 | 7.3414 | 2800.0 |
| 2009-11-17 08:00:00 | AAPL | Stock | 7.3546 | 7.3639 | 7.3546 | 7.3607 | 80332.0 |
| 2009-11-17 08:05:00 | AAPL | Stock | 7.3557 | 7.36 | 7.3554 | 7.3554 | 23380.0 |
| 2009-11-17 08:10:00 | AAPL | Stock | 7.3561 | 7.3607 | 7.3546 | 7.3607 | 27860.0 |
| 2009-11-17 08:15:00 | AAPL | Stock | 7.3596 | 7.36 | 7.3596 | 7.36 | 8400.0 |
| 2009-11-17 08:20:00 | AAPL | Stock | 7.3589 | 7.3607 | 7.3571 | 7.3571 | 29260.0 |
| 2009-11-17 08:25:00 | AAPL | Stock | 7.3579 | 7.3586 | 7.3579 | 7.3586 | 5600.0 |
| 2009-11-17 08:30:00 | AAPL | Stock | 7.3571 | 7.36 | 7.3511 | 7.3511 | 135464.0 |
| 2009-11-17 08:35:00 | AAPL | Stock | 7.3575 | 7.3586 | 7.3536 | 7.3586 | 68320.0 |
| 2009-11-17 08:40:00 | AAPL | Stock | 7.3582 | 7.3582 | 7.3582 | 7.3582 | 2800.0 |
| 2009-11-17 08:45:00 | AAPL | Stock | 7.3571 | 7.3675 | 7.3568 | 7.3646 | 252448.0 |
| 2009-11-17 08:50:00 | AAPL | Stock | 7.3646 | 7.3743 | 7.3643 | 7.3732 | 37408.0 |
| 2009-11-17 08:55:00 | AAPL | Stock | 7.3682 | 7.3682 | 7.3661 | 7.3664 | 21000.0 |
| 2009-11-17 09:00:00 | AAPL | Stock | 7.3696 | 7.3696 | 7.3643 | 7.3679 | 91000.0 |
| 2009-11-17 09:05:00 | AAPL | Stock | 7.3679 | 7.3679 | 7.3679 | 7.3679 | 33600.0 |
| 2009-11-17 09:10:00 | AAPL | Stock | 7.3679 | 7.3732 | 7.3639 | 7.3732 | 47600.0 |
| 2009-11-17 09:15:00 | AAPL | Stock | 7.3679 | 7.3679 | 7.3611 | 7.3657 | 137592.0 |
| 2009-11-17 09:20:00 | AAPL | Stock | 7.3632 | 7.3661 | 7.3614 | 7.3614 | 76160.0 |
| 2009-11-17 09:25:00 | AAPL | Stock | 7.3618 | 7.3618 | 7.3589 | 7.3596 | 56560.0 |
| 2009-11-17 09:30:00 | AAPL | Stock | 7.36 | 7.3964 | 7.3596 | 7.3868 | 18208568.0 |
| 2009-11-17 09:35:00 | AAPL | Stock | 7.3871 | 7.4018 | 7.375 | 7.3879 | 11765460.0 |
| 2009-11-17 09:40:00 | AAPL | Stock | 7.3879 | 7.4086 | 7.385 | 7.3939 | 9763684.0 |
| 2009-11-17 09:45:00 | AAPL | Stock | 7.395 | 7.4007 | 7.3625 | 7.3771 | 11472524.0 |
| 2009-11-17 09:50:00 | AAPL | Stock | 7.3782 | 7.3957 | 7.3768 | 7.3825 | 6134156.0 |
| 2009-11-17 09:55:00 | AAPL | Stock | 7.3832 | 7.3961 | 7.38 | 7.3839 | 5067384.0 |
| 2009-11-17 10:00:00 | AAPL | Stock | 7.385 | 7.39 | 7.3732 | 7.3768 | 4429376.0 |
| 2009-11-17 10:05:00 | AAPL | Stock | 7.3771 | 7.3829 | 7.3639 | 7.3699 | 5294968.0 |
| 2009-11-17 10:10:00 | AAPL | Stock | 7.3693 | 7.3786 | 7.3643 | 7.3746 | 4402552.0 |
| 2009-11-17 10:15:00 | AAPL | Stock | 7.3736 | 7.3839 | 7.37 | 7.3807 | 3382568.0 |
| 2009-11-17 10:20:00 | AAPL | Stock | 7.3814 | 7.3871 | 7.3771 | 7.3861 | 3706864.0 |
| 2009-11-17 10:25:00 | AAPL | Stock | 7.3857 | 7.3871 | 7.3746 | 7.3746 | 2873948.0 |
| 2009-11-17 10:30:00 | AAPL | Stock | 7.3746 | 7.3789 | 7.3679 | 7.3757 | 3065580.0 |
| 2009-11-17 10:35:00 | AAPL | Stock | 7.375 | 7.3779 | 7.3661 | 7.367 | 2846144.0 |
| 2009-11-17 10:40:00 | AAPL | Stock | 7.3675 | 7.3675 | 7.3521 | 7.355 | 7066696.0 |
| 2009-11-17 10:45:00 | AAPL | Stock | 7.3548 | 7.3632 | 7.3536 | 7.3546 | 2601228.0 |
| 2009-11-17 10:50:00 | AAPL | Stock | 7.355 | 7.3625 | 7.35 | 7.3607 | 3578344.0 |
| 2009-11-17 10:55:00 | AAPL | Stock | 7.3611 | 7.3657 | 7.3593 | 7.3643 | 2333856.0 |
| 2009-11-17 11:00:00 | AAPL | Stock | 7.365 | 7.3661 | 7.3546 | 7.3564 | 3125136.0 |
| 2009-11-17 11:05:00 | AAPL | Stock | 7.3571 | 7.365 | 7.3504 | 7.3629 | 3682252.0 |
| 2009-11-17 11:10:00 | AAPL | Stock | 7.3622 | 7.365 | 7.3536 | 7.3569 | 3041948.0 |
| 2009-11-17 11:15:00 | AAPL | Stock | 7.3568 | 7.3568 | 7.3436 | 7.3461 | 5858748.0 |
| 2009-11-17 11:20:00 | AAPL | Stock | 7.3464 | 7.3529 | 7.3443 | 7.3489 | 2469404.0 |
| 2009-11-17 11:25:00 | AAPL | Stock | 7.3489 | 7.3564 | 7.3482 | 7.3557 | 2370228.0 |
| 2009-11-17 11:30:00 | AAPL | Stock | 7.3557 | 7.3561 | 7.3482 | 7.3482 | 2274328.0 |
| 2009-11-17 11:35:00 | AAPL | Stock | 7.3482 | 7.3625 | 7.3471 | 7.3614 | 3494764.0 |
| 2009-11-17 11:40:00 | AAPL | Stock | 7.3614 | 7.3625 | 7.3518 | 7.3554 | 2362696.0 |
> showing 50 of 315,556 rows — these rows as CSV