PREVIEW / stock_5min / 2007-04-25
file: by_date/stock_5min/2007/2007-04-25.parquet size: 3.7 MB rows: 262,747 symbols: 2,601
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-04-25 06:55:00 | AAPL | Stock | 3.3604 | 3.3604 | 3.3604 | 3.3604 | 2800.0 |
| 2007-04-25 07:00:00 | AAPL | Stock | 3.3604 | 3.3604 | 3.3604 | 3.3604 | 5880.0 |
| 2007-04-25 07:05:00 | AAPL | Stock | 3.3632 | 3.3632 | 3.3632 | 3.3632 | 2800.0 |
| 2007-04-25 07:10:00 | AAPL | Stock | 3.3629 | 3.3639 | 3.3629 | 3.3639 | 53480.0 |
| 2007-04-25 07:15:00 | AAPL | Stock | 3.3643 | 3.3643 | 3.3643 | 3.3643 | 14000.0 |
| 2007-04-25 07:30:00 | AAPL | Stock | 3.3643 | 3.3675 | 3.3643 | 3.3643 | 16800.0 |
| 2007-04-25 07:35:00 | AAPL | Stock | 3.3643 | 3.3689 | 3.3643 | 3.3689 | 53200.0 |
| 2007-04-25 07:40:00 | AAPL | Stock | 3.3654 | 3.3654 | 3.3646 | 3.3646 | 14000.0 |
| 2007-04-25 07:45:00 | AAPL | Stock | 3.3643 | 3.3729 | 3.3643 | 3.3682 | 120400.0 |
| 2007-04-25 07:50:00 | AAPL | Stock | 3.3646 | 3.3654 | 3.3646 | 3.3654 | 28000.0 |
| 2007-04-25 07:55:00 | AAPL | Stock | 3.3643 | 3.3643 | 3.3629 | 3.3629 | 200200.0 |
| 2007-04-25 08:00:00 | AAPL | Stock | 3.3632 | 3.3679 | 3.3596 | 3.3643 | 697340.0 |
| 2007-04-25 08:05:00 | AAPL | Stock | 3.3643 | 3.3671 | 3.3625 | 3.365 | 182000.0 |
| 2007-04-25 08:10:00 | AAPL | Stock | 3.365 | 3.3686 | 3.365 | 3.3686 | 378224.0 |
| 2007-04-25 08:15:00 | AAPL | Stock | 3.3686 | 3.3743 | 3.3675 | 3.3743 | 451696.0 |
| 2007-04-25 08:20:00 | AAPL | Stock | 3.3739 | 3.3786 | 3.3721 | 3.375 | 434112.0 |
| 2007-04-25 08:25:00 | AAPL | Stock | 3.3732 | 3.3764 | 3.3696 | 3.3714 | 304668.0 |
| 2007-04-25 08:30:00 | AAPL | Stock | 3.3689 | 3.3714 | 3.3675 | 3.3679 | 158956.0 |
| 2007-04-25 08:35:00 | AAPL | Stock | 3.3679 | 3.3679 | 3.365 | 3.365 | 415632.0 |
| 2007-04-25 08:40:00 | AAPL | Stock | 3.3661 | 3.3661 | 3.3643 | 3.3661 | 99456.0 |
| 2007-04-25 08:45:00 | AAPL | Stock | 3.3679 | 3.3696 | 3.365 | 3.3668 | 89600.0 |
| 2007-04-25 08:50:00 | AAPL | Stock | 3.3654 | 3.3661 | 3.3589 | 3.3621 | 235676.0 |
| 2007-04-25 08:55:00 | AAPL | Stock | 3.3589 | 3.3657 | 3.3575 | 3.3625 | 202972.0 |
| 2007-04-25 09:00:00 | AAPL | Stock | 3.3639 | 3.3661 | 3.3629 | 3.3661 | 198828.0 |
| 2007-04-25 09:05:00 | AAPL | Stock | 3.3643 | 3.3661 | 3.3625 | 3.3643 | 409640.0 |
| 2007-04-25 09:10:00 | AAPL | Stock | 3.3661 | 3.3696 | 3.3661 | 3.3679 | 200200.0 |
| 2007-04-25 09:15:00 | AAPL | Stock | 3.3679 | 3.3686 | 3.3679 | 3.3686 | 112000.0 |
| 2007-04-25 09:20:00 | AAPL | Stock | 3.3679 | 3.3686 | 3.3679 | 3.3686 | 95200.0 |
| 2007-04-25 09:25:00 | AAPL | Stock | 3.3661 | 3.3679 | 3.3629 | 3.3654 | 891324.0 |
| 2007-04-25 09:30:00 | AAPL | Stock | 3.3654 | 3.375 | 3.35 | 3.3732 | 22767332.0 |
| 2007-04-25 09:35:00 | AAPL | Stock | 3.3736 | 3.3821 | 3.3711 | 3.3711 | 25546164.0 |
| 2007-04-25 09:40:00 | AAPL | Stock | 3.3714 | 3.3761 | 3.3604 | 3.3665 | 17805340.0 |
| 2007-04-25 09:45:00 | AAPL | Stock | 3.3664 | 3.3668 | 3.3546 | 3.3579 | 13724424.0 |
| 2007-04-25 09:50:00 | AAPL | Stock | 3.3582 | 3.3646 | 3.3536 | 3.3625 | 11987752.0 |
| 2007-04-25 09:55:00 | AAPL | Stock | 3.3629 | 3.3654 | 3.3586 | 3.3603 | 8437380.0 |
| 2007-04-25 10:00:00 | AAPL | Stock | 3.36 | 3.3664 | 3.3532 | 3.3586 | 10599372.0 |
| 2007-04-25 10:05:00 | AAPL | Stock | 3.3589 | 3.3618 | 3.3561 | 3.3596 | 8078308.0 |
| 2007-04-25 10:10:00 | AAPL | Stock | 3.3596 | 3.3604 | 3.3532 | 3.3571 | 9658936.0 |
| 2007-04-25 10:15:00 | AAPL | Stock | 3.3575 | 3.3586 | 3.3532 | 3.3564 | 8674540.0 |
| 2007-04-25 10:20:00 | AAPL | Stock | 3.3568 | 3.3661 | 3.3557 | 3.3661 | 8755180.0 |
| 2007-04-25 10:25:00 | AAPL | Stock | 3.3654 | 3.3711 | 3.3625 | 3.3693 | 11399724.0 |
| 2007-04-25 10:30:00 | AAPL | Stock | 3.3693 | 3.3693 | 3.3629 | 3.3629 | 6058948.0 |
| 2007-04-25 10:35:00 | AAPL | Stock | 3.3632 | 3.3654 | 3.36 | 3.3639 | 8140216.0 |
| 2007-04-25 10:40:00 | AAPL | Stock | 3.3636 | 3.3636 | 3.3611 | 3.3621 | 5014940.0 |
| 2007-04-25 10:45:00 | AAPL | Stock | 3.3618 | 3.3664 | 3.3611 | 3.3658 | 9426648.0 |
| 2007-04-25 10:50:00 | AAPL | Stock | 3.3659 | 3.3664 | 3.3589 | 3.3621 | 9081184.0 |
| 2007-04-25 10:55:00 | AAPL | Stock | 3.3621 | 3.3646 | 3.36 | 3.3611 | 4704112.0 |
| 2007-04-25 11:00:00 | AAPL | Stock | 3.3614 | 3.3646 | 3.3604 | 3.3643 | 4819164.0 |
| 2007-04-25 11:05:00 | AAPL | Stock | 3.3643 | 3.3661 | 3.3604 | 3.3604 | 4183060.0 |
| 2007-04-25 11:10:00 | AAPL | Stock | 3.3604 | 3.3671 | 3.3604 | 3.3661 | 7445004.0 |
> showing 50 of 262,747 rows — these rows as CSV