PREVIEW / stock_5min / 2003-10-27
file: by_date/stock_5min/2003/2003-10-27.parquet size: 2.2 MB rows: 156,872 symbols: 1,654
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-10-27 09:00:00 | AAPL | Stock | 0.4036 | 0.4036 | 0.4036 | 0.4036 | 89600.0 |
| 2003-10-27 09:15:00 | AAPL | Stock | 0.4063 | 0.4063 | 0.4063 | 0.4063 | 28000.0 |
| 2003-10-27 09:20:00 | AAPL | Stock | 0.4054 | 0.4054 | 0.4054 | 0.4054 | 28000.0 |
| 2003-10-27 09:25:00 | AAPL | Stock | 0.4063 | 0.4063 | 0.4054 | 0.4054 | 162400.0 |
| 2003-10-27 09:30:00 | AAPL | Stock | 0.4063 | 0.408 | 0.4038 | 0.4078 | 11392808.0 |
| 2003-10-27 09:35:00 | AAPL | Stock | 0.4079 | 0.4086 | 0.4077 | 0.4079 | 4097968.0 |
| 2003-10-27 09:40:00 | AAPL | Stock | 0.4079 | 0.4084 | 0.4079 | 0.4084 | 2492000.0 |
| 2003-10-27 09:45:00 | AAPL | Stock | 0.4084 | 0.4088 | 0.408 | 0.4084 | 7548744.0 |
| 2003-10-27 09:50:00 | AAPL | Stock | 0.4088 | 0.4088 | 0.4071 | 0.4071 | 1814400.0 |
| 2003-10-27 09:55:00 | AAPL | Stock | 0.4071 | 0.4073 | 0.4066 | 0.407 | 3001600.0 |
| 2003-10-27 10:00:00 | AAPL | Stock | 0.4071 | 0.4082 | 0.407 | 0.4077 | 5222448.0 |
| 2003-10-27 10:05:00 | AAPL | Stock | 0.4079 | 0.4079 | 0.4073 | 0.4073 | 1456000.0 |
| 2003-10-27 10:10:00 | AAPL | Stock | 0.4073 | 0.408 | 0.407 | 0.4079 | 1612800.0 |
| 2003-10-27 10:15:00 | AAPL | Stock | 0.4075 | 0.4075 | 0.4066 | 0.407 | 4211200.0 |
| 2003-10-27 10:20:00 | AAPL | Stock | 0.4071 | 0.4071 | 0.4052 | 0.4057 | 3191776.0 |
| 2003-10-27 10:25:00 | AAPL | Stock | 0.4059 | 0.4066 | 0.4034 | 0.4039 | 3585792.0 |
| 2003-10-27 10:30:00 | AAPL | Stock | 0.4044 | 0.4054 | 0.4039 | 0.405 | 1192800.0 |
| 2003-10-27 10:35:00 | AAPL | Stock | 0.405 | 0.405 | 0.4025 | 0.4038 | 2691192.0 |
| 2003-10-27 10:40:00 | AAPL | Stock | 0.4036 | 0.4043 | 0.4034 | 0.4034 | 1439200.0 |
| 2003-10-27 10:45:00 | AAPL | Stock | 0.4032 | 0.4045 | 0.4027 | 0.4039 | 991200.0 |
| 2003-10-27 10:50:00 | AAPL | Stock | 0.4039 | 0.4054 | 0.4036 | 0.4041 | 683200.0 |
| 2003-10-27 10:55:00 | AAPL | Stock | 0.4041 | 0.405 | 0.4027 | 0.4043 | 2356480.0 |
| 2003-10-27 11:00:00 | AAPL | Stock | 0.4038 | 0.4041 | 0.4025 | 0.403 | 1218056.0 |
| 2003-10-27 11:05:00 | AAPL | Stock | 0.4032 | 0.4038 | 0.4025 | 0.4027 | 1402576.0 |
| 2003-10-27 11:10:00 | AAPL | Stock | 0.4027 | 0.4029 | 0.402 | 0.4027 | 1877624.0 |
| 2003-10-27 11:15:00 | AAPL | Stock | 0.4027 | 0.4034 | 0.4025 | 0.4032 | 1601488.0 |
| 2003-10-27 11:20:00 | AAPL | Stock | 0.4036 | 0.4045 | 0.403 | 0.4039 | 891352.0 |
| 2003-10-27 11:25:00 | AAPL | Stock | 0.4038 | 0.4045 | 0.4038 | 0.4039 | 677600.0 |
| 2003-10-27 11:30:00 | AAPL | Stock | 0.4041 | 0.4041 | 0.4027 | 0.4029 | 2060800.0 |
| 2003-10-27 11:35:00 | AAPL | Stock | 0.4029 | 0.4029 | 0.4016 | 0.4021 | 2255680.0 |
| 2003-10-27 11:40:00 | AAPL | Stock | 0.4025 | 0.4025 | 0.4021 | 0.4023 | 274400.0 |
| 2003-10-27 11:45:00 | AAPL | Stock | 0.4023 | 0.4024 | 0.4016 | 0.4023 | 1590400.0 |
| 2003-10-27 11:50:00 | AAPL | Stock | 0.4025 | 0.4033 | 0.4023 | 0.4027 | 2884952.0 |
| 2003-10-27 11:55:00 | AAPL | Stock | 0.4025 | 0.4038 | 0.4025 | 0.4036 | 2998688.0 |
| 2003-10-27 12:00:00 | AAPL | Stock | 0.4036 | 0.4041 | 0.403 | 0.4036 | 1870400.0 |
| 2003-10-27 12:05:00 | AAPL | Stock | 0.4039 | 0.4043 | 0.4038 | 0.4041 | 526400.0 |
| 2003-10-27 12:10:00 | AAPL | Stock | 0.4039 | 0.4041 | 0.4034 | 0.4039 | 2749600.0 |
| 2003-10-27 12:15:00 | AAPL | Stock | 0.4041 | 0.4041 | 0.4034 | 0.4039 | 618800.0 |
| 2003-10-27 12:20:00 | AAPL | Stock | 0.4039 | 0.4043 | 0.4034 | 0.4039 | 1234800.0 |
| 2003-10-27 12:25:00 | AAPL | Stock | 0.4038 | 0.4041 | 0.4036 | 0.4039 | 491736.0 |
| 2003-10-27 12:30:00 | AAPL | Stock | 0.4038 | 0.4039 | 0.4032 | 0.4036 | 445928.0 |
| 2003-10-27 12:35:00 | AAPL | Stock | 0.4039 | 0.4039 | 0.4034 | 0.4034 | 285600.0 |
| 2003-10-27 12:40:00 | AAPL | Stock | 0.4036 | 0.4036 | 0.403 | 0.403 | 470400.0 |
| 2003-10-27 12:45:00 | AAPL | Stock | 0.403 | 0.403 | 0.4023 | 0.4025 | 560000.0 |
| 2003-10-27 12:50:00 | AAPL | Stock | 0.4023 | 0.4027 | 0.4018 | 0.4021 | 1581440.0 |
| 2003-10-27 12:55:00 | AAPL | Stock | 0.4021 | 0.4027 | 0.4018 | 0.4018 | 1030400.0 |
| 2003-10-27 13:00:00 | AAPL | Stock | 0.4018 | 0.4029 | 0.4016 | 0.4028 | 3849832.0 |
| 2003-10-27 13:05:00 | AAPL | Stock | 0.4029 | 0.4034 | 0.4029 | 0.4029 | 616000.0 |
| 2003-10-27 13:10:00 | AAPL | Stock | 0.4032 | 0.4032 | 0.4023 | 0.403 | 1486800.0 |
| 2003-10-27 13:15:00 | AAPL | Stock | 0.4034 | 0.4036 | 0.4023 | 0.4032 | 1439200.0 |
> showing 50 of 156,872 rows — these rows as CSV