PREVIEW / stock_5min / 2013-08-01
file: by_date/stock_5min/2013/2013-08-01.parquet size: 5.3 MB rows: 347,282 symbols: 3,540
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 |
|---|---|---|---|---|---|---|---|
| 2013-08-01 04:00:00 | AAPL | Stock | 16.1786 | 16.1786 | 16.1786 | 16.1786 | 2800.0 |
| 2013-08-01 05:10:00 | AAPL | Stock | 16.2196 | 16.2196 | 16.2196 | 16.2196 | 2800.0 |
| 2013-08-01 05:30:00 | AAPL | Stock | 16.25 | 16.25 | 16.25 | 16.25 | 2800.0 |
| 2013-08-01 06:35:00 | AAPL | Stock | 16.25 | 16.25 | 16.25 | 16.25 | 2800.0 |
| 2013-08-01 07:00:00 | AAPL | Stock | 16.25 | 16.25 | 16.25 | 16.25 | 2800.0 |
| 2013-08-01 07:05:00 | AAPL | Stock | 16.25 | 16.25 | 16.25 | 16.25 | 19600.0 |
| 2013-08-01 07:10:00 | AAPL | Stock | 16.2479 | 16.2479 | 16.2411 | 16.2411 | 5600.0 |
| 2013-08-01 07:15:00 | AAPL | Stock | 16.2411 | 16.2411 | 16.2411 | 16.2411 | 2800.0 |
| 2013-08-01 07:20:00 | AAPL | Stock | 16.2461 | 16.25 | 16.2461 | 16.2479 | 81200.0 |
| 2013-08-01 07:25:00 | AAPL | Stock | 16.2589 | 16.3036 | 16.2571 | 16.2964 | 57456.0 |
| 2013-08-01 07:30:00 | AAPL | Stock | 16.3143 | 16.3496 | 16.2964 | 16.3496 | 55440.0 |
| 2013-08-01 07:35:00 | AAPL | Stock | 16.3554 | 16.3607 | 16.3193 | 16.3204 | 153972.0 |
| 2013-08-01 07:40:00 | AAPL | Stock | 16.3125 | 16.3204 | 16.3125 | 16.3204 | 11200.0 |
| 2013-08-01 07:45:00 | AAPL | Stock | 16.3211 | 16.3332 | 16.3211 | 16.33 | 36680.0 |
| 2013-08-01 07:50:00 | AAPL | Stock | 16.3304 | 16.3304 | 16.3211 | 16.325 | 23940.0 |
| 2013-08-01 07:55:00 | AAPL | Stock | 16.325 | 16.3282 | 16.3207 | 16.3207 | 11200.0 |
| 2013-08-01 08:00:00 | AAPL | Stock | 16.3214 | 16.3214 | 16.1429 | 16.2907 | 288624.0 |
| 2013-08-01 08:05:00 | AAPL | Stock | 16.2861 | 16.2954 | 16.2757 | 16.2843 | 290668.0 |
| 2013-08-01 08:10:00 | AAPL | Stock | 16.2839 | 16.2857 | 16.275 | 16.2768 | 79716.0 |
| 2013-08-01 08:15:00 | AAPL | Stock | 16.2832 | 16.2839 | 16.2732 | 16.2839 | 96124.0 |
| 2013-08-01 08:20:00 | AAPL | Stock | 16.2854 | 16.3036 | 16.2821 | 16.2907 | 173516.0 |
| 2013-08-01 08:25:00 | AAPL | Stock | 16.3032 | 16.3036 | 16.2918 | 16.2989 | 253484.0 |
| 2013-08-01 08:30:00 | AAPL | Stock | 16.295 | 16.3036 | 16.295 | 16.2982 | 354144.0 |
| 2013-08-01 08:35:00 | AAPL | Stock | 16.2964 | 16.3014 | 16.2964 | 16.3 | 76720.0 |
| 2013-08-01 08:40:00 | AAPL | Stock | 16.3014 | 16.3036 | 16.2971 | 16.3021 | 353640.0 |
| 2013-08-01 08:45:00 | AAPL | Stock | 16.3036 | 16.3036 | 16.2982 | 16.2982 | 27160.0 |
| 2013-08-01 08:50:00 | AAPL | Stock | 16.3029 | 16.3029 | 16.2882 | 16.2882 | 75600.0 |
| 2013-08-01 08:55:00 | AAPL | Stock | 16.2918 | 16.2918 | 16.2875 | 16.29 | 54180.0 |
| 2013-08-01 09:00:00 | AAPL | Stock | 16.2904 | 16.2904 | 16.2882 | 16.2882 | 10556.0 |
| 2013-08-01 09:05:00 | AAPL | Stock | 16.29 | 16.2946 | 16.2882 | 16.2939 | 97440.0 |
| 2013-08-01 09:10:00 | AAPL | Stock | 16.2943 | 16.2946 | 16.2875 | 16.2875 | 109592.0 |
| 2013-08-01 09:15:00 | AAPL | Stock | 16.2889 | 16.2946 | 16.2889 | 16.2946 | 190120.0 |
| 2013-08-01 09:20:00 | AAPL | Stock | 16.2946 | 16.2946 | 16.2886 | 16.2886 | 37688.0 |
| 2013-08-01 09:25:00 | AAPL | Stock | 16.2893 | 16.2911 | 16.2593 | 16.2593 | 233044.0 |
| 2013-08-01 09:30:00 | AAPL | Stock | 16.2769 | 16.3143 | 16.2593 | 16.29 | 12078808.0 |
| 2013-08-01 09:35:00 | AAPL | Stock | 16.2879 | 16.3075 | 16.2536 | 16.2564 | 6322120.0 |
| 2013-08-01 09:40:00 | AAPL | Stock | 16.2575 | 16.2743 | 16.2054 | 16.21 | 7488852.0 |
| 2013-08-01 09:45:00 | AAPL | Stock | 16.2068 | 16.2682 | 16.1879 | 16.2607 | 7999600.0 |
| 2013-08-01 09:50:00 | AAPL | Stock | 16.2607 | 16.2679 | 16.2331 | 16.2567 | 3410932.0 |
| 2013-08-01 09:55:00 | AAPL | Stock | 16.2557 | 16.2721 | 16.2268 | 16.2321 | 4542020.0 |
| 2013-08-01 10:00:00 | AAPL | Stock | 16.2321 | 16.2539 | 16.2314 | 16.245 | 2721516.0 |
| 2013-08-01 10:05:00 | AAPL | Stock | 16.245 | 16.2521 | 16.225 | 16.2462 | 6359724.0 |
| 2013-08-01 10:10:00 | AAPL | Stock | 16.2436 | 16.2536 | 16.2375 | 16.25 | 5196800.0 |
| 2013-08-01 10:15:00 | AAPL | Stock | 16.25 | 16.2614 | 16.235 | 16.2421 | 2787876.0 |
| 2013-08-01 10:20:00 | AAPL | Stock | 16.2422 | 16.2964 | 16.2411 | 16.2907 | 4730516.0 |
| 2013-08-01 10:25:00 | AAPL | Stock | 16.2929 | 16.3018 | 16.2636 | 16.2764 | 3736320.0 |
| 2013-08-01 10:30:00 | AAPL | Stock | 16.2775 | 16.2835 | 16.2429 | 16.2432 | 2669912.0 |
| 2013-08-01 10:35:00 | AAPL | Stock | 16.2436 | 16.2561 | 16.2321 | 16.2421 | 3284596.0 |
| 2013-08-01 10:40:00 | AAPL | Stock | 16.2446 | 16.2739 | 16.24 | 16.2636 | 2991884.0 |
| 2013-08-01 10:45:00 | AAPL | Stock | 16.265 | 16.2804 | 16.2579 | 16.2771 | 2504600.0 |
> showing 50 of 347,282 rows — these rows as CSV