PREVIEW / stock_1min / 2011-05-19
file: by_date/stock_1min/2011/2011-05-19.parquet size: 13.1 MB rows: 982,102 symbols: 2,874
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-05-19 04:00:00 | AAPL | Stock | 12.1346 | 12.1346 | 12.1346 | 12.1346 | 2800.0 |
| 2011-05-19 04:43:00 | AAPL | Stock | 12.125 | 12.125 | 12.125 | 12.125 | 2800.0 |
| 2011-05-19 04:44:00 | AAPL | Stock | 12.1214 | 12.1214 | 12.1214 | 12.1214 | 2800.0 |
| 2011-05-19 04:54:00 | AAPL | Stock | 12.1125 | 12.1125 | 12.1125 | 12.1125 | 6300.0 |
| 2011-05-19 05:03:00 | AAPL | Stock | 12.1125 | 12.1125 | 12.1125 | 12.1125 | 11200.0 |
| 2011-05-19 05:18:00 | AAPL | Stock | 12.1418 | 12.1418 | 12.1418 | 12.1418 | 2800.0 |
| 2011-05-19 05:19:00 | AAPL | Stock | 12.1518 | 12.1518 | 12.1518 | 12.1518 | 2800.0 |
| 2011-05-19 06:11:00 | AAPL | Stock | 12.1914 | 12.1914 | 12.1914 | 12.1914 | 2800.0 |
| 2011-05-19 06:17:00 | AAPL | Stock | 12.1907 | 12.1907 | 12.1907 | 12.1907 | 2800.0 |
| 2011-05-19 06:44:00 | AAPL | Stock | 12.1904 | 12.1904 | 12.1904 | 12.1904 | 13104.0 |
| 2011-05-19 06:58:00 | AAPL | Stock | 12.1907 | 12.1907 | 12.1907 | 12.1907 | 4984.0 |
| 2011-05-19 07:10:00 | AAPL | Stock | 12.19 | 12.1904 | 12.19 | 12.19 | 37100.0 |
| 2011-05-19 07:16:00 | AAPL | Stock | 12.1921 | 12.1921 | 12.1921 | 12.1921 | 5600.0 |
| 2011-05-19 07:21:00 | AAPL | Stock | 12.1782 | 12.1782 | 12.1754 | 12.1754 | 18760.0 |
| 2011-05-19 07:22:00 | AAPL | Stock | 12.175 | 12.175 | 12.175 | 12.175 | 4620.0 |
| 2011-05-19 07:28:00 | AAPL | Stock | 12.1871 | 12.1871 | 12.1871 | 12.1871 | 2800.0 |
| 2011-05-19 07:36:00 | AAPL | Stock | 12.1789 | 12.1789 | 12.175 | 12.175 | 31220.0 |
| 2011-05-19 07:37:00 | AAPL | Stock | 12.175 | 12.175 | 12.1732 | 12.175 | 19600.0 |
| 2011-05-19 07:43:00 | AAPL | Stock | 12.18 | 12.1868 | 12.18 | 12.1868 | 11340.0 |
| 2011-05-19 07:45:00 | AAPL | Stock | 12.175 | 12.175 | 12.175 | 12.175 | 2800.0 |
| 2011-05-19 07:47:00 | AAPL | Stock | 12.1818 | 12.1818 | 12.1818 | 12.1818 | 2800.0 |
| 2011-05-19 07:54:00 | AAPL | Stock | 12.1818 | 12.1818 | 12.1757 | 12.1757 | 8400.0 |
| 2011-05-19 07:55:00 | AAPL | Stock | 12.1757 | 12.1757 | 12.1757 | 12.1757 | 14000.0 |
| 2011-05-19 07:56:00 | AAPL | Stock | 12.1757 | 12.1757 | 12.1757 | 12.1757 | 5600.0 |
| 2011-05-19 07:57:00 | AAPL | Stock | 12.1757 | 12.1757 | 12.1757 | 12.1757 | 5600.0 |
| 2011-05-19 07:59:00 | AAPL | Stock | 12.1786 | 12.1818 | 12.1786 | 12.1818 | 8400.0 |
| 2011-05-19 08:00:00 | AAPL | Stock | 12.1786 | 12.1914 | 12.1732 | 12.1732 | 66556.0 |
| 2011-05-19 08:01:00 | AAPL | Stock | 12.1739 | 12.175 | 12.1739 | 12.175 | 14000.0 |
| 2011-05-19 08:02:00 | AAPL | Stock | 12.1746 | 12.175 | 12.1746 | 12.175 | 8400.0 |
| 2011-05-19 08:04:00 | AAPL | Stock | 12.1679 | 12.1679 | 12.1679 | 12.1679 | 4200.0 |
| 2011-05-19 08:05:00 | AAPL | Stock | 12.1679 | 12.1679 | 12.1639 | 12.1639 | 19936.0 |
| 2011-05-19 08:06:00 | AAPL | Stock | 12.1639 | 12.1654 | 12.1607 | 12.1607 | 56000.0 |
| 2011-05-19 08:07:00 | AAPL | Stock | 12.1654 | 12.1746 | 12.1654 | 12.1743 | 36400.0 |
| 2011-05-19 08:08:00 | AAPL | Stock | 12.1721 | 12.1721 | 12.1721 | 12.1721 | 2800.0 |
| 2011-05-19 08:12:00 | AAPL | Stock | 12.1725 | 12.1964 | 12.1725 | 12.1889 | 194012.0 |
| 2011-05-19 08:13:00 | AAPL | Stock | 12.1779 | 12.1786 | 12.1779 | 12.1786 | 28588.0 |
| 2011-05-19 08:15:00 | AAPL | Stock | 12.1821 | 12.1821 | 12.1821 | 12.1821 | 5600.0 |
| 2011-05-19 08:17:00 | AAPL | Stock | 12.1786 | 12.1786 | 12.1782 | 12.1782 | 28840.0 |
| 2011-05-19 08:18:00 | AAPL | Stock | 12.1818 | 12.1821 | 12.1818 | 12.1821 | 27160.0 |
| 2011-05-19 08:19:00 | AAPL | Stock | 12.1854 | 12.1854 | 12.1854 | 12.1854 | 14000.0 |
| 2011-05-19 08:22:00 | AAPL | Stock | 12.1854 | 12.1854 | 12.1854 | 12.1854 | 7420.0 |
| 2011-05-19 08:25:00 | AAPL | Stock | 12.1839 | 12.1843 | 12.1839 | 12.1843 | 5600.0 |
| 2011-05-19 08:26:00 | AAPL | Stock | 12.1821 | 12.1821 | 12.1821 | 12.1821 | 3472.0 |
| 2011-05-19 08:27:00 | AAPL | Stock | 12.1843 | 12.1843 | 12.1843 | 12.1843 | 14560.0 |
| 2011-05-19 08:28:00 | AAPL | Stock | 12.1843 | 12.1843 | 12.1821 | 12.1821 | 16800.0 |
| 2011-05-19 08:30:00 | AAPL | Stock | 12.1843 | 12.2029 | 12.1839 | 12.2029 | 233352.0 |
| 2011-05-19 08:31:00 | AAPL | Stock | 12.1993 | 12.2054 | 12.1964 | 12.1996 | 50204.0 |
| 2011-05-19 08:32:00 | AAPL | Stock | 12.2036 | 12.2036 | 12.1996 | 12.1996 | 41160.0 |
| 2011-05-19 08:33:00 | AAPL | Stock | 12.2007 | 12.2018 | 12.2 | 12.2018 | 58380.0 |
| 2011-05-19 08:34:00 | AAPL | Stock | 12.2036 | 12.2054 | 12.2036 | 12.2036 | 39900.0 |
> showing 50 of 982,102 rows — these rows as CSV