PREVIEW / stock_30min / 2001-06-20
file: by_date/stock_30min/2001/2001-06-20.parquet size: 549 KB rows: 29,048 symbols: 1,312
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-06-20 08:00:00 | AAPL | Stock | 0.3589 | 0.3605 | 0.3589 | 0.3605 | 1271200.0 |
| 2001-06-20 08:30:00 | AAPL | Stock | 0.3575 | 0.3575 | 0.3573 | 0.3573 | 140000.0 |
| 2001-06-20 09:00:00 | AAPL | Stock | 0.3575 | 0.3577 | 0.3571 | 0.3571 | 2116800.0 |
| 2001-06-20 09:30:00 | AAPL | Stock | 0.3571 | 0.3696 | 0.3568 | 0.3691 | 44144800.0 |
| 2001-06-20 10:00:00 | AAPL | Stock | 0.3689 | 0.375 | 0.3679 | 0.3723 | 36752800.0 |
| 2001-06-20 10:30:00 | AAPL | Stock | 0.3723 | 0.3784 | 0.3714 | 0.3779 | 26678400.0 |
| 2001-06-20 11:00:00 | AAPL | Stock | 0.3782 | 0.3807 | 0.3764 | 0.3796 | 38690400.0 |
| 2001-06-20 11:30:00 | AAPL | Stock | 0.3795 | 0.3804 | 0.3768 | 0.3771 | 29288000.0 |
| 2001-06-20 12:00:00 | AAPL | Stock | 0.3764 | 0.3798 | 0.3755 | 0.377 | 26504800.0 |
| 2001-06-20 12:30:00 | AAPL | Stock | 0.377 | 0.3802 | 0.3761 | 0.3761 | 10746400.0 |
| 2001-06-20 13:00:00 | AAPL | Stock | 0.3761 | 0.3786 | 0.3759 | 0.377 | 12812800.0 |
| 2001-06-20 13:30:00 | AAPL | Stock | 0.3771 | 0.3782 | 0.3736 | 0.3766 | 20837600.0 |
| 2001-06-20 14:00:00 | AAPL | Stock | 0.3766 | 0.3836 | 0.3755 | 0.3834 | 21252000.0 |
| 2001-06-20 14:30:00 | AAPL | Stock | 0.3836 | 0.3838 | 0.3795 | 0.3818 | 29719200.0 |
| 2001-06-20 15:00:00 | AAPL | Stock | 0.382 | 0.3895 | 0.3818 | 0.3864 | 50713600.0 |
| 2001-06-20 15:30:00 | AAPL | Stock | 0.3863 | 0.3902 | 0.3855 | 0.387 | 48126400.0 |
| 2001-06-20 16:00:00 | AAPL | Stock | 0.387 | 0.3884 | 0.377 | 0.387 | 5028800.0 |
| 2001-06-20 16:30:00 | AAPL | Stock | 0.387 | 0.387 | 0.387 | 0.387 | 688800.0 |
| 2001-06-20 17:00:00 | AAPL | Stock | 0.387 | 0.387 | 0.3857 | 0.3857 | 386400.0 |
| 2001-06-20 18:00:00 | AAPL | Stock | 0.3857 | 0.3857 | 0.3857 | 0.3857 | 5600.0 |
| 2001-06-20 08:00:00 | MSFT | Stock | 33.59 | 33.59 | 33.25 | 33.575 | 9000.0 |
| 2001-06-20 08:30:00 | MSFT | Stock | 33.5 | 33.5 | 33.445 | 33.45 | 6000.0 |
| 2001-06-20 09:00:00 | MSFT | Stock | 33.3 | 33.6 | 33.3 | 33.555 | 105800.0 |
| 2001-06-20 09:30:00 | MSFT | Stock | 33.57 | 34.2 | 33.55 | 34.09 | 9152200.0 |
| 2001-06-20 10:00:00 | MSFT | Stock | 34.115 | 34.2 | 34.0 | 34.105 | 6243400.0 |
| 2001-06-20 10:30:00 | MSFT | Stock | 34.105 | 34.445 | 34.095 | 34.335 | 6926000.0 |
| 2001-06-20 11:00:00 | MSFT | Stock | 34.335 | 34.46 | 34.28 | 34.375 | 3707200.0 |
| 2001-06-20 11:30:00 | MSFT | Stock | 34.365 | 34.37 | 34.11 | 34.14 | 3016200.0 |
| 2001-06-20 12:00:00 | MSFT | Stock | 34.14 | 34.225 | 34.07 | 34.165 | 1851800.0 |
| 2001-06-20 12:30:00 | MSFT | Stock | 34.15 | 34.345 | 34.11 | 34.13 | 1278600.0 |
| 2001-06-20 13:00:00 | MSFT | Stock | 34.115 | 34.13 | 33.805 | 33.84 | 3118800.0 |
| 2001-06-20 13:30:00 | MSFT | Stock | 33.84 | 33.87 | 33.65 | 33.82 | 3675400.0 |
| 2001-06-20 14:00:00 | MSFT | Stock | 33.825 | 34.22 | 33.75 | 34.2 | 3776000.0 |
| 2001-06-20 14:30:00 | MSFT | Stock | 34.2 | 34.325 | 34.1 | 34.26 | 3449800.0 |
| 2001-06-20 15:00:00 | MSFT | Stock | 34.26 | 34.725 | 34.245 | 34.58 | 5957600.0 |
| 2001-06-20 15:30:00 | MSFT | Stock | 34.58 | 34.795 | 34.535 | 34.705 | 7023200.0 |
| 2001-06-20 16:00:00 | MSFT | Stock | 34.71 | 34.75 | 34.255 | 34.71 | 1179600.0 |
| 2001-06-20 16:30:00 | MSFT | Stock | 34.71 | 34.71 | 34.095 | 34.675 | 54200.0 |
| 2001-06-20 17:00:00 | MSFT | Stock | 33.555 | 34.715 | 33.555 | 34.715 | 200600.0 |
| 2001-06-20 17:30:00 | MSFT | Stock | 34.655 | 34.7 | 34.65 | 34.65 | 2200.0 |
| 2001-06-20 18:00:00 | MSFT | Stock | 34.675 | 34.71 | 34.675 | 34.71 | 1800.0 |
| 2001-06-20 08:00:00 | NVDA | Stock | 0.3542 | 0.3542 | 0.3542 | 0.3542 | 168000.0 |
| 2001-06-20 08:30:00 | NVDA | Stock | 0.3558 | 0.3558 | 0.3505 | 0.3525 | 2280000.0 |
| 2001-06-20 09:00:00 | NVDA | Stock | 0.3525 | 0.3596 | 0.3523 | 0.3537 | 14472000.0 |
| 2001-06-20 09:30:00 | NVDA | Stock | 0.353 | 0.3635 | 0.3506 | 0.3622 | 256008000.0 |
| 2001-06-20 10:00:00 | NVDA | Stock | 0.3622 | 0.3677 | 0.3552 | 0.3558 | 120672000.0 |
| 2001-06-20 10:30:00 | NVDA | Stock | 0.3559 | 0.3656 | 0.3537 | 0.365 | 119040000.0 |
| 2001-06-20 11:00:00 | NVDA | Stock | 0.3646 | 0.3709 | 0.364 | 0.3708 | 119472000.0 |
| 2001-06-20 11:30:00 | NVDA | Stock | 0.3705 | 0.3729 | 0.364 | 0.3669 | 91128000.0 |
| 2001-06-20 12:00:00 | NVDA | Stock | 0.3661 | 0.3668 | 0.3629 | 0.3632 | 58632000.0 |
> showing 50 of 29,048 rows — these rows as CSV