PREVIEW / stock_5min / 2014-04-29
file: by_date/stock_5min/2014/2014-04-29.parquet size: 5.4 MB rows: 356,689 symbols: 3,553
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-04-29 04:00:00 | AAPL | Stock | 21.2857 | 21.2857 | 21.2857 | 21.2857 | 5600.0 |
| 2014-04-29 04:05:00 | AAPL | Stock | 21.2536 | 21.2536 | 21.2536 | 21.2536 | 2800.0 |
| 2014-04-29 04:30:00 | AAPL | Stock | 21.2621 | 21.2621 | 21.2621 | 21.2621 | 3780.0 |
| 2014-04-29 05:20:00 | AAPL | Stock | 21.2668 | 21.2668 | 21.25 | 21.25 | 5600.0 |
| 2014-04-29 05:40:00 | AAPL | Stock | 21.2668 | 21.2668 | 21.2668 | 21.2668 | 11200.0 |
| 2014-04-29 05:55:00 | AAPL | Stock | 21.2821 | 21.2821 | 21.2821 | 21.2821 | 5600.0 |
| 2014-04-29 06:00:00 | AAPL | Stock | 21.2857 | 21.2857 | 21.2857 | 21.2857 | 2800.0 |
| 2014-04-29 06:10:00 | AAPL | Stock | 21.2964 | 21.2964 | 21.2964 | 21.2964 | 2800.0 |
| 2014-04-29 06:20:00 | AAPL | Stock | 21.2964 | 21.2964 | 21.2957 | 21.2957 | 17052.0 |
| 2014-04-29 06:35:00 | AAPL | Stock | 21.2964 | 21.2964 | 21.2964 | 21.2964 | 2800.0 |
| 2014-04-29 06:45:00 | AAPL | Stock | 21.2821 | 21.2821 | 21.2821 | 21.2821 | 26600.0 |
| 2014-04-29 06:50:00 | AAPL | Stock | 21.3025 | 21.3025 | 21.3025 | 21.3025 | 2800.0 |
| 2014-04-29 07:00:00 | AAPL | Stock | 21.2732 | 21.3004 | 21.2732 | 21.3004 | 28952.0 |
| 2014-04-29 07:05:00 | AAPL | Stock | 21.2964 | 21.3064 | 21.2964 | 21.3 | 21812.0 |
| 2014-04-29 07:10:00 | AAPL | Stock | 21.2964 | 21.3064 | 21.2961 | 21.2964 | 33600.0 |
| 2014-04-29 07:15:00 | AAPL | Stock | 21.3004 | 21.3004 | 21.2964 | 21.2964 | 8400.0 |
| 2014-04-29 07:20:00 | AAPL | Stock | 21.2882 | 21.2882 | 21.2857 | 21.2857 | 14840.0 |
| 2014-04-29 07:25:00 | AAPL | Stock | 21.2804 | 21.2857 | 21.2804 | 21.2857 | 8400.0 |
| 2014-04-29 07:30:00 | AAPL | Stock | 21.2779 | 21.2857 | 21.2779 | 21.2857 | 33600.0 |
| 2014-04-29 07:35:00 | AAPL | Stock | 21.2857 | 21.2857 | 21.2639 | 21.2732 | 157976.0 |
| 2014-04-29 07:40:00 | AAPL | Stock | 21.2764 | 21.3143 | 21.2764 | 21.3136 | 123256.0 |
| 2014-04-29 07:45:00 | AAPL | Stock | 21.3143 | 21.3386 | 21.2875 | 21.2875 | 267708.0 |
| 2014-04-29 07:50:00 | AAPL | Stock | 21.3061 | 21.3157 | 21.3036 | 21.3036 | 51800.0 |
| 2014-04-29 07:55:00 | AAPL | Stock | 21.3036 | 21.3175 | 21.295 | 21.3175 | 86520.0 |
| 2014-04-29 08:00:00 | AAPL | Stock | 21.3075 | 21.3139 | 21.2714 | 21.2718 | 576744.0 |
| 2014-04-29 08:05:00 | AAPL | Stock | 21.2714 | 21.2879 | 21.2714 | 21.2879 | 226604.0 |
| 2014-04-29 08:10:00 | AAPL | Stock | 21.2957 | 21.3143 | 21.2914 | 21.3143 | 89180.0 |
| 2014-04-29 08:15:00 | AAPL | Stock | 21.3086 | 21.3214 | 21.2964 | 21.2964 | 317940.0 |
| 2014-04-29 08:20:00 | AAPL | Stock | 21.3007 | 21.3029 | 21.2868 | 21.2907 | 39480.0 |
| 2014-04-29 08:25:00 | AAPL | Stock | 21.2979 | 21.3071 | 21.2864 | 21.2929 | 166236.0 |
| 2014-04-29 08:30:00 | AAPL | Stock | 21.2964 | 21.2986 | 21.2929 | 21.2968 | 52136.0 |
| 2014-04-29 08:35:00 | AAPL | Stock | 21.2954 | 21.2954 | 21.27 | 21.2857 | 316736.0 |
| 2014-04-29 08:40:00 | AAPL | Stock | 21.2836 | 21.2911 | 21.2836 | 21.2857 | 44660.0 |
| 2014-04-29 08:45:00 | AAPL | Stock | 21.2871 | 21.2946 | 21.2646 | 21.2657 | 174496.0 |
| 2014-04-29 08:50:00 | AAPL | Stock | 21.2718 | 21.2718 | 21.2543 | 21.2604 | 167188.0 |
| 2014-04-29 08:55:00 | AAPL | Stock | 21.2546 | 21.2668 | 21.2536 | 21.26 | 77308.0 |
| 2014-04-29 09:00:00 | AAPL | Stock | 21.2604 | 21.2604 | 21.2175 | 21.2336 | 3071348.0 |
| 2014-04-29 09:05:00 | AAPL | Stock | 21.2339 | 21.2504 | 21.2311 | 21.2504 | 60508.0 |
| 2014-04-29 09:10:00 | AAPL | Stock | 21.2418 | 21.25 | 21.2411 | 21.2454 | 16800.0 |
| 2014-04-29 09:15:00 | AAPL | Stock | 21.2411 | 21.2536 | 21.2411 | 21.2536 | 33600.0 |
| 2014-04-29 09:20:00 | AAPL | Stock | 21.2536 | 21.2761 | 21.2536 | 21.2696 | 30800.0 |
| 2014-04-29 09:25:00 | AAPL | Stock | 21.2768 | 21.2768 | 21.2086 | 21.2086 | 578284.0 |
| 2014-04-29 09:30:00 | AAPL | Stock | 21.205 | 21.285 | 21.1521 | 21.1959 | 21943180.0 |
| 2014-04-29 09:35:00 | AAPL | Stock | 21.2046 | 21.2179 | 21.0539 | 21.0793 | 16115456.0 |
| 2014-04-29 09:40:00 | AAPL | Stock | 21.0836 | 21.1589 | 21.0786 | 21.1525 | 7631064.0 |
| 2014-04-29 09:45:00 | AAPL | Stock | 21.1536 | 21.2125 | 21.125 | 21.1425 | 8932308.0 |
| 2014-04-29 09:50:00 | AAPL | Stock | 21.1425 | 21.1786 | 21.1264 | 21.1621 | 4687928.0 |
| 2014-04-29 09:55:00 | AAPL | Stock | 21.1625 | 21.1786 | 21.1011 | 21.1189 | 6735736.0 |
| 2014-04-29 10:00:00 | AAPL | Stock | 21.1132 | 21.1357 | 21.0625 | 21.1127 | 6886656.0 |
| 2014-04-29 10:05:00 | AAPL | Stock | 21.1166 | 21.1425 | 21.0932 | 21.1298 | 4936176.0 |
> showing 50 of 356,689 rows — these rows as CSV