PREVIEW / stock_5min / 2009-01-22
file: by_date/stock_5min/2009/2009-01-22.parquet size: 4.3 MB rows: 297,082 symbols: 3,281
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-22 04:40:00 | AAPL | Stock | 3.2136 | 3.2136 | 3.2136 | 3.2136 | 4200.0 |
| 2009-01-22 05:15:00 | AAPL | Stock | 3.2129 | 3.2129 | 3.2129 | 3.2129 | 6888.0 |
| 2009-01-22 05:30:00 | AAPL | Stock | 3.2354 | 3.2354 | 3.2354 | 3.2354 | 2800.0 |
| 2009-01-22 06:00:00 | AAPL | Stock | 3.2125 | 3.2125 | 3.2125 | 3.2125 | 8400.0 |
| 2009-01-22 06:45:00 | AAPL | Stock | 3.2193 | 3.2193 | 3.2193 | 3.2193 | 2800.0 |
| 2009-01-22 06:50:00 | AAPL | Stock | 3.1804 | 3.1804 | 3.1804 | 3.1804 | 4620.0 |
| 2009-01-22 07:00:00 | AAPL | Stock | 3.1789 | 3.2125 | 3.1786 | 3.2036 | 133560.0 |
| 2009-01-22 07:05:00 | AAPL | Stock | 3.2036 | 3.2071 | 3.2025 | 3.2071 | 46312.0 |
| 2009-01-22 07:10:00 | AAPL | Stock | 3.2107 | 3.225 | 3.2107 | 3.2225 | 304976.0 |
| 2009-01-22 07:15:00 | AAPL | Stock | 3.2193 | 3.2286 | 3.2189 | 3.2232 | 267708.0 |
| 2009-01-22 07:20:00 | AAPL | Stock | 3.2264 | 3.2264 | 3.2143 | 3.2161 | 170240.0 |
| 2009-01-22 07:25:00 | AAPL | Stock | 3.2186 | 3.2186 | 3.1968 | 3.2054 | 453404.0 |
| 2009-01-22 07:30:00 | AAPL | Stock | 3.2004 | 3.2107 | 3.1939 | 3.2104 | 564368.0 |
| 2009-01-22 07:35:00 | AAPL | Stock | 3.2096 | 3.2096 | 3.2011 | 3.2093 | 59220.0 |
| 2009-01-22 07:40:00 | AAPL | Stock | 3.2 | 3.2086 | 3.1932 | 3.1932 | 198100.0 |
| 2009-01-22 07:45:00 | AAPL | Stock | 3.1932 | 3.1957 | 3.1857 | 3.1957 | 198408.0 |
| 2009-01-22 07:50:00 | AAPL | Stock | 3.1932 | 3.1932 | 3.1911 | 3.1929 | 56000.0 |
| 2009-01-22 07:55:00 | AAPL | Stock | 3.1911 | 3.1964 | 3.1893 | 3.1964 | 144200.0 |
| 2009-01-22 08:00:00 | AAPL | Stock | 3.1964 | 3.2054 | 3.1786 | 3.1982 | 2812880.0 |
| 2009-01-22 08:05:00 | AAPL | Stock | 3.1982 | 3.2089 | 3.1946 | 3.2003 | 786268.0 |
| 2009-01-22 08:10:00 | AAPL | Stock | 3.2036 | 3.2196 | 3.2036 | 3.2104 | 1441384.0 |
| 2009-01-22 08:15:00 | AAPL | Stock | 3.2089 | 3.2268 | 3.2086 | 3.2268 | 998900.0 |
| 2009-01-22 08:20:00 | AAPL | Stock | 3.2264 | 3.2339 | 3.2232 | 3.2339 | 2128700.0 |
| 2009-01-22 08:25:00 | AAPL | Stock | 3.2332 | 3.2361 | 3.2239 | 3.2254 | 2800000.0 |
| 2009-01-22 08:30:00 | AAPL | Stock | 3.225 | 3.225 | 3.2064 | 3.2107 | 1826356.0 |
| 2009-01-22 08:35:00 | AAPL | Stock | 3.2096 | 3.2275 | 3.2075 | 3.2139 | 2377648.0 |
| 2009-01-22 08:40:00 | AAPL | Stock | 3.2139 | 3.2207 | 3.2125 | 3.2129 | 1389080.0 |
| 2009-01-22 08:45:00 | AAPL | Stock | 3.2125 | 3.2143 | 3.2036 | 3.2057 | 4409132.0 |
| 2009-01-22 08:50:00 | AAPL | Stock | 3.2036 | 3.2143 | 3.1911 | 3.1911 | 1887424.0 |
| 2009-01-22 08:55:00 | AAPL | Stock | 3.195 | 3.195 | 3.1736 | 3.1821 | 3921848.0 |
| 2009-01-22 09:00:00 | AAPL | Stock | 3.1821 | 3.1821 | 3.1489 | 3.1675 | 8603196.0 |
| 2009-01-22 09:05:00 | AAPL | Stock | 3.1668 | 3.1711 | 3.1532 | 3.1686 | 5616828.0 |
| 2009-01-22 09:10:00 | AAPL | Stock | 3.1707 | 3.1711 | 3.1607 | 3.1668 | 1858500.0 |
| 2009-01-22 09:15:00 | AAPL | Stock | 3.1657 | 3.1907 | 3.1657 | 3.185 | 1792812.0 |
| 2009-01-22 09:20:00 | AAPL | Stock | 3.185 | 3.1868 | 3.1571 | 3.1636 | 2194472.0 |
| 2009-01-22 09:25:00 | AAPL | Stock | 3.1639 | 3.1721 | 3.1357 | 3.1471 | 9386552.0 |
| 2009-01-22 09:30:00 | AAPL | Stock | 3.1468 | 3.1582 | 3.1089 | 3.1189 | 63442036.0 |
| 2009-01-22 09:35:00 | AAPL | Stock | 3.1189 | 3.1221 | 3.065 | 3.0825 | 68321680.0 |
| 2009-01-22 09:40:00 | AAPL | Stock | 3.0832 | 3.1318 | 3.0671 | 3.1236 | 61815628.0 |
| 2009-01-22 09:45:00 | AAPL | Stock | 3.1239 | 3.1536 | 3.0857 | 3.1364 | 56665084.0 |
| 2009-01-22 09:50:00 | AAPL | Stock | 3.1364 | 3.1875 | 3.1332 | 3.1761 | 54419428.0 |
| 2009-01-22 09:55:00 | AAPL | Stock | 3.1764 | 3.1907 | 3.1521 | 3.1821 | 38340652.0 |
| 2009-01-22 10:00:00 | AAPL | Stock | 3.1818 | 3.2089 | 3.1746 | 3.1764 | 44480912.0 |
| 2009-01-22 10:05:00 | AAPL | Stock | 3.1764 | 3.1832 | 3.1561 | 3.1736 | 25742276.0 |
| 2009-01-22 10:10:00 | AAPL | Stock | 3.1739 | 3.195 | 3.1632 | 3.1682 | 23921268.0 |
| 2009-01-22 10:15:00 | AAPL | Stock | 3.1686 | 3.1857 | 3.1579 | 3.185 | 23935632.0 |
| 2009-01-22 10:20:00 | AAPL | Stock | 3.185 | 3.1875 | 3.1543 | 3.1557 | 20841520.0 |
| 2009-01-22 10:25:00 | AAPL | Stock | 3.1561 | 3.1721 | 3.1489 | 3.1686 | 13917316.0 |
| 2009-01-22 10:30:00 | AAPL | Stock | 3.1689 | 3.1689 | 3.1225 | 3.1226 | 30263856.0 |
| 2009-01-22 10:35:00 | AAPL | Stock | 3.1236 | 3.1382 | 3.1225 | 3.1254 | 18169340.0 |
> showing 50 of 297,082 rows — these rows as CSV