PREVIEW / stock_1min / 2000-04-06
file: by_date/stock_1min/2000/2000-04-06.parquet size: 2.4 MB rows: 207,938 symbols: 941
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 |
|---|---|---|---|---|---|---|---|
| 2000-04-06 09:30:00 | AAPL | Stock | 1.1663 | 1.1699 | 1.1657 | 1.1669 | 2116800.0 |
| 2000-04-06 09:31:00 | AAPL | Stock | 1.1674 | 1.1674 | 1.1652 | 1.1663 | 1064000.0 |
| 2000-04-06 09:32:00 | AAPL | Stock | 1.1652 | 1.1674 | 1.1652 | 1.1657 | 4065600.0 |
| 2000-04-06 09:33:00 | AAPL | Stock | 1.1663 | 1.1724 | 1.1655 | 1.1696 | 649600.0 |
| 2000-04-06 09:34:00 | AAPL | Stock | 1.1702 | 1.1786 | 1.1674 | 1.1786 | 1680000.0 |
| 2000-04-06 09:35:00 | AAPL | Stock | 1.1791 | 1.1881 | 1.1663 | 1.1875 | 1478400.0 |
| 2000-04-06 09:36:00 | AAPL | Stock | 1.1886 | 1.1964 | 1.1842 | 1.1964 | 1747200.0 |
| 2000-04-06 09:37:00 | AAPL | Stock | 1.1948 | 1.1998 | 1.1847 | 1.1998 | 2228800.0 |
| 2000-04-06 09:38:00 | AAPL | Stock | 1.2009 | 1.2009 | 1.1942 | 1.1964 | 1512000.0 |
| 2000-04-06 09:39:00 | AAPL | Stock | 1.2003 | 1.2003 | 1.1964 | 1.1964 | 2060800.0 |
| 2000-04-06 09:40:00 | AAPL | Stock | 1.1964 | 1.1975 | 1.1875 | 1.1875 | 2408000.0 |
| 2000-04-06 09:41:00 | AAPL | Stock | 1.1875 | 1.1886 | 1.1847 | 1.1886 | 1534400.0 |
| 2000-04-06 09:42:00 | AAPL | Stock | 1.1875 | 1.1897 | 1.1864 | 1.1886 | 750400.0 |
| 2000-04-06 09:43:00 | AAPL | Stock | 1.1875 | 1.1903 | 1.1842 | 1.1842 | 616000.0 |
| 2000-04-06 09:44:00 | AAPL | Stock | 1.1842 | 1.1897 | 1.1797 | 1.1808 | 929600.0 |
| 2000-04-06 09:45:00 | AAPL | Stock | 1.1786 | 1.1814 | 1.1741 | 1.1747 | 918400.0 |
| 2000-04-06 09:46:00 | AAPL | Stock | 1.1741 | 1.1775 | 1.1741 | 1.1769 | 806400.0 |
| 2000-04-06 09:47:00 | AAPL | Stock | 1.1775 | 1.1775 | 1.1741 | 1.1747 | 369600.0 |
| 2000-04-06 09:48:00 | AAPL | Stock | 1.1775 | 1.1775 | 1.1747 | 1.1747 | 403200.0 |
| 2000-04-06 09:49:00 | AAPL | Stock | 1.1747 | 1.1769 | 1.1708 | 1.1708 | 1556800.0 |
| 2000-04-06 09:50:00 | AAPL | Stock | 1.1708 | 1.1719 | 1.1674 | 1.1674 | 593600.0 |
| 2000-04-06 09:51:00 | AAPL | Stock | 1.1685 | 1.1702 | 1.1674 | 1.1685 | 1355200.0 |
| 2000-04-06 09:52:00 | AAPL | Stock | 1.1674 | 1.1738 | 1.1674 | 1.1685 | 537600.0 |
| 2000-04-06 09:53:00 | AAPL | Stock | 1.1685 | 1.1724 | 1.1685 | 1.1685 | 582400.0 |
| 2000-04-06 09:54:00 | AAPL | Stock | 1.1705 | 1.1724 | 1.168 | 1.1685 | 1388800.0 |
| 2000-04-06 09:55:00 | AAPL | Stock | 1.1702 | 1.1702 | 1.1685 | 1.1685 | 571200.0 |
| 2000-04-06 09:56:00 | AAPL | Stock | 1.1685 | 1.1702 | 1.1663 | 1.1674 | 515200.0 |
| 2000-04-06 09:57:00 | AAPL | Stock | 1.1657 | 1.1747 | 1.1657 | 1.1741 | 302400.0 |
| 2000-04-06 09:58:00 | AAPL | Stock | 1.1696 | 1.1741 | 1.1696 | 1.1741 | 280000.0 |
| 2000-04-06 09:59:00 | AAPL | Stock | 1.1741 | 1.1775 | 1.1735 | 1.1775 | 1120000.0 |
| 2000-04-06 10:00:00 | AAPL | Stock | 1.1766 | 1.1766 | 1.173 | 1.1761 | 571200.0 |
| 2000-04-06 10:01:00 | AAPL | Stock | 1.1735 | 1.1752 | 1.1708 | 1.1719 | 470400.0 |
| 2000-04-06 10:02:00 | AAPL | Stock | 1.1696 | 1.1752 | 1.1696 | 1.1716 | 560000.0 |
| 2000-04-06 10:03:00 | AAPL | Stock | 1.1716 | 1.1752 | 1.1702 | 1.1719 | 336000.0 |
| 2000-04-06 10:04:00 | AAPL | Stock | 1.1741 | 1.1763 | 1.1719 | 1.173 | 817600.0 |
| 2000-04-06 10:05:00 | AAPL | Stock | 1.173 | 1.1775 | 1.1719 | 1.1741 | 1131200.0 |
| 2000-04-06 10:06:00 | AAPL | Stock | 1.1758 | 1.1769 | 1.1724 | 1.1724 | 840000.0 |
| 2000-04-06 10:07:00 | AAPL | Stock | 1.1719 | 1.1724 | 1.1674 | 1.1674 | 918400.0 |
| 2000-04-06 10:08:00 | AAPL | Stock | 1.1674 | 1.1674 | 1.1652 | 1.166 | 896000.0 |
| 2000-04-06 10:09:00 | AAPL | Stock | 1.1685 | 1.1719 | 1.1652 | 1.1719 | 627200.0 |
| 2000-04-06 10:10:00 | AAPL | Stock | 1.173 | 1.1769 | 1.173 | 1.1769 | 728000.0 |
| 2000-04-06 10:11:00 | AAPL | Stock | 1.1747 | 1.1752 | 1.1708 | 1.1708 | 571200.0 |
| 2000-04-06 10:12:00 | AAPL | Stock | 1.1761 | 1.1761 | 1.1738 | 1.1755 | 358400.0 |
| 2000-04-06 10:13:00 | AAPL | Stock | 1.1761 | 1.1763 | 1.1747 | 1.1752 | 347200.0 |
| 2000-04-06 10:14:00 | AAPL | Stock | 1.1752 | 1.1752 | 1.1708 | 1.1713 | 268800.0 |
| 2000-04-06 10:15:00 | AAPL | Stock | 1.1713 | 1.1713 | 1.1708 | 1.1713 | 582400.0 |
| 2000-04-06 10:16:00 | AAPL | Stock | 1.1708 | 1.1758 | 1.1708 | 1.1719 | 537600.0 |
| 2000-04-06 10:17:00 | AAPL | Stock | 1.1752 | 1.1758 | 1.1719 | 1.1747 | 145600.0 |
| 2000-04-06 10:18:00 | AAPL | Stock | 1.1719 | 1.1758 | 1.1708 | 1.1724 | 448000.0 |
| 2000-04-06 10:19:00 | AAPL | Stock | 1.173 | 1.1741 | 1.173 | 1.1738 | 145600.0 |
> showing 50 of 207,938 rows — these rows as CSV