PREVIEW / stock_5min / 2009-01-26
file: by_date/stock_5min/2009/2009-01-26.parquet size: 4.4 MB rows: 305,185 symbols: 3,306
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-01-26 06:55:00 | AAPL | Stock | 3.1875 | 3.1875 | 3.1875 | 3.1875 | 28000.0 |
| 2009-01-26 07:00:00 | AAPL | Stock | 3.1875 | 3.1875 | 3.1875 | 3.1875 | 11200.0 |
| 2009-01-26 07:10:00 | AAPL | Stock | 3.1975 | 3.1975 | 3.1975 | 3.1975 | 2800.0 |
| 2009-01-26 07:35:00 | AAPL | Stock | 3.1696 | 3.17 | 3.1696 | 3.17 | 14000.0 |
| 2009-01-26 07:55:00 | AAPL | Stock | 3.1543 | 3.1543 | 3.1543 | 3.1543 | 2800.0 |
| 2009-01-26 08:00:00 | AAPL | Stock | 3.1536 | 3.1707 | 3.1486 | 3.1707 | 60760.0 |
| 2009-01-26 08:05:00 | AAPL | Stock | 3.1607 | 3.1607 | 3.1607 | 3.1607 | 8400.0 |
| 2009-01-26 08:15:00 | AAPL | Stock | 3.1611 | 3.1611 | 3.1611 | 3.1611 | 6020.0 |
| 2009-01-26 08:20:00 | AAPL | Stock | 3.1611 | 3.1611 | 3.1611 | 3.1611 | 8400.0 |
| 2009-01-26 08:25:00 | AAPL | Stock | 3.1571 | 3.1643 | 3.1571 | 3.1632 | 39480.0 |
| 2009-01-26 08:35:00 | AAPL | Stock | 3.1607 | 3.1607 | 3.1607 | 3.1607 | 3864.0 |
| 2009-01-26 08:40:00 | AAPL | Stock | 3.1689 | 3.1782 | 3.1689 | 3.1782 | 115920.0 |
| 2009-01-26 08:45:00 | AAPL | Stock | 3.1768 | 3.1821 | 3.1754 | 3.1786 | 55580.0 |
| 2009-01-26 08:50:00 | AAPL | Stock | 3.1807 | 3.1814 | 3.1736 | 3.1771 | 57960.0 |
| 2009-01-26 08:55:00 | AAPL | Stock | 3.1736 | 3.1804 | 3.1732 | 3.1782 | 53620.0 |
| 2009-01-26 09:00:00 | AAPL | Stock | 3.1771 | 3.1814 | 3.175 | 3.1814 | 93240.0 |
| 2009-01-26 09:05:00 | AAPL | Stock | 3.1796 | 3.1825 | 3.1796 | 3.1825 | 16800.0 |
| 2009-01-26 09:10:00 | AAPL | Stock | 3.1821 | 3.1882 | 3.1789 | 3.1861 | 169876.0 |
| 2009-01-26 09:15:00 | AAPL | Stock | 3.1857 | 3.1932 | 3.1782 | 3.1925 | 527912.0 |
| 2009-01-26 09:20:00 | AAPL | Stock | 3.1929 | 3.1982 | 3.1861 | 3.1971 | 412664.0 |
| 2009-01-26 09:25:00 | AAPL | Stock | 3.1968 | 3.2029 | 3.1671 | 3.1743 | 1000328.0 |
| 2009-01-26 09:30:00 | AAPL | Stock | 3.1746 | 3.1964 | 3.165 | 3.1879 | 17199364.0 |
| 2009-01-26 09:35:00 | AAPL | Stock | 3.1871 | 3.205 | 3.1736 | 3.2043 | 16497964.0 |
| 2009-01-26 09:40:00 | AAPL | Stock | 3.2032 | 3.2129 | 3.1954 | 3.2082 | 13016976.0 |
| 2009-01-26 09:45:00 | AAPL | Stock | 3.2082 | 3.2275 | 3.2061 | 3.2179 | 23401840.0 |
| 2009-01-26 09:50:00 | AAPL | Stock | 3.2186 | 3.2232 | 3.2079 | 3.2118 | 10153612.0 |
| 2009-01-26 09:55:00 | AAPL | Stock | 3.2118 | 3.2146 | 3.2025 | 3.2064 | 9960244.0 |
| 2009-01-26 10:00:00 | AAPL | Stock | 3.2057 | 3.2386 | 3.2057 | 3.2343 | 21824992.0 |
| 2009-01-26 10:05:00 | AAPL | Stock | 3.235 | 3.2386 | 3.2279 | 3.2339 | 11240544.0 |
| 2009-01-26 10:10:00 | AAPL | Stock | 3.2343 | 3.2425 | 3.2214 | 3.2279 | 12465432.0 |
| 2009-01-26 10:15:00 | AAPL | Stock | 3.2282 | 3.2375 | 3.2261 | 3.2354 | 8680476.0 |
| 2009-01-26 10:20:00 | AAPL | Stock | 3.2357 | 3.2482 | 3.2339 | 3.2482 | 10291596.0 |
| 2009-01-26 10:25:00 | AAPL | Stock | 3.2482 | 3.2489 | 3.2404 | 3.2439 | 5682936.0 |
| 2009-01-26 10:30:00 | AAPL | Stock | 3.2443 | 3.2464 | 3.2364 | 3.24 | 8772176.0 |
| 2009-01-26 10:35:00 | AAPL | Stock | 3.24 | 3.24 | 3.2218 | 3.2229 | 7801500.0 |
| 2009-01-26 10:40:00 | AAPL | Stock | 3.2232 | 3.2268 | 3.2179 | 3.2182 | 7106512.0 |
| 2009-01-26 10:45:00 | AAPL | Stock | 3.2182 | 3.2304 | 3.2182 | 3.2264 | 5842760.0 |
| 2009-01-26 10:50:00 | AAPL | Stock | 3.2268 | 3.2268 | 3.2082 | 3.2107 | 9802492.0 |
| 2009-01-26 10:55:00 | AAPL | Stock | 3.2107 | 3.2189 | 3.2104 | 3.2164 | 7762412.0 |
| 2009-01-26 11:00:00 | AAPL | Stock | 3.2161 | 3.2268 | 3.2107 | 3.2114 | 7000420.0 |
| 2009-01-26 11:05:00 | AAPL | Stock | 3.2114 | 3.2143 | 3.2071 | 3.2125 | 6170640.0 |
| 2009-01-26 11:10:00 | AAPL | Stock | 3.2121 | 3.2157 | 3.2075 | 3.2086 | 4980864.0 |
| 2009-01-26 11:15:00 | AAPL | Stock | 3.2079 | 3.2161 | 3.2054 | 3.2061 | 6141184.0 |
| 2009-01-26 11:20:00 | AAPL | Stock | 3.2063 | 3.2121 | 3.2054 | 3.2089 | 4164356.0 |
| 2009-01-26 11:25:00 | AAPL | Stock | 3.2089 | 3.2196 | 3.2075 | 3.2186 | 5953388.0 |
| 2009-01-26 11:30:00 | AAPL | Stock | 3.2191 | 3.2229 | 3.2146 | 3.2146 | 4234468.0 |
| 2009-01-26 11:35:00 | AAPL | Stock | 3.2146 | 3.22 | 3.2118 | 3.2143 | 3764768.0 |
| 2009-01-26 11:40:00 | AAPL | Stock | 3.2136 | 3.2143 | 3.2089 | 3.2129 | 3716664.0 |
| 2009-01-26 11:45:00 | AAPL | Stock | 3.2125 | 3.215 | 3.2071 | 3.2075 | 5925920.0 |
| 2009-01-26 11:50:00 | AAPL | Stock | 3.2079 | 3.2107 | 3.205 | 3.2082 | 5009872.0 |
> showing 50 of 305,185 rows — these rows as CSV