PREVIEW / stock_1min / 2003-04-29
file: by_date/stock_1min/2003/2003-04-29.parquet size: 4.7 MB rows: 387,243 symbols: 1,290
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 |
|---|---|---|---|---|---|---|---|
| 2003-04-29 08:27:00 | AAPL | Stock | 0.2479 | 0.2479 | 0.2479 | 0.2479 | 5600.0 |
| 2003-04-29 08:34:00 | AAPL | Stock | 0.2489 | 0.2489 | 0.2489 | 0.2489 | 22400.0 |
| 2003-04-29 08:42:00 | AAPL | Stock | 0.25 | 0.25 | 0.2498 | 0.2498 | 28000.0 |
| 2003-04-29 08:44:00 | AAPL | Stock | 0.25 | 0.25 | 0.25 | 0.25 | 5600.0 |
| 2003-04-29 08:46:00 | AAPL | Stock | 0.2498 | 0.25 | 0.2498 | 0.25 | 53200.0 |
| 2003-04-29 08:57:00 | AAPL | Stock | 0.2493 | 0.2493 | 0.2493 | 0.2493 | 5600.0 |
| 2003-04-29 08:59:00 | AAPL | Stock | 0.2496 | 0.2496 | 0.2496 | 0.2496 | 11200.0 |
| 2003-04-29 09:00:00 | AAPL | Stock | 0.2489 | 0.2489 | 0.2489 | 0.2489 | 28000.0 |
| 2003-04-29 09:20:00 | AAPL | Stock | 0.2489 | 0.2489 | 0.2488 | 0.2488 | 11200.0 |
| 2003-04-29 09:22:00 | AAPL | Stock | 0.2488 | 0.2488 | 0.2488 | 0.2488 | 50400.0 |
| 2003-04-29 09:23:00 | AAPL | Stock | 0.2496 | 0.2496 | 0.2496 | 0.2496 | 5600.0 |
| 2003-04-29 09:26:00 | AAPL | Stock | 0.2489 | 0.2489 | 0.2489 | 0.2489 | 33600.0 |
| 2003-04-29 09:27:00 | AAPL | Stock | 0.2498 | 0.25 | 0.2495 | 0.25 | 446936.0 |
| 2003-04-29 09:28:00 | AAPL | Stock | 0.25 | 0.25 | 0.25 | 0.25 | 151200.0 |
| 2003-04-29 09:29:00 | AAPL | Stock | 0.2496 | 0.2496 | 0.2496 | 0.2496 | 11200.0 |
| 2003-04-29 09:30:00 | AAPL | Stock | 0.2496 | 0.25 | 0.2496 | 0.25 | 6437480.0 |
| 2003-04-29 09:31:00 | AAPL | Stock | 0.25 | 0.25 | 0.2496 | 0.2498 | 5718608.0 |
| 2003-04-29 09:32:00 | AAPL | Stock | 0.25 | 0.2505 | 0.2493 | 0.25 | 5601792.0 |
| 2003-04-29 09:33:00 | AAPL | Stock | 0.2499 | 0.2509 | 0.2499 | 0.25 | 6974856.0 |
| 2003-04-29 09:34:00 | AAPL | Stock | 0.25 | 0.2502 | 0.2493 | 0.2493 | 8089256.0 |
| 2003-04-29 09:35:00 | AAPL | Stock | 0.2493 | 0.2498 | 0.2491 | 0.2496 | 2506056.0 |
| 2003-04-29 09:36:00 | AAPL | Stock | 0.2495 | 0.2495 | 0.2489 | 0.2495 | 2346064.0 |
| 2003-04-29 09:37:00 | AAPL | Stock | 0.2493 | 0.2495 | 0.2491 | 0.2493 | 369600.0 |
| 2003-04-29 09:38:00 | AAPL | Stock | 0.2493 | 0.2495 | 0.2491 | 0.2493 | 2325288.0 |
| 2003-04-29 09:39:00 | AAPL | Stock | 0.2493 | 0.2495 | 0.2491 | 0.2494 | 257600.0 |
| 2003-04-29 09:40:00 | AAPL | Stock | 0.2491 | 0.2495 | 0.2488 | 0.2489 | 1417024.0 |
| 2003-04-29 09:41:00 | AAPL | Stock | 0.2488 | 0.2493 | 0.2484 | 0.2484 | 1428000.0 |
| 2003-04-29 09:42:00 | AAPL | Stock | 0.2486 | 0.2488 | 0.2482 | 0.2488 | 1355760.0 |
| 2003-04-29 09:43:00 | AAPL | Stock | 0.2484 | 0.2498 | 0.2484 | 0.2495 | 2114336.0 |
| 2003-04-29 09:44:00 | AAPL | Stock | 0.2495 | 0.2495 | 0.2491 | 0.2493 | 722400.0 |
| 2003-04-29 09:45:00 | AAPL | Stock | 0.2495 | 0.2495 | 0.2488 | 0.2488 | 1920800.0 |
| 2003-04-29 09:46:00 | AAPL | Stock | 0.2489 | 0.2493 | 0.2484 | 0.2488 | 1302168.0 |
| 2003-04-29 09:47:00 | AAPL | Stock | 0.2486 | 0.2488 | 0.2484 | 0.2486 | 1528128.0 |
| 2003-04-29 09:48:00 | AAPL | Stock | 0.2486 | 0.2486 | 0.2482 | 0.2482 | 493248.0 |
| 2003-04-29 09:49:00 | AAPL | Stock | 0.2486 | 0.2488 | 0.2486 | 0.2486 | 896000.0 |
| 2003-04-29 09:50:00 | AAPL | Stock | 0.2488 | 0.2488 | 0.2484 | 0.2484 | 1756048.0 |
| 2003-04-29 09:51:00 | AAPL | Stock | 0.2484 | 0.2488 | 0.2479 | 0.2479 | 6653080.0 |
| 2003-04-29 09:52:00 | AAPL | Stock | 0.2479 | 0.2482 | 0.2477 | 0.2482 | 1335600.0 |
| 2003-04-29 09:53:00 | AAPL | Stock | 0.2482 | 0.2482 | 0.248 | 0.2481 | 560000.0 |
| 2003-04-29 09:54:00 | AAPL | Stock | 0.248 | 0.2482 | 0.2477 | 0.248 | 2582888.0 |
| 2003-04-29 09:55:00 | AAPL | Stock | 0.248 | 0.2488 | 0.2479 | 0.2484 | 3642800.0 |
| 2003-04-29 09:56:00 | AAPL | Stock | 0.2482 | 0.2488 | 0.247 | 0.2471 | 3370080.0 |
| 2003-04-29 09:57:00 | AAPL | Stock | 0.247 | 0.2475 | 0.2464 | 0.2475 | 4715200.0 |
| 2003-04-29 09:58:00 | AAPL | Stock | 0.2475 | 0.2479 | 0.2471 | 0.2479 | 1980272.0 |
| 2003-04-29 09:59:00 | AAPL | Stock | 0.2477 | 0.2479 | 0.2466 | 0.2468 | 1664432.0 |
| 2003-04-29 10:00:00 | AAPL | Stock | 0.2471 | 0.2495 | 0.2464 | 0.2492 | 5078976.0 |
| 2003-04-29 10:01:00 | AAPL | Stock | 0.2493 | 0.2495 | 0.2482 | 0.2488 | 1439872.0 |
| 2003-04-29 10:02:00 | AAPL | Stock | 0.2486 | 0.2488 | 0.248 | 0.2482 | 2626400.0 |
| 2003-04-29 10:03:00 | AAPL | Stock | 0.2482 | 0.2482 | 0.2477 | 0.2482 | 1752800.0 |
| 2003-04-29 10:04:00 | AAPL | Stock | 0.2484 | 0.2486 | 0.2483 | 0.2486 | 1257872.0 |
> showing 50 of 387,243 rows — these rows as CSV