PREVIEW / stock_1min / 2009-09-11
file: by_date/stock_1min/2009/2009-09-11.parquet size: 12.5 MB rows: 939,782 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-09-11 06:29:00 | AAPL | Stock | 6.1764 | 6.1764 | 6.1764 | 6.1764 | 2800.0 |
| 2009-09-11 06:51:00 | AAPL | Stock | 6.1764 | 6.1786 | 6.1764 | 6.1786 | 6720.0 |
| 2009-09-11 07:12:00 | AAPL | Stock | 6.1796 | 6.1796 | 6.1796 | 6.1796 | 2800.0 |
| 2009-09-11 07:15:00 | AAPL | Stock | 6.1786 | 6.1786 | 6.1786 | 6.1786 | 39060.0 |
| 2009-09-11 07:33:00 | AAPL | Stock | 6.1782 | 6.1782 | 6.1782 | 6.1782 | 5600.0 |
| 2009-09-11 07:38:00 | AAPL | Stock | 6.1907 | 6.1911 | 6.1907 | 6.1907 | 22400.0 |
| 2009-09-11 07:39:00 | AAPL | Stock | 6.1907 | 6.1907 | 6.1907 | 6.1907 | 4200.0 |
| 2009-09-11 07:41:00 | AAPL | Stock | 6.1907 | 6.1939 | 6.1907 | 6.1939 | 19600.0 |
| 2009-09-11 07:42:00 | AAPL | Stock | 6.1907 | 6.1907 | 6.1907 | 6.1907 | 16800.0 |
| 2009-09-11 07:55:00 | AAPL | Stock | 6.1929 | 6.1939 | 6.1929 | 6.1939 | 19600.0 |
| 2009-09-11 07:56:00 | AAPL | Stock | 6.1857 | 6.1857 | 6.1857 | 6.1857 | 2800.0 |
| 2009-09-11 08:00:00 | AAPL | Stock | 6.1875 | 6.1889 | 6.1857 | 6.1889 | 94192.0 |
| 2009-09-11 08:01:00 | AAPL | Stock | 6.1904 | 6.1964 | 6.1904 | 6.1961 | 77980.0 |
| 2009-09-11 08:04:00 | AAPL | Stock | 6.1929 | 6.1929 | 6.1929 | 6.1929 | 16800.0 |
| 2009-09-11 08:05:00 | AAPL | Stock | 6.1879 | 6.1879 | 6.1879 | 6.1879 | 2800.0 |
| 2009-09-11 08:07:00 | AAPL | Stock | 6.1886 | 6.1886 | 6.1857 | 6.1857 | 16968.0 |
| 2009-09-11 08:08:00 | AAPL | Stock | 6.1836 | 6.1868 | 6.1836 | 6.1868 | 14000.0 |
| 2009-09-11 08:09:00 | AAPL | Stock | 6.1868 | 6.1868 | 6.1868 | 6.1868 | 14000.0 |
| 2009-09-11 08:10:00 | AAPL | Stock | 6.1868 | 6.1875 | 6.1868 | 6.1875 | 24248.0 |
| 2009-09-11 08:11:00 | AAPL | Stock | 6.1857 | 6.1857 | 6.1839 | 6.1839 | 21280.0 |
| 2009-09-11 08:12:00 | AAPL | Stock | 6.1821 | 6.1821 | 6.1821 | 6.1821 | 14000.0 |
| 2009-09-11 08:13:00 | AAPL | Stock | 6.1839 | 6.1839 | 6.1839 | 6.1839 | 4480.0 |
| 2009-09-11 08:14:00 | AAPL | Stock | 6.1807 | 6.1807 | 6.1807 | 6.1807 | 26880.0 |
| 2009-09-11 08:15:00 | AAPL | Stock | 6.1807 | 6.1807 | 6.1807 | 6.1807 | 8036.0 |
| 2009-09-11 08:16:00 | AAPL | Stock | 6.1825 | 6.1825 | 6.1807 | 6.1807 | 12600.0 |
| 2009-09-11 08:18:00 | AAPL | Stock | 6.1825 | 6.1839 | 6.1825 | 6.1839 | 52892.0 |
| 2009-09-11 08:19:00 | AAPL | Stock | 6.1857 | 6.1857 | 6.1857 | 6.1857 | 2800.0 |
| 2009-09-11 08:20:00 | AAPL | Stock | 6.1857 | 6.1857 | 6.1857 | 6.1857 | 21840.0 |
| 2009-09-11 08:21:00 | AAPL | Stock | 6.1825 | 6.1875 | 6.1825 | 6.1875 | 35980.0 |
| 2009-09-11 08:23:00 | AAPL | Stock | 6.1868 | 6.1868 | 6.1868 | 6.1868 | 2800.0 |
| 2009-09-11 08:24:00 | AAPL | Stock | 6.1868 | 6.1868 | 6.1868 | 6.1868 | 31388.0 |
| 2009-09-11 08:25:00 | AAPL | Stock | 6.1893 | 6.1893 | 6.1893 | 6.1893 | 9380.0 |
| 2009-09-11 08:26:00 | AAPL | Stock | 6.1893 | 6.1893 | 6.1871 | 6.1871 | 38220.0 |
| 2009-09-11 08:27:00 | AAPL | Stock | 6.1875 | 6.1886 | 6.1875 | 6.1886 | 13440.0 |
| 2009-09-11 08:28:00 | AAPL | Stock | 6.1889 | 6.1889 | 6.1868 | 6.1875 | 11200.0 |
| 2009-09-11 08:29:00 | AAPL | Stock | 6.1868 | 6.1871 | 6.1854 | 6.1871 | 22400.0 |
| 2009-09-11 08:31:00 | AAPL | Stock | 6.1843 | 6.1843 | 6.1839 | 6.1839 | 5600.0 |
| 2009-09-11 08:32:00 | AAPL | Stock | 6.1843 | 6.1843 | 6.1843 | 6.1843 | 8400.0 |
| 2009-09-11 08:33:00 | AAPL | Stock | 6.1882 | 6.1886 | 6.1882 | 6.1886 | 5600.0 |
| 2009-09-11 08:34:00 | AAPL | Stock | 6.1868 | 6.1868 | 6.1854 | 6.1854 | 23240.0 |
| 2009-09-11 08:36:00 | AAPL | Stock | 6.1836 | 6.1836 | 6.1825 | 6.1825 | 5600.0 |
| 2009-09-11 08:37:00 | AAPL | Stock | 6.1832 | 6.1864 | 6.1832 | 6.1864 | 44268.0 |
| 2009-09-11 08:38:00 | AAPL | Stock | 6.1839 | 6.1839 | 6.1839 | 6.1839 | 2800.0 |
| 2009-09-11 08:42:00 | AAPL | Stock | 6.1857 | 6.1857 | 6.1857 | 6.1857 | 2800.0 |
| 2009-09-11 08:45:00 | AAPL | Stock | 6.1889 | 6.1889 | 6.1886 | 6.1889 | 11200.0 |
| 2009-09-11 08:46:00 | AAPL | Stock | 6.1889 | 6.1904 | 6.1889 | 6.1893 | 36120.0 |
| 2009-09-11 08:48:00 | AAPL | Stock | 6.1875 | 6.1875 | 6.1875 | 6.1875 | 14000.0 |
| 2009-09-11 08:50:00 | AAPL | Stock | 6.1871 | 6.1871 | 6.1864 | 6.1868 | 17192.0 |
| 2009-09-11 08:52:00 | AAPL | Stock | 6.1861 | 6.1861 | 6.1861 | 6.1861 | 14000.0 |
| 2009-09-11 08:53:00 | AAPL | Stock | 6.1854 | 6.1854 | 6.1854 | 6.1854 | 5600.0 |
> showing 50 of 939,782 rows — these rows as CSV