PREVIEW / stock_5min / 2009-02-03
file: by_date/stock_5min/2009/2009-02-03.parquet size: 4.4 MB rows: 311,191 symbols: 3,273
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 |
|---|---|---|---|---|---|---|---|
| 2009-02-03 07:00:00 | AAPL | Stock | 3.2679 | 3.2679 | 3.2679 | 3.2679 | 5600.0 |
| 2009-02-03 07:10:00 | AAPL | Stock | 3.2675 | 3.2675 | 3.2675 | 3.2675 | 2800.0 |
| 2009-02-03 07:30:00 | AAPL | Stock | 3.2736 | 3.2779 | 3.2736 | 3.2779 | 53200.0 |
| 2009-02-03 08:05:00 | AAPL | Stock | 3.2675 | 3.275 | 3.2675 | 3.2675 | 32200.0 |
| 2009-02-03 08:10:00 | AAPL | Stock | 3.2682 | 3.2682 | 3.2682 | 3.2682 | 89600.0 |
| 2009-02-03 08:15:00 | AAPL | Stock | 3.2696 | 3.2696 | 3.2682 | 3.2682 | 67676.0 |
| 2009-02-03 08:20:00 | AAPL | Stock | 3.2675 | 3.2675 | 3.2675 | 3.2675 | 5600.0 |
| 2009-02-03 08:30:00 | AAPL | Stock | 3.2643 | 3.2643 | 3.2643 | 3.2643 | 14000.0 |
| 2009-02-03 08:35:00 | AAPL | Stock | 3.2643 | 3.2675 | 3.2643 | 3.2646 | 53760.0 |
| 2009-02-03 08:40:00 | AAPL | Stock | 3.2664 | 3.2664 | 3.265 | 3.265 | 16800.0 |
| 2009-02-03 08:45:00 | AAPL | Stock | 3.2689 | 3.2736 | 3.2657 | 3.2736 | 16800.0 |
| 2009-02-03 08:55:00 | AAPL | Stock | 3.2732 | 3.2829 | 3.2732 | 3.2814 | 144340.0 |
| 2009-02-03 09:00:00 | AAPL | Stock | 3.2829 | 3.2957 | 3.2814 | 3.2868 | 208628.0 |
| 2009-02-03 09:05:00 | AAPL | Stock | 3.2861 | 3.2911 | 3.2861 | 3.2868 | 27104.0 |
| 2009-02-03 09:10:00 | AAPL | Stock | 3.2918 | 3.2943 | 3.2914 | 3.2921 | 98308.0 |
| 2009-02-03 09:15:00 | AAPL | Stock | 3.2911 | 3.2911 | 3.2893 | 3.2911 | 60928.0 |
| 2009-02-03 09:20:00 | AAPL | Stock | 3.2904 | 3.2907 | 3.2893 | 3.2893 | 8400.0 |
| 2009-02-03 09:25:00 | AAPL | Stock | 3.2889 | 3.2889 | 3.2782 | 3.2804 | 864864.0 |
| 2009-02-03 09:30:00 | AAPL | Stock | 3.2821 | 3.29 | 3.2721 | 3.2779 | 17531948.0 |
| 2009-02-03 09:35:00 | AAPL | Stock | 3.2782 | 3.2786 | 3.2454 | 3.2493 | 15752268.0 |
| 2009-02-03 09:40:00 | AAPL | Stock | 3.2489 | 3.2643 | 3.2425 | 3.2443 | 15337196.0 |
| 2009-02-03 09:45:00 | AAPL | Stock | 3.2443 | 3.2457 | 3.2304 | 3.2375 | 11599308.0 |
| 2009-02-03 09:50:00 | AAPL | Stock | 3.2375 | 3.2454 | 3.2243 | 3.2439 | 13606880.0 |
| 2009-02-03 09:55:00 | AAPL | Stock | 3.2439 | 3.2471 | 3.2346 | 3.2418 | 8984864.0 |
| 2009-02-03 10:00:00 | AAPL | Stock | 3.2418 | 3.2575 | 3.2396 | 3.2489 | 11376568.0 |
| 2009-02-03 10:05:00 | AAPL | Stock | 3.2486 | 3.2711 | 3.2475 | 3.2643 | 12625256.0 |
| 2009-02-03 10:10:00 | AAPL | Stock | 3.265 | 3.2746 | 3.2632 | 3.2686 | 9634660.0 |
| 2009-02-03 10:15:00 | AAPL | Stock | 3.2689 | 3.2764 | 3.2511 | 3.2536 | 12127752.0 |
| 2009-02-03 10:20:00 | AAPL | Stock | 3.2539 | 3.2582 | 3.2482 | 3.2561 | 6370392.0 |
| 2009-02-03 10:25:00 | AAPL | Stock | 3.2564 | 3.28 | 3.2532 | 3.2714 | 9137408.0 |
| 2009-02-03 10:30:00 | AAPL | Stock | 3.2714 | 3.2839 | 3.2686 | 3.2796 | 9410016.0 |
| 2009-02-03 10:35:00 | AAPL | Stock | 3.28 | 3.2929 | 3.28 | 3.2875 | 11365508.0 |
| 2009-02-03 10:40:00 | AAPL | Stock | 3.2879 | 3.3021 | 3.2875 | 3.3 | 10053484.0 |
| 2009-02-03 10:45:00 | AAPL | Stock | 3.3 | 3.3036 | 3.2943 | 3.2957 | 9239916.0 |
| 2009-02-03 10:50:00 | AAPL | Stock | 3.2961 | 3.3018 | 3.2918 | 3.2968 | 5062932.0 |
| 2009-02-03 10:55:00 | AAPL | Stock | 3.2971 | 3.2996 | 3.2904 | 3.2943 | 4704056.0 |
| 2009-02-03 11:00:00 | AAPL | Stock | 3.295 | 3.3014 | 3.2929 | 3.2975 | 5191452.0 |
| 2009-02-03 11:05:00 | AAPL | Stock | 3.2975 | 3.3104 | 3.2964 | 3.3029 | 9046464.0 |
| 2009-02-03 11:10:00 | AAPL | Stock | 3.3036 | 3.3046 | 3.2982 | 3.3046 | 4492208.0 |
| 2009-02-03 11:15:00 | AAPL | Stock | 3.3036 | 3.3068 | 3.2957 | 3.3018 | 5625116.0 |
| 2009-02-03 11:20:00 | AAPL | Stock | 3.3011 | 3.3071 | 3.2957 | 3.305 | 4931640.0 |
| 2009-02-03 11:25:00 | AAPL | Stock | 3.305 | 3.3104 | 3.3029 | 3.3054 | 4913300.0 |
| 2009-02-03 11:30:00 | AAPL | Stock | 3.3061 | 3.3061 | 3.3 | 3.3046 | 3579828.0 |
| 2009-02-03 11:35:00 | AAPL | Stock | 3.3046 | 3.3075 | 3.2939 | 3.2964 | 5664372.0 |
| 2009-02-03 11:40:00 | AAPL | Stock | 3.2968 | 3.3014 | 3.2939 | 3.2996 | 4420164.0 |
| 2009-02-03 11:45:00 | AAPL | Stock | 3.2989 | 3.3032 | 3.2968 | 3.3025 | 2917460.0 |
| 2009-02-03 11:50:00 | AAPL | Stock | 3.3025 | 3.3029 | 3.2982 | 3.3004 | 2845248.0 |
| 2009-02-03 11:55:00 | AAPL | Stock | 3.3 | 3.3011 | 3.2879 | 3.2925 | 5663084.0 |
| 2009-02-03 12:00:00 | AAPL | Stock | 3.2925 | 3.2971 | 3.29 | 3.2939 | 4154332.0 |
| 2009-02-03 12:05:00 | AAPL | Stock | 3.2939 | 3.2943 | 3.2886 | 3.2896 | 3665592.0 |
> showing 50 of 311,191 rows — these rows as CSV