PREVIEW / stock_1min / 2002-06-14
file: by_date/stock_1min/2002/2002-06-14.parquet size: 4.4 MB rows: 342,731 symbols: 1,182
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 |
|---|---|---|---|---|---|---|---|
| 2002-06-14 08:06:00 | AAPL | Stock | 0.35 | 0.35 | 0.3448 | 0.3448 | 28000.0 |
| 2002-06-14 08:11:00 | AAPL | Stock | 0.3473 | 0.3473 | 0.3473 | 0.3473 | 50400.0 |
| 2002-06-14 08:17:00 | AAPL | Stock | 0.3464 | 0.3464 | 0.3464 | 0.3464 | 5600.0 |
| 2002-06-14 08:19:00 | AAPL | Stock | 0.3464 | 0.3464 | 0.3463 | 0.3463 | 50400.0 |
| 2002-06-14 08:23:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.348 | 0.3482 | 50400.0 |
| 2002-06-14 08:25:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3482 | 0.3482 | 280000.0 |
| 2002-06-14 08:39:00 | AAPL | Stock | 0.347 | 0.347 | 0.347 | 0.347 | 61600.0 |
| 2002-06-14 08:43:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3482 | 0.3482 | 16800.0 |
| 2002-06-14 08:45:00 | AAPL | Stock | 0.3464 | 0.3464 | 0.3464 | 0.3464 | 22400.0 |
| 2002-06-14 08:50:00 | AAPL | Stock | 0.347 | 0.347 | 0.3464 | 0.3464 | 56000.0 |
| 2002-06-14 08:55:00 | AAPL | Stock | 0.3464 | 0.3464 | 0.3464 | 0.3464 | 28000.0 |
| 2002-06-14 08:56:00 | AAPL | Stock | 0.3464 | 0.3464 | 0.3464 | 0.3464 | 61600.0 |
| 2002-06-14 08:57:00 | AAPL | Stock | 0.3464 | 0.3464 | 0.3464 | 0.3464 | 39200.0 |
| 2002-06-14 09:00:00 | AAPL | Stock | 0.3465 | 0.3465 | 0.3465 | 0.3465 | 11200.0 |
| 2002-06-14 09:07:00 | AAPL | Stock | 0.3465 | 0.3465 | 0.3464 | 0.3464 | 16800.0 |
| 2002-06-14 09:11:00 | AAPL | Stock | 0.3461 | 0.3461 | 0.3455 | 0.3455 | 89600.0 |
| 2002-06-14 09:12:00 | AAPL | Stock | 0.3464 | 0.3464 | 0.3464 | 0.3464 | 16800.0 |
| 2002-06-14 09:15:00 | AAPL | Stock | 0.3452 | 0.3452 | 0.3446 | 0.3446 | 67200.0 |
| 2002-06-14 09:16:00 | AAPL | Stock | 0.3445 | 0.3445 | 0.3438 | 0.3438 | 33600.0 |
| 2002-06-14 09:19:00 | AAPL | Stock | 0.3445 | 0.3445 | 0.3429 | 0.3429 | 11200.0 |
| 2002-06-14 09:21:00 | AAPL | Stock | 0.3461 | 0.3489 | 0.3461 | 0.3489 | 414400.0 |
| 2002-06-14 09:25:00 | AAPL | Stock | 0.3438 | 0.3443 | 0.3434 | 0.3434 | 156800.0 |
| 2002-06-14 09:26:00 | AAPL | Stock | 0.3434 | 0.3434 | 0.3434 | 0.3434 | 56000.0 |
| 2002-06-14 09:27:00 | AAPL | Stock | 0.342 | 0.3423 | 0.3411 | 0.3423 | 156800.0 |
| 2002-06-14 09:29:00 | AAPL | Stock | 0.3434 | 0.3436 | 0.3434 | 0.3436 | 44800.0 |
| 2002-06-14 09:30:00 | AAPL | Stock | 0.3436 | 0.3436 | 0.3418 | 0.3429 | 3180800.0 |
| 2002-06-14 09:31:00 | AAPL | Stock | 0.3429 | 0.3429 | 0.3416 | 0.3427 | 3354400.0 |
| 2002-06-14 09:32:00 | AAPL | Stock | 0.3436 | 0.3436 | 0.3396 | 0.3396 | 2497600.0 |
| 2002-06-14 09:33:00 | AAPL | Stock | 0.3405 | 0.3425 | 0.3395 | 0.3412 | 1164800.0 |
| 2002-06-14 09:34:00 | AAPL | Stock | 0.3409 | 0.3413 | 0.3404 | 0.3411 | 1215200.0 |
| 2002-06-14 09:35:00 | AAPL | Stock | 0.3411 | 0.342 | 0.3405 | 0.342 | 308000.0 |
| 2002-06-14 09:36:00 | AAPL | Stock | 0.342 | 0.3432 | 0.3418 | 0.3432 | 862400.0 |
| 2002-06-14 09:37:00 | AAPL | Stock | 0.3432 | 0.3441 | 0.3429 | 0.3438 | 2172800.0 |
| 2002-06-14 09:38:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3416 | 0.342 | 862400.0 |
| 2002-06-14 09:39:00 | AAPL | Stock | 0.342 | 0.3423 | 0.3413 | 0.3418 | 812000.0 |
| 2002-06-14 09:40:00 | AAPL | Stock | 0.342 | 0.3436 | 0.3414 | 0.3434 | 588000.0 |
| 2002-06-14 09:41:00 | AAPL | Stock | 0.3423 | 0.3434 | 0.3423 | 0.3425 | 504000.0 |
| 2002-06-14 09:42:00 | AAPL | Stock | 0.343 | 0.3432 | 0.3425 | 0.343 | 1299200.0 |
| 2002-06-14 09:43:00 | AAPL | Stock | 0.343 | 0.343 | 0.3423 | 0.3423 | 420000.0 |
| 2002-06-14 09:44:00 | AAPL | Stock | 0.3423 | 0.3425 | 0.3411 | 0.3413 | 957600.0 |
| 2002-06-14 09:45:00 | AAPL | Stock | 0.3413 | 0.3423 | 0.3411 | 0.3421 | 851200.0 |
| 2002-06-14 09:46:00 | AAPL | Stock | 0.3421 | 0.3421 | 0.3418 | 0.342 | 268800.0 |
| 2002-06-14 09:47:00 | AAPL | Stock | 0.3419 | 0.342 | 0.3419 | 0.342 | 224000.0 |
| 2002-06-14 09:48:00 | AAPL | Stock | 0.342 | 0.342 | 0.3418 | 0.3418 | 487200.0 |
| 2002-06-14 09:49:00 | AAPL | Stock | 0.342 | 0.342 | 0.3418 | 0.342 | 414400.0 |
| 2002-06-14 09:50:00 | AAPL | Stock | 0.342 | 0.3421 | 0.3418 | 0.3421 | 1456000.0 |
| 2002-06-14 09:51:00 | AAPL | Stock | 0.3421 | 0.3421 | 0.3404 | 0.3407 | 2609600.0 |
| 2002-06-14 09:52:00 | AAPL | Stock | 0.3407 | 0.3407 | 0.3388 | 0.3402 | 3488800.0 |
| 2002-06-14 09:53:00 | AAPL | Stock | 0.3404 | 0.3405 | 0.3382 | 0.3382 | 1870400.0 |
| 2002-06-14 09:54:00 | AAPL | Stock | 0.338 | 0.3384 | 0.3348 | 0.3348 | 2676800.0 |
> showing 50 of 342,731 rows — these rows as CSV