PREVIEW / stock_1min / 2008-08-29
file: by_date/stock_1min/2008/2008-08-29.parquet size: 11.2 MB rows: 912,834 symbols: 2,702
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 |
|---|---|---|---|---|---|---|---|
| 2008-08-29 07:59:00 | AAPL | Stock | 6.1786 | 6.1786 | 6.1786 | 6.1786 | 2800.0 |
| 2008-08-29 08:00:00 | AAPL | Stock | 6.1839 | 6.1839 | 6.1786 | 6.1836 | 11060.0 |
| 2008-08-29 08:01:00 | AAPL | Stock | 6.1843 | 6.1843 | 6.1843 | 6.1843 | 2800.0 |
| 2008-08-29 08:02:00 | AAPL | Stock | 6.1786 | 6.1786 | 6.1786 | 6.1786 | 8400.0 |
| 2008-08-29 08:04:00 | AAPL | Stock | 6.1879 | 6.1879 | 6.1879 | 6.1879 | 2800.0 |
| 2008-08-29 08:08:00 | AAPL | Stock | 6.1821 | 6.1821 | 6.1821 | 6.1821 | 2800.0 |
| 2008-08-29 08:10:00 | AAPL | Stock | 6.1811 | 6.1879 | 6.1811 | 6.185 | 21000.0 |
| 2008-08-29 08:12:00 | AAPL | Stock | 6.1857 | 6.1857 | 6.1857 | 6.1857 | 8400.0 |
| 2008-08-29 08:18:00 | AAPL | Stock | 6.1907 | 6.1907 | 6.1875 | 6.1875 | 5600.0 |
| 2008-08-29 08:21:00 | AAPL | Stock | 6.1929 | 6.1946 | 6.1882 | 6.1882 | 75600.0 |
| 2008-08-29 08:22:00 | AAPL | Stock | 6.1946 | 6.1946 | 6.1879 | 6.1879 | 39200.0 |
| 2008-08-29 08:24:00 | AAPL | Stock | 6.1879 | 6.1879 | 6.1875 | 6.1875 | 32760.0 |
| 2008-08-29 08:25:00 | AAPL | Stock | 6.1954 | 6.1954 | 6.1882 | 6.1946 | 47600.0 |
| 2008-08-29 08:27:00 | AAPL | Stock | 6.1925 | 6.1946 | 6.1925 | 6.1946 | 19600.0 |
| 2008-08-29 08:30:00 | AAPL | Stock | 6.1882 | 6.205 | 6.1804 | 6.205 | 78148.0 |
| 2008-08-29 08:31:00 | AAPL | Stock | 6.1857 | 6.205 | 6.1857 | 6.1864 | 36148.0 |
| 2008-08-29 08:32:00 | AAPL | Stock | 6.1829 | 6.1829 | 6.1696 | 6.1696 | 159180.0 |
| 2008-08-29 08:33:00 | AAPL | Stock | 6.1721 | 6.1779 | 6.1718 | 6.1779 | 29400.0 |
| 2008-08-29 08:34:00 | AAPL | Stock | 6.1782 | 6.1818 | 6.1782 | 6.1818 | 51212.0 |
| 2008-08-29 08:35:00 | AAPL | Stock | 6.1793 | 6.1793 | 6.1793 | 6.1793 | 11200.0 |
| 2008-08-29 08:36:00 | AAPL | Stock | 6.1789 | 6.1804 | 6.1786 | 6.1804 | 39200.0 |
| 2008-08-29 08:37:00 | AAPL | Stock | 6.1754 | 6.1754 | 6.1754 | 6.1754 | 2800.0 |
| 2008-08-29 08:38:00 | AAPL | Stock | 6.175 | 6.175 | 6.1732 | 6.1732 | 100800.0 |
| 2008-08-29 08:39:00 | AAPL | Stock | 6.175 | 6.1829 | 6.175 | 6.1829 | 86380.0 |
| 2008-08-29 08:41:00 | AAPL | Stock | 6.1789 | 6.1789 | 6.1786 | 6.1786 | 12992.0 |
| 2008-08-29 08:42:00 | AAPL | Stock | 6.1736 | 6.1736 | 6.1732 | 6.1732 | 14000.0 |
| 2008-08-29 08:43:00 | AAPL | Stock | 6.1739 | 6.1779 | 6.1732 | 6.1732 | 29400.0 |
| 2008-08-29 08:45:00 | AAPL | Stock | 6.1779 | 6.1821 | 6.1754 | 6.1754 | 50400.0 |
| 2008-08-29 08:47:00 | AAPL | Stock | 6.1761 | 6.1761 | 6.1761 | 6.1761 | 25200.0 |
| 2008-08-29 08:48:00 | AAPL | Stock | 6.1761 | 6.1761 | 6.1754 | 6.1754 | 8400.0 |
| 2008-08-29 08:49:00 | AAPL | Stock | 6.1754 | 6.1754 | 6.175 | 6.175 | 8400.0 |
| 2008-08-29 08:50:00 | AAPL | Stock | 6.175 | 6.175 | 6.175 | 6.175 | 2800.0 |
| 2008-08-29 08:51:00 | AAPL | Stock | 6.1732 | 6.1732 | 6.1696 | 6.1711 | 84224.0 |
| 2008-08-29 08:52:00 | AAPL | Stock | 6.1696 | 6.1714 | 6.1689 | 6.1714 | 42504.0 |
| 2008-08-29 08:53:00 | AAPL | Stock | 6.1721 | 6.1721 | 6.1714 | 6.1714 | 136808.0 |
| 2008-08-29 08:54:00 | AAPL | Stock | 6.1721 | 6.1725 | 6.1721 | 6.1725 | 47600.0 |
| 2008-08-29 08:55:00 | AAPL | Stock | 6.1743 | 6.1743 | 6.1721 | 6.1721 | 72800.0 |
| 2008-08-29 08:56:00 | AAPL | Stock | 6.1721 | 6.1746 | 6.1721 | 6.1746 | 34020.0 |
| 2008-08-29 08:57:00 | AAPL | Stock | 6.1718 | 6.1718 | 6.1714 | 6.1714 | 11200.0 |
| 2008-08-29 08:58:00 | AAPL | Stock | 6.1714 | 6.1714 | 6.1714 | 6.1714 | 2800.0 |
| 2008-08-29 08:59:00 | AAPL | Stock | 6.1714 | 6.1714 | 6.1707 | 6.1707 | 35336.0 |
| 2008-08-29 09:00:00 | AAPL | Stock | 6.1704 | 6.1704 | 6.17 | 6.17 | 14000.0 |
| 2008-08-29 09:01:00 | AAPL | Stock | 6.1707 | 6.1732 | 6.1707 | 6.1732 | 24080.0 |
| 2008-08-29 09:02:00 | AAPL | Stock | 6.1714 | 6.1714 | 6.1714 | 6.1714 | 13524.0 |
| 2008-08-29 09:03:00 | AAPL | Stock | 6.1739 | 6.175 | 6.1739 | 6.175 | 16800.0 |
| 2008-08-29 09:04:00 | AAPL | Stock | 6.1757 | 6.1786 | 6.1757 | 6.1786 | 62720.0 |
| 2008-08-29 09:05:00 | AAPL | Stock | 6.1814 | 6.1821 | 6.1807 | 6.1807 | 30856.0 |
| 2008-08-29 09:06:00 | AAPL | Stock | 6.1804 | 6.1804 | 6.18 | 6.18 | 5600.0 |
| 2008-08-29 09:07:00 | AAPL | Stock | 6.18 | 6.18 | 6.18 | 6.18 | 22400.0 |
| 2008-08-29 09:08:00 | AAPL | Stock | 6.18 | 6.18 | 6.1782 | 6.1786 | 64400.0 |
> showing 50 of 912,834 rows — these rows as CSV