PREVIEW / stock_5min / 2002-01-10
file: by_date/stock_5min/2002/2002-01-10.parquet size: 1.7 MB rows: 116,341 symbols: 1,359
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 |
|---|---|---|---|---|---|---|---|
| 2002-01-10 08:00:00 | AAPL | Stock | 0.3839 | 0.3869 | 0.3838 | 0.3869 | 627200.0 |
| 2002-01-10 08:05:00 | AAPL | Stock | 0.3805 | 0.3805 | 0.3804 | 0.3804 | 392000.0 |
| 2002-01-10 08:10:00 | AAPL | Stock | 0.3796 | 0.3804 | 0.3796 | 0.3804 | 173600.0 |
| 2002-01-10 08:20:00 | AAPL | Stock | 0.3777 | 0.3777 | 0.3777 | 0.3777 | 22400.0 |
| 2002-01-10 08:25:00 | AAPL | Stock | 0.3834 | 0.3834 | 0.3829 | 0.383 | 78400.0 |
| 2002-01-10 08:35:00 | AAPL | Stock | 0.3827 | 0.383 | 0.3821 | 0.3821 | 134400.0 |
| 2002-01-10 08:40:00 | AAPL | Stock | 0.3795 | 0.3804 | 0.3795 | 0.3804 | 39200.0 |
| 2002-01-10 08:45:00 | AAPL | Stock | 0.3804 | 0.383 | 0.3804 | 0.383 | 207200.0 |
| 2002-01-10 08:55:00 | AAPL | Stock | 0.3821 | 0.3821 | 0.3821 | 0.3821 | 78400.0 |
| 2002-01-10 09:00:00 | AAPL | Stock | 0.3818 | 0.3818 | 0.3795 | 0.3795 | 212800.0 |
| 2002-01-10 09:05:00 | AAPL | Stock | 0.3795 | 0.3795 | 0.3779 | 0.3779 | 89600.0 |
| 2002-01-10 09:10:00 | AAPL | Stock | 0.3777 | 0.3793 | 0.3763 | 0.3793 | 78400.0 |
| 2002-01-10 09:15:00 | AAPL | Stock | 0.3793 | 0.3793 | 0.3793 | 0.3793 | 16800.0 |
| 2002-01-10 09:20:00 | AAPL | Stock | 0.3793 | 0.3809 | 0.3793 | 0.3805 | 134400.0 |
| 2002-01-10 09:25:00 | AAPL | Stock | 0.3804 | 0.3805 | 0.3768 | 0.3789 | 1680000.0 |
| 2002-01-10 09:30:00 | AAPL | Stock | 0.3789 | 0.3807 | 0.3741 | 0.3746 | 18446400.0 |
| 2002-01-10 09:35:00 | AAPL | Stock | 0.3754 | 0.3773 | 0.3741 | 0.3766 | 9100000.0 |
| 2002-01-10 09:40:00 | AAPL | Stock | 0.3766 | 0.3773 | 0.3757 | 0.377 | 20417600.0 |
| 2002-01-10 09:45:00 | AAPL | Stock | 0.3771 | 0.3798 | 0.377 | 0.3777 | 9217600.0 |
| 2002-01-10 09:50:00 | AAPL | Stock | 0.3777 | 0.3782 | 0.3763 | 0.378 | 7033600.0 |
| 2002-01-10 09:55:00 | AAPL | Stock | 0.378 | 0.3821 | 0.378 | 0.3782 | 4827200.0 |
| 2002-01-10 10:00:00 | AAPL | Stock | 0.3784 | 0.3813 | 0.377 | 0.378 | 7005600.0 |
| 2002-01-10 10:05:00 | AAPL | Stock | 0.3782 | 0.3814 | 0.377 | 0.3814 | 4972800.0 |
| 2002-01-10 10:10:00 | AAPL | Stock | 0.3816 | 0.3816 | 0.3777 | 0.378 | 4558400.0 |
| 2002-01-10 10:15:00 | AAPL | Stock | 0.378 | 0.3796 | 0.3777 | 0.3779 | 3908800.0 |
| 2002-01-10 10:20:00 | AAPL | Stock | 0.378 | 0.3793 | 0.3777 | 0.3784 | 3186400.0 |
| 2002-01-10 10:25:00 | AAPL | Stock | 0.3784 | 0.3786 | 0.377 | 0.378 | 4272800.0 |
| 2002-01-10 10:30:00 | AAPL | Stock | 0.3784 | 0.3786 | 0.3768 | 0.3775 | 2643200.0 |
| 2002-01-10 10:35:00 | AAPL | Stock | 0.3779 | 0.378 | 0.377 | 0.3779 | 4485600.0 |
| 2002-01-10 10:40:00 | AAPL | Stock | 0.3779 | 0.3797 | 0.3779 | 0.3789 | 2956800.0 |
| 2002-01-10 10:45:00 | AAPL | Stock | 0.3788 | 0.3798 | 0.3782 | 0.3784 | 1568000.0 |
| 2002-01-10 10:50:00 | AAPL | Stock | 0.3788 | 0.3804 | 0.3784 | 0.3793 | 1775200.0 |
| 2002-01-10 10:55:00 | AAPL | Stock | 0.3793 | 0.382 | 0.3791 | 0.3796 | 3287200.0 |
| 2002-01-10 11:00:00 | AAPL | Stock | 0.3798 | 0.3816 | 0.3791 | 0.3791 | 4239200.0 |
| 2002-01-10 11:05:00 | AAPL | Stock | 0.3789 | 0.383 | 0.3789 | 0.3829 | 5600000.0 |
| 2002-01-10 11:10:00 | AAPL | Stock | 0.3821 | 0.3834 | 0.3789 | 0.3789 | 5947200.0 |
| 2002-01-10 11:15:00 | AAPL | Stock | 0.3795 | 0.3821 | 0.3795 | 0.3813 | 5902400.0 |
| 2002-01-10 11:20:00 | AAPL | Stock | 0.3809 | 0.3814 | 0.3795 | 0.3796 | 1444800.0 |
| 2002-01-10 11:25:00 | AAPL | Stock | 0.38 | 0.3804 | 0.3795 | 0.3801 | 1204000.0 |
| 2002-01-10 11:30:00 | AAPL | Stock | 0.3802 | 0.3804 | 0.3777 | 0.3793 | 2088800.0 |
| 2002-01-10 11:35:00 | AAPL | Stock | 0.3793 | 0.3804 | 0.3791 | 0.3802 | 2570400.0 |
| 2002-01-10 11:40:00 | AAPL | Stock | 0.3797 | 0.38 | 0.3771 | 0.3782 | 3147200.0 |
| 2002-01-10 11:45:00 | AAPL | Stock | 0.3782 | 0.3789 | 0.3766 | 0.3773 | 2346400.0 |
| 2002-01-10 11:50:00 | AAPL | Stock | 0.3773 | 0.3773 | 0.3754 | 0.3764 | 3914400.0 |
| 2002-01-10 11:55:00 | AAPL | Stock | 0.3763 | 0.3773 | 0.3757 | 0.3768 | 2844800.0 |
| 2002-01-10 12:00:00 | AAPL | Stock | 0.3768 | 0.3779 | 0.3763 | 0.3775 | 5566400.0 |
| 2002-01-10 12:05:00 | AAPL | Stock | 0.3776 | 0.3777 | 0.3759 | 0.3759 | 2727200.0 |
| 2002-01-10 12:10:00 | AAPL | Stock | 0.3759 | 0.3768 | 0.3739 | 0.3748 | 6120800.0 |
| 2002-01-10 12:15:00 | AAPL | Stock | 0.3748 | 0.3757 | 0.3741 | 0.3745 | 4748800.0 |
| 2002-01-10 12:20:00 | AAPL | Stock | 0.3745 | 0.3746 | 0.3732 | 0.3732 | 3292800.0 |
> showing 50 of 116,341 rows — these rows as CSV