PREVIEW / stock_5min / 2007-04-05
file: by_date/stock_5min/2007/2007-04-05.parquet size: 3.4 MB rows: 249,833 symbols: 2,577
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-05 06:10:00 | AAPL | Stock | 3.3614 | 3.3764 | 3.3614 | 3.3764 | 8400.0 |
| 2007-04-05 08:00:00 | AAPL | Stock | 3.3696 | 3.37 | 3.3689 | 3.3689 | 58548.0 |
| 2007-04-05 08:05:00 | AAPL | Stock | 3.3679 | 3.3679 | 3.3671 | 3.3671 | 30800.0 |
| 2007-04-05 08:10:00 | AAPL | Stock | 3.3679 | 3.3689 | 3.3679 | 3.3689 | 25200.0 |
| 2007-04-05 08:20:00 | AAPL | Stock | 3.3689 | 3.3689 | 3.3689 | 3.3689 | 4200.0 |
| 2007-04-05 08:25:00 | AAPL | Stock | 3.3696 | 3.3704 | 3.3696 | 3.3704 | 30800.0 |
| 2007-04-05 08:30:00 | AAPL | Stock | 3.3686 | 3.3686 | 3.3643 | 3.3643 | 93716.0 |
| 2007-04-05 08:40:00 | AAPL | Stock | 3.3643 | 3.3643 | 3.3643 | 3.3643 | 8400.0 |
| 2007-04-05 08:45:00 | AAPL | Stock | 3.3643 | 3.3643 | 3.3643 | 3.3643 | 11200.0 |
| 2007-04-05 08:50:00 | AAPL | Stock | 3.3625 | 3.3639 | 3.3625 | 3.3639 | 30128.0 |
| 2007-04-05 08:55:00 | AAPL | Stock | 3.3621 | 3.3621 | 3.3621 | 3.3621 | 60844.0 |
| 2007-04-05 09:00:00 | AAPL | Stock | 3.3625 | 3.3625 | 3.3621 | 3.3625 | 47516.0 |
| 2007-04-05 09:05:00 | AAPL | Stock | 3.3614 | 3.3625 | 3.3614 | 3.3614 | 102704.0 |
| 2007-04-05 09:10:00 | AAPL | Stock | 3.3614 | 3.3625 | 3.3607 | 3.3614 | 203840.0 |
| 2007-04-05 09:15:00 | AAPL | Stock | 3.3614 | 3.3614 | 3.3614 | 3.3614 | 36820.0 |
| 2007-04-05 09:20:00 | AAPL | Stock | 3.3632 | 3.3636 | 3.3632 | 3.3636 | 19600.0 |
| 2007-04-05 09:25:00 | AAPL | Stock | 3.3636 | 3.365 | 3.3629 | 3.3629 | 192360.0 |
| 2007-04-05 09:30:00 | AAPL | Stock | 3.3614 | 3.3661 | 3.3575 | 3.3607 | 9953328.0 |
| 2007-04-05 09:35:00 | AAPL | Stock | 3.3604 | 3.3607 | 3.34 | 3.3436 | 14121100.0 |
| 2007-04-05 09:40:00 | AAPL | Stock | 3.3432 | 3.3596 | 3.3432 | 3.3471 | 7647584.0 |
| 2007-04-05 09:45:00 | AAPL | Stock | 3.3482 | 3.3554 | 3.3471 | 3.3532 | 9432528.0 |
| 2007-04-05 09:50:00 | AAPL | Stock | 3.3525 | 3.3543 | 3.3482 | 3.3504 | 5931996.0 |
| 2007-04-05 09:55:00 | AAPL | Stock | 3.3511 | 3.3554 | 3.3482 | 3.3496 | 7316232.0 |
| 2007-04-05 10:00:00 | AAPL | Stock | 3.3496 | 3.3514 | 3.3439 | 3.3471 | 6158208.0 |
| 2007-04-05 10:05:00 | AAPL | Stock | 3.3475 | 3.35 | 3.3432 | 3.3493 | 6091316.0 |
| 2007-04-05 10:10:00 | AAPL | Stock | 3.3496 | 3.3589 | 3.3468 | 3.3497 | 8183448.0 |
| 2007-04-05 10:15:00 | AAPL | Stock | 3.35 | 3.3568 | 3.3496 | 3.3554 | 5436536.0 |
| 2007-04-05 10:20:00 | AAPL | Stock | 3.3561 | 3.3561 | 3.3521 | 3.3525 | 3743292.0 |
| 2007-04-05 10:25:00 | AAPL | Stock | 3.3525 | 3.3554 | 3.3468 | 3.3475 | 5736388.0 |
| 2007-04-05 10:30:00 | AAPL | Stock | 3.3475 | 3.3504 | 3.3468 | 3.3493 | 9311568.0 |
| 2007-04-05 10:35:00 | AAPL | Stock | 3.3496 | 3.3504 | 3.3446 | 3.35 | 6299664.0 |
| 2007-04-05 10:40:00 | AAPL | Stock | 3.35 | 3.36 | 3.3499 | 3.3579 | 11711812.0 |
| 2007-04-05 10:45:00 | AAPL | Stock | 3.3575 | 3.3593 | 3.355 | 3.3564 | 5335204.0 |
| 2007-04-05 10:50:00 | AAPL | Stock | 3.3568 | 3.3589 | 3.355 | 3.3562 | 6249320.0 |
| 2007-04-05 10:55:00 | AAPL | Stock | 3.3568 | 3.3579 | 3.3536 | 3.3546 | 4029452.0 |
| 2007-04-05 11:00:00 | AAPL | Stock | 3.3546 | 3.3564 | 3.3536 | 3.3564 | 2486512.0 |
| 2007-04-05 11:05:00 | AAPL | Stock | 3.3564 | 3.3575 | 3.3561 | 3.3568 | 2802156.0 |
| 2007-04-05 11:10:00 | AAPL | Stock | 3.3568 | 3.3568 | 3.3532 | 3.355 | 2811620.0 |
| 2007-04-05 11:15:00 | AAPL | Stock | 3.355 | 3.3554 | 3.35 | 3.3507 | 8397620.0 |
| 2007-04-05 11:20:00 | AAPL | Stock | 3.3507 | 3.3518 | 3.3482 | 3.3518 | 4730348.0 |
| 2007-04-05 11:25:00 | AAPL | Stock | 3.3518 | 3.3546 | 3.3518 | 3.3539 | 3777928.0 |
| 2007-04-05 11:30:00 | AAPL | Stock | 3.3539 | 3.3554 | 3.3536 | 3.355 | 2636760.0 |
| 2007-04-05 11:35:00 | AAPL | Stock | 3.3546 | 3.3557 | 3.3504 | 3.3522 | 5600140.0 |
| 2007-04-05 11:40:00 | AAPL | Stock | 3.3525 | 3.3557 | 3.3525 | 3.3557 | 4679136.0 |
| 2007-04-05 11:45:00 | AAPL | Stock | 3.3557 | 3.3557 | 3.3536 | 3.355 | 1570800.0 |
| 2007-04-05 11:50:00 | AAPL | Stock | 3.355 | 3.3575 | 3.3546 | 3.3571 | 3810156.0 |
| 2007-04-05 11:55:00 | AAPL | Stock | 3.3571 | 3.3625 | 3.3564 | 3.3611 | 6869044.0 |
| 2007-04-05 12:00:00 | AAPL | Stock | 3.3611 | 3.3629 | 3.3571 | 3.36 | 6311760.0 |
| 2007-04-05 12:05:00 | AAPL | Stock | 3.36 | 3.3646 | 3.36 | 3.3639 | 6132728.0 |
| 2007-04-05 12:10:00 | AAPL | Stock | 3.3636 | 3.3639 | 3.3593 | 3.3604 | 3760848.0 |
> showing 50 of 249,833 rows — these rows as CSV