PREVIEW / stock_5min / 2013-03-22
file: by_date/stock_5min/2013/2013-03-22.parquet size: 4.8 MB rows: 318,604 symbols: 3,461
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-03-22 04:00:00 | AAPL | Stock | 16.1804 | 16.1804 | 16.1804 | 16.1804 | 2800.0 |
| 2013-03-22 05:40:00 | AAPL | Stock | 16.2143 | 16.2143 | 16.2143 | 16.2143 | 2800.0 |
| 2013-03-22 07:00:00 | AAPL | Stock | 16.2207 | 16.2207 | 16.2054 | 16.2054 | 18200.0 |
| 2013-03-22 07:10:00 | AAPL | Stock | 16.2196 | 16.2196 | 16.2196 | 16.2196 | 3472.0 |
| 2013-03-22 07:15:00 | AAPL | Stock | 16.2214 | 16.2321 | 16.2214 | 16.2321 | 5600.0 |
| 2013-03-22 07:25:00 | AAPL | Stock | 16.2314 | 16.2321 | 16.2314 | 16.2321 | 6720.0 |
| 2013-03-22 07:30:00 | AAPL | Stock | 16.25 | 16.2679 | 16.25 | 16.2679 | 18480.0 |
| 2013-03-22 07:35:00 | AAPL | Stock | 16.2679 | 16.2679 | 16.2511 | 16.2582 | 45640.0 |
| 2013-03-22 07:40:00 | AAPL | Stock | 16.2561 | 16.2621 | 16.2325 | 16.2325 | 36400.0 |
| 2013-03-22 07:45:00 | AAPL | Stock | 16.2339 | 16.2429 | 16.2321 | 16.2354 | 59472.0 |
| 2013-03-22 07:50:00 | AAPL | Stock | 16.2254 | 16.2264 | 16.2218 | 16.225 | 19600.0 |
| 2013-03-22 07:55:00 | AAPL | Stock | 16.2304 | 16.2304 | 16.2304 | 16.2304 | 2800.0 |
| 2013-03-22 08:00:00 | AAPL | Stock | 16.2296 | 16.2393 | 16.2189 | 16.2279 | 133700.0 |
| 2013-03-22 08:05:00 | AAPL | Stock | 16.2304 | 16.2375 | 16.2214 | 16.2246 | 62020.0 |
| 2013-03-22 08:10:00 | AAPL | Stock | 16.2225 | 16.2225 | 16.2225 | 16.2225 | 11200.0 |
| 2013-03-22 08:15:00 | AAPL | Stock | 16.225 | 16.25 | 16.225 | 16.25 | 68712.0 |
| 2013-03-22 08:20:00 | AAPL | Stock | 16.2343 | 16.2361 | 16.2139 | 16.2143 | 122220.0 |
| 2013-03-22 08:25:00 | AAPL | Stock | 16.2321 | 16.2321 | 16.2321 | 16.2321 | 2800.0 |
| 2013-03-22 08:30:00 | AAPL | Stock | 16.2318 | 16.2318 | 16.2293 | 16.2304 | 19600.0 |
| 2013-03-22 08:35:00 | AAPL | Stock | 16.2304 | 16.2357 | 16.2304 | 16.2357 | 30800.0 |
| 2013-03-22 08:40:00 | AAPL | Stock | 16.2343 | 16.235 | 16.2232 | 16.2293 | 56000.0 |
| 2013-03-22 08:45:00 | AAPL | Stock | 16.2293 | 16.235 | 16.2189 | 16.2189 | 122836.0 |
| 2013-03-22 08:50:00 | AAPL | Stock | 16.22 | 16.2254 | 16.215 | 16.2207 | 50288.0 |
| 2013-03-22 08:55:00 | AAPL | Stock | 16.2214 | 16.2225 | 16.2157 | 16.2214 | 33600.0 |
| 2013-03-22 09:00:00 | AAPL | Stock | 16.2246 | 16.2311 | 16.2214 | 16.2214 | 49504.0 |
| 2013-03-22 09:05:00 | AAPL | Stock | 16.2157 | 16.2161 | 16.2143 | 16.2143 | 100044.0 |
| 2013-03-22 09:10:00 | AAPL | Stock | 16.2154 | 16.2218 | 16.2118 | 16.2214 | 56616.0 |
| 2013-03-22 09:15:00 | AAPL | Stock | 16.2246 | 16.2257 | 16.2168 | 16.2168 | 98308.0 |
| 2013-03-22 09:20:00 | AAPL | Stock | 16.2246 | 16.2321 | 16.2207 | 16.2321 | 75320.0 |
| 2013-03-22 09:25:00 | AAPL | Stock | 16.2314 | 16.2393 | 16.2304 | 16.2357 | 133112.0 |
| 2013-03-22 09:30:00 | AAPL | Stock | 16.2282 | 16.27 | 16.1825 | 16.2493 | 14003948.0 |
| 2013-03-22 09:35:00 | AAPL | Stock | 16.2527 | 16.2607 | 16.2182 | 16.22 | 6179068.0 |
| 2013-03-22 09:40:00 | AAPL | Stock | 16.2189 | 16.2339 | 16.1925 | 16.2339 | 6466068.0 |
| 2013-03-22 09:45:00 | AAPL | Stock | 16.2296 | 16.2939 | 16.2296 | 16.29 | 9961476.0 |
| 2013-03-22 09:50:00 | AAPL | Stock | 16.293 | 16.2961 | 16.2589 | 16.2843 | 6541276.0 |
| 2013-03-22 09:55:00 | AAPL | Stock | 16.285 | 16.2857 | 16.2536 | 16.2764 | 6152076.0 |
| 2013-03-22 10:00:00 | AAPL | Stock | 16.2754 | 16.3143 | 16.275 | 16.2894 | 7798308.0 |
| 2013-03-22 10:05:00 | AAPL | Stock | 16.2907 | 16.3186 | 16.2861 | 16.315 | 4579652.0 |
| 2013-03-22 10:10:00 | AAPL | Stock | 16.3125 | 16.3239 | 16.2986 | 16.3175 | 6776448.0 |
| 2013-03-22 10:15:00 | AAPL | Stock | 16.3189 | 16.3268 | 16.2904 | 16.2996 | 6882568.0 |
| 2013-03-22 10:20:00 | AAPL | Stock | 16.3018 | 16.3168 | 16.2946 | 16.2982 | 3191804.0 |
| 2013-03-22 10:25:00 | AAPL | Stock | 16.2979 | 16.3043 | 16.2646 | 16.2726 | 5075504.0 |
| 2013-03-22 10:30:00 | AAPL | Stock | 16.2714 | 16.3068 | 16.1786 | 16.3007 | 5365920.0 |
| 2013-03-22 10:35:00 | AAPL | Stock | 16.2986 | 16.31 | 16.2825 | 16.2979 | 2439416.0 |
| 2013-03-22 10:40:00 | AAPL | Stock | 16.2989 | 16.3114 | 16.2911 | 16.3111 | 2165380.0 |
| 2013-03-22 10:45:00 | AAPL | Stock | 16.3089 | 16.3179 | 16.2921 | 16.2989 | 2990428.0 |
| 2013-03-22 10:50:00 | AAPL | Stock | 16.2979 | 16.2982 | 16.2736 | 16.2775 | 3520048.0 |
| 2013-03-22 10:55:00 | AAPL | Stock | 16.2766 | 16.2889 | 16.265 | 16.2854 | 2633372.0 |
| 2013-03-22 11:00:00 | AAPL | Stock | 16.2839 | 16.3004 | 16.2811 | 16.2882 | 2908276.0 |
| 2013-03-22 11:05:00 | AAPL | Stock | 16.2879 | 16.2914 | 16.2797 | 16.285 | 1568476.0 |
> showing 50 of 318,604 rows — these rows as CSV