PREVIEW / stock_30min / 2001-01-31
file: by_date/stock_30min/2001/2001-01-31.parquet size: 561 KB rows: 28,333 symbols: 1,280
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-01-31 08:00:00 | AAPL | Stock | 0.3873 | 0.3873 | 0.3817 | 0.3873 | 16800.0 |
| 2001-01-31 08:30:00 | AAPL | Stock | 0.385 | 0.385 | 0.385 | 0.385 | 11200.0 |
| 2001-01-31 09:00:00 | AAPL | Stock | 0.3873 | 0.3873 | 0.3828 | 0.3839 | 817600.0 |
| 2001-01-31 09:30:00 | AAPL | Stock | 0.3839 | 0.3984 | 0.3828 | 0.3951 | 80567200.0 |
| 2001-01-31 10:00:00 | AAPL | Stock | 0.3951 | 0.4018 | 0.394 | 0.3996 | 58508800.0 |
| 2001-01-31 10:30:00 | AAPL | Stock | 0.3984 | 0.3996 | 0.3873 | 0.3906 | 88362400.0 |
| 2001-01-31 11:00:00 | AAPL | Stock | 0.3895 | 0.394 | 0.3884 | 0.3895 | 27221600.0 |
| 2001-01-31 11:30:00 | AAPL | Stock | 0.3895 | 0.3917 | 0.3884 | 0.3917 | 15019200.0 |
| 2001-01-31 12:00:00 | AAPL | Stock | 0.3906 | 0.3929 | 0.3895 | 0.3906 | 18480000.0 |
| 2001-01-31 12:30:00 | AAPL | Stock | 0.3917 | 0.394 | 0.3906 | 0.3929 | 10085600.0 |
| 2001-01-31 13:00:00 | AAPL | Stock | 0.3929 | 0.4007 | 0.3917 | 0.3962 | 65167200.0 |
| 2001-01-31 13:30:00 | AAPL | Stock | 0.3962 | 0.4007 | 0.3962 | 0.3984 | 18978400.0 |
| 2001-01-31 14:00:00 | AAPL | Stock | 0.3984 | 0.4018 | 0.3917 | 0.3951 | 40594400.0 |
| 2001-01-31 14:30:00 | AAPL | Stock | 0.3951 | 0.3973 | 0.3906 | 0.3929 | 82314400.0 |
| 2001-01-31 15:00:00 | AAPL | Stock | 0.3929 | 0.3951 | 0.3873 | 0.3884 | 29360800.0 |
| 2001-01-31 15:30:00 | AAPL | Stock | 0.3884 | 0.3917 | 0.385 | 0.3873 | 71271200.0 |
| 2001-01-31 16:00:00 | AAPL | Stock | 0.3873 | 0.3962 | 0.3839 | 0.3884 | 21308000.0 |
| 2001-01-31 16:30:00 | AAPL | Stock | 0.3906 | 0.3917 | 0.3839 | 0.3884 | 700000.0 |
| 2001-01-31 17:00:00 | AAPL | Stock | 0.3862 | 0.3873 | 0.3862 | 0.3862 | 123200.0 |
| 2001-01-31 17:30:00 | AAPL | Stock | 0.3862 | 0.3862 | 0.3817 | 0.3817 | 263200.0 |
| 2001-01-31 18:00:00 | AAPL | Stock | 0.3839 | 0.3839 | 0.3795 | 0.3795 | 196000.0 |
| 2001-01-31 08:00:00 | MSFT | Stock | 31.5625 | 31.7188 | 31.5 | 31.6875 | 33800.0 |
| 2001-01-31 08:30:00 | MSFT | Stock | 31.5625 | 31.6875 | 31.4688 | 31.625 | 51400.0 |
| 2001-01-31 09:00:00 | MSFT | Stock | 31.5 | 31.625 | 31.4688 | 31.5 | 284800.0 |
| 2001-01-31 09:30:00 | MSFT | Stock | 31.5 | 31.875 | 31.4688 | 31.5938 | 4980000.0 |
| 2001-01-31 10:00:00 | MSFT | Stock | 31.625 | 31.6875 | 31.375 | 31.4531 | 4881200.0 |
| 2001-01-31 10:30:00 | MSFT | Stock | 31.4688 | 31.625 | 31.375 | 31.5625 | 3346200.0 |
| 2001-01-31 11:00:00 | MSFT | Stock | 31.5781 | 31.5938 | 31.25 | 31.3438 | 4399600.0 |
| 2001-01-31 11:30:00 | MSFT | Stock | 31.3438 | 31.5 | 31.2812 | 31.4688 | 3349600.0 |
| 2001-01-31 12:00:00 | MSFT | Stock | 31.5 | 31.5312 | 31.2812 | 31.4375 | 2963800.0 |
| 2001-01-31 12:30:00 | MSFT | Stock | 31.4375 | 31.6562 | 31.375 | 31.5312 | 3561800.0 |
| 2001-01-31 13:00:00 | MSFT | Stock | 31.5312 | 31.625 | 31.3438 | 31.4062 | 2818600.0 |
| 2001-01-31 13:30:00 | MSFT | Stock | 31.375 | 31.4688 | 31.25 | 31.2812 | 4350800.0 |
| 2001-01-31 14:00:00 | MSFT | Stock | 31.25 | 31.625 | 31.0312 | 31.1562 | 10612800.0 |
| 2001-01-31 14:30:00 | MSFT | Stock | 31.1562 | 31.3125 | 31.0 | 31.1875 | 6126000.0 |
| 2001-01-31 15:00:00 | MSFT | Stock | 31.1875 | 31.25 | 30.7188 | 30.7812 | 5822600.0 |
| 2001-01-31 15:30:00 | MSFT | Stock | 30.8125 | 30.9375 | 30.5 | 30.5312 | 10773200.0 |
| 2001-01-31 16:00:00 | MSFT | Stock | 30.5312 | 31.4062 | 30.4375 | 30.5 | 4374400.0 |
| 2001-01-31 16:30:00 | MSFT | Stock | 30.5 | 30.6094 | 30.375 | 30.375 | 566800.0 |
| 2001-01-31 17:00:00 | MSFT | Stock | 30.3906 | 30.4375 | 30.25 | 30.3125 | 43000.0 |
| 2001-01-31 17:30:00 | MSFT | Stock | 30.3125 | 30.3438 | 30.2812 | 30.3438 | 43200.0 |
| 2001-01-31 18:00:00 | MSFT | Stock | 30.3438 | 30.5312 | 30.25 | 30.25 | 75800.0 |
| 2001-01-31 08:00:00 | NVDA | Stock | 0.2125 | 0.2125 | 0.2125 | 0.2125 | 24000.0 |
| 2001-01-31 08:30:00 | NVDA | Stock | 0.2135 | 0.2135 | 0.2125 | 0.2125 | 264000.0 |
| 2001-01-31 09:30:00 | NVDA | Stock | 0.2177 | 0.2219 | 0.2159 | 0.2201 | 34440000.0 |
| 2001-01-31 10:00:00 | NVDA | Stock | 0.2202 | 0.2234 | 0.219 | 0.2224 | 17208000.0 |
| 2001-01-31 10:30:00 | NVDA | Stock | 0.2227 | 0.226 | 0.2216 | 0.2253 | 34320000.0 |
| 2001-01-31 11:00:00 | NVDA | Stock | 0.225 | 0.2253 | 0.2214 | 0.2229 | 7512000.0 |
| 2001-01-31 11:30:00 | NVDA | Stock | 0.2227 | 0.2229 | 0.2201 | 0.2208 | 13728000.0 |
| 2001-01-31 12:00:00 | NVDA | Stock | 0.2208 | 0.2219 | 0.219 | 0.2203 | 13104000.0 |
> showing 50 of 28,333 rows — these rows as CSV