PREVIEW / stock_1min / 2011-04-06
file: by_date/stock_1min/2011/2011-04-06.parquet size: 13.5 MB rows: 1,007,830 symbols: 2,873
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 |
|---|---|---|---|---|---|---|---|
| 2011-04-06 04:04:00 | AAPL | Stock | 12.1471 | 12.1471 | 12.1471 | 12.1471 | 2800.0 |
| 2011-04-06 04:10:00 | AAPL | Stock | 12.1429 | 12.1429 | 12.1429 | 12.1429 | 19600.0 |
| 2011-04-06 04:25:00 | AAPL | Stock | 12.1429 | 12.1429 | 12.1429 | 12.1429 | 2800.0 |
| 2011-04-06 04:35:00 | AAPL | Stock | 12.1607 | 12.1607 | 12.1607 | 12.1607 | 16800.0 |
| 2011-04-06 04:36:00 | AAPL | Stock | 12.1607 | 12.1607 | 12.1607 | 12.1607 | 16800.0 |
| 2011-04-06 04:50:00 | AAPL | Stock | 12.15 | 12.15 | 12.15 | 12.15 | 14000.0 |
| 2011-04-06 05:20:00 | AAPL | Stock | 12.1679 | 12.1679 | 12.1679 | 12.1679 | 2800.0 |
| 2011-04-06 05:22:00 | AAPL | Stock | 12.1679 | 12.1679 | 12.1679 | 12.1679 | 5600.0 |
| 2011-04-06 05:23:00 | AAPL | Stock | 12.1679 | 12.1679 | 12.1679 | 12.1679 | 5600.0 |
| 2011-04-06 06:05:00 | AAPL | Stock | 12.1661 | 12.1661 | 12.1661 | 12.1661 | 2800.0 |
| 2011-04-06 06:11:00 | AAPL | Stock | 12.1714 | 12.1714 | 12.1714 | 12.1714 | 2800.0 |
| 2011-04-06 06:14:00 | AAPL | Stock | 12.1661 | 12.1661 | 12.1661 | 12.1661 | 2800.0 |
| 2011-04-06 06:23:00 | AAPL | Stock | 12.1714 | 12.1714 | 12.1714 | 12.1714 | 2800.0 |
| 2011-04-06 06:28:00 | AAPL | Stock | 12.1643 | 12.1643 | 12.1643 | 12.1643 | 2800.0 |
| 2011-04-06 06:34:00 | AAPL | Stock | 12.1711 | 12.1714 | 12.1711 | 12.1714 | 11200.0 |
| 2011-04-06 06:35:00 | AAPL | Stock | 12.1732 | 12.1732 | 12.1732 | 12.1732 | 7280.0 |
| 2011-04-06 06:36:00 | AAPL | Stock | 12.1604 | 12.1604 | 12.1604 | 12.1604 | 8400.0 |
| 2011-04-06 06:38:00 | AAPL | Stock | 12.1714 | 12.1714 | 12.1714 | 12.1714 | 2800.0 |
| 2011-04-06 06:41:00 | AAPL | Stock | 12.1714 | 12.1757 | 12.1714 | 12.1757 | 14000.0 |
| 2011-04-06 06:43:00 | AAPL | Stock | 12.1693 | 12.1693 | 12.1693 | 12.1693 | 6300.0 |
| 2011-04-06 06:56:00 | AAPL | Stock | 12.1761 | 12.1761 | 12.1761 | 12.1761 | 2800.0 |
| 2011-04-06 06:57:00 | AAPL | Stock | 12.1764 | 12.1764 | 12.1764 | 12.1764 | 8400.0 |
| 2011-04-06 06:58:00 | AAPL | Stock | 12.1768 | 12.1768 | 12.1768 | 12.1768 | 2800.0 |
| 2011-04-06 07:00:00 | AAPL | Stock | 12.1768 | 12.1768 | 12.1679 | 12.1679 | 8400.0 |
| 2011-04-06 07:04:00 | AAPL | Stock | 12.1607 | 12.1679 | 12.1607 | 12.1607 | 67060.0 |
| 2011-04-06 07:05:00 | AAPL | Stock | 12.1636 | 12.1679 | 12.1554 | 12.1679 | 19600.0 |
| 2011-04-06 07:07:00 | AAPL | Stock | 12.1729 | 12.1729 | 12.1729 | 12.1729 | 2800.0 |
| 2011-04-06 07:10:00 | AAPL | Stock | 12.1682 | 12.1682 | 12.1682 | 12.1682 | 5600.0 |
| 2011-04-06 07:14:00 | AAPL | Stock | 12.1679 | 12.1679 | 12.1679 | 12.1679 | 8400.0 |
| 2011-04-06 07:18:00 | AAPL | Stock | 12.1679 | 12.1679 | 12.1679 | 12.1679 | 5264.0 |
| 2011-04-06 07:19:00 | AAPL | Stock | 12.1693 | 12.1693 | 12.1693 | 12.1693 | 2800.0 |
| 2011-04-06 07:22:00 | AAPL | Stock | 12.1661 | 12.1661 | 12.1643 | 12.1646 | 14000.0 |
| 2011-04-06 07:23:00 | AAPL | Stock | 12.165 | 12.165 | 12.165 | 12.165 | 2800.0 |
| 2011-04-06 07:26:00 | AAPL | Stock | 12.1693 | 12.1696 | 12.1693 | 12.1696 | 5600.0 |
| 2011-04-06 07:27:00 | AAPL | Stock | 12.1607 | 12.1607 | 12.1607 | 12.1607 | 14000.0 |
| 2011-04-06 07:30:00 | AAPL | Stock | 12.1679 | 12.1679 | 12.1679 | 12.1679 | 5600.0 |
| 2011-04-06 07:31:00 | AAPL | Stock | 12.1679 | 12.1679 | 12.1679 | 12.1679 | 6104.0 |
| 2011-04-06 07:32:00 | AAPL | Stock | 12.1714 | 12.1714 | 12.1714 | 12.1714 | 2800.0 |
| 2011-04-06 07:34:00 | AAPL | Stock | 12.1704 | 12.1704 | 12.1704 | 12.1704 | 11200.0 |
| 2011-04-06 07:36:00 | AAPL | Stock | 12.1707 | 12.1707 | 12.1707 | 12.1707 | 2800.0 |
| 2011-04-06 07:39:00 | AAPL | Stock | 12.1704 | 12.1707 | 12.1704 | 12.1707 | 5600.0 |
| 2011-04-06 07:40:00 | AAPL | Stock | 12.1721 | 12.1746 | 12.1721 | 12.1746 | 8904.0 |
| 2011-04-06 07:41:00 | AAPL | Stock | 12.1686 | 12.1686 | 12.1686 | 12.1686 | 2800.0 |
| 2011-04-06 07:42:00 | AAPL | Stock | 12.1686 | 12.1686 | 12.1686 | 12.1686 | 2800.0 |
| 2011-04-06 07:54:00 | AAPL | Stock | 12.1607 | 12.1607 | 12.1582 | 12.1582 | 50400.0 |
| 2011-04-06 07:55:00 | AAPL | Stock | 12.1554 | 12.1554 | 12.1554 | 12.1554 | 2800.0 |
| 2011-04-06 07:56:00 | AAPL | Stock | 12.1607 | 12.1607 | 12.1607 | 12.1607 | 28000.0 |
| 2011-04-06 07:57:00 | AAPL | Stock | 12.1607 | 12.1679 | 12.1607 | 12.1679 | 30800.0 |
| 2011-04-06 07:58:00 | AAPL | Stock | 12.1607 | 12.1732 | 12.1607 | 12.1732 | 22400.0 |
| 2011-04-06 07:59:00 | AAPL | Stock | 12.1732 | 12.1732 | 12.1729 | 12.1729 | 22400.0 |
> showing 50 of 1,007,830 rows — these rows as CSV