PREVIEW / stock_30min / 2000-09-18
file: by_date/stock_30min/2000/2000-09-18.parquet size: 442 KB rows: 25,819 symbols: 1,224
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-09-18 08:00:00 | AAPL | Stock | 0.9861 | 0.9866 | 0.9861 | 0.9866 | 548800.0 |
| 2000-09-18 08:30:00 | AAPL | Stock | 0.9994 | 0.9994 | 0.9994 | 0.9994 | 28000.0 |
| 2000-09-18 09:00:00 | AAPL | Stock | 0.9955 | 1.0 | 0.9849 | 0.9866 | 543200.0 |
| 2000-09-18 09:30:00 | AAPL | Stock | 0.9866 | 1.0134 | 0.9866 | 1.0089 | 44688000.0 |
| 2000-09-18 10:00:00 | AAPL | Stock | 1.0089 | 1.0246 | 1.0056 | 1.0167 | 41328000.0 |
| 2000-09-18 10:30:00 | AAPL | Stock | 1.0167 | 1.0246 | 1.0056 | 1.0112 | 10528000.0 |
| 2000-09-18 11:00:00 | AAPL | Stock | 1.0112 | 1.0201 | 1.0056 | 1.0134 | 16044000.0 |
| 2000-09-18 11:30:00 | AAPL | Stock | 1.0145 | 1.0145 | 1.0022 | 1.0056 | 28134400.0 |
| 2000-09-18 12:00:00 | AAPL | Stock | 1.0056 | 1.0067 | 0.9833 | 0.9855 | 22836800.0 |
| 2000-09-18 12:30:00 | AAPL | Stock | 0.9855 | 1.0033 | 0.9844 | 1.0011 | 30828000.0 |
| 2000-09-18 13:00:00 | AAPL | Stock | 1.0 | 1.0033 | 0.9955 | 0.9955 | 15013600.0 |
| 2000-09-18 13:30:00 | AAPL | Stock | 0.9967 | 1.0156 | 0.9955 | 1.014 | 21996800.0 |
| 2000-09-18 14:00:00 | AAPL | Stock | 1.0134 | 1.0268 | 1.0089 | 1.0179 | 13384000.0 |
| 2000-09-18 14:30:00 | AAPL | Stock | 1.019 | 1.0525 | 1.0179 | 1.0502 | 33314400.0 |
| 2000-09-18 15:00:00 | AAPL | Stock | 1.0469 | 1.0603 | 1.0458 | 1.0525 | 36108800.0 |
| 2000-09-18 15:30:00 | AAPL | Stock | 1.0525 | 1.0848 | 1.0402 | 1.0826 | 70509600.0 |
| 2000-09-18 16:00:00 | AAPL | Stock | 1.0826 | 1.0893 | 1.0223 | 1.0781 | 33398400.0 |
| 2000-09-18 16:30:00 | AAPL | Stock | 1.0759 | 1.0831 | 1.0647 | 1.0759 | 890400.0 |
| 2000-09-18 17:00:00 | AAPL | Stock | 1.0748 | 1.0831 | 1.0748 | 1.0759 | 95200.0 |
| 2000-09-18 17:30:00 | AAPL | Stock | 1.0748 | 1.0759 | 1.0748 | 1.0753 | 56000.0 |
| 2000-09-18 18:00:00 | AAPL | Stock | 1.0753 | 1.0753 | 1.0748 | 1.0748 | 61600.0 |
| 2000-09-18 08:00:00 | MSFT | Stock | 32.0938 | 32.7188 | 32.0625 | 32.5 | 358600.0 |
| 2000-09-18 08:30:00 | MSFT | Stock | 32.4375 | 32.5312 | 32.375 | 32.4375 | 376400.0 |
| 2000-09-18 09:00:00 | MSFT | Stock | 32.4375 | 32.4375 | 32.0625 | 32.125 | 453600.0 |
| 2000-09-18 09:30:00 | MSFT | Stock | 32.125 | 32.3125 | 31.9375 | 32.1875 | 8486200.0 |
| 2000-09-18 10:00:00 | MSFT | Stock | 32.1875 | 32.2188 | 32.0312 | 32.125 | 4846800.0 |
| 2000-09-18 10:30:00 | MSFT | Stock | 32.1562 | 32.2188 | 31.9062 | 31.9062 | 6104600.0 |
| 2000-09-18 11:00:00 | MSFT | Stock | 31.9062 | 31.9688 | 31.75 | 31.8438 | 4145400.0 |
| 2000-09-18 11:30:00 | MSFT | Stock | 31.8125 | 31.8438 | 31.625 | 31.6875 | 4033400.0 |
| 2000-09-18 12:00:00 | MSFT | Stock | 31.6875 | 31.8125 | 31.5 | 31.5625 | 3766000.0 |
| 2000-09-18 12:30:00 | MSFT | Stock | 31.5938 | 31.6562 | 31.2812 | 31.3125 | 4062600.0 |
| 2000-09-18 13:00:00 | MSFT | Stock | 31.3438 | 31.4062 | 31.1875 | 31.2188 | 5912800.0 |
| 2000-09-18 13:30:00 | MSFT | Stock | 31.1875 | 31.5 | 31.0938 | 31.5 | 4085200.0 |
| 2000-09-18 14:00:00 | MSFT | Stock | 31.5 | 31.5938 | 31.2812 | 31.4062 | 3349600.0 |
| 2000-09-18 14:30:00 | MSFT | Stock | 31.4375 | 31.5312 | 31.1875 | 31.5 | 3847800.0 |
| 2000-09-18 15:00:00 | MSFT | Stock | 31.5 | 31.75 | 31.2812 | 31.375 | 4102800.0 |
| 2000-09-18 15:30:00 | MSFT | Stock | 31.3438 | 31.5625 | 31.1875 | 31.5312 | 7437600.0 |
| 2000-09-18 16:00:00 | MSFT | Stock | 31.5312 | 31.8594 | 31.3438 | 31.75 | 1663600.0 |
| 2000-09-18 16:30:00 | MSFT | Stock | 31.75 | 31.75 | 31.5 | 31.75 | 45600.0 |
| 2000-09-18 17:00:00 | MSFT | Stock | 31.75 | 31.75 | 31.5 | 31.6875 | 30000.0 |
| 2000-09-18 17:30:00 | MSFT | Stock | 31.25 | 31.7188 | 31.25 | 31.6875 | 73600.0 |
| 2000-09-18 18:00:00 | MSFT | Stock | 31.5625 | 31.6875 | 31.5625 | 31.625 | 600.0 |
| 2000-09-18 09:00:00 | NVDA | Stock | 0.2958 | 0.2958 | 0.2958 | 0.2958 | 72000.0 |
| 2000-09-18 09:30:00 | NVDA | Stock | 0.2961 | 0.2979 | 0.288 | 0.2958 | 17448000.0 |
| 2000-09-18 10:00:00 | NVDA | Stock | 0.2958 | 0.2969 | 0.2924 | 0.2958 | 7512000.0 |
| 2000-09-18 10:30:00 | NVDA | Stock | 0.2953 | 0.2964 | 0.2914 | 0.2914 | 9000000.0 |
| 2000-09-18 11:00:00 | NVDA | Stock | 0.2914 | 0.2932 | 0.2888 | 0.2893 | 12408000.0 |
| 2000-09-18 11:30:00 | NVDA | Stock | 0.2891 | 0.2914 | 0.2875 | 0.2891 | 11712000.0 |
| 2000-09-18 12:00:00 | NVDA | Stock | 0.2888 | 0.2904 | 0.2854 | 0.2872 | 8712000.0 |
| 2000-09-18 12:30:00 | NVDA | Stock | 0.2859 | 0.2872 | 0.276 | 0.2781 | 18528000.0 |
> showing 50 of 25,819 rows — these rows as CSV