PREVIEW / stock_30min / 2000-07-20
file: by_date/stock_30min/2000/2000-07-20.parquet size: 431 KB rows: 24,972 symbols: 1,196
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-20 08:00:00 | AAPL | Stock | 0.9554 | 0.9732 | 0.9542 | 0.9732 | 212800.0 |
| 2000-07-20 08:30:00 | AAPL | Stock | 0.9464 | 0.9754 | 0.9464 | 0.9688 | 291200.0 |
| 2000-07-20 09:00:00 | AAPL | Stock | 0.9688 | 0.9821 | 0.9643 | 0.9821 | 3970400.0 |
| 2000-07-20 09:30:00 | AAPL | Stock | 0.9821 | 1.0089 | 0.9799 | 0.9922 | 94981600.0 |
| 2000-07-20 10:00:00 | AAPL | Stock | 0.9933 | 1.019 | 0.9922 | 1.0045 | 56868000.0 |
| 2000-07-20 10:30:00 | AAPL | Stock | 1.0045 | 1.01 | 0.9933 | 0.9944 | 34725600.0 |
| 2000-07-20 11:00:00 | AAPL | Stock | 0.9944 | 0.9978 | 0.981 | 0.9821 | 45802400.0 |
| 2000-07-20 11:30:00 | AAPL | Stock | 0.9833 | 0.9855 | 0.9766 | 0.981 | 36388800.0 |
| 2000-07-20 12:00:00 | AAPL | Stock | 0.9805 | 0.9855 | 0.9777 | 0.9821 | 22876000.0 |
| 2000-07-20 12:30:00 | AAPL | Stock | 0.9821 | 0.9855 | 0.981 | 0.9855 | 12930400.0 |
| 2000-07-20 13:00:00 | AAPL | Stock | 0.9855 | 0.9877 | 0.9766 | 0.9777 | 17511200.0 |
| 2000-07-20 13:30:00 | AAPL | Stock | 0.9777 | 0.9788 | 0.9665 | 0.9721 | 26000800.0 |
| 2000-07-20 14:00:00 | AAPL | Stock | 0.9732 | 0.9866 | 0.9721 | 0.981 | 15859200.0 |
| 2000-07-20 14:30:00 | AAPL | Stock | 0.9799 | 0.9833 | 0.9754 | 0.9799 | 19986400.0 |
| 2000-07-20 15:00:00 | AAPL | Stock | 0.9794 | 0.9877 | 0.9788 | 0.9855 | 16284800.0 |
| 2000-07-20 15:30:00 | AAPL | Stock | 0.9855 | 0.9911 | 0.9821 | 0.9833 | 28145600.0 |
| 2000-07-20 16:00:00 | AAPL | Stock | 0.9833 | 0.9955 | 0.9721 | 0.99 | 3494400.0 |
| 2000-07-20 16:30:00 | AAPL | Stock | 0.9844 | 0.9888 | 0.9821 | 0.9844 | 84000.0 |
| 2000-07-20 17:00:00 | AAPL | Stock | 0.9911 | 0.9916 | 0.9821 | 0.9821 | 856800.0 |
| 2000-07-20 17:30:00 | AAPL | Stock | 0.9933 | 0.9933 | 0.9933 | 0.9933 | 28000.0 |
| 2000-07-20 18:00:00 | AAPL | Stock | 0.9833 | 0.9955 | 0.9833 | 0.9955 | 33600.0 |
| 2000-07-20 08:00:00 | MSFT | Stock | 36.6562 | 37.25 | 36.5 | 36.875 | 87600.0 |
| 2000-07-20 08:30:00 | MSFT | Stock | 36.8125 | 36.8125 | 36.7188 | 36.8125 | 75400.0 |
| 2000-07-20 09:00:00 | MSFT | Stock | 36.75 | 36.8438 | 36.6875 | 36.7188 | 240400.0 |
| 2000-07-20 09:30:00 | MSFT | Stock | 36.7188 | 36.9688 | 36.5625 | 36.9688 | 8272800.0 |
| 2000-07-20 10:00:00 | MSFT | Stock | 36.9531 | 37.4375 | 36.875 | 37.25 | 7396800.0 |
| 2000-07-20 10:30:00 | MSFT | Stock | 37.25 | 37.375 | 37.1562 | 37.1875 | 4941200.0 |
| 2000-07-20 11:00:00 | MSFT | Stock | 37.2188 | 37.25 | 37.125 | 37.2188 | 3616200.0 |
| 2000-07-20 11:30:00 | MSFT | Stock | 37.2031 | 37.4844 | 37.1562 | 37.4688 | 3979600.0 |
| 2000-07-20 12:00:00 | MSFT | Stock | 37.4688 | 37.5 | 37.3125 | 37.375 | 3387400.0 |
| 2000-07-20 12:30:00 | MSFT | Stock | 37.375 | 37.4688 | 37.3125 | 37.3125 | 1737400.0 |
| 2000-07-20 13:00:00 | MSFT | Stock | 37.3438 | 37.375 | 37.25 | 37.3125 | 1572800.0 |
| 2000-07-20 13:30:00 | MSFT | Stock | 37.3438 | 37.4688 | 37.3125 | 37.4062 | 1640600.0 |
| 2000-07-20 14:00:00 | MSFT | Stock | 37.4062 | 37.5625 | 37.375 | 37.5312 | 3953600.0 |
| 2000-07-20 14:30:00 | MSFT | Stock | 37.5312 | 37.625 | 37.375 | 37.4375 | 4289600.0 |
| 2000-07-20 15:00:00 | MSFT | Stock | 37.5 | 37.5312 | 37.3125 | 37.375 | 2843800.0 |
| 2000-07-20 15:30:00 | MSFT | Stock | 37.3438 | 37.5938 | 37.1875 | 37.4062 | 3761200.0 |
| 2000-07-20 16:00:00 | MSFT | Stock | 37.4062 | 37.5 | 36.7344 | 37.4844 | 1342000.0 |
| 2000-07-20 16:30:00 | MSFT | Stock | 37.4688 | 37.5 | 37.4375 | 37.4375 | 7400.0 |
| 2000-07-20 17:00:00 | MSFT | Stock | 37.25 | 37.5 | 37.25 | 37.4375 | 183400.0 |
| 2000-07-20 17:30:00 | MSFT | Stock | 37.4375 | 37.5 | 37.4375 | 37.4375 | 6400.0 |
| 2000-07-20 18:00:00 | MSFT | Stock | 37.4375 | 37.4375 | 37.4375 | 37.4375 | 800.0 |
| 2000-07-20 09:00:00 | NVDA | Stock | 0.2789 | 0.2789 | 0.2789 | 0.2789 | 48000.0 |
| 2000-07-20 09:30:00 | NVDA | Stock | 0.2789 | 0.2938 | 0.2781 | 0.2875 | 23136000.0 |
| 2000-07-20 10:00:00 | NVDA | Stock | 0.2844 | 0.2927 | 0.2844 | 0.2896 | 9096000.0 |
| 2000-07-20 10:30:00 | NVDA | Stock | 0.2888 | 0.2914 | 0.2875 | 0.2885 | 7008000.0 |
| 2000-07-20 11:00:00 | NVDA | Stock | 0.2891 | 0.2906 | 0.2833 | 0.2885 | 8736000.0 |
| 2000-07-20 11:30:00 | NVDA | Stock | 0.2849 | 0.2875 | 0.2844 | 0.2875 | 4272000.0 |
| 2000-07-20 12:00:00 | NVDA | Stock | 0.2875 | 0.288 | 0.2852 | 0.288 | 10536000.0 |
| 2000-07-20 12:30:00 | NVDA | Stock | 0.2876 | 0.2885 | 0.2865 | 0.2883 | 16680000.0 |
> showing 50 of 24,972 rows — these rows as CSV