PREVIEW / stock_30min / 2006-08-09
file: by_date/stock_30min/2006/2006-08-09.parquet size: 928 KB rows: 50,320 symbols: 2,316
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-08-09 07:30:00 | AAPL | Stock | 2.3214 | 2.3214 | 2.3214 | 2.3214 | 16800.0 |
| 2006-08-09 08:00:00 | AAPL | Stock | 2.3232 | 2.3429 | 2.3214 | 2.335 | 970312.0 |
| 2006-08-09 08:30:00 | AAPL | Stock | 2.335 | 2.3357 | 2.3304 | 2.3339 | 959504.0 |
| 2006-08-09 09:00:00 | AAPL | Stock | 2.3339 | 2.3432 | 2.3321 | 2.3389 | 2407244.0 |
| 2006-08-09 09:30:00 | AAPL | Stock | 2.3368 | 2.3429 | 2.2861 | 2.3079 | 153817860.0 |
| 2006-08-09 10:00:00 | AAPL | Stock | 2.3079 | 2.3104 | 2.2943 | 2.2957 | 79046436.0 |
| 2006-08-09 10:30:00 | AAPL | Stock | 2.2961 | 2.2996 | 2.2764 | 2.2918 | 119697396.0 |
| 2006-08-09 11:00:00 | AAPL | Stock | 2.2914 | 2.3104 | 2.2904 | 2.3039 | 79569532.0 |
| 2006-08-09 11:30:00 | AAPL | Stock | 2.3039 | 2.3361 | 2.3025 | 2.3307 | 99407728.0 |
| 2006-08-09 12:00:00 | AAPL | Stock | 2.3304 | 2.3306 | 2.3086 | 2.3179 | 53452868.0 |
| 2006-08-09 12:30:00 | AAPL | Stock | 2.3179 | 2.3207 | 2.3096 | 2.3143 | 25084388.0 |
| 2006-08-09 13:00:00 | AAPL | Stock | 2.314 | 2.3271 | 2.3029 | 2.3054 | 45806712.0 |
| 2006-08-09 13:30:00 | AAPL | Stock | 2.3029 | 2.3093 | 2.3 | 2.3018 | 34947472.0 |
| 2006-08-09 14:00:00 | AAPL | Stock | 2.3011 | 2.3057 | 2.2925 | 2.3004 | 38970792.0 |
| 2006-08-09 14:30:00 | AAPL | Stock | 2.3 | 2.3082 | 2.2818 | 2.2879 | 50615376.0 |
| 2006-08-09 15:00:00 | AAPL | Stock | 2.2875 | 2.2893 | 2.2682 | 2.2696 | 65093728.0 |
| 2006-08-09 15:30:00 | AAPL | Stock | 2.2696 | 2.2782 | 2.2643 | 2.2707 | 93729524.0 |
| 2006-08-09 16:00:00 | AAPL | Stock | 2.2711 | 2.2732 | 2.2679 | 2.2721 | 2217012.0 |
| 2006-08-09 16:30:00 | AAPL | Stock | 2.2714 | 2.2721 | 2.2711 | 2.2711 | 3709188.0 |
| 2006-08-09 17:00:00 | AAPL | Stock | 2.2718 | 2.2729 | 2.2689 | 2.2714 | 175420.0 |
| 2006-08-09 17:30:00 | AAPL | Stock | 2.2714 | 2.2718 | 2.2686 | 2.2696 | 122360.0 |
| 2006-08-09 18:00:00 | AAPL | Stock | 2.2686 | 2.2696 | 2.2686 | 2.2689 | 195664.0 |
| 2006-08-09 08:00:00 | MSFT | Stock | 24.48 | 24.48 | 24.47 | 24.48 | 9100.0 |
| 2006-08-09 08:30:00 | MSFT | Stock | 24.48 | 24.49 | 24.46 | 24.46 | 27108.0 |
| 2006-08-09 09:00:00 | MSFT | Stock | 24.49 | 24.5 | 24.42 | 24.5 | 51280.0 |
| 2006-08-09 09:30:00 | MSFT | Stock | 24.49 | 24.5 | 24.41 | 24.48 | 4435661.0 |
| 2006-08-09 10:00:00 | MSFT | Stock | 24.47 | 24.55 | 24.44 | 24.55 | 3789568.0 |
| 2006-08-09 10:30:00 | MSFT | Stock | 24.55 | 24.58 | 24.5 | 24.55 | 4259081.0 |
| 2006-08-09 11:00:00 | MSFT | Stock | 24.55 | 24.62 | 24.55 | 24.57 | 4756992.0 |
| 2006-08-09 11:30:00 | MSFT | Stock | 24.57 | 24.62 | 24.57 | 24.58 | 2454329.0 |
| 2006-08-09 12:00:00 | MSFT | Stock | 24.58 | 24.6 | 24.53 | 24.56 | 1375111.0 |
| 2006-08-09 12:30:00 | MSFT | Stock | 24.56 | 24.6 | 24.51 | 24.54 | 2352604.0 |
| 2006-08-09 13:00:00 | MSFT | Stock | 24.543 | 24.6 | 24.51 | 24.51 | 1881713.0 |
| 2006-08-09 13:30:00 | MSFT | Stock | 24.51 | 24.6 | 24.5 | 24.57 | 2049484.0 |
| 2006-08-09 14:00:00 | MSFT | Stock | 24.56 | 24.64 | 24.54 | 24.58 | 2620551.0 |
| 2006-08-09 14:30:00 | MSFT | Stock | 24.58 | 24.62 | 24.46 | 24.47 | 2995392.0 |
| 2006-08-09 15:00:00 | MSFT | Stock | 24.47 | 24.48 | 24.41 | 24.46 | 3729783.0 |
| 2006-08-09 15:30:00 | MSFT | Stock | 24.46 | 24.51 | 24.34 | 24.43 | 6023670.0 |
| 2006-08-09 16:00:00 | MSFT | Stock | 24.44 | 24.54 | 24.35 | 24.44 | 342074.0 |
| 2006-08-09 16:30:00 | MSFT | Stock | 24.44 | 24.44 | 24.44 | 24.44 | 2078.0 |
| 2006-08-09 17:00:00 | MSFT | Stock | 24.44 | 24.48 | 24.44 | 24.46 | 2400.0 |
| 2006-08-09 17:30:00 | MSFT | Stock | 24.48 | 24.48 | 24.418 | 24.44 | 7734.0 |
| 2006-08-09 18:00:00 | MSFT | Stock | 24.45 | 24.45 | 24.45 | 24.45 | 1750.0 |
| 2006-08-09 08:00:00 | NVDA | Stock | 0.4183 | 0.4183 | 0.4137 | 0.4137 | 345000.0 |
| 2006-08-09 08:30:00 | NVDA | Stock | 0.4125 | 0.4183 | 0.4125 | 0.4167 | 933000.0 |
| 2006-08-09 09:00:00 | NVDA | Stock | 0.4167 | 0.418 | 0.4123 | 0.4167 | 1131000.0 |
| 2006-08-09 09:30:00 | NVDA | Stock | 0.4137 | 0.425 | 0.4107 | 0.4163 | 130768560.0 |
| 2006-08-09 10:00:00 | NVDA | Stock | 0.416 | 0.4163 | 0.4102 | 0.4107 | 60384420.0 |
| 2006-08-09 10:30:00 | NVDA | Stock | 0.4107 | 0.4115 | 0.4043 | 0.4108 | 61219620.0 |
| 2006-08-09 11:00:00 | NVDA | Stock | 0.4108 | 0.4145 | 0.4105 | 0.4132 | 36950700.0 |
> showing 50 of 50,320 rows — these rows as CSV