PREVIEW / stock_5min / 2004-01-09
file: by_date/stock_5min/2004/2004-01-09.parquet size: 2.4 MB rows: 172,848 symbols: 1,712
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 |
|---|---|---|---|---|---|---|---|
| 2004-01-09 08:30:00 | AAPL | Stock | 0.4205 | 0.4205 | 0.4152 | 0.4152 | 936376.0 |
| 2004-01-09 08:35:00 | AAPL | Stock | 0.4169 | 0.4169 | 0.4136 | 0.4136 | 58800.0 |
| 2004-01-09 08:40:00 | AAPL | Stock | 0.4136 | 0.4145 | 0.4136 | 0.4145 | 84000.0 |
| 2004-01-09 08:45:00 | AAPL | Stock | 0.4161 | 0.4177 | 0.4161 | 0.4177 | 50680.0 |
| 2004-01-09 08:55:00 | AAPL | Stock | 0.4175 | 0.4175 | 0.4175 | 0.4175 | 5600.0 |
| 2004-01-09 09:05:00 | AAPL | Stock | 0.4161 | 0.4161 | 0.4136 | 0.4143 | 162400.0 |
| 2004-01-09 09:10:00 | AAPL | Stock | 0.4145 | 0.4145 | 0.4136 | 0.4136 | 50400.0 |
| 2004-01-09 09:25:00 | AAPL | Stock | 0.4141 | 0.4161 | 0.4136 | 0.4159 | 582400.0 |
| 2004-01-09 09:30:00 | AAPL | Stock | 0.4148 | 0.4214 | 0.4143 | 0.4196 | 10955784.0 |
| 2004-01-09 09:35:00 | AAPL | Stock | 0.42 | 0.4216 | 0.4196 | 0.421 | 15480192.0 |
| 2004-01-09 09:40:00 | AAPL | Stock | 0.4213 | 0.4213 | 0.4188 | 0.42 | 14356776.0 |
| 2004-01-09 09:45:00 | AAPL | Stock | 0.4202 | 0.4205 | 0.4196 | 0.4204 | 5613104.0 |
| 2004-01-09 09:50:00 | AAPL | Stock | 0.4204 | 0.4257 | 0.4204 | 0.4257 | 9984688.0 |
| 2004-01-09 09:55:00 | AAPL | Stock | 0.4254 | 0.4275 | 0.4248 | 0.4261 | 16086448.0 |
| 2004-01-09 10:00:00 | AAPL | Stock | 0.4261 | 0.4304 | 0.4259 | 0.4288 | 22462440.0 |
| 2004-01-09 10:05:00 | AAPL | Stock | 0.4286 | 0.4304 | 0.4284 | 0.4302 | 15734208.0 |
| 2004-01-09 10:10:00 | AAPL | Stock | 0.4302 | 0.4309 | 0.4284 | 0.4286 | 9815792.0 |
| 2004-01-09 10:15:00 | AAPL | Stock | 0.4286 | 0.4288 | 0.4259 | 0.4259 | 8754200.0 |
| 2004-01-09 10:20:00 | AAPL | Stock | 0.4257 | 0.4275 | 0.4252 | 0.4255 | 6337352.0 |
| 2004-01-09 10:25:00 | AAPL | Stock | 0.4255 | 0.4257 | 0.4239 | 0.4254 | 9537808.0 |
| 2004-01-09 10:30:00 | AAPL | Stock | 0.425 | 0.4252 | 0.4234 | 0.4234 | 6854344.0 |
| 2004-01-09 10:35:00 | AAPL | Stock | 0.4236 | 0.4261 | 0.4236 | 0.4259 | 4887680.0 |
| 2004-01-09 10:40:00 | AAPL | Stock | 0.4261 | 0.4263 | 0.425 | 0.4254 | 3784312.0 |
| 2004-01-09 10:45:00 | AAPL | Stock | 0.4252 | 0.4261 | 0.4243 | 0.4261 | 3586688.0 |
| 2004-01-09 10:50:00 | AAPL | Stock | 0.4261 | 0.427 | 0.4252 | 0.4266 | 3593856.0 |
| 2004-01-09 10:55:00 | AAPL | Stock | 0.4264 | 0.4266 | 0.4261 | 0.4265 | 2986872.0 |
| 2004-01-09 11:00:00 | AAPL | Stock | 0.4266 | 0.4268 | 0.4248 | 0.4248 | 3620904.0 |
| 2004-01-09 11:05:00 | AAPL | Stock | 0.4248 | 0.425 | 0.4238 | 0.4238 | 5045376.0 |
| 2004-01-09 11:10:00 | AAPL | Stock | 0.4241 | 0.4243 | 0.4236 | 0.4241 | 3855096.0 |
| 2004-01-09 11:15:00 | AAPL | Stock | 0.4241 | 0.4241 | 0.4234 | 0.4238 | 2246104.0 |
| 2004-01-09 11:20:00 | AAPL | Stock | 0.4238 | 0.4241 | 0.4237 | 0.4239 | 1747872.0 |
| 2004-01-09 11:25:00 | AAPL | Stock | 0.4239 | 0.4254 | 0.4239 | 0.425 | 1947008.0 |
| 2004-01-09 11:30:00 | AAPL | Stock | 0.425 | 0.4259 | 0.4239 | 0.4241 | 1766632.0 |
| 2004-01-09 11:35:00 | AAPL | Stock | 0.4241 | 0.4241 | 0.4223 | 0.4229 | 4008144.0 |
| 2004-01-09 11:40:00 | AAPL | Stock | 0.4229 | 0.423 | 0.4218 | 0.4223 | 2292416.0 |
| 2004-01-09 11:45:00 | AAPL | Stock | 0.4223 | 0.4232 | 0.4218 | 0.423 | 1980496.0 |
| 2004-01-09 11:50:00 | AAPL | Stock | 0.423 | 0.4232 | 0.4214 | 0.4221 | 8886976.0 |
| 2004-01-09 11:55:00 | AAPL | Stock | 0.4221 | 0.4227 | 0.4216 | 0.4225 | 2032352.0 |
| 2004-01-09 12:00:00 | AAPL | Stock | 0.4225 | 0.4233 | 0.4221 | 0.4227 | 2161936.0 |
| 2004-01-09 12:05:00 | AAPL | Stock | 0.4229 | 0.423 | 0.4219 | 0.4227 | 2674336.0 |
| 2004-01-09 12:10:00 | AAPL | Stock | 0.4227 | 0.4238 | 0.4227 | 0.4237 | 1847216.0 |
| 2004-01-09 12:15:00 | AAPL | Stock | 0.4237 | 0.4241 | 0.4234 | 0.4238 | 2717792.0 |
| 2004-01-09 12:20:00 | AAPL | Stock | 0.4236 | 0.4238 | 0.4236 | 0.4238 | 1931216.0 |
| 2004-01-09 12:25:00 | AAPL | Stock | 0.4236 | 0.4238 | 0.4234 | 0.4234 | 1733760.0 |
| 2004-01-09 12:30:00 | AAPL | Stock | 0.4236 | 0.4236 | 0.423 | 0.423 | 3556056.0 |
| 2004-01-09 12:35:00 | AAPL | Stock | 0.423 | 0.4234 | 0.4218 | 0.4218 | 1449840.0 |
| 2004-01-09 12:40:00 | AAPL | Stock | 0.4218 | 0.4225 | 0.4213 | 0.4223 | 4132408.0 |
| 2004-01-09 12:45:00 | AAPL | Stock | 0.422 | 0.422 | 0.4213 | 0.4213 | 1020040.0 |
| 2004-01-09 12:50:00 | AAPL | Stock | 0.4211 | 0.4214 | 0.4196 | 0.4198 | 1468040.0 |
| 2004-01-09 12:55:00 | AAPL | Stock | 0.4199 | 0.4205 | 0.4198 | 0.4202 | 3437784.0 |
> showing 50 of 172,848 rows — these rows as CSV