PREVIEW / stock_5min / 2006-04-19
file: by_date/stock_5min/2006/2006-04-19.parquet size: 3.1 MB rows: 227,241 symbols: 2,241
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 |
|---|---|---|---|---|---|---|---|
| 2006-04-19 04:15:00 | AAPL | Stock | 2.3857 | 2.3857 | 2.3857 | 2.3857 | 2800.0 |
| 2006-04-19 04:20:00 | AAPL | Stock | 2.3875 | 2.3875 | 2.3875 | 2.3875 | 5600.0 |
| 2006-04-19 04:25:00 | AAPL | Stock | 2.3893 | 2.3893 | 2.3893 | 2.3893 | 2800.0 |
| 2006-04-19 04:45:00 | AAPL | Stock | 2.3911 | 2.3911 | 2.3911 | 2.3911 | 2800.0 |
| 2006-04-19 05:00:00 | AAPL | Stock | 2.3893 | 2.3893 | 2.3893 | 2.3893 | 5600.0 |
| 2006-04-19 05:15:00 | AAPL | Stock | 2.3939 | 2.3939 | 2.3939 | 2.3939 | 5600.0 |
| 2006-04-19 07:05:00 | AAPL | Stock | 2.3982 | 2.3982 | 2.3982 | 2.3982 | 11200.0 |
| 2006-04-19 07:35:00 | AAPL | Stock | 2.4018 | 2.4018 | 2.4018 | 2.4018 | 14000.0 |
| 2006-04-19 07:40:00 | AAPL | Stock | 2.3932 | 2.3932 | 2.3932 | 2.3932 | 32760.0 |
| 2006-04-19 08:00:00 | AAPL | Stock | 2.4057 | 2.4057 | 2.3964 | 2.3964 | 693224.0 |
| 2006-04-19 08:05:00 | AAPL | Stock | 2.3968 | 2.4036 | 2.3964 | 2.4021 | 392224.0 |
| 2006-04-19 08:10:00 | AAPL | Stock | 2.4021 | 2.4036 | 2.3964 | 2.3968 | 293580.0 |
| 2006-04-19 08:15:00 | AAPL | Stock | 2.3982 | 2.4018 | 2.3982 | 2.4 | 146440.0 |
| 2006-04-19 08:20:00 | AAPL | Stock | 2.4 | 2.4 | 2.3961 | 2.3968 | 264656.0 |
| 2006-04-19 08:25:00 | AAPL | Stock | 2.3968 | 2.3968 | 2.3907 | 2.3936 | 611912.0 |
| 2006-04-19 08:30:00 | AAPL | Stock | 2.3911 | 2.3954 | 2.3896 | 2.3929 | 298172.0 |
| 2006-04-19 08:35:00 | AAPL | Stock | 2.3932 | 2.3954 | 2.3929 | 2.3954 | 142464.0 |
| 2006-04-19 08:40:00 | AAPL | Stock | 2.3954 | 2.3964 | 2.3946 | 2.3964 | 63000.0 |
| 2006-04-19 08:45:00 | AAPL | Stock | 2.3961 | 2.3961 | 2.3957 | 2.3961 | 48188.0 |
| 2006-04-19 08:50:00 | AAPL | Stock | 2.3961 | 2.3961 | 2.3875 | 2.3875 | 1251628.0 |
| 2006-04-19 08:55:00 | AAPL | Stock | 2.3929 | 2.3929 | 2.3893 | 2.3925 | 147000.0 |
| 2006-04-19 09:00:00 | AAPL | Stock | 2.39 | 2.3918 | 2.3871 | 2.3871 | 130200.0 |
| 2006-04-19 09:05:00 | AAPL | Stock | 2.3879 | 2.3879 | 2.3814 | 2.3829 | 823396.0 |
| 2006-04-19 09:10:00 | AAPL | Stock | 2.3832 | 2.3871 | 2.3829 | 2.3832 | 371952.0 |
| 2006-04-19 09:15:00 | AAPL | Stock | 2.3832 | 2.3868 | 2.3821 | 2.3868 | 413392.0 |
| 2006-04-19 09:20:00 | AAPL | Stock | 2.3868 | 2.3868 | 2.385 | 2.3857 | 202300.0 |
| 2006-04-19 09:25:00 | AAPL | Stock | 2.3857 | 2.3886 | 2.385 | 2.3886 | 675724.0 |
| 2006-04-19 09:30:00 | AAPL | Stock | 2.3864 | 2.3929 | 2.3757 | 2.3903 | 24937164.0 |
| 2006-04-19 09:35:00 | AAPL | Stock | 2.3896 | 2.3911 | 2.3804 | 2.3868 | 18581612.0 |
| 2006-04-19 09:40:00 | AAPL | Stock | 2.3871 | 2.3882 | 2.3789 | 2.3793 | 13538476.0 |
| 2006-04-19 09:45:00 | AAPL | Stock | 2.3796 | 2.3811 | 2.3686 | 2.3693 | 15876420.0 |
| 2006-04-19 09:50:00 | AAPL | Stock | 2.3697 | 2.385 | 2.3689 | 2.3832 | 12128676.0 |
| 2006-04-19 09:55:00 | AAPL | Stock | 2.3832 | 2.3846 | 2.3696 | 2.3711 | 12573624.0 |
| 2006-04-19 10:00:00 | AAPL | Stock | 2.3714 | 2.3721 | 2.3654 | 2.3682 | 13189456.0 |
| 2006-04-19 10:05:00 | AAPL | Stock | 2.3682 | 2.3686 | 2.3454 | 2.3521 | 32114236.0 |
| 2006-04-19 10:10:00 | AAPL | Stock | 2.3521 | 2.3536 | 2.3432 | 2.3446 | 17733520.0 |
| 2006-04-19 10:15:00 | AAPL | Stock | 2.3442 | 2.3532 | 2.3442 | 2.3532 | 12285728.0 |
| 2006-04-19 10:20:00 | AAPL | Stock | 2.3529 | 2.3568 | 2.3511 | 2.3568 | 10739372.0 |
| 2006-04-19 10:25:00 | AAPL | Stock | 2.3568 | 2.3611 | 2.3564 | 2.3579 | 12239696.0 |
| 2006-04-19 10:30:00 | AAPL | Stock | 2.3579 | 2.3582 | 2.3471 | 2.3504 | 14794696.0 |
| 2006-04-19 10:35:00 | AAPL | Stock | 2.35 | 2.3518 | 2.3446 | 2.3457 | 10041108.0 |
| 2006-04-19 10:40:00 | AAPL | Stock | 2.3461 | 2.3557 | 2.3436 | 2.3543 | 11609052.0 |
| 2006-04-19 10:45:00 | AAPL | Stock | 2.3542 | 2.3593 | 2.3536 | 2.3539 | 11278092.0 |
| 2006-04-19 10:50:00 | AAPL | Stock | 2.3536 | 2.3593 | 2.3504 | 2.3589 | 9994600.0 |
| 2006-04-19 10:55:00 | AAPL | Stock | 2.3589 | 2.3629 | 2.3547 | 2.3561 | 10228064.0 |
| 2006-04-19 11:00:00 | AAPL | Stock | 2.3557 | 2.3611 | 2.3536 | 2.3604 | 6193600.0 |
| 2006-04-19 11:05:00 | AAPL | Stock | 2.3596 | 2.3682 | 2.3536 | 2.3661 | 15802584.0 |
| 2006-04-19 11:10:00 | AAPL | Stock | 2.3664 | 2.3664 | 2.3586 | 2.3589 | 7021784.0 |
| 2006-04-19 11:15:00 | AAPL | Stock | 2.3589 | 2.3646 | 2.3589 | 2.3604 | 5656700.0 |
| 2006-04-19 11:20:00 | AAPL | Stock | 2.3611 | 2.3643 | 2.36 | 2.3636 | 4791640.0 |
> showing 50 of 227,241 rows — these rows as CSV