PREVIEW / stock_1min / 2003-01-24
file: by_date/stock_1min/2003/2003-01-24.parquet size: 4.6 MB rows: 376,195 symbols: 1,262
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-01-24 08:25:00 | AAPL | Stock | 0.2538 | 0.2538 | 0.2538 | 0.2538 | 11200.0 |
| 2003-01-24 08:33:00 | AAPL | Stock | 0.2538 | 0.2538 | 0.2538 | 0.2538 | 16800.0 |
| 2003-01-24 08:40:00 | AAPL | Stock | 0.2552 | 0.2552 | 0.2546 | 0.255 | 33600.0 |
| 2003-01-24 08:45:00 | AAPL | Stock | 0.255 | 0.255 | 0.255 | 0.255 | 44800.0 |
| 2003-01-24 09:05:00 | AAPL | Stock | 0.2543 | 0.2543 | 0.2538 | 0.2538 | 39200.0 |
| 2003-01-24 09:10:00 | AAPL | Stock | 0.2543 | 0.2543 | 0.2543 | 0.2543 | 5600.0 |
| 2003-01-24 09:20:00 | AAPL | Stock | 0.2536 | 0.2536 | 0.2536 | 0.2536 | 11200.0 |
| 2003-01-24 09:22:00 | AAPL | Stock | 0.2536 | 0.2536 | 0.2536 | 0.2536 | 16800.0 |
| 2003-01-24 09:24:00 | AAPL | Stock | 0.2536 | 0.2536 | 0.2536 | 0.2536 | 16800.0 |
| 2003-01-24 09:29:00 | AAPL | Stock | 0.2532 | 0.2538 | 0.253 | 0.2538 | 313600.0 |
| 2003-01-24 09:30:00 | AAPL | Stock | 0.2543 | 0.2543 | 0.2516 | 0.2516 | 2849224.0 |
| 2003-01-24 09:31:00 | AAPL | Stock | 0.252 | 0.253 | 0.2518 | 0.2523 | 716800.0 |
| 2003-01-24 09:32:00 | AAPL | Stock | 0.2523 | 0.253 | 0.2523 | 0.2523 | 352800.0 |
| 2003-01-24 09:33:00 | AAPL | Stock | 0.2523 | 0.2525 | 0.252 | 0.2525 | 1103200.0 |
| 2003-01-24 09:34:00 | AAPL | Stock | 0.252 | 0.2521 | 0.2509 | 0.252 | 492800.0 |
| 2003-01-24 09:35:00 | AAPL | Stock | 0.252 | 0.2521 | 0.2513 | 0.2514 | 3218768.0 |
| 2003-01-24 09:36:00 | AAPL | Stock | 0.2516 | 0.252 | 0.2514 | 0.2516 | 520800.0 |
| 2003-01-24 09:37:00 | AAPL | Stock | 0.2516 | 0.2516 | 0.2502 | 0.2504 | 1232000.0 |
| 2003-01-24 09:38:00 | AAPL | Stock | 0.2504 | 0.2511 | 0.2504 | 0.2504 | 554400.0 |
| 2003-01-24 09:39:00 | AAPL | Stock | 0.2511 | 0.2511 | 0.2505 | 0.2505 | 224000.0 |
| 2003-01-24 09:40:00 | AAPL | Stock | 0.2509 | 0.2511 | 0.2505 | 0.2507 | 2430400.0 |
| 2003-01-24 09:41:00 | AAPL | Stock | 0.2507 | 0.2509 | 0.2505 | 0.2507 | 711200.0 |
| 2003-01-24 09:42:00 | AAPL | Stock | 0.2507 | 0.2507 | 0.2507 | 0.2507 | 44800.0 |
| 2003-01-24 09:43:00 | AAPL | Stock | 0.2505 | 0.2507 | 0.2505 | 0.2507 | 498400.0 |
| 2003-01-24 09:44:00 | AAPL | Stock | 0.2505 | 0.2507 | 0.25 | 0.25 | 1933680.0 |
| 2003-01-24 09:45:00 | AAPL | Stock | 0.25 | 0.25 | 0.2495 | 0.2497 | 1906856.0 |
| 2003-01-24 09:46:00 | AAPL | Stock | 0.2497 | 0.2504 | 0.2496 | 0.25 | 649600.0 |
| 2003-01-24 09:47:00 | AAPL | Stock | 0.25 | 0.2504 | 0.25 | 0.2504 | 362432.0 |
| 2003-01-24 09:48:00 | AAPL | Stock | 0.25 | 0.2504 | 0.25 | 0.2502 | 268632.0 |
| 2003-01-24 09:49:00 | AAPL | Stock | 0.2502 | 0.2502 | 0.25 | 0.25 | 392000.0 |
| 2003-01-24 09:50:00 | AAPL | Stock | 0.25 | 0.2502 | 0.2496 | 0.2496 | 1220800.0 |
| 2003-01-24 09:51:00 | AAPL | Stock | 0.2496 | 0.2498 | 0.2493 | 0.2493 | 565600.0 |
| 2003-01-24 09:52:00 | AAPL | Stock | 0.2493 | 0.2498 | 0.2491 | 0.2497 | 2111200.0 |
| 2003-01-24 09:53:00 | AAPL | Stock | 0.2495 | 0.2496 | 0.2488 | 0.2496 | 1143296.0 |
| 2003-01-24 09:54:00 | AAPL | Stock | 0.2496 | 0.2496 | 0.2489 | 0.2495 | 1416800.0 |
| 2003-01-24 09:55:00 | AAPL | Stock | 0.2495 | 0.2496 | 0.2491 | 0.2495 | 1251544.0 |
| 2003-01-24 09:56:00 | AAPL | Stock | 0.2495 | 0.2496 | 0.2493 | 0.2495 | 929600.0 |
| 2003-01-24 09:57:00 | AAPL | Stock | 0.2495 | 0.2495 | 0.2486 | 0.2486 | 886480.0 |
| 2003-01-24 09:58:00 | AAPL | Stock | 0.2489 | 0.2489 | 0.2486 | 0.2486 | 1416800.0 |
| 2003-01-24 09:59:00 | AAPL | Stock | 0.2486 | 0.249 | 0.2484 | 0.2484 | 2660672.0 |
| 2003-01-24 10:00:00 | AAPL | Stock | 0.2484 | 0.2484 | 0.2479 | 0.2481 | 1670256.0 |
| 2003-01-24 10:01:00 | AAPL | Stock | 0.2477 | 0.2484 | 0.2475 | 0.2475 | 1243200.0 |
| 2003-01-24 10:02:00 | AAPL | Stock | 0.2477 | 0.248 | 0.2475 | 0.2479 | 921200.0 |
| 2003-01-24 10:03:00 | AAPL | Stock | 0.2479 | 0.2479 | 0.2475 | 0.2477 | 1212400.0 |
| 2003-01-24 10:04:00 | AAPL | Stock | 0.2477 | 0.248 | 0.2475 | 0.2479 | 484680.0 |
| 2003-01-24 10:05:00 | AAPL | Stock | 0.2479 | 0.2488 | 0.2479 | 0.2488 | 758688.0 |
| 2003-01-24 10:06:00 | AAPL | Stock | 0.2488 | 0.2491 | 0.2486 | 0.2489 | 1086624.0 |
| 2003-01-24 10:07:00 | AAPL | Stock | 0.2491 | 0.2491 | 0.2486 | 0.2486 | 994448.0 |
| 2003-01-24 10:08:00 | AAPL | Stock | 0.2486 | 0.2486 | 0.248 | 0.248 | 1248800.0 |
| 2003-01-24 10:09:00 | AAPL | Stock | 0.248 | 0.2482 | 0.248 | 0.2482 | 1299200.0 |
> showing 50 of 376,195 rows — these rows as CSV