PREVIEW / stock_30min / 2001-09-27
file: by_date/stock_30min/2001/2001-09-27.parquet size: 535 KB rows: 28,447 symbols: 1,338
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-09-27 08:30:00 | AAPL | Stock | 0.2695 | 0.2713 | 0.2695 | 0.2705 | 408800.0 |
| 2001-09-27 09:00:00 | AAPL | Stock | 0.2732 | 0.275 | 0.2703 | 0.272 | 1215200.0 |
| 2001-09-27 09:30:00 | AAPL | Stock | 0.2723 | 0.278 | 0.2714 | 0.2771 | 39704000.0 |
| 2001-09-27 10:00:00 | AAPL | Stock | 0.2771 | 0.2804 | 0.2759 | 0.2768 | 22523200.0 |
| 2001-09-27 10:30:00 | AAPL | Stock | 0.2768 | 0.2788 | 0.2761 | 0.2784 | 26415200.0 |
| 2001-09-27 11:00:00 | AAPL | Stock | 0.2784 | 0.2784 | 0.2768 | 0.2773 | 10903200.0 |
| 2001-09-27 11:30:00 | AAPL | Stock | 0.2775 | 0.2803 | 0.2773 | 0.2782 | 23430400.0 |
| 2001-09-27 12:00:00 | AAPL | Stock | 0.2782 | 0.2804 | 0.278 | 0.2796 | 15332800.0 |
| 2001-09-27 12:30:00 | AAPL | Stock | 0.2796 | 0.2796 | 0.2768 | 0.2771 | 20955200.0 |
| 2001-09-27 13:00:00 | AAPL | Stock | 0.277 | 0.2775 | 0.2764 | 0.277 | 13608000.0 |
| 2001-09-27 13:30:00 | AAPL | Stock | 0.2771 | 0.2784 | 0.2768 | 0.277 | 12460000.0 |
| 2001-09-27 14:00:00 | AAPL | Stock | 0.277 | 0.2813 | 0.277 | 0.2775 | 16055200.0 |
| 2001-09-27 14:30:00 | AAPL | Stock | 0.2773 | 0.2784 | 0.2768 | 0.2777 | 18379200.0 |
| 2001-09-27 15:00:00 | AAPL | Stock | 0.2775 | 0.2809 | 0.2759 | 0.2771 | 35795200.0 |
| 2001-09-27 15:30:00 | AAPL | Stock | 0.277 | 0.28 | 0.2759 | 0.2768 | 25463200.0 |
| 2001-09-27 16:00:00 | AAPL | Stock | 0.2768 | 0.2812 | 0.2768 | 0.2784 | 9637600.0 |
| 2001-09-27 16:30:00 | AAPL | Stock | 0.2761 | 0.277 | 0.2759 | 0.277 | 3012800.0 |
| 2001-09-27 17:00:00 | AAPL | Stock | 0.277 | 0.277 | 0.277 | 0.277 | 912800.0 |
| 2001-09-27 18:00:00 | AAPL | Stock | 0.2761 | 0.2761 | 0.2761 | 0.2761 | 11200.0 |
| 2001-09-27 08:00:00 | MSFT | Stock | 25.175 | 25.175 | 25.175 | 25.175 | 800.0 |
| 2001-09-27 08:30:00 | MSFT | Stock | 25.185 | 25.185 | 24.95 | 24.95 | 87600.0 |
| 2001-09-27 09:00:00 | MSFT | Stock | 24.96 | 25.1 | 24.96 | 25.05 | 118400.0 |
| 2001-09-27 09:30:00 | MSFT | Stock | 25.05 | 25.34 | 24.695 | 24.885 | 7260400.0 |
| 2001-09-27 10:00:00 | MSFT | Stock | 24.89 | 25.035 | 24.5355 | 24.56 | 6854000.0 |
| 2001-09-27 10:30:00 | MSFT | Stock | 24.56 | 24.595 | 24.375 | 24.5045 | 6669400.0 |
| 2001-09-27 11:00:00 | MSFT | Stock | 24.505 | 24.53 | 24.26 | 24.27 | 4711000.0 |
| 2001-09-27 11:30:00 | MSFT | Stock | 24.27 | 24.45 | 24.23 | 24.3 | 3604400.0 |
| 2001-09-27 12:00:00 | MSFT | Stock | 24.305 | 24.33 | 24.0845 | 24.135 | 2692400.0 |
| 2001-09-27 12:30:00 | MSFT | Stock | 24.13 | 24.285 | 24.0 | 24.155 | 12214600.0 |
| 2001-09-27 13:00:00 | MSFT | Stock | 24.16 | 24.24 | 24.06 | 24.1645 | 2715000.0 |
| 2001-09-27 13:30:00 | MSFT | Stock | 24.165 | 24.25 | 24.1 | 24.22 | 1587400.0 |
| 2001-09-27 14:00:00 | MSFT | Stock | 24.22 | 24.405 | 24.11 | 24.38 | 4108800.0 |
| 2001-09-27 14:30:00 | MSFT | Stock | 24.375 | 24.74 | 24.325 | 24.665 | 5927200.0 |
| 2001-09-27 15:00:00 | MSFT | Stock | 24.685 | 24.93 | 24.595 | 24.62 | 6545000.0 |
| 2001-09-27 15:30:00 | MSFT | Stock | 24.625 | 25.125 | 24.6 | 24.985 | 7940400.0 |
| 2001-09-27 16:00:00 | MSFT | Stock | 24.98 | 24.995 | 24.5092 | 24.965 | 1558600.0 |
| 2001-09-27 16:30:00 | MSFT | Stock | 24.98 | 24.995 | 24.5112 | 24.995 | 498800.0 |
| 2001-09-27 17:00:00 | MSFT | Stock | 24.98 | 24.98 | 24.445 | 24.95 | 490400.0 |
| 2001-09-27 17:30:00 | MSFT | Stock | 24.975 | 24.975 | 24.975 | 24.975 | 3000.0 |
| 2001-09-27 18:00:00 | MSFT | Stock | 25.0 | 25.05 | 25.0 | 25.05 | 3200.0 |
| 2001-09-27 08:00:00 | NVDA | Stock | 0.2304 | 0.2313 | 0.2304 | 0.2313 | 144000.0 |
| 2001-09-27 08:30:00 | NVDA | Stock | 0.2271 | 0.2279 | 0.2271 | 0.2279 | 60000.0 |
| 2001-09-27 09:00:00 | NVDA | Stock | 0.2303 | 0.2303 | 0.2279 | 0.2302 | 180000.0 |
| 2001-09-27 09:30:00 | NVDA | Stock | 0.2307 | 0.2333 | 0.2276 | 0.228 | 42912000.0 |
| 2001-09-27 10:00:00 | NVDA | Stock | 0.2279 | 0.2282 | 0.2126 | 0.2159 | 84672000.0 |
| 2001-09-27 10:30:00 | NVDA | Stock | 0.2166 | 0.2179 | 0.213 | 0.2178 | 61128000.0 |
| 2001-09-27 11:00:00 | NVDA | Stock | 0.2179 | 0.2192 | 0.2152 | 0.2187 | 73932000.0 |
| 2001-09-27 11:30:00 | NVDA | Stock | 0.2192 | 0.22 | 0.2168 | 0.2172 | 41688000.0 |
| 2001-09-27 12:00:00 | NVDA | Stock | 0.2174 | 0.2195 | 0.2174 | 0.2182 | 23796000.0 |
| 2001-09-27 12:30:00 | NVDA | Stock | 0.218 | 0.219 | 0.2157 | 0.2167 | 27384000.0 |
> showing 50 of 28,447 rows — these rows as CSV