PREVIEW / stock_1min / 2003-06-27
file: by_date/stock_1min/2003/2003-06-27.parquet size: 5.1 MB rows: 418,763 symbols: 1,297
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-06-27 08:00:00 | AAPL | Stock | 0.3446 | 0.3446 | 0.3446 | 0.3446 | 5600.0 |
| 2003-06-27 08:45:00 | AAPL | Stock | 0.3446 | 0.3447 | 0.3446 | 0.3446 | 560000.0 |
| 2003-06-27 08:46:00 | AAPL | Stock | 0.3446 | 0.3446 | 0.3446 | 0.3446 | 543200.0 |
| 2003-06-27 09:02:00 | AAPL | Stock | 0.3446 | 0.3446 | 0.3446 | 0.3446 | 33600.0 |
| 2003-06-27 09:07:00 | AAPL | Stock | 0.3446 | 0.3446 | 0.3446 | 0.3446 | 22400.0 |
| 2003-06-27 09:19:00 | AAPL | Stock | 0.3446 | 0.3446 | 0.3446 | 0.3446 | 5600.0 |
| 2003-06-27 09:24:00 | AAPL | Stock | 0.3446 | 0.3446 | 0.3446 | 0.3446 | 117600.0 |
| 2003-06-27 09:29:00 | AAPL | Stock | 0.3455 | 0.3455 | 0.3455 | 0.3455 | 5600.0 |
| 2003-06-27 09:30:00 | AAPL | Stock | 0.3446 | 0.3448 | 0.3411 | 0.3439 | 3068800.0 |
| 2003-06-27 09:31:00 | AAPL | Stock | 0.3414 | 0.3417 | 0.3414 | 0.3414 | 81200.0 |
| 2003-06-27 09:32:00 | AAPL | Stock | 0.3414 | 0.3441 | 0.3411 | 0.3416 | 972776.0 |
| 2003-06-27 09:33:00 | AAPL | Stock | 0.3413 | 0.3421 | 0.3411 | 0.342 | 1259104.0 |
| 2003-06-27 09:34:00 | AAPL | Stock | 0.3418 | 0.3432 | 0.3413 | 0.3421 | 1217720.0 |
| 2003-06-27 09:35:00 | AAPL | Stock | 0.3419 | 0.3423 | 0.3419 | 0.3421 | 453600.0 |
| 2003-06-27 09:36:00 | AAPL | Stock | 0.3418 | 0.3421 | 0.3414 | 0.3414 | 599368.0 |
| 2003-06-27 09:37:00 | AAPL | Stock | 0.3414 | 0.342 | 0.3414 | 0.342 | 1327928.0 |
| 2003-06-27 09:38:00 | AAPL | Stock | 0.342 | 0.3427 | 0.3418 | 0.3423 | 593600.0 |
| 2003-06-27 09:39:00 | AAPL | Stock | 0.3421 | 0.3423 | 0.342 | 0.3423 | 207200.0 |
| 2003-06-27 09:40:00 | AAPL | Stock | 0.3423 | 0.3423 | 0.3421 | 0.3423 | 1209600.0 |
| 2003-06-27 09:41:00 | AAPL | Stock | 0.3423 | 0.3429 | 0.3423 | 0.3425 | 1321600.0 |
| 2003-06-27 09:42:00 | AAPL | Stock | 0.3425 | 0.343 | 0.3423 | 0.3423 | 543200.0 |
| 2003-06-27 09:43:00 | AAPL | Stock | 0.3423 | 0.3425 | 0.3414 | 0.3414 | 1031128.0 |
| 2003-06-27 09:44:00 | AAPL | Stock | 0.3414 | 0.3423 | 0.3411 | 0.3413 | 994000.0 |
| 2003-06-27 09:45:00 | AAPL | Stock | 0.3411 | 0.342 | 0.3407 | 0.342 | 1367912.0 |
| 2003-06-27 09:46:00 | AAPL | Stock | 0.3416 | 0.3418 | 0.3414 | 0.3414 | 1041600.0 |
| 2003-06-27 09:47:00 | AAPL | Stock | 0.3414 | 0.342 | 0.3414 | 0.3418 | 448000.0 |
| 2003-06-27 09:48:00 | AAPL | Stock | 0.3416 | 0.342 | 0.3416 | 0.342 | 2396800.0 |
| 2003-06-27 09:49:00 | AAPL | Stock | 0.342 | 0.3423 | 0.3418 | 0.3418 | 1534400.0 |
| 2003-06-27 09:50:00 | AAPL | Stock | 0.3416 | 0.342 | 0.3409 | 0.3411 | 1624000.0 |
| 2003-06-27 09:51:00 | AAPL | Stock | 0.3411 | 0.3411 | 0.3404 | 0.3407 | 2111200.0 |
| 2003-06-27 09:52:00 | AAPL | Stock | 0.3405 | 0.3407 | 0.3404 | 0.3406 | 375200.0 |
| 2003-06-27 09:53:00 | AAPL | Stock | 0.3413 | 0.3413 | 0.3405 | 0.3407 | 696248.0 |
| 2003-06-27 09:54:00 | AAPL | Stock | 0.3404 | 0.3405 | 0.3396 | 0.3396 | 2396800.0 |
| 2003-06-27 09:55:00 | AAPL | Stock | 0.3396 | 0.3404 | 0.3395 | 0.3396 | 252000.0 |
| 2003-06-27 09:56:00 | AAPL | Stock | 0.3404 | 0.3409 | 0.3397 | 0.3404 | 737352.0 |
| 2003-06-27 09:57:00 | AAPL | Stock | 0.3405 | 0.3407 | 0.3404 | 0.3405 | 106400.0 |
| 2003-06-27 09:58:00 | AAPL | Stock | 0.3406 | 0.3413 | 0.3406 | 0.3411 | 117600.0 |
| 2003-06-27 09:59:00 | AAPL | Stock | 0.3414 | 0.3414 | 0.3404 | 0.3409 | 1859200.0 |
| 2003-06-27 10:00:00 | AAPL | Stock | 0.3405 | 0.3411 | 0.3402 | 0.3411 | 6507200.0 |
| 2003-06-27 10:01:00 | AAPL | Stock | 0.3411 | 0.3411 | 0.3405 | 0.3405 | 532000.0 |
| 2003-06-27 10:02:00 | AAPL | Stock | 0.3407 | 0.3411 | 0.3407 | 0.3411 | 224000.0 |
| 2003-06-27 10:03:00 | AAPL | Stock | 0.3409 | 0.3413 | 0.3409 | 0.3413 | 828800.0 |
| 2003-06-27 10:04:00 | AAPL | Stock | 0.3411 | 0.3414 | 0.3409 | 0.3409 | 935200.0 |
| 2003-06-27 10:05:00 | AAPL | Stock | 0.3409 | 0.3411 | 0.3409 | 0.3409 | 128800.0 |
| 2003-06-27 10:06:00 | AAPL | Stock | 0.3411 | 0.3411 | 0.3409 | 0.3411 | 84000.0 |
| 2003-06-27 10:07:00 | AAPL | Stock | 0.3409 | 0.3413 | 0.3409 | 0.3413 | 660800.0 |
| 2003-06-27 10:08:00 | AAPL | Stock | 0.3411 | 0.3416 | 0.3411 | 0.3414 | 795200.0 |
| 2003-06-27 10:09:00 | AAPL | Stock | 0.3413 | 0.3413 | 0.3409 | 0.3409 | 328720.0 |
| 2003-06-27 10:10:00 | AAPL | Stock | 0.3414 | 0.3414 | 0.3409 | 0.3409 | 6048000.0 |
| 2003-06-27 10:11:00 | AAPL | Stock | 0.3411 | 0.3414 | 0.341 | 0.3413 | 3220000.0 |
> showing 50 of 418,763 rows — these rows as CSV