PREVIEW / stock_30min / 2009-11-24
file: by_date/stock_30min/2009/2009-11-24.parquet size: 1.3 MB rows: 70,910 symbols: 3,416
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-24 05:00:00 | AAPL | Stock | 7.3514 | 7.3514 | 7.3054 | 7.3054 | 43512.0 |
| 2009-11-24 07:00:00 | AAPL | Stock | 7.3468 | 7.3468 | 7.3468 | 7.3468 | 11200.0 |
| 2009-11-24 07:30:00 | AAPL | Stock | 7.35 | 7.35 | 7.3418 | 7.3418 | 54600.0 |
| 2009-11-24 08:00:00 | AAPL | Stock | 7.3396 | 7.3493 | 7.3143 | 7.3282 | 592452.0 |
| 2009-11-24 08:30:00 | AAPL | Stock | 7.3268 | 7.3339 | 7.3179 | 7.3321 | 601132.0 |
| 2009-11-24 09:00:00 | AAPL | Stock | 7.3343 | 7.3432 | 7.3325 | 7.3336 | 593152.0 |
| 2009-11-24 09:30:00 | AAPL | Stock | 7.3332 | 7.3332 | 7.2464 | 7.2564 | 72069172.0 |
| 2009-11-24 10:00:00 | AAPL | Stock | 7.2571 | 7.2799 | 7.25 | 7.2647 | 38815672.0 |
| 2009-11-24 10:30:00 | AAPL | Stock | 7.2654 | 7.2946 | 7.2607 | 7.2864 | 26769988.0 |
| 2009-11-24 11:00:00 | AAPL | Stock | 7.2862 | 7.2939 | 7.2596 | 7.2614 | 19996480.0 |
| 2009-11-24 11:30:00 | AAPL | Stock | 7.2621 | 7.2782 | 7.2589 | 7.275 | 10081652.0 |
| 2009-11-24 12:00:00 | AAPL | Stock | 7.2757 | 7.2839 | 7.2714 | 7.2764 | 7479528.0 |
| 2009-11-24 12:30:00 | AAPL | Stock | 7.2779 | 7.2836 | 7.2646 | 7.2686 | 7771428.0 |
| 2009-11-24 13:00:00 | AAPL | Stock | 7.2676 | 7.2854 | 7.2657 | 7.2821 | 8631476.0 |
| 2009-11-24 13:30:00 | AAPL | Stock | 7.2829 | 7.2929 | 7.2818 | 7.2871 | 9832620.0 |
| 2009-11-24 14:00:00 | AAPL | Stock | 7.2868 | 7.3136 | 7.2814 | 7.3079 | 17769136.0 |
| 2009-11-24 14:30:00 | AAPL | Stock | 7.3082 | 7.3268 | 7.3036 | 7.3161 | 20723892.0 |
| 2009-11-24 15:00:00 | AAPL | Stock | 7.3164 | 7.325 | 7.2954 | 7.3101 | 25865980.0 |
| 2009-11-24 15:30:00 | AAPL | Stock | 7.3096 | 7.3111 | 7.2929 | 7.3014 | 31813124.0 |
| 2009-11-24 16:00:00 | AAPL | Stock | 7.3014 | 7.3105 | 7.2557 | 7.3014 | 10422636.0 |
| 2009-11-24 16:30:00 | AAPL | Stock | 7.3046 | 7.305 | 7.3014 | 7.3014 | 170548.0 |
| 2009-11-24 17:00:00 | AAPL | Stock | 7.3029 | 7.3075 | 7.3029 | 7.3071 | 120876.0 |
| 2009-11-24 17:30:00 | AAPL | Stock | 7.3079 | 7.3086 | 7.3032 | 7.3068 | 19600.0 |
| 2009-11-24 18:00:00 | AAPL | Stock | 7.3068 | 7.3089 | 7.3014 | 7.3054 | 252196.0 |
| 2009-11-24 18:30:00 | AAPL | Stock | 7.3043 | 7.3043 | 7.3043 | 7.3043 | 2800.0 |
| 2009-11-24 19:00:00 | AAPL | Stock | 7.3054 | 7.3114 | 7.3054 | 7.3114 | 124824.0 |
| 2009-11-24 19:30:00 | AAPL | Stock | 7.3071 | 7.3089 | 7.3057 | 7.3089 | 52360.0 |
| 2009-11-24 04:00:00 | MSFT | Stock | 29.76 | 29.76 | 29.76 | 29.76 | 300.0 |
| 2009-11-24 08:00:00 | MSFT | Stock | 29.95 | 29.95 | 29.9 | 29.9 | 1605.0 |
| 2009-11-24 08:30:00 | MSFT | Stock | 29.9 | 29.9 | 29.9 | 29.9 | 2800.0 |
| 2009-11-24 09:00:00 | MSFT | Stock | 29.94 | 30.0 | 29.93 | 29.95 | 1023360.0 |
| 2009-11-24 09:30:00 | MSFT | Stock | 29.95 | 29.96 | 29.79 | 29.84 | 5235687.0 |
| 2009-11-24 10:00:00 | MSFT | Stock | 29.81 | 29.94 | 29.75 | 29.85 | 3881687.0 |
| 2009-11-24 10:30:00 | MSFT | Stock | 29.85 | 29.99 | 29.85 | 29.98 | 2166805.0 |
| 2009-11-24 11:00:00 | MSFT | Stock | 29.988 | 29.99 | 29.9 | 29.91 | 2539276.0 |
| 2009-11-24 11:30:00 | MSFT | Stock | 29.91 | 29.95 | 29.9 | 29.928 | 1334180.0 |
| 2009-11-24 12:00:00 | MSFT | Stock | 29.921 | 29.93 | 29.9 | 29.93 | 931147.0 |
| 2009-11-24 12:30:00 | MSFT | Stock | 29.93 | 29.93 | 29.86 | 29.86 | 1054254.0 |
| 2009-11-24 13:00:00 | MSFT | Stock | 29.87 | 29.94 | 29.86 | 29.89 | 1644638.0 |
| 2009-11-24 13:30:00 | MSFT | Stock | 29.89 | 29.94 | 29.85 | 29.87 | 2150341.0 |
| 2009-11-24 14:00:00 | MSFT | Stock | 29.87 | 29.9 | 29.8 | 29.82 | 3765937.0 |
| 2009-11-24 14:30:00 | MSFT | Stock | 29.83 | 29.86 | 29.81 | 29.855 | 2458303.0 |
| 2009-11-24 15:00:00 | MSFT | Stock | 29.86 | 29.93 | 29.84 | 29.901 | 2290963.0 |
| 2009-11-24 15:30:00 | MSFT | Stock | 29.91 | 29.93 | 29.85 | 29.9 | 3760739.0 |
| 2009-11-24 16:00:00 | MSFT | Stock | 29.92 | 29.94 | 29.87 | 29.9 | 1669289.0 |
| 2009-11-24 16:30:00 | MSFT | Stock | 29.871 | 29.93 | 29.871 | 29.91 | 70552.0 |
| 2009-11-24 17:00:00 | MSFT | Stock | 29.93 | 29.93 | 29.7 | 29.74 | 52595.0 |
| 2009-11-24 17:30:00 | MSFT | Stock | 29.74 | 29.75 | 29.7 | 29.73 | 11250.0 |
| 2009-11-24 18:00:00 | MSFT | Stock | 29.75 | 29.91 | 29.7 | 29.7 | 44587.0 |
| 2009-11-24 18:30:00 | MSFT | Stock | 29.69 | 29.7 | 29.68 | 29.7 | 4000.0 |
> showing 50 of 70,910 rows — these rows as CSV