PREVIEW / stock_5min / 2006-06-05
file: by_date/stock_5min/2006/2006-06-05.parquet size: 3.1 MB rows: 228,485 symbols: 2,287
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-06-05 07:20:00 | AAPL | Stock | 2.1893 | 2.1911 | 2.1893 | 2.1911 | 22400.0 |
| 2006-06-05 07:25:00 | AAPL | Stock | 2.1893 | 2.1893 | 2.1893 | 2.1893 | 2800.0 |
| 2006-06-05 07:50:00 | AAPL | Stock | 2.1893 | 2.1893 | 2.1893 | 2.1893 | 8400.0 |
| 2006-06-05 08:00:00 | AAPL | Stock | 2.1893 | 2.1893 | 2.1893 | 2.1893 | 30800.0 |
| 2006-06-05 08:05:00 | AAPL | Stock | 2.1893 | 2.1893 | 2.1893 | 2.1893 | 36400.0 |
| 2006-06-05 08:10:00 | AAPL | Stock | 2.1879 | 2.1879 | 2.1875 | 2.1875 | 77252.0 |
| 2006-06-05 08:15:00 | AAPL | Stock | 2.1875 | 2.1875 | 2.1825 | 2.1839 | 70000.0 |
| 2006-06-05 08:20:00 | AAPL | Stock | 2.1839 | 2.1857 | 2.1839 | 2.1857 | 5600.0 |
| 2006-06-05 08:30:00 | AAPL | Stock | 2.1864 | 2.1893 | 2.1857 | 2.1893 | 99400.0 |
| 2006-06-05 08:35:00 | AAPL | Stock | 2.1875 | 2.1893 | 2.1875 | 2.1893 | 60172.0 |
| 2006-06-05 08:40:00 | AAPL | Stock | 2.1893 | 2.1893 | 2.1893 | 2.1893 | 84000.0 |
| 2006-06-05 08:45:00 | AAPL | Stock | 2.1893 | 2.1893 | 2.1879 | 2.1879 | 53200.0 |
| 2006-06-05 08:50:00 | AAPL | Stock | 2.1879 | 2.1879 | 2.1879 | 2.1879 | 5600.0 |
| 2006-06-05 08:55:00 | AAPL | Stock | 2.1879 | 2.1882 | 2.1868 | 2.1868 | 187600.0 |
| 2006-06-05 09:00:00 | AAPL | Stock | 2.1875 | 2.1875 | 2.1854 | 2.1854 | 168000.0 |
| 2006-06-05 09:05:00 | AAPL | Stock | 2.1861 | 2.1864 | 2.1846 | 2.1846 | 145600.0 |
| 2006-06-05 09:10:00 | AAPL | Stock | 2.1846 | 2.185 | 2.1839 | 2.1839 | 113148.0 |
| 2006-06-05 09:15:00 | AAPL | Stock | 2.185 | 2.185 | 2.1839 | 2.1839 | 57400.0 |
| 2006-06-05 09:20:00 | AAPL | Stock | 2.185 | 2.185 | 2.185 | 2.185 | 30800.0 |
| 2006-06-05 09:25:00 | AAPL | Stock | 2.185 | 2.1857 | 2.1804 | 2.1804 | 195720.0 |
| 2006-06-05 09:30:00 | AAPL | Stock | 2.1839 | 2.1839 | 2.1629 | 2.1771 | 27991040.0 |
| 2006-06-05 09:35:00 | AAPL | Stock | 2.1767 | 2.1789 | 2.1625 | 2.1664 | 16007124.0 |
| 2006-06-05 09:40:00 | AAPL | Stock | 2.1661 | 2.1779 | 2.1654 | 2.1679 | 14959476.0 |
| 2006-06-05 09:45:00 | AAPL | Stock | 2.1686 | 2.1739 | 2.1646 | 2.1661 | 8605324.0 |
| 2006-06-05 09:50:00 | AAPL | Stock | 2.1661 | 2.1739 | 2.1659 | 2.1682 | 14183848.0 |
| 2006-06-05 09:55:00 | AAPL | Stock | 2.1682 | 2.1707 | 2.1643 | 2.1664 | 12197584.0 |
| 2006-06-05 10:00:00 | AAPL | Stock | 2.1664 | 2.1714 | 2.1621 | 2.1697 | 16943220.0 |
| 2006-06-05 10:05:00 | AAPL | Stock | 2.17 | 2.1729 | 2.1668 | 2.1668 | 9135392.0 |
| 2006-06-05 10:10:00 | AAPL | Stock | 2.1671 | 2.1739 | 2.1664 | 2.1707 | 11538940.0 |
| 2006-06-05 10:15:00 | AAPL | Stock | 2.1707 | 2.1768 | 2.1696 | 2.1739 | 11482548.0 |
| 2006-06-05 10:20:00 | AAPL | Stock | 2.1739 | 2.175 | 2.1689 | 2.1718 | 9976792.0 |
| 2006-06-05 10:25:00 | AAPL | Stock | 2.1718 | 2.1739 | 2.1714 | 2.1729 | 6641208.0 |
| 2006-06-05 10:30:00 | AAPL | Stock | 2.1729 | 2.1775 | 2.1725 | 2.1732 | 9366616.0 |
| 2006-06-05 10:35:00 | AAPL | Stock | 2.1732 | 2.1736 | 2.1689 | 2.1707 | 6912528.0 |
| 2006-06-05 10:40:00 | AAPL | Stock | 2.1707 | 2.1721 | 2.1668 | 2.1681 | 4713800.0 |
| 2006-06-05 10:45:00 | AAPL | Stock | 2.1682 | 2.175 | 2.1679 | 2.1743 | 6680100.0 |
| 2006-06-05 10:50:00 | AAPL | Stock | 2.1739 | 2.1779 | 2.1714 | 2.1754 | 8302700.0 |
| 2006-06-05 10:55:00 | AAPL | Stock | 2.1754 | 2.1761 | 2.1736 | 2.1746 | 4503072.0 |
| 2006-06-05 11:00:00 | AAPL | Stock | 2.175 | 2.1814 | 2.175 | 2.1754 | 10242820.0 |
| 2006-06-05 11:05:00 | AAPL | Stock | 2.1754 | 2.1811 | 2.1746 | 2.1804 | 6435968.0 |
| 2006-06-05 11:10:00 | AAPL | Stock | 2.1804 | 2.1832 | 2.1774 | 2.1811 | 5936924.0 |
| 2006-06-05 11:15:00 | AAPL | Stock | 2.1811 | 2.1821 | 2.1789 | 2.1789 | 4244716.0 |
| 2006-06-05 11:20:00 | AAPL | Stock | 2.1789 | 2.1807 | 2.175 | 2.1796 | 5221272.0 |
| 2006-06-05 11:25:00 | AAPL | Stock | 2.1796 | 2.1796 | 2.1761 | 2.1779 | 3365572.0 |
| 2006-06-05 11:30:00 | AAPL | Stock | 2.1779 | 2.1779 | 2.1732 | 2.1754 | 4577552.0 |
| 2006-06-05 11:35:00 | AAPL | Stock | 2.1754 | 2.1764 | 2.1721 | 2.1736 | 2768136.0 |
| 2006-06-05 11:40:00 | AAPL | Stock | 2.1736 | 2.1739 | 2.1718 | 2.1729 | 4078844.0 |
| 2006-06-05 11:45:00 | AAPL | Stock | 2.1729 | 2.1739 | 2.1714 | 2.1725 | 3648176.0 |
| 2006-06-05 11:50:00 | AAPL | Stock | 2.1725 | 2.1731 | 2.1693 | 2.1714 | 5254788.0 |
| 2006-06-05 11:55:00 | AAPL | Stock | 2.1711 | 2.1729 | 2.1696 | 2.1729 | 2585856.0 |
> showing 50 of 228,485 rows — these rows as CSV