PREVIEW / stock_1min / 2003-04-09
file: by_date/stock_1min/2003/2003-04-09.parquet size: 4.4 MB rows: 359,649 symbols: 1,276
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-09 08:57:00 | AAPL | Stock | 0.258 | 0.258 | 0.258 | 0.258 | 44800.0 |
| 2003-04-09 09:04:00 | AAPL | Stock | 0.258 | 0.258 | 0.258 | 0.258 | 28000.0 |
| 2003-04-09 09:08:00 | AAPL | Stock | 0.258 | 0.258 | 0.258 | 0.258 | 39200.0 |
| 2003-04-09 09:11:00 | AAPL | Stock | 0.2616 | 0.2768 | 0.2582 | 0.2634 | 221088.0 |
| 2003-04-09 09:20:00 | AAPL | Stock | 0.2601 | 0.2602 | 0.26 | 0.2602 | 106400.0 |
| 2003-04-09 09:25:00 | AAPL | Stock | 0.2588 | 0.2588 | 0.2588 | 0.2588 | 44800.0 |
| 2003-04-09 09:29:00 | AAPL | Stock | 0.2584 | 0.2593 | 0.2584 | 0.2589 | 184800.0 |
| 2003-04-09 09:30:00 | AAPL | Stock | 0.2593 | 0.2602 | 0.2588 | 0.2589 | 1092000.0 |
| 2003-04-09 09:31:00 | AAPL | Stock | 0.2589 | 0.2596 | 0.2584 | 0.2595 | 510832.0 |
| 2003-04-09 09:32:00 | AAPL | Stock | 0.2595 | 0.2604 | 0.2589 | 0.2596 | 1461880.0 |
| 2003-04-09 09:33:00 | AAPL | Stock | 0.2596 | 0.2597 | 0.2595 | 0.2596 | 392000.0 |
| 2003-04-09 09:34:00 | AAPL | Stock | 0.2596 | 0.2604 | 0.2596 | 0.2604 | 128800.0 |
| 2003-04-09 09:35:00 | AAPL | Stock | 0.2605 | 0.2605 | 0.2598 | 0.2602 | 610400.0 |
| 2003-04-09 09:36:00 | AAPL | Stock | 0.2602 | 0.2602 | 0.2593 | 0.2598 | 224000.0 |
| 2003-04-09 09:37:00 | AAPL | Stock | 0.2598 | 0.2598 | 0.259 | 0.259 | 341600.0 |
| 2003-04-09 09:38:00 | AAPL | Stock | 0.2591 | 0.2591 | 0.2579 | 0.2579 | 501200.0 |
| 2003-04-09 09:39:00 | AAPL | Stock | 0.2579 | 0.2584 | 0.2577 | 0.258 | 184800.0 |
| 2003-04-09 09:40:00 | AAPL | Stock | 0.258 | 0.2582 | 0.2575 | 0.2579 | 459200.0 |
| 2003-04-09 09:41:00 | AAPL | Stock | 0.2577 | 0.2579 | 0.2573 | 0.2577 | 316456.0 |
| 2003-04-09 09:42:00 | AAPL | Stock | 0.2575 | 0.2577 | 0.2571 | 0.2571 | 653632.0 |
| 2003-04-09 09:43:00 | AAPL | Stock | 0.2575 | 0.2575 | 0.2571 | 0.2571 | 364000.0 |
| 2003-04-09 09:44:00 | AAPL | Stock | 0.2573 | 0.2573 | 0.2571 | 0.2571 | 386400.0 |
| 2003-04-09 09:45:00 | AAPL | Stock | 0.2571 | 0.2571 | 0.257 | 0.257 | 308000.0 |
| 2003-04-09 09:46:00 | AAPL | Stock | 0.257 | 0.2571 | 0.257 | 0.2571 | 50400.0 |
| 2003-04-09 09:47:00 | AAPL | Stock | 0.2571 | 0.2571 | 0.2568 | 0.2568 | 1019200.0 |
| 2003-04-09 09:48:00 | AAPL | Stock | 0.2568 | 0.2571 | 0.2568 | 0.257 | 806400.0 |
| 2003-04-09 09:49:00 | AAPL | Stock | 0.2571 | 0.2573 | 0.257 | 0.2571 | 582400.0 |
| 2003-04-09 09:50:00 | AAPL | Stock | 0.2571 | 0.2573 | 0.2564 | 0.2564 | 946400.0 |
| 2003-04-09 09:51:00 | AAPL | Stock | 0.2564 | 0.257 | 0.2564 | 0.2564 | 515200.0 |
| 2003-04-09 09:52:00 | AAPL | Stock | 0.2564 | 0.2571 | 0.2564 | 0.257 | 89600.0 |
| 2003-04-09 09:53:00 | AAPL | Stock | 0.257 | 0.2573 | 0.257 | 0.257 | 484288.0 |
| 2003-04-09 09:54:00 | AAPL | Stock | 0.257 | 0.2571 | 0.2566 | 0.2568 | 554064.0 |
| 2003-04-09 09:55:00 | AAPL | Stock | 0.2568 | 0.257 | 0.2563 | 0.2563 | 677600.0 |
| 2003-04-09 09:56:00 | AAPL | Stock | 0.2564 | 0.2573 | 0.2564 | 0.2571 | 330400.0 |
| 2003-04-09 09:57:00 | AAPL | Stock | 0.2573 | 0.2584 | 0.2571 | 0.2584 | 985600.0 |
| 2003-04-09 09:58:00 | AAPL | Stock | 0.2582 | 0.2584 | 0.2577 | 0.2577 | 576800.0 |
| 2003-04-09 09:59:00 | AAPL | Stock | 0.2579 | 0.2579 | 0.2577 | 0.2577 | 72800.0 |
| 2003-04-09 10:00:00 | AAPL | Stock | 0.2577 | 0.2577 | 0.2571 | 0.2571 | 336000.0 |
| 2003-04-09 10:01:00 | AAPL | Stock | 0.2573 | 0.2573 | 0.2573 | 0.2573 | 84000.0 |
| 2003-04-09 10:02:00 | AAPL | Stock | 0.2575 | 0.2575 | 0.2573 | 0.2573 | 19600.0 |
| 2003-04-09 10:03:00 | AAPL | Stock | 0.2575 | 0.2575 | 0.2573 | 0.2573 | 78400.0 |
| 2003-04-09 10:04:00 | AAPL | Stock | 0.2575 | 0.2579 | 0.2575 | 0.2579 | 201600.0 |
| 2003-04-09 10:05:00 | AAPL | Stock | 0.2579 | 0.2579 | 0.2573 | 0.2577 | 179200.0 |
| 2003-04-09 10:06:00 | AAPL | Stock | 0.2575 | 0.2575 | 0.2575 | 0.2575 | 22400.0 |
| 2003-04-09 10:07:00 | AAPL | Stock | 0.2577 | 0.2577 | 0.2575 | 0.2577 | 51072.0 |
| 2003-04-09 10:08:00 | AAPL | Stock | 0.2577 | 0.2589 | 0.2577 | 0.2586 | 565600.0 |
| 2003-04-09 10:09:00 | AAPL | Stock | 0.2588 | 0.2588 | 0.2584 | 0.2584 | 324352.0 |
| 2003-04-09 10:10:00 | AAPL | Stock | 0.2584 | 0.2584 | 0.2582 | 0.2582 | 67200.0 |
| 2003-04-09 10:11:00 | AAPL | Stock | 0.2586 | 0.2591 | 0.2586 | 0.2589 | 336000.0 |
| 2003-04-09 10:12:00 | AAPL | Stock | 0.2591 | 0.2598 | 0.2589 | 0.2596 | 675584.0 |
> showing 50 of 359,649 rows — these rows as CSV