PREVIEW / stock_30min / 2006-11-13
file: by_date/stock_30min/2006/2006-11-13.parquet size: 945 KB rows: 51,806 symbols: 2,448
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-11-13 08:00:00 | AAPL | Stock | 2.9704 | 2.9764 | 2.9689 | 2.9689 | 455868.0 |
| 2006-11-13 08:30:00 | AAPL | Stock | 2.9689 | 2.9732 | 2.9686 | 2.9696 | 167104.0 |
| 2006-11-13 09:00:00 | AAPL | Stock | 2.9696 | 2.9721 | 2.9646 | 2.9721 | 360304.0 |
| 2006-11-13 09:30:00 | AAPL | Stock | 2.9732 | 2.9911 | 2.9514 | 2.9893 | 57643180.0 |
| 2006-11-13 10:00:00 | AAPL | Stock | 2.9886 | 3.0107 | 2.9864 | 2.9989 | 55441932.0 |
| 2006-11-13 10:30:00 | AAPL | Stock | 2.9989 | 3.0032 | 2.995 | 2.9964 | 25825800.0 |
| 2006-11-13 11:00:00 | AAPL | Stock | 2.9964 | 3.0054 | 2.9964 | 3.0043 | 23521792.0 |
| 2006-11-13 11:30:00 | AAPL | Stock | 3.0043 | 3.0161 | 3.0036 | 3.007 | 43799196.0 |
| 2006-11-13 12:00:00 | AAPL | Stock | 3.0071 | 3.015 | 2.9975 | 3.0121 | 28751436.0 |
| 2006-11-13 12:30:00 | AAPL | Stock | 3.0121 | 3.0125 | 2.9954 | 2.9979 | 25020156.0 |
| 2006-11-13 13:00:00 | AAPL | Stock | 2.9982 | 2.9996 | 2.9861 | 2.9929 | 24906840.0 |
| 2006-11-13 13:30:00 | AAPL | Stock | 2.9929 | 2.9954 | 2.9736 | 2.9887 | 40496316.0 |
| 2006-11-13 14:00:00 | AAPL | Stock | 2.9886 | 2.9936 | 2.9854 | 2.9925 | 18080664.0 |
| 2006-11-13 14:30:00 | AAPL | Stock | 2.9925 | 3.0107 | 2.9925 | 3.0089 | 32155872.0 |
| 2006-11-13 15:00:00 | AAPL | Stock | 3.0089 | 3.0107 | 3.0018 | 3.0036 | 27695612.0 |
| 2006-11-13 15:30:00 | AAPL | Stock | 3.0036 | 3.0125 | 3.0004 | 3.0121 | 39015228.0 |
| 2006-11-13 16:00:00 | AAPL | Stock | 3.0121 | 3.015 | 3.0054 | 3.015 | 1178436.0 |
| 2006-11-13 16:30:00 | AAPL | Stock | 3.0161 | 3.0164 | 3.0089 | 3.0114 | 343952.0 |
| 2006-11-13 17:00:00 | AAPL | Stock | 3.0121 | 3.0125 | 3.0111 | 3.0111 | 69160.0 |
| 2006-11-13 17:30:00 | AAPL | Stock | 3.0111 | 3.0129 | 3.0107 | 3.0107 | 73332.0 |
| 2006-11-13 18:00:00 | AAPL | Stock | 3.0107 | 3.0107 | 3.0082 | 3.0107 | 137760.0 |
| 2006-11-13 18:30:00 | AAPL | Stock | 3.0107 | 3.0107 | 3.0107 | 3.0107 | 4200.0 |
| 2006-11-13 19:00:00 | AAPL | Stock | 3.0107 | 3.0107 | 3.0096 | 3.0107 | 53900.0 |
| 2006-11-13 19:30:00 | AAPL | Stock | 3.0082 | 3.0107 | 3.0082 | 3.0107 | 33824.0 |
| 2006-11-13 07:00:00 | MSFT | Stock | 29.24 | 29.24 | 29.24 | 29.24 | 5000.0 |
| 2006-11-13 07:30:00 | MSFT | Stock | 29.24 | 29.24 | 29.24 | 29.24 | 100.0 |
| 2006-11-13 08:00:00 | MSFT | Stock | 29.23 | 29.27 | 29.23 | 29.27 | 1326186.0 |
| 2006-11-13 08:30:00 | MSFT | Stock | 29.27 | 29.27 | 29.25 | 29.25 | 11239.0 |
| 2006-11-13 09:00:00 | MSFT | Stock | 29.29 | 29.3 | 29.17 | 29.17 | 49955.0 |
| 2006-11-13 09:30:00 | MSFT | Stock | 29.19 | 29.42 | 29.16 | 29.39 | 6063678.0 |
| 2006-11-13 10:00:00 | MSFT | Stock | 29.4 | 29.45 | 29.37 | 29.4 | 4397815.0 |
| 2006-11-13 10:30:00 | MSFT | Stock | 29.41 | 29.41 | 29.31 | 29.323 | 3085213.0 |
| 2006-11-13 11:00:00 | MSFT | Stock | 29.33 | 29.4 | 29.32 | 29.38 | 1731569.0 |
| 2006-11-13 11:30:00 | MSFT | Stock | 29.38 | 29.4 | 29.34 | 29.36 | 2606033.0 |
| 2006-11-13 12:00:00 | MSFT | Stock | 29.36 | 29.4 | 29.35 | 29.39 | 1442218.0 |
| 2006-11-13 12:30:00 | MSFT | Stock | 29.4 | 29.42 | 29.34 | 29.34 | 2221763.0 |
| 2006-11-13 13:00:00 | MSFT | Stock | 29.34 | 29.42 | 29.34 | 29.36 | 2172078.0 |
| 2006-11-13 13:30:00 | MSFT | Stock | 29.35 | 29.42 | 29.34 | 29.398 | 2074184.0 |
| 2006-11-13 14:00:00 | MSFT | Stock | 29.39 | 29.42 | 29.36 | 29.41 | 1499431.0 |
| 2006-11-13 14:30:00 | MSFT | Stock | 29.42 | 29.46 | 29.38 | 29.409 | 2419545.0 |
| 2006-11-13 15:00:00 | MSFT | Stock | 29.41 | 29.42 | 29.38 | 29.39 | 3860228.0 |
| 2006-11-13 15:30:00 | MSFT | Stock | 29.39 | 29.39 | 29.32 | 29.36 | 4773314.0 |
| 2006-11-13 16:00:00 | MSFT | Stock | 29.36 | 29.39 | 29.32 | 29.35 | 183116.0 |
| 2006-11-13 16:30:00 | MSFT | Stock | 29.38 | 29.38 | 29.35 | 29.35 | 1672600.0 |
| 2006-11-13 17:00:00 | MSFT | Stock | 29.36 | 29.38 | 29.35 | 29.38 | 6200.0 |
| 2006-11-13 17:30:00 | MSFT | Stock | 29.36 | 29.36 | 29.36 | 29.36 | 2046.0 |
| 2006-11-13 18:00:00 | MSFT | Stock | 29.38 | 29.38 | 29.36 | 29.36 | 1200.0 |
| 2006-11-13 19:00:00 | MSFT | Stock | 29.36 | 29.36 | 29.35 | 29.35 | 600.0 |
| 2006-11-13 19:30:00 | MSFT | Stock | 29.36 | 29.36 | 29.36 | 29.36 | 1500.0 |
| 2006-11-13 08:00:00 | NVDA | Stock | 0.5675 | 0.5752 | 0.5667 | 0.5745 | 212100.0 |
> showing 50 of 51,806 rows — these rows as CSV