PREVIEW / stock_5min / 2001-11-15
file: by_date/stock_5min/2001/2001-11-15.parquet size: 1.6 MB rows: 111,172 symbols: 1,352
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 |
|---|---|---|---|---|---|---|---|
| 2001-11-15 08:00:00 | AAPL | Stock | 0.3503 | 0.3503 | 0.3503 | 0.3503 | 476000.0 |
| 2001-11-15 08:25:00 | AAPL | Stock | 0.3507 | 0.3507 | 0.3507 | 0.3507 | 128800.0 |
| 2001-11-15 08:30:00 | AAPL | Stock | 0.35 | 0.35 | 0.35 | 0.35 | 5600.0 |
| 2001-11-15 09:00:00 | AAPL | Stock | 0.3491 | 0.3491 | 0.3482 | 0.3482 | 89600.0 |
| 2001-11-15 09:05:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3482 | 0.3482 | 28000.0 |
| 2001-11-15 09:15:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3482 | 0.3482 | 67200.0 |
| 2001-11-15 09:20:00 | AAPL | Stock | 0.3484 | 0.3484 | 0.3482 | 0.3482 | 128800.0 |
| 2001-11-15 09:25:00 | AAPL | Stock | 0.348 | 0.3482 | 0.3475 | 0.3475 | 123200.0 |
| 2001-11-15 09:30:00 | AAPL | Stock | 0.3473 | 0.3498 | 0.3461 | 0.3493 | 5236000.0 |
| 2001-11-15 09:35:00 | AAPL | Stock | 0.3493 | 0.3496 | 0.3468 | 0.348 | 4166400.0 |
| 2001-11-15 09:40:00 | AAPL | Stock | 0.348 | 0.3495 | 0.3461 | 0.3461 | 5980800.0 |
| 2001-11-15 09:45:00 | AAPL | Stock | 0.3459 | 0.3466 | 0.3439 | 0.3463 | 4922400.0 |
| 2001-11-15 09:50:00 | AAPL | Stock | 0.3438 | 0.3463 | 0.3434 | 0.3446 | 6809600.0 |
| 2001-11-15 09:55:00 | AAPL | Stock | 0.3443 | 0.3461 | 0.3443 | 0.3452 | 2861600.0 |
| 2001-11-15 10:00:00 | AAPL | Stock | 0.3453 | 0.3464 | 0.3441 | 0.3461 | 1506400.0 |
| 2001-11-15 10:05:00 | AAPL | Stock | 0.3464 | 0.3482 | 0.3457 | 0.3475 | 2660000.0 |
| 2001-11-15 10:10:00 | AAPL | Stock | 0.3475 | 0.35 | 0.3473 | 0.3482 | 2475200.0 |
| 2001-11-15 10:15:00 | AAPL | Stock | 0.3486 | 0.3518 | 0.3486 | 0.3516 | 3595200.0 |
| 2001-11-15 10:20:00 | AAPL | Stock | 0.3516 | 0.3521 | 0.3484 | 0.3486 | 3113600.0 |
| 2001-11-15 10:25:00 | AAPL | Stock | 0.3486 | 0.3509 | 0.3484 | 0.3502 | 1047200.0 |
| 2001-11-15 10:30:00 | AAPL | Stock | 0.3502 | 0.3534 | 0.3498 | 0.3525 | 2704800.0 |
| 2001-11-15 10:35:00 | AAPL | Stock | 0.3527 | 0.3545 | 0.3525 | 0.3545 | 4620000.0 |
| 2001-11-15 10:40:00 | AAPL | Stock | 0.3539 | 0.3546 | 0.3532 | 0.3532 | 2363200.0 |
| 2001-11-15 10:45:00 | AAPL | Stock | 0.3539 | 0.3554 | 0.353 | 0.3545 | 3309600.0 |
| 2001-11-15 10:50:00 | AAPL | Stock | 0.3552 | 0.3552 | 0.3534 | 0.3545 | 1428000.0 |
| 2001-11-15 10:55:00 | AAPL | Stock | 0.3545 | 0.3552 | 0.3536 | 0.3536 | 2402400.0 |
| 2001-11-15 11:00:00 | AAPL | Stock | 0.3536 | 0.3554 | 0.3536 | 0.3536 | 3276000.0 |
| 2001-11-15 11:05:00 | AAPL | Stock | 0.3536 | 0.3548 | 0.3525 | 0.3536 | 11765600.0 |
| 2001-11-15 11:10:00 | AAPL | Stock | 0.3531 | 0.3552 | 0.3516 | 0.352 | 3309600.0 |
| 2001-11-15 11:15:00 | AAPL | Stock | 0.3518 | 0.3527 | 0.3507 | 0.3507 | 3130400.0 |
| 2001-11-15 11:20:00 | AAPL | Stock | 0.3509 | 0.3525 | 0.3498 | 0.3523 | 1590400.0 |
| 2001-11-15 11:25:00 | AAPL | Stock | 0.3523 | 0.3523 | 0.3504 | 0.3516 | 599200.0 |
| 2001-11-15 11:30:00 | AAPL | Stock | 0.3513 | 0.3513 | 0.3493 | 0.3502 | 1713600.0 |
| 2001-11-15 11:35:00 | AAPL | Stock | 0.3502 | 0.3516 | 0.3497 | 0.3505 | 1170400.0 |
| 2001-11-15 11:40:00 | AAPL | Stock | 0.3505 | 0.3516 | 0.35 | 0.3502 | 420000.0 |
| 2001-11-15 11:45:00 | AAPL | Stock | 0.35 | 0.3505 | 0.35 | 0.35 | 560000.0 |
| 2001-11-15 11:50:00 | AAPL | Stock | 0.3504 | 0.3521 | 0.3495 | 0.3514 | 2178400.0 |
| 2001-11-15 11:55:00 | AAPL | Stock | 0.3514 | 0.3514 | 0.35 | 0.35 | 380800.0 |
| 2001-11-15 12:00:00 | AAPL | Stock | 0.35 | 0.3532 | 0.3496 | 0.3498 | 1999200.0 |
| 2001-11-15 12:05:00 | AAPL | Stock | 0.3498 | 0.3498 | 0.3482 | 0.3482 | 2178400.0 |
| 2001-11-15 12:10:00 | AAPL | Stock | 0.3482 | 0.3495 | 0.348 | 0.3489 | 1248800.0 |
| 2001-11-15 12:15:00 | AAPL | Stock | 0.3489 | 0.3509 | 0.3487 | 0.3502 | 1982400.0 |
| 2001-11-15 12:20:00 | AAPL | Stock | 0.3507 | 0.3507 | 0.3491 | 0.3502 | 1545600.0 |
| 2001-11-15 12:25:00 | AAPL | Stock | 0.3502 | 0.3525 | 0.3496 | 0.3516 | 3298400.0 |
| 2001-11-15 12:30:00 | AAPL | Stock | 0.3518 | 0.3534 | 0.3509 | 0.3518 | 4597600.0 |
| 2001-11-15 12:35:00 | AAPL | Stock | 0.3514 | 0.3518 | 0.3491 | 0.3514 | 6899200.0 |
| 2001-11-15 12:40:00 | AAPL | Stock | 0.3514 | 0.3518 | 0.3495 | 0.3518 | 4250400.0 |
| 2001-11-15 12:45:00 | AAPL | Stock | 0.3518 | 0.3518 | 0.3514 | 0.3514 | 716800.0 |
| 2001-11-15 12:50:00 | AAPL | Stock | 0.3511 | 0.3514 | 0.35 | 0.3513 | 1030400.0 |
| 2001-11-15 12:55:00 | AAPL | Stock | 0.3507 | 0.353 | 0.3507 | 0.3525 | 2520000.0 |
> showing 50 of 111,172 rows — these rows as CSV