PREVIEW / stock_5min / 2009-02-26
file: by_date/stock_5min/2009/2009-02-26.parquet size: 4.4 MB rows: 303,925 symbols: 3,304
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-26 06:35:00 | AAPL | Stock | 3.2918 | 3.2918 | 3.2918 | 3.2918 | 16800.0 |
| 2009-02-26 07:05:00 | AAPL | Stock | 3.2936 | 3.2936 | 3.2936 | 3.2936 | 8400.0 |
| 2009-02-26 07:15:00 | AAPL | Stock | 3.2929 | 3.2929 | 3.2857 | 3.2857 | 42000.0 |
| 2009-02-26 07:30:00 | AAPL | Stock | 3.2854 | 3.2854 | 3.2854 | 3.2854 | 25480.0 |
| 2009-02-26 07:35:00 | AAPL | Stock | 3.2857 | 3.2857 | 3.2857 | 3.2857 | 24220.0 |
| 2009-02-26 07:40:00 | AAPL | Stock | 3.2921 | 3.2921 | 3.2921 | 3.2921 | 13300.0 |
| 2009-02-26 07:45:00 | AAPL | Stock | 3.2921 | 3.2921 | 3.2921 | 3.2921 | 40180.0 |
| 2009-02-26 07:50:00 | AAPL | Stock | 3.2914 | 3.2914 | 3.2914 | 3.2914 | 5600.0 |
| 2009-02-26 07:55:00 | AAPL | Stock | 3.2946 | 3.2946 | 3.2946 | 3.2946 | 39480.0 |
| 2009-02-26 08:00:00 | AAPL | Stock | 3.2946 | 3.2964 | 3.2893 | 3.2893 | 111860.0 |
| 2009-02-26 08:05:00 | AAPL | Stock | 3.2857 | 3.2857 | 3.2814 | 3.2857 | 66920.0 |
| 2009-02-26 08:10:00 | AAPL | Stock | 3.2857 | 3.2857 | 3.2857 | 3.2857 | 24388.0 |
| 2009-02-26 08:20:00 | AAPL | Stock | 3.2854 | 3.2854 | 3.2854 | 3.2854 | 7000.0 |
| 2009-02-26 08:25:00 | AAPL | Stock | 3.2821 | 3.285 | 3.2821 | 3.285 | 30100.0 |
| 2009-02-26 08:30:00 | AAPL | Stock | 3.285 | 3.2857 | 3.2718 | 3.2857 | 71708.0 |
| 2009-02-26 08:35:00 | AAPL | Stock | 3.2893 | 3.2907 | 3.2857 | 3.2907 | 32340.0 |
| 2009-02-26 08:40:00 | AAPL | Stock | 3.2896 | 3.2896 | 3.2875 | 3.2875 | 19600.0 |
| 2009-02-26 08:45:00 | AAPL | Stock | 3.2875 | 3.2932 | 3.2857 | 3.2871 | 81956.0 |
| 2009-02-26 08:50:00 | AAPL | Stock | 3.2857 | 3.2871 | 3.275 | 3.2871 | 73920.0 |
| 2009-02-26 08:55:00 | AAPL | Stock | 3.2843 | 3.2843 | 3.2843 | 3.2843 | 5600.0 |
| 2009-02-26 09:00:00 | AAPL | Stock | 3.2857 | 3.2868 | 3.2821 | 3.2821 | 98000.0 |
| 2009-02-26 09:05:00 | AAPL | Stock | 3.2814 | 3.2814 | 3.2714 | 3.275 | 90160.0 |
| 2009-02-26 09:10:00 | AAPL | Stock | 3.275 | 3.2786 | 3.275 | 3.2768 | 131320.0 |
| 2009-02-26 09:15:00 | AAPL | Stock | 3.2754 | 3.2793 | 3.275 | 3.2786 | 62300.0 |
| 2009-02-26 09:20:00 | AAPL | Stock | 3.2754 | 3.2821 | 3.2679 | 3.2821 | 139440.0 |
| 2009-02-26 09:25:00 | AAPL | Stock | 3.2761 | 3.2932 | 3.2761 | 3.2857 | 208516.0 |
| 2009-02-26 09:30:00 | AAPL | Stock | 3.2821 | 3.2975 | 3.2789 | 3.2918 | 16900380.0 |
| 2009-02-26 09:35:00 | AAPL | Stock | 3.2907 | 3.2943 | 3.2621 | 3.2629 | 12288612.0 |
| 2009-02-26 09:40:00 | AAPL | Stock | 3.2632 | 3.2707 | 3.2464 | 3.2561 | 13449716.0 |
| 2009-02-26 09:45:00 | AAPL | Stock | 3.2571 | 3.2589 | 3.2343 | 3.2393 | 12679660.0 |
| 2009-02-26 09:50:00 | AAPL | Stock | 3.2396 | 3.26 | 3.2393 | 3.2539 | 8206576.0 |
| 2009-02-26 09:55:00 | AAPL | Stock | 3.254 | 3.2589 | 3.2414 | 3.2564 | 7174860.0 |
| 2009-02-26 10:00:00 | AAPL | Stock | 3.2571 | 3.275 | 3.25 | 3.2704 | 11075456.0 |
| 2009-02-26 10:05:00 | AAPL | Stock | 3.2711 | 3.2811 | 3.2646 | 3.2739 | 6795488.0 |
| 2009-02-26 10:10:00 | AAPL | Stock | 3.2732 | 3.2743 | 3.2546 | 3.2639 | 8530396.0 |
| 2009-02-26 10:15:00 | AAPL | Stock | 3.265 | 3.2732 | 3.2543 | 3.2707 | 6133764.0 |
| 2009-02-26 10:20:00 | AAPL | Stock | 3.2693 | 3.2893 | 3.2679 | 3.2886 | 8756524.0 |
| 2009-02-26 10:25:00 | AAPL | Stock | 3.2886 | 3.2921 | 3.2775 | 3.2821 | 8520568.0 |
| 2009-02-26 10:30:00 | AAPL | Stock | 3.2818 | 3.2904 | 3.2701 | 3.2868 | 7950096.0 |
| 2009-02-26 10:35:00 | AAPL | Stock | 3.2868 | 3.3096 | 3.285 | 3.3025 | 12779200.0 |
| 2009-02-26 10:40:00 | AAPL | Stock | 3.3025 | 3.3082 | 3.3 | 3.3032 | 7188104.0 |
| 2009-02-26 10:45:00 | AAPL | Stock | 3.3036 | 3.3168 | 3.3032 | 3.3114 | 8914808.0 |
| 2009-02-26 10:50:00 | AAPL | Stock | 3.3107 | 3.3154 | 3.3039 | 3.3054 | 7536480.0 |
| 2009-02-26 10:55:00 | AAPL | Stock | 3.3054 | 3.3186 | 3.304 | 3.3161 | 5128284.0 |
| 2009-02-26 11:00:00 | AAPL | Stock | 3.3157 | 3.3186 | 3.3 | 3.3011 | 7678132.0 |
| 2009-02-26 11:05:00 | AAPL | Stock | 3.3018 | 3.3018 | 3.29 | 3.295 | 10154452.0 |
| 2009-02-26 11:10:00 | AAPL | Stock | 3.2954 | 3.3018 | 3.2882 | 3.3018 | 8014384.0 |
| 2009-02-26 11:15:00 | AAPL | Stock | 3.3018 | 3.3018 | 3.2818 | 3.2889 | 9706536.0 |
| 2009-02-26 11:20:00 | AAPL | Stock | 3.2886 | 3.2957 | 3.285 | 3.2939 | 5562592.0 |
| 2009-02-26 11:25:00 | AAPL | Stock | 3.2939 | 3.2957 | 3.2786 | 3.28 | 5333216.0 |
> showing 50 of 303,925 rows — these rows as CSV