PREVIEW / stock_1min / 2010-08-11
file: by_date/stock_1min/2010/2010-08-11.parquet size: 13.2 MB rows: 1,012,293 symbols: 2,809
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-08-11 05:45:00 | AAPL | Stock | 9.1982 | 9.1982 | 9.1929 | 9.1929 | 8400.0 |
| 2010-08-11 05:50:00 | AAPL | Stock | 9.1696 | 9.1696 | 9.1696 | 9.1696 | 2800.0 |
| 2010-08-11 07:04:00 | AAPL | Stock | 9.1679 | 9.1679 | 9.1679 | 9.1679 | 2800.0 |
| 2010-08-11 07:07:00 | AAPL | Stock | 9.1661 | 9.1661 | 9.1661 | 9.1661 | 2800.0 |
| 2010-08-11 07:08:00 | AAPL | Stock | 9.1679 | 9.1679 | 9.1679 | 9.1679 | 2800.0 |
| 2010-08-11 07:09:00 | AAPL | Stock | 9.1679 | 9.1679 | 9.1661 | 9.1661 | 26600.0 |
| 2010-08-11 07:10:00 | AAPL | Stock | 9.1643 | 9.1643 | 9.1643 | 9.1643 | 2800.0 |
| 2010-08-11 07:11:00 | AAPL | Stock | 9.1643 | 9.1743 | 9.1643 | 9.1743 | 30800.0 |
| 2010-08-11 07:13:00 | AAPL | Stock | 9.175 | 9.175 | 9.175 | 9.175 | 5600.0 |
| 2010-08-11 07:14:00 | AAPL | Stock | 9.1761 | 9.1761 | 9.1761 | 9.1761 | 5600.0 |
| 2010-08-11 07:15:00 | AAPL | Stock | 9.1761 | 9.1761 | 9.1761 | 9.1761 | 2800.0 |
| 2010-08-11 07:16:00 | AAPL | Stock | 9.1757 | 9.1757 | 9.1757 | 9.1757 | 2800.0 |
| 2010-08-11 07:18:00 | AAPL | Stock | 9.175 | 9.175 | 9.175 | 9.175 | 2800.0 |
| 2010-08-11 07:20:00 | AAPL | Stock | 9.1786 | 9.1786 | 9.1786 | 9.1786 | 4200.0 |
| 2010-08-11 07:28:00 | AAPL | Stock | 9.1786 | 9.1786 | 9.1786 | 9.1786 | 2800.0 |
| 2010-08-11 07:29:00 | AAPL | Stock | 9.1786 | 9.1789 | 9.1786 | 9.1789 | 16100.0 |
| 2010-08-11 07:30:00 | AAPL | Stock | 9.1804 | 9.1804 | 9.1793 | 9.1793 | 5600.0 |
| 2010-08-11 07:31:00 | AAPL | Stock | 9.1786 | 9.1786 | 9.1786 | 9.1786 | 2800.0 |
| 2010-08-11 07:32:00 | AAPL | Stock | 9.1786 | 9.1786 | 9.175 | 9.175 | 22400.0 |
| 2010-08-11 07:40:00 | AAPL | Stock | 9.1793 | 9.1793 | 9.1793 | 9.1793 | 2800.0 |
| 2010-08-11 07:42:00 | AAPL | Stock | 9.1768 | 9.1768 | 9.1768 | 9.1768 | 5600.0 |
| 2010-08-11 07:44:00 | AAPL | Stock | 9.175 | 9.1768 | 9.175 | 9.1768 | 11200.0 |
| 2010-08-11 07:45:00 | AAPL | Stock | 9.1857 | 9.1857 | 9.1846 | 9.1846 | 14000.0 |
| 2010-08-11 07:46:00 | AAPL | Stock | 9.1825 | 9.1825 | 9.1764 | 9.1764 | 35168.0 |
| 2010-08-11 07:48:00 | AAPL | Stock | 9.1771 | 9.1771 | 9.175 | 9.175 | 28000.0 |
| 2010-08-11 07:54:00 | AAPL | Stock | 9.1818 | 9.1836 | 9.1807 | 9.1836 | 8400.0 |
| 2010-08-11 07:55:00 | AAPL | Stock | 9.1804 | 9.1804 | 9.1804 | 9.1804 | 5824.0 |
| 2010-08-11 07:56:00 | AAPL | Stock | 9.1804 | 9.1804 | 9.1804 | 9.1804 | 28000.0 |
| 2010-08-11 07:57:00 | AAPL | Stock | 9.1804 | 9.1804 | 9.1804 | 9.1804 | 2800.0 |
| 2010-08-11 07:58:00 | AAPL | Stock | 9.1804 | 9.1804 | 9.1804 | 9.1804 | 2800.0 |
| 2010-08-11 07:59:00 | AAPL | Stock | 9.1804 | 9.1804 | 9.1804 | 9.1804 | 184800.0 |
| 2010-08-11 08:00:00 | AAPL | Stock | 9.1829 | 9.1957 | 9.1757 | 9.1811 | 290444.0 |
| 2010-08-11 08:01:00 | AAPL | Stock | 9.1864 | 9.1864 | 9.1821 | 9.1821 | 26460.0 |
| 2010-08-11 08:02:00 | AAPL | Stock | 9.1821 | 9.1854 | 9.1807 | 9.1854 | 36680.0 |
| 2010-08-11 08:03:00 | AAPL | Stock | 9.1825 | 9.185 | 9.1804 | 9.185 | 65436.0 |
| 2010-08-11 08:04:00 | AAPL | Stock | 9.185 | 9.185 | 9.1786 | 9.1821 | 42000.0 |
| 2010-08-11 08:05:00 | AAPL | Stock | 9.1839 | 9.1839 | 9.1839 | 9.1839 | 2800.0 |
| 2010-08-11 08:06:00 | AAPL | Stock | 9.1825 | 9.1825 | 9.1786 | 9.1786 | 22428.0 |
| 2010-08-11 08:07:00 | AAPL | Stock | 9.1821 | 9.1821 | 9.1821 | 9.1821 | 11620.0 |
| 2010-08-11 08:08:00 | AAPL | Stock | 9.1821 | 9.1821 | 9.1796 | 9.1796 | 132692.0 |
| 2010-08-11 08:09:00 | AAPL | Stock | 9.1829 | 9.1829 | 9.1786 | 9.1789 | 256760.0 |
| 2010-08-11 08:10:00 | AAPL | Stock | 9.1775 | 9.1775 | 9.1668 | 9.1668 | 123564.0 |
| 2010-08-11 08:11:00 | AAPL | Stock | 9.1682 | 9.1729 | 9.1629 | 9.1643 | 89880.0 |
| 2010-08-11 08:12:00 | AAPL | Stock | 9.1675 | 9.1711 | 9.1657 | 9.1704 | 133504.0 |
| 2010-08-11 08:13:00 | AAPL | Stock | 9.1711 | 9.1711 | 9.1711 | 9.1711 | 2800.0 |
| 2010-08-11 08:14:00 | AAPL | Stock | 9.1714 | 9.1732 | 9.1711 | 9.1711 | 28420.0 |
| 2010-08-11 08:15:00 | AAPL | Stock | 9.1696 | 9.1696 | 9.1643 | 9.1679 | 22400.0 |
| 2010-08-11 08:16:00 | AAPL | Stock | 9.1668 | 9.1668 | 9.1646 | 9.1657 | 23800.0 |
| 2010-08-11 08:17:00 | AAPL | Stock | 9.1646 | 9.1661 | 9.1611 | 9.1657 | 28000.0 |
| 2010-08-11 08:18:00 | AAPL | Stock | 9.1629 | 9.1629 | 9.16 | 9.1607 | 47320.0 |
> showing 50 of 1,012,293 rows — these rows as CSV