PREVIEW / stock_30min / 2006-05-24
file: by_date/stock_30min/2006/2006-05-24.parquet size: 922 KB rows: 49,265 symbols: 2,272
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 |
|---|---|---|---|---|---|---|---|
| 2006-05-24 06:30:00 | AAPL | Stock | 2.25 | 2.25 | 2.25 | 2.25 | 56000.0 |
| 2006-05-24 07:30:00 | AAPL | Stock | 2.25 | 2.25 | 2.2464 | 2.2464 | 14000.0 |
| 2006-05-24 08:00:00 | AAPL | Stock | 2.2504 | 2.2643 | 2.2504 | 2.2607 | 648760.0 |
| 2006-05-24 08:30:00 | AAPL | Stock | 2.2607 | 2.2657 | 2.2536 | 2.2643 | 1223516.0 |
| 2006-05-24 09:00:00 | AAPL | Stock | 2.2636 | 2.2643 | 2.2389 | 2.2446 | 4915428.0 |
| 2006-05-24 09:30:00 | AAPL | Stock | 2.2496 | 2.2636 | 2.2143 | 2.2611 | 140380072.0 |
| 2006-05-24 10:00:00 | AAPL | Stock | 2.2607 | 2.2711 | 2.2504 | 2.2611 | 73703140.0 |
| 2006-05-24 10:30:00 | AAPL | Stock | 2.2607 | 2.2732 | 2.2546 | 2.2596 | 58457476.0 |
| 2006-05-24 11:00:00 | AAPL | Stock | 2.2593 | 2.2596 | 2.2396 | 2.2493 | 60098192.0 |
| 2006-05-24 11:30:00 | AAPL | Stock | 2.2493 | 2.2546 | 2.2375 | 2.2524 | 37656136.0 |
| 2006-05-24 12:00:00 | AAPL | Stock | 2.2521 | 2.2564 | 2.2336 | 2.2371 | 36729000.0 |
| 2006-05-24 12:30:00 | AAPL | Stock | 2.2368 | 2.2418 | 2.2243 | 2.2289 | 42569716.0 |
| 2006-05-24 13:00:00 | AAPL | Stock | 2.2289 | 2.2311 | 2.2039 | 2.2043 | 57144836.0 |
| 2006-05-24 13:30:00 | AAPL | Stock | 2.2043 | 2.2329 | 2.1986 | 2.2269 | 73936212.0 |
| 2006-05-24 14:00:00 | AAPL | Stock | 2.2268 | 2.2464 | 2.2143 | 2.2168 | 74740792.0 |
| 2006-05-24 14:30:00 | AAPL | Stock | 2.2164 | 2.2461 | 2.2143 | 2.2432 | 71721608.0 |
| 2006-05-24 15:00:00 | AAPL | Stock | 2.2432 | 2.2525 | 2.2246 | 2.2329 | 70356048.0 |
| 2006-05-24 15:30:00 | AAPL | Stock | 2.2329 | 2.2679 | 2.2325 | 2.2605 | 82196128.0 |
| 2006-05-24 16:00:00 | AAPL | Stock | 2.2593 | 2.2704 | 2.2582 | 2.2679 | 4080384.0 |
| 2006-05-24 16:30:00 | AAPL | Stock | 2.2679 | 2.2679 | 2.2643 | 2.2661 | 422268.0 |
| 2006-05-24 17:00:00 | AAPL | Stock | 2.2664 | 2.2689 | 2.2664 | 2.2675 | 123200.0 |
| 2006-05-24 17:30:00 | AAPL | Stock | 2.2675 | 2.2682 | 2.2675 | 2.2679 | 29820.0 |
| 2006-05-24 18:00:00 | AAPL | Stock | 2.2679 | 2.2704 | 2.2661 | 2.2689 | 219212.0 |
| 2006-05-24 07:00:00 | MSFT | Stock | 22.67 | 22.67 | 22.64 | 22.64 | 1400.0 |
| 2006-05-24 07:30:00 | MSFT | Stock | 22.67 | 22.67 | 22.67 | 22.67 | 2000.0 |
| 2006-05-24 08:00:00 | MSFT | Stock | 22.83 | 22.99 | 22.79 | 22.88 | 82980.0 |
| 2006-05-24 08:30:00 | MSFT | Stock | 22.88 | 22.95 | 22.87 | 22.89 | 175700.0 |
| 2006-05-24 09:00:00 | MSFT | Stock | 22.94 | 23.0 | 22.9 | 23.0 | 326259.0 |
| 2006-05-24 09:30:00 | MSFT | Stock | 22.99 | 23.38 | 22.98 | 23.33 | 16618594.0 |
| 2006-05-24 10:00:00 | MSFT | Stock | 23.33 | 23.48 | 23.31 | 23.38 | 15395318.0 |
| 2006-05-24 10:30:00 | MSFT | Stock | 23.37 | 23.41 | 23.31 | 23.35 | 5815150.0 |
| 2006-05-24 11:00:00 | MSFT | Stock | 23.35 | 23.41 | 23.25 | 23.32 | 7478055.0 |
| 2006-05-24 11:30:00 | MSFT | Stock | 23.33 | 23.33 | 23.19 | 23.29 | 4870913.0 |
| 2006-05-24 12:00:00 | MSFT | Stock | 23.29 | 23.405 | 23.27 | 23.329 | 3618540.0 |
| 2006-05-24 12:30:00 | MSFT | Stock | 23.32 | 23.38 | 23.26 | 23.31 | 5432874.0 |
| 2006-05-24 13:00:00 | MSFT | Stock | 23.31 | 23.34 | 23.25 | 23.28 | 3653683.0 |
| 2006-05-24 13:30:00 | MSFT | Stock | 23.28 | 23.4 | 23.23 | 23.37 | 5733460.0 |
| 2006-05-24 14:00:00 | MSFT | Stock | 23.38 | 23.41 | 23.3 | 23.33 | 5566839.0 |
| 2006-05-24 14:30:00 | MSFT | Stock | 23.33 | 23.51 | 23.31 | 23.43 | 8452799.0 |
| 2006-05-24 15:00:00 | MSFT | Stock | 23.43 | 23.49 | 23.33 | 23.35 | 8087120.0 |
| 2006-05-24 15:30:00 | MSFT | Stock | 23.36 | 23.54 | 23.35 | 23.5 | 12612661.0 |
| 2006-05-24 16:00:00 | MSFT | Stock | 23.49 | 23.52 | 23.404 | 23.5 | 626054.0 |
| 2006-05-24 16:30:00 | MSFT | Stock | 23.5 | 23.53 | 23.34 | 23.49 | 63791.0 |
| 2006-05-24 17:00:00 | MSFT | Stock | 23.5 | 23.51 | 23.49 | 23.5 | 8747.0 |
| 2006-05-24 17:30:00 | MSFT | Stock | 23.5 | 23.53 | 23.5 | 23.51 | 11732.0 |
| 2006-05-24 18:00:00 | MSFT | Stock | 23.52 | 23.55 | 23.51 | 23.55 | 19880.0 |
| 2006-05-24 06:30:00 | NVDA | Stock | 0.3955 | 0.3955 | 0.3955 | 0.3955 | 6000.0 |
| 2006-05-24 08:30:00 | NVDA | Stock | 0.3968 | 0.3992 | 0.3958 | 0.3962 | 184500.0 |
| 2006-05-24 09:00:00 | NVDA | Stock | 0.397 | 0.399 | 0.3967 | 0.3988 | 567900.0 |
| 2006-05-24 09:30:00 | NVDA | Stock | 0.3992 | 0.41 | 0.3988 | 0.4087 | 91979880.0 |
> showing 50 of 49,265 rows — these rows as CSV