PREVIEW / stock_5min / 2013-03-13
file: by_date/stock_5min/2013/2013-03-13.parquet size: 4.9 MB rows: 326,627 symbols: 3,465
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-13 05:20:00 | AAPL | Stock | 15.2786 | 15.2786 | 15.2786 | 15.2786 | 2800.0 |
| 2013-03-13 05:25:00 | AAPL | Stock | 15.2786 | 15.2786 | 15.2786 | 15.2786 | 19404.0 |
| 2013-03-13 06:20:00 | AAPL | Stock | 15.2679 | 15.2679 | 15.2571 | 15.2571 | 5600.0 |
| 2013-03-13 06:35:00 | AAPL | Stock | 15.2489 | 15.2489 | 15.2321 | 15.2321 | 9800.0 |
| 2013-03-13 07:00:00 | AAPL | Stock | 15.2679 | 15.2679 | 15.2679 | 15.2679 | 24976.0 |
| 2013-03-13 07:05:00 | AAPL | Stock | 15.2589 | 15.2679 | 15.2543 | 15.2654 | 59332.0 |
| 2013-03-13 07:10:00 | AAPL | Stock | 15.25 | 15.25 | 15.25 | 15.25 | 7000.0 |
| 2013-03-13 07:15:00 | AAPL | Stock | 15.2454 | 15.25 | 15.2454 | 15.25 | 6300.0 |
| 2013-03-13 07:30:00 | AAPL | Stock | 15.2475 | 15.2475 | 15.2357 | 15.2357 | 32424.0 |
| 2013-03-13 07:35:00 | AAPL | Stock | 15.2404 | 15.2461 | 15.2404 | 15.2461 | 8400.0 |
| 2013-03-13 07:40:00 | AAPL | Stock | 15.2461 | 15.2461 | 15.2461 | 15.2461 | 2800.0 |
| 2013-03-13 07:45:00 | AAPL | Stock | 15.2457 | 15.2521 | 15.2457 | 15.2521 | 31892.0 |
| 2013-03-13 07:55:00 | AAPL | Stock | 15.2543 | 15.2543 | 15.2539 | 15.2539 | 14000.0 |
| 2013-03-13 08:00:00 | AAPL | Stock | 15.2411 | 15.2639 | 15.2321 | 15.2396 | 243992.0 |
| 2013-03-13 08:05:00 | AAPL | Stock | 15.2382 | 15.2857 | 15.2357 | 15.2857 | 82236.0 |
| 2013-03-13 08:10:00 | AAPL | Stock | 15.2357 | 15.2593 | 15.2321 | 15.2593 | 86884.0 |
| 2013-03-13 08:15:00 | AAPL | Stock | 15.2568 | 15.2589 | 15.2504 | 15.2564 | 37548.0 |
| 2013-03-13 08:20:00 | AAPL | Stock | 15.2561 | 15.2625 | 15.25 | 15.2507 | 92680.0 |
| 2013-03-13 08:25:00 | AAPL | Stock | 15.2518 | 15.2661 | 15.2518 | 15.2661 | 67816.0 |
| 2013-03-13 08:30:00 | AAPL | Stock | 15.2643 | 15.2839 | 15.2614 | 15.2836 | 363972.0 |
| 2013-03-13 08:35:00 | AAPL | Stock | 15.2839 | 15.2946 | 15.2725 | 15.2725 | 420056.0 |
| 2013-03-13 08:40:00 | AAPL | Stock | 15.2729 | 15.2746 | 15.2486 | 15.2518 | 313432.0 |
| 2013-03-13 08:45:00 | AAPL | Stock | 15.2514 | 15.275 | 15.2468 | 15.275 | 146776.0 |
| 2013-03-13 08:50:00 | AAPL | Stock | 15.2811 | 15.2811 | 15.2764 | 15.2811 | 54600.0 |
| 2013-03-13 08:55:00 | AAPL | Stock | 15.2818 | 15.2818 | 15.2582 | 15.2707 | 149576.0 |
| 2013-03-13 09:00:00 | AAPL | Stock | 15.27 | 15.2736 | 15.2654 | 15.2682 | 113120.0 |
| 2013-03-13 09:05:00 | AAPL | Stock | 15.2736 | 15.2821 | 15.2679 | 15.2736 | 33656.0 |
| 2013-03-13 09:10:00 | AAPL | Stock | 15.2714 | 15.2818 | 15.2714 | 15.2814 | 84560.0 |
| 2013-03-13 09:15:00 | AAPL | Stock | 15.2804 | 15.2857 | 15.2754 | 15.2843 | 91224.0 |
| 2013-03-13 09:20:00 | AAPL | Stock | 15.2857 | 15.2957 | 15.2857 | 15.2957 | 76720.0 |
| 2013-03-13 09:25:00 | AAPL | Stock | 15.2961 | 15.3036 | 15.2868 | 15.2986 | 137396.0 |
| 2013-03-13 09:30:00 | AAPL | Stock | 15.3018 | 15.3125 | 15.2346 | 15.2847 | 14808024.0 |
| 2013-03-13 09:35:00 | AAPL | Stock | 15.28 | 15.2986 | 15.2254 | 15.2274 | 9388008.0 |
| 2013-03-13 09:40:00 | AAPL | Stock | 15.2289 | 15.2354 | 15.1986 | 15.2186 | 9405396.0 |
| 2013-03-13 09:45:00 | AAPL | Stock | 15.2189 | 15.2289 | 15.1914 | 15.2207 | 6897968.0 |
| 2013-03-13 09:50:00 | AAPL | Stock | 15.2159 | 15.25 | 15.2089 | 15.2261 | 6078240.0 |
| 2013-03-13 09:55:00 | AAPL | Stock | 15.2218 | 15.2811 | 15.2107 | 15.2673 | 5744732.0 |
| 2013-03-13 10:00:00 | AAPL | Stock | 15.2674 | 15.2689 | 15.215 | 15.2425 | 4234636.0 |
| 2013-03-13 10:05:00 | AAPL | Stock | 15.2442 | 15.2804 | 15.2407 | 15.2536 | 5992980.0 |
| 2013-03-13 10:10:00 | AAPL | Stock | 15.2575 | 15.4036 | 15.2464 | 15.3711 | 21032340.0 |
| 2013-03-13 10:15:00 | AAPL | Stock | 15.3714 | 15.3996 | 15.3214 | 15.3711 | 11501644.0 |
| 2013-03-13 10:20:00 | AAPL | Stock | 15.3729 | 15.4089 | 15.3396 | 15.3571 | 9322824.0 |
| 2013-03-13 10:25:00 | AAPL | Stock | 15.3573 | 15.3611 | 15.3096 | 15.3379 | 6794312.0 |
| 2013-03-13 10:30:00 | AAPL | Stock | 15.3354 | 15.3682 | 15.3286 | 15.3539 | 3161900.0 |
| 2013-03-13 10:35:00 | AAPL | Stock | 15.3529 | 15.4307 | 15.3479 | 15.417 | 7995624.0 |
| 2013-03-13 10:40:00 | AAPL | Stock | 15.4171 | 15.4321 | 15.3896 | 15.4318 | 6003676.0 |
| 2013-03-13 10:45:00 | AAPL | Stock | 15.4304 | 15.4357 | 15.3932 | 15.4125 | 4366152.0 |
| 2013-03-13 10:50:00 | AAPL | Stock | 15.4093 | 15.4236 | 15.3932 | 15.4107 | 5331200.0 |
| 2013-03-13 10:55:00 | AAPL | Stock | 15.4139 | 15.4239 | 15.3936 | 15.4171 | 3721760.0 |
| 2013-03-13 11:00:00 | AAPL | Stock | 15.4179 | 15.4286 | 15.3989 | 15.4218 | 5644436.0 |
> showing 50 of 326,627 rows — these rows as CSV