PREVIEW / stock_5min / 2008-08-26
file: by_date/stock_5min/2008/2008-08-26.parquet size: 4.2 MB rows: 305,061 symbols: 3,303
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 |
|---|---|---|---|---|---|---|---|
| 2008-08-26 05:15:00 | AAPL | Stock | 6.1361 | 6.1361 | 6.1361 | 6.1361 | 2800.0 |
| 2008-08-26 05:30:00 | AAPL | Stock | 6.1868 | 6.1868 | 6.1868 | 6.1868 | 2800.0 |
| 2008-08-26 07:05:00 | AAPL | Stock | 6.1868 | 6.1868 | 6.1696 | 6.1768 | 16800.0 |
| 2008-08-26 07:20:00 | AAPL | Stock | 6.2036 | 6.2036 | 6.2036 | 6.2036 | 5600.0 |
| 2008-08-26 07:45:00 | AAPL | Stock | 6.1943 | 6.1943 | 6.1943 | 6.1943 | 11900.0 |
| 2008-08-26 07:55:00 | AAPL | Stock | 6.1789 | 6.1789 | 6.1786 | 6.1786 | 35196.0 |
| 2008-08-26 08:00:00 | AAPL | Stock | 6.1782 | 6.1854 | 6.1646 | 6.1693 | 363440.0 |
| 2008-08-26 08:05:00 | AAPL | Stock | 6.1704 | 6.1746 | 6.1671 | 6.1671 | 168504.0 |
| 2008-08-26 08:10:00 | AAPL | Stock | 6.1671 | 6.1671 | 6.1643 | 6.1661 | 56000.0 |
| 2008-08-26 08:15:00 | AAPL | Stock | 6.1661 | 6.1746 | 6.1661 | 6.1711 | 68320.0 |
| 2008-08-26 08:20:00 | AAPL | Stock | 6.1661 | 6.1661 | 6.1589 | 6.1589 | 70000.0 |
| 2008-08-26 08:25:00 | AAPL | Stock | 6.1661 | 6.1661 | 6.1661 | 6.1661 | 71400.0 |
| 2008-08-26 08:30:00 | AAPL | Stock | 6.1625 | 6.1654 | 6.1589 | 6.1625 | 98000.0 |
| 2008-08-26 08:35:00 | AAPL | Stock | 6.1625 | 6.1661 | 6.1625 | 6.1661 | 44520.0 |
| 2008-08-26 08:40:00 | AAPL | Stock | 6.1711 | 6.1732 | 6.1711 | 6.1714 | 33600.0 |
| 2008-08-26 08:45:00 | AAPL | Stock | 6.1696 | 6.1761 | 6.1696 | 6.1761 | 64400.0 |
| 2008-08-26 08:50:00 | AAPL | Stock | 6.1761 | 6.1771 | 6.175 | 6.175 | 50400.0 |
| 2008-08-26 08:55:00 | AAPL | Stock | 6.175 | 6.1943 | 6.1718 | 6.1786 | 255668.0 |
| 2008-08-26 09:00:00 | AAPL | Stock | 6.175 | 6.1754 | 6.1643 | 6.1643 | 161028.0 |
| 2008-08-26 09:05:00 | AAPL | Stock | 6.1611 | 6.165 | 6.1571 | 6.1607 | 117628.0 |
| 2008-08-26 09:10:00 | AAPL | Stock | 6.1661 | 6.175 | 6.1661 | 6.1725 | 73500.0 |
| 2008-08-26 09:15:00 | AAPL | Stock | 6.1714 | 6.1786 | 6.1689 | 6.1689 | 53200.0 |
| 2008-08-26 09:20:00 | AAPL | Stock | 6.1714 | 6.175 | 6.1696 | 6.1696 | 32200.0 |
| 2008-08-26 09:25:00 | AAPL | Stock | 6.1693 | 6.1693 | 6.1643 | 6.1643 | 145600.0 |
| 2008-08-26 09:30:00 | AAPL | Stock | 6.1661 | 6.2029 | 6.1646 | 6.1907 | 16589188.0 |
| 2008-08-26 09:35:00 | AAPL | Stock | 6.1918 | 6.2221 | 6.1893 | 6.2059 | 16185204.0 |
| 2008-08-26 09:40:00 | AAPL | Stock | 6.2075 | 6.2354 | 6.2057 | 6.2307 | 13584564.0 |
| 2008-08-26 09:45:00 | AAPL | Stock | 6.2304 | 6.2331 | 6.22 | 6.2307 | 10359972.0 |
| 2008-08-26 09:50:00 | AAPL | Stock | 6.2314 | 6.2321 | 6.2218 | 6.23 | 7499016.0 |
| 2008-08-26 09:55:00 | AAPL | Stock | 6.2296 | 6.2311 | 6.2146 | 6.2279 | 7133952.0 |
| 2008-08-26 10:00:00 | AAPL | Stock | 6.2286 | 6.2404 | 6.2157 | 6.2286 | 13834576.0 |
| 2008-08-26 10:05:00 | AAPL | Stock | 6.2289 | 6.2457 | 6.2143 | 6.2202 | 10846640.0 |
| 2008-08-26 10:10:00 | AAPL | Stock | 6.2204 | 6.2246 | 6.2079 | 6.2136 | 9241624.0 |
| 2008-08-26 10:15:00 | AAPL | Stock | 6.2132 | 6.2136 | 6.1964 | 6.1979 | 8460704.0 |
| 2008-08-26 10:20:00 | AAPL | Stock | 6.1979 | 6.2129 | 6.1946 | 6.2039 | 7087108.0 |
| 2008-08-26 10:25:00 | AAPL | Stock | 6.205 | 6.2232 | 6.2 | 6.2204 | 6416424.0 |
| 2008-08-26 10:30:00 | AAPL | Stock | 6.22 | 6.2414 | 6.2193 | 6.2393 | 10292940.0 |
| 2008-08-26 10:35:00 | AAPL | Stock | 6.2389 | 6.2414 | 6.2311 | 6.2357 | 5681956.0 |
| 2008-08-26 10:40:00 | AAPL | Stock | 6.2361 | 6.2411 | 6.2229 | 6.2268 | 6409284.0 |
| 2008-08-26 10:45:00 | AAPL | Stock | 6.2261 | 6.2271 | 6.2189 | 6.2207 | 3493252.0 |
| 2008-08-26 10:50:00 | AAPL | Stock | 6.2216 | 6.2268 | 6.2164 | 6.2221 | 2690688.0 |
| 2008-08-26 10:55:00 | AAPL | Stock | 6.2221 | 6.2375 | 6.2207 | 6.235 | 4821600.0 |
| 2008-08-26 11:00:00 | AAPL | Stock | 6.235 | 6.2379 | 6.2296 | 6.2357 | 2093056.0 |
| 2008-08-26 11:05:00 | AAPL | Stock | 6.2357 | 6.2389 | 6.2093 | 6.2146 | 5641440.0 |
| 2008-08-26 11:10:00 | AAPL | Stock | 6.2136 | 6.2143 | 6.2057 | 6.2125 | 3940020.0 |
| 2008-08-26 11:15:00 | AAPL | Stock | 6.2136 | 6.2179 | 6.2046 | 6.2082 | 3016972.0 |
| 2008-08-26 11:20:00 | AAPL | Stock | 6.2086 | 6.2143 | 6.2043 | 6.2079 | 2642640.0 |
| 2008-08-26 11:25:00 | AAPL | Stock | 6.2075 | 6.2125 | 6.2057 | 6.2114 | 1856484.0 |
| 2008-08-26 11:30:00 | AAPL | Stock | 6.2118 | 6.2118 | 6.1929 | 6.1932 | 4457908.0 |
| 2008-08-26 11:35:00 | AAPL | Stock | 6.1932 | 6.2018 | 6.1829 | 6.1836 | 7530964.0 |
> showing 50 of 305,061 rows — these rows as CSV