PREVIEW / stock_1min / 2008-06-16
file: by_date/stock_1min/2008/2008-06-16.parquet size: 12.1 MB rows: 980,278 symbols: 2,692
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-06-16 04:16:00 | AAPL | Stock | 6.1786 | 6.1786 | 6.1786 | 6.1786 | 2800.0 |
| 2008-06-16 05:23:00 | AAPL | Stock | 6.1711 | 6.1711 | 6.1429 | 6.1429 | 11200.0 |
| 2008-06-16 06:11:00 | AAPL | Stock | 6.1786 | 6.1786 | 6.1786 | 6.1786 | 2800.0 |
| 2008-06-16 07:03:00 | AAPL | Stock | 6.1893 | 6.2036 | 6.1893 | 6.1893 | 22400.0 |
| 2008-06-16 07:07:00 | AAPL | Stock | 6.1946 | 6.1946 | 6.1946 | 6.1946 | 8400.0 |
| 2008-06-16 07:08:00 | AAPL | Stock | 6.1946 | 6.1946 | 6.1946 | 6.1946 | 5600.0 |
| 2008-06-16 07:09:00 | AAPL | Stock | 6.1946 | 6.1946 | 6.1946 | 6.1946 | 22400.0 |
| 2008-06-16 07:10:00 | AAPL | Stock | 6.1911 | 6.1911 | 6.1911 | 6.1911 | 28000.0 |
| 2008-06-16 07:14:00 | AAPL | Stock | 6.1893 | 6.1893 | 6.1893 | 6.1893 | 14000.0 |
| 2008-06-16 07:15:00 | AAPL | Stock | 6.1929 | 6.1929 | 6.1929 | 6.1929 | 2800.0 |
| 2008-06-16 07:18:00 | AAPL | Stock | 6.1929 | 6.1929 | 6.1929 | 6.1929 | 5600.0 |
| 2008-06-16 07:19:00 | AAPL | Stock | 6.1911 | 6.1911 | 6.1893 | 6.1893 | 8400.0 |
| 2008-06-16 07:22:00 | AAPL | Stock | 6.1821 | 6.1821 | 6.1821 | 6.1821 | 2800.0 |
| 2008-06-16 07:23:00 | AAPL | Stock | 6.1821 | 6.1821 | 6.1821 | 6.1821 | 2800.0 |
| 2008-06-16 07:28:00 | AAPL | Stock | 6.1907 | 6.1907 | 6.1907 | 6.1907 | 28000.0 |
| 2008-06-16 07:33:00 | AAPL | Stock | 6.1857 | 6.1857 | 6.1857 | 6.1857 | 2800.0 |
| 2008-06-16 07:38:00 | AAPL | Stock | 6.1889 | 6.1889 | 6.1889 | 6.1889 | 12600.0 |
| 2008-06-16 07:40:00 | AAPL | Stock | 6.1857 | 6.1893 | 6.1839 | 6.1893 | 76300.0 |
| 2008-06-16 07:44:00 | AAPL | Stock | 6.1893 | 6.1893 | 6.1893 | 6.1893 | 5600.0 |
| 2008-06-16 07:47:00 | AAPL | Stock | 6.1893 | 6.1893 | 6.1893 | 6.1893 | 28000.0 |
| 2008-06-16 07:48:00 | AAPL | Stock | 6.1893 | 6.1893 | 6.1857 | 6.1857 | 42000.0 |
| 2008-06-16 07:49:00 | AAPL | Stock | 6.1857 | 6.1893 | 6.1857 | 6.1893 | 140000.0 |
| 2008-06-16 07:50:00 | AAPL | Stock | 6.1857 | 6.1857 | 6.1857 | 6.1857 | 2800.0 |
| 2008-06-16 07:51:00 | AAPL | Stock | 6.1857 | 6.1857 | 6.1857 | 6.1857 | 2800.0 |
| 2008-06-16 07:52:00 | AAPL | Stock | 6.1857 | 6.1857 | 6.1821 | 6.1821 | 30800.0 |
| 2008-06-16 07:53:00 | AAPL | Stock | 6.1761 | 6.1786 | 6.175 | 6.1786 | 39200.0 |
| 2008-06-16 07:56:00 | AAPL | Stock | 6.1782 | 6.1782 | 6.1782 | 6.1782 | 8400.0 |
| 2008-06-16 07:59:00 | AAPL | Stock | 6.1782 | 6.1782 | 6.1782 | 6.1782 | 2800.0 |
| 2008-06-16 08:00:00 | AAPL | Stock | 6.1782 | 6.1882 | 6.1668 | 6.1786 | 362936.0 |
| 2008-06-16 08:01:00 | AAPL | Stock | 6.1786 | 6.1811 | 6.1786 | 6.1793 | 31080.0 |
| 2008-06-16 08:02:00 | AAPL | Stock | 6.1804 | 6.1882 | 6.1804 | 6.1879 | 82740.0 |
| 2008-06-16 08:03:00 | AAPL | Stock | 6.1882 | 6.1907 | 6.1879 | 6.1904 | 93800.0 |
| 2008-06-16 08:04:00 | AAPL | Stock | 6.1904 | 6.1904 | 6.19 | 6.19 | 8400.0 |
| 2008-06-16 08:05:00 | AAPL | Stock | 6.1886 | 6.1925 | 6.1886 | 6.1893 | 127876.0 |
| 2008-06-16 08:06:00 | AAPL | Stock | 6.1925 | 6.1943 | 6.1911 | 6.1943 | 46480.0 |
| 2008-06-16 08:07:00 | AAPL | Stock | 6.1943 | 6.1943 | 6.1918 | 6.1918 | 24780.0 |
| 2008-06-16 08:08:00 | AAPL | Stock | 6.1911 | 6.1911 | 6.1893 | 6.1893 | 16492.0 |
| 2008-06-16 08:09:00 | AAPL | Stock | 6.1886 | 6.1886 | 6.1857 | 6.1861 | 44072.0 |
| 2008-06-16 08:10:00 | AAPL | Stock | 6.1868 | 6.1868 | 6.1868 | 6.1868 | 2800.0 |
| 2008-06-16 08:11:00 | AAPL | Stock | 6.1875 | 6.1893 | 6.1875 | 6.1893 | 16352.0 |
| 2008-06-16 08:12:00 | AAPL | Stock | 6.1868 | 6.1875 | 6.1839 | 6.1839 | 373800.0 |
| 2008-06-16 08:13:00 | AAPL | Stock | 6.1839 | 6.1868 | 6.1804 | 6.1843 | 114800.0 |
| 2008-06-16 08:14:00 | AAPL | Stock | 6.1843 | 6.1843 | 6.1843 | 6.1843 | 8400.0 |
| 2008-06-16 08:16:00 | AAPL | Stock | 6.1861 | 6.1875 | 6.1861 | 6.1875 | 46200.0 |
| 2008-06-16 08:17:00 | AAPL | Stock | 6.1857 | 6.1875 | 6.185 | 6.1857 | 109900.0 |
| 2008-06-16 08:18:00 | AAPL | Stock | 6.1857 | 6.1896 | 6.1857 | 6.1875 | 63000.0 |
| 2008-06-16 08:19:00 | AAPL | Stock | 6.1857 | 6.1857 | 6.1857 | 6.1857 | 5600.0 |
| 2008-06-16 08:21:00 | AAPL | Stock | 6.1839 | 6.1857 | 6.1836 | 6.1836 | 19600.0 |
| 2008-06-16 08:22:00 | AAPL | Stock | 6.1836 | 6.1836 | 6.1836 | 6.1836 | 12600.0 |
| 2008-06-16 08:23:00 | AAPL | Stock | 6.1829 | 6.1829 | 6.1786 | 6.1786 | 213220.0 |
> showing 50 of 980,278 rows — these rows as CSV