PREVIEW / stock_5min / 2001-07-24
file: by_date/stock_5min/2001/2001-07-24.parquet size: 1.5 MB rows: 106,748 symbols: 1,316
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-07-24 08:00:00 | AAPL | Stock | 0.3488 | 0.3491 | 0.3488 | 0.3491 | 162400.0 |
| 2001-07-24 08:45:00 | AAPL | Stock | 0.3491 | 0.3491 | 0.3489 | 0.3489 | 28000.0 |
| 2001-07-24 09:10:00 | AAPL | Stock | 0.3488 | 0.3489 | 0.3488 | 0.3488 | 246400.0 |
| 2001-07-24 09:25:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3461 | 0.3461 | 184800.0 |
| 2001-07-24 09:30:00 | AAPL | Stock | 0.3463 | 0.3489 | 0.3461 | 0.3486 | 6680800.0 |
| 2001-07-24 09:35:00 | AAPL | Stock | 0.3488 | 0.35 | 0.3455 | 0.3455 | 5314400.0 |
| 2001-07-24 09:40:00 | AAPL | Stock | 0.3457 | 0.3491 | 0.3452 | 0.3488 | 4496800.0 |
| 2001-07-24 09:45:00 | AAPL | Stock | 0.3488 | 0.3493 | 0.348 | 0.3488 | 2167200.0 |
| 2001-07-24 09:50:00 | AAPL | Stock | 0.3488 | 0.3543 | 0.3488 | 0.3538 | 3432800.0 |
| 2001-07-24 09:55:00 | AAPL | Stock | 0.3538 | 0.3557 | 0.3536 | 0.3536 | 3264800.0 |
| 2001-07-24 10:00:00 | AAPL | Stock | 0.3536 | 0.3545 | 0.3525 | 0.3532 | 6456800.0 |
| 2001-07-24 10:05:00 | AAPL | Stock | 0.3536 | 0.3536 | 0.3511 | 0.3518 | 2128000.0 |
| 2001-07-24 10:10:00 | AAPL | Stock | 0.3518 | 0.3523 | 0.3496 | 0.35 | 4860800.0 |
| 2001-07-24 10:15:00 | AAPL | Stock | 0.35 | 0.3518 | 0.3491 | 0.35 | 3959200.0 |
| 2001-07-24 10:20:00 | AAPL | Stock | 0.3498 | 0.3513 | 0.3491 | 0.35 | 4872000.0 |
| 2001-07-24 10:25:00 | AAPL | Stock | 0.3511 | 0.3527 | 0.3509 | 0.3518 | 2693600.0 |
| 2001-07-24 10:30:00 | AAPL | Stock | 0.3518 | 0.353 | 0.3511 | 0.353 | 3001600.0 |
| 2001-07-24 10:35:00 | AAPL | Stock | 0.3527 | 0.3546 | 0.3521 | 0.3521 | 4183200.0 |
| 2001-07-24 10:40:00 | AAPL | Stock | 0.3523 | 0.3538 | 0.3504 | 0.3505 | 2273600.0 |
| 2001-07-24 10:45:00 | AAPL | Stock | 0.3504 | 0.3521 | 0.3504 | 0.3509 | 4642400.0 |
| 2001-07-24 10:50:00 | AAPL | Stock | 0.3509 | 0.3523 | 0.3509 | 0.3518 | 1892800.0 |
| 2001-07-24 10:55:00 | AAPL | Stock | 0.3513 | 0.3521 | 0.3511 | 0.3521 | 2391200.0 |
| 2001-07-24 11:00:00 | AAPL | Stock | 0.352 | 0.3532 | 0.352 | 0.3525 | 3656800.0 |
| 2001-07-24 11:05:00 | AAPL | Stock | 0.3525 | 0.3525 | 0.3489 | 0.3496 | 5762400.0 |
| 2001-07-24 11:10:00 | AAPL | Stock | 0.3496 | 0.3498 | 0.3473 | 0.3489 | 8663200.0 |
| 2001-07-24 11:15:00 | AAPL | Stock | 0.3491 | 0.35 | 0.3475 | 0.3491 | 2895200.0 |
| 2001-07-24 11:20:00 | AAPL | Stock | 0.3495 | 0.3496 | 0.3475 | 0.3479 | 2727200.0 |
| 2001-07-24 11:25:00 | AAPL | Stock | 0.3479 | 0.3505 | 0.3468 | 0.3498 | 5409600.0 |
| 2001-07-24 11:30:00 | AAPL | Stock | 0.3505 | 0.3511 | 0.3496 | 0.3511 | 2200800.0 |
| 2001-07-24 11:35:00 | AAPL | Stock | 0.3511 | 0.3514 | 0.3486 | 0.3489 | 1904000.0 |
| 2001-07-24 11:40:00 | AAPL | Stock | 0.3486 | 0.3495 | 0.3484 | 0.3495 | 1136800.0 |
| 2001-07-24 11:45:00 | AAPL | Stock | 0.3486 | 0.3502 | 0.3484 | 0.3484 | 1097600.0 |
| 2001-07-24 11:50:00 | AAPL | Stock | 0.3484 | 0.3489 | 0.3477 | 0.3484 | 2682400.0 |
| 2001-07-24 11:55:00 | AAPL | Stock | 0.3484 | 0.3495 | 0.3484 | 0.3484 | 1517600.0 |
| 2001-07-24 12:00:00 | AAPL | Stock | 0.3486 | 0.3493 | 0.3473 | 0.3475 | 2424800.0 |
| 2001-07-24 12:05:00 | AAPL | Stock | 0.3477 | 0.3489 | 0.3477 | 0.3482 | 3253600.0 |
| 2001-07-24 12:10:00 | AAPL | Stock | 0.3482 | 0.3489 | 0.3475 | 0.3479 | 2161600.0 |
| 2001-07-24 12:15:00 | AAPL | Stock | 0.348 | 0.3484 | 0.3464 | 0.3479 | 4323200.0 |
| 2001-07-24 12:20:00 | AAPL | Stock | 0.3479 | 0.3489 | 0.3473 | 0.3486 | 1842400.0 |
| 2001-07-24 12:25:00 | AAPL | Stock | 0.3489 | 0.3491 | 0.3482 | 0.3489 | 873600.0 |
| 2001-07-24 12:30:00 | AAPL | Stock | 0.3488 | 0.3491 | 0.3475 | 0.3482 | 6204800.0 |
| 2001-07-24 12:35:00 | AAPL | Stock | 0.3482 | 0.3484 | 0.3479 | 0.3479 | 1635200.0 |
| 2001-07-24 12:40:00 | AAPL | Stock | 0.3479 | 0.348 | 0.3464 | 0.3464 | 2945600.0 |
| 2001-07-24 12:45:00 | AAPL | Stock | 0.3473 | 0.3484 | 0.3466 | 0.3473 | 2391200.0 |
| 2001-07-24 12:50:00 | AAPL | Stock | 0.3479 | 0.3479 | 0.3464 | 0.3464 | 10780000.0 |
| 2001-07-24 12:55:00 | AAPL | Stock | 0.3464 | 0.3479 | 0.3464 | 0.3479 | 2055200.0 |
| 2001-07-24 13:00:00 | AAPL | Stock | 0.3479 | 0.3488 | 0.3479 | 0.348 | 924000.0 |
| 2001-07-24 13:05:00 | AAPL | Stock | 0.348 | 0.3486 | 0.3477 | 0.3484 | 7666400.0 |
| 2001-07-24 13:10:00 | AAPL | Stock | 0.3484 | 0.3488 | 0.3475 | 0.3486 | 2122400.0 |
| 2001-07-24 13:15:00 | AAPL | Stock | 0.3486 | 0.3486 | 0.3477 | 0.3477 | 3942400.0 |
> showing 50 of 106,748 rows — these rows as CSV