PREVIEW / stock_5min / 2005-06-03
file: by_date/stock_5min/2005/2005-06-03.parquet size: 2.7 MB rows: 194,449 symbols: 1,975
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 |
|---|---|---|---|---|---|---|---|
| 2005-06-03 05:55:00 | AAPL | Stock | 1.405 | 1.405 | 1.405 | 1.405 | 2800.0 |
| 2005-06-03 07:00:00 | AAPL | Stock | 1.4118 | 1.425 | 1.4118 | 1.4121 | 39200.0 |
| 2005-06-03 07:10:00 | AAPL | Stock | 1.4018 | 1.4018 | 1.4018 | 1.4018 | 28000.0 |
| 2005-06-03 07:20:00 | AAPL | Stock | 1.4036 | 1.4036 | 1.4036 | 1.4036 | 14000.0 |
| 2005-06-03 07:25:00 | AAPL | Stock | 1.3961 | 1.3961 | 1.3961 | 1.3961 | 2800.0 |
| 2005-06-03 07:30:00 | AAPL | Stock | 1.4032 | 1.4032 | 1.3929 | 1.3929 | 182000.0 |
| 2005-06-03 07:35:00 | AAPL | Stock | 1.3925 | 1.3925 | 1.3764 | 1.3796 | 467880.0 |
| 2005-06-03 07:40:00 | AAPL | Stock | 1.3796 | 1.3796 | 1.3739 | 1.375 | 819840.0 |
| 2005-06-03 07:45:00 | AAPL | Stock | 1.375 | 1.375 | 1.3664 | 1.3679 | 668640.0 |
| 2005-06-03 07:50:00 | AAPL | Stock | 1.3707 | 1.3718 | 1.3614 | 1.3646 | 251020.0 |
| 2005-06-03 07:55:00 | AAPL | Stock | 1.3671 | 1.3675 | 1.3561 | 1.3607 | 1445612.0 |
| 2005-06-03 08:00:00 | AAPL | Stock | 1.3607 | 1.3804 | 1.3561 | 1.3768 | 7306012.0 |
| 2005-06-03 08:05:00 | AAPL | Stock | 1.3761 | 1.3768 | 1.3668 | 1.3746 | 1932504.0 |
| 2005-06-03 08:10:00 | AAPL | Stock | 1.3746 | 1.3821 | 1.3725 | 1.3725 | 2958564.0 |
| 2005-06-03 08:15:00 | AAPL | Stock | 1.3729 | 1.3768 | 1.3696 | 1.3725 | 2724176.0 |
| 2005-06-03 08:20:00 | AAPL | Stock | 1.3732 | 1.3739 | 1.3689 | 1.3704 | 953288.0 |
| 2005-06-03 08:25:00 | AAPL | Stock | 1.3704 | 1.375 | 1.3696 | 1.3729 | 1946784.0 |
| 2005-06-03 08:30:00 | AAPL | Stock | 1.3718 | 1.3761 | 1.37 | 1.375 | 2735208.0 |
| 2005-06-03 08:35:00 | AAPL | Stock | 1.375 | 1.375 | 1.3704 | 1.3729 | 1341872.0 |
| 2005-06-03 08:40:00 | AAPL | Stock | 1.3718 | 1.3725 | 1.365 | 1.3671 | 1629264.0 |
| 2005-06-03 08:45:00 | AAPL | Stock | 1.3671 | 1.37 | 1.3643 | 1.3689 | 810264.0 |
| 2005-06-03 08:50:00 | AAPL | Stock | 1.3689 | 1.3711 | 1.3664 | 1.3696 | 542864.0 |
| 2005-06-03 08:55:00 | AAPL | Stock | 1.3704 | 1.3704 | 1.3675 | 1.3686 | 469588.0 |
| 2005-06-03 09:00:00 | AAPL | Stock | 1.3686 | 1.3696 | 1.3675 | 1.3689 | 1975680.0 |
| 2005-06-03 09:05:00 | AAPL | Stock | 1.3689 | 1.3714 | 1.3675 | 1.3704 | 864024.0 |
| 2005-06-03 09:10:00 | AAPL | Stock | 1.3696 | 1.3707 | 1.3679 | 1.3689 | 1544928.0 |
| 2005-06-03 09:15:00 | AAPL | Stock | 1.3689 | 1.3689 | 1.3539 | 1.3557 | 3736600.0 |
| 2005-06-03 09:20:00 | AAPL | Stock | 1.3561 | 1.3611 | 1.3561 | 1.3607 | 4441332.0 |
| 2005-06-03 09:25:00 | AAPL | Stock | 1.3614 | 1.3671 | 1.3589 | 1.3632 | 13018768.0 |
| 2005-06-03 09:30:00 | AAPL | Stock | 1.3629 | 1.3729 | 1.3529 | 1.37 | 66256456.0 |
| 2005-06-03 09:35:00 | AAPL | Stock | 1.3704 | 1.3711 | 1.3618 | 1.3711 | 36565004.0 |
| 2005-06-03 09:40:00 | AAPL | Stock | 1.3707 | 1.3714 | 1.3636 | 1.3639 | 19269040.0 |
| 2005-06-03 09:45:00 | AAPL | Stock | 1.3639 | 1.3711 | 1.3632 | 1.3693 | 23155048.0 |
| 2005-06-03 09:50:00 | AAPL | Stock | 1.3693 | 1.3779 | 1.3668 | 1.3729 | 28392644.0 |
| 2005-06-03 09:55:00 | AAPL | Stock | 1.3729 | 1.3736 | 1.3689 | 1.3704 | 15033340.0 |
| 2005-06-03 10:00:00 | AAPL | Stock | 1.3707 | 1.375 | 1.3696 | 1.3714 | 21308616.0 |
| 2005-06-03 10:05:00 | AAPL | Stock | 1.3714 | 1.3729 | 1.3657 | 1.3661 | 17648260.0 |
| 2005-06-03 10:10:00 | AAPL | Stock | 1.3661 | 1.3668 | 1.3632 | 1.3646 | 18276720.0 |
| 2005-06-03 10:15:00 | AAPL | Stock | 1.3646 | 1.3657 | 1.3557 | 1.3568 | 23809548.0 |
| 2005-06-03 10:20:00 | AAPL | Stock | 1.3568 | 1.3657 | 1.3554 | 1.3571 | 27655292.0 |
| 2005-06-03 10:25:00 | AAPL | Stock | 1.3575 | 1.3579 | 1.3496 | 1.3518 | 25941860.0 |
| 2005-06-03 10:30:00 | AAPL | Stock | 1.3518 | 1.3554 | 1.3489 | 1.3554 | 24432660.0 |
| 2005-06-03 10:35:00 | AAPL | Stock | 1.3554 | 1.3586 | 1.355 | 1.3568 | 18124540.0 |
| 2005-06-03 10:40:00 | AAPL | Stock | 1.3568 | 1.3571 | 1.3536 | 1.3554 | 11840248.0 |
| 2005-06-03 10:45:00 | AAPL | Stock | 1.3554 | 1.3554 | 1.3511 | 1.3536 | 11372732.0 |
| 2005-06-03 10:50:00 | AAPL | Stock | 1.3536 | 1.3607 | 1.3536 | 1.3596 | 16578968.0 |
| 2005-06-03 10:55:00 | AAPL | Stock | 1.3596 | 1.3611 | 1.3561 | 1.3561 | 23520952.0 |
| 2005-06-03 11:00:00 | AAPL | Stock | 1.3561 | 1.3586 | 1.3543 | 1.3579 | 8483188.0 |
| 2005-06-03 11:05:00 | AAPL | Stock | 1.3582 | 1.3589 | 1.3568 | 1.3571 | 10976644.0 |
| 2005-06-03 11:10:00 | AAPL | Stock | 1.3571 | 1.3611 | 1.3571 | 1.3589 | 7272692.0 |
> showing 50 of 194,449 rows — these rows as CSV