PREVIEW / stock_5min / 2011-06-03
file: by_date/stock_5min/2011/2011-06-03.parquet size: 5.0 MB rows: 338,974 symbols: 3,552
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-06-03 04:00:00 | AAPL | Stock | 12.3571 | 12.365 | 12.3571 | 12.365 | 8400.0 |
| 2011-06-03 04:10:00 | AAPL | Stock | 12.365 | 12.365 | 12.365 | 12.365 | 2800.0 |
| 2011-06-03 04:35:00 | AAPL | Stock | 12.3629 | 12.3629 | 12.3575 | 12.3575 | 9100.0 |
| 2011-06-03 06:05:00 | AAPL | Stock | 12.3575 | 12.3575 | 12.3393 | 12.3393 | 60900.0 |
| 2011-06-03 06:10:00 | AAPL | Stock | 12.3554 | 12.3554 | 12.3554 | 12.3554 | 9660.0 |
| 2011-06-03 07:35:00 | AAPL | Stock | 12.34 | 12.35 | 12.34 | 12.35 | 5936.0 |
| 2011-06-03 07:40:00 | AAPL | Stock | 12.3554 | 12.3554 | 12.35 | 12.35 | 14840.0 |
| 2011-06-03 07:50:00 | AAPL | Stock | 12.3429 | 12.3429 | 12.3393 | 12.3393 | 53004.0 |
| 2011-06-03 08:00:00 | AAPL | Stock | 12.3375 | 12.3393 | 12.3286 | 12.3286 | 74816.0 |
| 2011-06-03 08:05:00 | AAPL | Stock | 12.3268 | 12.3275 | 12.3107 | 12.3107 | 117348.0 |
| 2011-06-03 08:10:00 | AAPL | Stock | 12.3107 | 12.3214 | 12.3107 | 12.3204 | 61320.0 |
| 2011-06-03 08:15:00 | AAPL | Stock | 12.3179 | 12.3261 | 12.3143 | 12.3196 | 83580.0 |
| 2011-06-03 08:20:00 | AAPL | Stock | 12.3232 | 12.3525 | 12.3179 | 12.3179 | 137620.0 |
| 2011-06-03 08:25:00 | AAPL | Stock | 12.3389 | 12.3393 | 12.3214 | 12.3214 | 43148.0 |
| 2011-06-03 08:30:00 | AAPL | Stock | 12.3179 | 12.3214 | 12.2718 | 12.2918 | 762328.0 |
| 2011-06-03 08:35:00 | AAPL | Stock | 12.2932 | 12.2936 | 12.2532 | 12.2589 | 712320.0 |
| 2011-06-03 08:40:00 | AAPL | Stock | 12.2593 | 12.2857 | 12.2586 | 12.2839 | 410788.0 |
| 2011-06-03 08:45:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.275 | 12.275 | 552020.0 |
| 2011-06-03 08:50:00 | AAPL | Stock | 12.2718 | 12.2793 | 12.2607 | 12.2675 | 449400.0 |
| 2011-06-03 08:55:00 | AAPL | Stock | 12.2671 | 12.275 | 12.25 | 12.2714 | 558124.0 |
| 2011-06-03 09:00:00 | AAPL | Stock | 12.2689 | 12.2721 | 12.2575 | 12.2607 | 153552.0 |
| 2011-06-03 09:05:00 | AAPL | Stock | 12.2657 | 12.2718 | 12.2625 | 12.2679 | 85708.0 |
| 2011-06-03 09:10:00 | AAPL | Stock | 12.2632 | 12.2786 | 12.2632 | 12.2639 | 413644.0 |
| 2011-06-03 09:15:00 | AAPL | Stock | 12.2682 | 12.2761 | 12.26 | 12.26 | 53200.0 |
| 2011-06-03 09:20:00 | AAPL | Stock | 12.2675 | 12.2679 | 12.2593 | 12.2675 | 98364.0 |
| 2011-06-03 09:25:00 | AAPL | Stock | 12.2654 | 12.2714 | 12.2507 | 12.2604 | 750372.0 |
| 2011-06-03 09:30:00 | AAPL | Stock | 12.2571 | 12.3036 | 12.2457 | 12.2934 | 16992640.0 |
| 2011-06-03 09:35:00 | AAPL | Stock | 12.2921 | 12.2993 | 12.27 | 12.2875 | 8744540.0 |
| 2011-06-03 09:40:00 | AAPL | Stock | 12.2875 | 12.3107 | 12.2771 | 12.286 | 11153632.0 |
| 2011-06-03 09:45:00 | AAPL | Stock | 12.2854 | 12.2925 | 12.2536 | 12.2642 | 9212140.0 |
| 2011-06-03 09:50:00 | AAPL | Stock | 12.2639 | 12.2743 | 12.2407 | 12.2475 | 9808008.0 |
| 2011-06-03 09:55:00 | AAPL | Stock | 12.2475 | 12.2821 | 12.2382 | 12.2618 | 9298772.0 |
| 2011-06-03 10:00:00 | AAPL | Stock | 12.2664 | 12.2996 | 12.2643 | 12.285 | 8518748.0 |
| 2011-06-03 10:05:00 | AAPL | Stock | 12.2875 | 12.2896 | 12.27 | 12.2833 | 5143796.0 |
| 2011-06-03 10:10:00 | AAPL | Stock | 12.2827 | 12.3025 | 12.2757 | 12.2757 | 4507888.0 |
| 2011-06-03 10:15:00 | AAPL | Stock | 12.2757 | 12.2943 | 12.2754 | 12.2789 | 3652432.0 |
| 2011-06-03 10:20:00 | AAPL | Stock | 12.2789 | 12.2821 | 12.2679 | 12.2739 | 3442796.0 |
| 2011-06-03 10:25:00 | AAPL | Stock | 12.2739 | 12.3104 | 12.2711 | 12.3007 | 7622860.0 |
| 2011-06-03 10:30:00 | AAPL | Stock | 12.3029 | 12.3332 | 12.2943 | 12.3211 | 7896756.0 |
| 2011-06-03 10:35:00 | AAPL | Stock | 12.3214 | 12.3264 | 12.2921 | 12.2979 | 5422312.0 |
| 2011-06-03 10:40:00 | AAPL | Stock | 12.2979 | 12.3046 | 12.2881 | 12.2993 | 3188836.0 |
| 2011-06-03 10:45:00 | AAPL | Stock | 12.2996 | 12.3121 | 12.2936 | 12.2954 | 4817652.0 |
| 2011-06-03 10:50:00 | AAPL | Stock | 12.2964 | 12.3089 | 12.2868 | 12.2957 | 3476732.0 |
| 2011-06-03 10:55:00 | AAPL | Stock | 12.2971 | 12.3025 | 12.2875 | 12.3002 | 1986572.0 |
| 2011-06-03 11:00:00 | AAPL | Stock | 12.3004 | 12.3004 | 12.2868 | 12.2937 | 2038008.0 |
| 2011-06-03 11:05:00 | AAPL | Stock | 12.2918 | 12.2932 | 12.2721 | 12.2857 | 5208812.0 |
| 2011-06-03 11:10:00 | AAPL | Stock | 12.2854 | 12.2869 | 12.2739 | 12.2768 | 2270044.0 |
| 2011-06-03 11:15:00 | AAPL | Stock | 12.2768 | 12.2807 | 12.2679 | 12.27 | 2440480.0 |
| 2011-06-03 11:20:00 | AAPL | Stock | 12.27 | 12.2907 | 12.2686 | 12.2732 | 2544920.0 |
| 2011-06-03 11:25:00 | AAPL | Stock | 12.2732 | 12.2746 | 12.2643 | 12.2686 | 2557716.0 |
> showing 50 of 338,974 rows — these rows as CSV