PREVIEW / stock_5min / 2003-11-25
file: by_date/stock_5min/2003/2003-11-25.parquet size: 2.3 MB rows: 168,238 symbols: 1,686
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-11-25 08:00:00 | AAPL | Stock | 0.3786 | 0.3786 | 0.3786 | 0.3786 | 5600.0 |
| 2003-11-25 08:30:00 | AAPL | Stock | 0.3786 | 0.3786 | 0.3786 | 0.3786 | 22400.0 |
| 2003-11-25 09:20:00 | AAPL | Stock | 0.378 | 0.3786 | 0.378 | 0.3786 | 22400.0 |
| 2003-11-25 09:25:00 | AAPL | Stock | 0.3782 | 0.3786 | 0.3782 | 0.3786 | 72800.0 |
| 2003-11-25 09:30:00 | AAPL | Stock | 0.3786 | 0.3793 | 0.3759 | 0.3763 | 3894072.0 |
| 2003-11-25 09:35:00 | AAPL | Stock | 0.3763 | 0.3763 | 0.3732 | 0.3733 | 2091880.0 |
| 2003-11-25 09:40:00 | AAPL | Stock | 0.3733 | 0.375 | 0.3732 | 0.3743 | 1567216.0 |
| 2003-11-25 09:45:00 | AAPL | Stock | 0.3743 | 0.3763 | 0.3739 | 0.3757 | 4140304.0 |
| 2003-11-25 09:50:00 | AAPL | Stock | 0.3755 | 0.3779 | 0.3752 | 0.3773 | 3816792.0 |
| 2003-11-25 09:55:00 | AAPL | Stock | 0.3771 | 0.378 | 0.3761 | 0.3763 | 2968336.0 |
| 2003-11-25 10:00:00 | AAPL | Stock | 0.3763 | 0.3789 | 0.375 | 0.3777 | 3820824.0 |
| 2003-11-25 10:05:00 | AAPL | Stock | 0.3773 | 0.3777 | 0.3757 | 0.3758 | 3065552.0 |
| 2003-11-25 10:10:00 | AAPL | Stock | 0.3761 | 0.3775 | 0.3755 | 0.3775 | 2029160.0 |
| 2003-11-25 10:15:00 | AAPL | Stock | 0.377 | 0.377 | 0.3754 | 0.3761 | 3092264.0 |
| 2003-11-25 10:20:00 | AAPL | Stock | 0.3764 | 0.3768 | 0.3748 | 0.3754 | 2564408.0 |
| 2003-11-25 10:25:00 | AAPL | Stock | 0.3752 | 0.3754 | 0.3741 | 0.3746 | 2862776.0 |
| 2003-11-25 10:30:00 | AAPL | Stock | 0.3746 | 0.3754 | 0.3741 | 0.3753 | 1499064.0 |
| 2003-11-25 10:35:00 | AAPL | Stock | 0.3754 | 0.3763 | 0.3754 | 0.3755 | 2857176.0 |
| 2003-11-25 10:40:00 | AAPL | Stock | 0.3755 | 0.3757 | 0.3746 | 0.3746 | 2445464.0 |
| 2003-11-25 10:45:00 | AAPL | Stock | 0.3746 | 0.3757 | 0.3746 | 0.3752 | 10462368.0 |
| 2003-11-25 10:50:00 | AAPL | Stock | 0.3752 | 0.3752 | 0.3746 | 0.375 | 3070368.0 |
| 2003-11-25 10:55:00 | AAPL | Stock | 0.3748 | 0.375 | 0.3743 | 0.375 | 1270136.0 |
| 2003-11-25 11:00:00 | AAPL | Stock | 0.375 | 0.3752 | 0.3746 | 0.3746 | 1238048.0 |
| 2003-11-25 11:05:00 | AAPL | Stock | 0.3746 | 0.3748 | 0.3745 | 0.3746 | 727608.0 |
| 2003-11-25 11:10:00 | AAPL | Stock | 0.3746 | 0.3748 | 0.3746 | 0.3748 | 890400.0 |
| 2003-11-25 11:15:00 | AAPL | Stock | 0.3746 | 0.3746 | 0.3743 | 0.3743 | 664552.0 |
| 2003-11-25 11:20:00 | AAPL | Stock | 0.3743 | 0.375 | 0.3743 | 0.375 | 1533784.0 |
| 2003-11-25 11:25:00 | AAPL | Stock | 0.3748 | 0.3754 | 0.3748 | 0.375 | 2604000.0 |
| 2003-11-25 11:30:00 | AAPL | Stock | 0.3754 | 0.3754 | 0.3746 | 0.3746 | 1911112.0 |
| 2003-11-25 11:35:00 | AAPL | Stock | 0.3746 | 0.375 | 0.3746 | 0.375 | 1036000.0 |
| 2003-11-25 11:40:00 | AAPL | Stock | 0.375 | 0.3752 | 0.3748 | 0.375 | 1974336.0 |
| 2003-11-25 11:45:00 | AAPL | Stock | 0.375 | 0.3757 | 0.375 | 0.3757 | 3180072.0 |
| 2003-11-25 11:50:00 | AAPL | Stock | 0.3752 | 0.3755 | 0.3752 | 0.3755 | 812112.0 |
| 2003-11-25 11:55:00 | AAPL | Stock | 0.3755 | 0.3757 | 0.375 | 0.3754 | 1170512.0 |
| 2003-11-25 12:00:00 | AAPL | Stock | 0.375 | 0.3754 | 0.375 | 0.3752 | 1587040.0 |
| 2003-11-25 12:05:00 | AAPL | Stock | 0.3752 | 0.3755 | 0.375 | 0.3755 | 2571800.0 |
| 2003-11-25 12:10:00 | AAPL | Stock | 0.3755 | 0.3766 | 0.3752 | 0.3755 | 4299120.0 |
| 2003-11-25 12:15:00 | AAPL | Stock | 0.3759 | 0.3761 | 0.3755 | 0.3761 | 1449728.0 |
| 2003-11-25 12:20:00 | AAPL | Stock | 0.3757 | 0.3759 | 0.375 | 0.3752 | 1505000.0 |
| 2003-11-25 12:25:00 | AAPL | Stock | 0.375 | 0.3757 | 0.3746 | 0.3746 | 4050368.0 |
| 2003-11-25 12:30:00 | AAPL | Stock | 0.3748 | 0.3752 | 0.3746 | 0.3748 | 1738296.0 |
| 2003-11-25 12:35:00 | AAPL | Stock | 0.3748 | 0.3752 | 0.3748 | 0.375 | 467600.0 |
| 2003-11-25 12:40:00 | AAPL | Stock | 0.3748 | 0.3757 | 0.3748 | 0.3757 | 894712.0 |
| 2003-11-25 12:45:00 | AAPL | Stock | 0.3757 | 0.3759 | 0.3755 | 0.3755 | 1110088.0 |
| 2003-11-25 12:50:00 | AAPL | Stock | 0.3757 | 0.3757 | 0.375 | 0.3752 | 425600.0 |
| 2003-11-25 12:55:00 | AAPL | Stock | 0.3752 | 0.3752 | 0.3746 | 0.3748 | 1266104.0 |
| 2003-11-25 13:00:00 | AAPL | Stock | 0.3748 | 0.3748 | 0.3745 | 0.3746 | 1767640.0 |
| 2003-11-25 13:05:00 | AAPL | Stock | 0.3746 | 0.3748 | 0.374 | 0.3741 | 2691640.0 |
| 2003-11-25 13:10:00 | AAPL | Stock | 0.3739 | 0.3743 | 0.3739 | 0.3743 | 917224.0 |
| 2003-11-25 13:15:00 | AAPL | Stock | 0.3741 | 0.3743 | 0.3741 | 0.3743 | 217000.0 |
> showing 50 of 168,238 rows — these rows as CSV