PREVIEW / stock_30min / 2000-10-23
file: by_date/stock_30min/2000/2000-10-23.parquet size: 437 KB rows: 25,312 symbols: 1,232
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-10-23 08:00:00 | AAPL | Stock | 0.3661 | 0.3661 | 0.3527 | 0.3527 | 89600.0 |
| 2000-10-23 08:30:00 | AAPL | Stock | 0.3504 | 0.3549 | 0.3504 | 0.3527 | 162400.0 |
| 2000-10-23 09:00:00 | AAPL | Stock | 0.3527 | 0.3571 | 0.3482 | 0.3571 | 4636800.0 |
| 2000-10-23 09:30:00 | AAPL | Stock | 0.3571 | 0.3616 | 0.3471 | 0.3516 | 53642400.0 |
| 2000-10-23 10:00:00 | AAPL | Stock | 0.3516 | 0.3616 | 0.3504 | 0.3616 | 56761600.0 |
| 2000-10-23 10:30:00 | AAPL | Stock | 0.3611 | 0.3672 | 0.3605 | 0.365 | 87298400.0 |
| 2000-10-23 11:00:00 | AAPL | Stock | 0.365 | 0.365 | 0.3594 | 0.3627 | 28700000.0 |
| 2000-10-23 11:30:00 | AAPL | Stock | 0.3616 | 0.3638 | 0.3605 | 0.3627 | 25267200.0 |
| 2000-10-23 12:00:00 | AAPL | Stock | 0.3627 | 0.365 | 0.3594 | 0.3616 | 61633600.0 |
| 2000-10-23 12:30:00 | AAPL | Stock | 0.3616 | 0.3638 | 0.3605 | 0.3627 | 18043200.0 |
| 2000-10-23 13:00:00 | AAPL | Stock | 0.3622 | 0.365 | 0.3605 | 0.3622 | 26700800.0 |
| 2000-10-23 13:30:00 | AAPL | Stock | 0.3616 | 0.365 | 0.3616 | 0.3627 | 14660800.0 |
| 2000-10-23 14:00:00 | AAPL | Stock | 0.3622 | 0.3638 | 0.3616 | 0.3627 | 17320800.0 |
| 2000-10-23 14:30:00 | AAPL | Stock | 0.3627 | 0.3638 | 0.3571 | 0.3571 | 18407200.0 |
| 2000-10-23 15:00:00 | AAPL | Stock | 0.3571 | 0.3638 | 0.3571 | 0.3627 | 31746400.0 |
| 2000-10-23 15:30:00 | AAPL | Stock | 0.3627 | 0.365 | 0.3605 | 0.3616 | 40224800.0 |
| 2000-10-23 16:00:00 | AAPL | Stock | 0.3627 | 0.3728 | 0.3599 | 0.3638 | 30156000.0 |
| 2000-10-23 16:30:00 | AAPL | Stock | 0.3638 | 0.3661 | 0.3638 | 0.3661 | 1629600.0 |
| 2000-10-23 17:00:00 | AAPL | Stock | 0.3661 | 0.3661 | 0.3661 | 0.3661 | 11200.0 |
| 2000-10-23 17:30:00 | AAPL | Stock | 0.3638 | 0.3644 | 0.3638 | 0.3644 | 128800.0 |
| 2000-10-23 18:00:00 | AAPL | Stock | 0.3638 | 0.3638 | 0.3638 | 0.3638 | 106400.0 |
| 2000-10-23 08:00:00 | MSFT | Stock | 32.5 | 32.5 | 32.0 | 32.25 | 3600.0 |
| 2000-10-23 08:30:00 | MSFT | Stock | 32.1875 | 32.4062 | 32.125 | 32.3125 | 32200.0 |
| 2000-10-23 09:00:00 | MSFT | Stock | 32.3125 | 32.4688 | 32.25 | 32.3125 | 339600.0 |
| 2000-10-23 09:30:00 | MSFT | Stock | 32.3125 | 33.125 | 32.25 | 32.5312 | 14161800.0 |
| 2000-10-23 10:00:00 | MSFT | Stock | 32.5 | 32.5938 | 31.7812 | 31.8438 | 17535000.0 |
| 2000-10-23 10:30:00 | MSFT | Stock | 31.8438 | 32.0625 | 31.6562 | 31.7812 | 19095200.0 |
| 2000-10-23 11:00:00 | MSFT | Stock | 31.8125 | 31.9062 | 31.6562 | 31.7812 | 6486200.0 |
| 2000-10-23 11:30:00 | MSFT | Stock | 31.7812 | 31.9688 | 31.6562 | 31.75 | 5396600.0 |
| 2000-10-23 12:00:00 | MSFT | Stock | 31.7812 | 31.7812 | 31.1562 | 31.3125 | 14446200.0 |
| 2000-10-23 12:30:00 | MSFT | Stock | 31.2812 | 31.3125 | 31.0 | 31.2188 | 19445400.0 |
| 2000-10-23 13:00:00 | MSFT | Stock | 31.1875 | 31.2188 | 30.6562 | 30.7188 | 7015800.0 |
| 2000-10-23 13:30:00 | MSFT | Stock | 30.7188 | 30.75 | 30.5312 | 30.6875 | 14451800.0 |
| 2000-10-23 14:00:00 | MSFT | Stock | 30.6719 | 30.875 | 30.4062 | 30.5 | 12196800.0 |
| 2000-10-23 14:30:00 | MSFT | Stock | 30.5 | 30.6875 | 30.3438 | 30.625 | 9168000.0 |
| 2000-10-23 15:00:00 | MSFT | Stock | 30.625 | 30.75 | 30.5 | 30.5938 | 11424400.0 |
| 2000-10-23 15:30:00 | MSFT | Stock | 30.5938 | 31.125 | 30.5625 | 31.0312 | 16113400.0 |
| 2000-10-23 16:00:00 | MSFT | Stock | 31.0312 | 31.6562 | 30.7031 | 31.0625 | 5992800.0 |
| 2000-10-23 16:30:00 | MSFT | Stock | 31.125 | 31.1875 | 31.0 | 31.0 | 49400.0 |
| 2000-10-23 17:00:00 | MSFT | Stock | 31.0625 | 31.0781 | 30.9375 | 31.0781 | 14200.0 |
| 2000-10-23 17:30:00 | MSFT | Stock | 31.0 | 31.0625 | 31.0 | 31.0312 | 5600.0 |
| 2000-10-23 18:00:00 | MSFT | Stock | 31.0 | 31.0312 | 31.0 | 31.0312 | 5400.0 |
| 2000-10-23 09:30:00 | NVDA | Stock | 0.2924 | 0.2943 | 0.2893 | 0.2917 | 23496000.0 |
| 2000-10-23 10:00:00 | NVDA | Stock | 0.2917 | 0.2917 | 0.2818 | 0.2833 | 27384000.0 |
| 2000-10-23 10:30:00 | NVDA | Stock | 0.2833 | 0.2922 | 0.2818 | 0.2865 | 15792000.0 |
| 2000-10-23 11:00:00 | NVDA | Stock | 0.2865 | 0.2896 | 0.2839 | 0.2839 | 5760000.0 |
| 2000-10-23 11:30:00 | NVDA | Stock | 0.2844 | 0.2844 | 0.2818 | 0.2833 | 12864000.0 |
| 2000-10-23 12:00:00 | NVDA | Stock | 0.2828 | 0.2924 | 0.2828 | 0.2906 | 17280000.0 |
| 2000-10-23 12:30:00 | NVDA | Stock | 0.2917 | 0.2917 | 0.2885 | 0.2901 | 8232000.0 |
| 2000-10-23 13:00:00 | NVDA | Stock | 0.2896 | 0.2901 | 0.288 | 0.2891 | 6288000.0 |
> showing 50 of 25,312 rows — these rows as CSV