PREVIEW / stock_5min / 2009-10-20
file: by_date/stock_5min/2009/2009-10-20.parquet size: 4.7 MB rows: 322,073 symbols: 3,394
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-10-20 04:00:00 | AAPL | Stock | 7.1429 | 7.1429 | 7.1429 | 7.1429 | 2800.0 |
| 2009-10-20 04:10:00 | AAPL | Stock | 7.1432 | 7.1432 | 7.1429 | 7.1429 | 18424.0 |
| 2009-10-20 04:15:00 | AAPL | Stock | 7.1718 | 7.1718 | 7.1357 | 7.1357 | 14420.0 |
| 2009-10-20 04:20:00 | AAPL | Stock | 7.1357 | 7.1357 | 7.1357 | 7.1357 | 11620.0 |
| 2009-10-20 04:30:00 | AAPL | Stock | 7.1464 | 7.1464 | 7.1429 | 7.1429 | 6944.0 |
| 2009-10-20 04:40:00 | AAPL | Stock | 7.1471 | 7.1521 | 7.1471 | 7.1471 | 8400.0 |
| 2009-10-20 04:45:00 | AAPL | Stock | 7.1471 | 7.1471 | 7.1429 | 7.1429 | 12208.0 |
| 2009-10-20 04:50:00 | AAPL | Stock | 7.12 | 7.12 | 7.12 | 7.12 | 2800.0 |
| 2009-10-20 04:55:00 | AAPL | Stock | 7.1293 | 7.1293 | 7.1293 | 7.1293 | 2800.0 |
| 2009-10-20 05:00:00 | AAPL | Stock | 7.1257 | 7.1257 | 7.125 | 7.125 | 28000.0 |
| 2009-10-20 05:05:00 | AAPL | Stock | 7.1357 | 7.15 | 7.1357 | 7.15 | 43792.0 |
| 2009-10-20 05:10:00 | AAPL | Stock | 7.1561 | 7.1561 | 7.15 | 7.15 | 25200.0 |
| 2009-10-20 05:15:00 | AAPL | Stock | 7.1579 | 7.1632 | 7.1575 | 7.1632 | 69244.0 |
| 2009-10-20 05:30:00 | AAPL | Stock | 7.1607 | 7.1664 | 7.1607 | 7.1664 | 16800.0 |
| 2009-10-20 05:40:00 | AAPL | Stock | 7.1664 | 7.1664 | 7.1607 | 7.1607 | 10108.0 |
| 2009-10-20 05:50:00 | AAPL | Stock | 7.1668 | 7.1689 | 7.1668 | 7.1689 | 8400.0 |
| 2009-10-20 05:55:00 | AAPL | Stock | 7.1689 | 7.1786 | 7.1689 | 7.1786 | 32200.0 |
| 2009-10-20 06:05:00 | AAPL | Stock | 7.1796 | 7.1796 | 7.1796 | 7.1796 | 2800.0 |
| 2009-10-20 06:10:00 | AAPL | Stock | 7.1796 | 7.1804 | 7.1786 | 7.1786 | 28000.0 |
| 2009-10-20 06:15:00 | AAPL | Stock | 7.1821 | 7.1821 | 7.1786 | 7.1786 | 167104.0 |
| 2009-10-20 06:20:00 | AAPL | Stock | 7.1857 | 7.1857 | 7.1857 | 7.1857 | 14000.0 |
| 2009-10-20 06:30:00 | AAPL | Stock | 7.175 | 7.175 | 7.175 | 7.175 | 3696.0 |
| 2009-10-20 06:35:00 | AAPL | Stock | 7.1786 | 7.1786 | 7.1786 | 7.1786 | 8400.0 |
| 2009-10-20 06:40:00 | AAPL | Stock | 7.1821 | 7.1821 | 7.1786 | 7.1786 | 50400.0 |
| 2009-10-20 06:45:00 | AAPL | Stock | 7.1893 | 7.1964 | 7.1893 | 7.1964 | 193200.0 |
| 2009-10-20 06:50:00 | AAPL | Stock | 7.1929 | 7.1929 | 7.1929 | 7.1929 | 16800.0 |
| 2009-10-20 06:55:00 | AAPL | Stock | 7.1929 | 7.2 | 7.1929 | 7.2 | 86828.0 |
| 2009-10-20 07:00:00 | AAPL | Stock | 7.1929 | 7.2143 | 7.1929 | 7.2018 | 678636.0 |
| 2009-10-20 07:05:00 | AAPL | Stock | 7.2036 | 7.2143 | 7.1964 | 7.2139 | 360948.0 |
| 2009-10-20 07:10:00 | AAPL | Stock | 7.2143 | 7.2214 | 7.2107 | 7.2182 | 193340.0 |
| 2009-10-20 07:15:00 | AAPL | Stock | 7.2214 | 7.2214 | 7.2143 | 7.2179 | 317464.0 |
| 2009-10-20 07:20:00 | AAPL | Stock | 7.2196 | 7.2286 | 7.2196 | 7.225 | 72044.0 |
| 2009-10-20 07:25:00 | AAPL | Stock | 7.2282 | 7.2304 | 7.2143 | 7.2279 | 191744.0 |
| 2009-10-20 07:30:00 | AAPL | Stock | 7.2207 | 7.225 | 7.2143 | 7.2143 | 96572.0 |
| 2009-10-20 07:35:00 | AAPL | Stock | 7.2161 | 7.2214 | 7.2143 | 7.2146 | 243488.0 |
| 2009-10-20 07:40:00 | AAPL | Stock | 7.2146 | 7.2214 | 7.2054 | 7.2054 | 317800.0 |
| 2009-10-20 07:45:00 | AAPL | Stock | 7.2054 | 7.2136 | 7.2036 | 7.2114 | 135324.0 |
| 2009-10-20 07:50:00 | AAPL | Stock | 7.2046 | 7.2214 | 7.2046 | 7.2214 | 562324.0 |
| 2009-10-20 07:55:00 | AAPL | Stock | 7.2186 | 7.2496 | 7.2161 | 7.2393 | 1009624.0 |
| 2009-10-20 08:00:00 | AAPL | Stock | 7.2107 | 7.2582 | 7.2054 | 7.245 | 6462456.0 |
| 2009-10-20 08:05:00 | AAPL | Stock | 7.2446 | 7.2461 | 7.2321 | 7.2354 | 2304428.0 |
| 2009-10-20 08:10:00 | AAPL | Stock | 7.2336 | 7.25 | 7.2086 | 7.2193 | 1999060.0 |
| 2009-10-20 08:15:00 | AAPL | Stock | 7.2193 | 7.2321 | 7.2189 | 7.2286 | 1099196.0 |
| 2009-10-20 08:20:00 | AAPL | Stock | 7.2289 | 7.2321 | 7.2179 | 7.225 | 1133020.0 |
| 2009-10-20 08:25:00 | AAPL | Stock | 7.2246 | 7.2318 | 7.2229 | 7.2232 | 869540.0 |
| 2009-10-20 08:30:00 | AAPL | Stock | 7.2232 | 7.2286 | 7.215 | 7.2218 | 1417304.0 |
| 2009-10-20 08:35:00 | AAPL | Stock | 7.2218 | 7.2296 | 7.2204 | 7.2282 | 2624272.0 |
| 2009-10-20 08:40:00 | AAPL | Stock | 7.2279 | 7.2304 | 7.2214 | 7.2246 | 778344.0 |
| 2009-10-20 08:45:00 | AAPL | Stock | 7.2237 | 7.2282 | 7.2075 | 7.2107 | 1654520.0 |
| 2009-10-20 08:50:00 | AAPL | Stock | 7.2121 | 7.2175 | 7.2071 | 7.2089 | 1450232.0 |
> showing 50 of 322,073 rows — these rows as CSV