PREVIEW / stock_5min / 2003-11-28
file: by_date/stock_5min/2003/2003-11-28.parquet size: 1.2 MB rows: 83,100 symbols: 1,640
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-11-28 08:20:00 | AAPL | Stock | 0.3705 | 0.3705 | 0.3705 | 0.3705 | 11200.0 |
| 2003-11-28 08:30:00 | AAPL | Stock | 0.3705 | 0.3727 | 0.3705 | 0.3727 | 28000.0 |
| 2003-11-28 08:45:00 | AAPL | Stock | 0.3725 | 0.3725 | 0.3725 | 0.3725 | 56000.0 |
| 2003-11-28 09:25:00 | AAPL | Stock | 0.3698 | 0.3707 | 0.3689 | 0.3707 | 123200.0 |
| 2003-11-28 09:30:00 | AAPL | Stock | 0.3711 | 0.3714 | 0.3671 | 0.3688 | 5044368.0 |
| 2003-11-28 09:35:00 | AAPL | Stock | 0.3688 | 0.3695 | 0.3671 | 0.3695 | 2559704.0 |
| 2003-11-28 09:40:00 | AAPL | Stock | 0.3693 | 0.3696 | 0.3689 | 0.3693 | 1151696.0 |
| 2003-11-28 09:45:00 | AAPL | Stock | 0.3692 | 0.3693 | 0.367 | 0.367 | 1311128.0 |
| 2003-11-28 09:50:00 | AAPL | Stock | 0.367 | 0.3673 | 0.367 | 0.367 | 1523200.0 |
| 2003-11-28 09:55:00 | AAPL | Stock | 0.3673 | 0.3673 | 0.3664 | 0.3664 | 1121344.0 |
| 2003-11-28 10:00:00 | AAPL | Stock | 0.3666 | 0.3679 | 0.3664 | 0.3675 | 1917328.0 |
| 2003-11-28 10:05:00 | AAPL | Stock | 0.3675 | 0.3686 | 0.3675 | 0.3684 | 1175272.0 |
| 2003-11-28 10:10:00 | AAPL | Stock | 0.3684 | 0.3688 | 0.3682 | 0.3686 | 1351504.0 |
| 2003-11-28 10:15:00 | AAPL | Stock | 0.3684 | 0.3686 | 0.3673 | 0.3676 | 1071448.0 |
| 2003-11-28 10:20:00 | AAPL | Stock | 0.3679 | 0.3679 | 0.3677 | 0.3677 | 537600.0 |
| 2003-11-28 10:25:00 | AAPL | Stock | 0.3679 | 0.3679 | 0.3677 | 0.3679 | 612472.0 |
| 2003-11-28 10:30:00 | AAPL | Stock | 0.3677 | 0.3679 | 0.3677 | 0.3679 | 446432.0 |
| 2003-11-28 10:35:00 | AAPL | Stock | 0.3677 | 0.3679 | 0.3677 | 0.3679 | 1028440.0 |
| 2003-11-28 10:40:00 | AAPL | Stock | 0.3677 | 0.3684 | 0.3677 | 0.3684 | 1844584.0 |
| 2003-11-28 10:45:00 | AAPL | Stock | 0.3686 | 0.3691 | 0.3679 | 0.3691 | 527464.0 |
| 2003-11-28 10:50:00 | AAPL | Stock | 0.3691 | 0.3696 | 0.3691 | 0.3696 | 521864.0 |
| 2003-11-28 10:55:00 | AAPL | Stock | 0.3696 | 0.3696 | 0.3691 | 0.3696 | 696808.0 |
| 2003-11-28 11:00:00 | AAPL | Stock | 0.3696 | 0.3697 | 0.3695 | 0.3696 | 452424.0 |
| 2003-11-28 11:05:00 | AAPL | Stock | 0.3696 | 0.3711 | 0.3696 | 0.3707 | 1570128.0 |
| 2003-11-28 11:10:00 | AAPL | Stock | 0.3708 | 0.3713 | 0.3698 | 0.3698 | 2055928.0 |
| 2003-11-28 11:15:00 | AAPL | Stock | 0.3698 | 0.3704 | 0.3698 | 0.3702 | 817488.0 |
| 2003-11-28 11:20:00 | AAPL | Stock | 0.3704 | 0.3709 | 0.37 | 0.3704 | 607768.0 |
| 2003-11-28 11:25:00 | AAPL | Stock | 0.3704 | 0.372 | 0.37 | 0.3714 | 1793400.0 |
| 2003-11-28 11:30:00 | AAPL | Stock | 0.3718 | 0.3723 | 0.3718 | 0.3721 | 1574608.0 |
| 2003-11-28 11:35:00 | AAPL | Stock | 0.3721 | 0.3721 | 0.3705 | 0.3705 | 1886416.0 |
| 2003-11-28 11:40:00 | AAPL | Stock | 0.3707 | 0.3711 | 0.3705 | 0.3709 | 379680.0 |
| 2003-11-28 11:45:00 | AAPL | Stock | 0.3709 | 0.3718 | 0.3707 | 0.3718 | 1055040.0 |
| 2003-11-28 11:50:00 | AAPL | Stock | 0.3716 | 0.3716 | 0.3713 | 0.3714 | 1397200.0 |
| 2003-11-28 11:55:00 | AAPL | Stock | 0.3713 | 0.3716 | 0.3713 | 0.3716 | 2337104.0 |
| 2003-11-28 12:00:00 | AAPL | Stock | 0.3714 | 0.3714 | 0.3713 | 0.3714 | 1245664.0 |
| 2003-11-28 12:05:00 | AAPL | Stock | 0.3714 | 0.3716 | 0.3713 | 0.3714 | 1083600.0 |
| 2003-11-28 12:10:00 | AAPL | Stock | 0.3716 | 0.3723 | 0.3713 | 0.3723 | 642768.0 |
| 2003-11-28 12:15:00 | AAPL | Stock | 0.3721 | 0.3725 | 0.3716 | 0.3723 | 749392.0 |
| 2003-11-28 12:20:00 | AAPL | Stock | 0.3725 | 0.373 | 0.3721 | 0.3725 | 1030064.0 |
| 2003-11-28 12:25:00 | AAPL | Stock | 0.3727 | 0.3729 | 0.3725 | 0.3729 | 721896.0 |
| 2003-11-28 12:30:00 | AAPL | Stock | 0.3726 | 0.3734 | 0.3725 | 0.3734 | 2705248.0 |
| 2003-11-28 12:35:00 | AAPL | Stock | 0.3736 | 0.3738 | 0.373 | 0.3734 | 3091872.0 |
| 2003-11-28 12:40:00 | AAPL | Stock | 0.3734 | 0.3741 | 0.373 | 0.3736 | 2790480.0 |
| 2003-11-28 12:45:00 | AAPL | Stock | 0.3738 | 0.3738 | 0.373 | 0.3732 | 1441944.0 |
| 2003-11-28 12:50:00 | AAPL | Stock | 0.373 | 0.3741 | 0.373 | 0.3741 | 3739512.0 |
| 2003-11-28 12:55:00 | AAPL | Stock | 0.3741 | 0.3757 | 0.3723 | 0.3755 | 6348888.0 |
| 2003-11-28 13:00:00 | AAPL | Stock | 0.3738 | 0.3763 | 0.3729 | 0.3734 | 983808.0 |
| 2003-11-28 08:00:00 | MSFT | Stock | 25.5 | 25.6 | 25.5 | 25.6 | 500.0 |
| 2003-11-28 08:10:00 | MSFT | Stock | 25.47 | 25.47 | 25.47 | 25.47 | 100.0 |
| 2003-11-28 08:15:00 | MSFT | Stock | 25.47 | 25.47 | 25.47 | 25.47 | 2200.0 |
> showing 50 of 83,100 rows — these rows as CSV