PREVIEW / stock_30min / 2001-09-24
file: by_date/stock_30min/2001/2001-09-24.parquet size: 551 KB rows: 30,066 symbols: 1,346
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 |
|---|---|---|---|---|---|---|---|
| 2001-09-24 08:00:00 | AAPL | Stock | 0.2902 | 0.2914 | 0.2893 | 0.2911 | 268800.0 |
| 2001-09-24 08:30:00 | AAPL | Stock | 0.2911 | 0.2925 | 0.2911 | 0.2914 | 162400.0 |
| 2001-09-24 09:00:00 | AAPL | Stock | 0.2902 | 0.2907 | 0.2864 | 0.2884 | 1624000.0 |
| 2001-09-24 09:30:00 | AAPL | Stock | 0.2877 | 0.2946 | 0.2848 | 0.2914 | 43192800.0 |
| 2001-09-24 10:00:00 | AAPL | Stock | 0.2915 | 0.2973 | 0.2911 | 0.2936 | 24304000.0 |
| 2001-09-24 10:30:00 | AAPL | Stock | 0.2936 | 0.3 | 0.2929 | 0.2963 | 34417600.0 |
| 2001-09-24 11:00:00 | AAPL | Stock | 0.2961 | 0.3 | 0.2955 | 0.2966 | 19689600.0 |
| 2001-09-24 11:30:00 | AAPL | Stock | 0.2966 | 0.2989 | 0.2963 | 0.2971 | 8932000.0 |
| 2001-09-24 12:00:00 | AAPL | Stock | 0.2968 | 0.2991 | 0.2966 | 0.2979 | 9492000.0 |
| 2001-09-24 12:30:00 | AAPL | Stock | 0.2979 | 0.2991 | 0.2973 | 0.2989 | 5908000.0 |
| 2001-09-24 13:00:00 | AAPL | Stock | 0.2989 | 0.2998 | 0.293 | 0.2946 | 19213600.0 |
| 2001-09-24 13:30:00 | AAPL | Stock | 0.2946 | 0.2968 | 0.2941 | 0.2964 | 9133600.0 |
| 2001-09-24 14:00:00 | AAPL | Stock | 0.2964 | 0.2979 | 0.295 | 0.2959 | 11200000.0 |
| 2001-09-24 14:30:00 | AAPL | Stock | 0.2955 | 0.3007 | 0.2955 | 0.2995 | 11502400.0 |
| 2001-09-24 15:00:00 | AAPL | Stock | 0.2995 | 0.3008 | 0.2929 | 0.293 | 26633600.0 |
| 2001-09-24 15:30:00 | AAPL | Stock | 0.293 | 0.2977 | 0.288 | 0.2936 | 48154400.0 |
| 2001-09-24 16:00:00 | AAPL | Stock | 0.2936 | 0.2948 | 0.2886 | 0.2927 | 6714400.0 |
| 2001-09-24 16:30:00 | AAPL | Stock | 0.2888 | 0.2948 | 0.2888 | 0.2888 | 67200.0 |
| 2001-09-24 17:00:00 | AAPL | Stock | 0.2938 | 0.2938 | 0.2934 | 0.2938 | 3774400.0 |
| 2001-09-24 18:00:00 | AAPL | Stock | 0.2949 | 0.2949 | 0.2949 | 0.2949 | 392000.0 |
| 2001-09-24 08:00:00 | MSFT | Stock | 25.25 | 26.0 | 24.8525 | 25.65 | 320800.0 |
| 2001-09-24 08:30:00 | MSFT | Stock | 25.575 | 25.65 | 25.5 | 25.5925 | 89000.0 |
| 2001-09-24 09:00:00 | MSFT | Stock | 25.6 | 25.895 | 25.325 | 25.325 | 351800.0 |
| 2001-09-24 09:30:00 | MSFT | Stock | 25.325 | 25.475 | 25.055 | 25.085 | 13507200.0 |
| 2001-09-24 10:00:00 | MSFT | Stock | 25.09 | 25.34 | 24.935 | 25.235 | 9937800.0 |
| 2001-09-24 10:30:00 | MSFT | Stock | 25.23 | 25.6 | 25.18 | 25.57 | 7312000.0 |
| 2001-09-24 11:00:00 | MSFT | Stock | 25.575 | 25.75 | 25.5 | 25.585 | 5569400.0 |
| 2001-09-24 11:30:00 | MSFT | Stock | 25.575 | 25.75 | 25.545 | 25.7 | 3797000.0 |
| 2001-09-24 12:00:00 | MSFT | Stock | 25.7 | 25.7705 | 25.62 | 25.625 | 3904400.0 |
| 2001-09-24 12:30:00 | MSFT | Stock | 25.625 | 25.985 | 25.605 | 25.97 | 3505600.0 |
| 2001-09-24 13:00:00 | MSFT | Stock | 25.955 | 25.99 | 25.835 | 25.93 | 2605000.0 |
| 2001-09-24 13:30:00 | MSFT | Stock | 25.94 | 25.9505 | 25.755 | 25.765 | 3446000.0 |
| 2001-09-24 14:00:00 | MSFT | Stock | 25.77 | 25.9455 | 25.74 | 25.885 | 4023400.0 |
| 2001-09-24 14:30:00 | MSFT | Stock | 25.885 | 26.175 | 25.85 | 26.14 | 4943000.0 |
| 2001-09-24 15:00:00 | MSFT | Stock | 26.14 | 26.225 | 26.005 | 26.05 | 5397600.0 |
| 2001-09-24 15:30:00 | MSFT | Stock | 26.06 | 26.1 | 25.8 | 26.005 | 8186000.0 |
| 2001-09-24 16:00:00 | MSFT | Stock | 26.0 | 26.075 | 25.325 | 26.0 | 3918000.0 |
| 2001-09-24 16:30:00 | MSFT | Stock | 25.95 | 25.995 | 24.57 | 25.985 | 17600.0 |
| 2001-09-24 17:00:00 | MSFT | Stock | 25.9712 | 26.005 | 25.94 | 26.005 | 531000.0 |
| 2001-09-24 17:30:00 | MSFT | Stock | 25.99 | 25.99 | 25.99 | 25.99 | 2000.0 |
| 2001-09-24 18:00:00 | MSFT | Stock | 26.0 | 26.0 | 26.0 | 26.0 | 600.0 |
| 2001-09-24 08:00:00 | NVDA | Stock | 0.2322 | 0.2427 | 0.2322 | 0.2375 | 360000.0 |
| 2001-09-24 08:30:00 | NVDA | Stock | 0.2392 | 0.2417 | 0.2364 | 0.2417 | 2028000.0 |
| 2001-09-24 09:00:00 | NVDA | Stock | 0.24 | 0.2427 | 0.2375 | 0.2426 | 7164000.0 |
| 2001-09-24 09:30:00 | NVDA | Stock | 0.2426 | 0.2431 | 0.2318 | 0.2356 | 275304000.0 |
| 2001-09-24 10:00:00 | NVDA | Stock | 0.2356 | 0.2504 | 0.2333 | 0.2457 | 246576000.0 |
| 2001-09-24 10:30:00 | NVDA | Stock | 0.2457 | 0.2487 | 0.2425 | 0.2472 | 93312000.0 |
| 2001-09-24 11:00:00 | NVDA | Stock | 0.2471 | 0.2496 | 0.2458 | 0.2473 | 113616000.0 |
| 2001-09-24 11:30:00 | NVDA | Stock | 0.2472 | 0.2485 | 0.2467 | 0.2477 | 54972000.0 |
| 2001-09-24 12:00:00 | NVDA | Stock | 0.2477 | 0.25 | 0.2468 | 0.2468 | 56964000.0 |
> showing 50 of 30,066 rows — these rows as CSV