PREVIEW / stock_5min / 2007-03-26
file: by_date/stock_5min/2007/2007-03-26.parquet size: 3.6 MB rows: 257,867 symbols: 2,565
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 |
|---|---|---|---|---|---|---|---|
| 2007-03-26 07:00:00 | AAPL | Stock | 3.3482 | 3.3482 | 3.3482 | 3.3482 | 2800.0 |
| 2007-03-26 07:20:00 | AAPL | Stock | 3.3446 | 3.3446 | 3.3446 | 3.3446 | 2800.0 |
| 2007-03-26 07:35:00 | AAPL | Stock | 3.3496 | 3.4486 | 3.3496 | 3.3532 | 50400.0 |
| 2007-03-26 07:50:00 | AAPL | Stock | 3.355 | 3.355 | 3.355 | 3.355 | 28000.0 |
| 2007-03-26 07:55:00 | AAPL | Stock | 3.3518 | 3.375 | 3.3518 | 3.3746 | 385000.0 |
| 2007-03-26 08:00:00 | AAPL | Stock | 3.3732 | 3.3732 | 3.3568 | 3.3607 | 614516.0 |
| 2007-03-26 08:05:00 | AAPL | Stock | 3.3607 | 3.3632 | 3.3536 | 3.3589 | 377832.0 |
| 2007-03-26 08:10:00 | AAPL | Stock | 3.3596 | 3.3636 | 3.3596 | 3.3632 | 132440.0 |
| 2007-03-26 08:15:00 | AAPL | Stock | 3.3629 | 3.3629 | 3.3604 | 3.3607 | 134176.0 |
| 2007-03-26 08:20:00 | AAPL | Stock | 3.3614 | 3.3621 | 3.3589 | 3.3589 | 94248.0 |
| 2007-03-26 08:25:00 | AAPL | Stock | 3.3589 | 3.3604 | 3.3589 | 3.3604 | 47600.0 |
| 2007-03-26 08:30:00 | AAPL | Stock | 3.3604 | 3.3625 | 3.3604 | 3.3618 | 170800.0 |
| 2007-03-26 08:35:00 | AAPL | Stock | 3.3629 | 3.3636 | 3.3625 | 3.3629 | 200900.0 |
| 2007-03-26 08:40:00 | AAPL | Stock | 3.3629 | 3.3696 | 3.3629 | 3.3661 | 498400.0 |
| 2007-03-26 08:45:00 | AAPL | Stock | 3.3661 | 3.3664 | 3.3625 | 3.3625 | 345660.0 |
| 2007-03-26 08:50:00 | AAPL | Stock | 3.3621 | 3.3643 | 3.3607 | 3.3643 | 166096.0 |
| 2007-03-26 08:55:00 | AAPL | Stock | 3.3643 | 3.3643 | 3.3625 | 3.3643 | 159544.0 |
| 2007-03-26 09:00:00 | AAPL | Stock | 3.3629 | 3.3629 | 3.3625 | 3.3625 | 53200.0 |
| 2007-03-26 09:05:00 | AAPL | Stock | 3.3625 | 3.3654 | 3.3607 | 3.3654 | 219464.0 |
| 2007-03-26 09:10:00 | AAPL | Stock | 3.3643 | 3.3643 | 3.3639 | 3.3643 | 61600.0 |
| 2007-03-26 09:15:00 | AAPL | Stock | 3.3639 | 3.3643 | 3.3639 | 3.3639 | 126000.0 |
| 2007-03-26 09:20:00 | AAPL | Stock | 3.3643 | 3.3643 | 3.3614 | 3.3629 | 32200.0 |
| 2007-03-26 09:25:00 | AAPL | Stock | 3.3614 | 3.3618 | 3.355 | 3.3564 | 864724.0 |
| 2007-03-26 09:30:00 | AAPL | Stock | 3.3568 | 3.3614 | 3.3489 | 3.3525 | 21360556.0 |
| 2007-03-26 09:35:00 | AAPL | Stock | 3.3532 | 3.3636 | 3.35 | 3.3614 | 15715952.0 |
| 2007-03-26 09:40:00 | AAPL | Stock | 3.3611 | 3.3839 | 3.3582 | 3.3832 | 25608968.0 |
| 2007-03-26 09:45:00 | AAPL | Stock | 3.3836 | 3.3857 | 3.3789 | 3.3825 | 18823980.0 |
| 2007-03-26 09:50:00 | AAPL | Stock | 3.3818 | 3.385 | 3.3696 | 3.3714 | 18913216.0 |
| 2007-03-26 09:55:00 | AAPL | Stock | 3.3714 | 3.3807 | 3.3686 | 3.375 | 12381012.0 |
| 2007-03-26 10:00:00 | AAPL | Stock | 3.375 | 3.375 | 3.3582 | 3.3582 | 21831936.0 |
| 2007-03-26 10:05:00 | AAPL | Stock | 3.3582 | 3.3693 | 3.3471 | 3.3543 | 20083924.0 |
| 2007-03-26 10:10:00 | AAPL | Stock | 3.3546 | 3.3682 | 3.3504 | 3.3603 | 15366400.0 |
| 2007-03-26 10:15:00 | AAPL | Stock | 3.36 | 3.365 | 3.3554 | 3.3636 | 11841676.0 |
| 2007-03-26 10:20:00 | AAPL | Stock | 3.3632 | 3.365 | 3.3464 | 3.3468 | 15307796.0 |
| 2007-03-26 10:25:00 | AAPL | Stock | 3.3464 | 3.3561 | 3.3321 | 3.3396 | 28630308.0 |
| 2007-03-26 10:30:00 | AAPL | Stock | 3.34 | 3.3618 | 3.3375 | 3.3435 | 14009744.0 |
| 2007-03-26 10:35:00 | AAPL | Stock | 3.3436 | 3.3646 | 3.3432 | 3.3477 | 9045848.0 |
| 2007-03-26 10:40:00 | AAPL | Stock | 3.3479 | 3.3586 | 3.3465 | 3.3507 | 11408096.0 |
| 2007-03-26 10:45:00 | AAPL | Stock | 3.3507 | 3.3564 | 3.3493 | 3.355 | 10316096.0 |
| 2007-03-26 10:50:00 | AAPL | Stock | 3.3554 | 3.3586 | 3.3521 | 3.3546 | 9105264.0 |
| 2007-03-26 10:55:00 | AAPL | Stock | 3.3543 | 3.3579 | 3.3493 | 3.3507 | 6991460.0 |
| 2007-03-26 11:00:00 | AAPL | Stock | 3.3511 | 3.3529 | 3.3464 | 3.3464 | 8034292.0 |
| 2007-03-26 11:05:00 | AAPL | Stock | 3.3468 | 3.3543 | 3.3461 | 3.3532 | 6137852.0 |
| 2007-03-26 11:10:00 | AAPL | Stock | 3.3532 | 3.3582 | 3.3532 | 3.3539 | 6645688.0 |
| 2007-03-26 11:15:00 | AAPL | Stock | 3.3543 | 3.3596 | 3.3525 | 3.3593 | 7733628.0 |
| 2007-03-26 11:20:00 | AAPL | Stock | 3.3593 | 3.3625 | 3.3564 | 3.3564 | 10213980.0 |
| 2007-03-26 11:25:00 | AAPL | Stock | 3.3571 | 3.3607 | 3.3554 | 3.36 | 5357660.0 |
| 2007-03-26 11:30:00 | AAPL | Stock | 3.3604 | 3.3625 | 3.3582 | 3.3589 | 5434576.0 |
| 2007-03-26 11:35:00 | AAPL | Stock | 3.3593 | 3.3671 | 3.3589 | 3.3657 | 9186072.0 |
| 2007-03-26 11:40:00 | AAPL | Stock | 3.3661 | 3.3679 | 3.3632 | 3.365 | 14481656.0 |
> showing 50 of 257,867 rows — these rows as CSV