PREVIEW / stock_5min / 2003-08-01
file: by_date/stock_5min/2003/2003-08-01.parquet size: 2.2 MB rows: 157,564 symbols: 1,598
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-08-01 08:15:00 | AAPL | Stock | 0.375 | 0.3764 | 0.375 | 0.3764 | 207200.0 |
| 2003-08-01 08:25:00 | AAPL | Stock | 0.3763 | 0.3763 | 0.3763 | 0.3763 | 28000.0 |
| 2003-08-01 08:30:00 | AAPL | Stock | 0.375 | 0.375 | 0.375 | 0.375 | 78400.0 |
| 2003-08-01 08:35:00 | AAPL | Stock | 0.3766 | 0.3766 | 0.3766 | 0.3766 | 140000.0 |
| 2003-08-01 08:40:00 | AAPL | Stock | 0.3766 | 0.3766 | 0.3766 | 0.3766 | 33600.0 |
| 2003-08-01 08:45:00 | AAPL | Stock | 0.3757 | 0.3757 | 0.375 | 0.375 | 28000.0 |
| 2003-08-01 08:50:00 | AAPL | Stock | 0.375 | 0.375 | 0.375 | 0.375 | 28000.0 |
| 2003-08-01 09:00:00 | AAPL | Stock | 0.3757 | 0.3802 | 0.3757 | 0.3802 | 33600.0 |
| 2003-08-01 09:05:00 | AAPL | Stock | 0.3755 | 0.3766 | 0.3755 | 0.3757 | 72800.0 |
| 2003-08-01 09:10:00 | AAPL | Stock | 0.3757 | 0.3757 | 0.3757 | 0.3757 | 16800.0 |
| 2003-08-01 09:15:00 | AAPL | Stock | 0.3763 | 0.3763 | 0.3762 | 0.3763 | 44800.0 |
| 2003-08-01 09:20:00 | AAPL | Stock | 0.3764 | 0.3764 | 0.3764 | 0.3764 | 11200.0 |
| 2003-08-01 09:25:00 | AAPL | Stock | 0.3766 | 0.3766 | 0.3746 | 0.3746 | 196000.0 |
| 2003-08-01 09:30:00 | AAPL | Stock | 0.375 | 0.375 | 0.3738 | 0.3745 | 4032000.0 |
| 2003-08-01 09:35:00 | AAPL | Stock | 0.3746 | 0.3791 | 0.3745 | 0.3786 | 2272032.0 |
| 2003-08-01 09:40:00 | AAPL | Stock | 0.3786 | 0.3798 | 0.3777 | 0.3786 | 3550400.0 |
| 2003-08-01 09:45:00 | AAPL | Stock | 0.3786 | 0.3786 | 0.3763 | 0.378 | 5460728.0 |
| 2003-08-01 09:50:00 | AAPL | Stock | 0.378 | 0.3791 | 0.377 | 0.3777 | 3466400.0 |
| 2003-08-01 09:55:00 | AAPL | Stock | 0.3775 | 0.3777 | 0.375 | 0.3752 | 2447200.0 |
| 2003-08-01 10:00:00 | AAPL | Stock | 0.3752 | 0.3752 | 0.3732 | 0.3736 | 5062848.0 |
| 2003-08-01 10:05:00 | AAPL | Stock | 0.3741 | 0.3757 | 0.3738 | 0.375 | 2643200.0 |
| 2003-08-01 10:10:00 | AAPL | Stock | 0.3748 | 0.3754 | 0.3738 | 0.375 | 1327200.0 |
| 2003-08-01 10:15:00 | AAPL | Stock | 0.375 | 0.3752 | 0.3732 | 0.3732 | 2170728.0 |
| 2003-08-01 10:20:00 | AAPL | Stock | 0.3735 | 0.3743 | 0.3707 | 0.3707 | 2855440.0 |
| 2003-08-01 10:25:00 | AAPL | Stock | 0.3707 | 0.3721 | 0.3697 | 0.3698 | 3122392.0 |
| 2003-08-01 10:30:00 | AAPL | Stock | 0.3698 | 0.3709 | 0.3698 | 0.3698 | 1675016.0 |
| 2003-08-01 10:35:00 | AAPL | Stock | 0.37 | 0.3716 | 0.3691 | 0.3716 | 1288448.0 |
| 2003-08-01 10:40:00 | AAPL | Stock | 0.3716 | 0.372 | 0.3707 | 0.3716 | 1249976.0 |
| 2003-08-01 10:45:00 | AAPL | Stock | 0.3714 | 0.3723 | 0.3707 | 0.3716 | 2155832.0 |
| 2003-08-01 10:50:00 | AAPL | Stock | 0.3714 | 0.3714 | 0.3698 | 0.3705 | 1545600.0 |
| 2003-08-01 10:55:00 | AAPL | Stock | 0.3707 | 0.372 | 0.3702 | 0.372 | 1487360.0 |
| 2003-08-01 11:00:00 | AAPL | Stock | 0.3718 | 0.372 | 0.3702 | 0.3718 | 1114400.0 |
| 2003-08-01 11:05:00 | AAPL | Stock | 0.3721 | 0.3725 | 0.3716 | 0.3723 | 1728048.0 |
| 2003-08-01 11:10:00 | AAPL | Stock | 0.3723 | 0.3738 | 0.3718 | 0.3725 | 1781584.0 |
| 2003-08-01 11:15:00 | AAPL | Stock | 0.3725 | 0.375 | 0.3725 | 0.3743 | 1792616.0 |
| 2003-08-01 11:20:00 | AAPL | Stock | 0.3741 | 0.3741 | 0.3736 | 0.3738 | 812000.0 |
| 2003-08-01 11:25:00 | AAPL | Stock | 0.3739 | 0.3755 | 0.3739 | 0.3755 | 1853600.0 |
| 2003-08-01 11:30:00 | AAPL | Stock | 0.3752 | 0.3759 | 0.3734 | 0.3745 | 2228800.0 |
| 2003-08-01 11:35:00 | AAPL | Stock | 0.3748 | 0.375 | 0.3738 | 0.3739 | 414400.0 |
| 2003-08-01 11:40:00 | AAPL | Stock | 0.3739 | 0.3746 | 0.3736 | 0.3736 | 2038400.0 |
| 2003-08-01 11:45:00 | AAPL | Stock | 0.3734 | 0.3746 | 0.3732 | 0.3743 | 1825600.0 |
| 2003-08-01 11:50:00 | AAPL | Stock | 0.3745 | 0.3748 | 0.3744 | 0.3748 | 414400.0 |
| 2003-08-01 11:55:00 | AAPL | Stock | 0.3748 | 0.3748 | 0.3732 | 0.3732 | 582400.0 |
| 2003-08-01 12:00:00 | AAPL | Stock | 0.3734 | 0.3743 | 0.3734 | 0.3738 | 319200.0 |
| 2003-08-01 12:05:00 | AAPL | Stock | 0.3738 | 0.3738 | 0.3732 | 0.3734 | 515200.0 |
| 2003-08-01 12:10:00 | AAPL | Stock | 0.3732 | 0.3732 | 0.3725 | 0.3725 | 705600.0 |
| 2003-08-01 12:15:00 | AAPL | Stock | 0.3725 | 0.3727 | 0.3723 | 0.3725 | 481264.0 |
| 2003-08-01 12:20:00 | AAPL | Stock | 0.3725 | 0.3729 | 0.3725 | 0.3727 | 1080800.0 |
| 2003-08-01 12:25:00 | AAPL | Stock | 0.3727 | 0.3729 | 0.3723 | 0.3725 | 800800.0 |
| 2003-08-01 12:30:00 | AAPL | Stock | 0.3725 | 0.3725 | 0.3714 | 0.3714 | 3924480.0 |
> showing 50 of 157,564 rows — these rows as CSV