PREVIEW / stock_1min / 2009-01-26
file: by_date/stock_1min/2009/2009-01-26.parquet size: 12.2 MB rows: 940,518 symbols: 2,678
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-01-26 06:55:00 | AAPL | Stock | 3.1875 | 3.1875 | 3.1875 | 3.1875 | 11200.0 |
| 2009-01-26 06:56:00 | AAPL | Stock | 3.1875 | 3.1875 | 3.1875 | 3.1875 | 16800.0 |
| 2009-01-26 07:00:00 | AAPL | Stock | 3.1875 | 3.1875 | 3.1875 | 3.1875 | 11200.0 |
| 2009-01-26 07:10:00 | AAPL | Stock | 3.1975 | 3.1975 | 3.1975 | 3.1975 | 2800.0 |
| 2009-01-26 07:38:00 | AAPL | Stock | 3.1696 | 3.17 | 3.1696 | 3.17 | 14000.0 |
| 2009-01-26 07:56:00 | AAPL | Stock | 3.1543 | 3.1543 | 3.1543 | 3.1543 | 2800.0 |
| 2009-01-26 08:00:00 | AAPL | Stock | 3.1536 | 3.1557 | 3.1486 | 3.15 | 48160.0 |
| 2009-01-26 08:03:00 | AAPL | Stock | 3.1557 | 3.1557 | 3.1557 | 3.1557 | 7000.0 |
| 2009-01-26 08:04:00 | AAPL | Stock | 3.1707 | 3.1707 | 3.1707 | 3.1707 | 5600.0 |
| 2009-01-26 08:07:00 | AAPL | Stock | 3.1607 | 3.1607 | 3.1607 | 3.1607 | 2800.0 |
| 2009-01-26 08:08:00 | AAPL | Stock | 3.1607 | 3.1607 | 3.1607 | 3.1607 | 5600.0 |
| 2009-01-26 08:19:00 | AAPL | Stock | 3.1611 | 3.1611 | 3.1611 | 3.1611 | 6020.0 |
| 2009-01-26 08:22:00 | AAPL | Stock | 3.1611 | 3.1611 | 3.1611 | 3.1611 | 8400.0 |
| 2009-01-26 08:29:00 | AAPL | Stock | 3.1571 | 3.1643 | 3.1571 | 3.1632 | 39480.0 |
| 2009-01-26 08:35:00 | AAPL | Stock | 3.1607 | 3.1607 | 3.1607 | 3.1607 | 3864.0 |
| 2009-01-26 08:41:00 | AAPL | Stock | 3.1689 | 3.1714 | 3.1689 | 3.1714 | 17920.0 |
| 2009-01-26 08:42:00 | AAPL | Stock | 3.1725 | 3.175 | 3.1725 | 3.175 | 53200.0 |
| 2009-01-26 08:43:00 | AAPL | Stock | 3.175 | 3.1779 | 3.175 | 3.1779 | 35000.0 |
| 2009-01-26 08:44:00 | AAPL | Stock | 3.1768 | 3.1782 | 3.1768 | 3.1782 | 9800.0 |
| 2009-01-26 08:45:00 | AAPL | Stock | 3.1768 | 3.1786 | 3.1768 | 3.1786 | 30380.0 |
| 2009-01-26 08:46:00 | AAPL | Stock | 3.1754 | 3.1821 | 3.1754 | 3.1821 | 8400.0 |
| 2009-01-26 08:49:00 | AAPL | Stock | 3.1793 | 3.1793 | 3.1786 | 3.1786 | 16800.0 |
| 2009-01-26 08:50:00 | AAPL | Stock | 3.1807 | 3.1814 | 3.1786 | 3.1786 | 29736.0 |
| 2009-01-26 08:51:00 | AAPL | Stock | 3.1775 | 3.1775 | 3.175 | 3.175 | 5600.0 |
| 2009-01-26 08:52:00 | AAPL | Stock | 3.1736 | 3.1786 | 3.1736 | 3.1771 | 22624.0 |
| 2009-01-26 08:55:00 | AAPL | Stock | 3.1736 | 3.1779 | 3.1732 | 3.1779 | 22820.0 |
| 2009-01-26 08:56:00 | AAPL | Stock | 3.1804 | 3.1804 | 3.1796 | 3.1804 | 11200.0 |
| 2009-01-26 08:58:00 | AAPL | Stock | 3.1775 | 3.1782 | 3.1771 | 3.1782 | 19600.0 |
| 2009-01-26 09:00:00 | AAPL | Stock | 3.1771 | 3.1771 | 3.1771 | 3.1771 | 4452.0 |
| 2009-01-26 09:01:00 | AAPL | Stock | 3.1771 | 3.1771 | 3.175 | 3.1754 | 58268.0 |
| 2009-01-26 09:02:00 | AAPL | Stock | 3.1771 | 3.1779 | 3.1771 | 3.1779 | 5600.0 |
| 2009-01-26 09:03:00 | AAPL | Stock | 3.1786 | 3.1814 | 3.1786 | 3.1814 | 24920.0 |
| 2009-01-26 09:06:00 | AAPL | Stock | 3.1796 | 3.1796 | 3.1796 | 3.1796 | 2800.0 |
| 2009-01-26 09:07:00 | AAPL | Stock | 3.1814 | 3.1818 | 3.1814 | 3.1818 | 5600.0 |
| 2009-01-26 09:08:00 | AAPL | Stock | 3.1821 | 3.1825 | 3.1821 | 3.1825 | 8400.0 |
| 2009-01-26 09:10:00 | AAPL | Stock | 3.1821 | 3.1821 | 3.1821 | 3.1821 | 10080.0 |
| 2009-01-26 09:11:00 | AAPL | Stock | 3.1818 | 3.1882 | 3.1818 | 3.1882 | 98196.0 |
| 2009-01-26 09:12:00 | AAPL | Stock | 3.1875 | 3.1875 | 3.1875 | 3.1875 | 11200.0 |
| 2009-01-26 09:13:00 | AAPL | Stock | 3.1882 | 3.1882 | 3.1789 | 3.1789 | 14000.0 |
| 2009-01-26 09:14:00 | AAPL | Stock | 3.1829 | 3.1861 | 3.1818 | 3.1861 | 36400.0 |
| 2009-01-26 09:15:00 | AAPL | Stock | 3.1857 | 3.1875 | 3.1782 | 3.1875 | 151788.0 |
| 2009-01-26 09:16:00 | AAPL | Stock | 3.1875 | 3.1882 | 3.1875 | 3.1875 | 89824.0 |
| 2009-01-26 09:17:00 | AAPL | Stock | 3.1871 | 3.1871 | 3.1871 | 3.1871 | 2800.0 |
| 2009-01-26 09:18:00 | AAPL | Stock | 3.1871 | 3.1904 | 3.1871 | 3.1904 | 117600.0 |
| 2009-01-26 09:19:00 | AAPL | Stock | 3.1904 | 3.1932 | 3.1875 | 3.1925 | 165900.0 |
| 2009-01-26 09:20:00 | AAPL | Stock | 3.1929 | 3.1929 | 3.1879 | 3.1879 | 8400.0 |
| 2009-01-26 09:21:00 | AAPL | Stock | 3.1929 | 3.1939 | 3.1861 | 3.1889 | 73164.0 |
| 2009-01-26 09:22:00 | AAPL | Stock | 3.1932 | 3.1939 | 3.1925 | 3.1932 | 56000.0 |
| 2009-01-26 09:24:00 | AAPL | Stock | 3.1932 | 3.1982 | 3.1932 | 3.1971 | 275100.0 |
| 2009-01-26 09:25:00 | AAPL | Stock | 3.1968 | 3.2029 | 3.1964 | 3.2029 | 67200.0 |
> showing 50 of 940,518 rows — these rows as CSV