PREVIEW / stock_30min / 2005-11-16
file: by_date/stock_30min/2005/2005-11-16.parquet size: 864 KB rows: 46,540 symbols: 2,122
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 |
|---|---|---|---|---|---|---|---|
| 2005-11-16 07:30:00 | AAPL | Stock | 2.2475 | 2.2475 | 2.2386 | 2.2436 | 170800.0 |
| 2005-11-16 08:00:00 | AAPL | Stock | 2.2411 | 2.25 | 2.2364 | 2.2425 | 1862504.0 |
| 2005-11-16 08:30:00 | AAPL | Stock | 2.2418 | 2.2561 | 2.2411 | 2.2561 | 1621256.0 |
| 2005-11-16 09:00:00 | AAPL | Stock | 2.2529 | 2.2607 | 2.2482 | 2.2539 | 4149096.0 |
| 2005-11-16 09:30:00 | AAPL | Stock | 2.2554 | 2.2836 | 2.2532 | 2.2729 | 144933236.0 |
| 2005-11-16 10:00:00 | AAPL | Stock | 2.2732 | 2.2943 | 2.2696 | 2.2893 | 101424148.0 |
| 2005-11-16 10:30:00 | AAPL | Stock | 2.2889 | 2.2996 | 2.2811 | 2.294 | 71508584.0 |
| 2005-11-16 11:00:00 | AAPL | Stock | 2.2936 | 2.2939 | 2.2789 | 2.29 | 49729680.0 |
| 2005-11-16 11:30:00 | AAPL | Stock | 2.2896 | 2.3032 | 2.2871 | 2.3 | 45227448.0 |
| 2005-11-16 12:00:00 | AAPL | Stock | 2.2996 | 2.3032 | 2.2929 | 2.2961 | 28900648.0 |
| 2005-11-16 12:30:00 | AAPL | Stock | 2.2961 | 2.2986 | 2.2871 | 2.2914 | 24345580.0 |
| 2005-11-16 13:00:00 | AAPL | Stock | 2.2911 | 2.2979 | 2.2875 | 2.2968 | 24878280.0 |
| 2005-11-16 13:30:00 | AAPL | Stock | 2.2968 | 2.3011 | 2.2936 | 2.2989 | 25759608.0 |
| 2005-11-16 14:00:00 | AAPL | Stock | 2.2989 | 2.2989 | 2.2914 | 2.295 | 23021404.0 |
| 2005-11-16 14:30:00 | AAPL | Stock | 2.295 | 2.3014 | 2.2904 | 2.3007 | 35837424.0 |
| 2005-11-16 15:00:00 | AAPL | Stock | 2.3007 | 2.3132 | 2.2954 | 2.3107 | 61764164.0 |
| 2005-11-16 15:30:00 | AAPL | Stock | 2.3107 | 2.3236 | 2.305 | 2.3204 | 107183748.0 |
| 2005-11-16 16:00:00 | AAPL | Stock | 2.3196 | 2.325 | 2.3161 | 2.3232 | 3252900.0 |
| 2005-11-16 16:30:00 | AAPL | Stock | 2.325 | 2.335 | 2.3196 | 2.3196 | 6202112.0 |
| 2005-11-16 17:00:00 | AAPL | Stock | 2.3321 | 2.3357 | 2.2917 | 2.3339 | 1321712.0 |
| 2005-11-16 17:30:00 | AAPL | Stock | 2.3336 | 2.3336 | 2.3068 | 2.3286 | 734748.0 |
| 2005-11-16 18:00:00 | AAPL | Stock | 2.3307 | 2.3332 | 2.3296 | 2.3332 | 194096.0 |
| 2005-11-16 07:00:00 | MSFT | Stock | 26.5 | 27.49 | 26.5 | 27.49 | 1000.0 |
| 2005-11-16 07:30:00 | MSFT | Stock | 27.4 | 27.43 | 27.4 | 27.43 | 10000.0 |
| 2005-11-16 08:00:00 | MSFT | Stock | 27.45 | 27.58 | 27.42 | 27.43 | 23254.0 |
| 2005-11-16 08:30:00 | MSFT | Stock | 27.43 | 27.45 | 27.42 | 27.44 | 57270.0 |
| 2005-11-16 09:00:00 | MSFT | Stock | 27.44 | 27.48 | 27.44 | 27.48 | 57109.0 |
| 2005-11-16 09:30:00 | MSFT | Stock | 27.48 | 27.6 | 27.44 | 27.6 | 6452449.0 |
| 2005-11-16 10:00:00 | MSFT | Stock | 27.59 | 27.65 | 27.54 | 27.6 | 5254196.0 |
| 2005-11-16 10:30:00 | MSFT | Stock | 27.6 | 27.67 | 27.59 | 27.6 | 4762054.0 |
| 2005-11-16 11:00:00 | MSFT | Stock | 27.6 | 27.61 | 27.52 | 27.59 | 5521806.0 |
| 2005-11-16 11:30:00 | MSFT | Stock | 27.59 | 27.62 | 27.57 | 27.59 | 2612299.0 |
| 2005-11-16 12:00:00 | MSFT | Stock | 27.59 | 27.621 | 27.56 | 27.6 | 2272507.0 |
| 2005-11-16 12:30:00 | MSFT | Stock | 27.6 | 27.63 | 27.55 | 27.62 | 2801370.0 |
| 2005-11-16 13:00:00 | MSFT | Stock | 27.61 | 27.751 | 27.53 | 27.75 | 8065568.0 |
| 2005-11-16 13:30:00 | MSFT | Stock | 27.74 | 27.8 | 27.55 | 27.76 | 9794615.0 |
| 2005-11-16 14:00:00 | MSFT | Stock | 27.76 | 27.8 | 27.73 | 27.77 | 4209372.0 |
| 2005-11-16 14:30:00 | MSFT | Stock | 27.77 | 27.851 | 27.71 | 27.85 | 8761976.0 |
| 2005-11-16 15:00:00 | MSFT | Stock | 27.84 | 27.88 | 27.75 | 27.8 | 7539614.0 |
| 2005-11-16 15:30:00 | MSFT | Stock | 27.81 | 27.82 | 27.7 | 27.75 | 12544366.0 |
| 2005-11-16 16:00:00 | MSFT | Stock | 27.75 | 27.82 | 27.64 | 27.77 | 178251.0 |
| 2005-11-16 16:30:00 | MSFT | Stock | 27.77 | 27.81 | 27.74 | 27.81 | 1506198.0 |
| 2005-11-16 17:00:00 | MSFT | Stock | 27.77 | 27.8 | 27.689 | 27.74 | 1061805.0 |
| 2005-11-16 17:30:00 | MSFT | Stock | 27.77 | 27.804 | 27.75 | 27.77 | 4161.0 |
| 2005-11-16 18:00:00 | MSFT | Stock | 27.77 | 27.78 | 27.76 | 27.77 | 1395.0 |
| 2005-11-16 09:00:00 | NVDA | Stock | 0.2906 | 0.2907 | 0.2902 | 0.2907 | 192000.0 |
| 2005-11-16 09:30:00 | NVDA | Stock | 0.2904 | 0.2922 | 0.2873 | 0.2879 | 80149800.0 |
| 2005-11-16 10:00:00 | NVDA | Stock | 0.2879 | 0.2883 | 0.2837 | 0.2859 | 73297200.0 |
| 2005-11-16 10:30:00 | NVDA | Stock | 0.2858 | 0.2904 | 0.2858 | 0.2893 | 52075320.0 |
| 2005-11-16 11:00:00 | NVDA | Stock | 0.2892 | 0.2895 | 0.2877 | 0.2883 | 26609640.0 |
> showing 50 of 46,540 rows — these rows as CSV