PREVIEW / stock_5min / 2008-07-17
file: by_date/stock_5min/2008/2008-07-17.parquet size: 4.7 MB rows: 325,462 symbols: 3,337
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-07-17 05:00:00 | AAPL | Stock | 6.1786 | 6.1786 | 6.1786 | 6.1786 | 2800.0 |
| 2008-07-17 06:50:00 | AAPL | Stock | 6.1929 | 6.1929 | 6.1929 | 6.1929 | 2800.0 |
| 2008-07-17 07:00:00 | AAPL | Stock | 6.1964 | 6.2004 | 6.1964 | 6.2004 | 9800.0 |
| 2008-07-17 07:05:00 | AAPL | Stock | 6.2157 | 6.2232 | 6.2146 | 6.2232 | 141400.0 |
| 2008-07-17 07:10:00 | AAPL | Stock | 6.2296 | 6.2568 | 6.225 | 6.2304 | 161560.0 |
| 2008-07-17 07:15:00 | AAPL | Stock | 6.2321 | 6.2321 | 6.2261 | 6.2314 | 18200.0 |
| 2008-07-17 07:20:00 | AAPL | Stock | 6.2236 | 6.2236 | 6.2232 | 6.2232 | 60200.0 |
| 2008-07-17 07:30:00 | AAPL | Stock | 6.2282 | 6.2282 | 6.2214 | 6.2275 | 33656.0 |
| 2008-07-17 07:35:00 | AAPL | Stock | 6.2268 | 6.2268 | 6.2036 | 6.2036 | 60200.0 |
| 2008-07-17 07:40:00 | AAPL | Stock | 6.2107 | 6.2107 | 6.2107 | 6.2107 | 2800.0 |
| 2008-07-17 07:45:00 | AAPL | Stock | 6.2143 | 6.2143 | 6.2143 | 6.2143 | 2800.0 |
| 2008-07-17 07:50:00 | AAPL | Stock | 6.2089 | 6.2143 | 6.2089 | 6.2143 | 16800.0 |
| 2008-07-17 07:55:00 | AAPL | Stock | 6.2143 | 6.2143 | 6.2071 | 6.2136 | 71960.0 |
| 2008-07-17 08:00:00 | AAPL | Stock | 6.2125 | 6.2204 | 6.2036 | 6.2036 | 316596.0 |
| 2008-07-17 08:05:00 | AAPL | Stock | 6.2054 | 6.2161 | 6.2054 | 6.2157 | 188832.0 |
| 2008-07-17 08:10:00 | AAPL | Stock | 6.2143 | 6.2161 | 6.2107 | 6.2132 | 136304.0 |
| 2008-07-17 08:15:00 | AAPL | Stock | 6.2129 | 6.2139 | 6.1936 | 6.1943 | 298144.0 |
| 2008-07-17 08:20:00 | AAPL | Stock | 6.1964 | 6.1982 | 6.1864 | 6.1982 | 158564.0 |
| 2008-07-17 08:25:00 | AAPL | Stock | 6.1929 | 6.1943 | 6.1864 | 6.1864 | 145908.0 |
| 2008-07-17 08:30:00 | AAPL | Stock | 6.1921 | 6.2125 | 6.1875 | 6.2036 | 219800.0 |
| 2008-07-17 08:35:00 | AAPL | Stock | 6.1961 | 6.2025 | 6.1929 | 6.2021 | 112196.0 |
| 2008-07-17 08:40:00 | AAPL | Stock | 6.2025 | 6.2046 | 6.2007 | 6.2007 | 51184.0 |
| 2008-07-17 08:45:00 | AAPL | Stock | 6.2021 | 6.2061 | 6.2007 | 6.2061 | 59416.0 |
| 2008-07-17 08:50:00 | AAPL | Stock | 6.2061 | 6.2071 | 6.2036 | 6.2071 | 50316.0 |
| 2008-07-17 08:55:00 | AAPL | Stock | 6.2071 | 6.2071 | 6.2036 | 6.2064 | 67564.0 |
| 2008-07-17 09:00:00 | AAPL | Stock | 6.2071 | 6.2075 | 6.1943 | 6.1957 | 383936.0 |
| 2008-07-17 09:05:00 | AAPL | Stock | 6.1964 | 6.2107 | 6.1961 | 6.2107 | 306068.0 |
| 2008-07-17 09:10:00 | AAPL | Stock | 6.2104 | 6.215 | 6.2104 | 6.2143 | 482440.0 |
| 2008-07-17 09:15:00 | AAPL | Stock | 6.2125 | 6.2161 | 6.2054 | 6.2104 | 339416.0 |
| 2008-07-17 09:20:00 | AAPL | Stock | 6.2089 | 6.2182 | 6.2075 | 6.2182 | 196980.0 |
| 2008-07-17 09:25:00 | AAPL | Stock | 6.2204 | 6.2221 | 6.2107 | 6.2175 | 584500.0 |
| 2008-07-17 09:30:00 | AAPL | Stock | 6.2143 | 6.2332 | 6.1896 | 6.2225 | 20754524.0 |
| 2008-07-17 09:35:00 | AAPL | Stock | 6.2218 | 6.2493 | 6.2164 | 6.2361 | 18512704.0 |
| 2008-07-17 09:40:00 | AAPL | Stock | 6.235 | 6.2457 | 6.2264 | 6.2307 | 14567028.0 |
| 2008-07-17 09:45:00 | AAPL | Stock | 6.23 | 6.2318 | 6.1914 | 6.2075 | 16647176.0 |
| 2008-07-17 09:50:00 | AAPL | Stock | 6.2075 | 6.2293 | 6.2 | 6.2214 | 15275876.0 |
| 2008-07-17 09:55:00 | AAPL | Stock | 6.2214 | 6.2239 | 6.1946 | 6.1954 | 12516672.0 |
| 2008-07-17 10:00:00 | AAPL | Stock | 6.195 | 6.2021 | 6.1796 | 6.1971 | 10865092.0 |
| 2008-07-17 10:05:00 | AAPL | Stock | 6.1976 | 6.1982 | 6.1532 | 6.1746 | 15938944.0 |
| 2008-07-17 10:10:00 | AAPL | Stock | 6.1746 | 6.1857 | 6.1625 | 6.1839 | 13582912.0 |
| 2008-07-17 10:15:00 | AAPL | Stock | 6.1836 | 6.205 | 6.1836 | 6.1939 | 9968056.0 |
| 2008-07-17 10:20:00 | AAPL | Stock | 6.1946 | 6.2029 | 6.1664 | 6.1669 | 8642368.0 |
| 2008-07-17 10:25:00 | AAPL | Stock | 6.1682 | 6.1857 | 6.1607 | 6.1711 | 8370908.0 |
| 2008-07-17 10:30:00 | AAPL | Stock | 6.17 | 6.1786 | 6.1607 | 6.1739 | 6257328.0 |
| 2008-07-17 10:35:00 | AAPL | Stock | 6.1736 | 6.19 | 6.1607 | 6.1611 | 10297504.0 |
| 2008-07-17 10:40:00 | AAPL | Stock | 6.1611 | 6.1729 | 6.1511 | 6.1689 | 9622704.0 |
| 2008-07-17 10:45:00 | AAPL | Stock | 6.1689 | 6.1786 | 6.1589 | 6.1714 | 6373612.0 |
| 2008-07-17 10:50:00 | AAPL | Stock | 6.1714 | 6.1714 | 6.1521 | 6.1643 | 5031572.0 |
| 2008-07-17 10:55:00 | AAPL | Stock | 6.1636 | 6.1786 | 6.1589 | 6.1764 | 5960248.0 |
| 2008-07-17 11:00:00 | AAPL | Stock | 6.1775 | 6.1875 | 6.1529 | 6.1557 | 12420212.0 |
> showing 50 of 325,462 rows — these rows as CSV