PREVIEW / stock_1min / 2004-12-15
file: by_date/stock_1min/2004/2004-12-15.parquet size: 6.7 MB rows: 542,199 symbols: 1,559
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 |
|---|---|---|---|---|---|---|---|
| 2004-12-15 08:00:00 | AAPL | Stock | 1.1713 | 1.1713 | 1.1713 | 1.1713 | 14000.0 |
| 2004-12-15 08:01:00 | AAPL | Stock | 1.1745 | 1.1745 | 1.1745 | 1.1745 | 5600.0 |
| 2004-12-15 08:06:00 | AAPL | Stock | 1.1741 | 1.1741 | 1.1741 | 1.1741 | 39200.0 |
| 2004-12-15 08:10:00 | AAPL | Stock | 1.1745 | 1.1745 | 1.1745 | 1.1745 | 11200.0 |
| 2004-12-15 08:11:00 | AAPL | Stock | 1.1743 | 1.1745 | 1.1743 | 1.1745 | 44800.0 |
| 2004-12-15 08:21:00 | AAPL | Stock | 1.1696 | 1.1696 | 1.1696 | 1.1696 | 16800.0 |
| 2004-12-15 08:22:00 | AAPL | Stock | 1.1682 | 1.1696 | 1.1682 | 1.1696 | 50400.0 |
| 2004-12-15 08:24:00 | AAPL | Stock | 1.1698 | 1.1698 | 1.1698 | 1.1698 | 9520.0 |
| 2004-12-15 08:29:00 | AAPL | Stock | 1.1696 | 1.1698 | 1.1696 | 1.1698 | 39200.0 |
| 2004-12-15 08:30:00 | AAPL | Stock | 1.1696 | 1.1696 | 1.1696 | 1.1696 | 5656.0 |
| 2004-12-15 08:31:00 | AAPL | Stock | 1.1696 | 1.1696 | 1.1696 | 1.1696 | 5600.0 |
| 2004-12-15 08:33:00 | AAPL | Stock | 1.1682 | 1.1682 | 1.1682 | 1.1682 | 5600.0 |
| 2004-12-15 08:35:00 | AAPL | Stock | 1.1696 | 1.1696 | 1.1696 | 1.1696 | 11200.0 |
| 2004-12-15 08:36:00 | AAPL | Stock | 1.1682 | 1.1704 | 1.1682 | 1.1704 | 51520.0 |
| 2004-12-15 08:39:00 | AAPL | Stock | 1.1714 | 1.1714 | 1.1714 | 1.1714 | 5600.0 |
| 2004-12-15 08:41:00 | AAPL | Stock | 1.1704 | 1.1704 | 1.1704 | 1.1704 | 5600.0 |
| 2004-12-15 08:45:00 | AAPL | Stock | 1.1684 | 1.1684 | 1.1684 | 1.1684 | 33600.0 |
| 2004-12-15 08:46:00 | AAPL | Stock | 1.1682 | 1.1684 | 1.1682 | 1.1684 | 19656.0 |
| 2004-12-15 08:51:00 | AAPL | Stock | 1.1682 | 1.1682 | 1.1682 | 1.1682 | 8400.0 |
| 2004-12-15 08:54:00 | AAPL | Stock | 1.1682 | 1.1705 | 1.1682 | 1.1705 | 75600.0 |
| 2004-12-15 08:57:00 | AAPL | Stock | 1.1684 | 1.1684 | 1.1684 | 1.1684 | 5600.0 |
| 2004-12-15 09:16:00 | AAPL | Stock | 1.1679 | 1.1679 | 1.1679 | 1.1679 | 5600.0 |
| 2004-12-15 09:17:00 | AAPL | Stock | 1.1679 | 1.1679 | 1.1679 | 1.1679 | 16800.0 |
| 2004-12-15 09:28:00 | AAPL | Stock | 1.1668 | 1.1668 | 1.1661 | 1.1661 | 92512.0 |
| 2004-12-15 09:29:00 | AAPL | Stock | 1.1663 | 1.1682 | 1.1661 | 1.1675 | 489104.0 |
| 2004-12-15 09:30:00 | AAPL | Stock | 1.165 | 1.1677 | 1.165 | 1.1661 | 4209296.0 |
| 2004-12-15 09:31:00 | AAPL | Stock | 1.1661 | 1.1663 | 1.165 | 1.1652 | 1985312.0 |
| 2004-12-15 09:32:00 | AAPL | Stock | 1.1652 | 1.1654 | 1.1589 | 1.1591 | 3491880.0 |
| 2004-12-15 09:33:00 | AAPL | Stock | 1.1589 | 1.1618 | 1.1588 | 1.1616 | 4533032.0 |
| 2004-12-15 09:34:00 | AAPL | Stock | 1.1611 | 1.1657 | 1.159 | 1.1648 | 1533448.0 |
| 2004-12-15 09:35:00 | AAPL | Stock | 1.1644 | 1.1645 | 1.1623 | 1.163 | 1471120.0 |
| 2004-12-15 09:36:00 | AAPL | Stock | 1.1634 | 1.1643 | 1.1627 | 1.1636 | 1514464.0 |
| 2004-12-15 09:37:00 | AAPL | Stock | 1.1634 | 1.1643 | 1.1634 | 1.1638 | 1280328.0 |
| 2004-12-15 09:38:00 | AAPL | Stock | 1.1638 | 1.1639 | 1.1616 | 1.1621 | 1359120.0 |
| 2004-12-15 09:39:00 | AAPL | Stock | 1.1621 | 1.1621 | 1.1607 | 1.162 | 2143120.0 |
| 2004-12-15 09:40:00 | AAPL | Stock | 1.1623 | 1.1652 | 1.1618 | 1.1645 | 1640800.0 |
| 2004-12-15 09:41:00 | AAPL | Stock | 1.1641 | 1.1664 | 1.1636 | 1.1655 | 2112600.0 |
| 2004-12-15 09:42:00 | AAPL | Stock | 1.1659 | 1.1689 | 1.1652 | 1.1677 | 2788744.0 |
| 2004-12-15 09:43:00 | AAPL | Stock | 1.1673 | 1.1684 | 1.1655 | 1.1666 | 2370200.0 |
| 2004-12-15 09:44:00 | AAPL | Stock | 1.1669 | 1.1675 | 1.1657 | 1.1657 | 2078160.0 |
| 2004-12-15 09:45:00 | AAPL | Stock | 1.1655 | 1.1664 | 1.1643 | 1.1645 | 1939616.0 |
| 2004-12-15 09:46:00 | AAPL | Stock | 1.1643 | 1.1652 | 1.1625 | 1.1638 | 2320416.0 |
| 2004-12-15 09:47:00 | AAPL | Stock | 1.1638 | 1.1659 | 1.1625 | 1.1652 | 2216424.0 |
| 2004-12-15 09:48:00 | AAPL | Stock | 1.1654 | 1.1663 | 1.1648 | 1.1661 | 1094576.0 |
| 2004-12-15 09:49:00 | AAPL | Stock | 1.1659 | 1.167 | 1.1654 | 1.1663 | 1351952.0 |
| 2004-12-15 09:50:00 | AAPL | Stock | 1.1664 | 1.167 | 1.1657 | 1.1657 | 920024.0 |
| 2004-12-15 09:51:00 | AAPL | Stock | 1.1655 | 1.1663 | 1.1646 | 1.1652 | 1279320.0 |
| 2004-12-15 09:52:00 | AAPL | Stock | 1.1648 | 1.1663 | 1.1648 | 1.1661 | 696528.0 |
| 2004-12-15 09:53:00 | AAPL | Stock | 1.1661 | 1.1664 | 1.1652 | 1.1663 | 1332968.0 |
| 2004-12-15 09:54:00 | AAPL | Stock | 1.1659 | 1.1663 | 1.1648 | 1.1655 | 819000.0 |
> showing 50 of 542,199 rows — these rows as CSV