PREVIEW / stock_1min / 2010-07-30
file: by_date/stock_1min/2010/2010-07-30.parquet size: 12.5 MB rows: 956,671 symbols: 2,819
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 |
|---|---|---|---|---|---|---|---|
| 2010-07-30 05:49:00 | AAPL | Stock | 9.1982 | 9.1982 | 9.1982 | 9.1982 | 2800.0 |
| 2010-07-30 06:47:00 | AAPL | Stock | 9.185 | 9.185 | 9.185 | 9.185 | 22120.0 |
| 2010-07-30 06:48:00 | AAPL | Stock | 9.185 | 9.185 | 9.185 | 9.185 | 8400.0 |
| 2010-07-30 06:49:00 | AAPL | Stock | 9.185 | 9.185 | 9.185 | 9.185 | 11200.0 |
| 2010-07-30 06:50:00 | AAPL | Stock | 9.185 | 9.185 | 9.185 | 9.185 | 5600.0 |
| 2010-07-30 06:59:00 | AAPL | Stock | 9.185 | 9.185 | 9.185 | 9.185 | 5600.0 |
| 2010-07-30 07:00:00 | AAPL | Stock | 9.1846 | 9.1846 | 9.1846 | 9.1846 | 6160.0 |
| 2010-07-30 07:01:00 | AAPL | Stock | 9.2075 | 9.2075 | 9.2075 | 9.2075 | 6440.0 |
| 2010-07-30 07:31:00 | AAPL | Stock | 9.1786 | 9.1786 | 9.1786 | 9.1786 | 2800.0 |
| 2010-07-30 07:34:00 | AAPL | Stock | 9.1786 | 9.1786 | 9.1782 | 9.1786 | 8400.0 |
| 2010-07-30 07:35:00 | AAPL | Stock | 9.1786 | 9.1786 | 9.1786 | 9.1786 | 2800.0 |
| 2010-07-30 07:42:00 | AAPL | Stock | 9.1789 | 9.1789 | 9.1789 | 9.1789 | 2800.0 |
| 2010-07-30 07:50:00 | AAPL | Stock | 9.1846 | 9.1846 | 9.1846 | 9.1846 | 8400.0 |
| 2010-07-30 07:52:00 | AAPL | Stock | 9.1846 | 9.1904 | 9.1846 | 9.1904 | 11200.0 |
| 2010-07-30 07:59:00 | AAPL | Stock | 9.185 | 9.185 | 9.185 | 9.185 | 2800.0 |
| 2010-07-30 08:00:00 | AAPL | Stock | 9.1846 | 9.1893 | 9.1811 | 9.1893 | 79520.0 |
| 2010-07-30 08:01:00 | AAPL | Stock | 9.1825 | 9.1832 | 9.1825 | 9.1832 | 19600.0 |
| 2010-07-30 08:02:00 | AAPL | Stock | 9.1861 | 9.1861 | 9.1854 | 9.1854 | 16800.0 |
| 2010-07-30 08:03:00 | AAPL | Stock | 9.1821 | 9.1846 | 9.1786 | 9.1786 | 25928.0 |
| 2010-07-30 08:04:00 | AAPL | Stock | 9.1814 | 9.1814 | 9.1743 | 9.1743 | 88760.0 |
| 2010-07-30 08:05:00 | AAPL | Stock | 9.1714 | 9.1714 | 9.1657 | 9.1657 | 14000.0 |
| 2010-07-30 08:07:00 | AAPL | Stock | 9.1718 | 9.1732 | 9.1704 | 9.1732 | 16800.0 |
| 2010-07-30 08:08:00 | AAPL | Stock | 9.1707 | 9.1707 | 9.1707 | 9.1707 | 5600.0 |
| 2010-07-30 08:09:00 | AAPL | Stock | 9.1704 | 9.1704 | 9.1704 | 9.1704 | 5600.0 |
| 2010-07-30 08:10:00 | AAPL | Stock | 9.1679 | 9.1714 | 9.1679 | 9.1714 | 15120.0 |
| 2010-07-30 08:11:00 | AAPL | Stock | 9.1696 | 9.1696 | 9.1625 | 9.1657 | 77028.0 |
| 2010-07-30 08:12:00 | AAPL | Stock | 9.1657 | 9.1675 | 9.1657 | 9.1675 | 37072.0 |
| 2010-07-30 08:13:00 | AAPL | Stock | 9.1729 | 9.1764 | 9.1696 | 9.1696 | 11424.0 |
| 2010-07-30 08:14:00 | AAPL | Stock | 9.1732 | 9.1764 | 9.1732 | 9.1764 | 30800.0 |
| 2010-07-30 08:15:00 | AAPL | Stock | 9.1761 | 9.1761 | 9.1732 | 9.1732 | 8400.0 |
| 2010-07-30 08:16:00 | AAPL | Stock | 9.1714 | 9.1714 | 9.1714 | 9.1714 | 2800.0 |
| 2010-07-30 08:18:00 | AAPL | Stock | 9.1757 | 9.1768 | 9.175 | 9.1764 | 46816.0 |
| 2010-07-30 08:20:00 | AAPL | Stock | 9.1746 | 9.1746 | 9.1746 | 9.1746 | 8400.0 |
| 2010-07-30 08:21:00 | AAPL | Stock | 9.1729 | 9.1729 | 9.1729 | 9.1729 | 2800.0 |
| 2010-07-30 08:22:00 | AAPL | Stock | 9.1736 | 9.1743 | 9.1729 | 9.1729 | 68600.0 |
| 2010-07-30 08:23:00 | AAPL | Stock | 9.1757 | 9.1757 | 9.1686 | 9.1686 | 76160.0 |
| 2010-07-30 08:24:00 | AAPL | Stock | 9.1679 | 9.1696 | 9.1679 | 9.1696 | 28980.0 |
| 2010-07-30 08:28:00 | AAPL | Stock | 9.1707 | 9.1707 | 9.1707 | 9.1707 | 2800.0 |
| 2010-07-30 08:29:00 | AAPL | Stock | 9.1736 | 9.175 | 9.1736 | 9.175 | 44800.0 |
| 2010-07-30 08:30:00 | AAPL | Stock | 9.17 | 9.1786 | 9.1446 | 9.1786 | 227556.0 |
| 2010-07-30 08:31:00 | AAPL | Stock | 9.1668 | 9.1668 | 9.1482 | 9.1611 | 76860.0 |
| 2010-07-30 08:32:00 | AAPL | Stock | 9.1575 | 9.1729 | 9.1561 | 9.1693 | 187880.0 |
| 2010-07-30 08:33:00 | AAPL | Stock | 9.1621 | 9.1679 | 9.1539 | 9.1679 | 66080.0 |
| 2010-07-30 08:34:00 | AAPL | Stock | 9.1693 | 9.1707 | 9.1693 | 9.1707 | 5600.0 |
| 2010-07-30 08:35:00 | AAPL | Stock | 9.1711 | 9.1711 | 9.1582 | 9.1614 | 139860.0 |
| 2010-07-30 08:36:00 | AAPL | Stock | 9.1614 | 9.1614 | 9.1614 | 9.1614 | 13580.0 |
| 2010-07-30 08:37:00 | AAPL | Stock | 9.1607 | 9.1661 | 9.1607 | 9.1661 | 11200.0 |
| 2010-07-30 08:38:00 | AAPL | Stock | 9.1629 | 9.1693 | 9.1629 | 9.1693 | 81956.0 |
| 2010-07-30 08:39:00 | AAPL | Stock | 9.1714 | 9.1789 | 9.1714 | 9.1779 | 144396.0 |
| 2010-07-30 08:40:00 | AAPL | Stock | 9.1714 | 9.175 | 9.1557 | 9.1557 | 164220.0 |
> showing 50 of 956,671 rows — these rows as CSV