PREVIEW / stock_5min / 2013-07-22
file: by_date/stock_5min/2013/2013-07-22.parquet size: 5.1 MB rows: 340,462 symbols: 3,511
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-07-22 05:10:00 | AAPL | Stock | 15.2039 | 15.2039 | 15.2039 | 15.2039 | 2800.0 |
| 2013-07-22 05:50:00 | AAPL | Stock | 15.2086 | 15.2086 | 15.2086 | 15.2086 | 2800.0 |
| 2013-07-22 06:40:00 | AAPL | Stock | 15.2093 | 15.2093 | 15.2089 | 15.2089 | 11900.0 |
| 2013-07-22 06:50:00 | AAPL | Stock | 15.2032 | 15.2082 | 15.2032 | 15.2082 | 14000.0 |
| 2013-07-22 07:00:00 | AAPL | Stock | 15.1893 | 15.1893 | 15.1893 | 15.1893 | 12880.0 |
| 2013-07-22 07:15:00 | AAPL | Stock | 15.2143 | 15.2143 | 15.2143 | 15.2143 | 2800.0 |
| 2013-07-22 07:20:00 | AAPL | Stock | 15.2143 | 15.2143 | 15.1964 | 15.1964 | 11200.0 |
| 2013-07-22 07:35:00 | AAPL | Stock | 15.2086 | 15.2196 | 15.2086 | 15.2196 | 38080.0 |
| 2013-07-22 07:40:00 | AAPL | Stock | 15.2207 | 15.25 | 15.2207 | 15.25 | 64120.0 |
| 2013-07-22 07:45:00 | AAPL | Stock | 15.2514 | 15.27 | 15.2514 | 15.27 | 28000.0 |
| 2013-07-22 07:50:00 | AAPL | Stock | 15.2657 | 15.2657 | 15.2571 | 15.2571 | 33600.0 |
| 2013-07-22 07:55:00 | AAPL | Stock | 15.2514 | 15.2607 | 15.2482 | 15.2582 | 168196.0 |
| 2013-07-22 08:00:00 | AAPL | Stock | 15.2468 | 15.2607 | 15.2143 | 15.2386 | 166516.0 |
| 2013-07-22 08:05:00 | AAPL | Stock | 15.2361 | 15.2361 | 15.2186 | 15.2186 | 187320.0 |
| 2013-07-22 08:10:00 | AAPL | Stock | 15.2232 | 15.2318 | 15.2182 | 15.2318 | 134988.0 |
| 2013-07-22 08:15:00 | AAPL | Stock | 15.2321 | 15.2393 | 15.23 | 15.2357 | 30800.0 |
| 2013-07-22 08:20:00 | AAPL | Stock | 15.2393 | 15.2482 | 15.2321 | 15.2354 | 159600.0 |
| 2013-07-22 08:25:00 | AAPL | Stock | 15.2286 | 15.2311 | 15.2232 | 15.2236 | 87500.0 |
| 2013-07-22 08:30:00 | AAPL | Stock | 15.2307 | 15.2329 | 15.2232 | 15.2268 | 176736.0 |
| 2013-07-22 08:35:00 | AAPL | Stock | 15.2268 | 15.2339 | 15.2232 | 15.2318 | 55440.0 |
| 2013-07-22 08:40:00 | AAPL | Stock | 15.2286 | 15.2286 | 15.2286 | 15.2286 | 2968.0 |
| 2013-07-22 08:45:00 | AAPL | Stock | 15.2282 | 15.2429 | 15.2271 | 15.2429 | 167328.0 |
| 2013-07-22 08:50:00 | AAPL | Stock | 15.2464 | 15.2482 | 15.2464 | 15.2471 | 23240.0 |
| 2013-07-22 08:55:00 | AAPL | Stock | 15.2471 | 15.2482 | 15.2446 | 15.2471 | 66920.0 |
| 2013-07-22 09:00:00 | AAPL | Stock | 15.2446 | 15.2468 | 15.2436 | 15.2436 | 47600.0 |
| 2013-07-22 09:05:00 | AAPL | Stock | 15.2439 | 15.25 | 15.2439 | 15.2482 | 153804.0 |
| 2013-07-22 09:10:00 | AAPL | Stock | 15.2464 | 15.25 | 15.2329 | 15.2336 | 133532.0 |
| 2013-07-22 09:15:00 | AAPL | Stock | 15.2336 | 15.25 | 15.2336 | 15.25 | 54936.0 |
| 2013-07-22 09:20:00 | AAPL | Stock | 15.2536 | 15.2589 | 15.2461 | 15.2536 | 75040.0 |
| 2013-07-22 09:25:00 | AAPL | Stock | 15.2393 | 15.3571 | 15.2393 | 15.3389 | 3350816.0 |
| 2013-07-22 09:30:00 | AAPL | Stock | 15.3318 | 15.3411 | 15.2396 | 15.313 | 23375772.0 |
| 2013-07-22 09:35:00 | AAPL | Stock | 15.3129 | 15.3482 | 15.2996 | 15.3104 | 7147336.0 |
| 2013-07-22 09:40:00 | AAPL | Stock | 15.3129 | 15.3339 | 15.2218 | 15.25 | 8338036.0 |
| 2013-07-22 09:45:00 | AAPL | Stock | 15.2487 | 15.2539 | 15.2179 | 15.2311 | 4783632.0 |
| 2013-07-22 09:50:00 | AAPL | Stock | 15.2368 | 15.25 | 15.1953 | 15.2429 | 5178096.0 |
| 2013-07-22 09:55:00 | AAPL | Stock | 15.2467 | 15.2538 | 15.2241 | 15.2443 | 2548980.0 |
| 2013-07-22 10:00:00 | AAPL | Stock | 15.2496 | 15.2782 | 15.2236 | 15.2439 | 4111884.0 |
| 2013-07-22 10:05:00 | AAPL | Stock | 15.245 | 15.2532 | 15.2175 | 15.2407 | 3080308.0 |
| 2013-07-22 10:10:00 | AAPL | Stock | 15.2432 | 15.2625 | 15.2371 | 15.2461 | 3182732.0 |
| 2013-07-22 10:15:00 | AAPL | Stock | 15.2489 | 15.2646 | 15.2415 | 15.258 | 3168564.0 |
| 2013-07-22 10:20:00 | AAPL | Stock | 15.2632 | 15.3286 | 15.2521 | 15.2911 | 5250084.0 |
| 2013-07-22 10:25:00 | AAPL | Stock | 15.2907 | 15.3157 | 15.2807 | 15.3054 | 2423932.0 |
| 2013-07-22 10:30:00 | AAPL | Stock | 15.3093 | 15.3286 | 15.2768 | 15.2821 | 3505712.0 |
| 2013-07-22 10:35:00 | AAPL | Stock | 15.2833 | 15.2957 | 15.2696 | 15.2807 | 2161572.0 |
| 2013-07-22 10:40:00 | AAPL | Stock | 15.2807 | 15.2929 | 15.2714 | 15.291 | 1607116.0 |
| 2013-07-22 10:45:00 | AAPL | Stock | 15.2929 | 15.2989 | 15.2811 | 15.2943 | 1355144.0 |
| 2013-07-22 10:50:00 | AAPL | Stock | 15.2943 | 15.2975 | 15.2746 | 15.285 | 3161368.0 |
| 2013-07-22 10:55:00 | AAPL | Stock | 15.2846 | 15.295 | 15.2771 | 15.2854 | 2522996.0 |
| 2013-07-22 11:00:00 | AAPL | Stock | 15.2843 | 15.2871 | 15.2614 | 15.2814 | 2605932.0 |
| 2013-07-22 11:05:00 | AAPL | Stock | 15.2818 | 15.2875 | 15.2679 | 15.2782 | 1132740.0 |
> showing 50 of 340,462 rows — these rows as CSV