PREVIEW / stock_5min / 2006-08-14
file: by_date/stock_5min/2006/2006-08-14.parquet size: 3.0 MB rows: 222,194 symbols: 2,345
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 |
|---|---|---|---|---|---|---|---|
| 2006-08-14 05:20:00 | AAPL | Stock | 2.2811 | 2.2811 | 2.2811 | 2.2811 | 2800.0 |
| 2006-08-14 08:00:00 | AAPL | Stock | 2.2786 | 2.2911 | 2.2714 | 2.29 | 518364.0 |
| 2006-08-14 08:05:00 | AAPL | Stock | 2.2921 | 2.2946 | 2.2893 | 2.2929 | 292180.0 |
| 2006-08-14 08:10:00 | AAPL | Stock | 2.2921 | 2.2929 | 2.2857 | 2.2907 | 212800.0 |
| 2006-08-14 08:15:00 | AAPL | Stock | 2.29 | 2.2907 | 2.2868 | 2.2868 | 20300.0 |
| 2006-08-14 08:20:00 | AAPL | Stock | 2.2896 | 2.2896 | 2.2879 | 2.2879 | 5600.0 |
| 2006-08-14 08:25:00 | AAPL | Stock | 2.2875 | 2.2893 | 2.2857 | 2.2857 | 297080.0 |
| 2006-08-14 08:30:00 | AAPL | Stock | 2.2857 | 2.2896 | 2.2857 | 2.2871 | 184800.0 |
| 2006-08-14 08:35:00 | AAPL | Stock | 2.2857 | 2.2925 | 2.2857 | 2.2925 | 281176.0 |
| 2006-08-14 08:40:00 | AAPL | Stock | 2.2918 | 2.2921 | 2.29 | 2.29 | 48776.0 |
| 2006-08-14 08:45:00 | AAPL | Stock | 2.2875 | 2.2911 | 2.2875 | 2.29 | 101472.0 |
| 2006-08-14 08:50:00 | AAPL | Stock | 2.2911 | 2.2921 | 2.2911 | 2.2914 | 44968.0 |
| 2006-08-14 08:55:00 | AAPL | Stock | 2.2911 | 2.2914 | 2.2857 | 2.2857 | 111972.0 |
| 2006-08-14 09:00:00 | AAPL | Stock | 2.2857 | 2.2875 | 2.2821 | 2.2821 | 171920.0 |
| 2006-08-14 09:05:00 | AAPL | Stock | 2.2821 | 2.2839 | 2.2821 | 2.2839 | 148484.0 |
| 2006-08-14 09:10:00 | AAPL | Stock | 2.2854 | 2.2893 | 2.2839 | 2.2839 | 254660.0 |
| 2006-08-14 09:15:00 | AAPL | Stock | 2.2839 | 2.2839 | 2.2821 | 2.2836 | 61600.0 |
| 2006-08-14 09:20:00 | AAPL | Stock | 2.2846 | 2.2846 | 2.2846 | 2.2846 | 5600.0 |
| 2006-08-14 09:25:00 | AAPL | Stock | 2.2818 | 2.2875 | 2.2818 | 2.2857 | 1689940.0 |
| 2006-08-14 09:30:00 | AAPL | Stock | 2.2875 | 2.305 | 2.2821 | 2.2932 | 32871748.0 |
| 2006-08-14 09:35:00 | AAPL | Stock | 2.2929 | 2.3018 | 2.2829 | 2.2839 | 20206340.0 |
| 2006-08-14 09:40:00 | AAPL | Stock | 2.2839 | 2.2857 | 2.2761 | 2.279 | 18424952.0 |
| 2006-08-14 09:45:00 | AAPL | Stock | 2.2789 | 2.2825 | 2.275 | 2.2757 | 16958004.0 |
| 2006-08-14 09:50:00 | AAPL | Stock | 2.2757 | 2.2864 | 2.2754 | 2.2857 | 15677228.0 |
| 2006-08-14 09:55:00 | AAPL | Stock | 2.2857 | 2.2925 | 2.2839 | 2.2857 | 15423800.0 |
| 2006-08-14 10:00:00 | AAPL | Stock | 2.2857 | 2.2882 | 2.28 | 2.2814 | 7836332.0 |
| 2006-08-14 10:05:00 | AAPL | Stock | 2.2818 | 2.2875 | 2.2818 | 2.2846 | 7999208.0 |
| 2006-08-14 10:10:00 | AAPL | Stock | 2.2846 | 2.285 | 2.2804 | 2.2821 | 9404304.0 |
| 2006-08-14 10:15:00 | AAPL | Stock | 2.2821 | 2.2836 | 2.2757 | 2.2768 | 11708592.0 |
| 2006-08-14 10:20:00 | AAPL | Stock | 2.2764 | 2.2807 | 2.2721 | 2.2736 | 12671792.0 |
| 2006-08-14 10:25:00 | AAPL | Stock | 2.2732 | 2.2775 | 2.2714 | 2.2757 | 13485752.0 |
| 2006-08-14 10:30:00 | AAPL | Stock | 2.2757 | 2.2864 | 2.2754 | 2.2857 | 9408980.0 |
| 2006-08-14 10:35:00 | AAPL | Stock | 2.2861 | 2.2864 | 2.2814 | 2.2821 | 6158012.0 |
| 2006-08-14 10:40:00 | AAPL | Stock | 2.2818 | 2.2854 | 2.2804 | 2.2839 | 6397384.0 |
| 2006-08-14 10:45:00 | AAPL | Stock | 2.2843 | 2.2889 | 2.2807 | 2.2868 | 8153516.0 |
| 2006-08-14 10:50:00 | AAPL | Stock | 2.2868 | 2.2882 | 2.2854 | 2.2871 | 5320112.0 |
| 2006-08-14 10:55:00 | AAPL | Stock | 2.2871 | 2.2893 | 2.2839 | 2.288 | 5978896.0 |
| 2006-08-14 11:00:00 | AAPL | Stock | 2.2879 | 2.3 | 2.2864 | 2.2982 | 14907676.0 |
| 2006-08-14 11:05:00 | AAPL | Stock | 2.2982 | 2.3021 | 2.2954 | 2.3014 | 15376032.0 |
| 2006-08-14 11:10:00 | AAPL | Stock | 2.3011 | 2.3089 | 2.2989 | 2.3071 | 16486288.0 |
| 2006-08-14 11:15:00 | AAPL | Stock | 2.3071 | 2.3096 | 2.3021 | 2.3029 | 18660460.0 |
| 2006-08-14 11:20:00 | AAPL | Stock | 2.3029 | 2.3057 | 2.2968 | 2.3 | 10592764.0 |
| 2006-08-14 11:25:00 | AAPL | Stock | 2.3 | 2.3029 | 2.2993 | 2.3011 | 6146812.0 |
| 2006-08-14 11:30:00 | AAPL | Stock | 2.3014 | 2.3061 | 2.2979 | 2.2986 | 9980544.0 |
| 2006-08-14 11:35:00 | AAPL | Stock | 2.2986 | 2.3036 | 2.2986 | 2.3029 | 8571780.0 |
| 2006-08-14 11:40:00 | AAPL | Stock | 2.3032 | 2.3061 | 2.2964 | 2.3047 | 8848728.0 |
| 2006-08-14 11:45:00 | AAPL | Stock | 2.3054 | 2.3086 | 2.3032 | 2.3043 | 6001156.0 |
| 2006-08-14 11:50:00 | AAPL | Stock | 2.3043 | 2.3089 | 2.3043 | 2.3068 | 4232788.0 |
| 2006-08-14 11:55:00 | AAPL | Stock | 2.3068 | 2.3093 | 2.3057 | 2.3085 | 16423568.0 |
| 2006-08-14 12:00:00 | AAPL | Stock | 2.3086 | 2.3139 | 2.3082 | 2.3129 | 13058640.0 |
> showing 50 of 222,194 rows — these rows as CSV