PREVIEW / stock_5min / 2001-08-07
file: by_date/stock_5min/2001/2001-08-07.parquet size: 1.5 MB rows: 105,297 symbols: 1,337
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-08-07 08:15:00 | AAPL | Stock | 0.3407 | 0.3407 | 0.3407 | 0.3407 | 28000.0 |
| 2001-08-07 08:45:00 | AAPL | Stock | 0.3446 | 0.345 | 0.3446 | 0.345 | 106400.0 |
| 2001-08-07 08:50:00 | AAPL | Stock | 0.3429 | 0.3429 | 0.3429 | 0.3429 | 11200.0 |
| 2001-08-07 08:55:00 | AAPL | Stock | 0.3455 | 0.3455 | 0.3455 | 0.3455 | 22400.0 |
| 2001-08-07 09:05:00 | AAPL | Stock | 0.3455 | 0.3455 | 0.3416 | 0.3416 | 106400.0 |
| 2001-08-07 09:10:00 | AAPL | Stock | 0.345 | 0.3464 | 0.345 | 0.3464 | 67200.0 |
| 2001-08-07 09:20:00 | AAPL | Stock | 0.3448 | 0.3448 | 0.3448 | 0.3448 | 5600.0 |
| 2001-08-07 09:25:00 | AAPL | Stock | 0.3446 | 0.3455 | 0.3446 | 0.3452 | 280000.0 |
| 2001-08-07 09:30:00 | AAPL | Stock | 0.3452 | 0.3454 | 0.3389 | 0.3411 | 8943200.0 |
| 2001-08-07 09:35:00 | AAPL | Stock | 0.342 | 0.342 | 0.3395 | 0.3411 | 3242400.0 |
| 2001-08-07 09:40:00 | AAPL | Stock | 0.3411 | 0.342 | 0.3405 | 0.342 | 2643200.0 |
| 2001-08-07 09:45:00 | AAPL | Stock | 0.342 | 0.3432 | 0.3418 | 0.3429 | 2878400.0 |
| 2001-08-07 09:50:00 | AAPL | Stock | 0.3427 | 0.3454 | 0.3427 | 0.3454 | 2508800.0 |
| 2001-08-07 09:55:00 | AAPL | Stock | 0.3452 | 0.3455 | 0.3443 | 0.3455 | 2060800.0 |
| 2001-08-07 10:00:00 | AAPL | Stock | 0.3455 | 0.3463 | 0.3441 | 0.3441 | 2329600.0 |
| 2001-08-07 10:05:00 | AAPL | Stock | 0.3445 | 0.345 | 0.3439 | 0.345 | 1052800.0 |
| 2001-08-07 10:10:00 | AAPL | Stock | 0.345 | 0.3455 | 0.3446 | 0.3455 | 2273600.0 |
| 2001-08-07 10:15:00 | AAPL | Stock | 0.3455 | 0.3463 | 0.3454 | 0.3454 | 1108800.0 |
| 2001-08-07 10:20:00 | AAPL | Stock | 0.3455 | 0.3463 | 0.3443 | 0.3452 | 2318400.0 |
| 2001-08-07 10:25:00 | AAPL | Stock | 0.3452 | 0.3457 | 0.345 | 0.345 | 1226400.0 |
| 2001-08-07 10:30:00 | AAPL | Stock | 0.345 | 0.3455 | 0.3448 | 0.3455 | 778400.0 |
| 2001-08-07 10:35:00 | AAPL | Stock | 0.3455 | 0.3479 | 0.3454 | 0.347 | 3091200.0 |
| 2001-08-07 10:40:00 | AAPL | Stock | 0.3468 | 0.348 | 0.3457 | 0.348 | 3466400.0 |
| 2001-08-07 10:45:00 | AAPL | Stock | 0.348 | 0.3489 | 0.347 | 0.3484 | 3231200.0 |
| 2001-08-07 10:50:00 | AAPL | Stock | 0.3477 | 0.3491 | 0.3477 | 0.3486 | 1108800.0 |
| 2001-08-07 10:55:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3477 | 0.348 | 1276800.0 |
| 2001-08-07 11:00:00 | AAPL | Stock | 0.348 | 0.3488 | 0.3477 | 0.3486 | 2100000.0 |
| 2001-08-07 11:05:00 | AAPL | Stock | 0.3486 | 0.3491 | 0.348 | 0.3484 | 2738400.0 |
| 2001-08-07 11:10:00 | AAPL | Stock | 0.3484 | 0.35 | 0.3479 | 0.3496 | 4194400.0 |
| 2001-08-07 11:15:00 | AAPL | Stock | 0.3495 | 0.3495 | 0.3482 | 0.3491 | 1657600.0 |
| 2001-08-07 11:20:00 | AAPL | Stock | 0.3491 | 0.3513 | 0.3489 | 0.3489 | 3113600.0 |
| 2001-08-07 11:25:00 | AAPL | Stock | 0.3486 | 0.3509 | 0.3477 | 0.3505 | 4373600.0 |
| 2001-08-07 11:30:00 | AAPL | Stock | 0.3495 | 0.35 | 0.3491 | 0.3498 | 655200.0 |
| 2001-08-07 11:35:00 | AAPL | Stock | 0.3495 | 0.3507 | 0.3493 | 0.3498 | 1640800.0 |
| 2001-08-07 11:40:00 | AAPL | Stock | 0.35 | 0.3505 | 0.3493 | 0.3493 | 1590400.0 |
| 2001-08-07 11:45:00 | AAPL | Stock | 0.3493 | 0.3502 | 0.3493 | 0.3496 | 1797600.0 |
| 2001-08-07 11:50:00 | AAPL | Stock | 0.3496 | 0.35 | 0.3486 | 0.3496 | 1327200.0 |
| 2001-08-07 11:55:00 | AAPL | Stock | 0.3495 | 0.3498 | 0.3491 | 0.3496 | 985600.0 |
| 2001-08-07 12:00:00 | AAPL | Stock | 0.3498 | 0.3504 | 0.3493 | 0.3495 | 2760800.0 |
| 2001-08-07 12:05:00 | AAPL | Stock | 0.3496 | 0.3496 | 0.3479 | 0.3482 | 3164000.0 |
| 2001-08-07 12:10:00 | AAPL | Stock | 0.3482 | 0.3491 | 0.3482 | 0.3488 | 1260000.0 |
| 2001-08-07 12:15:00 | AAPL | Stock | 0.3489 | 0.3491 | 0.348 | 0.348 | 1820000.0 |
| 2001-08-07 12:20:00 | AAPL | Stock | 0.3484 | 0.3484 | 0.3464 | 0.348 | 2088800.0 |
| 2001-08-07 12:25:00 | AAPL | Stock | 0.3484 | 0.3486 | 0.3479 | 0.3482 | 414400.0 |
| 2001-08-07 12:30:00 | AAPL | Stock | 0.3482 | 0.3486 | 0.3466 | 0.3475 | 1024800.0 |
| 2001-08-07 12:35:00 | AAPL | Stock | 0.3473 | 0.3486 | 0.3466 | 0.3486 | 1058400.0 |
| 2001-08-07 12:40:00 | AAPL | Stock | 0.3486 | 0.3489 | 0.3482 | 0.3484 | 1428000.0 |
| 2001-08-07 12:45:00 | AAPL | Stock | 0.3484 | 0.3488 | 0.3461 | 0.3471 | 4009600.0 |
| 2001-08-07 12:50:00 | AAPL | Stock | 0.3471 | 0.3475 | 0.3464 | 0.3464 | 509600.0 |
| 2001-08-07 12:55:00 | AAPL | Stock | 0.3464 | 0.3468 | 0.3436 | 0.345 | 3768800.0 |
> showing 50 of 105,297 rows — these rows as CSV