PREVIEW / stock_30min / 2006-09-08
file: by_date/stock_30min/2006/2006-09-08.parquet size: 896 KB rows: 48,879 symbols: 2,336
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-09-08 04:00:00 | AAPL | Stock | 2.6018 | 2.6018 | 2.6018 | 2.6018 | 2800.0 |
| 2006-09-08 04:30:00 | AAPL | Stock | 2.6071 | 2.6071 | 2.6071 | 2.6071 | 2800.0 |
| 2006-09-08 06:00:00 | AAPL | Stock | 2.6125 | 2.6143 | 2.6089 | 2.6089 | 22680.0 |
| 2006-09-08 06:30:00 | AAPL | Stock | 2.6143 | 2.6175 | 2.6143 | 2.6175 | 154000.0 |
| 2006-09-08 07:00:00 | AAPL | Stock | 2.6246 | 2.625 | 2.6179 | 2.6179 | 195860.0 |
| 2006-09-08 07:30:00 | AAPL | Stock | 2.62 | 2.625 | 2.6168 | 2.6168 | 120400.0 |
| 2006-09-08 08:00:00 | AAPL | Stock | 2.6211 | 2.6318 | 2.6161 | 2.6243 | 3835860.0 |
| 2006-09-08 08:30:00 | AAPL | Stock | 2.6232 | 2.63 | 2.6182 | 2.6232 | 2650508.0 |
| 2006-09-08 09:00:00 | AAPL | Stock | 2.625 | 2.6293 | 2.6161 | 2.6186 | 5673556.0 |
| 2006-09-08 09:30:00 | AAPL | Stock | 2.6204 | 2.6275 | 2.5911 | 2.5986 | 200074980.0 |
| 2006-09-08 10:00:00 | AAPL | Stock | 2.5986 | 2.6036 | 2.5764 | 2.5957 | 134825796.0 |
| 2006-09-08 10:30:00 | AAPL | Stock | 2.5954 | 2.6014 | 2.5821 | 2.6007 | 64674568.0 |
| 2006-09-08 11:00:00 | AAPL | Stock | 2.6007 | 2.6014 | 2.5829 | 2.5871 | 61282508.0 |
| 2006-09-08 11:30:00 | AAPL | Stock | 2.5879 | 2.5879 | 2.5732 | 2.5764 | 66279948.0 |
| 2006-09-08 12:00:00 | AAPL | Stock | 2.5768 | 2.595 | 2.5682 | 2.5718 | 50127644.0 |
| 2006-09-08 12:30:00 | AAPL | Stock | 2.5721 | 2.5925 | 2.5718 | 2.5889 | 39492684.0 |
| 2006-09-08 13:00:00 | AAPL | Stock | 2.5889 | 2.59 | 2.5789 | 2.585 | 33525968.0 |
| 2006-09-08 13:30:00 | AAPL | Stock | 2.585 | 2.5961 | 2.5811 | 2.5946 | 34598004.0 |
| 2006-09-08 14:00:00 | AAPL | Stock | 2.5946 | 2.5982 | 2.5889 | 2.5918 | 41199088.0 |
| 2006-09-08 14:30:00 | AAPL | Stock | 2.5914 | 2.5996 | 2.5889 | 2.5975 | 29976856.0 |
| 2006-09-08 15:00:00 | AAPL | Stock | 2.5971 | 2.5979 | 2.5854 | 2.595 | 48346844.0 |
| 2006-09-08 15:30:00 | AAPL | Stock | 2.5946 | 2.5964 | 2.5857 | 2.5904 | 68338032.0 |
| 2006-09-08 16:00:00 | AAPL | Stock | 2.5914 | 2.5936 | 2.5889 | 2.5893 | 1806980.0 |
| 2006-09-08 16:30:00 | AAPL | Stock | 2.5911 | 2.5914 | 2.5904 | 2.5904 | 340200.0 |
| 2006-09-08 17:00:00 | AAPL | Stock | 2.5911 | 2.5936 | 2.5911 | 2.5921 | 227556.0 |
| 2006-09-08 17:30:00 | AAPL | Stock | 2.5921 | 2.5921 | 2.59 | 2.59 | 174496.0 |
| 2006-09-08 18:00:00 | AAPL | Stock | 2.5921 | 2.5925 | 2.59 | 2.5911 | 99540.0 |
| 2006-09-08 08:00:00 | MSFT | Stock | 25.5 | 25.5 | 25.45 | 25.45 | 13870.0 |
| 2006-09-08 08:30:00 | MSFT | Stock | 25.49 | 25.49 | 25.49 | 25.49 | 5100.0 |
| 2006-09-08 09:00:00 | MSFT | Stock | 25.49 | 25.55 | 25.47 | 25.54 | 68732.0 |
| 2006-09-08 09:30:00 | MSFT | Stock | 25.53 | 25.55 | 25.46 | 25.5 | 3814367.0 |
| 2006-09-08 10:00:00 | MSFT | Stock | 25.5 | 25.55 | 25.47 | 25.54 | 2382011.0 |
| 2006-09-08 10:30:00 | MSFT | Stock | 25.54 | 25.65 | 25.5 | 25.65 | 3435239.0 |
| 2006-09-08 11:00:00 | MSFT | Stock | 25.65 | 25.68 | 25.61 | 25.627 | 2934871.0 |
| 2006-09-08 11:30:00 | MSFT | Stock | 25.62 | 25.62 | 25.54 | 25.58 | 2369719.0 |
| 2006-09-08 12:00:00 | MSFT | Stock | 25.57 | 25.65 | 25.57 | 25.62 | 2252834.0 |
| 2006-09-08 12:30:00 | MSFT | Stock | 25.62 | 25.65 | 25.61 | 25.63 | 866883.0 |
| 2006-09-08 13:00:00 | MSFT | Stock | 25.63 | 25.78 | 25.62 | 25.76 | 2780921.0 |
| 2006-09-08 13:30:00 | MSFT | Stock | 25.75 | 25.79 | 25.68 | 25.72 | 2712709.0 |
| 2006-09-08 14:00:00 | MSFT | Stock | 25.72 | 25.74 | 25.63 | 25.64 | 2014267.0 |
| 2006-09-08 14:30:00 | MSFT | Stock | 25.64 | 25.68 | 25.59 | 25.648 | 1828422.0 |
| 2006-09-08 15:00:00 | MSFT | Stock | 25.64 | 25.66 | 25.58 | 25.64 | 2678053.0 |
| 2006-09-08 15:30:00 | MSFT | Stock | 25.65 | 25.66 | 25.59 | 25.62 | 4451707.0 |
| 2006-09-08 16:00:00 | MSFT | Stock | 25.6 | 25.64 | 25.25 | 25.58 | 106288.0 |
| 2006-09-08 16:30:00 | MSFT | Stock | 25.6 | 25.6 | 25.58 | 25.58 | 869.0 |
| 2006-09-08 17:00:00 | MSFT | Stock | 25.59 | 25.63 | 25.59 | 25.59 | 1170.0 |
| 2006-09-08 17:30:00 | MSFT | Stock | 25.58 | 25.59 | 25.58 | 25.58 | 2550.0 |
| 2006-09-08 08:00:00 | NVDA | Stock | 0.4607 | 0.4663 | 0.4607 | 0.4632 | 574800.0 |
| 2006-09-08 08:30:00 | NVDA | Stock | 0.4633 | 0.4683 | 0.4632 | 0.4683 | 360000.0 |
| 2006-09-08 09:00:00 | NVDA | Stock | 0.4667 | 0.47 | 0.4667 | 0.4677 | 877140.0 |
> showing 50 of 48,879 rows — these rows as CSV