PREVIEW / stock_1min / 2009-03-06
file: by_date/stock_1min/2009/2009-03-06.parquet size: 13.0 MB rows: 994,917 symbols: 2,736
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 |
|---|---|---|---|---|---|---|---|
| 2009-03-06 07:21:00 | AAPL | Stock | 3.1625 | 3.1625 | 3.1625 | 3.1625 | 2800.0 |
| 2009-03-06 07:22:00 | AAPL | Stock | 3.1625 | 3.1625 | 3.1625 | 3.1625 | 2800.0 |
| 2009-03-06 07:30:00 | AAPL | Stock | 3.1625 | 3.1625 | 3.1571 | 3.1571 | 8540.0 |
| 2009-03-06 07:55:00 | AAPL | Stock | 3.1607 | 3.1607 | 3.1571 | 3.1571 | 14000.0 |
| 2009-03-06 07:56:00 | AAPL | Stock | 3.1532 | 3.1532 | 3.1532 | 3.1532 | 14000.0 |
| 2009-03-06 07:58:00 | AAPL | Stock | 3.1536 | 3.1536 | 3.1532 | 3.1532 | 16800.0 |
| 2009-03-06 07:59:00 | AAPL | Stock | 3.1571 | 3.1571 | 3.1571 | 3.1571 | 8400.0 |
| 2009-03-06 08:00:00 | AAPL | Stock | 3.1536 | 3.1607 | 3.1536 | 3.1607 | 49140.0 |
| 2009-03-06 08:03:00 | AAPL | Stock | 3.1646 | 3.1646 | 3.1646 | 3.1646 | 5600.0 |
| 2009-03-06 08:04:00 | AAPL | Stock | 3.1643 | 3.1643 | 3.1639 | 3.1639 | 25928.0 |
| 2009-03-06 08:05:00 | AAPL | Stock | 3.1639 | 3.1639 | 3.1607 | 3.1639 | 65996.0 |
| 2009-03-06 08:06:00 | AAPL | Stock | 3.1643 | 3.1779 | 3.1643 | 3.1686 | 85400.0 |
| 2009-03-06 08:07:00 | AAPL | Stock | 3.1614 | 3.1782 | 3.1614 | 3.1782 | 11200.0 |
| 2009-03-06 08:08:00 | AAPL | Stock | 3.1786 | 3.1804 | 3.1782 | 3.1804 | 42252.0 |
| 2009-03-06 08:09:00 | AAPL | Stock | 3.185 | 3.185 | 3.185 | 3.185 | 5600.0 |
| 2009-03-06 08:11:00 | AAPL | Stock | 3.1786 | 3.1786 | 3.1786 | 3.1786 | 14000.0 |
| 2009-03-06 08:13:00 | AAPL | Stock | 3.1732 | 3.1732 | 3.1732 | 3.1732 | 13860.0 |
| 2009-03-06 08:15:00 | AAPL | Stock | 3.1714 | 3.1714 | 3.1714 | 3.1714 | 2800.0 |
| 2009-03-06 08:16:00 | AAPL | Stock | 3.1736 | 3.1736 | 3.1736 | 3.1736 | 26600.0 |
| 2009-03-06 08:17:00 | AAPL | Stock | 3.1729 | 3.1732 | 3.1729 | 3.1732 | 15960.0 |
| 2009-03-06 08:20:00 | AAPL | Stock | 3.1768 | 3.1768 | 3.1768 | 3.1768 | 2800.0 |
| 2009-03-06 08:22:00 | AAPL | Stock | 3.1711 | 3.1711 | 3.1643 | 3.1696 | 50960.0 |
| 2009-03-06 08:24:00 | AAPL | Stock | 3.1643 | 3.1675 | 3.1643 | 3.165 | 36400.0 |
| 2009-03-06 08:25:00 | AAPL | Stock | 3.1657 | 3.1657 | 3.1532 | 3.1546 | 112084.0 |
| 2009-03-06 08:26:00 | AAPL | Stock | 3.1604 | 3.1679 | 3.1604 | 3.1679 | 44212.0 |
| 2009-03-06 08:29:00 | AAPL | Stock | 3.1679 | 3.175 | 3.1679 | 3.175 | 50400.0 |
| 2009-03-06 08:30:00 | AAPL | Stock | 3.1732 | 3.1886 | 3.1729 | 3.1729 | 290696.0 |
| 2009-03-06 08:31:00 | AAPL | Stock | 3.1786 | 3.1943 | 3.1775 | 3.1857 | 171332.0 |
| 2009-03-06 08:32:00 | AAPL | Stock | 3.1864 | 3.1882 | 3.1786 | 3.1786 | 216440.0 |
| 2009-03-06 08:33:00 | AAPL | Stock | 3.175 | 3.1786 | 3.175 | 3.1757 | 78568.0 |
| 2009-03-06 08:34:00 | AAPL | Stock | 3.1786 | 3.1786 | 3.1682 | 3.1682 | 114548.0 |
| 2009-03-06 08:35:00 | AAPL | Stock | 3.1679 | 3.1696 | 3.1625 | 3.1625 | 101584.0 |
| 2009-03-06 08:36:00 | AAPL | Stock | 3.1625 | 3.1625 | 3.1554 | 3.1554 | 150220.0 |
| 2009-03-06 08:37:00 | AAPL | Stock | 3.1589 | 3.1589 | 3.1536 | 3.1571 | 48860.0 |
| 2009-03-06 08:38:00 | AAPL | Stock | 3.1586 | 3.1607 | 3.1571 | 3.1607 | 34804.0 |
| 2009-03-06 08:39:00 | AAPL | Stock | 3.1593 | 3.1593 | 3.1593 | 3.1593 | 12320.0 |
| 2009-03-06 08:40:00 | AAPL | Stock | 3.1596 | 3.16 | 3.1596 | 3.16 | 39452.0 |
| 2009-03-06 08:41:00 | AAPL | Stock | 3.16 | 3.16 | 3.1571 | 3.1571 | 94864.0 |
| 2009-03-06 08:42:00 | AAPL | Stock | 3.1571 | 3.1571 | 3.1554 | 3.1554 | 15680.0 |
| 2009-03-06 08:43:00 | AAPL | Stock | 3.1568 | 3.1571 | 3.1568 | 3.1571 | 43960.0 |
| 2009-03-06 08:44:00 | AAPL | Stock | 3.1604 | 3.1604 | 3.1604 | 3.1604 | 5600.0 |
| 2009-03-06 08:45:00 | AAPL | Stock | 3.1629 | 3.1679 | 3.1604 | 3.1604 | 136500.0 |
| 2009-03-06 08:46:00 | AAPL | Stock | 3.1607 | 3.165 | 3.1607 | 3.1632 | 37800.0 |
| 2009-03-06 08:47:00 | AAPL | Stock | 3.1643 | 3.1646 | 3.1643 | 3.1646 | 5600.0 |
| 2009-03-06 08:48:00 | AAPL | Stock | 3.1657 | 3.1661 | 3.1657 | 3.1661 | 15120.0 |
| 2009-03-06 08:49:00 | AAPL | Stock | 3.1704 | 3.1714 | 3.17 | 3.1714 | 86520.0 |
| 2009-03-06 08:50:00 | AAPL | Stock | 3.1707 | 3.1707 | 3.1661 | 3.1686 | 48720.0 |
| 2009-03-06 08:51:00 | AAPL | Stock | 3.1668 | 3.1686 | 3.1668 | 3.1686 | 8400.0 |
| 2009-03-06 08:52:00 | AAPL | Stock | 3.1696 | 3.1696 | 3.1696 | 3.1696 | 17108.0 |
| 2009-03-06 08:53:00 | AAPL | Stock | 3.1714 | 3.1746 | 3.1714 | 3.1746 | 47124.0 |
> showing 50 of 994,917 rows — these rows as CSV