PREVIEW / stock_5min / 2001-07-02
file: by_date/stock_5min/2001/2001-07-02.parquet size: 1.7 MB rows: 118,167 symbols: 1,314
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-07-02 08:20:00 | AAPL | Stock | 0.4286 | 0.4286 | 0.425 | 0.4268 | 56000.0 |
| 2001-07-02 08:40:00 | AAPL | Stock | 0.425 | 0.425 | 0.425 | 0.425 | 5600.0 |
| 2001-07-02 09:25:00 | AAPL | Stock | 0.4223 | 0.4243 | 0.4218 | 0.4232 | 106400.0 |
| 2001-07-02 09:30:00 | AAPL | Stock | 0.4221 | 0.4232 | 0.417 | 0.4189 | 7722400.0 |
| 2001-07-02 09:35:00 | AAPL | Stock | 0.4189 | 0.4196 | 0.4157 | 0.4179 | 8618400.0 |
| 2001-07-02 09:40:00 | AAPL | Stock | 0.4179 | 0.4202 | 0.4171 | 0.4193 | 7537600.0 |
| 2001-07-02 09:45:00 | AAPL | Stock | 0.4195 | 0.4211 | 0.4188 | 0.4202 | 11256000.0 |
| 2001-07-02 09:50:00 | AAPL | Stock | 0.4204 | 0.4204 | 0.4145 | 0.4157 | 8932000.0 |
| 2001-07-02 09:55:00 | AAPL | Stock | 0.4161 | 0.4161 | 0.4132 | 0.4148 | 9794400.0 |
| 2001-07-02 10:00:00 | AAPL | Stock | 0.4155 | 0.4163 | 0.4132 | 0.4163 | 6468000.0 |
| 2001-07-02 10:05:00 | AAPL | Stock | 0.4161 | 0.4184 | 0.4146 | 0.417 | 1999200.0 |
| 2001-07-02 10:10:00 | AAPL | Stock | 0.417 | 0.4204 | 0.4168 | 0.4204 | 3068800.0 |
| 2001-07-02 10:15:00 | AAPL | Stock | 0.4204 | 0.4205 | 0.4193 | 0.4204 | 3192000.0 |
| 2001-07-02 10:20:00 | AAPL | Stock | 0.4204 | 0.4238 | 0.42 | 0.4225 | 4071200.0 |
| 2001-07-02 10:25:00 | AAPL | Stock | 0.4223 | 0.4239 | 0.4193 | 0.4232 | 6837600.0 |
| 2001-07-02 10:30:00 | AAPL | Stock | 0.4232 | 0.4268 | 0.4232 | 0.4245 | 4720800.0 |
| 2001-07-02 10:35:00 | AAPL | Stock | 0.4241 | 0.4241 | 0.4216 | 0.4234 | 1775200.0 |
| 2001-07-02 10:40:00 | AAPL | Stock | 0.4232 | 0.4238 | 0.4193 | 0.4195 | 2615200.0 |
| 2001-07-02 10:45:00 | AAPL | Stock | 0.4196 | 0.4214 | 0.4195 | 0.4214 | 5040000.0 |
| 2001-07-02 10:50:00 | AAPL | Stock | 0.4214 | 0.4214 | 0.4196 | 0.4196 | 744800.0 |
| 2001-07-02 10:55:00 | AAPL | Stock | 0.4196 | 0.422 | 0.4193 | 0.4196 | 7935200.0 |
| 2001-07-02 11:00:00 | AAPL | Stock | 0.4196 | 0.4205 | 0.4193 | 0.4196 | 1170400.0 |
| 2001-07-02 11:05:00 | AAPL | Stock | 0.4196 | 0.4196 | 0.4188 | 0.4196 | 2077600.0 |
| 2001-07-02 11:10:00 | AAPL | Stock | 0.4196 | 0.422 | 0.4195 | 0.4214 | 2385600.0 |
| 2001-07-02 11:15:00 | AAPL | Stock | 0.4214 | 0.422 | 0.4202 | 0.4216 | 3595200.0 |
| 2001-07-02 11:20:00 | AAPL | Stock | 0.4216 | 0.4216 | 0.4189 | 0.4204 | 666400.0 |
| 2001-07-02 11:25:00 | AAPL | Stock | 0.42 | 0.4214 | 0.42 | 0.4211 | 1859200.0 |
| 2001-07-02 11:30:00 | AAPL | Stock | 0.4211 | 0.4214 | 0.42 | 0.42 | 1808800.0 |
| 2001-07-02 11:35:00 | AAPL | Stock | 0.4211 | 0.422 | 0.4207 | 0.422 | 1988000.0 |
| 2001-07-02 11:40:00 | AAPL | Stock | 0.422 | 0.4241 | 0.422 | 0.4234 | 1898400.0 |
| 2001-07-02 11:45:00 | AAPL | Stock | 0.4227 | 0.4229 | 0.4211 | 0.4227 | 711200.0 |
| 2001-07-02 11:50:00 | AAPL | Stock | 0.423 | 0.4252 | 0.423 | 0.4252 | 2716000.0 |
| 2001-07-02 11:55:00 | AAPL | Stock | 0.4254 | 0.4263 | 0.4252 | 0.4255 | 5964000.0 |
| 2001-07-02 12:00:00 | AAPL | Stock | 0.4248 | 0.4248 | 0.4229 | 0.4239 | 1125600.0 |
| 2001-07-02 12:05:00 | AAPL | Stock | 0.4239 | 0.4261 | 0.4239 | 0.4255 | 1500800.0 |
| 2001-07-02 12:10:00 | AAPL | Stock | 0.4252 | 0.4257 | 0.4241 | 0.4243 | 996800.0 |
| 2001-07-02 12:15:00 | AAPL | Stock | 0.4241 | 0.4248 | 0.423 | 0.4236 | 1416800.0 |
| 2001-07-02 12:20:00 | AAPL | Stock | 0.4232 | 0.4238 | 0.4232 | 0.4232 | 621600.0 |
| 2001-07-02 12:25:00 | AAPL | Stock | 0.4234 | 0.4243 | 0.4234 | 0.4241 | 627200.0 |
| 2001-07-02 12:30:00 | AAPL | Stock | 0.4241 | 0.425 | 0.4238 | 0.4245 | 683200.0 |
| 2001-07-02 12:35:00 | AAPL | Stock | 0.425 | 0.4259 | 0.4245 | 0.4255 | 1069600.0 |
| 2001-07-02 12:40:00 | AAPL | Stock | 0.4259 | 0.4263 | 0.4245 | 0.4246 | 756000.0 |
| 2001-07-02 12:45:00 | AAPL | Stock | 0.425 | 0.4255 | 0.4245 | 0.4252 | 862400.0 |
| 2001-07-02 12:50:00 | AAPL | Stock | 0.425 | 0.4255 | 0.4241 | 0.4241 | 868000.0 |
| 2001-07-02 12:55:00 | AAPL | Stock | 0.4239 | 0.4248 | 0.423 | 0.4248 | 1652000.0 |
| 2001-07-02 13:00:00 | AAPL | Stock | 0.4245 | 0.4252 | 0.4245 | 0.4245 | 1008000.0 |
| 2001-07-02 13:05:00 | AAPL | Stock | 0.4245 | 0.4254 | 0.4245 | 0.4252 | 476000.0 |
| 2001-07-02 13:10:00 | AAPL | Stock | 0.4254 | 0.4257 | 0.4245 | 0.4257 | 2262400.0 |
| 2001-07-02 13:15:00 | AAPL | Stock | 0.4254 | 0.4257 | 0.4232 | 0.4248 | 1108800.0 |
| 2001-07-02 13:20:00 | AAPL | Stock | 0.4248 | 0.4254 | 0.4243 | 0.4252 | 1114400.0 |
> showing 50 of 118,167 rows — these rows as CSV