PREVIEW / stock_1min / 2012-01-12
file: by_date/stock_1min/2012/2012-01-12.parquet size: 12.8 MB rows: 954,368 symbols: 2,862
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 |
|---|---|---|---|---|---|---|---|
| 2012-01-12 05:56:00 | AAPL | Stock | 15.1554 | 15.1554 | 15.1554 | 15.1554 | 8400.0 |
| 2012-01-12 05:58:00 | AAPL | Stock | 15.1129 | 15.1554 | 15.0957 | 15.0957 | 20440.0 |
| 2012-01-12 07:01:00 | AAPL | Stock | 15.1464 | 15.1596 | 15.1464 | 15.1596 | 39900.0 |
| 2012-01-12 07:02:00 | AAPL | Stock | 15.1707 | 15.1707 | 15.1707 | 15.1707 | 2800.0 |
| 2012-01-12 07:03:00 | AAPL | Stock | 15.1786 | 15.1786 | 15.1786 | 15.1786 | 2800.0 |
| 2012-01-12 07:05:00 | AAPL | Stock | 15.175 | 15.175 | 15.175 | 15.175 | 2800.0 |
| 2012-01-12 07:06:00 | AAPL | Stock | 15.1679 | 15.1679 | 15.1679 | 15.1679 | 14000.0 |
| 2012-01-12 07:07:00 | AAPL | Stock | 15.1518 | 15.1518 | 15.1518 | 15.1518 | 14000.0 |
| 2012-01-12 07:11:00 | AAPL | Stock | 15.1818 | 15.1818 | 15.1818 | 15.1818 | 2800.0 |
| 2012-01-12 07:18:00 | AAPL | Stock | 15.1736 | 15.1736 | 15.1718 | 15.1718 | 36400.0 |
| 2012-01-12 07:19:00 | AAPL | Stock | 15.1775 | 15.1782 | 15.1775 | 15.1782 | 28000.0 |
| 2012-01-12 07:23:00 | AAPL | Stock | 15.1764 | 15.1807 | 15.1764 | 15.1807 | 53200.0 |
| 2012-01-12 07:24:00 | AAPL | Stock | 15.1807 | 15.1807 | 15.1786 | 15.1786 | 8960.0 |
| 2012-01-12 07:25:00 | AAPL | Stock | 15.1807 | 15.1807 | 15.1779 | 15.1779 | 24640.0 |
| 2012-01-12 07:31:00 | AAPL | Stock | 15.1696 | 15.1696 | 15.1607 | 15.1607 | 14000.0 |
| 2012-01-12 07:32:00 | AAPL | Stock | 15.1768 | 15.1768 | 15.1768 | 15.1768 | 2800.0 |
| 2012-01-12 07:33:00 | AAPL | Stock | 15.175 | 15.175 | 15.175 | 15.175 | 2800.0 |
| 2012-01-12 07:37:00 | AAPL | Stock | 15.1661 | 15.1661 | 15.1661 | 15.1661 | 3500.0 |
| 2012-01-12 07:39:00 | AAPL | Stock | 15.1714 | 15.1714 | 15.1714 | 15.1714 | 2800.0 |
| 2012-01-12 07:40:00 | AAPL | Stock | 15.1721 | 15.1721 | 15.1718 | 15.1718 | 11200.0 |
| 2012-01-12 07:42:00 | AAPL | Stock | 15.1757 | 15.1807 | 15.1757 | 15.1807 | 46144.0 |
| 2012-01-12 07:43:00 | AAPL | Stock | 15.1807 | 15.1871 | 15.1786 | 15.1786 | 31640.0 |
| 2012-01-12 07:44:00 | AAPL | Stock | 15.1868 | 15.1871 | 15.1868 | 15.1871 | 25200.0 |
| 2012-01-12 07:45:00 | AAPL | Stock | 15.1893 | 15.1893 | 15.1893 | 15.1893 | 22400.0 |
| 2012-01-12 07:46:00 | AAPL | Stock | 15.1893 | 15.1925 | 15.1893 | 15.1925 | 5600.0 |
| 2012-01-12 07:47:00 | AAPL | Stock | 15.1918 | 15.1918 | 15.1918 | 15.1918 | 2800.0 |
| 2012-01-12 07:48:00 | AAPL | Stock | 15.1914 | 15.1914 | 15.1914 | 15.1914 | 2800.0 |
| 2012-01-12 07:51:00 | AAPL | Stock | 15.1907 | 15.1907 | 15.1875 | 15.1875 | 17808.0 |
| 2012-01-12 07:52:00 | AAPL | Stock | 15.195 | 15.1964 | 15.195 | 15.1964 | 26460.0 |
| 2012-01-12 07:57:00 | AAPL | Stock | 15.1861 | 15.1861 | 15.1861 | 15.1861 | 5600.0 |
| 2012-01-12 07:58:00 | AAPL | Stock | 15.18 | 15.18 | 15.18 | 15.18 | 2800.0 |
| 2012-01-12 08:00:00 | AAPL | Stock | 15.1789 | 15.1804 | 15.1661 | 15.1786 | 134708.0 |
| 2012-01-12 08:01:00 | AAPL | Stock | 15.1775 | 15.1779 | 15.1771 | 15.1771 | 17584.0 |
| 2012-01-12 08:02:00 | AAPL | Stock | 15.1771 | 15.1771 | 15.1771 | 15.1771 | 8680.0 |
| 2012-01-12 08:03:00 | AAPL | Stock | 15.1721 | 15.1789 | 15.1721 | 15.1786 | 115080.0 |
| 2012-01-12 08:04:00 | AAPL | Stock | 15.1829 | 15.1839 | 15.1786 | 15.1786 | 39088.0 |
| 2012-01-12 08:05:00 | AAPL | Stock | 15.1829 | 15.1829 | 15.1829 | 15.1829 | 5600.0 |
| 2012-01-12 08:06:00 | AAPL | Stock | 15.1768 | 15.1786 | 15.1736 | 15.1739 | 19992.0 |
| 2012-01-12 08:07:00 | AAPL | Stock | 15.1661 | 15.1661 | 15.1661 | 15.1661 | 8400.0 |
| 2012-01-12 08:08:00 | AAPL | Stock | 15.1721 | 15.1721 | 15.1618 | 15.1693 | 52640.0 |
| 2012-01-12 08:09:00 | AAPL | Stock | 15.1693 | 15.1693 | 15.1693 | 15.1693 | 5600.0 |
| 2012-01-12 08:12:00 | AAPL | Stock | 15.1629 | 15.1629 | 15.1589 | 15.1589 | 39452.0 |
| 2012-01-12 08:13:00 | AAPL | Stock | 15.1589 | 15.1589 | 15.1589 | 15.1589 | 5264.0 |
| 2012-01-12 08:15:00 | AAPL | Stock | 15.1639 | 15.1639 | 15.1639 | 15.1639 | 14000.0 |
| 2012-01-12 08:16:00 | AAPL | Stock | 15.1639 | 15.1643 | 15.1639 | 15.1643 | 14000.0 |
| 2012-01-12 08:21:00 | AAPL | Stock | 15.1539 | 15.1539 | 15.1539 | 15.1539 | 2800.0 |
| 2012-01-12 08:23:00 | AAPL | Stock | 15.1514 | 15.1514 | 15.1429 | 15.1429 | 22120.0 |
| 2012-01-12 08:24:00 | AAPL | Stock | 15.1525 | 15.1536 | 15.1525 | 15.1536 | 11200.0 |
| 2012-01-12 08:25:00 | AAPL | Stock | 15.1589 | 15.1589 | 15.1589 | 15.1589 | 2800.0 |
| 2012-01-12 08:26:00 | AAPL | Stock | 15.1486 | 15.15 | 15.1464 | 15.1464 | 29120.0 |
> showing 50 of 954,368 rows — these rows as CSV