PREVIEW / stock_5min / 2001-11-21
file: by_date/stock_5min/2001/2001-11-21.parquet size: 1.5 MB rows: 104,574 symbols: 1,353
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-21 08:00:00 | AAPL | Stock | 0.3495 | 0.3495 | 0.3495 | 0.3495 | 263200.0 |
| 2001-11-21 08:10:00 | AAPL | Stock | 0.3464 | 0.3464 | 0.3438 | 0.3446 | 33600.0 |
| 2001-11-21 08:15:00 | AAPL | Stock | 0.3446 | 0.3446 | 0.3446 | 0.3446 | 39200.0 |
| 2001-11-21 08:20:00 | AAPL | Stock | 0.3446 | 0.3446 | 0.3446 | 0.3446 | 140000.0 |
| 2001-11-21 08:25:00 | AAPL | Stock | 0.3446 | 0.3446 | 0.3446 | 0.3446 | 95200.0 |
| 2001-11-21 08:30:00 | AAPL | Stock | 0.3463 | 0.3491 | 0.3463 | 0.3484 | 263200.0 |
| 2001-11-21 08:55:00 | AAPL | Stock | 0.3484 | 0.3495 | 0.3484 | 0.3495 | 72800.0 |
| 2001-11-21 09:15:00 | AAPL | Stock | 0.3484 | 0.3484 | 0.3484 | 0.3484 | 11200.0 |
| 2001-11-21 09:20:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3482 | 0.3482 | 16800.0 |
| 2001-11-21 09:25:00 | AAPL | Stock | 0.3482 | 0.3511 | 0.3482 | 0.3493 | 963200.0 |
| 2001-11-21 09:30:00 | AAPL | Stock | 0.3502 | 0.3514 | 0.3482 | 0.3513 | 6367200.0 |
| 2001-11-21 09:35:00 | AAPL | Stock | 0.3513 | 0.3536 | 0.3509 | 0.3529 | 3113600.0 |
| 2001-11-21 09:40:00 | AAPL | Stock | 0.3527 | 0.3536 | 0.3504 | 0.3513 | 1500800.0 |
| 2001-11-21 09:45:00 | AAPL | Stock | 0.3513 | 0.3532 | 0.3505 | 0.3507 | 2396800.0 |
| 2001-11-21 09:50:00 | AAPL | Stock | 0.3509 | 0.3509 | 0.3486 | 0.3488 | 4849600.0 |
| 2001-11-21 09:55:00 | AAPL | Stock | 0.3491 | 0.3507 | 0.3489 | 0.3502 | 2721600.0 |
| 2001-11-21 10:00:00 | AAPL | Stock | 0.35 | 0.35 | 0.3486 | 0.3488 | 1640800.0 |
| 2001-11-21 10:05:00 | AAPL | Stock | 0.3486 | 0.352 | 0.3482 | 0.3513 | 3936800.0 |
| 2001-11-21 10:10:00 | AAPL | Stock | 0.3513 | 0.3531 | 0.3495 | 0.353 | 4816000.0 |
| 2001-11-21 10:15:00 | AAPL | Stock | 0.353 | 0.3534 | 0.3511 | 0.3511 | 3085600.0 |
| 2001-11-21 10:20:00 | AAPL | Stock | 0.3509 | 0.3518 | 0.3491 | 0.3496 | 2928800.0 |
| 2001-11-21 10:25:00 | AAPL | Stock | 0.3493 | 0.3509 | 0.3493 | 0.3502 | 3724000.0 |
| 2001-11-21 10:30:00 | AAPL | Stock | 0.3504 | 0.3504 | 0.3466 | 0.3466 | 2144800.0 |
| 2001-11-21 10:35:00 | AAPL | Stock | 0.3466 | 0.3489 | 0.3464 | 0.3464 | 4592000.0 |
| 2001-11-21 10:40:00 | AAPL | Stock | 0.3464 | 0.3473 | 0.3448 | 0.3463 | 2704800.0 |
| 2001-11-21 10:45:00 | AAPL | Stock | 0.3463 | 0.3477 | 0.3455 | 0.3455 | 2133600.0 |
| 2001-11-21 10:50:00 | AAPL | Stock | 0.3455 | 0.3461 | 0.3446 | 0.3448 | 2884000.0 |
| 2001-11-21 10:55:00 | AAPL | Stock | 0.3454 | 0.3463 | 0.3453 | 0.3454 | 1428000.0 |
| 2001-11-21 11:00:00 | AAPL | Stock | 0.3457 | 0.3464 | 0.3439 | 0.3461 | 2654400.0 |
| 2001-11-21 11:05:00 | AAPL | Stock | 0.3459 | 0.347 | 0.3459 | 0.3469 | 3158400.0 |
| 2001-11-21 11:10:00 | AAPL | Stock | 0.3468 | 0.347 | 0.3463 | 0.347 | 1797600.0 |
| 2001-11-21 11:15:00 | AAPL | Stock | 0.3473 | 0.3486 | 0.3473 | 0.3477 | 1590400.0 |
| 2001-11-21 11:20:00 | AAPL | Stock | 0.3473 | 0.348 | 0.3471 | 0.3473 | 2195200.0 |
| 2001-11-21 11:25:00 | AAPL | Stock | 0.3475 | 0.3486 | 0.3475 | 0.3486 | 621600.0 |
| 2001-11-21 11:30:00 | AAPL | Stock | 0.3486 | 0.35 | 0.348 | 0.3493 | 2464000.0 |
| 2001-11-21 11:35:00 | AAPL | Stock | 0.3494 | 0.3502 | 0.3491 | 0.3502 | 1400000.0 |
| 2001-11-21 11:40:00 | AAPL | Stock | 0.3504 | 0.3504 | 0.3495 | 0.3495 | 4608800.0 |
| 2001-11-21 11:45:00 | AAPL | Stock | 0.3493 | 0.3496 | 0.3482 | 0.3489 | 1523200.0 |
| 2001-11-21 11:50:00 | AAPL | Stock | 0.3488 | 0.3488 | 0.3475 | 0.3475 | 3628800.0 |
| 2001-11-21 11:55:00 | AAPL | Stock | 0.3475 | 0.3477 | 0.3471 | 0.3471 | 364000.0 |
| 2001-11-21 12:00:00 | AAPL | Stock | 0.3471 | 0.3477 | 0.3468 | 0.3471 | 644000.0 |
| 2001-11-21 12:05:00 | AAPL | Stock | 0.3471 | 0.3495 | 0.3471 | 0.3477 | 1444800.0 |
| 2001-11-21 12:10:00 | AAPL | Stock | 0.3479 | 0.3482 | 0.3473 | 0.3475 | 1556800.0 |
| 2001-11-21 12:15:00 | AAPL | Stock | 0.3475 | 0.3484 | 0.3475 | 0.3479 | 1114400.0 |
| 2001-11-21 12:20:00 | AAPL | Stock | 0.348 | 0.3495 | 0.3479 | 0.3482 | 660800.0 |
| 2001-11-21 12:25:00 | AAPL | Stock | 0.3489 | 0.3491 | 0.3484 | 0.3484 | 117600.0 |
| 2001-11-21 12:30:00 | AAPL | Stock | 0.3486 | 0.3491 | 0.3486 | 0.3489 | 952000.0 |
| 2001-11-21 12:35:00 | AAPL | Stock | 0.3489 | 0.3495 | 0.3482 | 0.3495 | 4205600.0 |
| 2001-11-21 12:40:00 | AAPL | Stock | 0.3495 | 0.3495 | 0.3482 | 0.3489 | 2363200.0 |
| 2001-11-21 12:45:00 | AAPL | Stock | 0.3491 | 0.3491 | 0.3482 | 0.3482 | 3757600.0 |
> showing 50 of 104,574 rows — these rows as CSV