PREVIEW / stock_30min / 2008-12-02
file: by_date/stock_30min/2008/2008-12-02.parquet size: 1.2 MB rows: 68,403 symbols: 3,329
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 |
|---|---|---|---|---|---|---|---|
| 2008-12-02 05:00:00 | AAPL | Stock | 3.2189 | 3.2189 | 3.2189 | 3.2189 | 14000.0 |
| 2008-12-02 06:30:00 | AAPL | Stock | 3.2189 | 3.2232 | 3.2179 | 3.2179 | 47600.0 |
| 2008-12-02 07:00:00 | AAPL | Stock | 3.2014 | 3.225 | 3.2014 | 3.225 | 25760.0 |
| 2008-12-02 07:30:00 | AAPL | Stock | 3.2254 | 3.2254 | 3.2036 | 3.2161 | 99960.0 |
| 2008-12-02 08:00:00 | AAPL | Stock | 3.2164 | 3.225 | 3.2161 | 3.2211 | 606340.0 |
| 2008-12-02 08:30:00 | AAPL | Stock | 3.2229 | 3.2307 | 3.2207 | 3.2207 | 434028.0 |
| 2008-12-02 09:00:00 | AAPL | Stock | 3.2218 | 3.2246 | 3.2107 | 3.2161 | 383124.0 |
| 2008-12-02 09:30:00 | AAPL | Stock | 3.2175 | 3.2275 | 3.0893 | 3.1129 | 145586140.0 |
| 2008-12-02 10:00:00 | AAPL | Stock | 3.1114 | 3.1918 | 3.0986 | 3.1575 | 131981864.0 |
| 2008-12-02 10:30:00 | AAPL | Stock | 3.1579 | 3.2532 | 3.1571 | 3.2471 | 107347072.0 |
| 2008-12-02 11:00:00 | AAPL | Stock | 3.2471 | 3.2679 | 3.2339 | 3.2421 | 80898468.0 |
| 2008-12-02 11:30:00 | AAPL | Stock | 3.2421 | 3.2643 | 3.2186 | 3.2593 | 66050824.0 |
| 2008-12-02 12:00:00 | AAPL | Stock | 3.2593 | 3.2821 | 3.2546 | 3.2771 | 51277128.0 |
| 2008-12-02 12:30:00 | AAPL | Stock | 3.2775 | 3.2807 | 3.2321 | 3.2532 | 52672984.0 |
| 2008-12-02 13:00:00 | AAPL | Stock | 3.2532 | 3.2711 | 3.2429 | 3.2462 | 43591800.0 |
| 2008-12-02 13:30:00 | AAPL | Stock | 3.2464 | 3.2482 | 3.2082 | 3.2171 | 55092184.0 |
| 2008-12-02 14:00:00 | AAPL | Stock | 3.2171 | 3.2268 | 3.1679 | 3.1875 | 75655748.0 |
| 2008-12-02 14:30:00 | AAPL | Stock | 3.1876 | 3.25 | 3.1793 | 3.2454 | 72733528.0 |
| 2008-12-02 15:00:00 | AAPL | Stock | 3.2457 | 3.2971 | 3.1954 | 3.285 | 70516768.0 |
| 2008-12-02 15:30:00 | AAPL | Stock | 3.2857 | 3.3089 | 3.25 | 3.3032 | 87758860.0 |
| 2008-12-02 16:00:00 | AAPL | Stock | 3.3036 | 3.3036 | 3.2073 | 3.2946 | 27491240.0 |
| 2008-12-02 16:30:00 | AAPL | Stock | 3.2964 | 3.3011 | 3.2189 | 3.2911 | 1061088.0 |
| 2008-12-02 17:00:00 | AAPL | Stock | 3.2979 | 3.2982 | 3.2921 | 3.2964 | 50400.0 |
| 2008-12-02 17:30:00 | AAPL | Stock | 3.2946 | 3.2986 | 3.2925 | 3.2964 | 214060.0 |
| 2008-12-02 18:00:00 | AAPL | Stock | 3.2964 | 3.3014 | 3.2946 | 3.2946 | 78372.0 |
| 2008-12-02 18:30:00 | AAPL | Stock | 3.2971 | 3.2979 | 3.2929 | 3.2936 | 199080.0 |
| 2008-12-02 19:00:00 | AAPL | Stock | 3.2936 | 3.3029 | 3.2936 | 3.3029 | 117740.0 |
| 2008-12-02 19:30:00 | AAPL | Stock | 3.2964 | 3.3043 | 3.2964 | 3.3036 | 337680.0 |
| 2008-12-02 05:00:00 | MSFT | Stock | 19.84 | 19.84 | 19.84 | 19.84 | 100.0 |
| 2008-12-02 07:00:00 | MSFT | Stock | 18.95 | 19.08 | 18.95 | 19.08 | 1950.0 |
| 2008-12-02 07:30:00 | MSFT | Stock | 19.08 | 19.08 | 19.0 | 19.04 | 3061.0 |
| 2008-12-02 08:00:00 | MSFT | Stock | 18.97 | 19.02 | 18.82 | 18.95 | 21714.0 |
| 2008-12-02 08:30:00 | MSFT | Stock | 18.95 | 19.02 | 18.92 | 19.0 | 24326.0 |
| 2008-12-02 09:00:00 | MSFT | Stock | 19.03 | 19.03 | 18.92 | 19.0 | 21649.0 |
| 2008-12-02 09:30:00 | MSFT | Stock | 18.98 | 19.015 | 18.56 | 18.8 | 6166503.0 |
| 2008-12-02 10:00:00 | MSFT | Stock | 18.79 | 18.96 | 18.76 | 18.93 | 6305785.0 |
| 2008-12-02 10:30:00 | MSFT | Stock | 18.93 | 19.118 | 18.91 | 19.036 | 4097216.0 |
| 2008-12-02 11:00:00 | MSFT | Stock | 19.04 | 19.1 | 18.89 | 19.05 | 2826113.0 |
| 2008-12-02 11:30:00 | MSFT | Stock | 19.05 | 19.28 | 18.9 | 19.21 | 3628520.0 |
| 2008-12-02 12:00:00 | MSFT | Stock | 19.2 | 19.3 | 18.75 | 19.27 | 3484011.0 |
| 2008-12-02 12:30:00 | MSFT | Stock | 19.27 | 19.3 | 19.1 | 19.228 | 3015933.0 |
| 2008-12-02 13:00:00 | MSFT | Stock | 19.22 | 19.31 | 19.17 | 19.23 | 3311423.0 |
| 2008-12-02 13:30:00 | MSFT | Stock | 19.24 | 19.24 | 19.0 | 19.013 | 4213082.0 |
| 2008-12-02 14:00:00 | MSFT | Stock | 19.01 | 19.07 | 18.63 | 18.732 | 6178599.0 |
| 2008-12-02 14:30:00 | MSFT | Stock | 18.735 | 18.94 | 18.66 | 18.92 | 5291939.0 |
| 2008-12-02 15:00:00 | MSFT | Stock | 18.91 | 19.13 | 18.63 | 19.05 | 4449105.0 |
| 2008-12-02 15:30:00 | MSFT | Stock | 19.06 | 19.19 | 18.71 | 19.16 | 7523947.0 |
| 2008-12-02 16:00:00 | MSFT | Stock | 19.15 | 19.2 | 18.654 | 19.1 | 9823040.0 |
| 2008-12-02 16:30:00 | MSFT | Stock | 19.13 | 19.15 | 18.983 | 19.07 | 24375.0 |
| 2008-12-02 17:00:00 | MSFT | Stock | 19.15 | 19.15 | 19.05 | 19.06 | 31111.0 |
> showing 50 of 68,403 rows — these rows as CSV