PREVIEW / stock_30min / 2011-10-11
file: by_date/stock_30min/2011/2011-10-11.parquet size: 1.4 MB rows: 74,291 symbols: 3,491
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 |
|---|---|---|---|---|---|---|---|
| 2011-10-11 04:00:00 | AAPL | Stock | 13.8854 | 13.9111 | 13.8854 | 13.9111 | 53200.0 |
| 2011-10-11 04:30:00 | AAPL | Stock | 13.8786 | 13.8836 | 13.8611 | 13.8836 | 49560.0 |
| 2011-10-11 05:00:00 | AAPL | Stock | 13.8929 | 13.8929 | 13.8929 | 13.8929 | 2800.0 |
| 2011-10-11 05:30:00 | AAPL | Stock | 13.8914 | 13.8914 | 13.8914 | 13.8914 | 2800.0 |
| 2011-10-11 06:00:00 | AAPL | Stock | 13.9082 | 13.9107 | 13.9082 | 13.9107 | 8400.0 |
| 2011-10-11 06:30:00 | AAPL | Stock | 13.8839 | 13.8839 | 13.8839 | 13.8839 | 7000.0 |
| 2011-10-11 07:00:00 | AAPL | Stock | 13.8668 | 13.9325 | 13.8668 | 13.9129 | 194908.0 |
| 2011-10-11 07:30:00 | AAPL | Stock | 13.9275 | 13.9443 | 13.8954 | 13.9036 | 253848.0 |
| 2011-10-11 08:00:00 | AAPL | Stock | 13.9207 | 14.0468 | 13.9111 | 13.9964 | 3721676.0 |
| 2011-10-11 08:30:00 | AAPL | Stock | 14.0029 | 14.0168 | 13.9671 | 13.9854 | 2289840.0 |
| 2011-10-11 09:00:00 | AAPL | Stock | 13.985 | 14.0282 | 13.9632 | 14.0141 | 1657096.0 |
| 2011-10-11 09:30:00 | AAPL | Stock | 14.0204 | 14.225 | 13.9821 | 14.1864 | 125917316.0 |
| 2011-10-11 10:00:00 | AAPL | Stock | 14.1864 | 14.2804 | 14.1454 | 14.2768 | 61658296.0 |
| 2011-10-11 10:30:00 | AAPL | Stock | 14.2775 | 14.3321 | 14.2346 | 14.2534 | 65401784.0 |
| 2011-10-11 11:00:00 | AAPL | Stock | 14.2532 | 14.2814 | 14.2179 | 14.2514 | 30819012.0 |
| 2011-10-11 11:30:00 | AAPL | Stock | 14.2536 | 14.3011 | 14.2504 | 14.2793 | 27246940.0 |
| 2011-10-11 12:00:00 | AAPL | Stock | 14.2796 | 14.3079 | 14.2618 | 14.2829 | 19962488.0 |
| 2011-10-11 12:30:00 | AAPL | Stock | 14.2829 | 14.2918 | 14.1929 | 14.2321 | 25348988.0 |
| 2011-10-11 13:00:00 | AAPL | Stock | 14.2309 | 14.2468 | 14.1886 | 14.2386 | 19508888.0 |
| 2011-10-11 13:30:00 | AAPL | Stock | 14.2407 | 14.2971 | 14.2288 | 14.2971 | 19223848.0 |
| 2011-10-11 14:00:00 | AAPL | Stock | 14.2982 | 14.2982 | 14.2536 | 14.2746 | 22501220.0 |
| 2011-10-11 14:30:00 | AAPL | Stock | 14.2741 | 14.3429 | 14.2536 | 14.3421 | 32172056.0 |
| 2011-10-11 15:00:00 | AAPL | Stock | 14.3436 | 14.3993 | 14.2589 | 14.2646 | 73037132.0 |
| 2011-10-11 15:30:00 | AAPL | Stock | 14.2643 | 14.3329 | 14.2504 | 14.2954 | 59241616.0 |
| 2011-10-11 16:00:00 | AAPL | Stock | 14.295 | 14.3007 | 14.1556 | 14.2557 | 6553260.0 |
| 2011-10-11 16:30:00 | AAPL | Stock | 14.2589 | 14.2961 | 14.2286 | 14.2289 | 553196.0 |
| 2011-10-11 17:00:00 | AAPL | Stock | 14.2411 | 14.2571 | 14.2321 | 14.2571 | 172200.0 |
| 2011-10-11 17:30:00 | AAPL | Stock | 14.2571 | 14.2571 | 14.25 | 14.25 | 119000.0 |
| 2011-10-11 18:00:00 | AAPL | Stock | 14.2504 | 14.2961 | 14.2429 | 14.2429 | 186956.0 |
| 2011-10-11 18:30:00 | AAPL | Stock | 14.2489 | 14.2493 | 14.2361 | 14.2414 | 257040.0 |
| 2011-10-11 19:00:00 | AAPL | Stock | 14.2375 | 14.25 | 14.2321 | 14.2486 | 223636.0 |
| 2011-10-11 19:30:00 | AAPL | Stock | 14.2486 | 14.2561 | 14.2418 | 14.2479 | 134932.0 |
| 2011-10-11 07:00:00 | MSFT | Stock | 26.76 | 26.91 | 26.75 | 26.91 | 2100.0 |
| 2011-10-11 07:30:00 | MSFT | Stock | 26.92 | 26.92 | 26.88 | 26.88 | 700.0 |
| 2011-10-11 08:00:00 | MSFT | Stock | 26.88 | 26.94 | 26.88 | 26.9 | 6822.0 |
| 2011-10-11 08:30:00 | MSFT | Stock | 26.89 | 26.9 | 26.8 | 26.8 | 11300.0 |
| 2011-10-11 09:00:00 | MSFT | Stock | 26.8 | 26.9 | 26.76 | 26.84 | 77494.0 |
| 2011-10-11 09:30:00 | MSFT | Stock | 26.84 | 26.93 | 26.72 | 26.882 | 3692188.0 |
| 2011-10-11 10:00:00 | MSFT | Stock | 26.87 | 26.97 | 26.74 | 26.965 | 3415802.0 |
| 2011-10-11 10:30:00 | MSFT | Stock | 26.96 | 27.0 | 26.95 | 27.0 | 3124631.0 |
| 2011-10-11 11:00:00 | MSFT | Stock | 26.995 | 27.0 | 26.91 | 26.956 | 2261040.0 |
| 2011-10-11 11:30:00 | MSFT | Stock | 26.955 | 26.99 | 26.945 | 26.97 | 2133091.0 |
| 2011-10-11 12:00:00 | MSFT | Stock | 26.97 | 26.98 | 26.94 | 26.97 | 1267188.0 |
| 2011-10-11 12:30:00 | MSFT | Stock | 26.961 | 26.97 | 26.92 | 26.96 | 1827673.0 |
| 2011-10-11 13:00:00 | MSFT | Stock | 26.96 | 26.99 | 26.9 | 26.98 | 1929103.0 |
| 2011-10-11 13:30:00 | MSFT | Stock | 26.98 | 27.035 | 26.96 | 27.03 | 3377058.0 |
| 2011-10-11 14:00:00 | MSFT | Stock | 27.04 | 27.05 | 26.92 | 26.925 | 1891498.0 |
| 2011-10-11 14:30:00 | MSFT | Stock | 26.925 | 26.98 | 26.9 | 26.96 | 2171389.0 |
| 2011-10-11 15:00:00 | MSFT | Stock | 26.955 | 27.04 | 26.94 | 26.95 | 2544383.0 |
| 2011-10-11 15:30:00 | MSFT | Stock | 26.951 | 27.07 | 26.94 | 26.99 | 6681307.0 |
> showing 50 of 74,291 rows — these rows as CSV