PREVIEW / stock_5min / 2003-08-06
file: by_date/stock_5min/2003/2003-08-06.parquet size: 2.1 MB rows: 152,381 symbols: 1,597
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-08-06 08:30:00 | AAPL | Stock | 0.3632 | 0.3639 | 0.3632 | 0.3639 | 112000.0 |
| 2003-08-06 09:10:00 | AAPL | Stock | 0.3627 | 0.3627 | 0.3627 | 0.3627 | 11200.0 |
| 2003-08-06 09:20:00 | AAPL | Stock | 0.3632 | 0.3639 | 0.3632 | 0.3639 | 61600.0 |
| 2003-08-06 09:25:00 | AAPL | Stock | 0.3634 | 0.3639 | 0.3589 | 0.3593 | 1114400.0 |
| 2003-08-06 09:30:00 | AAPL | Stock | 0.3582 | 0.3602 | 0.357 | 0.3575 | 11579120.0 |
| 2003-08-06 09:35:00 | AAPL | Stock | 0.3579 | 0.3596 | 0.3571 | 0.3583 | 2962400.0 |
| 2003-08-06 09:40:00 | AAPL | Stock | 0.3584 | 0.3598 | 0.3573 | 0.3575 | 2531200.0 |
| 2003-08-06 09:45:00 | AAPL | Stock | 0.3579 | 0.3602 | 0.3573 | 0.3593 | 2015216.0 |
| 2003-08-06 09:50:00 | AAPL | Stock | 0.3595 | 0.3595 | 0.3563 | 0.357 | 3178896.0 |
| 2003-08-06 09:55:00 | AAPL | Stock | 0.357 | 0.3575 | 0.3563 | 0.3571 | 4351200.0 |
| 2003-08-06 10:00:00 | AAPL | Stock | 0.3573 | 0.358 | 0.3571 | 0.3577 | 3701600.0 |
| 2003-08-06 10:05:00 | AAPL | Stock | 0.3577 | 0.3593 | 0.3566 | 0.3568 | 6347208.0 |
| 2003-08-06 10:10:00 | AAPL | Stock | 0.3566 | 0.3571 | 0.3529 | 0.3529 | 5006400.0 |
| 2003-08-06 10:15:00 | AAPL | Stock | 0.3529 | 0.3529 | 0.3505 | 0.3514 | 8004920.0 |
| 2003-08-06 10:20:00 | AAPL | Stock | 0.3514 | 0.3527 | 0.3496 | 0.3496 | 3267096.0 |
| 2003-08-06 10:25:00 | AAPL | Stock | 0.3495 | 0.3498 | 0.3482 | 0.3491 | 6133680.0 |
| 2003-08-06 10:30:00 | AAPL | Stock | 0.3489 | 0.3502 | 0.3482 | 0.3501 | 5265624.0 |
| 2003-08-06 10:35:00 | AAPL | Stock | 0.3502 | 0.3518 | 0.3502 | 0.3511 | 3482696.0 |
| 2003-08-06 10:40:00 | AAPL | Stock | 0.3511 | 0.3511 | 0.3502 | 0.3511 | 2044000.0 |
| 2003-08-06 10:45:00 | AAPL | Stock | 0.3511 | 0.3527 | 0.3509 | 0.3518 | 3708544.0 |
| 2003-08-06 10:50:00 | AAPL | Stock | 0.3518 | 0.3521 | 0.3498 | 0.3498 | 1782536.0 |
| 2003-08-06 10:55:00 | AAPL | Stock | 0.3498 | 0.3498 | 0.3489 | 0.3496 | 3852800.0 |
| 2003-08-06 11:00:00 | AAPL | Stock | 0.3496 | 0.3496 | 0.3491 | 0.3493 | 2592800.0 |
| 2003-08-06 11:05:00 | AAPL | Stock | 0.3493 | 0.3495 | 0.3486 | 0.3488 | 3776640.0 |
| 2003-08-06 11:10:00 | AAPL | Stock | 0.3488 | 0.3493 | 0.3488 | 0.3491 | 2828000.0 |
| 2003-08-06 11:15:00 | AAPL | Stock | 0.3493 | 0.3496 | 0.3491 | 0.3495 | 1293600.0 |
| 2003-08-06 11:20:00 | AAPL | Stock | 0.3495 | 0.3496 | 0.3484 | 0.3486 | 2430960.0 |
| 2003-08-06 11:25:00 | AAPL | Stock | 0.3489 | 0.3496 | 0.3489 | 0.3495 | 2416456.0 |
| 2003-08-06 11:30:00 | AAPL | Stock | 0.3495 | 0.35 | 0.3495 | 0.35 | 1943200.0 |
| 2003-08-06 11:35:00 | AAPL | Stock | 0.35 | 0.3511 | 0.35 | 0.3511 | 4158672.0 |
| 2003-08-06 11:40:00 | AAPL | Stock | 0.3509 | 0.3513 | 0.3509 | 0.3511 | 1592640.0 |
| 2003-08-06 11:45:00 | AAPL | Stock | 0.3513 | 0.3513 | 0.3507 | 0.3507 | 1456000.0 |
| 2003-08-06 11:50:00 | AAPL | Stock | 0.3507 | 0.3507 | 0.3491 | 0.3493 | 1058400.0 |
| 2003-08-06 11:55:00 | AAPL | Stock | 0.3493 | 0.35 | 0.3491 | 0.35 | 1937600.0 |
| 2003-08-06 12:00:00 | AAPL | Stock | 0.35 | 0.3509 | 0.35 | 0.3509 | 1304800.0 |
| 2003-08-06 12:05:00 | AAPL | Stock | 0.3505 | 0.353 | 0.3505 | 0.3516 | 5406352.0 |
| 2003-08-06 12:10:00 | AAPL | Stock | 0.3514 | 0.3518 | 0.3513 | 0.3518 | 1008000.0 |
| 2003-08-06 12:15:00 | AAPL | Stock | 0.3518 | 0.352 | 0.3514 | 0.3518 | 1920800.0 |
| 2003-08-06 12:20:00 | AAPL | Stock | 0.3518 | 0.3519 | 0.3516 | 0.3518 | 409416.0 |
| 2003-08-06 12:25:00 | AAPL | Stock | 0.3516 | 0.352 | 0.3513 | 0.3518 | 2958200.0 |
| 2003-08-06 12:30:00 | AAPL | Stock | 0.3518 | 0.3529 | 0.3518 | 0.3518 | 2872800.0 |
| 2003-08-06 12:35:00 | AAPL | Stock | 0.3521 | 0.3521 | 0.3511 | 0.3516 | 803880.0 |
| 2003-08-06 12:40:00 | AAPL | Stock | 0.3516 | 0.3521 | 0.3516 | 0.3521 | 806400.0 |
| 2003-08-06 12:45:00 | AAPL | Stock | 0.3521 | 0.3521 | 0.352 | 0.3521 | 442400.0 |
| 2003-08-06 12:50:00 | AAPL | Stock | 0.3521 | 0.3521 | 0.3518 | 0.3521 | 593600.0 |
| 2003-08-06 12:55:00 | AAPL | Stock | 0.3521 | 0.3523 | 0.352 | 0.352 | 756000.0 |
| 2003-08-06 13:00:00 | AAPL | Stock | 0.3521 | 0.3529 | 0.3518 | 0.3523 | 1932056.0 |
| 2003-08-06 13:05:00 | AAPL | Stock | 0.3525 | 0.3529 | 0.3523 | 0.3529 | 961520.0 |
| 2003-08-06 13:10:00 | AAPL | Stock | 0.3525 | 0.3527 | 0.3523 | 0.3527 | 487200.0 |
| 2003-08-06 13:15:00 | AAPL | Stock | 0.3525 | 0.3527 | 0.3523 | 0.3527 | 414400.0 |
> showing 50 of 152,381 rows — these rows as CSV