PREVIEW / stock_5min / 2006-10-18
file: by_date/stock_5min/2006/2006-10-18.parquet size: 3.2 MB rows: 232,564 symbols: 2,406
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-10-18 07:35:00 | AAPL | Stock | 2.6539 | 2.6539 | 2.6493 | 2.6493 | 13720.0 |
| 2006-10-18 07:40:00 | AAPL | Stock | 2.6493 | 2.6493 | 2.6493 | 2.6493 | 14000.0 |
| 2006-10-18 07:45:00 | AAPL | Stock | 2.6443 | 2.6443 | 2.6443 | 2.6443 | 2800.0 |
| 2006-10-18 07:50:00 | AAPL | Stock | 2.6475 | 2.6475 | 2.6361 | 2.6361 | 47600.0 |
| 2006-10-18 07:55:00 | AAPL | Stock | 2.6432 | 2.6457 | 2.6432 | 2.6457 | 11200.0 |
| 2006-10-18 08:00:00 | AAPL | Stock | 2.6475 | 2.6536 | 2.6443 | 2.6493 | 292600.0 |
| 2006-10-18 08:05:00 | AAPL | Stock | 2.6486 | 2.6543 | 2.6443 | 2.6543 | 210700.0 |
| 2006-10-18 08:10:00 | AAPL | Stock | 2.6579 | 2.6639 | 2.6579 | 2.6639 | 240268.0 |
| 2006-10-18 08:15:00 | AAPL | Stock | 2.6646 | 2.665 | 2.6607 | 2.6625 | 272440.0 |
| 2006-10-18 08:20:00 | AAPL | Stock | 2.6643 | 2.6643 | 2.6625 | 2.6625 | 27160.0 |
| 2006-10-18 08:25:00 | AAPL | Stock | 2.6654 | 2.6654 | 2.6589 | 2.66 | 299236.0 |
| 2006-10-18 08:30:00 | AAPL | Stock | 2.6607 | 2.6671 | 2.6607 | 2.6664 | 736596.0 |
| 2006-10-18 08:35:00 | AAPL | Stock | 2.6654 | 2.6668 | 2.6654 | 2.6668 | 248360.0 |
| 2006-10-18 08:40:00 | AAPL | Stock | 2.6668 | 2.6682 | 2.6661 | 2.6664 | 811524.0 |
| 2006-10-18 08:45:00 | AAPL | Stock | 2.6679 | 2.6679 | 2.6639 | 2.6675 | 334516.0 |
| 2006-10-18 08:50:00 | AAPL | Stock | 2.6675 | 2.6718 | 2.6675 | 2.6707 | 711228.0 |
| 2006-10-18 08:55:00 | AAPL | Stock | 2.6729 | 2.675 | 2.67 | 2.6714 | 130536.0 |
| 2006-10-18 09:20:00 | AAPL | Stock | 2.6714 | 2.6714 | 2.6714 | 2.6714 | 195440.0 |
| 2006-10-18 09:25:00 | AAPL | Stock | 2.6693 | 2.6761 | 2.6661 | 2.6711 | 2101512.0 |
| 2006-10-18 09:30:00 | AAPL | Stock | 2.6696 | 2.6786 | 2.665 | 2.665 | 21991284.0 |
| 2006-10-18 09:35:00 | AAPL | Stock | 2.665 | 2.6746 | 2.655 | 2.6693 | 21110656.0 |
| 2006-10-18 09:40:00 | AAPL | Stock | 2.6693 | 2.6743 | 2.6686 | 2.6704 | 18756724.0 |
| 2006-10-18 09:45:00 | AAPL | Stock | 2.6704 | 2.6875 | 2.67 | 2.6814 | 22832152.0 |
| 2006-10-18 09:50:00 | AAPL | Stock | 2.6818 | 2.6875 | 2.67 | 2.675 | 16457784.0 |
| 2006-10-18 09:55:00 | AAPL | Stock | 2.6746 | 2.6779 | 2.665 | 2.6736 | 16101540.0 |
| 2006-10-18 10:00:00 | AAPL | Stock | 2.6736 | 2.6736 | 2.6614 | 2.6643 | 9676100.0 |
| 2006-10-18 10:05:00 | AAPL | Stock | 2.6639 | 2.6761 | 2.6629 | 2.6743 | 10573220.0 |
| 2006-10-18 10:10:00 | AAPL | Stock | 2.6743 | 2.6754 | 2.6714 | 2.6732 | 6913228.0 |
| 2006-10-18 10:15:00 | AAPL | Stock | 2.6732 | 2.6732 | 2.6654 | 2.6671 | 7064120.0 |
| 2006-10-18 10:20:00 | AAPL | Stock | 2.6671 | 2.6671 | 2.6568 | 2.6607 | 12031040.0 |
| 2006-10-18 10:25:00 | AAPL | Stock | 2.6611 | 2.6661 | 2.6586 | 2.6654 | 7719852.0 |
| 2006-10-18 10:30:00 | AAPL | Stock | 2.6657 | 2.6718 | 2.6643 | 2.6661 | 7003668.0 |
| 2006-10-18 10:35:00 | AAPL | Stock | 2.6657 | 2.6732 | 2.6646 | 2.6714 | 6320776.0 |
| 2006-10-18 10:40:00 | AAPL | Stock | 2.6714 | 2.6732 | 2.6618 | 2.665 | 7915768.0 |
| 2006-10-18 10:45:00 | AAPL | Stock | 2.665 | 2.6679 | 2.6536 | 2.654 | 13017032.0 |
| 2006-10-18 10:50:00 | AAPL | Stock | 2.655 | 2.6607 | 2.6507 | 2.6507 | 11454716.0 |
| 2006-10-18 10:55:00 | AAPL | Stock | 2.6511 | 2.6589 | 2.6504 | 2.6568 | 7993104.0 |
| 2006-10-18 11:00:00 | AAPL | Stock | 2.6568 | 2.6614 | 2.6521 | 2.6532 | 6061356.0 |
| 2006-10-18 11:05:00 | AAPL | Stock | 2.6526 | 2.6536 | 2.6436 | 2.6454 | 15699936.0 |
| 2006-10-18 11:10:00 | AAPL | Stock | 2.6457 | 2.6571 | 2.645 | 2.6486 | 11881688.0 |
| 2006-10-18 11:15:00 | AAPL | Stock | 2.6489 | 2.6504 | 2.6461 | 2.6468 | 6158824.0 |
| 2006-10-18 11:20:00 | AAPL | Stock | 2.6464 | 2.6493 | 2.6436 | 2.6457 | 11220720.0 |
| 2006-10-18 11:25:00 | AAPL | Stock | 2.6457 | 2.6489 | 2.6396 | 2.6443 | 12879384.0 |
| 2006-10-18 11:30:00 | AAPL | Stock | 2.6439 | 2.6489 | 2.64 | 2.6407 | 7865788.0 |
| 2006-10-18 11:35:00 | AAPL | Stock | 2.6407 | 2.6536 | 2.6403 | 2.6479 | 7290444.0 |
| 2006-10-18 11:40:00 | AAPL | Stock | 2.6479 | 2.6532 | 2.6479 | 2.6511 | 8133804.0 |
| 2006-10-18 11:45:00 | AAPL | Stock | 2.6514 | 2.6557 | 2.6507 | 2.6529 | 5188736.0 |
| 2006-10-18 11:50:00 | AAPL | Stock | 2.6532 | 2.6554 | 2.6518 | 2.6536 | 5258484.0 |
| 2006-10-18 11:55:00 | AAPL | Stock | 2.6532 | 2.6589 | 2.6529 | 2.6561 | 7091952.0 |
| 2006-10-18 12:00:00 | AAPL | Stock | 2.6564 | 2.6618 | 2.6557 | 2.6607 | 7922460.0 |
> showing 50 of 232,564 rows — these rows as CSV