PREVIEW / stock_5min / 2005-06-17
file: by_date/stock_5min/2005/2005-06-17.parquet size: 2.8 MB rows: 202,921 symbols: 1,985
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-17 07:35:00 | AAPL | Stock | 1.3629 | 1.3629 | 1.3629 | 1.3629 | 28000.0 |
| 2005-06-17 08:00:00 | AAPL | Stock | 1.3632 | 1.3643 | 1.3632 | 1.3636 | 25200.0 |
| 2005-06-17 08:05:00 | AAPL | Stock | 1.3632 | 1.3636 | 1.3632 | 1.3636 | 36400.0 |
| 2005-06-17 08:10:00 | AAPL | Stock | 1.3636 | 1.3636 | 1.3636 | 1.3636 | 106400.0 |
| 2005-06-17 08:15:00 | AAPL | Stock | 1.3636 | 1.3636 | 1.3632 | 1.3636 | 128240.0 |
| 2005-06-17 08:20:00 | AAPL | Stock | 1.3632 | 1.3632 | 1.3632 | 1.3632 | 22400.0 |
| 2005-06-17 08:25:00 | AAPL | Stock | 1.3625 | 1.3625 | 1.3607 | 1.3607 | 11200.0 |
| 2005-06-17 08:30:00 | AAPL | Stock | 1.3625 | 1.3625 | 1.3614 | 1.3625 | 47600.0 |
| 2005-06-17 08:35:00 | AAPL | Stock | 1.3625 | 1.3625 | 1.3625 | 1.3625 | 69160.0 |
| 2005-06-17 08:40:00 | AAPL | Stock | 1.3614 | 1.3614 | 1.3614 | 1.3614 | 16800.0 |
| 2005-06-17 08:45:00 | AAPL | Stock | 1.3611 | 1.3611 | 1.3611 | 1.3611 | 95200.0 |
| 2005-06-17 08:50:00 | AAPL | Stock | 1.3611 | 1.3611 | 1.3571 | 1.3607 | 75600.0 |
| 2005-06-17 08:55:00 | AAPL | Stock | 1.3607 | 1.3625 | 1.3607 | 1.3625 | 196000.0 |
| 2005-06-17 09:00:00 | AAPL | Stock | 1.3625 | 1.3625 | 1.3625 | 1.3625 | 2800.0 |
| 2005-06-17 09:05:00 | AAPL | Stock | 1.3636 | 1.3661 | 1.3625 | 1.3661 | 190960.0 |
| 2005-06-17 09:10:00 | AAPL | Stock | 1.3654 | 1.3657 | 1.3654 | 1.3654 | 56000.0 |
| 2005-06-17 09:15:00 | AAPL | Stock | 1.3639 | 1.3639 | 1.3639 | 1.3639 | 17500.0 |
| 2005-06-17 09:20:00 | AAPL | Stock | 1.3639 | 1.3654 | 1.3639 | 1.365 | 92260.0 |
| 2005-06-17 09:25:00 | AAPL | Stock | 1.3632 | 1.3793 | 1.3607 | 1.375 | 12100816.0 |
| 2005-06-17 09:30:00 | AAPL | Stock | 1.3739 | 1.3764 | 1.3646 | 1.37 | 129028200.0 |
| 2005-06-17 09:35:00 | AAPL | Stock | 1.37 | 1.3743 | 1.3625 | 1.3636 | 12523616.0 |
| 2005-06-17 09:40:00 | AAPL | Stock | 1.3636 | 1.3679 | 1.3629 | 1.3671 | 15403976.0 |
| 2005-06-17 09:45:00 | AAPL | Stock | 1.3671 | 1.3682 | 1.3657 | 1.3671 | 10819900.0 |
| 2005-06-17 09:50:00 | AAPL | Stock | 1.3671 | 1.3686 | 1.3571 | 1.3589 | 17801028.0 |
| 2005-06-17 09:55:00 | AAPL | Stock | 1.3589 | 1.3643 | 1.3579 | 1.36 | 17858596.0 |
| 2005-06-17 10:00:00 | AAPL | Stock | 1.3604 | 1.3654 | 1.3589 | 1.3636 | 8392188.0 |
| 2005-06-17 10:05:00 | AAPL | Stock | 1.3632 | 1.3636 | 1.3543 | 1.3582 | 12815432.0 |
| 2005-06-17 10:10:00 | AAPL | Stock | 1.3582 | 1.3593 | 1.3529 | 1.3564 | 8646036.0 |
| 2005-06-17 10:15:00 | AAPL | Stock | 1.3564 | 1.3571 | 1.3511 | 1.3532 | 9929920.0 |
| 2005-06-17 10:20:00 | AAPL | Stock | 1.3536 | 1.3664 | 1.3532 | 1.3664 | 17503724.0 |
| 2005-06-17 10:25:00 | AAPL | Stock | 1.3668 | 1.3696 | 1.3625 | 1.3657 | 11941300.0 |
| 2005-06-17 10:30:00 | AAPL | Stock | 1.3654 | 1.3664 | 1.3636 | 1.3639 | 5382664.0 |
| 2005-06-17 10:35:00 | AAPL | Stock | 1.3639 | 1.3671 | 1.3639 | 1.3646 | 6801788.0 |
| 2005-06-17 10:40:00 | AAPL | Stock | 1.3643 | 1.3675 | 1.3632 | 1.3664 | 6926976.0 |
| 2005-06-17 10:45:00 | AAPL | Stock | 1.3664 | 1.3664 | 1.3611 | 1.3621 | 5012644.0 |
| 2005-06-17 10:50:00 | AAPL | Stock | 1.3625 | 1.365 | 1.3611 | 1.3643 | 5567632.0 |
| 2005-06-17 10:55:00 | AAPL | Stock | 1.3639 | 1.3639 | 1.3589 | 1.3607 | 4601912.0 |
| 2005-06-17 11:00:00 | AAPL | Stock | 1.3611 | 1.3632 | 1.3582 | 1.3586 | 2894976.0 |
| 2005-06-17 11:05:00 | AAPL | Stock | 1.3586 | 1.3607 | 1.3579 | 1.3582 | 7071260.0 |
| 2005-06-17 11:10:00 | AAPL | Stock | 1.3579 | 1.3604 | 1.3564 | 1.3564 | 3326232.0 |
| 2005-06-17 11:15:00 | AAPL | Stock | 1.3568 | 1.3586 | 1.3554 | 1.3568 | 6588596.0 |
| 2005-06-17 11:20:00 | AAPL | Stock | 1.3564 | 1.3568 | 1.3546 | 1.3564 | 5106584.0 |
| 2005-06-17 11:25:00 | AAPL | Stock | 1.3561 | 1.3586 | 1.3557 | 1.3568 | 4906412.0 |
| 2005-06-17 11:30:00 | AAPL | Stock | 1.3571 | 1.3596 | 1.3568 | 1.3579 | 4472748.0 |
| 2005-06-17 11:35:00 | AAPL | Stock | 1.3575 | 1.3607 | 1.3554 | 1.3571 | 5191984.0 |
| 2005-06-17 11:40:00 | AAPL | Stock | 1.3571 | 1.3586 | 1.3561 | 1.3561 | 2688252.0 |
| 2005-06-17 11:45:00 | AAPL | Stock | 1.3561 | 1.3596 | 1.3554 | 1.3561 | 3839724.0 |
| 2005-06-17 11:50:00 | AAPL | Stock | 1.3561 | 1.3582 | 1.3561 | 1.3575 | 3678080.0 |
| 2005-06-17 11:55:00 | AAPL | Stock | 1.3575 | 1.3593 | 1.3571 | 1.3586 | 1547504.0 |
| 2005-06-17 12:00:00 | AAPL | Stock | 1.3589 | 1.3607 | 1.3589 | 1.36 | 2240812.0 |
> showing 50 of 202,921 rows — these rows as CSV