PREVIEW / stock_1min / 2005-08-31
file: by_date/stock_1min/2005/2005-08-31.parquet size: 7.4 MB rows: 597,050 symbols: 1,700
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 |
|---|---|---|---|---|---|---|---|
| 2005-08-31 08:00:00 | AAPL | Stock | 1.6632 | 1.6693 | 1.6632 | 1.6693 | 8400.0 |
| 2005-08-31 08:03:00 | AAPL | Stock | 1.6679 | 1.6679 | 1.6679 | 1.6679 | 2800.0 |
| 2005-08-31 08:06:00 | AAPL | Stock | 1.6679 | 1.6693 | 1.6679 | 1.6693 | 30800.0 |
| 2005-08-31 08:07:00 | AAPL | Stock | 1.6743 | 1.6743 | 1.6743 | 1.6743 | 65800.0 |
| 2005-08-31 08:08:00 | AAPL | Stock | 1.6739 | 1.6739 | 1.6739 | 1.6739 | 16800.0 |
| 2005-08-31 08:11:00 | AAPL | Stock | 1.6739 | 1.6739 | 1.6739 | 1.6739 | 4732.0 |
| 2005-08-31 08:16:00 | AAPL | Stock | 1.6718 | 1.6718 | 1.6718 | 1.6718 | 2800.0 |
| 2005-08-31 08:20:00 | AAPL | Stock | 1.6707 | 1.6707 | 1.67 | 1.67 | 11200.0 |
| 2005-08-31 08:22:00 | AAPL | Stock | 1.6718 | 1.6718 | 1.6718 | 1.6718 | 5600.0 |
| 2005-08-31 08:29:00 | AAPL | Stock | 1.6704 | 1.6704 | 1.6696 | 1.6696 | 40460.0 |
| 2005-08-31 08:30:00 | AAPL | Stock | 1.67 | 1.67 | 1.6693 | 1.6696 | 74200.0 |
| 2005-08-31 08:31:00 | AAPL | Stock | 1.6693 | 1.6693 | 1.6693 | 1.6693 | 28000.0 |
| 2005-08-31 08:32:00 | AAPL | Stock | 1.6693 | 1.6693 | 1.6693 | 1.6693 | 56000.0 |
| 2005-08-31 08:34:00 | AAPL | Stock | 1.6693 | 1.6693 | 1.6679 | 1.6686 | 85540.0 |
| 2005-08-31 08:35:00 | AAPL | Stock | 1.6686 | 1.6686 | 1.6646 | 1.6646 | 34860.0 |
| 2005-08-31 08:37:00 | AAPL | Stock | 1.665 | 1.6661 | 1.665 | 1.6661 | 11200.0 |
| 2005-08-31 08:45:00 | AAPL | Stock | 1.665 | 1.665 | 1.665 | 1.665 | 14000.0 |
| 2005-08-31 08:48:00 | AAPL | Stock | 1.665 | 1.665 | 1.665 | 1.665 | 2800.0 |
| 2005-08-31 08:49:00 | AAPL | Stock | 1.665 | 1.6689 | 1.665 | 1.6689 | 42000.0 |
| 2005-08-31 08:52:00 | AAPL | Stock | 1.665 | 1.665 | 1.665 | 1.665 | 11200.0 |
| 2005-08-31 09:05:00 | AAPL | Stock | 1.6679 | 1.6679 | 1.6675 | 1.6679 | 37520.0 |
| 2005-08-31 09:06:00 | AAPL | Stock | 1.6682 | 1.6682 | 1.6682 | 1.6682 | 28000.0 |
| 2005-08-31 09:09:00 | AAPL | Stock | 1.6682 | 1.6682 | 1.6682 | 1.6682 | 8400.0 |
| 2005-08-31 09:10:00 | AAPL | Stock | 1.6682 | 1.6682 | 1.6682 | 1.6682 | 2800.0 |
| 2005-08-31 09:11:00 | AAPL | Stock | 1.6657 | 1.6657 | 1.6657 | 1.6657 | 28000.0 |
| 2005-08-31 09:12:00 | AAPL | Stock | 1.6657 | 1.6657 | 1.6657 | 1.6657 | 28000.0 |
| 2005-08-31 09:13:00 | AAPL | Stock | 1.6657 | 1.6657 | 1.6657 | 1.6657 | 28000.0 |
| 2005-08-31 09:14:00 | AAPL | Stock | 1.6657 | 1.6657 | 1.6657 | 1.6657 | 5600.0 |
| 2005-08-31 09:15:00 | AAPL | Stock | 1.6657 | 1.6675 | 1.6657 | 1.6675 | 64400.0 |
| 2005-08-31 09:16:00 | AAPL | Stock | 1.6675 | 1.6675 | 1.6675 | 1.6675 | 5600.0 |
| 2005-08-31 09:17:00 | AAPL | Stock | 1.6696 | 1.6696 | 1.6696 | 1.6696 | 19600.0 |
| 2005-08-31 09:18:00 | AAPL | Stock | 1.6675 | 1.6675 | 1.6675 | 1.6675 | 5600.0 |
| 2005-08-31 09:20:00 | AAPL | Stock | 1.6657 | 1.6657 | 1.6657 | 1.6657 | 19600.0 |
| 2005-08-31 09:22:00 | AAPL | Stock | 1.6657 | 1.6657 | 1.6657 | 1.6657 | 14000.0 |
| 2005-08-31 09:24:00 | AAPL | Stock | 1.6657 | 1.6657 | 1.6657 | 1.6657 | 2800.0 |
| 2005-08-31 09:25:00 | AAPL | Stock | 1.6657 | 1.6693 | 1.665 | 1.6693 | 22400.0 |
| 2005-08-31 09:26:00 | AAPL | Stock | 1.6696 | 1.6711 | 1.6696 | 1.67 | 72800.0 |
| 2005-08-31 09:27:00 | AAPL | Stock | 1.67 | 1.6714 | 1.67 | 1.6711 | 176400.0 |
| 2005-08-31 09:28:00 | AAPL | Stock | 1.6696 | 1.6711 | 1.6696 | 1.6707 | 42000.0 |
| 2005-08-31 09:29:00 | AAPL | Stock | 1.6693 | 1.6718 | 1.6675 | 1.6696 | 118776.0 |
| 2005-08-31 09:30:00 | AAPL | Stock | 1.6736 | 1.6736 | 1.6639 | 1.6664 | 7218372.0 |
| 2005-08-31 09:31:00 | AAPL | Stock | 1.6661 | 1.6725 | 1.6621 | 1.6661 | 1731968.0 |
| 2005-08-31 09:32:00 | AAPL | Stock | 1.6661 | 1.6668 | 1.665 | 1.6654 | 888468.0 |
| 2005-08-31 09:33:00 | AAPL | Stock | 1.6654 | 1.6664 | 1.665 | 1.6657 | 1547644.0 |
| 2005-08-31 09:34:00 | AAPL | Stock | 1.6654 | 1.6654 | 1.6589 | 1.6589 | 2269736.0 |
| 2005-08-31 09:35:00 | AAPL | Stock | 1.6589 | 1.6636 | 1.6586 | 1.6614 | 1951768.0 |
| 2005-08-31 09:36:00 | AAPL | Stock | 1.6625 | 1.6636 | 1.6607 | 1.6621 | 1130752.0 |
| 2005-08-31 09:37:00 | AAPL | Stock | 1.6621 | 1.6625 | 1.6604 | 1.6607 | 1390508.0 |
| 2005-08-31 09:38:00 | AAPL | Stock | 1.6611 | 1.6618 | 1.6604 | 1.6614 | 1333472.0 |
| 2005-08-31 09:39:00 | AAPL | Stock | 1.6614 | 1.6618 | 1.6607 | 1.6618 | 2129596.0 |
> showing 50 of 597,050 rows — these rows as CSV