PREVIEW / stock_5min / 2005-07-13
file: by_date/stock_5min/2005/2005-07-13.parquet size: 2.6 MB rows: 193,362 symbols: 2,030
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-07-13 07:40:00 | AAPL | Stock | 1.375 | 1.375 | 1.375 | 1.375 | 5600.0 |
| 2005-07-13 07:45:00 | AAPL | Stock | 1.3646 | 1.3646 | 1.3646 | 1.3646 | 249200.0 |
| 2005-07-13 07:50:00 | AAPL | Stock | 1.3646 | 1.3646 | 1.3643 | 1.3646 | 138600.0 |
| 2005-07-13 08:00:00 | AAPL | Stock | 1.3611 | 1.3679 | 1.3607 | 1.3679 | 41300.0 |
| 2005-07-13 08:05:00 | AAPL | Stock | 1.3718 | 1.3732 | 1.37 | 1.37 | 30800.0 |
| 2005-07-13 08:10:00 | AAPL | Stock | 1.3679 | 1.3714 | 1.3679 | 1.3696 | 148400.0 |
| 2005-07-13 08:15:00 | AAPL | Stock | 1.3696 | 1.3721 | 1.3696 | 1.3696 | 33600.0 |
| 2005-07-13 08:20:00 | AAPL | Stock | 1.3714 | 1.3714 | 1.3679 | 1.3679 | 110460.0 |
| 2005-07-13 08:25:00 | AAPL | Stock | 1.3696 | 1.3729 | 1.3693 | 1.3729 | 29400.0 |
| 2005-07-13 08:30:00 | AAPL | Stock | 1.3686 | 1.3696 | 1.3679 | 1.3696 | 105000.0 |
| 2005-07-13 08:35:00 | AAPL | Stock | 1.3693 | 1.3696 | 1.3679 | 1.3679 | 122724.0 |
| 2005-07-13 08:40:00 | AAPL | Stock | 1.3675 | 1.3675 | 1.3643 | 1.3646 | 77700.0 |
| 2005-07-13 08:45:00 | AAPL | Stock | 1.3646 | 1.3661 | 1.3646 | 1.3654 | 46200.0 |
| 2005-07-13 08:50:00 | AAPL | Stock | 1.3657 | 1.3657 | 1.3657 | 1.3657 | 5600.0 |
| 2005-07-13 08:55:00 | AAPL | Stock | 1.3668 | 1.3668 | 1.3668 | 1.3668 | 61600.0 |
| 2005-07-13 09:00:00 | AAPL | Stock | 1.3671 | 1.3675 | 1.3518 | 1.3536 | 1181572.0 |
| 2005-07-13 09:05:00 | AAPL | Stock | 1.3607 | 1.3607 | 1.3536 | 1.3571 | 74060.0 |
| 2005-07-13 09:10:00 | AAPL | Stock | 1.3571 | 1.3582 | 1.355 | 1.3571 | 157892.0 |
| 2005-07-13 09:15:00 | AAPL | Stock | 1.3543 | 1.3543 | 1.3536 | 1.3536 | 22400.0 |
| 2005-07-13 09:20:00 | AAPL | Stock | 1.3571 | 1.3582 | 1.3571 | 1.3582 | 36400.0 |
| 2005-07-13 09:25:00 | AAPL | Stock | 1.3593 | 1.3679 | 1.3593 | 1.3657 | 849380.0 |
| 2005-07-13 09:30:00 | AAPL | Stock | 1.3675 | 1.3704 | 1.3621 | 1.3654 | 15920632.0 |
| 2005-07-13 09:35:00 | AAPL | Stock | 1.3654 | 1.3714 | 1.3646 | 1.3679 | 18138204.0 |
| 2005-07-13 09:40:00 | AAPL | Stock | 1.3682 | 1.3729 | 1.3681 | 1.369 | 12892824.0 |
| 2005-07-13 09:45:00 | AAPL | Stock | 1.3693 | 1.3704 | 1.3657 | 1.3689 | 8096172.0 |
| 2005-07-13 09:50:00 | AAPL | Stock | 1.3689 | 1.3718 | 1.3682 | 1.3696 | 10340736.0 |
| 2005-07-13 09:55:00 | AAPL | Stock | 1.37 | 1.37 | 1.3679 | 1.3682 | 7982156.0 |
| 2005-07-13 10:00:00 | AAPL | Stock | 1.3686 | 1.3707 | 1.3668 | 1.3696 | 4562012.0 |
| 2005-07-13 10:05:00 | AAPL | Stock | 1.3696 | 1.37 | 1.3632 | 1.3632 | 7308700.0 |
| 2005-07-13 10:10:00 | AAPL | Stock | 1.3632 | 1.3664 | 1.3571 | 1.3589 | 18423888.0 |
| 2005-07-13 10:15:00 | AAPL | Stock | 1.3589 | 1.3593 | 1.3536 | 1.3557 | 14108360.0 |
| 2005-07-13 10:20:00 | AAPL | Stock | 1.3564 | 1.3589 | 1.3554 | 1.3557 | 14327152.0 |
| 2005-07-13 10:25:00 | AAPL | Stock | 1.3557 | 1.3579 | 1.3557 | 1.3564 | 11919516.0 |
| 2005-07-13 10:30:00 | AAPL | Stock | 1.3564 | 1.3589 | 1.3564 | 1.3582 | 9326828.0 |
| 2005-07-13 10:35:00 | AAPL | Stock | 1.3582 | 1.36 | 1.3579 | 1.3586 | 8930264.0 |
| 2005-07-13 10:40:00 | AAPL | Stock | 1.3586 | 1.3586 | 1.3543 | 1.3546 | 10387272.0 |
| 2005-07-13 10:45:00 | AAPL | Stock | 1.3546 | 1.3568 | 1.3546 | 1.3564 | 6182624.0 |
| 2005-07-13 10:50:00 | AAPL | Stock | 1.3564 | 1.3589 | 1.3561 | 1.3589 | 6317108.0 |
| 2005-07-13 10:55:00 | AAPL | Stock | 1.3596 | 1.36 | 1.3568 | 1.3582 | 9702672.0 |
| 2005-07-13 11:00:00 | AAPL | Stock | 1.3586 | 1.3604 | 1.3582 | 1.3593 | 5982620.0 |
| 2005-07-13 11:05:00 | AAPL | Stock | 1.3596 | 1.3604 | 1.3589 | 1.3596 | 4158448.0 |
| 2005-07-13 11:10:00 | AAPL | Stock | 1.3596 | 1.3625 | 1.3596 | 1.3603 | 7017220.0 |
| 2005-07-13 11:15:00 | AAPL | Stock | 1.36 | 1.3621 | 1.3589 | 1.3614 | 5122068.0 |
| 2005-07-13 11:20:00 | AAPL | Stock | 1.3614 | 1.3643 | 1.3611 | 1.3625 | 5405624.0 |
| 2005-07-13 11:25:00 | AAPL | Stock | 1.3629 | 1.3671 | 1.3593 | 1.3661 | 15261512.0 |
| 2005-07-13 11:30:00 | AAPL | Stock | 1.3661 | 1.3671 | 1.3632 | 1.3632 | 5021716.0 |
| 2005-07-13 11:35:00 | AAPL | Stock | 1.3632 | 1.3654 | 1.3629 | 1.365 | 3546088.0 |
| 2005-07-13 11:40:00 | AAPL | Stock | 1.3649 | 1.3661 | 1.3643 | 1.3646 | 2603132.0 |
| 2005-07-13 11:45:00 | AAPL | Stock | 1.3646 | 1.365 | 1.363 | 1.3643 | 1541176.0 |
| 2005-07-13 11:50:00 | AAPL | Stock | 1.3646 | 1.3646 | 1.3611 | 1.3614 | 5757220.0 |
> showing 50 of 193,362 rows — these rows as CSV