PREVIEW / stock_5min / 2010-02-19
file: by_date/stock_5min/2010/2010-02-19.parquet size: 4.6 MB rows: 317,801 symbols: 3,443
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 |
|---|---|---|---|---|---|---|---|
| 2010-02-19 04:30:00 | AAPL | Stock | 7.1821 | 7.1821 | 7.1821 | 7.1821 | 5600.0 |
| 2010-02-19 06:40:00 | AAPL | Stock | 7.1921 | 7.1964 | 7.1921 | 7.1964 | 15960.0 |
| 2010-02-19 07:00:00 | AAPL | Stock | 7.1946 | 7.1946 | 7.1946 | 7.1946 | 5600.0 |
| 2010-02-19 07:05:00 | AAPL | Stock | 7.21 | 7.2143 | 7.21 | 7.2143 | 15372.0 |
| 2010-02-19 07:10:00 | AAPL | Stock | 7.2225 | 7.2232 | 7.2221 | 7.2232 | 25200.0 |
| 2010-02-19 07:15:00 | AAPL | Stock | 7.2232 | 7.2232 | 7.2232 | 7.2232 | 16100.0 |
| 2010-02-19 07:20:00 | AAPL | Stock | 7.2214 | 7.2214 | 7.2214 | 7.2214 | 2800.0 |
| 2010-02-19 07:25:00 | AAPL | Stock | 7.2114 | 7.2114 | 7.2071 | 7.2071 | 5600.0 |
| 2010-02-19 07:30:00 | AAPL | Stock | 7.2136 | 7.2136 | 7.2136 | 7.2136 | 5600.0 |
| 2010-02-19 07:35:00 | AAPL | Stock | 7.2136 | 7.2136 | 7.2136 | 7.2136 | 2800.0 |
| 2010-02-19 07:45:00 | AAPL | Stock | 7.2186 | 7.2186 | 7.2186 | 7.2186 | 5600.0 |
| 2010-02-19 07:55:00 | AAPL | Stock | 7.2232 | 7.2232 | 7.2232 | 7.2232 | 14000.0 |
| 2010-02-19 08:00:00 | AAPL | Stock | 7.22 | 7.22 | 7.2054 | 7.2089 | 346584.0 |
| 2010-02-19 08:05:00 | AAPL | Stock | 7.2089 | 7.2089 | 7.1893 | 7.1921 | 150752.0 |
| 2010-02-19 08:10:00 | AAPL | Stock | 7.1875 | 7.1929 | 7.1875 | 7.1929 | 22400.0 |
| 2010-02-19 08:15:00 | AAPL | Stock | 7.1946 | 7.2018 | 7.1946 | 7.1964 | 70000.0 |
| 2010-02-19 08:20:00 | AAPL | Stock | 7.2046 | 7.205 | 7.2043 | 7.2043 | 14000.0 |
| 2010-02-19 08:25:00 | AAPL | Stock | 7.2043 | 7.205 | 7.2043 | 7.205 | 35784.0 |
| 2010-02-19 08:30:00 | AAPL | Stock | 7.205 | 7.2161 | 7.2036 | 7.21 | 473256.0 |
| 2010-02-19 08:35:00 | AAPL | Stock | 7.2146 | 7.2196 | 7.2054 | 7.2061 | 311864.0 |
| 2010-02-19 08:40:00 | AAPL | Stock | 7.2082 | 7.2143 | 7.2064 | 7.2136 | 141008.0 |
| 2010-02-19 08:45:00 | AAPL | Stock | 7.2107 | 7.2389 | 7.2107 | 7.2357 | 739508.0 |
| 2010-02-19 08:50:00 | AAPL | Stock | 7.2357 | 7.2364 | 7.2254 | 7.2286 | 315028.0 |
| 2010-02-19 08:55:00 | AAPL | Stock | 7.2286 | 7.2411 | 7.2286 | 7.2325 | 458164.0 |
| 2010-02-19 09:00:00 | AAPL | Stock | 7.2361 | 7.2364 | 7.2271 | 7.2271 | 121744.0 |
| 2010-02-19 09:05:00 | AAPL | Stock | 7.2279 | 7.2282 | 7.2143 | 7.2214 | 141680.0 |
| 2010-02-19 09:10:00 | AAPL | Stock | 7.2214 | 7.2282 | 7.2214 | 7.2221 | 109816.0 |
| 2010-02-19 09:15:00 | AAPL | Stock | 7.2204 | 7.2246 | 7.2196 | 7.2211 | 64400.0 |
| 2010-02-19 09:20:00 | AAPL | Stock | 7.2221 | 7.2221 | 7.2221 | 7.2221 | 2800.0 |
| 2010-02-19 09:25:00 | AAPL | Stock | 7.2214 | 7.2225 | 7.2093 | 7.21 | 217280.0 |
| 2010-02-19 09:30:00 | AAPL | Stock | 7.2111 | 7.2279 | 7.2032 | 7.2182 | 11903192.0 |
| 2010-02-19 09:35:00 | AAPL | Stock | 7.2189 | 7.23 | 7.2014 | 7.2296 | 11513992.0 |
| 2010-02-19 09:40:00 | AAPL | Stock | 7.2282 | 7.2296 | 7.2054 | 7.2054 | 9513420.0 |
| 2010-02-19 09:45:00 | AAPL | Stock | 7.205 | 7.2161 | 7.2036 | 7.2104 | 5799416.0 |
| 2010-02-19 09:50:00 | AAPL | Stock | 7.2114 | 7.2164 | 7.2036 | 7.2107 | 6238792.0 |
| 2010-02-19 09:55:00 | AAPL | Stock | 7.2107 | 7.2136 | 7.1993 | 7.1993 | 7236656.0 |
| 2010-02-19 10:00:00 | AAPL | Stock | 7.1993 | 7.205 | 7.1893 | 7.1911 | 9575608.0 |
| 2010-02-19 10:05:00 | AAPL | Stock | 7.1911 | 7.2064 | 7.1896 | 7.202 | 6823404.0 |
| 2010-02-19 10:10:00 | AAPL | Stock | 7.2014 | 7.2018 | 7.1825 | 7.185 | 9090732.0 |
| 2010-02-19 10:15:00 | AAPL | Stock | 7.1857 | 7.2064 | 7.185 | 7.2039 | 4991952.0 |
| 2010-02-19 10:20:00 | AAPL | Stock | 7.2039 | 7.2211 | 7.2014 | 7.2146 | 9389352.0 |
| 2010-02-19 10:25:00 | AAPL | Stock | 7.215 | 7.2239 | 7.21 | 7.2121 | 7820176.0 |
| 2010-02-19 10:30:00 | AAPL | Stock | 7.2125 | 7.2168 | 7.2046 | 7.2082 | 4079908.0 |
| 2010-02-19 10:35:00 | AAPL | Stock | 7.2083 | 7.2143 | 7.2046 | 7.21 | 3370948.0 |
| 2010-02-19 10:40:00 | AAPL | Stock | 7.2096 | 7.2189 | 7.2096 | 7.2137 | 4738328.0 |
| 2010-02-19 10:45:00 | AAPL | Stock | 7.2136 | 7.2232 | 7.2136 | 7.2154 | 4307828.0 |
| 2010-02-19 10:50:00 | AAPL | Stock | 7.2157 | 7.2175 | 7.2093 | 7.2093 | 2630544.0 |
| 2010-02-19 10:55:00 | AAPL | Stock | 7.2125 | 7.2143 | 7.2071 | 7.2086 | 2216228.0 |
| 2010-02-19 11:00:00 | AAPL | Stock | 7.2089 | 7.2186 | 7.2086 | 7.215 | 4022144.0 |
| 2010-02-19 11:05:00 | AAPL | Stock | 7.215 | 7.2204 | 7.2114 | 7.2154 | 3418716.0 |
> showing 50 of 317,801 rows — these rows as CSV