PREVIEW / stock_5min / 2003-07-11
file: by_date/stock_5min/2003/2003-07-11.parquet size: 2.0 MB rows: 148,338 symbols: 1,580
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-07-11 08:00:00 | AAPL | Stock | 0.3496 | 0.3496 | 0.3496 | 0.3496 | 464800.0 |
| 2003-07-11 09:00:00 | AAPL | Stock | 0.3498 | 0.3498 | 0.3498 | 0.3498 | 89600.0 |
| 2003-07-11 09:20:00 | AAPL | Stock | 0.3511 | 0.3511 | 0.3511 | 0.3511 | 28000.0 |
| 2003-07-11 09:25:00 | AAPL | Stock | 0.3505 | 0.3518 | 0.3505 | 0.3518 | 190400.0 |
| 2003-07-11 09:30:00 | AAPL | Stock | 0.3511 | 0.3554 | 0.3511 | 0.3552 | 6891864.0 |
| 2003-07-11 09:35:00 | AAPL | Stock | 0.3552 | 0.3554 | 0.354 | 0.3548 | 3052392.0 |
| 2003-07-11 09:40:00 | AAPL | Stock | 0.355 | 0.3554 | 0.3513 | 0.3518 | 2699200.0 |
| 2003-07-11 09:45:00 | AAPL | Stock | 0.3518 | 0.3545 | 0.3516 | 0.3541 | 1601600.0 |
| 2003-07-11 09:50:00 | AAPL | Stock | 0.3543 | 0.3552 | 0.3536 | 0.3536 | 1086400.0 |
| 2003-07-11 09:55:00 | AAPL | Stock | 0.3536 | 0.3538 | 0.352 | 0.3525 | 1416800.0 |
| 2003-07-11 10:00:00 | AAPL | Stock | 0.3529 | 0.3538 | 0.352 | 0.352 | 1772904.0 |
| 2003-07-11 10:05:00 | AAPL | Stock | 0.352 | 0.3529 | 0.3513 | 0.3521 | 1775200.0 |
| 2003-07-11 10:10:00 | AAPL | Stock | 0.3521 | 0.3536 | 0.3514 | 0.3536 | 1377600.0 |
| 2003-07-11 10:15:00 | AAPL | Stock | 0.3534 | 0.3543 | 0.3522 | 0.3538 | 1423968.0 |
| 2003-07-11 10:20:00 | AAPL | Stock | 0.3538 | 0.3543 | 0.3534 | 0.3541 | 971768.0 |
| 2003-07-11 10:25:00 | AAPL | Stock | 0.3541 | 0.3566 | 0.3541 | 0.3563 | 3193736.0 |
| 2003-07-11 10:30:00 | AAPL | Stock | 0.3563 | 0.3568 | 0.3546 | 0.3547 | 1826272.0 |
| 2003-07-11 10:35:00 | AAPL | Stock | 0.355 | 0.3555 | 0.3546 | 0.3546 | 2206400.0 |
| 2003-07-11 10:40:00 | AAPL | Stock | 0.3546 | 0.3554 | 0.3546 | 0.3554 | 935200.0 |
| 2003-07-11 10:45:00 | AAPL | Stock | 0.3554 | 0.3563 | 0.3552 | 0.3552 | 1220800.0 |
| 2003-07-11 10:50:00 | AAPL | Stock | 0.3554 | 0.3563 | 0.3548 | 0.3548 | 1892800.0 |
| 2003-07-11 10:55:00 | AAPL | Stock | 0.355 | 0.3554 | 0.3546 | 0.3548 | 1018864.0 |
| 2003-07-11 11:00:00 | AAPL | Stock | 0.3548 | 0.3562 | 0.3548 | 0.3561 | 1135232.0 |
| 2003-07-11 11:05:00 | AAPL | Stock | 0.3559 | 0.3561 | 0.3534 | 0.3541 | 828576.0 |
| 2003-07-11 11:10:00 | AAPL | Stock | 0.3536 | 0.3538 | 0.353 | 0.3538 | 901600.0 |
| 2003-07-11 11:15:00 | AAPL | Stock | 0.3536 | 0.3545 | 0.3534 | 0.3543 | 708400.0 |
| 2003-07-11 11:20:00 | AAPL | Stock | 0.3545 | 0.3545 | 0.3543 | 0.3543 | 375200.0 |
| 2003-07-11 11:25:00 | AAPL | Stock | 0.3545 | 0.3545 | 0.3543 | 0.3545 | 341600.0 |
| 2003-07-11 11:30:00 | AAPL | Stock | 0.3543 | 0.3559 | 0.3543 | 0.3557 | 1344000.0 |
| 2003-07-11 11:35:00 | AAPL | Stock | 0.3555 | 0.3559 | 0.355 | 0.3554 | 722400.0 |
| 2003-07-11 11:40:00 | AAPL | Stock | 0.3552 | 0.3555 | 0.3548 | 0.3548 | 207200.0 |
| 2003-07-11 11:45:00 | AAPL | Stock | 0.3548 | 0.3557 | 0.3546 | 0.3557 | 560000.0 |
| 2003-07-11 11:50:00 | AAPL | Stock | 0.3557 | 0.3566 | 0.3555 | 0.3563 | 1556800.0 |
| 2003-07-11 11:55:00 | AAPL | Stock | 0.3563 | 0.3571 | 0.3563 | 0.3571 | 2550800.0 |
| 2003-07-11 12:00:00 | AAPL | Stock | 0.3568 | 0.3571 | 0.3563 | 0.3564 | 1495200.0 |
| 2003-07-11 12:05:00 | AAPL | Stock | 0.3563 | 0.3563 | 0.355 | 0.355 | 1103200.0 |
| 2003-07-11 12:10:00 | AAPL | Stock | 0.355 | 0.355 | 0.3548 | 0.355 | 247856.0 |
| 2003-07-11 12:15:00 | AAPL | Stock | 0.355 | 0.3553 | 0.3548 | 0.355 | 1276800.0 |
| 2003-07-11 12:20:00 | AAPL | Stock | 0.355 | 0.3557 | 0.3546 | 0.3555 | 1030400.0 |
| 2003-07-11 12:25:00 | AAPL | Stock | 0.3554 | 0.3554 | 0.3536 | 0.3536 | 2602544.0 |
| 2003-07-11 12:30:00 | AAPL | Stock | 0.3536 | 0.3538 | 0.3525 | 0.3527 | 1708448.0 |
| 2003-07-11 12:35:00 | AAPL | Stock | 0.3527 | 0.3527 | 0.3509 | 0.3514 | 2503200.0 |
| 2003-07-11 12:40:00 | AAPL | Stock | 0.3514 | 0.3518 | 0.3514 | 0.3516 | 470400.0 |
| 2003-07-11 12:45:00 | AAPL | Stock | 0.3516 | 0.3525 | 0.3514 | 0.3521 | 1814400.0 |
| 2003-07-11 12:50:00 | AAPL | Stock | 0.3521 | 0.3521 | 0.3505 | 0.3507 | 1271200.0 |
| 2003-07-11 12:55:00 | AAPL | Stock | 0.3507 | 0.3509 | 0.3505 | 0.3505 | 1685600.0 |
| 2003-07-11 13:00:00 | AAPL | Stock | 0.3505 | 0.3509 | 0.3504 | 0.3504 | 4480000.0 |
| 2003-07-11 13:05:00 | AAPL | Stock | 0.3505 | 0.3505 | 0.35 | 0.3502 | 1536696.0 |
| 2003-07-11 13:10:00 | AAPL | Stock | 0.35 | 0.3502 | 0.3488 | 0.3498 | 2710736.0 |
| 2003-07-11 13:15:00 | AAPL | Stock | 0.35 | 0.3509 | 0.35 | 0.3509 | 3621800.0 |
> showing 50 of 148,338 rows — these rows as CSV