PREVIEW / stock_1min / 2009-02-20
file: by_date/stock_1min/2009/2009-02-20.parquet size: 13.1 MB rows: 1,001,148 symbols: 2,734
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-02-20 07:07:00 | AAPL | Stock | 3.1921 | 3.1929 | 3.1921 | 3.1929 | 14000.0 |
| 2009-02-20 07:11:00 | AAPL | Stock | 3.1929 | 3.1929 | 3.1929 | 3.1929 | 2800.0 |
| 2009-02-20 07:36:00 | AAPL | Stock | 3.1786 | 3.1786 | 3.1786 | 3.1786 | 27020.0 |
| 2009-02-20 07:38:00 | AAPL | Stock | 3.1786 | 3.1786 | 3.1786 | 3.1786 | 4620.0 |
| 2009-02-20 07:40:00 | AAPL | Stock | 3.1786 | 3.1786 | 3.1786 | 3.1786 | 8400.0 |
| 2009-02-20 07:48:00 | AAPL | Stock | 3.1696 | 3.1696 | 3.1643 | 3.1643 | 5600.0 |
| 2009-02-20 07:50:00 | AAPL | Stock | 3.1643 | 3.1643 | 3.1643 | 3.1643 | 2800.0 |
| 2009-02-20 07:51:00 | AAPL | Stock | 3.1643 | 3.1643 | 3.1643 | 3.1643 | 3080.0 |
| 2009-02-20 07:54:00 | AAPL | Stock | 3.1718 | 3.1718 | 3.1718 | 3.1718 | 14000.0 |
| 2009-02-20 08:00:00 | AAPL | Stock | 3.1904 | 3.1964 | 3.1786 | 3.1786 | 255696.0 |
| 2009-02-20 08:01:00 | AAPL | Stock | 3.1786 | 3.1786 | 3.175 | 3.175 | 12264.0 |
| 2009-02-20 08:02:00 | AAPL | Stock | 3.1821 | 3.1821 | 3.1821 | 3.1821 | 4900.0 |
| 2009-02-20 08:03:00 | AAPL | Stock | 3.1818 | 3.1818 | 3.1818 | 3.1818 | 5600.0 |
| 2009-02-20 08:04:00 | AAPL | Stock | 3.1804 | 3.1839 | 3.1804 | 3.1839 | 16800.0 |
| 2009-02-20 08:05:00 | AAPL | Stock | 3.1839 | 3.1839 | 3.1839 | 3.1839 | 2800.0 |
| 2009-02-20 08:06:00 | AAPL | Stock | 3.1875 | 3.1879 | 3.1875 | 3.1879 | 11200.0 |
| 2009-02-20 08:07:00 | AAPL | Stock | 3.1879 | 3.1879 | 3.1879 | 3.1879 | 7840.0 |
| 2009-02-20 08:08:00 | AAPL | Stock | 3.1857 | 3.1893 | 3.1857 | 3.1893 | 22400.0 |
| 2009-02-20 08:10:00 | AAPL | Stock | 3.1893 | 3.1893 | 3.1893 | 3.1893 | 2800.0 |
| 2009-02-20 08:12:00 | AAPL | Stock | 3.1875 | 3.1893 | 3.1875 | 3.1893 | 90720.0 |
| 2009-02-20 08:13:00 | AAPL | Stock | 3.1929 | 3.1957 | 3.1911 | 3.1911 | 37800.0 |
| 2009-02-20 08:14:00 | AAPL | Stock | 3.1886 | 3.1886 | 3.1857 | 3.1857 | 28000.0 |
| 2009-02-20 08:15:00 | AAPL | Stock | 3.1857 | 3.1857 | 3.1857 | 3.1857 | 2800.0 |
| 2009-02-20 08:16:00 | AAPL | Stock | 3.1821 | 3.1821 | 3.1821 | 3.1821 | 26460.0 |
| 2009-02-20 08:17:00 | AAPL | Stock | 3.1857 | 3.1857 | 3.1857 | 3.1857 | 5600.0 |
| 2009-02-20 08:19:00 | AAPL | Stock | 3.1811 | 3.1857 | 3.1804 | 3.1857 | 94080.0 |
| 2009-02-20 08:20:00 | AAPL | Stock | 3.1875 | 3.1875 | 3.1875 | 3.1875 | 14000.0 |
| 2009-02-20 08:22:00 | AAPL | Stock | 3.1857 | 3.1857 | 3.1821 | 3.1821 | 14000.0 |
| 2009-02-20 08:24:00 | AAPL | Stock | 3.1879 | 3.1879 | 3.1821 | 3.1821 | 11200.0 |
| 2009-02-20 08:26:00 | AAPL | Stock | 3.1811 | 3.1879 | 3.1811 | 3.1879 | 41048.0 |
| 2009-02-20 08:28:00 | AAPL | Stock | 3.1811 | 3.1879 | 3.1811 | 3.1879 | 34440.0 |
| 2009-02-20 08:30:00 | AAPL | Stock | 3.1821 | 3.1821 | 3.1821 | 3.1821 | 8400.0 |
| 2009-02-20 08:31:00 | AAPL | Stock | 3.1857 | 3.1857 | 3.1857 | 3.1857 | 67200.0 |
| 2009-02-20 08:35:00 | AAPL | Stock | 3.1907 | 3.1907 | 3.1907 | 3.1907 | 16800.0 |
| 2009-02-20 08:36:00 | AAPL | Stock | 3.1825 | 3.1879 | 3.1821 | 3.1875 | 36400.0 |
| 2009-02-20 08:37:00 | AAPL | Stock | 3.1875 | 3.1875 | 3.1875 | 3.1875 | 8400.0 |
| 2009-02-20 08:38:00 | AAPL | Stock | 3.1875 | 3.1875 | 3.1875 | 3.1875 | 14000.0 |
| 2009-02-20 08:39:00 | AAPL | Stock | 3.1893 | 3.1893 | 3.1857 | 3.1857 | 8400.0 |
| 2009-02-20 08:41:00 | AAPL | Stock | 3.19 | 3.19 | 3.1893 | 3.19 | 13720.0 |
| 2009-02-20 08:42:00 | AAPL | Stock | 3.19 | 3.1918 | 3.19 | 3.1918 | 11060.0 |
| 2009-02-20 08:43:00 | AAPL | Stock | 3.1904 | 3.1957 | 3.1821 | 3.1957 | 115920.0 |
| 2009-02-20 08:44:00 | AAPL | Stock | 3.1957 | 3.1964 | 3.1957 | 3.1964 | 103600.0 |
| 2009-02-20 08:45:00 | AAPL | Stock | 3.1964 | 3.1964 | 3.1921 | 3.1964 | 86800.0 |
| 2009-02-20 08:46:00 | AAPL | Stock | 3.195 | 3.1968 | 3.195 | 3.1964 | 46200.0 |
| 2009-02-20 08:47:00 | AAPL | Stock | 3.1964 | 3.1989 | 3.1964 | 3.1989 | 50400.0 |
| 2009-02-20 08:48:00 | AAPL | Stock | 3.1968 | 3.1968 | 3.1964 | 3.1964 | 40516.0 |
| 2009-02-20 08:50:00 | AAPL | Stock | 3.1964 | 3.1964 | 3.1957 | 3.1957 | 36400.0 |
| 2009-02-20 08:51:00 | AAPL | Stock | 3.1957 | 3.1957 | 3.1957 | 3.1957 | 73640.0 |
| 2009-02-20 08:55:00 | AAPL | Stock | 3.1961 | 3.1964 | 3.1961 | 3.1964 | 27972.0 |
| 2009-02-20 08:56:00 | AAPL | Stock | 3.1975 | 3.1975 | 3.1975 | 3.1975 | 4200.0 |
> showing 50 of 1,001,148 rows — these rows as CSV