PREVIEW / stock_5min / 2001-05-18
file: by_date/stock_5min/2001/2001-05-18.parquet size: 1.5 MB rows: 106,146 symbols: 1,301
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 |
|---|---|---|---|---|---|---|---|
| 2001-05-18 08:20:00 | AAPL | Stock | 0.4214 | 0.4214 | 0.4214 | 0.4214 | 33600.0 |
| 2001-05-18 08:25:00 | AAPL | Stock | 0.4214 | 0.4214 | 0.4214 | 0.4214 | 11200.0 |
| 2001-05-18 08:30:00 | AAPL | Stock | 0.4214 | 0.4214 | 0.4148 | 0.4179 | 324800.0 |
| 2001-05-18 08:40:00 | AAPL | Stock | 0.4161 | 0.4179 | 0.4161 | 0.4161 | 117600.0 |
| 2001-05-18 08:45:00 | AAPL | Stock | 0.4195 | 0.4195 | 0.4182 | 0.4182 | 22400.0 |
| 2001-05-18 08:50:00 | AAPL | Stock | 0.4168 | 0.4168 | 0.4168 | 0.4168 | 5600.0 |
| 2001-05-18 09:05:00 | AAPL | Stock | 0.4196 | 0.4196 | 0.4196 | 0.4196 | 11200.0 |
| 2001-05-18 09:15:00 | AAPL | Stock | 0.4193 | 0.4209 | 0.4189 | 0.4209 | 240800.0 |
| 2001-05-18 09:20:00 | AAPL | Stock | 0.4209 | 0.4218 | 0.4209 | 0.4218 | 67200.0 |
| 2001-05-18 09:25:00 | AAPL | Stock | 0.4221 | 0.4227 | 0.4161 | 0.4193 | 1484000.0 |
| 2001-05-18 09:30:00 | AAPL | Stock | 0.4171 | 0.418 | 0.4155 | 0.4179 | 10673600.0 |
| 2001-05-18 09:35:00 | AAPL | Stock | 0.418 | 0.4188 | 0.4171 | 0.4184 | 3393600.0 |
| 2001-05-18 09:40:00 | AAPL | Stock | 0.4184 | 0.4221 | 0.4175 | 0.4177 | 2598400.0 |
| 2001-05-18 09:45:00 | AAPL | Stock | 0.4177 | 0.4177 | 0.4134 | 0.4138 | 3864000.0 |
| 2001-05-18 09:50:00 | AAPL | Stock | 0.4134 | 0.418 | 0.4134 | 0.4159 | 2290400.0 |
| 2001-05-18 09:55:00 | AAPL | Stock | 0.4154 | 0.4188 | 0.4154 | 0.4188 | 688800.0 |
| 2001-05-18 10:00:00 | AAPL | Stock | 0.4163 | 0.4186 | 0.4163 | 0.4173 | 1556800.0 |
| 2001-05-18 10:05:00 | AAPL | Stock | 0.4173 | 0.4193 | 0.4171 | 0.4191 | 2553600.0 |
| 2001-05-18 10:10:00 | AAPL | Stock | 0.4195 | 0.42 | 0.4182 | 0.4182 | 3864000.0 |
| 2001-05-18 10:15:00 | AAPL | Stock | 0.4179 | 0.4193 | 0.4173 | 0.4184 | 1652000.0 |
| 2001-05-18 10:20:00 | AAPL | Stock | 0.4184 | 0.4204 | 0.4184 | 0.4198 | 2105600.0 |
| 2001-05-18 10:25:00 | AAPL | Stock | 0.4196 | 0.4202 | 0.417 | 0.4179 | 2340800.0 |
| 2001-05-18 10:30:00 | AAPL | Stock | 0.4179 | 0.4188 | 0.4168 | 0.4168 | 1792000.0 |
| 2001-05-18 10:35:00 | AAPL | Stock | 0.417 | 0.4186 | 0.4168 | 0.418 | 2128000.0 |
| 2001-05-18 10:40:00 | AAPL | Stock | 0.4179 | 0.4182 | 0.417 | 0.417 | 2195200.0 |
| 2001-05-18 10:45:00 | AAPL | Stock | 0.417 | 0.4188 | 0.417 | 0.4188 | 1304800.0 |
| 2001-05-18 10:50:00 | AAPL | Stock | 0.418 | 0.4188 | 0.418 | 0.4188 | 582400.0 |
| 2001-05-18 10:55:00 | AAPL | Stock | 0.4188 | 0.4191 | 0.4171 | 0.4188 | 1624000.0 |
| 2001-05-18 11:00:00 | AAPL | Stock | 0.4188 | 0.4188 | 0.417 | 0.417 | 588000.0 |
| 2001-05-18 11:05:00 | AAPL | Stock | 0.417 | 0.4188 | 0.417 | 0.417 | 2391200.0 |
| 2001-05-18 11:10:00 | AAPL | Stock | 0.417 | 0.418 | 0.417 | 0.4179 | 985600.0 |
| 2001-05-18 11:15:00 | AAPL | Stock | 0.4179 | 0.4188 | 0.417 | 0.417 | 1584800.0 |
| 2001-05-18 11:20:00 | AAPL | Stock | 0.4171 | 0.4177 | 0.4168 | 0.4168 | 851200.0 |
| 2001-05-18 11:25:00 | AAPL | Stock | 0.4171 | 0.4188 | 0.417 | 0.4177 | 403200.0 |
| 2001-05-18 11:30:00 | AAPL | Stock | 0.4177 | 0.4179 | 0.4171 | 0.4177 | 694400.0 |
| 2001-05-18 11:35:00 | AAPL | Stock | 0.4179 | 0.4179 | 0.4171 | 0.4179 | 722400.0 |
| 2001-05-18 11:40:00 | AAPL | Stock | 0.4175 | 0.4179 | 0.4171 | 0.4175 | 694400.0 |
| 2001-05-18 11:45:00 | AAPL | Stock | 0.4175 | 0.4177 | 0.4152 | 0.4161 | 1086400.0 |
| 2001-05-18 11:50:00 | AAPL | Stock | 0.4161 | 0.4175 | 0.4146 | 0.417 | 957600.0 |
| 2001-05-18 11:55:00 | AAPL | Stock | 0.4164 | 0.4173 | 0.4161 | 0.417 | 532000.0 |
| 2001-05-18 12:00:00 | AAPL | Stock | 0.4173 | 0.4175 | 0.4159 | 0.4161 | 1764000.0 |
| 2001-05-18 12:05:00 | AAPL | Stock | 0.4161 | 0.418 | 0.4161 | 0.4179 | 901600.0 |
| 2001-05-18 12:10:00 | AAPL | Stock | 0.417 | 0.4177 | 0.417 | 0.4171 | 224000.0 |
| 2001-05-18 12:15:00 | AAPL | Stock | 0.4171 | 0.4175 | 0.4166 | 0.4166 | 728000.0 |
| 2001-05-18 12:20:00 | AAPL | Stock | 0.4168 | 0.4179 | 0.4166 | 0.4175 | 1232000.0 |
| 2001-05-18 12:25:00 | AAPL | Stock | 0.4175 | 0.4175 | 0.4168 | 0.417 | 386400.0 |
| 2001-05-18 12:30:00 | AAPL | Stock | 0.417 | 0.417 | 0.4168 | 0.4168 | 700000.0 |
| 2001-05-18 12:35:00 | AAPL | Stock | 0.4166 | 0.417 | 0.4166 | 0.4166 | 616000.0 |
| 2001-05-18 12:40:00 | AAPL | Stock | 0.4166 | 0.4166 | 0.4161 | 0.4161 | 397600.0 |
| 2001-05-18 12:45:00 | AAPL | Stock | 0.4161 | 0.4164 | 0.4152 | 0.4164 | 431200.0 |
> showing 50 of 106,146 rows — these rows as CSV