PREVIEW / stock_30min / 2010-12-01
file: by_date/stock_30min/2010/2010-12-01.parquet size: 1.5 MB rows: 78,610 symbols: 3,531
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-01 04:30:00 | AAPL | Stock | 11.1786 | 11.1786 | 11.1786 | 11.1786 | 11200.0 |
| 2010-12-01 05:00:00 | AAPL | Stock | 11.1982 | 11.2007 | 11.1982 | 11.2007 | 5600.0 |
| 2010-12-01 05:30:00 | AAPL | Stock | 11.2196 | 11.2196 | 11.2196 | 11.2196 | 4200.0 |
| 2010-12-01 06:00:00 | AAPL | Stock | 11.2196 | 11.2318 | 11.1957 | 11.1957 | 16800.0 |
| 2010-12-01 06:30:00 | AAPL | Stock | 11.2314 | 11.2411 | 11.2314 | 11.2411 | 31500.0 |
| 2010-12-01 07:00:00 | AAPL | Stock | 11.2393 | 11.2482 | 11.2136 | 11.2143 | 444220.0 |
| 2010-12-01 07:30:00 | AAPL | Stock | 11.2089 | 11.2214 | 11.2004 | 11.2182 | 1030344.0 |
| 2010-12-01 08:00:00 | AAPL | Stock | 11.2186 | 11.2375 | 11.2075 | 11.2304 | 3698688.0 |
| 2010-12-01 08:30:00 | AAPL | Stock | 11.2261 | 11.2411 | 11.2221 | 11.2361 | 2493064.0 |
| 2010-12-01 09:00:00 | AAPL | Stock | 11.2361 | 11.2614 | 11.2357 | 11.2614 | 4068540.0 |
| 2010-12-01 09:30:00 | AAPL | Stock | 11.2621 | 11.3032 | 11.25 | 11.2986 | 81154724.0 |
| 2010-12-01 10:00:00 | AAPL | Stock | 11.2996 | 11.3036 | 11.2646 | 11.2818 | 36057504.0 |
| 2010-12-01 10:30:00 | AAPL | Stock | 11.2786 | 11.3139 | 11.2779 | 11.3029 | 37522184.0 |
| 2010-12-01 11:00:00 | AAPL | Stock | 11.3032 | 11.3182 | 11.2882 | 11.3157 | 22514184.0 |
| 2010-12-01 11:30:00 | AAPL | Stock | 11.3164 | 11.3318 | 11.305 | 11.3286 | 28051772.0 |
| 2010-12-01 12:00:00 | AAPL | Stock | 11.3296 | 11.3368 | 11.3143 | 11.3218 | 27846840.0 |
| 2010-12-01 12:30:00 | AAPL | Stock | 11.3209 | 11.3321 | 11.3143 | 11.3304 | 17400404.0 |
| 2010-12-01 13:00:00 | AAPL | Stock | 11.3305 | 11.3482 | 11.3032 | 11.3171 | 34168932.0 |
| 2010-12-01 13:30:00 | AAPL | Stock | 11.3171 | 11.3343 | 11.3111 | 11.3264 | 15889244.0 |
| 2010-12-01 14:00:00 | AAPL | Stock | 11.3261 | 11.3425 | 11.3111 | 11.3273 | 21941808.0 |
| 2010-12-01 14:30:00 | AAPL | Stock | 11.3286 | 11.3375 | 11.3175 | 11.3279 | 15748404.0 |
| 2010-12-01 15:00:00 | AAPL | Stock | 11.3269 | 11.3272 | 11.3089 | 11.3111 | 21163632.0 |
| 2010-12-01 15:30:00 | AAPL | Stock | 11.3125 | 11.3246 | 11.2936 | 11.3114 | 47390140.0 |
| 2010-12-01 16:00:00 | AAPL | Stock | 11.3114 | 11.3214 | 11.2929 | 11.2982 | 36619856.0 |
| 2010-12-01 16:30:00 | AAPL | Stock | 11.2964 | 11.3 | 11.2932 | 11.2932 | 97300.0 |
| 2010-12-01 17:00:00 | AAPL | Stock | 11.3218 | 11.3218 | 11.2929 | 11.2968 | 1038156.0 |
| 2010-12-01 17:30:00 | AAPL | Stock | 11.2964 | 11.3 | 11.2964 | 11.2989 | 52668.0 |
| 2010-12-01 18:00:00 | AAPL | Stock | 11.2993 | 11.3036 | 11.2964 | 11.3007 | 347004.0 |
| 2010-12-01 18:30:00 | AAPL | Stock | 11.3011 | 11.3036 | 11.2929 | 11.2964 | 597044.0 |
| 2010-12-01 19:00:00 | AAPL | Stock | 11.2946 | 11.2946 | 11.2875 | 11.2882 | 403536.0 |
| 2010-12-01 19:30:00 | AAPL | Stock | 11.2875 | 11.2875 | 11.2568 | 11.2579 | 997304.0 |
| 2010-12-01 06:00:00 | MSFT | Stock | 25.46 | 25.47 | 25.46 | 25.47 | 200.0 |
| 2010-12-01 07:00:00 | MSFT | Stock | 25.45 | 25.45 | 25.42 | 25.45 | 2600.0 |
| 2010-12-01 07:30:00 | MSFT | Stock | 25.42 | 25.42 | 25.34 | 25.41 | 11132.0 |
| 2010-12-01 08:00:00 | MSFT | Stock | 25.41 | 25.44 | 25.36 | 25.43 | 28995.0 |
| 2010-12-01 08:30:00 | MSFT | Stock | 25.43 | 25.49 | 25.42 | 25.48 | 65604.0 |
| 2010-12-01 09:00:00 | MSFT | Stock | 25.49 | 25.58 | 25.47 | 25.57 | 136661.0 |
| 2010-12-01 09:30:00 | MSFT | Stock | 25.57 | 25.91 | 25.56 | 25.88 | 10535481.0 |
| 2010-12-01 10:00:00 | MSFT | Stock | 25.88 | 25.97 | 25.85 | 25.91 | 9323392.0 |
| 2010-12-01 10:30:00 | MSFT | Stock | 25.9 | 25.94 | 25.86 | 25.87 | 5988581.0 |
| 2010-12-01 11:00:00 | MSFT | Stock | 25.87 | 25.93 | 25.82 | 25.86 | 4421405.0 |
| 2010-12-01 11:30:00 | MSFT | Stock | 25.87 | 26.0 | 25.86 | 25.98 | 4151276.0 |
| 2010-12-01 12:00:00 | MSFT | Stock | 25.985 | 26.08 | 25.98 | 26.045 | 3485378.0 |
| 2010-12-01 12:30:00 | MSFT | Stock | 26.04 | 26.15 | 26.01 | 26.13 | 3335413.0 |
| 2010-12-01 13:00:00 | MSFT | Stock | 26.131 | 26.23 | 26.1 | 26.12 | 5148497.0 |
| 2010-12-01 13:30:00 | MSFT | Stock | 26.12 | 26.19 | 26.11 | 26.162 | 3509055.0 |
| 2010-12-01 14:00:00 | MSFT | Stock | 26.17 | 26.21 | 26.13 | 26.15 | 3188297.0 |
| 2010-12-01 14:30:00 | MSFT | Stock | 26.146 | 26.25 | 26.146 | 26.24 | 2977369.0 |
| 2010-12-01 15:00:00 | MSFT | Stock | 26.25 | 26.25 | 26.09 | 26.17 | 3752477.0 |
| 2010-12-01 15:30:00 | MSFT | Stock | 26.165 | 26.2 | 26.03 | 26.05 | 7254132.0 |
> showing 50 of 78,610 rows — these rows as CSV