PREVIEW / stock_30min / 2000-07-19
file: by_date/stock_30min/2000/2000-07-19.parquet size: 419 KB rows: 24,579 symbols: 1,188
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 |
|---|---|---|---|---|---|---|---|
| 2000-07-19 08:00:00 | AAPL | Stock | 0.9732 | 0.9866 | 0.9509 | 0.9799 | 5700800.0 |
| 2000-07-19 08:30:00 | AAPL | Stock | 0.9799 | 1.0229 | 0.9732 | 1.0045 | 4429600.0 |
| 2000-07-19 09:00:00 | AAPL | Stock | 1.0 | 1.0 | 0.9621 | 0.9833 | 2990400.0 |
| 2000-07-19 09:30:00 | AAPL | Stock | 0.9855 | 1.0145 | 0.9766 | 0.9777 | 53076800.0 |
| 2000-07-19 10:00:00 | AAPL | Stock | 0.9777 | 0.9844 | 0.9598 | 0.971 | 41137600.0 |
| 2000-07-19 10:30:00 | AAPL | Stock | 0.971 | 0.9777 | 0.9632 | 0.9632 | 28112000.0 |
| 2000-07-19 11:00:00 | AAPL | Stock | 0.9632 | 0.9721 | 0.9621 | 0.971 | 39104800.0 |
| 2000-07-19 11:30:00 | AAPL | Stock | 0.9676 | 0.9799 | 0.9509 | 0.9542 | 37917600.0 |
| 2000-07-19 12:00:00 | AAPL | Stock | 0.9554 | 0.9626 | 0.9531 | 0.9565 | 14739200.0 |
| 2000-07-19 12:30:00 | AAPL | Stock | 0.9565 | 0.9576 | 0.9397 | 0.9442 | 26124000.0 |
| 2000-07-19 13:00:00 | AAPL | Stock | 0.9431 | 0.9554 | 0.942 | 0.9464 | 21610400.0 |
| 2000-07-19 13:30:00 | AAPL | Stock | 0.9487 | 0.9487 | 0.9386 | 0.9397 | 12471200.0 |
| 2000-07-19 14:00:00 | AAPL | Stock | 0.9397 | 0.9509 | 0.9358 | 0.9475 | 18894400.0 |
| 2000-07-19 14:30:00 | AAPL | Stock | 0.9475 | 0.9487 | 0.9353 | 0.9364 | 29080800.0 |
| 2000-07-19 15:00:00 | AAPL | Stock | 0.9353 | 0.9386 | 0.9241 | 0.9286 | 47835200.0 |
| 2000-07-19 15:30:00 | AAPL | Stock | 0.9275 | 0.9487 | 0.9275 | 0.9397 | 45264800.0 |
| 2000-07-19 16:00:00 | AAPL | Stock | 0.9408 | 0.9554 | 0.9252 | 0.9408 | 12174400.0 |
| 2000-07-19 16:30:00 | AAPL | Stock | 0.9442 | 0.9531 | 0.9408 | 0.9464 | 1657600.0 |
| 2000-07-19 17:00:00 | AAPL | Stock | 0.9531 | 0.9554 | 0.9464 | 0.9531 | 173600.0 |
| 2000-07-19 17:30:00 | AAPL | Stock | 0.952 | 0.9554 | 0.952 | 0.9531 | 229600.0 |
| 2000-07-19 18:00:00 | AAPL | Stock | 0.9542 | 0.9542 | 0.9464 | 0.9464 | 56000.0 |
| 2000-07-19 08:00:00 | MSFT | Stock | 37.75 | 39.5 | 37.5 | 38.25 | 698200.0 |
| 2000-07-19 08:30:00 | MSFT | Stock | 38.25 | 39.2344 | 38.0625 | 38.25 | 355200.0 |
| 2000-07-19 09:00:00 | MSFT | Stock | 38.1875 | 38.375 | 37.625 | 38.125 | 716600.0 |
| 2000-07-19 09:30:00 | MSFT | Stock | 38.0312 | 38.25 | 37.3438 | 37.5156 | 23484000.0 |
| 2000-07-19 10:00:00 | MSFT | Stock | 37.5 | 37.5625 | 37.25 | 37.375 | 14750400.0 |
| 2000-07-19 10:30:00 | MSFT | Stock | 37.375 | 37.4688 | 37.0938 | 37.2188 | 12510200.0 |
| 2000-07-19 11:00:00 | MSFT | Stock | 37.1875 | 37.25 | 36.75 | 36.7812 | 10403800.0 |
| 2000-07-19 11:30:00 | MSFT | Stock | 36.7812 | 36.8125 | 36.4688 | 36.4688 | 12361000.0 |
| 2000-07-19 12:00:00 | MSFT | Stock | 36.5 | 36.8438 | 36.4688 | 36.75 | 11345800.0 |
| 2000-07-19 12:30:00 | MSFT | Stock | 36.7188 | 36.875 | 36.6875 | 36.8438 | 5342200.0 |
| 2000-07-19 13:00:00 | MSFT | Stock | 36.8438 | 37.0625 | 36.7188 | 36.875 | 5476000.0 |
| 2000-07-19 13:30:00 | MSFT | Stock | 36.8438 | 36.9375 | 36.625 | 36.6562 | 3821000.0 |
| 2000-07-19 14:00:00 | MSFT | Stock | 36.6875 | 36.7812 | 36.625 | 36.6875 | 5423600.0 |
| 2000-07-19 14:30:00 | MSFT | Stock | 36.6875 | 36.7812 | 36.5938 | 36.625 | 7056600.0 |
| 2000-07-19 15:00:00 | MSFT | Stock | 36.625 | 36.7188 | 36.4688 | 36.5156 | 8211600.0 |
| 2000-07-19 15:30:00 | MSFT | Stock | 36.5625 | 36.8125 | 36.4062 | 36.5312 | 12045800.0 |
| 2000-07-19 16:00:00 | MSFT | Stock | 36.5625 | 38.0312 | 36.5 | 36.6562 | 2739600.0 |
| 2000-07-19 16:30:00 | MSFT | Stock | 36.6562 | 38.1562 | 36.5625 | 36.5938 | 249800.0 |
| 2000-07-19 17:00:00 | MSFT | Stock | 36.7188 | 37.0938 | 36.6875 | 36.6875 | 77200.0 |
| 2000-07-19 17:30:00 | MSFT | Stock | 36.7188 | 36.75 | 36.6875 | 36.75 | 8200.0 |
| 2000-07-19 18:00:00 | MSFT | Stock | 36.75 | 36.8281 | 36.7188 | 36.7812 | 21400.0 |
| 2000-07-19 09:00:00 | NVDA | Stock | 0.2917 | 0.2917 | 0.2875 | 0.2875 | 1704000.0 |
| 2000-07-19 09:30:00 | NVDA | Stock | 0.2875 | 0.2891 | 0.2813 | 0.2828 | 36024000.0 |
| 2000-07-19 10:00:00 | NVDA | Stock | 0.2826 | 0.287 | 0.2813 | 0.287 | 23352000.0 |
| 2000-07-19 10:30:00 | NVDA | Stock | 0.287 | 0.2896 | 0.2862 | 0.2875 | 6936000.0 |
| 2000-07-19 11:00:00 | NVDA | Stock | 0.2875 | 0.2875 | 0.2742 | 0.275 | 24288000.0 |
| 2000-07-19 11:30:00 | NVDA | Stock | 0.2734 | 0.2802 | 0.2732 | 0.2784 | 16488000.0 |
| 2000-07-19 12:00:00 | NVDA | Stock | 0.2781 | 0.2833 | 0.2781 | 0.2828 | 7032000.0 |
| 2000-07-19 12:30:00 | NVDA | Stock | 0.2818 | 0.2833 | 0.2786 | 0.2789 | 15360000.0 |
> showing 50 of 24,579 rows — these rows as CSV