PREVIEW / stock_5min / 2004-12-07
file: by_date/stock_5min/2004/2004-12-07.parquet size: 2.7 MB rows: 192,251 symbols: 1,888
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-07 08:00:00 | AAPL | Stock | 1.175 | 1.175 | 1.1723 | 1.1723 | 224000.0 |
| 2004-12-07 08:05:00 | AAPL | Stock | 1.1705 | 1.1723 | 1.1691 | 1.1723 | 158480.0 |
| 2004-12-07 08:10:00 | AAPL | Stock | 1.1714 | 1.1723 | 1.1714 | 1.1714 | 201600.0 |
| 2004-12-07 08:15:00 | AAPL | Stock | 1.1714 | 1.1714 | 1.1473 | 1.1498 | 1648864.0 |
| 2004-12-07 08:20:00 | AAPL | Stock | 1.1498 | 1.1691 | 1.1468 | 1.1634 | 406168.0 |
| 2004-12-07 08:25:00 | AAPL | Stock | 1.1634 | 1.1657 | 1.1618 | 1.1643 | 609728.0 |
| 2004-12-07 08:30:00 | AAPL | Stock | 1.1634 | 1.1645 | 1.1634 | 1.1645 | 81200.0 |
| 2004-12-07 08:35:00 | AAPL | Stock | 1.1643 | 1.167 | 1.1643 | 1.1643 | 218176.0 |
| 2004-12-07 08:40:00 | AAPL | Stock | 1.1643 | 1.1654 | 1.1611 | 1.1654 | 119224.0 |
| 2004-12-07 08:45:00 | AAPL | Stock | 1.1654 | 1.1668 | 1.1654 | 1.1668 | 77448.0 |
| 2004-12-07 08:50:00 | AAPL | Stock | 1.1668 | 1.1686 | 1.1668 | 1.1686 | 254800.0 |
| 2004-12-07 08:55:00 | AAPL | Stock | 1.1686 | 1.1696 | 1.1686 | 1.1686 | 246680.0 |
| 2004-12-07 09:00:00 | AAPL | Stock | 1.1686 | 1.1702 | 1.1686 | 1.1696 | 400792.0 |
| 2004-12-07 09:05:00 | AAPL | Stock | 1.1696 | 1.1702 | 1.1693 | 1.1702 | 190400.0 |
| 2004-12-07 09:10:00 | AAPL | Stock | 1.1705 | 1.1709 | 1.1696 | 1.1705 | 879200.0 |
| 2004-12-07 09:15:00 | AAPL | Stock | 1.1696 | 1.1723 | 1.1688 | 1.1716 | 927080.0 |
| 2004-12-07 09:20:00 | AAPL | Stock | 1.1723 | 1.1732 | 1.1705 | 1.172 | 939176.0 |
| 2004-12-07 09:25:00 | AAPL | Stock | 1.1734 | 1.1793 | 1.1693 | 1.1777 | 4498200.0 |
| 2004-12-07 09:30:00 | AAPL | Stock | 1.1773 | 1.1793 | 1.1632 | 1.1643 | 31188584.0 |
| 2004-12-07 09:35:00 | AAPL | Stock | 1.1643 | 1.1693 | 1.1634 | 1.1643 | 18648896.0 |
| 2004-12-07 09:40:00 | AAPL | Stock | 1.1643 | 1.1648 | 1.1539 | 1.1575 | 27239968.0 |
| 2004-12-07 09:45:00 | AAPL | Stock | 1.1575 | 1.1605 | 1.1562 | 1.1564 | 14076104.0 |
| 2004-12-07 09:50:00 | AAPL | Stock | 1.1564 | 1.1625 | 1.1563 | 1.1582 | 20977152.0 |
| 2004-12-07 09:55:00 | AAPL | Stock | 1.1582 | 1.1686 | 1.1582 | 1.1679 | 22497664.0 |
| 2004-12-07 10:00:00 | AAPL | Stock | 1.1679 | 1.1796 | 1.165 | 1.1773 | 31652824.0 |
| 2004-12-07 10:05:00 | AAPL | Stock | 1.177 | 1.1916 | 1.177 | 1.1911 | 53680648.0 |
| 2004-12-07 10:10:00 | AAPL | Stock | 1.1905 | 1.1911 | 1.1838 | 1.1855 | 28140168.0 |
| 2004-12-07 10:15:00 | AAPL | Stock | 1.1854 | 1.1857 | 1.175 | 1.1761 | 21682416.0 |
| 2004-12-07 10:20:00 | AAPL | Stock | 1.1761 | 1.1763 | 1.1714 | 1.1743 | 19777968.0 |
| 2004-12-07 10:25:00 | AAPL | Stock | 1.1743 | 1.175 | 1.1734 | 1.175 | 6844488.0 |
| 2004-12-07 10:30:00 | AAPL | Stock | 1.175 | 1.1791 | 1.1741 | 1.1779 | 8467200.0 |
| 2004-12-07 10:35:00 | AAPL | Stock | 1.178 | 1.1798 | 1.1743 | 1.1748 | 7004424.0 |
| 2004-12-07 10:40:00 | AAPL | Stock | 1.175 | 1.1757 | 1.1671 | 1.168 | 12658912.0 |
| 2004-12-07 10:45:00 | AAPL | Stock | 1.168 | 1.1693 | 1.1638 | 1.1668 | 13804280.0 |
| 2004-12-07 10:50:00 | AAPL | Stock | 1.1668 | 1.1679 | 1.1655 | 1.1661 | 5982816.0 |
| 2004-12-07 10:55:00 | AAPL | Stock | 1.1661 | 1.1713 | 1.1661 | 1.1705 | 7736792.0 |
| 2004-12-07 11:00:00 | AAPL | Stock | 1.1705 | 1.1714 | 1.167 | 1.167 | 6550544.0 |
| 2004-12-07 11:05:00 | AAPL | Stock | 1.1671 | 1.1702 | 1.167 | 1.17 | 3672088.0 |
| 2004-12-07 11:10:00 | AAPL | Stock | 1.1704 | 1.1713 | 1.1696 | 1.17 | 2625896.0 |
| 2004-12-07 11:15:00 | AAPL | Stock | 1.1702 | 1.1738 | 1.1696 | 1.1723 | 3176768.0 |
| 2004-12-07 11:20:00 | AAPL | Stock | 1.172 | 1.1723 | 1.1686 | 1.17 | 2689568.0 |
| 2004-12-07 11:25:00 | AAPL | Stock | 1.17 | 1.172 | 1.1693 | 1.172 | 2905896.0 |
| 2004-12-07 11:30:00 | AAPL | Stock | 1.172 | 1.173 | 1.1696 | 1.1696 | 3710448.0 |
| 2004-12-07 11:35:00 | AAPL | Stock | 1.1696 | 1.1702 | 1.1679 | 1.1679 | 4614456.0 |
| 2004-12-07 11:40:00 | AAPL | Stock | 1.1679 | 1.1698 | 1.1677 | 1.168 | 4489352.0 |
| 2004-12-07 11:45:00 | AAPL | Stock | 1.1679 | 1.1688 | 1.1655 | 1.1655 | 8822464.0 |
| 2004-12-07 11:50:00 | AAPL | Stock | 1.1655 | 1.1659 | 1.1625 | 1.163 | 11402888.0 |
| 2004-12-07 11:55:00 | AAPL | Stock | 1.1627 | 1.168 | 1.1625 | 1.1661 | 10909528.0 |
| 2004-12-07 12:00:00 | AAPL | Stock | 1.1655 | 1.1657 | 1.1636 | 1.1638 | 3503920.0 |
| 2004-12-07 12:05:00 | AAPL | Stock | 1.1641 | 1.165 | 1.1627 | 1.1632 | 5845224.0 |
> showing 50 of 192,251 rows — these rows as CSV