PREVIEW / stock_5min / 2006-12-11
file: by_date/stock_5min/2006/2006-12-11.parquet size: 3.2 MB rows: 238,187 symbols: 2,483
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 |
|---|---|---|---|---|---|---|---|
| 2006-12-11 05:10:00 | AAPL | Stock | 3.1736 | 3.1736 | 3.1736 | 3.1736 | 2800.0 |
| 2006-12-11 07:35:00 | AAPL | Stock | 3.1714 | 3.1714 | 3.1714 | 3.1714 | 5600.0 |
| 2006-12-11 07:45:00 | AAPL | Stock | 3.1757 | 3.1757 | 3.1757 | 3.1757 | 5600.0 |
| 2006-12-11 08:00:00 | AAPL | Stock | 3.1714 | 3.1907 | 3.1704 | 3.1889 | 478100.0 |
| 2006-12-11 08:05:00 | AAPL | Stock | 3.1893 | 3.1893 | 3.1857 | 3.1857 | 219380.0 |
| 2006-12-11 08:10:00 | AAPL | Stock | 3.1857 | 3.1864 | 3.1857 | 3.1857 | 199304.0 |
| 2006-12-11 08:15:00 | AAPL | Stock | 3.1857 | 3.1857 | 3.1829 | 3.1839 | 149520.0 |
| 2006-12-11 08:20:00 | AAPL | Stock | 3.1839 | 3.1868 | 3.1821 | 3.185 | 120596.0 |
| 2006-12-11 08:25:00 | AAPL | Stock | 3.1839 | 3.1839 | 3.1821 | 3.1839 | 120400.0 |
| 2006-12-11 08:30:00 | AAPL | Stock | 3.1839 | 3.1839 | 3.1825 | 3.1825 | 16800.0 |
| 2006-12-11 08:35:00 | AAPL | Stock | 3.1857 | 3.1857 | 3.1846 | 3.1846 | 78400.0 |
| 2006-12-11 08:40:00 | AAPL | Stock | 3.1839 | 3.1846 | 3.1796 | 3.1804 | 53200.0 |
| 2006-12-11 08:45:00 | AAPL | Stock | 3.1804 | 3.1839 | 3.1789 | 3.1789 | 62692.0 |
| 2006-12-11 08:50:00 | AAPL | Stock | 3.1786 | 3.1793 | 3.1786 | 3.1789 | 25200.0 |
| 2006-12-11 08:55:00 | AAPL | Stock | 3.1804 | 3.1804 | 3.1521 | 3.1521 | 47684.0 |
| 2006-12-11 09:00:00 | AAPL | Stock | 3.1804 | 3.1814 | 3.1793 | 3.1814 | 61600.0 |
| 2006-12-11 09:05:00 | AAPL | Stock | 3.1836 | 3.1846 | 3.1814 | 3.1832 | 45920.0 |
| 2006-12-11 09:10:00 | AAPL | Stock | 3.1821 | 3.1821 | 3.1789 | 3.1796 | 74956.0 |
| 2006-12-11 09:15:00 | AAPL | Stock | 3.1793 | 3.1821 | 3.1793 | 3.1793 | 25228.0 |
| 2006-12-11 09:20:00 | AAPL | Stock | 3.175 | 3.1782 | 3.175 | 3.1764 | 39200.0 |
| 2006-12-11 09:25:00 | AAPL | Stock | 3.1757 | 3.1771 | 3.1714 | 3.1771 | 198660.0 |
| 2006-12-11 09:30:00 | AAPL | Stock | 3.175 | 3.1839 | 3.1661 | 3.1746 | 7451584.0 |
| 2006-12-11 09:35:00 | AAPL | Stock | 3.1746 | 3.1761 | 3.1529 | 3.1529 | 15270276.0 |
| 2006-12-11 09:40:00 | AAPL | Stock | 3.1529 | 3.1586 | 3.1446 | 3.1536 | 16893212.0 |
| 2006-12-11 09:45:00 | AAPL | Stock | 3.1536 | 3.1657 | 3.1496 | 3.1582 | 13551048.0 |
| 2006-12-11 09:50:00 | AAPL | Stock | 3.1586 | 3.1689 | 3.1579 | 3.1654 | 10971912.0 |
| 2006-12-11 09:55:00 | AAPL | Stock | 3.1645 | 3.1825 | 3.1645 | 3.1782 | 16276260.0 |
| 2006-12-11 10:00:00 | AAPL | Stock | 3.1782 | 3.1839 | 3.165 | 3.1718 | 14052052.0 |
| 2006-12-11 10:05:00 | AAPL | Stock | 3.1721 | 3.1875 | 3.1718 | 3.1836 | 15174572.0 |
| 2006-12-11 10:10:00 | AAPL | Stock | 3.1836 | 3.1893 | 3.1811 | 3.1857 | 13429388.0 |
| 2006-12-11 10:15:00 | AAPL | Stock | 3.1864 | 3.1889 | 3.1796 | 3.1861 | 11858896.0 |
| 2006-12-11 10:20:00 | AAPL | Stock | 3.1854 | 3.1861 | 3.1796 | 3.18 | 8016400.0 |
| 2006-12-11 10:25:00 | AAPL | Stock | 3.1796 | 3.18 | 3.1686 | 3.1754 | 10948224.0 |
| 2006-12-11 10:30:00 | AAPL | Stock | 3.175 | 3.1796 | 3.1739 | 3.1789 | 5401312.0 |
| 2006-12-11 10:35:00 | AAPL | Stock | 3.1786 | 3.1825 | 3.1743 | 3.1793 | 6106856.0 |
| 2006-12-11 10:40:00 | AAPL | Stock | 3.1793 | 3.1807 | 3.1714 | 3.1757 | 4212628.0 |
| 2006-12-11 10:45:00 | AAPL | Stock | 3.1757 | 3.1804 | 3.1725 | 3.1793 | 3936240.0 |
| 2006-12-11 10:50:00 | AAPL | Stock | 3.1789 | 3.1796 | 3.1689 | 3.17 | 5808208.0 |
| 2006-12-11 10:55:00 | AAPL | Stock | 3.17 | 3.1786 | 3.1679 | 3.1707 | 8688680.0 |
| 2006-12-11 11:00:00 | AAPL | Stock | 3.1707 | 3.1746 | 3.1686 | 3.17 | 7378616.0 |
| 2006-12-11 11:05:00 | AAPL | Stock | 3.1696 | 3.1771 | 3.1696 | 3.1743 | 5767720.0 |
| 2006-12-11 11:10:00 | AAPL | Stock | 3.1743 | 3.1771 | 3.1739 | 3.1746 | 2890608.0 |
| 2006-12-11 11:15:00 | AAPL | Stock | 3.1746 | 3.1761 | 3.1696 | 3.1704 | 2744588.0 |
| 2006-12-11 11:20:00 | AAPL | Stock | 3.1707 | 3.1771 | 3.1704 | 3.1754 | 3834236.0 |
| 2006-12-11 11:25:00 | AAPL | Stock | 3.1757 | 3.1771 | 3.1739 | 3.1757 | 3831352.0 |
| 2006-12-11 11:30:00 | AAPL | Stock | 3.1761 | 3.18 | 3.1757 | 3.1779 | 5386892.0 |
| 2006-12-11 11:35:00 | AAPL | Stock | 3.1782 | 3.1811 | 3.1761 | 3.1761 | 4269244.0 |
| 2006-12-11 11:40:00 | AAPL | Stock | 3.1761 | 3.1804 | 3.1746 | 3.1757 | 3532676.0 |
| 2006-12-11 11:45:00 | AAPL | Stock | 3.1757 | 3.1779 | 3.1746 | 3.1757 | 2424464.0 |
| 2006-12-11 11:50:00 | AAPL | Stock | 3.1757 | 3.1779 | 3.1721 | 3.1721 | 5041204.0 |
> showing 50 of 238,187 rows — these rows as CSV