PREVIEW / stock_5min / 2006-03-31
file: by_date/stock_5min/2006/2006-03-31.parquet size: 3.1 MB rows: 226,223 symbols: 2,226
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-03-31 04:25:00 | AAPL | Stock | 2.2464 | 2.2464 | 2.2464 | 2.2464 | 8400.0 |
| 2006-03-31 06:35:00 | AAPL | Stock | 2.2411 | 2.2411 | 2.2411 | 2.2411 | 2800.0 |
| 2006-03-31 06:40:00 | AAPL | Stock | 2.2411 | 2.2411 | 2.2411 | 2.2411 | 2800.0 |
| 2006-03-31 07:00:00 | AAPL | Stock | 2.2446 | 2.2446 | 2.2446 | 2.2446 | 2800.0 |
| 2006-03-31 07:10:00 | AAPL | Stock | 2.2411 | 2.2411 | 2.2411 | 2.2411 | 2800.0 |
| 2006-03-31 07:30:00 | AAPL | Stock | 2.25 | 2.25 | 2.25 | 2.25 | 2800.0 |
| 2006-03-31 07:50:00 | AAPL | Stock | 2.25 | 2.25 | 2.25 | 2.25 | 5600.0 |
| 2006-03-31 07:55:00 | AAPL | Stock | 2.2554 | 2.2571 | 2.2554 | 2.2571 | 39200.0 |
| 2006-03-31 08:00:00 | AAPL | Stock | 2.2507 | 2.2564 | 2.2479 | 2.2532 | 264880.0 |
| 2006-03-31 08:05:00 | AAPL | Stock | 2.2536 | 2.2539 | 2.2479 | 2.2479 | 165200.0 |
| 2006-03-31 08:10:00 | AAPL | Stock | 2.2496 | 2.2496 | 2.2486 | 2.2486 | 16800.0 |
| 2006-03-31 08:15:00 | AAPL | Stock | 2.2479 | 2.2479 | 2.2464 | 2.2464 | 172900.0 |
| 2006-03-31 08:20:00 | AAPL | Stock | 2.2468 | 2.2468 | 2.2468 | 2.2468 | 40712.0 |
| 2006-03-31 08:25:00 | AAPL | Stock | 2.2471 | 2.2475 | 2.2464 | 2.2464 | 141988.0 |
| 2006-03-31 08:30:00 | AAPL | Stock | 2.2464 | 2.2482 | 2.2464 | 2.2464 | 274064.0 |
| 2006-03-31 08:35:00 | AAPL | Stock | 2.2457 | 2.2468 | 2.2446 | 2.2446 | 103460.0 |
| 2006-03-31 08:40:00 | AAPL | Stock | 2.2446 | 2.2468 | 2.2443 | 2.2464 | 100240.0 |
| 2006-03-31 08:45:00 | AAPL | Stock | 2.2464 | 2.25 | 2.2454 | 2.2493 | 147840.0 |
| 2006-03-31 08:50:00 | AAPL | Stock | 2.2486 | 2.2536 | 2.2486 | 2.2518 | 456400.0 |
| 2006-03-31 08:55:00 | AAPL | Stock | 2.2518 | 2.2521 | 2.2482 | 2.25 | 424900.0 |
| 2006-03-31 09:00:00 | AAPL | Stock | 2.2493 | 2.25 | 2.2468 | 2.25 | 172032.0 |
| 2006-03-31 09:05:00 | AAPL | Stock | 2.25 | 2.25 | 2.2489 | 2.25 | 197484.0 |
| 2006-03-31 09:10:00 | AAPL | Stock | 2.2486 | 2.25 | 2.2471 | 2.2482 | 213276.0 |
| 2006-03-31 09:15:00 | AAPL | Stock | 2.25 | 2.2536 | 2.25 | 2.2536 | 449512.0 |
| 2006-03-31 09:20:00 | AAPL | Stock | 2.2539 | 2.2582 | 2.2529 | 2.2561 | 644000.0 |
| 2006-03-31 09:25:00 | AAPL | Stock | 2.2536 | 2.2593 | 2.2536 | 2.2589 | 1950060.0 |
| 2006-03-31 09:30:00 | AAPL | Stock | 2.2589 | 2.2718 | 2.2514 | 2.2568 | 37278696.0 |
| 2006-03-31 09:35:00 | AAPL | Stock | 2.2568 | 2.2607 | 2.2464 | 2.2525 | 26502700.0 |
| 2006-03-31 09:40:00 | AAPL | Stock | 2.2518 | 2.2611 | 2.2471 | 2.26 | 18842740.0 |
| 2006-03-31 09:45:00 | AAPL | Stock | 2.2596 | 2.2607 | 2.2475 | 2.2496 | 16672488.0 |
| 2006-03-31 09:50:00 | AAPL | Stock | 2.25 | 2.2521 | 2.2418 | 2.2439 | 25891040.0 |
| 2006-03-31 09:55:00 | AAPL | Stock | 2.2429 | 2.2536 | 2.2393 | 2.2504 | 22928080.0 |
| 2006-03-31 10:00:00 | AAPL | Stock | 2.2504 | 2.2521 | 2.2439 | 2.2482 | 11988396.0 |
| 2006-03-31 10:05:00 | AAPL | Stock | 2.2482 | 2.2486 | 2.2361 | 2.2375 | 17012968.0 |
| 2006-03-31 10:10:00 | AAPL | Stock | 2.2371 | 2.2464 | 2.2364 | 2.2432 | 15336412.0 |
| 2006-03-31 10:15:00 | AAPL | Stock | 2.2439 | 2.2464 | 2.24 | 2.2417 | 12606188.0 |
| 2006-03-31 10:20:00 | AAPL | Stock | 2.2414 | 2.2425 | 2.2282 | 2.2318 | 26455016.0 |
| 2006-03-31 10:25:00 | AAPL | Stock | 2.2314 | 2.235 | 2.2229 | 2.2264 | 22127224.0 |
| 2006-03-31 10:30:00 | AAPL | Stock | 2.2261 | 2.2314 | 2.2232 | 2.2271 | 12159812.0 |
| 2006-03-31 10:35:00 | AAPL | Stock | 2.2275 | 2.2332 | 2.2254 | 2.2321 | 11999400.0 |
| 2006-03-31 10:40:00 | AAPL | Stock | 2.2318 | 2.235 | 2.2264 | 2.2279 | 10039092.0 |
| 2006-03-31 10:45:00 | AAPL | Stock | 2.2279 | 2.2364 | 2.2261 | 2.2329 | 9342648.0 |
| 2006-03-31 10:50:00 | AAPL | Stock | 2.2332 | 2.2346 | 2.23 | 2.2329 | 10943576.0 |
| 2006-03-31 10:55:00 | AAPL | Stock | 2.2332 | 2.2586 | 2.2329 | 2.235 | 7402024.0 |
| 2006-03-31 11:00:00 | AAPL | Stock | 2.2346 | 2.235 | 2.2304 | 2.2343 | 7205156.0 |
| 2006-03-31 11:05:00 | AAPL | Stock | 2.2343 | 2.2411 | 2.2325 | 2.2404 | 9641912.0 |
| 2006-03-31 11:10:00 | AAPL | Stock | 2.2404 | 2.2454 | 2.2368 | 2.2414 | 8810900.0 |
| 2006-03-31 11:15:00 | AAPL | Stock | 2.2411 | 2.2479 | 2.2411 | 2.2465 | 8837220.0 |
| 2006-03-31 11:20:00 | AAPL | Stock | 2.2468 | 2.25 | 2.2446 | 2.2482 | 11957288.0 |
| 2006-03-31 11:25:00 | AAPL | Stock | 2.2482 | 2.2482 | 2.2411 | 2.2439 | 12492228.0 |
> showing 50 of 226,223 rows — these rows as CSV