PREVIEW / stock_5min / 2011-07-26
file: by_date/stock_5min/2011/2011-07-26.parquet size: 4.8 MB rows: 324,015 symbols: 3,521
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 |
|---|---|---|---|---|---|---|---|
| 2011-07-26 04:00:00 | AAPL | Stock | 14.2754 | 14.2754 | 14.2711 | 14.2711 | 5600.0 |
| 2011-07-26 04:05:00 | AAPL | Stock | 14.2707 | 14.2707 | 14.2707 | 14.2707 | 2800.0 |
| 2011-07-26 04:10:00 | AAPL | Stock | 14.2729 | 14.2729 | 14.2729 | 14.2729 | 2800.0 |
| 2011-07-26 04:20:00 | AAPL | Stock | 14.2643 | 14.2643 | 14.2643 | 14.2643 | 2800.0 |
| 2011-07-26 04:25:00 | AAPL | Stock | 14.2468 | 14.2486 | 14.2179 | 14.2179 | 16800.0 |
| 2011-07-26 04:35:00 | AAPL | Stock | 14.2386 | 14.2386 | 14.2386 | 14.2386 | 2800.0 |
| 2011-07-26 04:55:00 | AAPL | Stock | 14.2386 | 14.2414 | 14.2289 | 14.2411 | 19600.0 |
| 2011-07-26 05:00:00 | AAPL | Stock | 14.2382 | 14.2389 | 14.2382 | 14.2382 | 19600.0 |
| 2011-07-26 05:05:00 | AAPL | Stock | 14.2393 | 14.2393 | 14.2289 | 14.2289 | 5600.0 |
| 2011-07-26 05:10:00 | AAPL | Stock | 14.2293 | 14.2293 | 14.2293 | 14.2293 | 5600.0 |
| 2011-07-26 05:15:00 | AAPL | Stock | 14.2293 | 14.2293 | 14.2289 | 14.2289 | 7084.0 |
| 2011-07-26 05:55:00 | AAPL | Stock | 14.2321 | 14.2321 | 14.2321 | 14.2321 | 4452.0 |
| 2011-07-26 06:00:00 | AAPL | Stock | 14.2464 | 14.2464 | 14.2464 | 14.2464 | 4452.0 |
| 2011-07-26 06:20:00 | AAPL | Stock | 14.2482 | 14.25 | 14.2482 | 14.25 | 10052.0 |
| 2011-07-26 06:25:00 | AAPL | Stock | 14.25 | 14.2625 | 14.25 | 14.2614 | 33348.0 |
| 2011-07-26 06:55:00 | AAPL | Stock | 14.2446 | 14.2464 | 14.2446 | 14.2464 | 9800.0 |
| 2011-07-26 07:00:00 | AAPL | Stock | 14.2496 | 14.2643 | 14.2496 | 14.2589 | 63504.0 |
| 2011-07-26 07:05:00 | AAPL | Stock | 14.2607 | 14.2804 | 14.2589 | 14.2643 | 74480.0 |
| 2011-07-26 07:10:00 | AAPL | Stock | 14.2607 | 14.2664 | 14.2571 | 14.2664 | 88312.0 |
| 2011-07-26 07:15:00 | AAPL | Stock | 14.2664 | 14.2664 | 14.2661 | 14.2661 | 19600.0 |
| 2011-07-26 07:20:00 | AAPL | Stock | 14.26 | 14.2679 | 14.26 | 14.2679 | 86800.0 |
| 2011-07-26 07:25:00 | AAPL | Stock | 14.2611 | 14.2639 | 14.2611 | 14.2625 | 25200.0 |
| 2011-07-26 07:30:00 | AAPL | Stock | 14.2679 | 14.2818 | 14.2643 | 14.2643 | 128800.0 |
| 2011-07-26 07:35:00 | AAPL | Stock | 14.2639 | 14.2786 | 14.2639 | 14.2768 | 39536.0 |
| 2011-07-26 07:40:00 | AAPL | Stock | 14.2768 | 14.295 | 14.2768 | 14.295 | 72408.0 |
| 2011-07-26 07:45:00 | AAPL | Stock | 14.2929 | 14.3036 | 14.2857 | 14.2968 | 142380.0 |
| 2011-07-26 07:50:00 | AAPL | Stock | 14.2964 | 14.2964 | 14.2929 | 14.2929 | 22400.0 |
| 2011-07-26 07:55:00 | AAPL | Stock | 14.2896 | 14.3018 | 14.2846 | 14.2846 | 342972.0 |
| 2011-07-26 08:00:00 | AAPL | Stock | 14.2886 | 14.2929 | 14.2675 | 14.2929 | 349076.0 |
| 2011-07-26 08:05:00 | AAPL | Stock | 14.2921 | 14.2925 | 14.2768 | 14.2768 | 268968.0 |
| 2011-07-26 08:10:00 | AAPL | Stock | 14.2768 | 14.2929 | 14.2768 | 14.2929 | 221088.0 |
| 2011-07-26 08:15:00 | AAPL | Stock | 14.2954 | 14.2993 | 14.2893 | 14.2993 | 149380.0 |
| 2011-07-26 08:20:00 | AAPL | Stock | 14.2982 | 14.3111 | 14.2954 | 14.2964 | 426552.0 |
| 2011-07-26 08:25:00 | AAPL | Stock | 14.2982 | 14.3139 | 14.2982 | 14.3054 | 196364.0 |
| 2011-07-26 08:30:00 | AAPL | Stock | 14.3057 | 14.3321 | 14.3025 | 14.3171 | 641480.0 |
| 2011-07-26 08:35:00 | AAPL | Stock | 14.3139 | 14.3221 | 14.3039 | 14.3071 | 165508.0 |
| 2011-07-26 08:40:00 | AAPL | Stock | 14.3071 | 14.31 | 14.2889 | 14.2943 | 707980.0 |
| 2011-07-26 08:45:00 | AAPL | Stock | 14.2946 | 14.3054 | 14.2879 | 14.3 | 1199464.0 |
| 2011-07-26 08:50:00 | AAPL | Stock | 14.2993 | 14.2996 | 14.2911 | 14.2914 | 244104.0 |
| 2011-07-26 08:55:00 | AAPL | Stock | 14.2946 | 14.2954 | 14.2918 | 14.2932 | 154392.0 |
| 2011-07-26 09:00:00 | AAPL | Stock | 14.2925 | 14.2971 | 14.2821 | 14.2821 | 600684.0 |
| 2011-07-26 09:05:00 | AAPL | Stock | 14.2821 | 14.2896 | 14.2682 | 14.2779 | 299712.0 |
| 2011-07-26 09:10:00 | AAPL | Stock | 14.2786 | 14.2911 | 14.2786 | 14.2857 | 389144.0 |
| 2011-07-26 09:15:00 | AAPL | Stock | 14.2857 | 14.2904 | 14.2821 | 14.2839 | 276388.0 |
| 2011-07-26 09:20:00 | AAPL | Stock | 14.2804 | 14.2857 | 14.2789 | 14.2832 | 82992.0 |
| 2011-07-26 09:25:00 | AAPL | Stock | 14.2825 | 14.29 | 14.2729 | 14.2857 | 891044.0 |
| 2011-07-26 09:30:00 | AAPL | Stock | 14.2857 | 14.3468 | 14.2743 | 14.3082 | 28203280.0 |
| 2011-07-26 09:35:00 | AAPL | Stock | 14.3082 | 14.3879 | 14.2946 | 14.3661 | 22333248.0 |
| 2011-07-26 09:40:00 | AAPL | Stock | 14.37 | 14.4089 | 14.3629 | 14.3657 | 20506724.0 |
| 2011-07-26 09:45:00 | AAPL | Stock | 14.3649 | 14.3804 | 14.3332 | 14.3804 | 14228060.0 |
> showing 50 of 324,015 rows — these rows as CSV