PREVIEW / stock_5min / 2010-09-16
file: by_date/stock_5min/2010/2010-09-16.parquet size: 4.5 MB rows: 316,029 symbols: 3,467
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-09-16 04:35:00 | AAPL | Stock | 9.6536 | 9.6536 | 9.6536 | 9.6536 | 2800.0 |
| 2010-09-16 04:40:00 | AAPL | Stock | 9.6536 | 9.6536 | 9.6536 | 9.6536 | 2800.0 |
| 2010-09-16 06:30:00 | AAPL | Stock | 9.6782 | 9.6782 | 9.6782 | 9.6782 | 2800.0 |
| 2010-09-16 07:00:00 | AAPL | Stock | 9.6864 | 9.6864 | 9.6786 | 9.6786 | 11200.0 |
| 2010-09-16 07:05:00 | AAPL | Stock | 9.6786 | 9.6825 | 9.6786 | 9.6825 | 25200.0 |
| 2010-09-16 07:10:00 | AAPL | Stock | 9.6789 | 9.6857 | 9.6789 | 9.6857 | 53200.0 |
| 2010-09-16 07:20:00 | AAPL | Stock | 9.6839 | 9.6839 | 9.6829 | 9.6829 | 11060.0 |
| 2010-09-16 07:25:00 | AAPL | Stock | 9.6821 | 9.6857 | 9.6786 | 9.6857 | 44800.0 |
| 2010-09-16 07:30:00 | AAPL | Stock | 9.6861 | 9.6861 | 9.6857 | 9.6857 | 93800.0 |
| 2010-09-16 07:35:00 | AAPL | Stock | 9.6857 | 9.6857 | 9.6721 | 9.6721 | 55300.0 |
| 2010-09-16 07:40:00 | AAPL | Stock | 9.6718 | 9.6718 | 9.6714 | 9.6714 | 14000.0 |
| 2010-09-16 07:45:00 | AAPL | Stock | 9.6775 | 9.6779 | 9.6775 | 9.6779 | 14000.0 |
| 2010-09-16 07:50:00 | AAPL | Stock | 9.6789 | 9.6875 | 9.6789 | 9.68 | 70924.0 |
| 2010-09-16 08:00:00 | AAPL | Stock | 9.68 | 9.68 | 9.6714 | 9.6743 | 189140.0 |
| 2010-09-16 08:05:00 | AAPL | Stock | 9.6718 | 9.6768 | 9.6689 | 9.6743 | 211260.0 |
| 2010-09-16 08:10:00 | AAPL | Stock | 9.6721 | 9.6743 | 9.67 | 9.67 | 79800.0 |
| 2010-09-16 08:15:00 | AAPL | Stock | 9.6696 | 9.6732 | 9.6664 | 9.6682 | 189812.0 |
| 2010-09-16 08:20:00 | AAPL | Stock | 9.6682 | 9.6718 | 9.6671 | 9.6696 | 93548.0 |
| 2010-09-16 08:25:00 | AAPL | Stock | 9.6711 | 9.6732 | 9.6643 | 9.6679 | 341012.0 |
| 2010-09-16 08:30:00 | AAPL | Stock | 9.6714 | 9.6839 | 9.6532 | 9.6614 | 1653624.0 |
| 2010-09-16 08:35:00 | AAPL | Stock | 9.6586 | 9.6675 | 9.6539 | 9.665 | 316260.0 |
| 2010-09-16 08:40:00 | AAPL | Stock | 9.67 | 9.6764 | 9.6696 | 9.6721 | 104496.0 |
| 2010-09-16 08:45:00 | AAPL | Stock | 9.6721 | 9.6729 | 9.6657 | 9.6682 | 301280.0 |
| 2010-09-16 08:50:00 | AAPL | Stock | 9.6679 | 9.6693 | 9.6579 | 9.6625 | 159740.0 |
| 2010-09-16 08:55:00 | AAPL | Stock | 9.6621 | 9.6643 | 9.6579 | 9.6625 | 338996.0 |
| 2010-09-16 09:00:00 | AAPL | Stock | 9.6618 | 9.6671 | 9.6607 | 9.6671 | 232988.0 |
| 2010-09-16 09:05:00 | AAPL | Stock | 9.6654 | 9.6721 | 9.6654 | 9.6714 | 159600.0 |
| 2010-09-16 09:10:00 | AAPL | Stock | 9.6686 | 9.6686 | 9.6607 | 9.6614 | 168420.0 |
| 2010-09-16 09:15:00 | AAPL | Stock | 9.6632 | 9.6632 | 9.6614 | 9.6614 | 29204.0 |
| 2010-09-16 09:20:00 | AAPL | Stock | 9.6668 | 9.6714 | 9.6661 | 9.6696 | 119000.0 |
| 2010-09-16 09:25:00 | AAPL | Stock | 9.6671 | 9.6671 | 9.6454 | 9.6514 | 583744.0 |
| 2010-09-16 09:30:00 | AAPL | Stock | 9.6529 | 9.6761 | 9.6504 | 9.665 | 12962460.0 |
| 2010-09-16 09:35:00 | AAPL | Stock | 9.6696 | 9.6786 | 9.6621 | 9.6721 | 10019744.0 |
| 2010-09-16 09:40:00 | AAPL | Stock | 9.6725 | 9.6757 | 9.6464 | 9.6482 | 13039600.0 |
| 2010-09-16 09:45:00 | AAPL | Stock | 9.6482 | 9.6496 | 9.625 | 9.6471 | 11681712.0 |
| 2010-09-16 09:50:00 | AAPL | Stock | 9.6475 | 9.6714 | 9.645 | 9.6707 | 9563316.0 |
| 2010-09-16 09:55:00 | AAPL | Stock | 9.6711 | 9.6725 | 9.6575 | 9.665 | 5286400.0 |
| 2010-09-16 10:00:00 | AAPL | Stock | 9.6625 | 9.6757 | 9.6411 | 9.6679 | 16621976.0 |
| 2010-09-16 10:05:00 | AAPL | Stock | 9.6686 | 9.6789 | 9.6607 | 9.6671 | 10562832.0 |
| 2010-09-16 10:10:00 | AAPL | Stock | 9.6679 | 9.6743 | 9.6614 | 9.6646 | 6339704.0 |
| 2010-09-16 10:15:00 | AAPL | Stock | 9.6643 | 9.6671 | 9.6564 | 9.6629 | 6413008.0 |
| 2010-09-16 10:20:00 | AAPL | Stock | 9.6632 | 9.6818 | 9.6614 | 9.6725 | 9227372.0 |
| 2010-09-16 10:25:00 | AAPL | Stock | 9.673 | 9.6964 | 9.673 | 9.6911 | 17587808.0 |
| 2010-09-16 10:30:00 | AAPL | Stock | 9.6911 | 9.6929 | 9.6796 | 9.6825 | 6736996.0 |
| 2010-09-16 10:35:00 | AAPL | Stock | 9.6832 | 9.7004 | 9.6821 | 9.6943 | 8867264.0 |
| 2010-09-16 10:40:00 | AAPL | Stock | 9.6943 | 9.7082 | 9.6925 | 9.705 | 8458716.0 |
| 2010-09-16 10:45:00 | AAPL | Stock | 9.7057 | 9.7129 | 9.7043 | 9.7121 | 6781684.0 |
| 2010-09-16 10:50:00 | AAPL | Stock | 9.7121 | 9.7182 | 9.71 | 9.7126 | 7553560.0 |
| 2010-09-16 10:55:00 | AAPL | Stock | 9.7132 | 9.7266 | 9.7123 | 9.7161 | 7150780.0 |
| 2010-09-16 11:00:00 | AAPL | Stock | 9.7168 | 9.7232 | 9.7104 | 9.7232 | 4957960.0 |
> showing 50 of 316,029 rows — these rows as CSV