PREVIEW / stock_5min / 2009-11-30
file: by_date/stock_5min/2009/2009-11-30.parquet size: 4.9 MB rows: 333,093 symbols: 3,436
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-11-30 05:00:00 | AAPL | Stock | 7.1786 | 7.1786 | 7.1786 | 7.1786 | 27020.0 |
| 2009-11-30 06:05:00 | AAPL | Stock | 7.1786 | 7.1786 | 7.1786 | 7.1786 | 2800.0 |
| 2009-11-30 06:40:00 | AAPL | Stock | 7.1786 | 7.1786 | 7.1786 | 7.1786 | 2800.0 |
| 2009-11-30 06:55:00 | AAPL | Stock | 7.1782 | 7.1782 | 7.1782 | 7.1782 | 28000.0 |
| 2009-11-30 07:00:00 | AAPL | Stock | 7.1643 | 7.1643 | 7.1639 | 7.1639 | 61600.0 |
| 2009-11-30 07:05:00 | AAPL | Stock | 7.1639 | 7.1639 | 7.1639 | 7.1639 | 30800.0 |
| 2009-11-30 07:10:00 | AAPL | Stock | 7.1639 | 7.1639 | 7.1639 | 7.1639 | 11200.0 |
| 2009-11-30 07:15:00 | AAPL | Stock | 7.1643 | 7.1821 | 7.1643 | 7.1821 | 45780.0 |
| 2009-11-30 07:25:00 | AAPL | Stock | 7.1732 | 7.1875 | 7.1732 | 7.1875 | 30800.0 |
| 2009-11-30 07:35:00 | AAPL | Stock | 7.1893 | 7.1921 | 7.1857 | 7.1911 | 75040.0 |
| 2009-11-30 07:40:00 | AAPL | Stock | 7.1789 | 7.1789 | 7.1789 | 7.1789 | 14000.0 |
| 2009-11-30 07:45:00 | AAPL | Stock | 7.1946 | 7.2054 | 7.1946 | 7.2054 | 39060.0 |
| 2009-11-30 07:55:00 | AAPL | Stock | 7.2054 | 7.2054 | 7.2054 | 7.2054 | 2800.0 |
| 2009-11-30 08:00:00 | AAPL | Stock | 7.2039 | 7.2393 | 7.2039 | 7.2254 | 423360.0 |
| 2009-11-30 08:05:00 | AAPL | Stock | 7.225 | 7.2286 | 7.2196 | 7.2211 | 150836.0 |
| 2009-11-30 08:10:00 | AAPL | Stock | 7.2179 | 7.2232 | 7.2157 | 7.2161 | 116984.0 |
| 2009-11-30 08:15:00 | AAPL | Stock | 7.2179 | 7.2179 | 7.2139 | 7.2157 | 75880.0 |
| 2009-11-30 08:20:00 | AAPL | Stock | 7.2139 | 7.2286 | 7.2139 | 7.225 | 469644.0 |
| 2009-11-30 08:25:00 | AAPL | Stock | 7.225 | 7.2286 | 7.225 | 7.2286 | 156660.0 |
| 2009-11-30 08:30:00 | AAPL | Stock | 7.2268 | 7.2268 | 7.2218 | 7.2218 | 50960.0 |
| 2009-11-30 08:35:00 | AAPL | Stock | 7.2218 | 7.2239 | 7.2179 | 7.2239 | 263060.0 |
| 2009-11-30 08:40:00 | AAPL | Stock | 7.2232 | 7.23 | 7.1839 | 7.2096 | 461328.0 |
| 2009-11-30 08:45:00 | AAPL | Stock | 7.2143 | 7.2143 | 7.2089 | 7.2089 | 63084.0 |
| 2009-11-30 08:50:00 | AAPL | Stock | 7.2089 | 7.2143 | 7.2089 | 7.2143 | 72800.0 |
| 2009-11-30 08:55:00 | AAPL | Stock | 7.2143 | 7.2175 | 7.2121 | 7.2143 | 78652.0 |
| 2009-11-30 09:00:00 | AAPL | Stock | 7.2207 | 7.2211 | 7.2089 | 7.2114 | 152432.0 |
| 2009-11-30 09:05:00 | AAPL | Stock | 7.2107 | 7.2125 | 7.2093 | 7.2093 | 73780.0 |
| 2009-11-30 09:10:00 | AAPL | Stock | 7.2125 | 7.2125 | 7.2036 | 7.2036 | 228620.0 |
| 2009-11-30 09:15:00 | AAPL | Stock | 7.2014 | 7.2014 | 7.1918 | 7.1989 | 606984.0 |
| 2009-11-30 09:20:00 | AAPL | Stock | 7.1925 | 7.1932 | 7.1918 | 7.1921 | 244384.0 |
| 2009-11-30 09:25:00 | AAPL | Stock | 7.1939 | 7.2046 | 7.1825 | 7.1825 | 561568.0 |
| 2009-11-30 09:30:00 | AAPL | Stock | 7.1854 | 7.2029 | 7.1489 | 7.1811 | 16678452.0 |
| 2009-11-30 09:35:00 | AAPL | Stock | 7.1821 | 7.2029 | 7.1757 | 7.1986 | 12882296.0 |
| 2009-11-30 09:40:00 | AAPL | Stock | 7.1979 | 7.2029 | 7.1789 | 7.1985 | 13161764.0 |
| 2009-11-30 09:45:00 | AAPL | Stock | 7.1979 | 7.1989 | 7.1675 | 7.1821 | 12522020.0 |
| 2009-11-30 09:50:00 | AAPL | Stock | 7.1821 | 7.1836 | 7.1661 | 7.1743 | 5544028.0 |
| 2009-11-30 09:55:00 | AAPL | Stock | 7.1718 | 7.1818 | 7.1718 | 7.1771 | 5754952.0 |
| 2009-11-30 10:00:00 | AAPL | Stock | 7.1782 | 7.1879 | 7.1764 | 7.1814 | 6328700.0 |
| 2009-11-30 10:05:00 | AAPL | Stock | 7.1814 | 7.2 | 7.1811 | 7.1914 | 8495536.0 |
| 2009-11-30 10:10:00 | AAPL | Stock | 7.1918 | 7.1957 | 7.1839 | 7.1875 | 5230652.0 |
| 2009-11-30 10:15:00 | AAPL | Stock | 7.1871 | 7.1943 | 7.1829 | 7.1852 | 4977364.0 |
| 2009-11-30 10:20:00 | AAPL | Stock | 7.1854 | 7.1911 | 7.1725 | 7.1739 | 5356148.0 |
| 2009-11-30 10:25:00 | AAPL | Stock | 7.1746 | 7.1796 | 7.1696 | 7.1761 | 5321792.0 |
| 2009-11-30 10:30:00 | AAPL | Stock | 7.1751 | 7.1854 | 7.1743 | 7.1771 | 5788216.0 |
| 2009-11-30 10:35:00 | AAPL | Stock | 7.1775 | 7.1807 | 7.1729 | 7.1761 | 3181164.0 |
| 2009-11-30 10:40:00 | AAPL | Stock | 7.1761 | 7.1779 | 7.1721 | 7.1732 | 2473520.0 |
| 2009-11-30 10:45:00 | AAPL | Stock | 7.1732 | 7.1743 | 7.1571 | 7.1609 | 9138696.0 |
| 2009-11-30 10:50:00 | AAPL | Stock | 7.1596 | 7.1632 | 7.1518 | 7.1621 | 5010880.0 |
| 2009-11-30 10:55:00 | AAPL | Stock | 7.1632 | 7.1632 | 7.1518 | 7.1536 | 3340176.0 |
| 2009-11-30 11:00:00 | AAPL | Stock | 7.1539 | 7.1543 | 7.1321 | 7.1346 | 10205832.0 |
> showing 50 of 333,093 rows — these rows as CSV