PREVIEW / stock_5min / 2006-03-14
file: by_date/stock_5min/2006/2006-03-14.parquet size: 3.0 MB rows: 219,639 symbols: 2,205
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 |
|---|---|---|---|---|---|---|---|
| 2006-03-14 04:35:00 | AAPL | Stock | 2.3496 | 2.3496 | 2.3496 | 2.3496 | 4620.0 |
| 2006-03-14 05:40:00 | AAPL | Stock | 2.3446 | 2.3446 | 2.3446 | 2.3446 | 2800.0 |
| 2006-03-14 07:20:00 | AAPL | Stock | 2.3393 | 2.3393 | 2.3379 | 2.3379 | 11200.0 |
| 2006-03-14 07:35:00 | AAPL | Stock | 2.3432 | 2.3432 | 2.3432 | 2.3432 | 5600.0 |
| 2006-03-14 07:40:00 | AAPL | Stock | 2.3432 | 2.3432 | 2.3393 | 2.3393 | 5600.0 |
| 2006-03-14 08:00:00 | AAPL | Stock | 2.3393 | 2.3418 | 2.3236 | 2.3393 | 447720.0 |
| 2006-03-14 08:05:00 | AAPL | Stock | 2.3375 | 2.3396 | 2.3375 | 2.3396 | 22400.0 |
| 2006-03-14 08:10:00 | AAPL | Stock | 2.3393 | 2.3411 | 2.3393 | 2.3393 | 96600.0 |
| 2006-03-14 08:15:00 | AAPL | Stock | 2.3393 | 2.3425 | 2.3393 | 2.3393 | 74200.0 |
| 2006-03-14 08:20:00 | AAPL | Stock | 2.3393 | 2.3393 | 2.3393 | 2.3393 | 14000.0 |
| 2006-03-14 08:25:00 | AAPL | Stock | 2.3393 | 2.3393 | 2.3393 | 2.3393 | 117964.0 |
| 2006-03-14 08:30:00 | AAPL | Stock | 2.3393 | 2.3396 | 2.3375 | 2.3379 | 150472.0 |
| 2006-03-14 08:35:00 | AAPL | Stock | 2.3379 | 2.3421 | 2.3379 | 2.3414 | 149436.0 |
| 2006-03-14 08:40:00 | AAPL | Stock | 2.3414 | 2.3429 | 2.3361 | 2.3375 | 469560.0 |
| 2006-03-14 08:45:00 | AAPL | Stock | 2.3375 | 2.3411 | 2.3375 | 2.3393 | 19600.0 |
| 2006-03-14 08:50:00 | AAPL | Stock | 2.3382 | 2.3386 | 2.3382 | 2.3386 | 19600.0 |
| 2006-03-14 08:55:00 | AAPL | Stock | 2.3393 | 2.3393 | 2.3375 | 2.3386 | 101920.0 |
| 2006-03-14 09:00:00 | AAPL | Stock | 2.3386 | 2.3386 | 2.3386 | 2.3386 | 28000.0 |
| 2006-03-14 09:05:00 | AAPL | Stock | 2.3393 | 2.3418 | 2.3393 | 2.3393 | 169400.0 |
| 2006-03-14 09:10:00 | AAPL | Stock | 2.3393 | 2.3393 | 2.3386 | 2.3386 | 44800.0 |
| 2006-03-14 09:15:00 | AAPL | Stock | 2.3382 | 2.3382 | 2.3382 | 2.3382 | 14000.0 |
| 2006-03-14 09:20:00 | AAPL | Stock | 2.3386 | 2.3393 | 2.3386 | 2.3393 | 64400.0 |
| 2006-03-14 09:25:00 | AAPL | Stock | 2.3432 | 2.3507 | 2.3386 | 2.3507 | 1213996.0 |
| 2006-03-14 09:30:00 | AAPL | Stock | 2.3489 | 2.3554 | 2.3393 | 2.3554 | 20478836.0 |
| 2006-03-14 09:35:00 | AAPL | Stock | 2.3554 | 2.3596 | 2.3514 | 2.3536 | 12860764.0 |
| 2006-03-14 09:40:00 | AAPL | Stock | 2.3539 | 2.3543 | 2.3429 | 2.3511 | 13051864.0 |
| 2006-03-14 09:45:00 | AAPL | Stock | 2.3507 | 2.3571 | 2.3486 | 2.3561 | 11765796.0 |
| 2006-03-14 09:50:00 | AAPL | Stock | 2.3564 | 2.3611 | 2.35 | 2.3554 | 16924936.0 |
| 2006-03-14 09:55:00 | AAPL | Stock | 2.3557 | 2.36 | 2.3525 | 2.3592 | 9757076.0 |
| 2006-03-14 10:00:00 | AAPL | Stock | 2.3589 | 2.3714 | 2.3589 | 2.3707 | 23686012.0 |
| 2006-03-14 10:05:00 | AAPL | Stock | 2.3704 | 2.3786 | 2.3646 | 2.3775 | 22427776.0 |
| 2006-03-14 10:10:00 | AAPL | Stock | 2.3779 | 2.3782 | 2.37 | 2.3725 | 21547456.0 |
| 2006-03-14 10:15:00 | AAPL | Stock | 2.3725 | 2.3757 | 2.37 | 2.3732 | 9552004.0 |
| 2006-03-14 10:20:00 | AAPL | Stock | 2.3729 | 2.3732 | 2.3657 | 2.3686 | 15112552.0 |
| 2006-03-14 10:25:00 | AAPL | Stock | 2.3689 | 2.3714 | 2.3625 | 2.365 | 10905804.0 |
| 2006-03-14 10:30:00 | AAPL | Stock | 2.3646 | 2.3682 | 2.3589 | 2.3596 | 12365752.0 |
| 2006-03-14 10:35:00 | AAPL | Stock | 2.3593 | 2.3632 | 2.3575 | 2.3596 | 11553332.0 |
| 2006-03-14 10:40:00 | AAPL | Stock | 2.3593 | 2.3661 | 2.3557 | 2.3636 | 13529208.0 |
| 2006-03-14 10:45:00 | AAPL | Stock | 2.3632 | 2.3686 | 2.3629 | 2.3664 | 9331728.0 |
| 2006-03-14 10:50:00 | AAPL | Stock | 2.3664 | 2.3711 | 2.3646 | 2.3679 | 4907840.0 |
| 2006-03-14 10:55:00 | AAPL | Stock | 2.3682 | 2.3686 | 2.3618 | 2.3639 | 5427268.0 |
| 2006-03-14 11:00:00 | AAPL | Stock | 2.3636 | 2.3668 | 2.3607 | 2.3611 | 5616324.0 |
| 2006-03-14 11:05:00 | AAPL | Stock | 2.3611 | 2.3646 | 2.3611 | 2.3621 | 3027724.0 |
| 2006-03-14 11:10:00 | AAPL | Stock | 2.3621 | 2.3679 | 2.3593 | 2.3639 | 5001108.0 |
| 2006-03-14 11:15:00 | AAPL | Stock | 2.3643 | 2.3664 | 2.3625 | 2.3639 | 4228000.0 |
| 2006-03-14 11:20:00 | AAPL | Stock | 2.3636 | 2.37 | 2.3632 | 2.3696 | 6051108.0 |
| 2006-03-14 11:25:00 | AAPL | Stock | 2.3696 | 2.3704 | 2.3661 | 2.3671 | 4949896.0 |
| 2006-03-14 11:30:00 | AAPL | Stock | 2.3671 | 2.3732 | 2.3671 | 2.3679 | 6388648.0 |
| 2006-03-14 11:35:00 | AAPL | Stock | 2.3675 | 2.3679 | 2.3661 | 2.3661 | 3522876.0 |
| 2006-03-14 11:40:00 | AAPL | Stock | 2.3657 | 2.37 | 2.3611 | 2.3679 | 8334368.0 |
> showing 50 of 219,639 rows — these rows as CSV