PREVIEW / stock_5min / 2009-09-15
file: by_date/stock_5min/2009/2009-09-15.parquet size: 4.7 MB rows: 323,818 symbols: 3,379
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-09-15 07:00:00 | AAPL | Stock | 6.2071 | 6.2071 | 6.2071 | 6.2071 | 14000.0 |
| 2009-09-15 07:15:00 | AAPL | Stock | 6.1879 | 6.1879 | 6.1879 | 6.1879 | 14000.0 |
| 2009-09-15 07:20:00 | AAPL | Stock | 6.1911 | 6.1911 | 6.1911 | 6.1911 | 2800.0 |
| 2009-09-15 07:45:00 | AAPL | Stock | 6.2032 | 6.2032 | 6.2032 | 6.2032 | 8400.0 |
| 2009-09-15 07:50:00 | AAPL | Stock | 6.2039 | 6.2039 | 6.2018 | 6.2018 | 8400.0 |
| 2009-09-15 08:00:00 | AAPL | Stock | 6.2043 | 6.2196 | 6.2036 | 6.2107 | 2839648.0 |
| 2009-09-15 08:05:00 | AAPL | Stock | 6.2139 | 6.2179 | 6.2139 | 6.2168 | 53480.0 |
| 2009-09-15 08:10:00 | AAPL | Stock | 6.2182 | 6.2232 | 6.2143 | 6.2218 | 332500.0 |
| 2009-09-15 08:15:00 | AAPL | Stock | 6.2207 | 6.2207 | 6.2154 | 6.2189 | 47236.0 |
| 2009-09-15 08:20:00 | AAPL | Stock | 6.2161 | 6.2189 | 6.215 | 6.215 | 25200.0 |
| 2009-09-15 08:25:00 | AAPL | Stock | 6.2175 | 6.2179 | 6.2143 | 6.2143 | 70812.0 |
| 2009-09-15 08:30:00 | AAPL | Stock | 6.2143 | 6.2289 | 6.2143 | 6.2289 | 472500.0 |
| 2009-09-15 08:35:00 | AAPL | Stock | 6.2289 | 6.2289 | 6.2236 | 6.2264 | 141204.0 |
| 2009-09-15 08:40:00 | AAPL | Stock | 6.2286 | 6.2289 | 6.2232 | 6.2279 | 154224.0 |
| 2009-09-15 08:45:00 | AAPL | Stock | 6.2279 | 6.2286 | 6.2232 | 6.2254 | 229432.0 |
| 2009-09-15 08:50:00 | AAPL | Stock | 6.225 | 6.2289 | 6.2236 | 6.2268 | 50736.0 |
| 2009-09-15 08:55:00 | AAPL | Stock | 6.2268 | 6.2289 | 6.225 | 6.225 | 176064.0 |
| 2009-09-15 09:00:00 | AAPL | Stock | 6.2275 | 6.2282 | 6.2232 | 6.225 | 151480.0 |
| 2009-09-15 09:05:00 | AAPL | Stock | 6.225 | 6.2254 | 6.2232 | 6.225 | 280000.0 |
| 2009-09-15 09:10:00 | AAPL | Stock | 6.225 | 6.2286 | 6.2232 | 6.225 | 111160.0 |
| 2009-09-15 09:15:00 | AAPL | Stock | 6.225 | 6.225 | 6.2171 | 6.2175 | 100800.0 |
| 2009-09-15 09:20:00 | AAPL | Stock | 6.2193 | 6.2239 | 6.2193 | 6.2218 | 110600.0 |
| 2009-09-15 09:25:00 | AAPL | Stock | 6.2189 | 6.2218 | 6.2157 | 6.2171 | 146832.0 |
| 2009-09-15 09:30:00 | AAPL | Stock | 6.2157 | 6.2296 | 6.1996 | 6.2271 | 16729552.0 |
| 2009-09-15 09:35:00 | AAPL | Stock | 6.2264 | 6.2407 | 6.2171 | 6.2386 | 11767224.0 |
| 2009-09-15 09:40:00 | AAPL | Stock | 6.2386 | 6.2486 | 6.2296 | 6.2324 | 10101784.0 |
| 2009-09-15 09:45:00 | AAPL | Stock | 6.2321 | 6.2386 | 6.2232 | 6.2261 | 7502908.0 |
| 2009-09-15 09:50:00 | AAPL | Stock | 6.2257 | 6.2261 | 6.2086 | 6.2192 | 9677360.0 |
| 2009-09-15 09:55:00 | AAPL | Stock | 6.2182 | 6.2307 | 6.2136 | 6.2286 | 7932204.0 |
| 2009-09-15 10:00:00 | AAPL | Stock | 6.2275 | 6.2286 | 6.2107 | 6.2189 | 7001288.0 |
| 2009-09-15 10:05:00 | AAPL | Stock | 6.22 | 6.2321 | 6.2114 | 6.2321 | 6944084.0 |
| 2009-09-15 10:10:00 | AAPL | Stock | 6.2321 | 6.2368 | 6.2196 | 6.2221 | 7443856.0 |
| 2009-09-15 10:15:00 | AAPL | Stock | 6.2221 | 6.2236 | 6.2107 | 6.2229 | 6609316.0 |
| 2009-09-15 10:20:00 | AAPL | Stock | 6.2232 | 6.2307 | 6.2193 | 6.2214 | 4668300.0 |
| 2009-09-15 10:25:00 | AAPL | Stock | 6.2211 | 6.2321 | 6.2179 | 6.2314 | 5029052.0 |
| 2009-09-15 10:30:00 | AAPL | Stock | 6.2318 | 6.2396 | 6.2286 | 6.2346 | 5235664.0 |
| 2009-09-15 10:35:00 | AAPL | Stock | 6.2343 | 6.2407 | 6.2332 | 6.2357 | 2776956.0 |
| 2009-09-15 10:40:00 | AAPL | Stock | 6.235 | 6.245 | 6.2304 | 6.2443 | 4585140.0 |
| 2009-09-15 10:45:00 | AAPL | Stock | 6.2446 | 6.2486 | 6.2436 | 6.2464 | 7310296.0 |
| 2009-09-15 10:50:00 | AAPL | Stock | 6.2464 | 6.25 | 6.2411 | 6.2421 | 9136344.0 |
| 2009-09-15 10:55:00 | AAPL | Stock | 6.2431 | 6.2475 | 6.2411 | 6.2457 | 2901052.0 |
| 2009-09-15 11:00:00 | AAPL | Stock | 6.2454 | 6.2479 | 6.2375 | 6.2414 | 7822808.0 |
| 2009-09-15 11:05:00 | AAPL | Stock | 6.2407 | 6.2425 | 6.2332 | 6.2395 | 3634932.0 |
| 2009-09-15 11:10:00 | AAPL | Stock | 6.2393 | 6.245 | 6.2375 | 6.2382 | 1894760.0 |
| 2009-09-15 11:15:00 | AAPL | Stock | 6.2386 | 6.2411 | 6.2332 | 6.2382 | 3119928.0 |
| 2009-09-15 11:20:00 | AAPL | Stock | 6.2382 | 6.2475 | 6.2364 | 6.2443 | 3838044.0 |
| 2009-09-15 11:25:00 | AAPL | Stock | 6.2446 | 6.2575 | 6.2425 | 6.2564 | 12228048.0 |
| 2009-09-15 11:30:00 | AAPL | Stock | 6.2557 | 6.26 | 6.2525 | 6.2553 | 6325732.0 |
| 2009-09-15 11:35:00 | AAPL | Stock | 6.2543 | 6.26 | 6.2543 | 6.2593 | 3363528.0 |
| 2009-09-15 11:40:00 | AAPL | Stock | 6.2596 | 6.26 | 6.2507 | 6.2546 | 2686264.0 |
> showing 50 of 323,818 rows — these rows as CSV