PREVIEW / stock_5min / 2003-08-08
file: by_date/stock_5min/2003/2003-08-08.parquet size: 2.0 MB rows: 144,692 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-08 08:55:00 | AAPL | Stock | 0.3561 | 0.3561 | 0.3561 | 0.3561 | 1848000.0 |
| 2003-08-08 09:05:00 | AAPL | Stock | 0.357 | 0.357 | 0.357 | 0.357 | 28000.0 |
| 2003-08-08 09:15:00 | AAPL | Stock | 0.357 | 0.357 | 0.357 | 0.357 | 5600.0 |
| 2003-08-08 09:25:00 | AAPL | Stock | 0.3573 | 0.3584 | 0.3563 | 0.3582 | 313600.0 |
| 2003-08-08 09:30:00 | AAPL | Stock | 0.3591 | 0.3595 | 0.3546 | 0.355 | 4538408.0 |
| 2003-08-08 09:35:00 | AAPL | Stock | 0.3552 | 0.3575 | 0.3538 | 0.3543 | 1603672.0 |
| 2003-08-08 09:40:00 | AAPL | Stock | 0.3539 | 0.3543 | 0.3523 | 0.3525 | 2809128.0 |
| 2003-08-08 09:45:00 | AAPL | Stock | 0.3525 | 0.355 | 0.3525 | 0.3546 | 1243200.0 |
| 2003-08-08 09:50:00 | AAPL | Stock | 0.3545 | 0.3557 | 0.3543 | 0.3554 | 1349600.0 |
| 2003-08-08 09:55:00 | AAPL | Stock | 0.3555 | 0.3564 | 0.355 | 0.355 | 1299984.0 |
| 2003-08-08 10:00:00 | AAPL | Stock | 0.355 | 0.3564 | 0.3548 | 0.3564 | 1327200.0 |
| 2003-08-08 10:05:00 | AAPL | Stock | 0.3563 | 0.3564 | 0.3546 | 0.355 | 1584240.0 |
| 2003-08-08 10:10:00 | AAPL | Stock | 0.3548 | 0.3548 | 0.3545 | 0.3546 | 940800.0 |
| 2003-08-08 10:15:00 | AAPL | Stock | 0.3546 | 0.3555 | 0.3546 | 0.3548 | 1988000.0 |
| 2003-08-08 10:20:00 | AAPL | Stock | 0.3548 | 0.355 | 0.3545 | 0.3545 | 1022000.0 |
| 2003-08-08 10:25:00 | AAPL | Stock | 0.3546 | 0.355 | 0.3545 | 0.355 | 864976.0 |
| 2003-08-08 10:30:00 | AAPL | Stock | 0.3552 | 0.3557 | 0.355 | 0.3555 | 1866928.0 |
| 2003-08-08 10:35:00 | AAPL | Stock | 0.3554 | 0.3557 | 0.3552 | 0.3552 | 935200.0 |
| 2003-08-08 10:40:00 | AAPL | Stock | 0.3552 | 0.3552 | 0.3545 | 0.3547 | 445816.0 |
| 2003-08-08 10:45:00 | AAPL | Stock | 0.3546 | 0.3549 | 0.3545 | 0.3546 | 1674512.0 |
| 2003-08-08 10:50:00 | AAPL | Stock | 0.3548 | 0.3557 | 0.3548 | 0.355 | 1002400.0 |
| 2003-08-08 10:55:00 | AAPL | Stock | 0.355 | 0.355 | 0.3521 | 0.3523 | 2287768.0 |
| 2003-08-08 11:00:00 | AAPL | Stock | 0.3525 | 0.3539 | 0.3516 | 0.3539 | 6153168.0 |
| 2003-08-08 11:05:00 | AAPL | Stock | 0.3539 | 0.3548 | 0.3534 | 0.3534 | 2743440.0 |
| 2003-08-08 11:10:00 | AAPL | Stock | 0.3536 | 0.3545 | 0.352 | 0.352 | 1696912.0 |
| 2003-08-08 11:15:00 | AAPL | Stock | 0.3521 | 0.3527 | 0.3516 | 0.3516 | 2353176.0 |
| 2003-08-08 11:20:00 | AAPL | Stock | 0.3517 | 0.353 | 0.3516 | 0.3521 | 1889832.0 |
| 2003-08-08 11:25:00 | AAPL | Stock | 0.3525 | 0.3529 | 0.3521 | 0.3525 | 991200.0 |
| 2003-08-08 11:30:00 | AAPL | Stock | 0.3529 | 0.3529 | 0.3525 | 0.3527 | 854728.0 |
| 2003-08-08 11:35:00 | AAPL | Stock | 0.3527 | 0.3541 | 0.3527 | 0.3541 | 885472.0 |
| 2003-08-08 11:40:00 | AAPL | Stock | 0.3539 | 0.3539 | 0.3534 | 0.3536 | 801528.0 |
| 2003-08-08 11:45:00 | AAPL | Stock | 0.3536 | 0.3545 | 0.3532 | 0.3543 | 1730400.0 |
| 2003-08-08 11:50:00 | AAPL | Stock | 0.3541 | 0.3543 | 0.3529 | 0.3529 | 668528.0 |
| 2003-08-08 11:55:00 | AAPL | Stock | 0.353 | 0.3532 | 0.3529 | 0.353 | 324800.0 |
| 2003-08-08 12:00:00 | AAPL | Stock | 0.353 | 0.3532 | 0.3521 | 0.3521 | 1259832.0 |
| 2003-08-08 12:05:00 | AAPL | Stock | 0.3521 | 0.3527 | 0.352 | 0.3525 | 464800.0 |
| 2003-08-08 12:10:00 | AAPL | Stock | 0.3525 | 0.3534 | 0.3525 | 0.3532 | 1019200.0 |
| 2003-08-08 12:15:00 | AAPL | Stock | 0.3532 | 0.3532 | 0.353 | 0.353 | 436296.0 |
| 2003-08-08 12:20:00 | AAPL | Stock | 0.353 | 0.353 | 0.3523 | 0.3523 | 729008.0 |
| 2003-08-08 12:25:00 | AAPL | Stock | 0.3523 | 0.3525 | 0.3518 | 0.3518 | 602000.0 |
| 2003-08-08 12:30:00 | AAPL | Stock | 0.352 | 0.3523 | 0.3516 | 0.3518 | 671104.0 |
| 2003-08-08 12:35:00 | AAPL | Stock | 0.3518 | 0.3523 | 0.3517 | 0.3521 | 901600.0 |
| 2003-08-08 12:40:00 | AAPL | Stock | 0.3523 | 0.3538 | 0.3523 | 0.3536 | 798560.0 |
| 2003-08-08 12:45:00 | AAPL | Stock | 0.3536 | 0.3536 | 0.3521 | 0.3521 | 784000.0 |
| 2003-08-08 12:50:00 | AAPL | Stock | 0.3521 | 0.3521 | 0.3518 | 0.352 | 341600.0 |
| 2003-08-08 12:55:00 | AAPL | Stock | 0.3521 | 0.3523 | 0.3518 | 0.3521 | 800800.0 |
| 2003-08-08 13:00:00 | AAPL | Stock | 0.3521 | 0.353 | 0.3521 | 0.353 | 940800.0 |
| 2003-08-08 13:05:00 | AAPL | Stock | 0.3528 | 0.3532 | 0.3526 | 0.3527 | 1036000.0 |
| 2003-08-08 13:10:00 | AAPL | Stock | 0.3527 | 0.3536 | 0.3525 | 0.3525 | 828800.0 |
| 2003-08-08 13:15:00 | AAPL | Stock | 0.3527 | 0.3532 | 0.3527 | 0.353 | 408800.0 |
> showing 50 of 144,692 rows — these rows as CSV