PREVIEW / stock_30min / 2002-01-17
file: by_date/stock_30min/2002/2002-01-17.parquet size: 581 KB rows: 29,856 symbols: 1,348
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 |
|---|---|---|---|---|---|---|---|
| 2002-01-17 08:00:00 | AAPL | Stock | 0.3955 | 0.3964 | 0.3804 | 0.392 | 2878400.0 |
| 2002-01-17 08:30:00 | AAPL | Stock | 0.3921 | 0.3936 | 0.3916 | 0.392 | 3242400.0 |
| 2002-01-17 09:00:00 | AAPL | Stock | 0.3925 | 0.393 | 0.3893 | 0.3929 | 11244800.0 |
| 2002-01-17 09:30:00 | AAPL | Stock | 0.3923 | 0.4002 | 0.3913 | 0.3938 | 154761600.0 |
| 2002-01-17 10:00:00 | AAPL | Stock | 0.3938 | 0.3948 | 0.3905 | 0.3925 | 79654400.0 |
| 2002-01-17 10:30:00 | AAPL | Stock | 0.3923 | 0.3961 | 0.3911 | 0.3946 | 55272000.0 |
| 2002-01-17 11:00:00 | AAPL | Stock | 0.3946 | 0.3955 | 0.3925 | 0.393 | 28621600.0 |
| 2002-01-17 11:30:00 | AAPL | Stock | 0.3929 | 0.3941 | 0.3905 | 0.3932 | 37973600.0 |
| 2002-01-17 12:00:00 | AAPL | Stock | 0.3934 | 0.3961 | 0.393 | 0.3945 | 28229600.0 |
| 2002-01-17 12:30:00 | AAPL | Stock | 0.3946 | 0.3979 | 0.3945 | 0.3971 | 27384000.0 |
| 2002-01-17 13:00:00 | AAPL | Stock | 0.397 | 0.3979 | 0.395 | 0.3952 | 10668000.0 |
| 2002-01-17 13:30:00 | AAPL | Stock | 0.395 | 0.3968 | 0.3943 | 0.3955 | 12616800.0 |
| 2002-01-17 14:00:00 | AAPL | Stock | 0.3959 | 0.3961 | 0.3914 | 0.393 | 24063200.0 |
| 2002-01-17 14:30:00 | AAPL | Stock | 0.393 | 0.3969 | 0.393 | 0.3964 | 22590400.0 |
| 2002-01-17 15:00:00 | AAPL | Stock | 0.3959 | 0.4029 | 0.3959 | 0.4016 | 71265600.0 |
| 2002-01-17 15:30:00 | AAPL | Stock | 0.4016 | 0.4061 | 0.3988 | 0.4014 | 56744800.0 |
| 2002-01-17 16:00:00 | AAPL | Stock | 0.4014 | 0.4018 | 0.3955 | 0.3984 | 17752000.0 |
| 2002-01-17 16:30:00 | AAPL | Stock | 0.3986 | 0.4014 | 0.3957 | 0.3957 | 1310400.0 |
| 2002-01-17 17:00:00 | AAPL | Stock | 0.4014 | 0.4014 | 0.4014 | 0.4014 | 128800.0 |
| 2002-01-17 17:30:00 | AAPL | Stock | 0.3957 | 0.3963 | 0.3929 | 0.393 | 644000.0 |
| 2002-01-17 18:00:00 | AAPL | Stock | 0.3932 | 0.3932 | 0.3857 | 0.3877 | 716800.0 |
| 2002-01-17 08:00:00 | MSFT | Stock | 34.325 | 34.325 | 34.15 | 34.25 | 63400.0 |
| 2002-01-17 08:30:00 | MSFT | Stock | 34.25 | 34.29 | 34.15 | 34.255 | 145000.0 |
| 2002-01-17 09:00:00 | MSFT | Stock | 34.275 | 34.35 | 34.25 | 34.25 | 378200.0 |
| 2002-01-17 09:30:00 | MSFT | Stock | 34.265 | 34.49 | 34.2 | 34.4 | 6875000.0 |
| 2002-01-17 10:00:00 | MSFT | Stock | 34.3945 | 34.55 | 34.3495 | 34.535 | 5592400.0 |
| 2002-01-17 10:30:00 | MSFT | Stock | 34.535 | 34.72 | 34.52 | 34.67 | 4374400.0 |
| 2002-01-17 11:00:00 | MSFT | Stock | 34.675 | 34.685 | 34.515 | 34.6 | 4242800.0 |
| 2002-01-17 11:30:00 | MSFT | Stock | 34.6 | 34.75 | 34.57 | 34.69 | 3649400.0 |
| 2002-01-17 12:00:00 | MSFT | Stock | 34.7 | 34.775 | 34.66 | 34.775 | 3740800.0 |
| 2002-01-17 12:30:00 | MSFT | Stock | 34.775 | 34.875 | 34.765 | 34.795 | 3706200.0 |
| 2002-01-17 13:00:00 | MSFT | Stock | 34.795 | 34.835 | 34.71 | 34.755 | 2708600.0 |
| 2002-01-17 13:30:00 | MSFT | Stock | 34.755 | 34.87 | 34.735 | 34.82 | 2499400.0 |
| 2002-01-17 14:00:00 | MSFT | Stock | 34.815 | 34.85 | 34.65 | 34.69 | 3459000.0 |
| 2002-01-17 14:30:00 | MSFT | Stock | 34.685 | 34.9 | 34.65 | 34.89 | 3677600.0 |
| 2002-01-17 15:00:00 | MSFT | Stock | 34.8895 | 34.98 | 34.816 | 34.965 | 4936600.0 |
| 2002-01-17 15:30:00 | MSFT | Stock | 34.965 | 35.0005 | 34.85 | 34.925 | 12527400.0 |
| 2002-01-17 16:00:00 | MSFT | Stock | 34.925 | 34.995 | 33.85 | 34.32 | 6700400.0 |
| 2002-01-17 16:30:00 | MSFT | Stock | 34.32 | 34.93 | 33.9 | 34.16 | 5212800.0 |
| 2002-01-17 17:00:00 | MSFT | Stock | 34.18 | 34.93 | 34.0 | 34.165 | 567600.0 |
| 2002-01-17 17:30:00 | MSFT | Stock | 34.15 | 34.25 | 34.025 | 34.15 | 1128200.0 |
| 2002-01-17 18:00:00 | MSFT | Stock | 34.155 | 34.18 | 33.45 | 33.575 | 1295800.0 |
| 2002-01-17 08:00:00 | NVDA | Stock | 0.5354 | 0.5412 | 0.5312 | 0.5376 | 6036000.0 |
| 2002-01-17 08:30:00 | NVDA | Stock | 0.5375 | 0.5415 | 0.535 | 0.5375 | 4404000.0 |
| 2002-01-17 09:00:00 | NVDA | Stock | 0.5375 | 0.5412 | 0.5365 | 0.5406 | 4812000.0 |
| 2002-01-17 09:30:00 | NVDA | Stock | 0.5406 | 0.5412 | 0.5313 | 0.5327 | 145872000.0 |
| 2002-01-17 10:00:00 | NVDA | Stock | 0.5327 | 0.537 | 0.5309 | 0.5333 | 107112000.0 |
| 2002-01-17 10:30:00 | NVDA | Stock | 0.5331 | 0.5333 | 0.5297 | 0.531 | 72444000.0 |
| 2002-01-17 11:00:00 | NVDA | Stock | 0.5313 | 0.5322 | 0.5232 | 0.5238 | 95136000.0 |
| 2002-01-17 11:30:00 | NVDA | Stock | 0.5233 | 0.5272 | 0.521 | 0.5262 | 80136000.0 |
> showing 50 of 29,856 rows — these rows as CSV