PREVIEW / stock_1min / 2009-11-30
file: by_date/stock_1min/2009/2009-11-30.parquet size: 13.3 MB rows: 1,013,964 symbols: 2,794
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-11-30 05:01:00 | AAPL | Stock | 7.1786 | 7.1786 | 7.1786 | 7.1786 | 24220.0 |
| 2009-11-30 05:03:00 | AAPL | Stock | 7.1786 | 7.1786 | 7.1786 | 7.1786 | 2800.0 |
| 2009-11-30 06:05:00 | AAPL | Stock | 7.1786 | 7.1786 | 7.1786 | 7.1786 | 2800.0 |
| 2009-11-30 06:41:00 | AAPL | Stock | 7.1786 | 7.1786 | 7.1786 | 7.1786 | 2800.0 |
| 2009-11-30 06:58:00 | AAPL | Stock | 7.1782 | 7.1782 | 7.1782 | 7.1782 | 28000.0 |
| 2009-11-30 07:04:00 | AAPL | Stock | 7.1643 | 7.1643 | 7.1639 | 7.1639 | 61600.0 |
| 2009-11-30 07:05:00 | AAPL | Stock | 7.1639 | 7.1639 | 7.1639 | 7.1639 | 30800.0 |
| 2009-11-30 07:14:00 | AAPL | Stock | 7.1639 | 7.1639 | 7.1639 | 7.1639 | 11200.0 |
| 2009-11-30 07:16:00 | AAPL | Stock | 7.1643 | 7.1643 | 7.1643 | 7.1643 | 2800.0 |
| 2009-11-30 07:17:00 | AAPL | Stock | 7.1775 | 7.1821 | 7.1775 | 7.1821 | 42980.0 |
| 2009-11-30 07:26:00 | AAPL | Stock | 7.1732 | 7.1786 | 7.1732 | 7.1786 | 5600.0 |
| 2009-11-30 07:29:00 | AAPL | Stock | 7.1821 | 7.1875 | 7.1821 | 7.1875 | 25200.0 |
| 2009-11-30 07:36:00 | AAPL | Stock | 7.1893 | 7.1921 | 7.1893 | 7.1921 | 24640.0 |
| 2009-11-30 07:38:00 | AAPL | Stock | 7.1893 | 7.1893 | 7.1857 | 7.1857 | 30800.0 |
| 2009-11-30 07:39:00 | AAPL | Stock | 7.1889 | 7.1911 | 7.1889 | 7.1911 | 19600.0 |
| 2009-11-30 07:40:00 | AAPL | Stock | 7.1789 | 7.1789 | 7.1789 | 7.1789 | 14000.0 |
| 2009-11-30 07:47:00 | AAPL | Stock | 7.1946 | 7.1982 | 7.1946 | 7.1982 | 28000.0 |
| 2009-11-30 07:49:00 | AAPL | Stock | 7.2054 | 7.2054 | 7.2054 | 7.2054 | 11060.0 |
| 2009-11-30 07:59:00 | AAPL | Stock | 7.2054 | 7.2054 | 7.2054 | 7.2054 | 2800.0 |
| 2009-11-30 08:00:00 | AAPL | Stock | 7.2039 | 7.2143 | 7.2039 | 7.2143 | 108108.0 |
| 2009-11-30 08:01:00 | AAPL | Stock | 7.2164 | 7.2232 | 7.215 | 7.215 | 19600.0 |
| 2009-11-30 08:02:00 | AAPL | Stock | 7.2196 | 7.2357 | 7.2195 | 7.2357 | 105980.0 |
| 2009-11-30 08:03:00 | AAPL | Stock | 7.2371 | 7.2393 | 7.2286 | 7.2286 | 65800.0 |
| 2009-11-30 08:04:00 | AAPL | Stock | 7.2321 | 7.2321 | 7.2254 | 7.2254 | 123872.0 |
| 2009-11-30 08:05:00 | AAPL | Stock | 7.225 | 7.2254 | 7.225 | 7.2254 | 16800.0 |
| 2009-11-30 08:06:00 | AAPL | Stock | 7.2268 | 7.2268 | 7.2268 | 7.2268 | 25984.0 |
| 2009-11-30 08:07:00 | AAPL | Stock | 7.2257 | 7.2286 | 7.2214 | 7.2243 | 73052.0 |
| 2009-11-30 08:08:00 | AAPL | Stock | 7.223 | 7.223 | 7.2207 | 7.2207 | 16800.0 |
| 2009-11-30 08:09:00 | AAPL | Stock | 7.2204 | 7.2211 | 7.2196 | 7.2211 | 18200.0 |
| 2009-11-30 08:10:00 | AAPL | Stock | 7.2179 | 7.2196 | 7.2157 | 7.2179 | 30800.0 |
| 2009-11-30 08:11:00 | AAPL | Stock | 7.2179 | 7.2179 | 7.2168 | 7.2179 | 19600.0 |
| 2009-11-30 08:12:00 | AAPL | Stock | 7.2175 | 7.2193 | 7.2175 | 7.2193 | 28000.0 |
| 2009-11-30 08:13:00 | AAPL | Stock | 7.2186 | 7.2232 | 7.2186 | 7.2232 | 25984.0 |
| 2009-11-30 08:14:00 | AAPL | Stock | 7.2175 | 7.2175 | 7.2161 | 7.2161 | 12600.0 |
| 2009-11-30 08:16:00 | AAPL | Stock | 7.2179 | 7.2179 | 7.2179 | 7.2179 | 2800.0 |
| 2009-11-30 08:17:00 | AAPL | Stock | 7.2179 | 7.2179 | 7.2161 | 7.2179 | 18900.0 |
| 2009-11-30 08:18:00 | AAPL | Stock | 7.2157 | 7.2161 | 7.2139 | 7.2139 | 40096.0 |
| 2009-11-30 08:19:00 | AAPL | Stock | 7.2143 | 7.2157 | 7.2143 | 7.2157 | 14084.0 |
| 2009-11-30 08:21:00 | AAPL | Stock | 7.2139 | 7.2196 | 7.2139 | 7.2179 | 228424.0 |
| 2009-11-30 08:22:00 | AAPL | Stock | 7.2221 | 7.2225 | 7.2179 | 7.2179 | 158424.0 |
| 2009-11-30 08:23:00 | AAPL | Stock | 7.2214 | 7.225 | 7.2214 | 7.225 | 52556.0 |
| 2009-11-30 08:24:00 | AAPL | Stock | 7.225 | 7.2286 | 7.225 | 7.225 | 30240.0 |
| 2009-11-30 08:25:00 | AAPL | Stock | 7.225 | 7.2279 | 7.225 | 7.2279 | 54600.0 |
| 2009-11-30 08:26:00 | AAPL | Stock | 7.2275 | 7.2275 | 7.2275 | 7.2275 | 14000.0 |
| 2009-11-30 08:27:00 | AAPL | Stock | 7.225 | 7.2275 | 7.225 | 7.2275 | 16016.0 |
| 2009-11-30 08:28:00 | AAPL | Stock | 7.225 | 7.2286 | 7.225 | 7.2286 | 63084.0 |
| 2009-11-30 08:29:00 | AAPL | Stock | 7.2286 | 7.2286 | 7.2286 | 7.2286 | 8960.0 |
| 2009-11-30 08:30:00 | AAPL | Stock | 7.2268 | 7.2268 | 7.2268 | 7.2268 | 6160.0 |
| 2009-11-30 08:32:00 | AAPL | Stock | 7.225 | 7.225 | 7.2246 | 7.2246 | 5600.0 |
| 2009-11-30 08:34:00 | AAPL | Stock | 7.2225 | 7.2225 | 7.2218 | 7.2218 | 39200.0 |
> showing 50 of 1,013,964 rows — these rows as CSV