PREVIEW / stock_30min / 2009-11-13
file: by_date/stock_30min/2009/2009-11-13.parquet size: 1.3 MB rows: 70,562 symbols: 3,400
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-13 05:00:00 | AAPL | Stock | 7.2411 | 7.2411 | 7.215 | 7.215 | 12936.0 |
| 2009-11-13 05:30:00 | AAPL | Stock | 7.215 | 7.215 | 7.1714 | 7.2071 | 21672.0 |
| 2009-11-13 06:00:00 | AAPL | Stock | 7.2146 | 7.2404 | 7.2146 | 7.2404 | 5600.0 |
| 2009-11-13 07:00:00 | AAPL | Stock | 7.2429 | 7.2429 | 7.2429 | 7.2429 | 5600.0 |
| 2009-11-13 07:30:00 | AAPL | Stock | 7.2364 | 7.2364 | 7.2364 | 7.2364 | 8400.0 |
| 2009-11-13 08:00:00 | AAPL | Stock | 7.2321 | 7.2429 | 7.225 | 7.2429 | 514780.0 |
| 2009-11-13 08:30:00 | AAPL | Stock | 7.2429 | 7.2757 | 7.2429 | 7.26 | 1389752.0 |
| 2009-11-13 09:00:00 | AAPL | Stock | 7.2607 | 7.2625 | 7.2404 | 7.2457 | 690480.0 |
| 2009-11-13 09:30:00 | AAPL | Stock | 7.2464 | 7.2614 | 7.2168 | 7.2357 | 55013980.0 |
| 2009-11-13 10:00:00 | AAPL | Stock | 7.2343 | 7.2679 | 7.2282 | 7.2639 | 32844840.0 |
| 2009-11-13 10:30:00 | AAPL | Stock | 7.2621 | 7.2696 | 7.2414 | 7.2564 | 24157644.0 |
| 2009-11-13 11:00:00 | AAPL | Stock | 7.2568 | 7.2829 | 7.2529 | 7.2779 | 22619772.0 |
| 2009-11-13 11:30:00 | AAPL | Stock | 7.2782 | 7.2946 | 7.2725 | 7.285 | 26957756.0 |
| 2009-11-13 12:00:00 | AAPL | Stock | 7.2846 | 7.3054 | 7.2843 | 7.305 | 16428104.0 |
| 2009-11-13 12:30:00 | AAPL | Stock | 7.3054 | 7.3154 | 7.2914 | 7.2939 | 16491776.0 |
| 2009-11-13 13:00:00 | AAPL | Stock | 7.2939 | 7.3021 | 7.2918 | 7.2954 | 8916992.0 |
| 2009-11-13 13:30:00 | AAPL | Stock | 7.2954 | 7.2979 | 7.2768 | 7.2796 | 15179108.0 |
| 2009-11-13 14:00:00 | AAPL | Stock | 7.2793 | 7.2964 | 7.2779 | 7.2889 | 13357960.0 |
| 2009-11-13 14:30:00 | AAPL | Stock | 7.2889 | 7.2907 | 7.2507 | 7.2536 | 25284000.0 |
| 2009-11-13 15:00:00 | AAPL | Stock | 7.2536 | 7.2807 | 7.2432 | 7.2743 | 27482476.0 |
| 2009-11-13 15:30:00 | AAPL | Stock | 7.2739 | 7.31 | 7.2718 | 7.3032 | 40085164.0 |
| 2009-11-13 16:00:00 | AAPL | Stock | 7.3036 | 7.3107 | 7.2719 | 7.3018 | 6051976.0 |
| 2009-11-13 16:30:00 | AAPL | Stock | 7.3054 | 7.3071 | 7.3018 | 7.3071 | 252728.0 |
| 2009-11-13 17:00:00 | AAPL | Stock | 7.3054 | 7.3064 | 7.3039 | 7.3054 | 37660.0 |
| 2009-11-13 17:30:00 | AAPL | Stock | 7.3036 | 7.3066 | 7.2964 | 7.3066 | 501900.0 |
| 2009-11-13 18:00:00 | AAPL | Stock | 7.3036 | 7.3036 | 7.3014 | 7.3036 | 629944.0 |
| 2009-11-13 18:30:00 | AAPL | Stock | 7.3 | 7.3025 | 7.3 | 7.3025 | 7728.0 |
| 2009-11-13 19:00:00 | AAPL | Stock | 7.3057 | 7.3079 | 7.3057 | 7.3079 | 59752.0 |
| 2009-11-13 19:30:00 | AAPL | Stock | 7.3061 | 7.3089 | 7.3036 | 7.3064 | 90048.0 |
| 2009-11-13 06:00:00 | MSFT | Stock | 29.59 | 29.59 | 29.59 | 29.59 | 100.0 |
| 2009-11-13 07:00:00 | MSFT | Stock | 29.59 | 29.59 | 29.5 | 29.5 | 600.0 |
| 2009-11-13 07:30:00 | MSFT | Stock | 29.6 | 29.6 | 29.6 | 29.6 | 100.0 |
| 2009-11-13 08:00:00 | MSFT | Stock | 29.58 | 29.58 | 29.45 | 29.5 | 10652.0 |
| 2009-11-13 08:30:00 | MSFT | Stock | 29.49 | 29.59 | 29.49 | 29.55 | 9300.0 |
| 2009-11-13 09:00:00 | MSFT | Stock | 29.55 | 29.59 | 29.44 | 29.45 | 43738.0 |
| 2009-11-13 09:30:00 | MSFT | Stock | 29.47 | 29.49 | 29.39 | 29.42 | 6244997.0 |
| 2009-11-13 10:00:00 | MSFT | Stock | 29.42 | 29.47 | 29.37 | 29.46 | 3694976.0 |
| 2009-11-13 10:30:00 | MSFT | Stock | 29.46 | 29.55 | 29.42 | 29.5 | 4148661.0 |
| 2009-11-13 11:00:00 | MSFT | Stock | 29.5 | 29.7 | 29.48 | 29.65 | 4683585.0 |
| 2009-11-13 11:30:00 | MSFT | Stock | 29.65 | 29.71 | 29.64 | 29.68 | 2414744.0 |
| 2009-11-13 12:00:00 | MSFT | Stock | 29.68 | 29.78 | 29.65 | 29.73 | 3837751.0 |
| 2009-11-13 12:30:00 | MSFT | Stock | 29.74 | 29.79 | 29.72 | 29.745 | 2032218.0 |
| 2009-11-13 13:00:00 | MSFT | Stock | 29.75 | 29.78 | 29.72 | 29.768 | 2312497.0 |
| 2009-11-13 13:30:00 | MSFT | Stock | 29.77 | 29.79 | 29.64 | 29.68 | 3968360.0 |
| 2009-11-13 14:00:00 | MSFT | Stock | 29.67 | 29.74 | 29.67 | 29.692 | 3562557.0 |
| 2009-11-13 14:30:00 | MSFT | Stock | 29.693 | 29.72 | 29.58 | 29.58 | 4226875.0 |
| 2009-11-13 15:00:00 | MSFT | Stock | 29.58 | 29.67 | 29.58 | 29.643 | 3922466.0 |
| 2009-11-13 15:30:00 | MSFT | Stock | 29.648 | 29.69 | 29.61 | 29.63 | 5343514.0 |
| 2009-11-13 16:00:00 | MSFT | Stock | 29.63 | 29.64 | 29.588 | 29.62 | 1568456.0 |
| 2009-11-13 16:30:00 | MSFT | Stock | 29.64 | 29.74 | 29.6 | 29.6 | 22849.0 |
> showing 50 of 70,562 rows — these rows as CSV