PREVIEW / stock_30min / 2014-02-06
file: by_date/stock_30min/2014/2014-02-06.parquet size: 1.6 MB rows: 82,653 symbols: 3,556
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 |
|---|---|---|---|---|---|---|---|
| 2014-02-06 04:00:00 | AAPL | Stock | 18.2311 | 18.3214 | 18.2311 | 18.2661 | 8400.0 |
| 2014-02-06 04:30:00 | AAPL | Stock | 18.2407 | 18.2679 | 18.2407 | 18.2679 | 14280.0 |
| 2014-02-06 05:00:00 | AAPL | Stock | 18.2857 | 18.2914 | 18.2754 | 18.2821 | 44800.0 |
| 2014-02-06 06:00:00 | AAPL | Stock | 18.2718 | 18.2732 | 18.2129 | 18.2407 | 74536.0 |
| 2014-02-06 06:30:00 | AAPL | Stock | 18.2514 | 18.2514 | 18.2321 | 18.2321 | 28000.0 |
| 2014-02-06 07:00:00 | AAPL | Stock | 18.2321 | 18.2732 | 18.2268 | 18.2268 | 186508.0 |
| 2014-02-06 07:30:00 | AAPL | Stock | 18.2179 | 18.2196 | 18.1825 | 18.2071 | 249452.0 |
| 2014-02-06 08:00:00 | AAPL | Stock | 18.1982 | 18.2657 | 18.1846 | 18.2179 | 698628.0 |
| 2014-02-06 08:30:00 | AAPL | Stock | 18.2179 | 18.2268 | 18.1989 | 18.2229 | 910588.0 |
| 2014-02-06 09:00:00 | AAPL | Stock | 18.2239 | 18.2357 | 18.2068 | 18.2189 | 898744.0 |
| 2014-02-06 09:30:00 | AAPL | Stock | 18.2164 | 18.2996 | 18.1525 | 18.165 | 39483752.0 |
| 2014-02-06 10:00:00 | AAPL | Stock | 18.165 | 18.2654 | 18.1361 | 18.2639 | 24001824.0 |
| 2014-02-06 10:30:00 | AAPL | Stock | 18.2629 | 18.3393 | 18.255 | 18.3175 | 21071512.0 |
| 2014-02-06 11:00:00 | AAPL | Stock | 18.3175 | 18.3243 | 18.2786 | 18.3112 | 10696224.0 |
| 2014-02-06 11:30:00 | AAPL | Stock | 18.3129 | 18.3321 | 18.2864 | 18.2955 | 10284540.0 |
| 2014-02-06 12:00:00 | AAPL | Stock | 18.2954 | 18.3196 | 18.2832 | 18.2925 | 7822276.0 |
| 2014-02-06 12:30:00 | AAPL | Stock | 18.2925 | 18.3104 | 18.2682 | 18.2932 | 7143192.0 |
| 2014-02-06 13:00:00 | AAPL | Stock | 18.2966 | 18.3111 | 18.2929 | 18.3021 | 5792696.0 |
| 2014-02-06 13:30:00 | AAPL | Stock | 18.3036 | 18.3286 | 18.303 | 18.3186 | 7545524.0 |
| 2014-02-06 14:00:00 | AAPL | Stock | 18.3193 | 18.3393 | 18.3139 | 18.3316 | 9873332.0 |
| 2014-02-06 14:30:00 | AAPL | Stock | 18.3346 | 18.3386 | 18.3082 | 18.33 | 8407112.0 |
| 2014-02-06 15:00:00 | AAPL | Stock | 18.3289 | 18.3321 | 18.2871 | 18.3079 | 12320504.0 |
| 2014-02-06 15:30:00 | AAPL | Stock | 18.3079 | 18.3304 | 18.2993 | 18.3021 | 29366680.0 |
| 2014-02-06 16:00:00 | AAPL | Stock | 18.3039 | 18.3268 | 18.2757 | 18.2984 | 9520084.0 |
| 2014-02-06 16:30:00 | AAPL | Stock | 18.2854 | 18.3029 | 18.2789 | 18.2893 | 61768.0 |
| 2014-02-06 17:00:00 | AAPL | Stock | 18.2768 | 18.3039 | 18.275 | 18.2857 | 168308.0 |
| 2014-02-06 17:30:00 | AAPL | Stock | 18.2857 | 18.2857 | 18.2682 | 18.2857 | 100716.0 |
| 2014-02-06 18:00:00 | AAPL | Stock | 18.2825 | 18.2825 | 18.2796 | 18.2796 | 19040.0 |
| 2014-02-06 18:30:00 | AAPL | Stock | 18.2836 | 18.2857 | 18.2818 | 18.2818 | 9352.0 |
| 2014-02-06 19:00:00 | AAPL | Stock | 18.2857 | 18.2857 | 18.2836 | 18.2836 | 12488.0 |
| 2014-02-06 19:30:00 | AAPL | Stock | 18.2818 | 18.2925 | 18.2796 | 18.2825 | 90804.0 |
| 2014-02-06 05:30:00 | MSFT | Stock | 36.05 | 36.05 | 36.05 | 36.05 | 600.0 |
| 2014-02-06 06:00:00 | MSFT | Stock | 36.02 | 36.05 | 36.02 | 36.05 | 1400.0 |
| 2014-02-06 07:00:00 | MSFT | Stock | 36.05 | 36.6 | 36.0 | 36.0 | 11550.0 |
| 2014-02-06 07:30:00 | MSFT | Stock | 36.0 | 36.01 | 35.93 | 35.93 | 2300.0 |
| 2014-02-06 08:00:00 | MSFT | Stock | 35.98 | 36.06 | 35.95 | 36.0 | 4422.0 |
| 2014-02-06 08:30:00 | MSFT | Stock | 35.99 | 36.02 | 35.95 | 35.96 | 8532.0 |
| 2014-02-06 09:00:00 | MSFT | Stock | 35.9 | 35.99 | 35.79 | 35.83 | 58175.0 |
| 2014-02-06 09:30:00 | MSFT | Stock | 35.81 | 36.05 | 35.69 | 35.925 | 5594394.0 |
| 2014-02-06 10:00:00 | MSFT | Stock | 35.929 | 36.17 | 35.9 | 36.15 | 2975381.0 |
| 2014-02-06 10:30:00 | MSFT | Stock | 36.16 | 36.24 | 36.08 | 36.19 | 1954079.0 |
| 2014-02-06 11:00:00 | MSFT | Stock | 36.19 | 36.25 | 36.14 | 36.19 | 1659499.0 |
| 2014-02-06 11:30:00 | MSFT | Stock | 36.2 | 36.23 | 36.09 | 36.12 | 1818615.0 |
| 2014-02-06 12:00:00 | MSFT | Stock | 36.12 | 36.16 | 36.1 | 36.13 | 903601.0 |
| 2014-02-06 12:30:00 | MSFT | Stock | 36.12 | 36.14 | 36.07 | 36.074 | 1582995.0 |
| 2014-02-06 13:00:00 | MSFT | Stock | 36.08 | 36.1 | 35.97 | 35.98 | 1911731.0 |
| 2014-02-06 13:30:00 | MSFT | Stock | 35.98 | 36.12 | 35.97 | 36.12 | 1733483.0 |
| 2014-02-06 14:00:00 | MSFT | Stock | 36.114 | 36.24 | 36.09 | 36.2 | 1860921.0 |
| 2014-02-06 14:30:00 | MSFT | Stock | 36.21 | 36.24 | 36.19 | 36.22 | 3206667.0 |
| 2014-02-06 15:00:00 | MSFT | Stock | 36.225 | 36.24 | 36.17 | 36.2 | 1828047.0 |
> showing 50 of 82,653 rows — these rows as CSV