PREVIEW / stock_1min / 2009-12-23
file: by_date/stock_1min/2009/2009-12-23.parquet size: 12.0 MB rows: 898,416 symbols: 2,805
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-12-23 04:46:00 | AAPL | Stock | 7.1525 | 7.1525 | 7.1525 | 7.1525 | 5600.0 |
| 2009-12-23 07:06:00 | AAPL | Stock | 7.1857 | 7.1857 | 7.1857 | 7.1857 | 10220.0 |
| 2009-12-23 07:09:00 | AAPL | Stock | 7.1857 | 7.1857 | 7.1857 | 7.1857 | 53760.0 |
| 2009-12-23 07:10:00 | AAPL | Stock | 7.1864 | 7.1864 | 7.1857 | 7.1857 | 27748.0 |
| 2009-12-23 07:13:00 | AAPL | Stock | 7.1857 | 7.1857 | 7.1857 | 7.1857 | 8400.0 |
| 2009-12-23 07:14:00 | AAPL | Stock | 7.1857 | 7.1857 | 7.1857 | 7.1857 | 41160.0 |
| 2009-12-23 07:21:00 | AAPL | Stock | 7.1857 | 7.1857 | 7.1857 | 7.1857 | 7000.0 |
| 2009-12-23 07:22:00 | AAPL | Stock | 7.1857 | 7.1857 | 7.1857 | 7.1857 | 2800.0 |
| 2009-12-23 07:26:00 | AAPL | Stock | 7.1857 | 7.1857 | 7.1857 | 7.1857 | 16800.0 |
| 2009-12-23 07:27:00 | AAPL | Stock | 7.1929 | 7.1929 | 7.1929 | 7.1929 | 7000.0 |
| 2009-12-23 07:35:00 | AAPL | Stock | 7.1857 | 7.1857 | 7.1857 | 7.1857 | 2800.0 |
| 2009-12-23 07:36:00 | AAPL | Stock | 7.1861 | 7.1861 | 7.1861 | 7.1861 | 2800.0 |
| 2009-12-23 07:41:00 | AAPL | Stock | 7.1857 | 7.1857 | 7.1857 | 7.1857 | 4312.0 |
| 2009-12-23 07:46:00 | AAPL | Stock | 7.1875 | 7.1875 | 7.1875 | 7.1875 | 2800.0 |
| 2009-12-23 07:49:00 | AAPL | Stock | 7.1889 | 7.1889 | 7.1889 | 7.1889 | 2800.0 |
| 2009-12-23 07:52:00 | AAPL | Stock | 7.1875 | 7.1875 | 7.1875 | 7.1875 | 11200.0 |
| 2009-12-23 08:00:00 | AAPL | Stock | 7.1825 | 7.1907 | 7.1725 | 7.1857 | 124768.0 |
| 2009-12-23 08:01:00 | AAPL | Stock | 7.1786 | 7.1786 | 7.175 | 7.1786 | 14000.0 |
| 2009-12-23 08:02:00 | AAPL | Stock | 7.1814 | 7.1814 | 7.1814 | 7.1814 | 5600.0 |
| 2009-12-23 08:03:00 | AAPL | Stock | 7.1814 | 7.1814 | 7.1786 | 7.1786 | 49252.0 |
| 2009-12-23 08:04:00 | AAPL | Stock | 7.1786 | 7.1821 | 7.1786 | 7.1821 | 29120.0 |
| 2009-12-23 08:05:00 | AAPL | Stock | 7.1821 | 7.1821 | 7.1821 | 7.1821 | 2800.0 |
| 2009-12-23 08:06:00 | AAPL | Stock | 7.1836 | 7.1889 | 7.1836 | 7.1889 | 5600.0 |
| 2009-12-23 08:07:00 | AAPL | Stock | 7.1875 | 7.1875 | 7.1821 | 7.1821 | 33600.0 |
| 2009-12-23 08:08:00 | AAPL | Stock | 7.1871 | 7.1875 | 7.1871 | 7.1875 | 28000.0 |
| 2009-12-23 08:09:00 | AAPL | Stock | 7.1875 | 7.1907 | 7.1875 | 7.1907 | 30800.0 |
| 2009-12-23 08:10:00 | AAPL | Stock | 7.1864 | 7.1864 | 7.1864 | 7.1864 | 2800.0 |
| 2009-12-23 08:11:00 | AAPL | Stock | 7.19 | 7.1907 | 7.19 | 7.1907 | 31080.0 |
| 2009-12-23 08:12:00 | AAPL | Stock | 7.1896 | 7.1896 | 7.1896 | 7.1896 | 2800.0 |
| 2009-12-23 08:14:00 | AAPL | Stock | 7.19 | 7.19 | 7.1864 | 7.1864 | 42280.0 |
| 2009-12-23 08:16:00 | AAPL | Stock | 7.1864 | 7.1875 | 7.1857 | 7.1875 | 28280.0 |
| 2009-12-23 08:20:00 | AAPL | Stock | 7.1861 | 7.1861 | 7.1861 | 7.1861 | 4620.0 |
| 2009-12-23 08:21:00 | AAPL | Stock | 7.1882 | 7.1882 | 7.1882 | 7.1882 | 8260.0 |
| 2009-12-23 08:22:00 | AAPL | Stock | 7.1875 | 7.1875 | 7.1875 | 7.1875 | 19600.0 |
| 2009-12-23 08:23:00 | AAPL | Stock | 7.1857 | 7.1857 | 7.1857 | 7.1857 | 13944.0 |
| 2009-12-23 08:24:00 | AAPL | Stock | 7.1857 | 7.1857 | 7.1857 | 7.1857 | 5600.0 |
| 2009-12-23 08:25:00 | AAPL | Stock | 7.1857 | 7.1857 | 7.1843 | 7.1843 | 28000.0 |
| 2009-12-23 08:26:00 | AAPL | Stock | 7.1875 | 7.1875 | 7.1875 | 7.1875 | 2800.0 |
| 2009-12-23 08:27:00 | AAPL | Stock | 7.1843 | 7.1843 | 7.1843 | 7.1843 | 5600.0 |
| 2009-12-23 08:28:00 | AAPL | Stock | 7.1839 | 7.1839 | 7.1839 | 7.1839 | 14000.0 |
| 2009-12-23 08:29:00 | AAPL | Stock | 7.1836 | 7.1836 | 7.1786 | 7.1786 | 39200.0 |
| 2009-12-23 08:30:00 | AAPL | Stock | 7.1786 | 7.1804 | 7.1746 | 7.1804 | 104300.0 |
| 2009-12-23 08:31:00 | AAPL | Stock | 7.1796 | 7.1804 | 7.1789 | 7.1804 | 42000.0 |
| 2009-12-23 08:32:00 | AAPL | Stock | 7.1843 | 7.1843 | 7.1843 | 7.1843 | 2800.0 |
| 2009-12-23 08:33:00 | AAPL | Stock | 7.1825 | 7.1857 | 7.1821 | 7.1854 | 40600.0 |
| 2009-12-23 08:34:00 | AAPL | Stock | 7.1854 | 7.1893 | 7.1854 | 7.1893 | 23800.0 |
| 2009-12-23 08:35:00 | AAPL | Stock | 7.1893 | 7.1911 | 7.1882 | 7.1904 | 66752.0 |
| 2009-12-23 08:36:00 | AAPL | Stock | 7.1893 | 7.1893 | 7.1882 | 7.1882 | 41216.0 |
| 2009-12-23 08:37:00 | AAPL | Stock | 7.1889 | 7.1893 | 7.1882 | 7.1889 | 74816.0 |
| 2009-12-23 08:38:00 | AAPL | Stock | 7.1886 | 7.1889 | 7.1886 | 7.1889 | 8400.0 |
> showing 50 of 898,416 rows — these rows as CSV