PREVIEW / stock_5min / 2008-11-18
file: by_date/stock_5min/2008/2008-11-18.parquet size: 4.4 MB rows: 314,474 symbols: 3,329
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-11-18 06:35:00 | AAPL | Stock | 3.11 | 3.11 | 3.11 | 3.11 | 5600.0 |
| 2008-11-18 06:55:00 | AAPL | Stock | 3.0925 | 3.0925 | 3.0925 | 3.0925 | 2800.0 |
| 2008-11-18 07:15:00 | AAPL | Stock | 3.1286 | 3.1289 | 3.1286 | 3.1286 | 16800.0 |
| 2008-11-18 07:25:00 | AAPL | Stock | 3.1271 | 3.1271 | 3.1271 | 3.1271 | 2800.0 |
| 2008-11-18 07:30:00 | AAPL | Stock | 3.1264 | 3.1339 | 3.1264 | 3.1339 | 19600.0 |
| 2008-11-18 07:35:00 | AAPL | Stock | 3.1339 | 3.1368 | 3.1339 | 3.1357 | 50400.0 |
| 2008-11-18 07:40:00 | AAPL | Stock | 3.1357 | 3.1357 | 3.1339 | 3.1339 | 10080.0 |
| 2008-11-18 07:45:00 | AAPL | Stock | 3.1339 | 3.1346 | 3.1339 | 3.1339 | 73920.0 |
| 2008-11-18 07:50:00 | AAPL | Stock | 3.1339 | 3.1339 | 3.1339 | 3.1339 | 10864.0 |
| 2008-11-18 07:55:00 | AAPL | Stock | 3.1364 | 3.1364 | 3.1364 | 3.1364 | 5600.0 |
| 2008-11-18 08:00:00 | AAPL | Stock | 3.1357 | 3.1639 | 3.1339 | 3.1596 | 327264.0 |
| 2008-11-18 08:05:00 | AAPL | Stock | 3.1689 | 3.2036 | 3.1571 | 3.1893 | 713860.0 |
| 2008-11-18 08:10:00 | AAPL | Stock | 3.1964 | 3.2214 | 3.1911 | 3.2143 | 815304.0 |
| 2008-11-18 08:15:00 | AAPL | Stock | 3.2143 | 3.2407 | 3.2071 | 3.2346 | 771428.0 |
| 2008-11-18 08:20:00 | AAPL | Stock | 3.2254 | 3.2346 | 3.2221 | 3.2229 | 269164.0 |
| 2008-11-18 08:25:00 | AAPL | Stock | 3.2229 | 3.2314 | 3.215 | 3.2279 | 247240.0 |
| 2008-11-18 08:30:00 | AAPL | Stock | 3.2268 | 3.2357 | 3.2143 | 3.2279 | 686280.0 |
| 2008-11-18 08:35:00 | AAPL | Stock | 3.225 | 3.25 | 3.225 | 3.2464 | 690088.0 |
| 2008-11-18 08:40:00 | AAPL | Stock | 3.2464 | 3.2536 | 3.2361 | 3.2511 | 910224.0 |
| 2008-11-18 08:45:00 | AAPL | Stock | 3.2518 | 3.2518 | 3.2368 | 3.2368 | 258916.0 |
| 2008-11-18 08:50:00 | AAPL | Stock | 3.2339 | 3.2429 | 3.2332 | 3.2364 | 262696.0 |
| 2008-11-18 08:55:00 | AAPL | Stock | 3.235 | 3.2357 | 3.2204 | 3.2204 | 598192.0 |
| 2008-11-18 09:00:00 | AAPL | Stock | 3.2239 | 3.2239 | 3.2089 | 3.2143 | 557564.0 |
| 2008-11-18 09:05:00 | AAPL | Stock | 3.2143 | 3.2193 | 3.2089 | 3.2125 | 376180.0 |
| 2008-11-18 09:10:00 | AAPL | Stock | 3.2125 | 3.2146 | 3.2086 | 3.2125 | 594328.0 |
| 2008-11-18 09:15:00 | AAPL | Stock | 3.2114 | 3.2182 | 3.2093 | 3.2143 | 347872.0 |
| 2008-11-18 09:20:00 | AAPL | Stock | 3.2139 | 3.2182 | 3.2132 | 3.2143 | 191800.0 |
| 2008-11-18 09:25:00 | AAPL | Stock | 3.2136 | 3.215 | 3.1993 | 3.2018 | 932344.0 |
| 2008-11-18 09:30:00 | AAPL | Stock | 3.2043 | 3.2321 | 3.1643 | 3.2214 | 33761336.0 |
| 2008-11-18 09:35:00 | AAPL | Stock | 3.2214 | 3.2496 | 3.2196 | 3.2339 | 26109132.0 |
| 2008-11-18 09:40:00 | AAPL | Stock | 3.2343 | 3.2407 | 3.2071 | 3.2104 | 20066340.0 |
| 2008-11-18 09:45:00 | AAPL | Stock | 3.2093 | 3.2225 | 3.2018 | 3.2139 | 21121268.0 |
| 2008-11-18 09:50:00 | AAPL | Stock | 3.2136 | 3.2146 | 3.1825 | 3.1871 | 21288792.0 |
| 2008-11-18 09:55:00 | AAPL | Stock | 3.1868 | 3.1871 | 3.1643 | 3.1775 | 25144056.0 |
| 2008-11-18 10:00:00 | AAPL | Stock | 3.1779 | 3.1839 | 3.1579 | 3.1607 | 24742368.0 |
| 2008-11-18 10:05:00 | AAPL | Stock | 3.1632 | 3.18 | 3.1632 | 3.1774 | 20518708.0 |
| 2008-11-18 10:10:00 | AAPL | Stock | 3.1774 | 3.2018 | 3.1732 | 3.1918 | 20309940.0 |
| 2008-11-18 10:15:00 | AAPL | Stock | 3.1911 | 3.2018 | 3.1893 | 3.2011 | 17715544.0 |
| 2008-11-18 10:20:00 | AAPL | Stock | 3.2018 | 3.2125 | 3.1914 | 3.1954 | 20769588.0 |
| 2008-11-18 10:25:00 | AAPL | Stock | 3.1946 | 3.2275 | 3.1936 | 3.2274 | 19148388.0 |
| 2008-11-18 10:30:00 | AAPL | Stock | 3.2268 | 3.2311 | 3.2143 | 3.2161 | 22659280.0 |
| 2008-11-18 10:35:00 | AAPL | Stock | 3.2171 | 3.2218 | 3.2075 | 3.2157 | 12513004.0 |
| 2008-11-18 10:40:00 | AAPL | Stock | 3.2164 | 3.2243 | 3.2046 | 3.2089 | 15200052.0 |
| 2008-11-18 10:45:00 | AAPL | Stock | 3.2089 | 3.2214 | 3.2054 | 3.2193 | 11801188.0 |
| 2008-11-18 10:50:00 | AAPL | Stock | 3.2182 | 3.2189 | 3.2054 | 3.2107 | 11101888.0 |
| 2008-11-18 10:55:00 | AAPL | Stock | 3.2107 | 3.2168 | 3.2011 | 3.2104 | 10718932.0 |
| 2008-11-18 11:00:00 | AAPL | Stock | 3.2104 | 3.2104 | 3.1857 | 3.1925 | 13233472.0 |
| 2008-11-18 11:05:00 | AAPL | Stock | 3.1929 | 3.2036 | 3.1925 | 3.1992 | 13127548.0 |
| 2008-11-18 11:10:00 | AAPL | Stock | 3.1989 | 3.2 | 3.185 | 3.1925 | 8490384.0 |
| 2008-11-18 11:15:00 | AAPL | Stock | 3.1918 | 3.1989 | 3.1864 | 3.1904 | 7603708.0 |
> showing 50 of 314,474 rows — these rows as CSV