PREVIEW / stock_5min / 2006-04-24
file: by_date/stock_5min/2006/2006-04-24.parquet size: 3.1 MB rows: 225,339 symbols: 2,246
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 |
|---|---|---|---|---|---|---|---|
| 2006-04-24 08:00:00 | AAPL | Stock | 2.3864 | 2.3893 | 2.3857 | 2.3857 | 133700.0 |
| 2006-04-24 08:05:00 | AAPL | Stock | 2.3893 | 2.3893 | 2.3857 | 2.3875 | 110600.0 |
| 2006-04-24 08:10:00 | AAPL | Stock | 2.3875 | 2.3893 | 2.3875 | 2.3875 | 58800.0 |
| 2006-04-24 08:15:00 | AAPL | Stock | 2.3875 | 2.3886 | 2.3857 | 2.3886 | 64400.0 |
| 2006-04-24 08:25:00 | AAPL | Stock | 2.3886 | 2.3886 | 2.3868 | 2.3868 | 8400.0 |
| 2006-04-24 08:30:00 | AAPL | Stock | 2.3868 | 2.3964 | 2.3857 | 2.3929 | 538440.0 |
| 2006-04-24 08:35:00 | AAPL | Stock | 2.3896 | 2.3921 | 2.3896 | 2.3921 | 19600.0 |
| 2006-04-24 08:40:00 | AAPL | Stock | 2.3882 | 2.3914 | 2.3857 | 2.3861 | 137844.0 |
| 2006-04-24 08:45:00 | AAPL | Stock | 2.3861 | 2.3911 | 2.3861 | 2.3907 | 331828.0 |
| 2006-04-24 08:50:00 | AAPL | Stock | 2.3911 | 2.3925 | 2.3907 | 2.3921 | 348880.0 |
| 2006-04-24 08:55:00 | AAPL | Stock | 2.3911 | 2.3911 | 2.3893 | 2.3893 | 70000.0 |
| 2006-04-24 09:00:00 | AAPL | Stock | 2.3896 | 2.3925 | 2.3896 | 2.3914 | 82740.0 |
| 2006-04-24 09:05:00 | AAPL | Stock | 2.3914 | 2.3914 | 2.3911 | 2.3911 | 61600.0 |
| 2006-04-24 09:10:00 | AAPL | Stock | 2.3886 | 2.3893 | 2.3882 | 2.3893 | 30912.0 |
| 2006-04-24 09:15:00 | AAPL | Stock | 2.3893 | 2.3893 | 2.3893 | 2.3893 | 14000.0 |
| 2006-04-24 09:25:00 | AAPL | Stock | 2.3882 | 2.3911 | 2.3857 | 2.3907 | 615580.0 |
| 2006-04-24 09:30:00 | AAPL | Stock | 2.3875 | 2.39 | 2.38 | 2.3811 | 16094400.0 |
| 2006-04-24 09:35:00 | AAPL | Stock | 2.3814 | 2.3886 | 2.3679 | 2.3704 | 15647128.0 |
| 2006-04-24 09:40:00 | AAPL | Stock | 2.3711 | 2.3871 | 2.3689 | 2.3771 | 18807544.0 |
| 2006-04-24 09:45:00 | AAPL | Stock | 2.3771 | 2.3796 | 2.3614 | 2.3632 | 14297500.0 |
| 2006-04-24 09:50:00 | AAPL | Stock | 2.3636 | 2.3675 | 2.3536 | 2.3546 | 19333888.0 |
| 2006-04-24 09:55:00 | AAPL | Stock | 2.3543 | 2.3618 | 2.3486 | 2.3543 | 15939000.0 |
| 2006-04-24 10:00:00 | AAPL | Stock | 2.3546 | 2.3643 | 2.3532 | 2.3629 | 15368472.0 |
| 2006-04-24 10:05:00 | AAPL | Stock | 2.3629 | 2.3689 | 2.3621 | 2.3636 | 10987984.0 |
| 2006-04-24 10:10:00 | AAPL | Stock | 2.3639 | 2.3887 | 2.3582 | 2.3636 | 8935892.0 |
| 2006-04-24 10:15:00 | AAPL | Stock | 2.3636 | 2.3675 | 2.3582 | 2.3668 | 6519660.0 |
| 2006-04-24 10:20:00 | AAPL | Stock | 2.3675 | 2.3818 | 2.3661 | 2.3789 | 17163272.0 |
| 2006-04-24 10:25:00 | AAPL | Stock | 2.3793 | 2.3793 | 2.3686 | 2.37 | 8936340.0 |
| 2006-04-24 10:30:00 | AAPL | Stock | 2.37 | 2.3746 | 2.3664 | 2.3725 | 6848772.0 |
| 2006-04-24 10:35:00 | AAPL | Stock | 2.3721 | 2.3743 | 2.3675 | 2.3707 | 8608824.0 |
| 2006-04-24 10:40:00 | AAPL | Stock | 2.3704 | 2.3786 | 2.3693 | 2.3779 | 10560620.0 |
| 2006-04-24 10:45:00 | AAPL | Stock | 2.3779 | 2.3889 | 2.3775 | 2.3871 | 19469128.0 |
| 2006-04-24 10:50:00 | AAPL | Stock | 2.3871 | 2.3879 | 2.3786 | 2.3786 | 8070972.0 |
| 2006-04-24 10:55:00 | AAPL | Stock | 2.3796 | 2.3832 | 2.3746 | 2.3779 | 7244748.0 |
| 2006-04-24 11:00:00 | AAPL | Stock | 2.3775 | 2.3811 | 2.3657 | 2.3675 | 11190284.0 |
| 2006-04-24 11:05:00 | AAPL | Stock | 2.3675 | 2.3682 | 2.3586 | 2.3654 | 13763092.0 |
| 2006-04-24 11:10:00 | AAPL | Stock | 2.3646 | 2.3718 | 2.3644 | 2.3679 | 7874664.0 |
| 2006-04-24 11:15:00 | AAPL | Stock | 2.3686 | 2.3732 | 2.3632 | 2.3664 | 5905480.0 |
| 2006-04-24 11:20:00 | AAPL | Stock | 2.3664 | 2.3704 | 2.3625 | 2.3644 | 9233280.0 |
| 2006-04-24 11:25:00 | AAPL | Stock | 2.3643 | 2.3689 | 2.3636 | 2.3671 | 6342336.0 |
| 2006-04-24 11:30:00 | AAPL | Stock | 2.3682 | 2.3732 | 2.3643 | 2.3646 | 5474532.0 |
| 2006-04-24 11:35:00 | AAPL | Stock | 2.3643 | 2.365 | 2.3568 | 2.3604 | 10553844.0 |
| 2006-04-24 11:40:00 | AAPL | Stock | 2.3604 | 2.3607 | 2.3543 | 2.3589 | 8819692.0 |
| 2006-04-24 11:45:00 | AAPL | Stock | 2.3589 | 2.3604 | 2.3514 | 2.3536 | 9657900.0 |
| 2006-04-24 11:50:00 | AAPL | Stock | 2.3536 | 2.3582 | 2.3514 | 2.3539 | 6658232.0 |
| 2006-04-24 11:55:00 | AAPL | Stock | 2.3539 | 2.3593 | 2.3518 | 2.3546 | 6444816.0 |
| 2006-04-24 12:00:00 | AAPL | Stock | 2.3543 | 2.3579 | 2.3529 | 2.3579 | 6707904.0 |
| 2006-04-24 12:05:00 | AAPL | Stock | 2.3571 | 2.3571 | 2.3518 | 2.355 | 4777612.0 |
| 2006-04-24 12:10:00 | AAPL | Stock | 2.355 | 2.3589 | 2.3536 | 2.3539 | 4357780.0 |
| 2006-04-24 12:15:00 | AAPL | Stock | 2.3536 | 2.355 | 2.35 | 2.3511 | 5389216.0 |
> showing 50 of 225,339 rows — these rows as CSV