PREVIEW / stock_5min / 2006-11-28
file: by_date/stock_5min/2006/2006-11-28.parquet size: 3.3 MB rows: 239,112 symbols: 2,471
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 |
|---|---|---|---|---|---|---|---|
| 2006-11-28 06:10:00 | AAPL | Stock | 3.2089 | 3.2089 | 3.2089 | 3.2089 | 53200.0 |
| 2006-11-28 06:55:00 | AAPL | Stock | 3.2093 | 3.2093 | 3.2093 | 3.2093 | 2800.0 |
| 2006-11-28 07:00:00 | AAPL | Stock | 3.2186 | 3.2286 | 3.2182 | 3.2286 | 43232.0 |
| 2006-11-28 07:10:00 | AAPL | Stock | 3.2214 | 3.2214 | 3.2161 | 3.2161 | 5600.0 |
| 2006-11-28 07:20:00 | AAPL | Stock | 3.2214 | 3.2214 | 3.2214 | 3.2214 | 5600.0 |
| 2006-11-28 07:25:00 | AAPL | Stock | 3.2211 | 3.2211 | 3.2211 | 3.2211 | 7756.0 |
| 2006-11-28 07:30:00 | AAPL | Stock | 3.2161 | 3.2161 | 3.2061 | 3.2061 | 29204.0 |
| 2006-11-28 07:40:00 | AAPL | Stock | 3.2171 | 3.2171 | 3.2171 | 3.2171 | 56000.0 |
| 2006-11-28 07:45:00 | AAPL | Stock | 3.2171 | 3.2321 | 3.2171 | 3.2321 | 481600.0 |
| 2006-11-28 07:50:00 | AAPL | Stock | 3.225 | 3.2311 | 3.225 | 3.2254 | 89040.0 |
| 2006-11-28 07:55:00 | AAPL | Stock | 3.2286 | 3.2286 | 3.2286 | 3.2286 | 128800.0 |
| 2006-11-28 08:00:00 | AAPL | Stock | 3.2257 | 3.2321 | 3.2225 | 3.2304 | 915488.0 |
| 2006-11-28 08:05:00 | AAPL | Stock | 3.23 | 3.2336 | 3.2268 | 3.2268 | 971908.0 |
| 2006-11-28 08:10:00 | AAPL | Stock | 3.23 | 3.2321 | 3.2268 | 3.2304 | 822584.0 |
| 2006-11-28 08:15:00 | AAPL | Stock | 3.2304 | 3.2314 | 3.2239 | 3.2257 | 959700.0 |
| 2006-11-28 08:20:00 | AAPL | Stock | 3.2254 | 3.2286 | 3.2246 | 3.225 | 331800.0 |
| 2006-11-28 08:25:00 | AAPL | Stock | 3.2243 | 3.2268 | 3.2221 | 3.225 | 476112.0 |
| 2006-11-28 08:30:00 | AAPL | Stock | 3.2236 | 3.225 | 3.2143 | 3.225 | 1462692.0 |
| 2006-11-28 08:35:00 | AAPL | Stock | 3.2232 | 3.2232 | 3.2082 | 3.2107 | 985320.0 |
| 2006-11-28 08:40:00 | AAPL | Stock | 3.2107 | 3.2107 | 3.2054 | 3.21 | 851424.0 |
| 2006-11-28 08:45:00 | AAPL | Stock | 3.2107 | 3.2143 | 3.2089 | 3.2107 | 676200.0 |
| 2006-11-28 08:50:00 | AAPL | Stock | 3.2107 | 3.2196 | 3.2086 | 3.2121 | 1061340.0 |
| 2006-11-28 08:55:00 | AAPL | Stock | 3.2139 | 3.2143 | 3.21 | 3.2104 | 483952.0 |
| 2006-11-28 09:00:00 | AAPL | Stock | 3.21 | 3.2121 | 3.2093 | 3.2111 | 506380.0 |
| 2006-11-28 09:05:00 | AAPL | Stock | 3.2096 | 3.2129 | 3.2068 | 3.2071 | 564256.0 |
| 2006-11-28 09:10:00 | AAPL | Stock | 3.2079 | 3.2232 | 3.2079 | 3.2214 | 1401400.0 |
| 2006-11-28 09:15:00 | AAPL | Stock | 3.2214 | 3.2254 | 3.22 | 3.2211 | 944328.0 |
| 2006-11-28 09:20:00 | AAPL | Stock | 3.2229 | 3.2375 | 3.2214 | 3.2368 | 2175264.0 |
| 2006-11-28 09:25:00 | AAPL | Stock | 3.2371 | 3.2371 | 3.2268 | 3.2279 | 2026752.0 |
| 2006-11-28 09:30:00 | AAPL | Stock | 3.2271 | 3.2461 | 3.2236 | 3.2457 | 43236032.0 |
| 2006-11-28 09:35:00 | AAPL | Stock | 3.2461 | 3.2471 | 3.2304 | 3.2329 | 28710640.0 |
| 2006-11-28 09:40:00 | AAPL | Stock | 3.2325 | 3.2389 | 3.2264 | 3.2286 | 27265616.0 |
| 2006-11-28 09:45:00 | AAPL | Stock | 3.2289 | 3.2311 | 3.2111 | 3.2229 | 39090268.0 |
| 2006-11-28 09:50:00 | AAPL | Stock | 3.2229 | 3.2296 | 3.2161 | 3.2186 | 22088164.0 |
| 2006-11-28 09:55:00 | AAPL | Stock | 3.2182 | 3.2307 | 3.2161 | 3.2289 | 17742956.0 |
| 2006-11-28 10:00:00 | AAPL | Stock | 3.2293 | 3.2457 | 3.2254 | 3.2457 | 26079928.0 |
| 2006-11-28 10:05:00 | AAPL | Stock | 3.2457 | 3.2525 | 3.2364 | 3.2443 | 29276408.0 |
| 2006-11-28 10:10:00 | AAPL | Stock | 3.2439 | 3.2446 | 3.2307 | 3.2339 | 15708812.0 |
| 2006-11-28 10:15:00 | AAPL | Stock | 3.2339 | 3.2446 | 3.2271 | 3.2418 | 15337812.0 |
| 2006-11-28 10:20:00 | AAPL | Stock | 3.2418 | 3.2518 | 3.2411 | 3.25 | 20828108.0 |
| 2006-11-28 10:25:00 | AAPL | Stock | 3.2504 | 3.2657 | 3.25 | 3.2657 | 30221268.0 |
| 2006-11-28 10:30:00 | AAPL | Stock | 3.265 | 3.2682 | 3.2593 | 3.2643 | 20479340.0 |
| 2006-11-28 10:35:00 | AAPL | Stock | 3.2639 | 3.2679 | 3.2596 | 3.2636 | 16619764.0 |
| 2006-11-28 10:40:00 | AAPL | Stock | 3.2634 | 3.2661 | 3.2268 | 3.2657 | 9742824.0 |
| 2006-11-28 10:45:00 | AAPL | Stock | 3.2657 | 3.2768 | 3.2607 | 3.2714 | 23791628.0 |
| 2006-11-28 10:50:00 | AAPL | Stock | 3.2711 | 3.2718 | 3.2621 | 3.2664 | 11332608.0 |
| 2006-11-28 10:55:00 | AAPL | Stock | 3.2664 | 3.2671 | 3.2579 | 3.2596 | 15303148.0 |
| 2006-11-28 11:00:00 | AAPL | Stock | 3.2593 | 3.2689 | 3.2579 | 3.2643 | 10554964.0 |
| 2006-11-28 11:05:00 | AAPL | Stock | 3.2643 | 3.2646 | 3.2536 | 3.2586 | 12306140.0 |
| 2006-11-28 11:10:00 | AAPL | Stock | 3.2586 | 3.2596 | 3.2543 | 3.2593 | 8075340.0 |
> showing 50 of 239,112 rows — these rows as CSV