PREVIEW / stock_5min / 2009-03-03
file: by_date/stock_5min/2009/2009-03-03.parquet size: 4.6 MB rows: 321,020 symbols: 3,359
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 |
|---|---|---|---|---|---|---|---|
| 2009-03-03 07:55:00 | AAPL | Stock | 3.1679 | 3.1679 | 3.1679 | 3.1679 | 5600.0 |
| 2009-03-03 08:00:00 | AAPL | Stock | 3.1671 | 3.1696 | 3.15 | 3.1671 | 115808.0 |
| 2009-03-03 08:05:00 | AAPL | Stock | 3.1679 | 3.1714 | 3.1607 | 3.1707 | 127736.0 |
| 2009-03-03 08:10:00 | AAPL | Stock | 3.17 | 3.175 | 3.1696 | 3.175 | 81200.0 |
| 2009-03-03 08:15:00 | AAPL | Stock | 3.1771 | 3.1786 | 3.1725 | 3.1786 | 47320.0 |
| 2009-03-03 08:20:00 | AAPL | Stock | 3.1786 | 3.1786 | 3.1768 | 3.1786 | 57596.0 |
| 2009-03-03 08:25:00 | AAPL | Stock | 3.1782 | 3.1839 | 3.1782 | 3.1821 | 117936.0 |
| 2009-03-03 08:30:00 | AAPL | Stock | 3.1839 | 3.2071 | 3.1821 | 3.1871 | 560560.0 |
| 2009-03-03 08:35:00 | AAPL | Stock | 3.1943 | 3.1982 | 3.1861 | 3.1893 | 413336.0 |
| 2009-03-03 08:40:00 | AAPL | Stock | 3.1893 | 3.1975 | 3.1786 | 3.1857 | 412916.0 |
| 2009-03-03 08:45:00 | AAPL | Stock | 3.1857 | 3.1893 | 3.1821 | 3.1893 | 73332.0 |
| 2009-03-03 08:50:00 | AAPL | Stock | 3.1829 | 3.1829 | 3.1679 | 3.1768 | 364084.0 |
| 2009-03-03 08:55:00 | AAPL | Stock | 3.1686 | 3.1857 | 3.1686 | 3.1821 | 420140.0 |
| 2009-03-03 09:00:00 | AAPL | Stock | 3.1821 | 3.185 | 3.1775 | 3.1843 | 342356.0 |
| 2009-03-03 09:05:00 | AAPL | Stock | 3.1843 | 3.1871 | 3.1836 | 3.1871 | 233856.0 |
| 2009-03-03 09:10:00 | AAPL | Stock | 3.1871 | 3.1907 | 3.1871 | 3.1893 | 62160.0 |
| 2009-03-03 09:15:00 | AAPL | Stock | 3.1904 | 3.2036 | 3.19 | 3.19 | 398216.0 |
| 2009-03-03 09:20:00 | AAPL | Stock | 3.1936 | 3.1939 | 3.1929 | 3.1929 | 84000.0 |
| 2009-03-03 09:25:00 | AAPL | Stock | 3.1946 | 3.1946 | 3.175 | 3.1786 | 293440.0 |
| 2009-03-03 09:30:00 | AAPL | Stock | 3.1768 | 3.1964 | 3.1625 | 3.1625 | 21580692.0 |
| 2009-03-03 09:35:00 | AAPL | Stock | 3.1645 | 3.1789 | 3.1579 | 3.175 | 15813308.0 |
| 2009-03-03 09:40:00 | AAPL | Stock | 3.1745 | 3.1746 | 3.1536 | 3.1707 | 18694200.0 |
| 2009-03-03 09:45:00 | AAPL | Stock | 3.1707 | 3.1821 | 3.17 | 3.1779 | 12574268.0 |
| 2009-03-03 09:50:00 | AAPL | Stock | 3.1782 | 3.1871 | 3.1714 | 3.1754 | 12935580.0 |
| 2009-03-03 09:55:00 | AAPL | Stock | 3.1761 | 3.1764 | 3.1607 | 3.1611 | 4973640.0 |
| 2009-03-03 10:00:00 | AAPL | Stock | 3.1611 | 3.1743 | 3.1486 | 3.1668 | 8889664.0 |
| 2009-03-03 10:05:00 | AAPL | Stock | 3.1664 | 3.1786 | 3.1643 | 3.175 | 10375820.0 |
| 2009-03-03 10:10:00 | AAPL | Stock | 3.1746 | 3.1761 | 3.1386 | 3.1393 | 11201092.0 |
| 2009-03-03 10:15:00 | AAPL | Stock | 3.1396 | 3.1561 | 3.1386 | 3.1514 | 12696460.0 |
| 2009-03-03 10:20:00 | AAPL | Stock | 3.1514 | 3.1743 | 3.1457 | 3.1671 | 8695120.0 |
| 2009-03-03 10:25:00 | AAPL | Stock | 3.1671 | 3.1754 | 3.1625 | 3.1686 | 5684056.0 |
| 2009-03-03 10:30:00 | AAPL | Stock | 3.1693 | 3.1695 | 3.1507 | 3.1593 | 6842808.0 |
| 2009-03-03 10:35:00 | AAPL | Stock | 3.16 | 3.1721 | 3.1571 | 3.1707 | 6839308.0 |
| 2009-03-03 10:40:00 | AAPL | Stock | 3.1707 | 3.1929 | 3.1696 | 3.1832 | 13262620.0 |
| 2009-03-03 10:45:00 | AAPL | Stock | 3.1832 | 3.1921 | 3.1811 | 3.1854 | 7946148.0 |
| 2009-03-03 10:50:00 | AAPL | Stock | 3.1854 | 3.1904 | 3.1693 | 3.1721 | 8340780.0 |
| 2009-03-03 10:55:00 | AAPL | Stock | 3.1721 | 3.1729 | 3.1607 | 3.1646 | 6578488.0 |
| 2009-03-03 11:00:00 | AAPL | Stock | 3.165 | 3.1714 | 3.155 | 3.1579 | 6450024.0 |
| 2009-03-03 11:05:00 | AAPL | Stock | 3.1579 | 3.1682 | 3.1521 | 3.1671 | 8985900.0 |
| 2009-03-03 11:10:00 | AAPL | Stock | 3.1671 | 3.1679 | 3.1429 | 3.1543 | 7917448.0 |
| 2009-03-03 11:15:00 | AAPL | Stock | 3.1543 | 3.1596 | 3.1471 | 3.1589 | 11085564.0 |
| 2009-03-03 11:20:00 | AAPL | Stock | 3.1589 | 3.1782 | 3.1564 | 3.1766 | 9406124.0 |
| 2009-03-03 11:25:00 | AAPL | Stock | 3.1775 | 3.1886 | 3.1739 | 3.1871 | 8691704.0 |
| 2009-03-03 11:30:00 | AAPL | Stock | 3.1868 | 3.1868 | 3.1764 | 3.1768 | 8038492.0 |
| 2009-03-03 11:35:00 | AAPL | Stock | 3.1779 | 3.1857 | 3.1714 | 3.1715 | 6463548.0 |
| 2009-03-03 11:40:00 | AAPL | Stock | 3.1725 | 3.1746 | 3.1639 | 3.1696 | 5204136.0 |
| 2009-03-03 11:45:00 | AAPL | Stock | 3.1696 | 3.1696 | 3.1593 | 3.1682 | 5049352.0 |
| 2009-03-03 11:50:00 | AAPL | Stock | 3.1686 | 3.1714 | 3.15 | 3.1596 | 5738208.0 |
| 2009-03-03 11:55:00 | AAPL | Stock | 3.1596 | 3.1718 | 3.1564 | 3.17 | 7286244.0 |
| 2009-03-03 12:00:00 | AAPL | Stock | 3.1704 | 3.1832 | 3.1671 | 3.1825 | 8348760.0 |
> showing 50 of 321,020 rows — these rows as CSV