PREVIEW / stock_30min / 2001-03-14
file: by_date/stock_30min/2001/2001-03-14.parquet size: 534 KB rows: 27,438 symbols: 1,274
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-03-14 08:00:00 | AAPL | Stock | 0.3393 | 0.3488 | 0.3214 | 0.3281 | 1601600.0 |
| 2001-03-14 08:30:00 | AAPL | Stock | 0.3292 | 0.3304 | 0.3281 | 0.3281 | 896000.0 |
| 2001-03-14 09:00:00 | AAPL | Stock | 0.3292 | 0.3371 | 0.3292 | 0.3315 | 1416800.0 |
| 2001-03-14 09:30:00 | AAPL | Stock | 0.3304 | 0.3438 | 0.3292 | 0.3404 | 51542400.0 |
| 2001-03-14 10:00:00 | AAPL | Stock | 0.3404 | 0.3571 | 0.3404 | 0.3571 | 42728000.0 |
| 2001-03-14 10:30:00 | AAPL | Stock | 0.3571 | 0.3661 | 0.3538 | 0.3605 | 61840800.0 |
| 2001-03-14 11:00:00 | AAPL | Stock | 0.3605 | 0.3605 | 0.3504 | 0.3527 | 19297600.0 |
| 2001-03-14 11:30:00 | AAPL | Stock | 0.3527 | 0.3571 | 0.3516 | 0.3516 | 14280000.0 |
| 2001-03-14 12:00:00 | AAPL | Stock | 0.3516 | 0.3527 | 0.3438 | 0.346 | 27714400.0 |
| 2001-03-14 12:30:00 | AAPL | Stock | 0.346 | 0.3516 | 0.3438 | 0.3482 | 13692000.0 |
| 2001-03-14 13:00:00 | AAPL | Stock | 0.3482 | 0.3504 | 0.3438 | 0.346 | 32569600.0 |
| 2001-03-14 13:30:00 | AAPL | Stock | 0.3471 | 0.3549 | 0.346 | 0.3516 | 27955200.0 |
| 2001-03-14 14:00:00 | AAPL | Stock | 0.3516 | 0.365 | 0.3516 | 0.3638 | 34664000.0 |
| 2001-03-14 14:30:00 | AAPL | Stock | 0.3638 | 0.365 | 0.3555 | 0.3571 | 35515200.0 |
| 2001-03-14 15:00:00 | AAPL | Stock | 0.3583 | 0.3627 | 0.3549 | 0.3605 | 40616800.0 |
| 2001-03-14 15:30:00 | AAPL | Stock | 0.3616 | 0.3661 | 0.3583 | 0.3627 | 37794400.0 |
| 2001-03-14 16:00:00 | AAPL | Stock | 0.3638 | 0.365 | 0.3605 | 0.3638 | 12734400.0 |
| 2001-03-14 16:30:00 | AAPL | Stock | 0.3605 | 0.3605 | 0.3605 | 0.3605 | 28000.0 |
| 2001-03-14 17:00:00 | AAPL | Stock | 0.3627 | 0.3638 | 0.3605 | 0.3616 | 44800.0 |
| 2001-03-14 17:30:00 | AAPL | Stock | 0.3616 | 0.3616 | 0.3616 | 0.3616 | 39200.0 |
| 2001-03-14 18:00:00 | AAPL | Stock | 0.3605 | 0.3605 | 0.3605 | 0.3605 | 11200.0 |
| 2001-03-14 08:00:00 | MSFT | Stock | 26.0938 | 26.5312 | 25.75 | 25.9375 | 390400.0 |
| 2001-03-14 08:30:00 | MSFT | Stock | 25.9375 | 26.25 | 25.7812 | 26.0938 | 175000.0 |
| 2001-03-14 09:00:00 | MSFT | Stock | 26.25 | 27.25 | 26.125 | 26.2812 | 499200.0 |
| 2001-03-14 09:30:00 | MSFT | Stock | 26.25 | 27.0 | 26.0938 | 26.7188 | 12587000.0 |
| 2001-03-14 10:00:00 | MSFT | Stock | 26.6875 | 27.5 | 26.6562 | 27.1562 | 11605800.0 |
| 2001-03-14 10:30:00 | MSFT | Stock | 27.1562 | 27.625 | 26.9688 | 27.4688 | 9126000.0 |
| 2001-03-14 11:00:00 | MSFT | Stock | 27.5 | 27.5 | 27.0312 | 27.125 | 4463400.0 |
| 2001-03-14 11:30:00 | MSFT | Stock | 27.125 | 27.375 | 26.8438 | 26.8438 | 3654800.0 |
| 2001-03-14 12:00:00 | MSFT | Stock | 26.8438 | 26.9062 | 26.4688 | 26.5 | 5226800.0 |
| 2001-03-14 12:30:00 | MSFT | Stock | 26.4688 | 26.9375 | 26.375 | 26.875 | 4293000.0 |
| 2001-03-14 13:00:00 | MSFT | Stock | 26.875 | 26.875 | 26.375 | 26.6562 | 3921200.0 |
| 2001-03-14 13:30:00 | MSFT | Stock | 26.5938 | 27.0312 | 26.4375 | 27.0 | 5007400.0 |
| 2001-03-14 14:00:00 | MSFT | Stock | 27.0 | 27.2188 | 26.8125 | 26.9062 | 3506000.0 |
| 2001-03-14 14:30:00 | MSFT | Stock | 26.9375 | 26.9688 | 26.5625 | 26.7188 | 3096400.0 |
| 2001-03-14 15:00:00 | MSFT | Stock | 26.6875 | 27.0 | 26.5625 | 26.8438 | 4977800.0 |
| 2001-03-14 15:30:00 | MSFT | Stock | 26.8438 | 27.375 | 26.8438 | 27.1562 | 11527400.0 |
| 2001-03-14 16:00:00 | MSFT | Stock | 26.9688 | 27.25 | 26.5938 | 26.9375 | 1457800.0 |
| 2001-03-14 16:30:00 | MSFT | Stock | 26.9844 | 27.125 | 26.9375 | 27.0625 | 736400.0 |
| 2001-03-14 17:00:00 | MSFT | Stock | 27.125 | 27.125 | 27.1094 | 27.125 | 1400.0 |
| 2001-03-14 17:30:00 | MSFT | Stock | 27.125 | 27.125 | 27.0 | 27.125 | 3600.0 |
| 2001-03-14 18:00:00 | MSFT | Stock | 27.1719 | 27.1719 | 27.0625 | 27.0625 | 600.0 |
| 2001-03-14 08:00:00 | NVDA | Stock | 0.2208 | 0.2208 | 0.2083 | 0.2125 | 960000.0 |
| 2001-03-14 08:30:00 | NVDA | Stock | 0.2125 | 0.2143 | 0.2104 | 0.2143 | 3168000.0 |
| 2001-03-14 09:00:00 | NVDA | Stock | 0.2135 | 0.2167 | 0.212 | 0.2148 | 4776000.0 |
| 2001-03-14 09:30:00 | NVDA | Stock | 0.2148 | 0.2292 | 0.2148 | 0.2271 | 211872000.0 |
| 2001-03-14 10:00:00 | NVDA | Stock | 0.2263 | 0.2297 | 0.2232 | 0.2271 | 121152000.0 |
| 2001-03-14 10:30:00 | NVDA | Stock | 0.2263 | 0.2344 | 0.225 | 0.2307 | 101328000.0 |
| 2001-03-14 11:00:00 | NVDA | Stock | 0.2307 | 0.2326 | 0.2271 | 0.2302 | 71688000.0 |
| 2001-03-14 11:30:00 | NVDA | Stock | 0.2299 | 0.2323 | 0.226 | 0.2268 | 58968000.0 |
> showing 50 of 27,438 rows — these rows as CSV