PREVIEW / stock_5min / 2010-04-13
file: by_date/stock_5min/2010/2010-04-13.parquet size: 4.8 MB rows: 327,090 symbols: 3,477
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 |
|---|---|---|---|---|---|---|---|
| 2010-04-13 05:35:00 | AAPL | Stock | 8.6357 | 8.6357 | 8.6357 | 8.6357 | 3136.0 |
| 2010-04-13 06:50:00 | AAPL | Stock | 8.65 | 8.65 | 8.65 | 8.65 | 5264.0 |
| 2010-04-13 07:35:00 | AAPL | Stock | 8.6321 | 8.6321 | 8.625 | 8.625 | 30716.0 |
| 2010-04-13 07:50:00 | AAPL | Stock | 8.6257 | 8.6464 | 8.6071 | 8.6464 | 49084.0 |
| 2010-04-13 08:00:00 | AAPL | Stock | 8.6504 | 8.6509 | 8.6318 | 8.6509 | 57120.0 |
| 2010-04-13 08:05:00 | AAPL | Stock | 8.6398 | 8.65 | 8.6393 | 8.65 | 194040.0 |
| 2010-04-13 08:10:00 | AAPL | Stock | 8.6432 | 8.6432 | 8.6429 | 8.6429 | 39900.0 |
| 2010-04-13 08:15:00 | AAPL | Stock | 8.6429 | 8.6464 | 8.6429 | 8.6461 | 45220.0 |
| 2010-04-13 08:20:00 | AAPL | Stock | 8.645 | 8.65 | 8.6357 | 8.6364 | 127736.0 |
| 2010-04-13 08:25:00 | AAPL | Stock | 8.6389 | 8.6389 | 8.6371 | 8.6371 | 23968.0 |
| 2010-04-13 08:30:00 | AAPL | Stock | 8.6371 | 8.6425 | 8.6368 | 8.6375 | 47600.0 |
| 2010-04-13 08:35:00 | AAPL | Stock | 8.6421 | 8.6425 | 8.6375 | 8.6379 | 70000.0 |
| 2010-04-13 08:40:00 | AAPL | Stock | 8.6379 | 8.6421 | 8.6375 | 8.6421 | 80360.0 |
| 2010-04-13 08:45:00 | AAPL | Stock | 8.6425 | 8.6454 | 8.6421 | 8.6429 | 203812.0 |
| 2010-04-13 08:50:00 | AAPL | Stock | 8.6439 | 8.6454 | 8.6411 | 8.6418 | 70000.0 |
| 2010-04-13 08:55:00 | AAPL | Stock | 8.6429 | 8.6446 | 8.6407 | 8.6432 | 148400.0 |
| 2010-04-13 09:00:00 | AAPL | Stock | 8.6414 | 8.6436 | 8.6414 | 8.6432 | 19600.0 |
| 2010-04-13 09:05:00 | AAPL | Stock | 8.6443 | 8.6461 | 8.6411 | 8.6411 | 95452.0 |
| 2010-04-13 09:10:00 | AAPL | Stock | 8.6411 | 8.6425 | 8.6386 | 8.6393 | 42000.0 |
| 2010-04-13 09:15:00 | AAPL | Stock | 8.6404 | 8.6404 | 8.6354 | 8.6354 | 154728.0 |
| 2010-04-13 09:20:00 | AAPL | Stock | 8.6361 | 8.6425 | 8.6357 | 8.6386 | 61600.0 |
| 2010-04-13 09:25:00 | AAPL | Stock | 8.6375 | 8.6443 | 8.6286 | 8.6393 | 377328.0 |
| 2010-04-13 09:30:00 | AAPL | Stock | 8.6389 | 8.6529 | 8.6368 | 8.6418 | 14193396.0 |
| 2010-04-13 09:35:00 | AAPL | Stock | 8.6429 | 8.6518 | 8.6393 | 8.65 | 8189832.0 |
| 2010-04-13 09:40:00 | AAPL | Stock | 8.6489 | 8.6625 | 8.6429 | 8.6596 | 12970188.0 |
| 2010-04-13 09:45:00 | AAPL | Stock | 8.6594 | 8.6693 | 8.6521 | 8.6675 | 5328372.0 |
| 2010-04-13 09:50:00 | AAPL | Stock | 8.6675 | 8.6714 | 8.66 | 8.6636 | 6466656.0 |
| 2010-04-13 09:55:00 | AAPL | Stock | 8.6636 | 8.6696 | 8.6575 | 8.6586 | 4352376.0 |
| 2010-04-13 10:00:00 | AAPL | Stock | 8.6586 | 8.6611 | 8.6521 | 8.6607 | 5682096.0 |
| 2010-04-13 10:05:00 | AAPL | Stock | 8.6618 | 8.6643 | 8.6564 | 8.6586 | 5548032.0 |
| 2010-04-13 10:10:00 | AAPL | Stock | 8.6575 | 8.6671 | 8.6575 | 8.6643 | 4283496.0 |
| 2010-04-13 10:15:00 | AAPL | Stock | 8.6636 | 8.6654 | 8.65 | 8.6504 | 4981480.0 |
| 2010-04-13 10:20:00 | AAPL | Stock | 8.6504 | 8.6521 | 8.6404 | 8.6464 | 9306192.0 |
| 2010-04-13 10:25:00 | AAPL | Stock | 8.6468 | 8.6479 | 8.6289 | 8.6311 | 10618440.0 |
| 2010-04-13 10:30:00 | AAPL | Stock | 8.6311 | 8.6556 | 8.6268 | 8.6332 | 8149848.0 |
| 2010-04-13 10:35:00 | AAPL | Stock | 8.6336 | 8.6489 | 8.6111 | 8.6232 | 11838344.0 |
| 2010-04-13 10:40:00 | AAPL | Stock | 8.6236 | 8.6321 | 8.6193 | 8.6307 | 5394816.0 |
| 2010-04-13 10:45:00 | AAPL | Stock | 8.6311 | 8.6314 | 8.6239 | 8.6261 | 2334304.0 |
| 2010-04-13 10:50:00 | AAPL | Stock | 8.6264 | 8.6354 | 8.625 | 8.6343 | 2542036.0 |
| 2010-04-13 10:55:00 | AAPL | Stock | 8.6343 | 8.6375 | 8.6257 | 8.6279 | 2989000.0 |
| 2010-04-13 11:00:00 | AAPL | Stock | 8.6282 | 8.6303 | 8.6225 | 8.6264 | 4044768.0 |
| 2010-04-13 11:05:00 | AAPL | Stock | 8.6275 | 8.6279 | 8.6189 | 8.6204 | 3608472.0 |
| 2010-04-13 11:10:00 | AAPL | Stock | 8.6204 | 8.6221 | 8.6129 | 8.6221 | 4637948.0 |
| 2010-04-13 11:15:00 | AAPL | Stock | 8.6214 | 8.635 | 8.6196 | 8.6346 | 3156580.0 |
| 2010-04-13 11:20:00 | AAPL | Stock | 8.635 | 8.6429 | 8.6332 | 8.6382 | 4243848.0 |
| 2010-04-13 11:25:00 | AAPL | Stock | 8.6384 | 8.6446 | 8.6366 | 8.6418 | 2418892.0 |
| 2010-04-13 11:30:00 | AAPL | Stock | 8.6425 | 8.6464 | 8.6393 | 8.6407 | 2516360.0 |
| 2010-04-13 11:35:00 | AAPL | Stock | 8.64 | 8.6414 | 8.6321 | 8.6332 | 1798020.0 |
| 2010-04-13 11:40:00 | AAPL | Stock | 8.6332 | 8.6391 | 8.6325 | 8.6354 | 1804040.0 |
| 2010-04-13 11:45:00 | AAPL | Stock | 8.6361 | 8.6386 | 8.6318 | 8.6364 | 1598856.0 |
> showing 50 of 327,090 rows — these rows as CSV