PREVIEW / stock_5min / 2003-07-28
file: by_date/stock_5min/2003/2003-07-28.parquet size: 2.2 MB rows: 154,780 symbols: 1,599
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 |
|---|---|---|---|---|---|---|---|
| 2003-07-28 08:00:00 | AAPL | Stock | 0.3821 | 0.4018 | 0.3821 | 0.4018 | 560000.0 |
| 2003-07-28 08:05:00 | AAPL | Stock | 0.392 | 0.392 | 0.392 | 0.392 | 5600.0 |
| 2003-07-28 08:10:00 | AAPL | Stock | 0.3873 | 0.3873 | 0.3873 | 0.3873 | 11200.0 |
| 2003-07-28 08:20:00 | AAPL | Stock | 0.3871 | 0.3871 | 0.3871 | 0.3871 | 5600.0 |
| 2003-07-28 09:00:00 | AAPL | Stock | 0.3839 | 0.3848 | 0.3839 | 0.3839 | 67200.0 |
| 2003-07-28 09:25:00 | AAPL | Stock | 0.3839 | 0.3845 | 0.3836 | 0.3839 | 291200.0 |
| 2003-07-28 09:30:00 | AAPL | Stock | 0.3839 | 0.384 | 0.3768 | 0.38 | 7211624.0 |
| 2003-07-28 09:35:00 | AAPL | Stock | 0.3802 | 0.3821 | 0.3798 | 0.3819 | 2161376.0 |
| 2003-07-28 09:40:00 | AAPL | Stock | 0.3821 | 0.383 | 0.3813 | 0.3818 | 2711856.0 |
| 2003-07-28 09:45:00 | AAPL | Stock | 0.3818 | 0.382 | 0.3775 | 0.3779 | 4911872.0 |
| 2003-07-28 09:50:00 | AAPL | Stock | 0.3779 | 0.3782 | 0.3771 | 0.3773 | 2355864.0 |
| 2003-07-28 09:55:00 | AAPL | Stock | 0.3775 | 0.378 | 0.3757 | 0.377 | 4591328.0 |
| 2003-07-28 10:00:00 | AAPL | Stock | 0.377 | 0.3795 | 0.3763 | 0.3779 | 5798632.0 |
| 2003-07-28 10:05:00 | AAPL | Stock | 0.3779 | 0.3782 | 0.3768 | 0.378 | 1831200.0 |
| 2003-07-28 10:10:00 | AAPL | Stock | 0.3781 | 0.3788 | 0.3771 | 0.3784 | 2505384.0 |
| 2003-07-28 10:15:00 | AAPL | Stock | 0.3784 | 0.3793 | 0.3784 | 0.3788 | 2296000.0 |
| 2003-07-28 10:20:00 | AAPL | Stock | 0.3788 | 0.3795 | 0.3784 | 0.3788 | 2915472.0 |
| 2003-07-28 10:25:00 | AAPL | Stock | 0.3789 | 0.3789 | 0.3784 | 0.3786 | 6955200.0 |
| 2003-07-28 10:30:00 | AAPL | Stock | 0.3784 | 0.38 | 0.3782 | 0.3791 | 2324000.0 |
| 2003-07-28 10:35:00 | AAPL | Stock | 0.3795 | 0.3795 | 0.3786 | 0.3786 | 1204000.0 |
| 2003-07-28 10:40:00 | AAPL | Stock | 0.3784 | 0.3793 | 0.3784 | 0.3784 | 952000.0 |
| 2003-07-28 10:45:00 | AAPL | Stock | 0.3784 | 0.3789 | 0.378 | 0.3788 | 688800.0 |
| 2003-07-28 10:50:00 | AAPL | Stock | 0.3788 | 0.3789 | 0.3777 | 0.3782 | 554400.0 |
| 2003-07-28 10:55:00 | AAPL | Stock | 0.3784 | 0.3796 | 0.3784 | 0.3795 | 1593200.0 |
| 2003-07-28 11:00:00 | AAPL | Stock | 0.3795 | 0.38 | 0.3788 | 0.3791 | 3897488.0 |
| 2003-07-28 11:05:00 | AAPL | Stock | 0.3796 | 0.3796 | 0.3777 | 0.3779 | 1669080.0 |
| 2003-07-28 11:10:00 | AAPL | Stock | 0.378 | 0.3786 | 0.3779 | 0.3782 | 1044680.0 |
| 2003-07-28 11:15:00 | AAPL | Stock | 0.3784 | 0.3805 | 0.3784 | 0.3802 | 2172800.0 |
| 2003-07-28 11:20:00 | AAPL | Stock | 0.38 | 0.3804 | 0.3795 | 0.3795 | 1338400.0 |
| 2003-07-28 11:25:00 | AAPL | Stock | 0.3795 | 0.3804 | 0.3791 | 0.3796 | 1220800.0 |
| 2003-07-28 11:30:00 | AAPL | Stock | 0.3796 | 0.3798 | 0.3789 | 0.3795 | 1453200.0 |
| 2003-07-28 11:35:00 | AAPL | Stock | 0.3798 | 0.3798 | 0.3788 | 0.3793 | 1724800.0 |
| 2003-07-28 11:40:00 | AAPL | Stock | 0.3795 | 0.3798 | 0.3793 | 0.3798 | 2122400.0 |
| 2003-07-28 11:45:00 | AAPL | Stock | 0.3796 | 0.3798 | 0.3789 | 0.3791 | 2100000.0 |
| 2003-07-28 11:50:00 | AAPL | Stock | 0.3789 | 0.3791 | 0.3788 | 0.3789 | 711200.0 |
| 2003-07-28 11:55:00 | AAPL | Stock | 0.3789 | 0.3791 | 0.3786 | 0.3788 | 752080.0 |
| 2003-07-28 12:00:00 | AAPL | Stock | 0.3786 | 0.3786 | 0.3777 | 0.3777 | 2369640.0 |
| 2003-07-28 12:05:00 | AAPL | Stock | 0.3777 | 0.3786 | 0.3777 | 0.3777 | 795200.0 |
| 2003-07-28 12:10:00 | AAPL | Stock | 0.3777 | 0.3779 | 0.3777 | 0.3777 | 380800.0 |
| 2003-07-28 12:15:00 | AAPL | Stock | 0.3777 | 0.3782 | 0.3777 | 0.3777 | 644000.0 |
| 2003-07-28 12:20:00 | AAPL | Stock | 0.3777 | 0.378 | 0.3777 | 0.3779 | 1108800.0 |
| 2003-07-28 12:25:00 | AAPL | Stock | 0.378 | 0.378 | 0.3779 | 0.3779 | 190400.0 |
| 2003-07-28 12:30:00 | AAPL | Stock | 0.3779 | 0.378 | 0.3777 | 0.3779 | 627200.0 |
| 2003-07-28 12:35:00 | AAPL | Stock | 0.3777 | 0.3777 | 0.3766 | 0.3768 | 1107400.0 |
| 2003-07-28 12:40:00 | AAPL | Stock | 0.3766 | 0.3768 | 0.3764 | 0.3768 | 884800.0 |
| 2003-07-28 12:45:00 | AAPL | Stock | 0.3766 | 0.377 | 0.3764 | 0.377 | 778400.0 |
| 2003-07-28 12:50:00 | AAPL | Stock | 0.377 | 0.377 | 0.3768 | 0.377 | 649600.0 |
| 2003-07-28 12:55:00 | AAPL | Stock | 0.377 | 0.3771 | 0.377 | 0.3771 | 644000.0 |
| 2003-07-28 13:00:00 | AAPL | Stock | 0.377 | 0.377 | 0.3759 | 0.3761 | 1568840.0 |
| 2003-07-28 13:05:00 | AAPL | Stock | 0.3761 | 0.3761 | 0.3757 | 0.3759 | 850472.0 |
> showing 50 of 154,780 rows — these rows as CSV