PREVIEW / stock_1min / 2009-03-03
file: by_date/stock_1min/2009/2009-03-03.parquet size: 13.5 MB rows: 1,029,181 symbols: 2,730
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-03 07:57:00 | AAPL | Stock | 3.1679 | 3.1679 | 3.1679 | 3.1679 | 5600.0 |
| 2009-03-03 08:00:00 | AAPL | Stock | 3.1671 | 3.1671 | 3.15 | 3.15 | 6300.0 |
| 2009-03-03 08:01:00 | AAPL | Stock | 3.1679 | 3.1679 | 3.1679 | 3.1679 | 11200.0 |
| 2009-03-03 08:02:00 | AAPL | Stock | 3.1679 | 3.1679 | 3.1679 | 3.1679 | 3108.0 |
| 2009-03-03 08:03:00 | AAPL | Stock | 3.1679 | 3.1696 | 3.1679 | 3.1679 | 44800.0 |
| 2009-03-03 08:04:00 | AAPL | Stock | 3.1693 | 3.1696 | 3.1671 | 3.1671 | 50400.0 |
| 2009-03-03 08:05:00 | AAPL | Stock | 3.1679 | 3.1679 | 3.1607 | 3.1607 | 16800.0 |
| 2009-03-03 08:07:00 | AAPL | Stock | 3.1671 | 3.1714 | 3.1671 | 3.1714 | 102536.0 |
| 2009-03-03 08:08:00 | AAPL | Stock | 3.1714 | 3.1714 | 3.1714 | 3.1714 | 5600.0 |
| 2009-03-03 08:09:00 | AAPL | Stock | 3.1707 | 3.1707 | 3.1707 | 3.1707 | 2800.0 |
| 2009-03-03 08:10:00 | AAPL | Stock | 3.17 | 3.17 | 3.17 | 3.17 | 2800.0 |
| 2009-03-03 08:11:00 | AAPL | Stock | 3.17 | 3.17 | 3.17 | 3.17 | 22400.0 |
| 2009-03-03 08:12:00 | AAPL | Stock | 3.1696 | 3.1696 | 3.1696 | 3.1696 | 5600.0 |
| 2009-03-03 08:14:00 | AAPL | Stock | 3.1729 | 3.175 | 3.1729 | 3.175 | 50400.0 |
| 2009-03-03 08:15:00 | AAPL | Stock | 3.1771 | 3.1771 | 3.1771 | 3.1771 | 2800.0 |
| 2009-03-03 08:16:00 | AAPL | Stock | 3.1725 | 3.1725 | 3.1725 | 3.1725 | 2800.0 |
| 2009-03-03 08:19:00 | AAPL | Stock | 3.1771 | 3.1786 | 3.1771 | 3.1786 | 41720.0 |
| 2009-03-03 08:20:00 | AAPL | Stock | 3.1786 | 3.1786 | 3.1786 | 3.1786 | 7532.0 |
| 2009-03-03 08:21:00 | AAPL | Stock | 3.1786 | 3.1786 | 3.1768 | 3.1786 | 23044.0 |
| 2009-03-03 08:22:00 | AAPL | Stock | 3.1782 | 3.1786 | 3.1782 | 3.1786 | 27020.0 |
| 2009-03-03 08:25:00 | AAPL | Stock | 3.1782 | 3.1818 | 3.1782 | 3.1818 | 57008.0 |
| 2009-03-03 08:27:00 | AAPL | Stock | 3.1821 | 3.1821 | 3.1821 | 3.1821 | 38528.0 |
| 2009-03-03 08:28:00 | AAPL | Stock | 3.1839 | 3.1839 | 3.1839 | 3.1839 | 8400.0 |
| 2009-03-03 08:29:00 | AAPL | Stock | 3.1821 | 3.1821 | 3.1821 | 3.1821 | 14000.0 |
| 2009-03-03 08:31:00 | AAPL | Stock | 3.1839 | 3.1846 | 3.1821 | 3.1846 | 44912.0 |
| 2009-03-03 08:32:00 | AAPL | Stock | 3.1846 | 3.2071 | 3.1846 | 3.1964 | 351204.0 |
| 2009-03-03 08:33:00 | AAPL | Stock | 3.1964 | 3.2 | 3.1857 | 3.1857 | 132720.0 |
| 2009-03-03 08:34:00 | AAPL | Stock | 3.1857 | 3.1871 | 3.1857 | 3.1871 | 31724.0 |
| 2009-03-03 08:35:00 | AAPL | Stock | 3.1943 | 3.1954 | 3.1943 | 3.1954 | 54376.0 |
| 2009-03-03 08:36:00 | AAPL | Stock | 3.1954 | 3.1954 | 3.1907 | 3.1936 | 11480.0 |
| 2009-03-03 08:37:00 | AAPL | Stock | 3.1925 | 3.1982 | 3.1918 | 3.1964 | 66500.0 |
| 2009-03-03 08:38:00 | AAPL | Stock | 3.1964 | 3.1975 | 3.1929 | 3.1929 | 165200.0 |
| 2009-03-03 08:39:00 | AAPL | Stock | 3.1904 | 3.1904 | 3.1861 | 3.1893 | 115780.0 |
| 2009-03-03 08:40:00 | AAPL | Stock | 3.1893 | 3.1893 | 3.1868 | 3.1868 | 18172.0 |
| 2009-03-03 08:41:00 | AAPL | Stock | 3.1936 | 3.1975 | 3.1839 | 3.1961 | 70000.0 |
| 2009-03-03 08:42:00 | AAPL | Stock | 3.1911 | 3.1911 | 3.1786 | 3.1857 | 324744.0 |
| 2009-03-03 08:46:00 | AAPL | Stock | 3.1857 | 3.1857 | 3.1854 | 3.1854 | 14056.0 |
| 2009-03-03 08:47:00 | AAPL | Stock | 3.1821 | 3.1821 | 3.1821 | 3.1821 | 8876.0 |
| 2009-03-03 08:48:00 | AAPL | Stock | 3.1825 | 3.1893 | 3.1825 | 3.1893 | 50400.0 |
| 2009-03-03 08:50:00 | AAPL | Stock | 3.1829 | 3.1829 | 3.1786 | 3.1786 | 62104.0 |
| 2009-03-03 08:51:00 | AAPL | Stock | 3.1786 | 3.1793 | 3.1786 | 3.1793 | 27272.0 |
| 2009-03-03 08:52:00 | AAPL | Stock | 3.1768 | 3.1771 | 3.1768 | 3.1771 | 30800.0 |
| 2009-03-03 08:53:00 | AAPL | Stock | 3.1786 | 3.1793 | 3.1786 | 3.1786 | 91280.0 |
| 2009-03-03 08:54:00 | AAPL | Stock | 3.1771 | 3.1771 | 3.1679 | 3.1768 | 152628.0 |
| 2009-03-03 08:55:00 | AAPL | Stock | 3.1686 | 3.1771 | 3.1686 | 3.1771 | 26600.0 |
| 2009-03-03 08:56:00 | AAPL | Stock | 3.1768 | 3.1786 | 3.175 | 3.1786 | 163240.0 |
| 2009-03-03 08:57:00 | AAPL | Stock | 3.1832 | 3.1857 | 3.1832 | 3.1846 | 81200.0 |
| 2009-03-03 08:58:00 | AAPL | Stock | 3.1839 | 3.1839 | 3.1796 | 3.1796 | 102200.0 |
| 2009-03-03 08:59:00 | AAPL | Stock | 3.1818 | 3.1821 | 3.1818 | 3.1821 | 46900.0 |
| 2009-03-03 09:00:00 | AAPL | Stock | 3.1821 | 3.1821 | 3.1804 | 3.1804 | 35000.0 |
> showing 50 of 1,029,181 rows — these rows as CSV