PREVIEW / stock_1min / 2011-12-22
file: by_date/stock_1min/2011/2011-12-22.parquet size: 12.8 MB rows: 960,061 symbols: 2,865
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 |
|---|---|---|---|---|---|---|---|
| 2011-12-22 04:00:00 | AAPL | Stock | 14.1429 | 14.1429 | 14.1429 | 14.1429 | 2800.0 |
| 2011-12-22 04:03:00 | AAPL | Stock | 14.2025 | 14.2114 | 14.2025 | 14.2114 | 11200.0 |
| 2011-12-22 04:45:00 | AAPL | Stock | 14.1936 | 14.1936 | 14.1936 | 14.1936 | 2800.0 |
| 2011-12-22 05:36:00 | AAPL | Stock | 14.1429 | 14.1429 | 14.1429 | 14.1429 | 8400.0 |
| 2011-12-22 05:40:00 | AAPL | Stock | 14.1454 | 14.1454 | 14.1454 | 14.1454 | 5600.0 |
| 2011-12-22 06:08:00 | AAPL | Stock | 14.1489 | 14.1489 | 14.1432 | 14.1432 | 5600.0 |
| 2011-12-22 06:19:00 | AAPL | Stock | 14.1493 | 14.1493 | 14.1493 | 14.1493 | 2800.0 |
| 2011-12-22 06:20:00 | AAPL | Stock | 14.1493 | 14.1493 | 14.1493 | 14.1493 | 2800.0 |
| 2011-12-22 06:48:00 | AAPL | Stock | 14.1536 | 14.1536 | 14.1536 | 14.1536 | 5600.0 |
| 2011-12-22 06:50:00 | AAPL | Stock | 14.1536 | 14.1536 | 14.1536 | 14.1536 | 5600.0 |
| 2011-12-22 07:00:00 | AAPL | Stock | 14.1625 | 14.1625 | 14.1625 | 14.1625 | 5600.0 |
| 2011-12-22 07:01:00 | AAPL | Stock | 14.1664 | 14.1664 | 14.1664 | 14.1664 | 2800.0 |
| 2011-12-22 07:04:00 | AAPL | Stock | 14.1736 | 14.1736 | 14.1736 | 14.1736 | 5600.0 |
| 2011-12-22 07:13:00 | AAPL | Stock | 14.1557 | 14.1557 | 14.1557 | 14.1557 | 2800.0 |
| 2011-12-22 07:20:00 | AAPL | Stock | 14.1786 | 14.1786 | 14.1786 | 14.1786 | 2800.0 |
| 2011-12-22 07:21:00 | AAPL | Stock | 14.1875 | 14.1875 | 14.1875 | 14.1875 | 2800.0 |
| 2011-12-22 07:24:00 | AAPL | Stock | 14.1875 | 14.1875 | 14.1875 | 14.1875 | 5600.0 |
| 2011-12-22 07:26:00 | AAPL | Stock | 14.1861 | 14.1861 | 14.1861 | 14.1861 | 2800.0 |
| 2011-12-22 07:28:00 | AAPL | Stock | 14.1786 | 14.1786 | 14.1786 | 14.1786 | 5600.0 |
| 2011-12-22 07:30:00 | AAPL | Stock | 14.1836 | 14.1836 | 14.1836 | 14.1836 | 23240.0 |
| 2011-12-22 07:34:00 | AAPL | Stock | 14.1836 | 14.1839 | 14.1836 | 14.1839 | 21280.0 |
| 2011-12-22 07:35:00 | AAPL | Stock | 14.1857 | 14.1911 | 14.1857 | 14.1882 | 14000.0 |
| 2011-12-22 07:36:00 | AAPL | Stock | 14.1875 | 14.1875 | 14.1875 | 14.1875 | 8400.0 |
| 2011-12-22 07:38:00 | AAPL | Stock | 14.1964 | 14.1964 | 14.1964 | 14.1964 | 12320.0 |
| 2011-12-22 07:40:00 | AAPL | Stock | 14.1964 | 14.1964 | 14.1964 | 14.1964 | 14000.0 |
| 2011-12-22 07:41:00 | AAPL | Stock | 14.1964 | 14.1964 | 14.1964 | 14.1964 | 2800.0 |
| 2011-12-22 07:42:00 | AAPL | Stock | 14.1943 | 14.1943 | 14.1943 | 14.1943 | 5600.0 |
| 2011-12-22 07:43:00 | AAPL | Stock | 14.1918 | 14.1918 | 14.1918 | 14.1918 | 5600.0 |
| 2011-12-22 07:46:00 | AAPL | Stock | 14.19 | 14.1921 | 14.19 | 14.1921 | 8400.0 |
| 2011-12-22 07:47:00 | AAPL | Stock | 14.1921 | 14.1921 | 14.1921 | 14.1921 | 2800.0 |
| 2011-12-22 07:51:00 | AAPL | Stock | 14.1882 | 14.1882 | 14.1875 | 14.1875 | 14000.0 |
| 2011-12-22 07:55:00 | AAPL | Stock | 14.1882 | 14.1889 | 14.1882 | 14.1889 | 22400.0 |
| 2011-12-22 07:56:00 | AAPL | Stock | 14.1921 | 14.1964 | 14.1921 | 14.1964 | 11676.0 |
| 2011-12-22 08:00:00 | AAPL | Stock | 14.1925 | 14.1929 | 14.1925 | 14.1929 | 13804.0 |
| 2011-12-22 08:01:00 | AAPL | Stock | 14.1946 | 14.1946 | 14.1946 | 14.1946 | 5600.0 |
| 2011-12-22 08:02:00 | AAPL | Stock | 14.1864 | 14.1864 | 14.1861 | 14.1861 | 16800.0 |
| 2011-12-22 08:03:00 | AAPL | Stock | 14.1861 | 14.1943 | 14.1857 | 14.1868 | 33600.0 |
| 2011-12-22 08:04:00 | AAPL | Stock | 14.19 | 14.19 | 14.1893 | 14.1893 | 28000.0 |
| 2011-12-22 08:05:00 | AAPL | Stock | 14.1904 | 14.1904 | 14.1904 | 14.1904 | 2800.0 |
| 2011-12-22 08:06:00 | AAPL | Stock | 14.1964 | 14.1964 | 14.1961 | 14.1964 | 11200.0 |
| 2011-12-22 08:07:00 | AAPL | Stock | 14.1964 | 14.1964 | 14.1964 | 14.1964 | 14924.0 |
| 2011-12-22 08:08:00 | AAPL | Stock | 14.1964 | 14.1964 | 14.1929 | 14.1961 | 34468.0 |
| 2011-12-22 08:10:00 | AAPL | Stock | 14.19 | 14.19 | 14.1893 | 14.1893 | 5600.0 |
| 2011-12-22 08:11:00 | AAPL | Stock | 14.1907 | 14.1925 | 14.1907 | 14.1925 | 16800.0 |
| 2011-12-22 08:12:00 | AAPL | Stock | 14.1957 | 14.1957 | 14.1957 | 14.1957 | 5600.0 |
| 2011-12-22 08:14:00 | AAPL | Stock | 14.1936 | 14.1964 | 14.1936 | 14.1957 | 37660.0 |
| 2011-12-22 08:15:00 | AAPL | Stock | 14.1946 | 14.1946 | 14.1896 | 14.1896 | 14000.0 |
| 2011-12-22 08:16:00 | AAPL | Stock | 14.1911 | 14.1911 | 14.1911 | 14.1911 | 2800.0 |
| 2011-12-22 08:17:00 | AAPL | Stock | 14.1929 | 14.1929 | 14.1929 | 14.1929 | 2800.0 |
| 2011-12-22 08:18:00 | AAPL | Stock | 14.1925 | 14.1929 | 14.1925 | 14.1929 | 25760.0 |
> showing 50 of 960,061 rows — these rows as CSV