PREVIEW / stock_5min / 2003-07-10
file: by_date/stock_5min/2003/2003-07-10.parquet size: 2.2 MB rows: 155,142 symbols: 1,589
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-10 08:00:00 | AAPL | Stock | 0.3545 | 0.3545 | 0.3545 | 0.3545 | 123200.0 |
| 2003-07-10 08:20:00 | AAPL | Stock | 0.3545 | 0.3545 | 0.3545 | 0.3545 | 11200.0 |
| 2003-07-10 08:30:00 | AAPL | Stock | 0.3545 | 0.3545 | 0.3545 | 0.3545 | 5600.0 |
| 2003-07-10 09:15:00 | AAPL | Stock | 0.3527 | 0.3527 | 0.3527 | 0.3527 | 112000.0 |
| 2003-07-10 09:20:00 | AAPL | Stock | 0.3536 | 0.3552 | 0.3536 | 0.355 | 229600.0 |
| 2003-07-10 09:25:00 | AAPL | Stock | 0.355 | 0.3552 | 0.3541 | 0.3552 | 442400.0 |
| 2003-07-10 09:30:00 | AAPL | Stock | 0.3559 | 0.3561 | 0.3527 | 0.3547 | 5278000.0 |
| 2003-07-10 09:35:00 | AAPL | Stock | 0.3546 | 0.3548 | 0.3527 | 0.3529 | 2788800.0 |
| 2003-07-10 09:40:00 | AAPL | Stock | 0.3529 | 0.3557 | 0.3518 | 0.3555 | 2630992.0 |
| 2003-07-10 09:45:00 | AAPL | Stock | 0.3554 | 0.3559 | 0.3537 | 0.3539 | 6944616.0 |
| 2003-07-10 09:50:00 | AAPL | Stock | 0.3538 | 0.3539 | 0.3525 | 0.3527 | 3578400.0 |
| 2003-07-10 09:55:00 | AAPL | Stock | 0.353 | 0.353 | 0.3518 | 0.3521 | 1750336.0 |
| 2003-07-10 10:00:00 | AAPL | Stock | 0.3518 | 0.3557 | 0.3518 | 0.3554 | 4515336.0 |
| 2003-07-10 10:05:00 | AAPL | Stock | 0.3552 | 0.3554 | 0.3532 | 0.3536 | 4005624.0 |
| 2003-07-10 10:10:00 | AAPL | Stock | 0.3532 | 0.3536 | 0.3516 | 0.3518 | 3977456.0 |
| 2003-07-10 10:15:00 | AAPL | Stock | 0.352 | 0.3543 | 0.3514 | 0.3523 | 2850400.0 |
| 2003-07-10 10:20:00 | AAPL | Stock | 0.3523 | 0.3541 | 0.3521 | 0.3534 | 1850520.0 |
| 2003-07-10 10:25:00 | AAPL | Stock | 0.3534 | 0.3538 | 0.3516 | 0.352 | 1460368.0 |
| 2003-07-10 10:30:00 | AAPL | Stock | 0.3519 | 0.3521 | 0.3513 | 0.3514 | 1615320.0 |
| 2003-07-10 10:35:00 | AAPL | Stock | 0.3516 | 0.353 | 0.3502 | 0.353 | 4072488.0 |
| 2003-07-10 10:40:00 | AAPL | Stock | 0.3529 | 0.3532 | 0.3513 | 0.3513 | 1271200.0 |
| 2003-07-10 10:45:00 | AAPL | Stock | 0.3514 | 0.3516 | 0.3491 | 0.3496 | 2055200.0 |
| 2003-07-10 10:50:00 | AAPL | Stock | 0.3496 | 0.3511 | 0.3495 | 0.3509 | 1421896.0 |
| 2003-07-10 10:55:00 | AAPL | Stock | 0.3507 | 0.3516 | 0.3507 | 0.3511 | 565600.0 |
| 2003-07-10 11:00:00 | AAPL | Stock | 0.3509 | 0.3513 | 0.3505 | 0.3507 | 835296.0 |
| 2003-07-10 11:05:00 | AAPL | Stock | 0.3509 | 0.3511 | 0.3502 | 0.3509 | 1293600.0 |
| 2003-07-10 11:10:00 | AAPL | Stock | 0.3511 | 0.3511 | 0.3502 | 0.3502 | 2116072.0 |
| 2003-07-10 11:15:00 | AAPL | Stock | 0.35 | 0.3514 | 0.35 | 0.3513 | 2032800.0 |
| 2003-07-10 11:20:00 | AAPL | Stock | 0.3513 | 0.3514 | 0.3511 | 0.3511 | 436800.0 |
| 2003-07-10 11:25:00 | AAPL | Stock | 0.3509 | 0.352 | 0.3505 | 0.352 | 2122848.0 |
| 2003-07-10 11:30:00 | AAPL | Stock | 0.352 | 0.3525 | 0.3518 | 0.3525 | 1700496.0 |
| 2003-07-10 11:35:00 | AAPL | Stock | 0.3525 | 0.3525 | 0.3498 | 0.3502 | 3146584.0 |
| 2003-07-10 11:40:00 | AAPL | Stock | 0.35 | 0.3504 | 0.3486 | 0.35 | 1605464.0 |
| 2003-07-10 11:45:00 | AAPL | Stock | 0.3502 | 0.3505 | 0.3489 | 0.3489 | 1033536.0 |
| 2003-07-10 11:50:00 | AAPL | Stock | 0.3489 | 0.3498 | 0.3488 | 0.3493 | 470400.0 |
| 2003-07-10 11:55:00 | AAPL | Stock | 0.3493 | 0.3498 | 0.3489 | 0.3491 | 957600.0 |
| 2003-07-10 12:00:00 | AAPL | Stock | 0.3495 | 0.35 | 0.3491 | 0.3499 | 436800.0 |
| 2003-07-10 12:05:00 | AAPL | Stock | 0.3498 | 0.3499 | 0.3495 | 0.3496 | 648200.0 |
| 2003-07-10 12:10:00 | AAPL | Stock | 0.3497 | 0.3504 | 0.3497 | 0.3504 | 548800.0 |
| 2003-07-10 12:15:00 | AAPL | Stock | 0.3504 | 0.3511 | 0.3496 | 0.3496 | 632520.0 |
| 2003-07-10 12:20:00 | AAPL | Stock | 0.3498 | 0.3502 | 0.3495 | 0.35 | 1500800.0 |
| 2003-07-10 12:25:00 | AAPL | Stock | 0.3502 | 0.3505 | 0.35 | 0.3504 | 690200.0 |
| 2003-07-10 12:30:00 | AAPL | Stock | 0.3504 | 0.3509 | 0.3496 | 0.3507 | 1506400.0 |
| 2003-07-10 12:35:00 | AAPL | Stock | 0.3507 | 0.3509 | 0.3504 | 0.3505 | 1097600.0 |
| 2003-07-10 12:40:00 | AAPL | Stock | 0.3505 | 0.3505 | 0.3495 | 0.3496 | 996744.0 |
| 2003-07-10 12:45:00 | AAPL | Stock | 0.3496 | 0.3498 | 0.3484 | 0.3486 | 1392496.0 |
| 2003-07-10 12:50:00 | AAPL | Stock | 0.3486 | 0.3489 | 0.3484 | 0.3488 | 1158808.0 |
| 2003-07-10 12:55:00 | AAPL | Stock | 0.3489 | 0.3491 | 0.3486 | 0.3486 | 552496.0 |
| 2003-07-10 13:00:00 | AAPL | Stock | 0.3486 | 0.3489 | 0.348 | 0.3484 | 3668000.0 |
| 2003-07-10 13:05:00 | AAPL | Stock | 0.3484 | 0.3488 | 0.3482 | 0.3486 | 1120000.0 |
> showing 50 of 155,142 rows — these rows as CSV