PREVIEW / stock_5min / 2006-11-22
file: by_date/stock_5min/2006/2006-11-22.parquet size: 3.2 MB rows: 230,359 symbols: 2,451
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-11-22 07:50:00 | AAPL | Stock | 3.1893 | 3.1925 | 3.1893 | 3.1925 | 8400.0 |
| 2006-11-22 07:55:00 | AAPL | Stock | 3.1839 | 3.1839 | 3.1839 | 3.1839 | 21840.0 |
| 2006-11-22 08:00:00 | AAPL | Stock | 3.1821 | 3.1864 | 3.1821 | 3.1821 | 252588.0 |
| 2006-11-22 08:05:00 | AAPL | Stock | 3.1814 | 3.1839 | 3.1814 | 3.1839 | 147224.0 |
| 2006-11-22 08:10:00 | AAPL | Stock | 3.1839 | 3.1868 | 3.1839 | 3.1857 | 196420.0 |
| 2006-11-22 08:15:00 | AAPL | Stock | 3.1875 | 3.1893 | 3.1868 | 3.1868 | 339724.0 |
| 2006-11-22 08:20:00 | AAPL | Stock | 3.1868 | 3.1907 | 3.1857 | 3.1907 | 275156.0 |
| 2006-11-22 08:25:00 | AAPL | Stock | 3.1896 | 3.1925 | 3.1882 | 3.1904 | 448812.0 |
| 2006-11-22 08:30:00 | AAPL | Stock | 3.1893 | 3.1907 | 3.1879 | 3.1879 | 327236.0 |
| 2006-11-22 08:35:00 | AAPL | Stock | 3.1879 | 3.1911 | 3.1854 | 3.1864 | 283640.0 |
| 2006-11-22 08:40:00 | AAPL | Stock | 3.1864 | 3.1875 | 3.1839 | 3.1864 | 314972.0 |
| 2006-11-22 08:45:00 | AAPL | Stock | 3.1857 | 3.1857 | 3.1821 | 3.1854 | 358820.0 |
| 2006-11-22 08:50:00 | AAPL | Stock | 3.1839 | 3.1854 | 3.1807 | 3.1821 | 133448.0 |
| 2006-11-22 08:55:00 | AAPL | Stock | 3.1839 | 3.1839 | 3.1811 | 3.1814 | 187600.0 |
| 2006-11-22 09:00:00 | AAPL | Stock | 3.1811 | 3.1821 | 3.1786 | 3.1796 | 337148.0 |
| 2006-11-22 09:05:00 | AAPL | Stock | 3.1793 | 3.1843 | 3.1786 | 3.1821 | 38640.0 |
| 2006-11-22 09:10:00 | AAPL | Stock | 3.18 | 3.1825 | 3.1789 | 3.1811 | 158760.0 |
| 2006-11-22 09:15:00 | AAPL | Stock | 3.1804 | 3.1804 | 3.1779 | 3.1786 | 142408.0 |
| 2006-11-22 09:20:00 | AAPL | Stock | 3.1786 | 3.1786 | 3.1768 | 3.1775 | 214648.0 |
| 2006-11-22 09:25:00 | AAPL | Stock | 3.1771 | 3.1804 | 3.1743 | 3.1764 | 597632.0 |
| 2006-11-22 09:30:00 | AAPL | Stock | 3.1782 | 3.1786 | 3.1646 | 3.1679 | 24684744.0 |
| 2006-11-22 09:35:00 | AAPL | Stock | 3.1679 | 3.1707 | 3.1611 | 3.1682 | 13498072.0 |
| 2006-11-22 09:40:00 | AAPL | Stock | 3.1679 | 3.1696 | 3.1607 | 3.1639 | 15141588.0 |
| 2006-11-22 09:45:00 | AAPL | Stock | 3.1643 | 3.175 | 3.1629 | 3.1711 | 12883948.0 |
| 2006-11-22 09:50:00 | AAPL | Stock | 3.1714 | 3.1714 | 3.1643 | 3.1661 | 8409828.0 |
| 2006-11-22 09:55:00 | AAPL | Stock | 3.1661 | 3.1729 | 3.1646 | 3.17 | 8082732.0 |
| 2006-11-22 10:00:00 | AAPL | Stock | 3.17 | 3.1701 | 3.1532 | 3.1554 | 20188840.0 |
| 2006-11-22 10:05:00 | AAPL | Stock | 3.155 | 3.1575 | 3.1379 | 3.1421 | 24875228.0 |
| 2006-11-22 10:10:00 | AAPL | Stock | 3.1425 | 3.1464 | 3.1375 | 3.1446 | 15487472.0 |
| 2006-11-22 10:15:00 | AAPL | Stock | 3.1436 | 3.1507 | 3.1421 | 3.1482 | 10202584.0 |
| 2006-11-22 10:20:00 | AAPL | Stock | 3.1482 | 3.1532 | 3.145 | 3.1518 | 7987840.0 |
| 2006-11-22 10:25:00 | AAPL | Stock | 3.1521 | 3.1521 | 3.1457 | 3.15 | 7170268.0 |
| 2006-11-22 10:30:00 | AAPL | Stock | 3.15 | 3.1554 | 3.15 | 3.1554 | 19025216.0 |
| 2006-11-22 10:35:00 | AAPL | Stock | 3.1554 | 3.1589 | 3.1536 | 3.1579 | 10160136.0 |
| 2006-11-22 10:40:00 | AAPL | Stock | 3.1575 | 3.1629 | 3.1539 | 3.1629 | 7656012.0 |
| 2006-11-22 10:45:00 | AAPL | Stock | 3.1625 | 3.1704 | 3.1621 | 3.1675 | 13814864.0 |
| 2006-11-22 10:50:00 | AAPL | Stock | 3.1675 | 3.1704 | 3.1632 | 3.1686 | 11806956.0 |
| 2006-11-22 10:55:00 | AAPL | Stock | 3.1686 | 3.1736 | 3.1671 | 3.1686 | 10140228.0 |
| 2006-11-22 11:00:00 | AAPL | Stock | 3.1686 | 3.1739 | 3.1679 | 3.1732 | 10645180.0 |
| 2006-11-22 11:05:00 | AAPL | Stock | 3.1732 | 3.1757 | 3.1721 | 3.1754 | 8807372.0 |
| 2006-11-22 11:10:00 | AAPL | Stock | 3.175 | 3.1768 | 3.1704 | 3.171 | 8884204.0 |
| 2006-11-22 11:15:00 | AAPL | Stock | 3.1707 | 3.1718 | 3.1664 | 3.1714 | 5350072.0 |
| 2006-11-22 11:20:00 | AAPL | Stock | 3.1714 | 3.1736 | 3.17 | 3.1714 | 3521476.0 |
| 2006-11-22 11:25:00 | AAPL | Stock | 3.1714 | 3.175 | 3.1711 | 3.1746 | 3865316.0 |
| 2006-11-22 11:30:00 | AAPL | Stock | 3.1746 | 3.1768 | 3.1732 | 3.1743 | 5401536.0 |
| 2006-11-22 11:35:00 | AAPL | Stock | 3.1743 | 3.175 | 3.1732 | 3.1739 | 3417932.0 |
| 2006-11-22 11:40:00 | AAPL | Stock | 3.1739 | 3.1779 | 3.1739 | 3.1771 | 4879588.0 |
| 2006-11-22 11:45:00 | AAPL | Stock | 3.1771 | 3.2139 | 3.1764 | 3.1868 | 16837408.0 |
| 2006-11-22 11:50:00 | AAPL | Stock | 3.1854 | 3.1893 | 3.1814 | 3.1871 | 7656488.0 |
| 2006-11-22 11:55:00 | AAPL | Stock | 3.1875 | 3.19 | 3.1839 | 3.1893 | 5506200.0 |
> showing 50 of 230,359 rows — these rows as CSV