PREVIEW / stock_30min / 2010-11-29
file: by_date/stock_30min/2010/2010-11-29.parquet size: 1.4 MB rows: 74,356 symbols: 3,508
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-11-29 04:00:00 | AAPL | Stock | 11.2964 | 11.3529 | 11.2964 | 11.3529 | 22960.0 |
| 2010-11-29 04:30:00 | AAPL | Stock | 11.3404 | 11.3404 | 11.3125 | 11.3304 | 22400.0 |
| 2010-11-29 05:00:00 | AAPL | Stock | 11.31 | 11.31 | 11.3018 | 11.3018 | 8400.0 |
| 2010-11-29 05:30:00 | AAPL | Stock | 11.3082 | 11.3082 | 11.28 | 11.28 | 14000.0 |
| 2010-11-29 06:00:00 | AAPL | Stock | 11.28 | 11.2839 | 11.2768 | 11.2839 | 8400.0 |
| 2010-11-29 06:30:00 | AAPL | Stock | 11.2868 | 11.2964 | 11.2868 | 11.2964 | 28000.0 |
| 2010-11-29 07:00:00 | AAPL | Stock | 11.2857 | 11.3018 | 11.2732 | 11.2875 | 648900.0 |
| 2010-11-29 07:30:00 | AAPL | Stock | 11.2857 | 11.2857 | 11.2507 | 11.2839 | 248360.0 |
| 2010-11-29 08:00:00 | AAPL | Stock | 11.2839 | 11.3243 | 11.2836 | 11.3171 | 2292724.0 |
| 2010-11-29 08:30:00 | AAPL | Stock | 11.315 | 11.3196 | 11.2975 | 11.3036 | 1801856.0 |
| 2010-11-29 09:00:00 | AAPL | Stock | 11.3021 | 11.3064 | 11.2707 | 11.2707 | 1724072.0 |
| 2010-11-29 09:30:00 | AAPL | Stock | 11.2718 | 11.3054 | 11.1736 | 11.2057 | 79068640.0 |
| 2010-11-29 10:00:00 | AAPL | Stock | 11.2032 | 11.2117 | 11.1207 | 11.1813 | 56939820.0 |
| 2010-11-29 10:30:00 | AAPL | Stock | 11.1811 | 11.2271 | 11.1729 | 11.1868 | 31656380.0 |
| 2010-11-29 11:00:00 | AAPL | Stock | 11.1881 | 11.2136 | 11.1664 | 11.1964 | 24647616.0 |
| 2010-11-29 11:30:00 | AAPL | Stock | 11.1954 | 11.2061 | 11.1661 | 11.1775 | 19406940.0 |
| 2010-11-29 12:00:00 | AAPL | Stock | 11.1764 | 11.2054 | 11.1568 | 11.1955 | 18195408.0 |
| 2010-11-29 12:30:00 | AAPL | Stock | 11.1954 | 11.2064 | 11.1704 | 11.1882 | 16706424.0 |
| 2010-11-29 13:00:00 | AAPL | Stock | 11.1879 | 11.1893 | 11.165 | 11.1764 | 11547872.0 |
| 2010-11-29 13:30:00 | AAPL | Stock | 11.1779 | 11.1868 | 11.1643 | 11.1757 | 11178832.0 |
| 2010-11-29 14:00:00 | AAPL | Stock | 11.1773 | 11.2217 | 11.1707 | 11.2193 | 14228032.0 |
| 2010-11-29 14:30:00 | AAPL | Stock | 11.2179 | 11.2857 | 11.2168 | 11.2771 | 46105332.0 |
| 2010-11-29 15:00:00 | AAPL | Stock | 11.2761 | 11.3271 | 11.2643 | 11.3271 | 42733516.0 |
| 2010-11-29 15:30:00 | AAPL | Stock | 11.3264 | 11.3386 | 11.3039 | 11.3154 | 48638380.0 |
| 2010-11-29 16:00:00 | AAPL | Stock | 11.3161 | 11.3181 | 11.2302 | 11.3057 | 5851776.0 |
| 2010-11-29 16:30:00 | AAPL | Stock | 11.3071 | 11.3271 | 11.3039 | 11.3054 | 176904.0 |
| 2010-11-29 17:00:00 | AAPL | Stock | 11.3061 | 11.3075 | 11.3039 | 11.3057 | 137144.0 |
| 2010-11-29 17:30:00 | AAPL | Stock | 11.3039 | 11.3046 | 11.3 | 11.3007 | 178220.0 |
| 2010-11-29 18:00:00 | AAPL | Stock | 11.3014 | 11.3168 | 11.2982 | 11.3039 | 3088316.0 |
| 2010-11-29 18:30:00 | AAPL | Stock | 11.3043 | 11.3061 | 11.2986 | 11.3014 | 39648.0 |
| 2010-11-29 19:00:00 | AAPL | Stock | 11.2975 | 11.3054 | 11.2971 | 11.3036 | 28700.0 |
| 2010-11-29 19:30:00 | AAPL | Stock | 11.3036 | 11.3161 | 11.3036 | 11.315 | 463288.0 |
| 2010-11-29 08:00:00 | MSFT | Stock | 25.28 | 25.29 | 25.24 | 25.25 | 72444.0 |
| 2010-11-29 08:30:00 | MSFT | Stock | 25.25 | 25.25 | 25.18 | 25.25 | 92624.0 |
| 2010-11-29 09:00:00 | MSFT | Stock | 25.21 | 25.28 | 25.19 | 25.19 | 127213.0 |
| 2010-11-29 09:30:00 | MSFT | Stock | 25.19 | 25.228 | 25.0 | 25.04 | 7358184.0 |
| 2010-11-29 10:00:00 | MSFT | Stock | 25.04 | 25.09 | 24.93 | 25.01 | 6820665.0 |
| 2010-11-29 10:30:00 | MSFT | Stock | 25.012 | 25.14 | 25.005 | 25.01 | 5049094.0 |
| 2010-11-29 11:00:00 | MSFT | Stock | 25.02 | 25.09 | 25.005 | 25.07 | 3315447.0 |
| 2010-11-29 11:30:00 | MSFT | Stock | 25.07 | 25.13 | 25.04 | 25.11 | 3226838.0 |
| 2010-11-29 12:00:00 | MSFT | Stock | 25.11 | 25.15 | 25.09 | 25.115 | 2496912.0 |
| 2010-11-29 12:30:00 | MSFT | Stock | 25.11 | 25.15 | 25.1 | 25.125 | 1404448.0 |
| 2010-11-29 13:00:00 | MSFT | Stock | 25.13 | 25.14 | 25.08 | 25.08 | 1584241.0 |
| 2010-11-29 13:30:00 | MSFT | Stock | 25.088 | 25.13 | 25.052 | 25.087 | 2262261.0 |
| 2010-11-29 14:00:00 | MSFT | Stock | 25.08 | 25.2 | 25.07 | 25.2 | 2035717.0 |
| 2010-11-29 14:30:00 | MSFT | Stock | 25.19 | 25.315 | 25.19 | 25.3 | 3567334.0 |
| 2010-11-29 15:00:00 | MSFT | Stock | 25.31 | 25.41 | 25.29 | 25.41 | 3770264.0 |
| 2010-11-29 15:30:00 | MSFT | Stock | 25.405 | 25.42 | 25.31 | 25.31 | 6365042.0 |
| 2010-11-29 16:00:00 | MSFT | Stock | 25.31 | 25.355 | 25.147 | 25.158 | 3697532.0 |
| 2010-11-29 16:30:00 | MSFT | Stock | 25.3 | 25.415 | 25.262 | 25.35 | 26344.0 |
> showing 50 of 74,356 rows — these rows as CSV