PREVIEW / stock_5min / 2006-03-27
file: by_date/stock_5min/2006/2006-03-27.parquet size: 3.0 MB rows: 218,742 symbols: 2,223
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-03-27 06:30:00 | AAPL | Stock | 2.1446 | 2.1464 | 2.1446 | 2.1464 | 5600.0 |
| 2006-03-27 07:00:00 | AAPL | Stock | 2.1446 | 2.1446 | 2.1446 | 2.1446 | 2800.0 |
| 2006-03-27 07:05:00 | AAPL | Stock | 2.1446 | 2.1446 | 2.1446 | 2.1446 | 2800.0 |
| 2006-03-27 07:15:00 | AAPL | Stock | 2.1446 | 2.1446 | 2.1446 | 2.1446 | 25200.0 |
| 2006-03-27 07:20:00 | AAPL | Stock | 2.1464 | 2.1464 | 2.1464 | 2.1464 | 2800.0 |
| 2006-03-27 07:45:00 | AAPL | Stock | 2.1432 | 2.1432 | 2.1432 | 2.1432 | 19600.0 |
| 2006-03-27 07:50:00 | AAPL | Stock | 2.1464 | 2.1493 | 2.1464 | 2.1493 | 117600.0 |
| 2006-03-27 07:55:00 | AAPL | Stock | 2.1482 | 2.1482 | 2.1475 | 2.1475 | 19600.0 |
| 2006-03-27 08:00:00 | AAPL | Stock | 2.15 | 2.1521 | 2.1464 | 2.1518 | 807716.0 |
| 2006-03-27 08:05:00 | AAPL | Stock | 2.1518 | 2.1529 | 2.1493 | 2.15 | 346360.0 |
| 2006-03-27 08:10:00 | AAPL | Stock | 2.1504 | 2.1511 | 2.1489 | 2.1493 | 192360.0 |
| 2006-03-27 08:15:00 | AAPL | Stock | 2.1493 | 2.1493 | 2.1479 | 2.1482 | 213976.0 |
| 2006-03-27 08:20:00 | AAPL | Stock | 2.1489 | 2.1489 | 2.1482 | 2.1482 | 103600.0 |
| 2006-03-27 08:25:00 | AAPL | Stock | 2.1482 | 2.1482 | 2.1464 | 2.1475 | 206500.0 |
| 2006-03-27 08:30:00 | AAPL | Stock | 2.1479 | 2.1496 | 2.1475 | 2.1486 | 161812.0 |
| 2006-03-27 08:35:00 | AAPL | Stock | 2.1496 | 2.15 | 2.1482 | 2.1496 | 180460.0 |
| 2006-03-27 08:40:00 | AAPL | Stock | 2.1507 | 2.1511 | 2.1482 | 2.1493 | 200284.0 |
| 2006-03-27 08:45:00 | AAPL | Stock | 2.1489 | 2.1496 | 2.1486 | 2.1496 | 154000.0 |
| 2006-03-27 08:50:00 | AAPL | Stock | 2.1486 | 2.15 | 2.1479 | 2.1496 | 138040.0 |
| 2006-03-27 08:55:00 | AAPL | Stock | 2.15 | 2.1514 | 2.1489 | 2.1489 | 277760.0 |
| 2006-03-27 09:00:00 | AAPL | Stock | 2.1507 | 2.1507 | 2.1482 | 2.1482 | 262640.0 |
| 2006-03-27 09:05:00 | AAPL | Stock | 2.1486 | 2.1507 | 2.1479 | 2.1489 | 219100.0 |
| 2006-03-27 09:10:00 | AAPL | Stock | 2.15 | 2.1507 | 2.1482 | 2.1504 | 345352.0 |
| 2006-03-27 09:15:00 | AAPL | Stock | 2.1504 | 2.1504 | 2.1493 | 2.1493 | 27832.0 |
| 2006-03-27 09:20:00 | AAPL | Stock | 2.1493 | 2.1493 | 2.1482 | 2.1482 | 145320.0 |
| 2006-03-27 09:25:00 | AAPL | Stock | 2.1482 | 2.1554 | 2.1475 | 2.1539 | 868196.0 |
| 2006-03-27 09:30:00 | AAPL | Stock | 2.1554 | 2.1671 | 2.1446 | 2.1589 | 38854732.0 |
| 2006-03-27 09:35:00 | AAPL | Stock | 2.1593 | 2.1732 | 2.1539 | 2.1679 | 26407500.0 |
| 2006-03-27 09:40:00 | AAPL | Stock | 2.1682 | 2.1839 | 2.1632 | 2.1811 | 39230968.0 |
| 2006-03-27 09:45:00 | AAPL | Stock | 2.1818 | 2.1879 | 2.1739 | 2.1778 | 38075604.0 |
| 2006-03-27 09:50:00 | AAPL | Stock | 2.1786 | 2.1893 | 2.1779 | 2.1893 | 26705868.0 |
| 2006-03-27 09:55:00 | AAPL | Stock | 2.1889 | 2.1921 | 2.1846 | 2.1886 | 24431428.0 |
| 2006-03-27 10:00:00 | AAPL | Stock | 2.1886 | 2.1893 | 2.1786 | 2.1842 | 17593744.0 |
| 2006-03-27 10:05:00 | AAPL | Stock | 2.1836 | 2.1846 | 2.1725 | 2.1754 | 26707240.0 |
| 2006-03-27 10:10:00 | AAPL | Stock | 2.1757 | 2.1789 | 2.1714 | 2.1786 | 23154740.0 |
| 2006-03-27 10:15:00 | AAPL | Stock | 2.1782 | 2.1821 | 2.1771 | 2.1775 | 19024292.0 |
| 2006-03-27 10:20:00 | AAPL | Stock | 2.1779 | 2.1814 | 2.1754 | 2.1807 | 13183380.0 |
| 2006-03-27 10:25:00 | AAPL | Stock | 2.1804 | 2.1879 | 2.1768 | 2.1779 | 21600432.0 |
| 2006-03-27 10:30:00 | AAPL | Stock | 2.1782 | 2.1839 | 2.1768 | 2.1832 | 8733676.0 |
| 2006-03-27 10:35:00 | AAPL | Stock | 2.1829 | 2.1857 | 2.1793 | 2.1821 | 10502884.0 |
| 2006-03-27 10:40:00 | AAPL | Stock | 2.1821 | 2.1846 | 2.1804 | 2.1821 | 6517840.0 |
| 2006-03-27 10:45:00 | AAPL | Stock | 2.1821 | 2.1821 | 2.1729 | 2.1732 | 14318556.0 |
| 2006-03-27 10:50:00 | AAPL | Stock | 2.1732 | 2.1746 | 2.1679 | 2.1704 | 14639436.0 |
| 2006-03-27 10:55:00 | AAPL | Stock | 2.1704 | 2.1743 | 2.1661 | 2.1661 | 8874012.0 |
| 2006-03-27 11:00:00 | AAPL | Stock | 2.1661 | 2.1693 | 2.1636 | 2.1671 | 13759172.0 |
| 2006-03-27 11:05:00 | AAPL | Stock | 2.1671 | 2.1686 | 2.1607 | 2.165 | 12469716.0 |
| 2006-03-27 11:10:00 | AAPL | Stock | 2.1646 | 2.1721 | 2.1646 | 2.1713 | 16098096.0 |
| 2006-03-27 11:15:00 | AAPL | Stock | 2.1711 | 2.1761 | 2.1696 | 2.1743 | 10884832.0 |
| 2006-03-27 11:20:00 | AAPL | Stock | 2.1746 | 2.1771 | 2.1739 | 2.1743 | 8894396.0 |
| 2006-03-27 11:25:00 | AAPL | Stock | 2.1746 | 2.1757 | 2.1661 | 2.1682 | 11140920.0 |
> showing 50 of 218,742 rows — these rows as CSV