PREVIEW / stock_1min / 2004-12-10
file: by_date/stock_1min/2004/2004-12-10.parquet size: 6.3 MB rows: 514,694 symbols: 1,556
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-10 08:00:00 | AAPL | Stock | 1.15 | 1.155 | 1.15 | 1.155 | 352800.0 |
| 2004-12-10 08:01:00 | AAPL | Stock | 1.1546 | 1.1546 | 1.1523 | 1.1523 | 110488.0 |
| 2004-12-10 08:02:00 | AAPL | Stock | 1.1523 | 1.1523 | 1.1523 | 1.1523 | 33600.0 |
| 2004-12-10 08:03:00 | AAPL | Stock | 1.1527 | 1.1548 | 1.1527 | 1.1548 | 271040.0 |
| 2004-12-10 08:04:00 | AAPL | Stock | 1.155 | 1.1589 | 1.155 | 1.1563 | 442400.0 |
| 2004-12-10 08:05:00 | AAPL | Stock | 1.1598 | 1.1598 | 1.1589 | 1.1595 | 69496.0 |
| 2004-12-10 08:06:00 | AAPL | Stock | 1.1573 | 1.158 | 1.1552 | 1.1552 | 72800.0 |
| 2004-12-10 08:07:00 | AAPL | Stock | 1.1554 | 1.1571 | 1.1554 | 1.1571 | 145600.0 |
| 2004-12-10 08:08:00 | AAPL | Stock | 1.1571 | 1.1575 | 1.1571 | 1.1571 | 65520.0 |
| 2004-12-10 08:11:00 | AAPL | Stock | 1.1591 | 1.1591 | 1.1589 | 1.1589 | 36400.0 |
| 2004-12-10 08:13:00 | AAPL | Stock | 1.1589 | 1.1589 | 1.1586 | 1.1588 | 180880.0 |
| 2004-12-10 08:14:00 | AAPL | Stock | 1.1588 | 1.1588 | 1.1588 | 1.1588 | 95200.0 |
| 2004-12-10 08:15:00 | AAPL | Stock | 1.1589 | 1.1602 | 1.1589 | 1.1602 | 333200.0 |
| 2004-12-10 08:16:00 | AAPL | Stock | 1.1589 | 1.1607 | 1.1589 | 1.1607 | 138600.0 |
| 2004-12-10 08:18:00 | AAPL | Stock | 1.1596 | 1.162 | 1.1596 | 1.162 | 195496.0 |
| 2004-12-10 08:19:00 | AAPL | Stock | 1.1634 | 1.1634 | 1.1609 | 1.1634 | 221200.0 |
| 2004-12-10 08:20:00 | AAPL | Stock | 1.1634 | 1.1652 | 1.1634 | 1.1652 | 84000.0 |
| 2004-12-10 08:21:00 | AAPL | Stock | 1.1655 | 1.1666 | 1.1655 | 1.1666 | 50400.0 |
| 2004-12-10 08:22:00 | AAPL | Stock | 1.1664 | 1.1666 | 1.1661 | 1.1666 | 257600.0 |
| 2004-12-10 08:23:00 | AAPL | Stock | 1.1666 | 1.1691 | 1.1666 | 1.1691 | 134400.0 |
| 2004-12-10 08:24:00 | AAPL | Stock | 1.1679 | 1.1693 | 1.167 | 1.1693 | 229040.0 |
| 2004-12-10 08:25:00 | AAPL | Stock | 1.1688 | 1.1693 | 1.1679 | 1.1679 | 100240.0 |
| 2004-12-10 08:26:00 | AAPL | Stock | 1.1679 | 1.1688 | 1.1679 | 1.1688 | 33600.0 |
| 2004-12-10 08:27:00 | AAPL | Stock | 1.1679 | 1.1679 | 1.167 | 1.167 | 117600.0 |
| 2004-12-10 08:28:00 | AAPL | Stock | 1.1663 | 1.1663 | 1.1661 | 1.1661 | 64400.0 |
| 2004-12-10 08:29:00 | AAPL | Stock | 1.1661 | 1.1661 | 1.1655 | 1.1655 | 321160.0 |
| 2004-12-10 08:30:00 | AAPL | Stock | 1.1655 | 1.1655 | 1.1643 | 1.1643 | 176904.0 |
| 2004-12-10 08:31:00 | AAPL | Stock | 1.1643 | 1.1643 | 1.1643 | 1.1643 | 7000.0 |
| 2004-12-10 08:32:00 | AAPL | Stock | 1.1643 | 1.1643 | 1.163 | 1.163 | 15400.0 |
| 2004-12-10 08:33:00 | AAPL | Stock | 1.163 | 1.1652 | 1.1625 | 1.1643 | 88200.0 |
| 2004-12-10 08:34:00 | AAPL | Stock | 1.1625 | 1.1625 | 1.1616 | 1.1616 | 131600.0 |
| 2004-12-10 08:35:00 | AAPL | Stock | 1.1616 | 1.1623 | 1.1616 | 1.1623 | 67200.0 |
| 2004-12-10 08:36:00 | AAPL | Stock | 1.1616 | 1.162 | 1.1616 | 1.162 | 58016.0 |
| 2004-12-10 08:37:00 | AAPL | Stock | 1.1625 | 1.1643 | 1.1625 | 1.1643 | 100800.0 |
| 2004-12-10 08:38:00 | AAPL | Stock | 1.1643 | 1.1643 | 1.1634 | 1.1643 | 140000.0 |
| 2004-12-10 08:39:00 | AAPL | Stock | 1.1643 | 1.1643 | 1.162 | 1.162 | 81200.0 |
| 2004-12-10 08:40:00 | AAPL | Stock | 1.1636 | 1.1643 | 1.1636 | 1.1643 | 11200.0 |
| 2004-12-10 08:41:00 | AAPL | Stock | 1.1621 | 1.1621 | 1.1613 | 1.1616 | 107184.0 |
| 2004-12-10 08:43:00 | AAPL | Stock | 1.162 | 1.1621 | 1.162 | 1.1621 | 39200.0 |
| 2004-12-10 08:44:00 | AAPL | Stock | 1.1613 | 1.1613 | 1.1613 | 1.1613 | 5600.0 |
| 2004-12-10 08:45:00 | AAPL | Stock | 1.1623 | 1.1645 | 1.1621 | 1.1645 | 233800.0 |
| 2004-12-10 08:46:00 | AAPL | Stock | 1.1643 | 1.1654 | 1.1638 | 1.1654 | 158480.0 |
| 2004-12-10 08:47:00 | AAPL | Stock | 1.1657 | 1.1679 | 1.1655 | 1.1679 | 241920.0 |
| 2004-12-10 08:48:00 | AAPL | Stock | 1.1679 | 1.1741 | 1.1679 | 1.1723 | 1422176.0 |
| 2004-12-10 08:49:00 | AAPL | Stock | 1.1729 | 1.1732 | 1.1427 | 1.1696 | 539112.0 |
| 2004-12-10 08:50:00 | AAPL | Stock | 1.1709 | 1.1714 | 1.1696 | 1.17 | 124656.0 |
| 2004-12-10 08:51:00 | AAPL | Stock | 1.1705 | 1.1705 | 1.1664 | 1.1679 | 360752.0 |
| 2004-12-10 08:52:00 | AAPL | Stock | 1.1677 | 1.1696 | 1.167 | 1.1679 | 65744.0 |
| 2004-12-10 08:53:00 | AAPL | Stock | 1.1673 | 1.168 | 1.1673 | 1.1679 | 145600.0 |
| 2004-12-10 08:54:00 | AAPL | Stock | 1.1677 | 1.1677 | 1.1673 | 1.1673 | 33600.0 |
> showing 50 of 514,694 rows — these rows as CSV