PREVIEW / stock_5min / 2003-07-17
file: by_date/stock_5min/2003/2003-07-17.parquet size: 2.2 MB rows: 156,111 symbols: 1,584
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-17 08:00:00 | AAPL | Stock | 0.3552 | 0.3594 | 0.3552 | 0.3552 | 41720.0 |
| 2003-07-17 08:10:00 | AAPL | Stock | 0.3552 | 0.3552 | 0.3552 | 0.3552 | 30520.0 |
| 2003-07-17 08:40:00 | AAPL | Stock | 0.3554 | 0.3554 | 0.3554 | 0.3554 | 25480.0 |
| 2003-07-17 08:45:00 | AAPL | Stock | 0.3554 | 0.3554 | 0.3554 | 0.3554 | 33600.0 |
| 2003-07-17 08:50:00 | AAPL | Stock | 0.3571 | 0.3571 | 0.357 | 0.357 | 89600.0 |
| 2003-07-17 08:55:00 | AAPL | Stock | 0.357 | 0.357 | 0.357 | 0.357 | 33600.0 |
| 2003-07-17 09:00:00 | AAPL | Stock | 0.357 | 0.3571 | 0.357 | 0.3571 | 212800.0 |
| 2003-07-17 09:05:00 | AAPL | Stock | 0.3571 | 0.3571 | 0.3571 | 0.3571 | 33600.0 |
| 2003-07-17 09:10:00 | AAPL | Stock | 0.3571 | 0.3571 | 0.3571 | 0.3571 | 218400.0 |
| 2003-07-17 09:15:00 | AAPL | Stock | 0.3571 | 0.3571 | 0.3571 | 0.3571 | 33600.0 |
| 2003-07-17 09:20:00 | AAPL | Stock | 0.3571 | 0.3571 | 0.3571 | 0.3571 | 386400.0 |
| 2003-07-17 09:25:00 | AAPL | Stock | 0.3571 | 0.3602 | 0.3571 | 0.36 | 1433600.0 |
| 2003-07-17 09:30:00 | AAPL | Stock | 0.3605 | 0.3616 | 0.3596 | 0.3609 | 14326088.0 |
| 2003-07-17 09:35:00 | AAPL | Stock | 0.3609 | 0.3661 | 0.3605 | 0.3643 | 24113208.0 |
| 2003-07-17 09:40:00 | AAPL | Stock | 0.3643 | 0.3654 | 0.3638 | 0.365 | 25227272.0 |
| 2003-07-17 09:45:00 | AAPL | Stock | 0.365 | 0.367 | 0.3648 | 0.3666 | 21417312.0 |
| 2003-07-17 09:50:00 | AAPL | Stock | 0.3664 | 0.3723 | 0.3657 | 0.3705 | 24435824.0 |
| 2003-07-17 09:55:00 | AAPL | Stock | 0.3705 | 0.3705 | 0.3684 | 0.3698 | 27770736.0 |
| 2003-07-17 10:00:00 | AAPL | Stock | 0.3698 | 0.3707 | 0.3695 | 0.37 | 20505016.0 |
| 2003-07-17 10:05:00 | AAPL | Stock | 0.3696 | 0.3703 | 0.3669 | 0.3677 | 10425464.0 |
| 2003-07-17 10:10:00 | AAPL | Stock | 0.3677 | 0.3679 | 0.3668 | 0.3675 | 9615200.0 |
| 2003-07-17 10:15:00 | AAPL | Stock | 0.3675 | 0.368 | 0.3625 | 0.3634 | 14622720.0 |
| 2003-07-17 10:20:00 | AAPL | Stock | 0.3634 | 0.367 | 0.3629 | 0.3652 | 15030736.0 |
| 2003-07-17 10:25:00 | AAPL | Stock | 0.3652 | 0.3659 | 0.3641 | 0.3659 | 5782168.0 |
| 2003-07-17 10:30:00 | AAPL | Stock | 0.3657 | 0.3659 | 0.3643 | 0.3652 | 5377120.0 |
| 2003-07-17 10:35:00 | AAPL | Stock | 0.3654 | 0.3659 | 0.3643 | 0.3648 | 6249096.0 |
| 2003-07-17 10:40:00 | AAPL | Stock | 0.3648 | 0.3659 | 0.3646 | 0.3657 | 5118400.0 |
| 2003-07-17 10:45:00 | AAPL | Stock | 0.3659 | 0.3673 | 0.3655 | 0.3666 | 8244040.0 |
| 2003-07-17 10:50:00 | AAPL | Stock | 0.3668 | 0.3677 | 0.3655 | 0.3655 | 12678400.0 |
| 2003-07-17 10:55:00 | AAPL | Stock | 0.3657 | 0.3679 | 0.3655 | 0.3679 | 6208496.0 |
| 2003-07-17 11:00:00 | AAPL | Stock | 0.3677 | 0.3689 | 0.3675 | 0.3686 | 11837224.0 |
| 2003-07-17 11:05:00 | AAPL | Stock | 0.3684 | 0.3696 | 0.368 | 0.3691 | 4827200.0 |
| 2003-07-17 11:10:00 | AAPL | Stock | 0.3689 | 0.3698 | 0.3689 | 0.3695 | 9380224.0 |
| 2003-07-17 11:15:00 | AAPL | Stock | 0.3695 | 0.3704 | 0.3693 | 0.3693 | 9257696.0 |
| 2003-07-17 11:20:00 | AAPL | Stock | 0.3693 | 0.3698 | 0.3682 | 0.3696 | 6724256.0 |
| 2003-07-17 11:25:00 | AAPL | Stock | 0.3693 | 0.3696 | 0.3682 | 0.3686 | 2282392.0 |
| 2003-07-17 11:30:00 | AAPL | Stock | 0.3688 | 0.3696 | 0.3675 | 0.3679 | 4269216.0 |
| 2003-07-17 11:35:00 | AAPL | Stock | 0.3679 | 0.3688 | 0.3671 | 0.3671 | 3679368.0 |
| 2003-07-17 11:40:00 | AAPL | Stock | 0.3671 | 0.3671 | 0.3663 | 0.3663 | 5717600.0 |
| 2003-07-17 11:45:00 | AAPL | Stock | 0.3661 | 0.3671 | 0.3661 | 0.367 | 7156184.0 |
| 2003-07-17 11:50:00 | AAPL | Stock | 0.367 | 0.3673 | 0.3666 | 0.3668 | 7977200.0 |
| 2003-07-17 11:55:00 | AAPL | Stock | 0.3668 | 0.367 | 0.3668 | 0.3668 | 2609600.0 |
| 2003-07-17 12:00:00 | AAPL | Stock | 0.367 | 0.3684 | 0.3662 | 0.367 | 6863248.0 |
| 2003-07-17 12:05:00 | AAPL | Stock | 0.367 | 0.367 | 0.3659 | 0.3661 | 1879080.0 |
| 2003-07-17 12:10:00 | AAPL | Stock | 0.3661 | 0.3663 | 0.3654 | 0.3659 | 3342584.0 |
| 2003-07-17 12:15:00 | AAPL | Stock | 0.3659 | 0.3673 | 0.3657 | 0.367 | 2451008.0 |
| 2003-07-17 12:20:00 | AAPL | Stock | 0.3668 | 0.3668 | 0.3655 | 0.3663 | 3478104.0 |
| 2003-07-17 12:25:00 | AAPL | Stock | 0.3663 | 0.367 | 0.3661 | 0.3669 | 2018912.0 |
| 2003-07-17 12:30:00 | AAPL | Stock | 0.3667 | 0.3668 | 0.3645 | 0.3654 | 8657040.0 |
| 2003-07-17 12:35:00 | AAPL | Stock | 0.3654 | 0.3655 | 0.3645 | 0.3645 | 5622400.0 |
> showing 50 of 156,111 rows — these rows as CSV