PREVIEW / stock_5min / 2008-02-20
file: by_date/stock_5min/2008/2008-02-20.parquet size: 4.3 MB rows: 314,382 symbols: 3,279
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 |
|---|---|---|---|---|---|---|---|
| 2008-02-20 05:55:00 | AAPL | Stock | 4.3679 | 4.3679 | 4.3668 | 4.3668 | 28000.0 |
| 2008-02-20 06:30:00 | AAPL | Stock | 4.3625 | 4.3625 | 4.3571 | 4.3571 | 11200.0 |
| 2008-02-20 07:00:00 | AAPL | Stock | 4.3611 | 4.3661 | 4.3607 | 4.3607 | 58800.0 |
| 2008-02-20 07:05:00 | AAPL | Stock | 4.3607 | 4.3607 | 4.3518 | 4.3571 | 14000.0 |
| 2008-02-20 07:10:00 | AAPL | Stock | 4.3536 | 4.3536 | 4.3536 | 4.3536 | 16520.0 |
| 2008-02-20 07:15:00 | AAPL | Stock | 4.3643 | 4.3643 | 4.3529 | 4.3571 | 119756.0 |
| 2008-02-20 07:20:00 | AAPL | Stock | 4.3604 | 4.3604 | 4.3571 | 4.36 | 139468.0 |
| 2008-02-20 07:25:00 | AAPL | Stock | 4.3607 | 4.3607 | 4.3571 | 4.3571 | 11872.0 |
| 2008-02-20 07:30:00 | AAPL | Stock | 4.3575 | 4.3771 | 4.3575 | 4.3771 | 63728.0 |
| 2008-02-20 07:40:00 | AAPL | Stock | 4.375 | 4.375 | 4.3721 | 4.3721 | 11760.0 |
| 2008-02-20 07:45:00 | AAPL | Stock | 4.3682 | 4.3682 | 4.3682 | 4.3682 | 5600.0 |
| 2008-02-20 07:55:00 | AAPL | Stock | 4.3629 | 4.3629 | 4.3629 | 4.3629 | 5516.0 |
| 2008-02-20 08:00:00 | AAPL | Stock | 4.3714 | 4.375 | 4.3643 | 4.3668 | 143640.0 |
| 2008-02-20 08:05:00 | AAPL | Stock | 4.3668 | 4.3693 | 4.3582 | 4.3625 | 212100.0 |
| 2008-02-20 08:10:00 | AAPL | Stock | 4.3636 | 4.3643 | 4.3536 | 4.3571 | 399000.0 |
| 2008-02-20 08:15:00 | AAPL | Stock | 4.3571 | 4.3575 | 4.3571 | 4.3575 | 117964.0 |
| 2008-02-20 08:20:00 | AAPL | Stock | 4.36 | 4.3614 | 4.3575 | 4.3611 | 68600.0 |
| 2008-02-20 08:25:00 | AAPL | Stock | 4.3589 | 4.3771 | 4.3575 | 4.3643 | 327320.0 |
| 2008-02-20 08:30:00 | AAPL | Stock | 4.3725 | 4.3725 | 4.3393 | 4.3443 | 1673756.0 |
| 2008-02-20 08:35:00 | AAPL | Stock | 4.3461 | 4.3471 | 4.3343 | 4.3425 | 857276.0 |
| 2008-02-20 08:40:00 | AAPL | Stock | 4.3407 | 4.35 | 4.3357 | 4.3446 | 274988.0 |
| 2008-02-20 08:45:00 | AAPL | Stock | 4.3464 | 4.3514 | 4.3361 | 4.3361 | 351960.0 |
| 2008-02-20 08:50:00 | AAPL | Stock | 4.3375 | 4.3468 | 4.3375 | 4.3468 | 371000.0 |
| 2008-02-20 08:55:00 | AAPL | Stock | 4.3468 | 4.35 | 4.3404 | 4.3482 | 307412.0 |
| 2008-02-20 09:00:00 | AAPL | Stock | 4.3486 | 4.3571 | 4.3464 | 4.3571 | 569240.0 |
| 2008-02-20 09:05:00 | AAPL | Stock | 4.3571 | 4.3621 | 4.3568 | 4.3571 | 731360.0 |
| 2008-02-20 09:10:00 | AAPL | Stock | 4.3554 | 4.3554 | 4.3507 | 4.3525 | 131600.0 |
| 2008-02-20 09:15:00 | AAPL | Stock | 4.3521 | 4.3571 | 4.35 | 4.3554 | 231980.0 |
| 2008-02-20 09:20:00 | AAPL | Stock | 4.3546 | 4.3546 | 4.3429 | 4.3482 | 630168.0 |
| 2008-02-20 09:25:00 | AAPL | Stock | 4.3482 | 4.3686 | 4.3439 | 4.3654 | 1302028.0 |
| 2008-02-20 09:30:00 | AAPL | Stock | 4.3643 | 4.3961 | 4.3589 | 4.3764 | 27863556.0 |
| 2008-02-20 09:35:00 | AAPL | Stock | 4.3764 | 4.3996 | 4.3457 | 4.39 | 30223872.0 |
| 2008-02-20 09:40:00 | AAPL | Stock | 4.3911 | 4.4086 | 4.3821 | 4.395 | 29003604.0 |
| 2008-02-20 09:45:00 | AAPL | Stock | 4.3957 | 4.4068 | 4.3807 | 4.4007 | 16436700.0 |
| 2008-02-20 09:50:00 | AAPL | Stock | 4.4007 | 4.4107 | 4.3929 | 4.4036 | 12761112.0 |
| 2008-02-20 09:55:00 | AAPL | Stock | 4.4021 | 4.4042 | 4.3789 | 4.3796 | 14309736.0 |
| 2008-02-20 10:00:00 | AAPL | Stock | 4.3793 | 4.3868 | 4.3661 | 4.3661 | 16764076.0 |
| 2008-02-20 10:05:00 | AAPL | Stock | 4.3664 | 4.3782 | 4.36 | 4.3682 | 15817564.0 |
| 2008-02-20 10:10:00 | AAPL | Stock | 4.3689 | 4.3796 | 4.3629 | 4.3715 | 13661256.0 |
| 2008-02-20 10:15:00 | AAPL | Stock | 4.3704 | 4.3917 | 4.3689 | 4.3917 | 13434596.0 |
| 2008-02-20 10:20:00 | AAPL | Stock | 4.3907 | 4.4025 | 4.3857 | 4.39 | 17388644.0 |
| 2008-02-20 10:25:00 | AAPL | Stock | 4.3896 | 4.3971 | 4.3789 | 4.3861 | 10971016.0 |
| 2008-02-20 10:30:00 | AAPL | Stock | 4.3861 | 4.3861 | 4.3675 | 4.3675 | 10344600.0 |
| 2008-02-20 10:35:00 | AAPL | Stock | 4.3675 | 4.3846 | 4.3661 | 4.3789 | 8718024.0 |
| 2008-02-20 10:40:00 | AAPL | Stock | 4.3786 | 4.3843 | 4.3689 | 4.3779 | 9263100.0 |
| 2008-02-20 10:45:00 | AAPL | Stock | 4.3786 | 4.3861 | 4.3718 | 4.3782 | 11137336.0 |
| 2008-02-20 10:50:00 | AAPL | Stock | 4.3782 | 4.3782 | 4.3543 | 4.3593 | 14874888.0 |
| 2008-02-20 10:55:00 | AAPL | Stock | 4.3593 | 4.3671 | 4.3539 | 4.3607 | 11921392.0 |
| 2008-02-20 11:00:00 | AAPL | Stock | 4.3607 | 4.3711 | 4.3586 | 4.3661 | 7585004.0 |
| 2008-02-20 11:05:00 | AAPL | Stock | 4.3654 | 4.3704 | 4.3589 | 4.3593 | 7009660.0 |
> showing 50 of 314,382 rows — these rows as CSV