PREVIEW / stock_5min / 2006-09-25
file: by_date/stock_5min/2006/2006-09-25.parquet size: 3.2 MB rows: 228,665 symbols: 2,380
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 |
|---|---|---|---|---|---|---|---|
| 2006-09-25 07:10:00 | AAPL | Stock | 2.6239 | 2.6239 | 2.6239 | 2.6239 | 2800.0 |
| 2006-09-25 07:15:00 | AAPL | Stock | 2.6357 | 2.6357 | 2.6286 | 2.6286 | 8400.0 |
| 2006-09-25 07:30:00 | AAPL | Stock | 2.6339 | 2.6339 | 2.6339 | 2.6339 | 14000.0 |
| 2006-09-25 08:00:00 | AAPL | Stock | 2.6354 | 2.6364 | 2.6264 | 2.6318 | 1217440.0 |
| 2006-09-25 08:05:00 | AAPL | Stock | 2.6336 | 2.6343 | 2.6293 | 2.6314 | 450156.0 |
| 2006-09-25 08:10:00 | AAPL | Stock | 2.6321 | 2.6332 | 2.6304 | 2.6304 | 147560.0 |
| 2006-09-25 08:15:00 | AAPL | Stock | 2.6318 | 2.6332 | 2.6304 | 2.6321 | 374976.0 |
| 2006-09-25 08:20:00 | AAPL | Stock | 2.6329 | 2.6332 | 2.6307 | 2.6329 | 182560.0 |
| 2006-09-25 08:25:00 | AAPL | Stock | 2.6314 | 2.6329 | 2.6311 | 2.6311 | 518560.0 |
| 2006-09-25 08:30:00 | AAPL | Stock | 2.6318 | 2.6321 | 2.6286 | 2.6286 | 112700.0 |
| 2006-09-25 08:35:00 | AAPL | Stock | 2.6304 | 2.6321 | 2.6304 | 2.6318 | 78624.0 |
| 2006-09-25 08:40:00 | AAPL | Stock | 2.6311 | 2.6311 | 2.63 | 2.6311 | 154140.0 |
| 2006-09-25 08:45:00 | AAPL | Stock | 2.6314 | 2.6321 | 2.6304 | 2.6321 | 72800.0 |
| 2006-09-25 08:50:00 | AAPL | Stock | 2.6321 | 2.6321 | 2.6314 | 2.6321 | 382480.0 |
| 2006-09-25 08:55:00 | AAPL | Stock | 2.6321 | 2.6336 | 2.6318 | 2.6325 | 459564.0 |
| 2006-09-25 09:00:00 | AAPL | Stock | 2.6332 | 2.6332 | 2.6321 | 2.6329 | 114800.0 |
| 2006-09-25 09:05:00 | AAPL | Stock | 2.6321 | 2.6321 | 2.6304 | 2.6304 | 163856.0 |
| 2006-09-25 09:10:00 | AAPL | Stock | 2.6304 | 2.6368 | 2.6304 | 2.6339 | 1214304.0 |
| 2006-09-25 09:15:00 | AAPL | Stock | 2.6354 | 2.6357 | 2.6321 | 2.6339 | 567364.0 |
| 2006-09-25 09:20:00 | AAPL | Stock | 2.6343 | 2.6379 | 2.6343 | 2.6368 | 393540.0 |
| 2006-09-25 09:25:00 | AAPL | Stock | 2.6361 | 2.6375 | 2.6343 | 2.6357 | 809760.0 |
| 2006-09-25 09:30:00 | AAPL | Stock | 2.6361 | 2.6532 | 2.6329 | 2.6464 | 31471692.0 |
| 2006-09-25 09:35:00 | AAPL | Stock | 2.6468 | 2.6582 | 2.6443 | 2.6504 | 21166376.0 |
| 2006-09-25 09:40:00 | AAPL | Stock | 2.6507 | 2.6571 | 2.645 | 2.6475 | 12581268.0 |
| 2006-09-25 09:45:00 | AAPL | Stock | 2.6471 | 2.6561 | 2.6464 | 2.6507 | 11911200.0 |
| 2006-09-25 09:50:00 | AAPL | Stock | 2.6507 | 2.6554 | 2.645 | 2.6539 | 13790000.0 |
| 2006-09-25 09:55:00 | AAPL | Stock | 2.6539 | 2.6636 | 2.65 | 2.6611 | 24087728.0 |
| 2006-09-25 10:00:00 | AAPL | Stock | 2.6611 | 2.6661 | 2.6557 | 2.6618 | 26281920.0 |
| 2006-09-25 10:05:00 | AAPL | Stock | 2.6621 | 2.6668 | 2.6575 | 2.6589 | 19182632.0 |
| 2006-09-25 10:10:00 | AAPL | Stock | 2.6582 | 2.6586 | 2.6457 | 2.6493 | 19973156.0 |
| 2006-09-25 10:15:00 | AAPL | Stock | 2.6493 | 2.6521 | 2.6436 | 2.645 | 19758396.0 |
| 2006-09-25 10:20:00 | AAPL | Stock | 2.645 | 2.6525 | 2.6443 | 2.6514 | 11667712.0 |
| 2006-09-25 10:25:00 | AAPL | Stock | 2.6514 | 2.6518 | 2.6464 | 2.6475 | 9818816.0 |
| 2006-09-25 10:30:00 | AAPL | Stock | 2.6471 | 2.6486 | 2.6396 | 2.6439 | 14967680.0 |
| 2006-09-25 10:35:00 | AAPL | Stock | 2.6439 | 2.6475 | 2.6386 | 2.6422 | 12020316.0 |
| 2006-09-25 10:40:00 | AAPL | Stock | 2.6425 | 2.6446 | 2.6396 | 2.6396 | 6008352.0 |
| 2006-09-25 10:45:00 | AAPL | Stock | 2.64 | 2.6429 | 2.6357 | 2.6421 | 10118248.0 |
| 2006-09-25 10:50:00 | AAPL | Stock | 2.6418 | 2.6511 | 2.6407 | 2.6507 | 12038096.0 |
| 2006-09-25 10:55:00 | AAPL | Stock | 2.6507 | 2.66 | 2.65 | 2.6564 | 15790292.0 |
| 2006-09-25 11:00:00 | AAPL | Stock | 2.6561 | 2.6614 | 2.6546 | 2.6554 | 11669980.0 |
| 2006-09-25 11:05:00 | AAPL | Stock | 2.6554 | 2.6646 | 2.6543 | 2.6636 | 14286468.0 |
| 2006-09-25 11:10:00 | AAPL | Stock | 2.6636 | 2.6689 | 2.6586 | 2.6657 | 13784764.0 |
| 2006-09-25 11:15:00 | AAPL | Stock | 2.6657 | 2.6696 | 2.6639 | 2.6668 | 10856272.0 |
| 2006-09-25 11:20:00 | AAPL | Stock | 2.6668 | 2.6789 | 2.6668 | 2.6771 | 20555808.0 |
| 2006-09-25 11:25:00 | AAPL | Stock | 2.6771 | 2.6818 | 2.6736 | 2.6761 | 19779676.0 |
| 2006-09-25 11:30:00 | AAPL | Stock | 2.6764 | 2.6796 | 2.6704 | 2.6721 | 10987424.0 |
| 2006-09-25 11:35:00 | AAPL | Stock | 2.6725 | 2.6746 | 2.6693 | 2.6721 | 5814956.0 |
| 2006-09-25 11:40:00 | AAPL | Stock | 2.6721 | 2.6768 | 2.6711 | 2.6768 | 5703488.0 |
| 2006-09-25 11:45:00 | AAPL | Stock | 2.6767 | 2.6771 | 2.6686 | 2.6707 | 7119168.0 |
| 2006-09-25 11:50:00 | AAPL | Stock | 2.6707 | 2.6746 | 2.6707 | 2.6732 | 4841648.0 |
> showing 50 of 228,665 rows — these rows as CSV