PREVIEW / stock_5min / 2005-04-22
file: by_date/stock_5min/2005/2005-04-22.parquet size: 2.7 MB rows: 198,696 symbols: 1,956
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 |
|---|---|---|---|---|---|---|---|
| 2005-04-22 08:00:00 | AAPL | Stock | 1.325 | 1.3271 | 1.3079 | 1.3079 | 356720.0 |
| 2005-04-22 08:05:00 | AAPL | Stock | 1.3082 | 1.3125 | 1.3082 | 1.3107 | 39200.0 |
| 2005-04-22 08:10:00 | AAPL | Stock | 1.3089 | 1.3143 | 1.3082 | 1.3121 | 142716.0 |
| 2005-04-22 08:15:00 | AAPL | Stock | 1.3125 | 1.3125 | 1.3121 | 1.3121 | 62524.0 |
| 2005-04-22 08:20:00 | AAPL | Stock | 1.3129 | 1.3129 | 1.3129 | 1.3129 | 4200.0 |
| 2005-04-22 08:25:00 | AAPL | Stock | 1.3121 | 1.3129 | 1.3118 | 1.3118 | 59332.0 |
| 2005-04-22 08:30:00 | AAPL | Stock | 1.3125 | 1.3175 | 1.3125 | 1.3175 | 42532.0 |
| 2005-04-22 08:35:00 | AAPL | Stock | 1.3154 | 1.3175 | 1.3125 | 1.3143 | 309568.0 |
| 2005-04-22 08:40:00 | AAPL | Stock | 1.3129 | 1.3143 | 1.3125 | 1.3143 | 202636.0 |
| 2005-04-22 08:45:00 | AAPL | Stock | 1.315 | 1.3161 | 1.315 | 1.3157 | 53732.0 |
| 2005-04-22 08:50:00 | AAPL | Stock | 1.3157 | 1.3186 | 1.3157 | 1.3186 | 70840.0 |
| 2005-04-22 08:55:00 | AAPL | Stock | 1.3193 | 1.3214 | 1.3193 | 1.3214 | 223972.0 |
| 2005-04-22 09:00:00 | AAPL | Stock | 1.3171 | 1.3171 | 1.3168 | 1.3171 | 35000.0 |
| 2005-04-22 09:05:00 | AAPL | Stock | 1.3171 | 1.3179 | 1.3171 | 1.3179 | 125300.0 |
| 2005-04-22 09:10:00 | AAPL | Stock | 1.3179 | 1.3193 | 1.3118 | 1.3118 | 349860.0 |
| 2005-04-22 09:15:00 | AAPL | Stock | 1.3143 | 1.3164 | 1.3139 | 1.3143 | 1331400.0 |
| 2005-04-22 09:20:00 | AAPL | Stock | 1.3143 | 1.3154 | 1.3107 | 1.3154 | 1042776.0 |
| 2005-04-22 09:25:00 | AAPL | Stock | 1.3175 | 1.3175 | 1.3143 | 1.3143 | 925372.0 |
| 2005-04-22 09:30:00 | AAPL | Stock | 1.3157 | 1.3214 | 1.2968 | 1.2968 | 34611080.0 |
| 2005-04-22 09:35:00 | AAPL | Stock | 1.2968 | 1.2986 | 1.2807 | 1.2857 | 39008648.0 |
| 2005-04-22 09:40:00 | AAPL | Stock | 1.2857 | 1.2921 | 1.2789 | 1.2879 | 24576440.0 |
| 2005-04-22 09:45:00 | AAPL | Stock | 1.2879 | 1.2882 | 1.2793 | 1.2818 | 23836764.0 |
| 2005-04-22 09:50:00 | AAPL | Stock | 1.2811 | 1.2829 | 1.2718 | 1.2793 | 28668108.0 |
| 2005-04-22 09:55:00 | AAPL | Stock | 1.2793 | 1.2804 | 1.2732 | 1.2732 | 18062156.0 |
| 2005-04-22 10:00:00 | AAPL | Stock | 1.2732 | 1.2782 | 1.2704 | 1.2721 | 20297004.0 |
| 2005-04-22 10:05:00 | AAPL | Stock | 1.2714 | 1.3143 | 1.2686 | 1.2761 | 16108120.0 |
| 2005-04-22 10:10:00 | AAPL | Stock | 1.2764 | 1.2818 | 1.2743 | 1.2814 | 14413056.0 |
| 2005-04-22 10:15:00 | AAPL | Stock | 1.2811 | 1.2857 | 1.2775 | 1.2811 | 21967736.0 |
| 2005-04-22 10:20:00 | AAPL | Stock | 1.2811 | 1.2839 | 1.2761 | 1.2775 | 14108024.0 |
| 2005-04-22 10:25:00 | AAPL | Stock | 1.2775 | 1.2886 | 1.2775 | 1.2857 | 19055204.0 |
| 2005-04-22 10:30:00 | AAPL | Stock | 1.2854 | 1.2871 | 1.2825 | 1.2839 | 8631756.0 |
| 2005-04-22 10:35:00 | AAPL | Stock | 1.2836 | 1.2861 | 1.2829 | 1.2836 | 5976964.0 |
| 2005-04-22 10:40:00 | AAPL | Stock | 1.2832 | 1.2832 | 1.2754 | 1.2786 | 9259488.0 |
| 2005-04-22 10:45:00 | AAPL | Stock | 1.2786 | 1.2843 | 1.2779 | 1.2832 | 4566492.0 |
| 2005-04-22 10:50:00 | AAPL | Stock | 1.2832 | 1.2843 | 1.2814 | 1.2821 | 4644976.0 |
| 2005-04-22 10:55:00 | AAPL | Stock | 1.2821 | 1.2864 | 1.2821 | 1.2839 | 6577704.0 |
| 2005-04-22 11:00:00 | AAPL | Stock | 1.2836 | 1.2936 | 1.2832 | 1.2907 | 16545228.0 |
| 2005-04-22 11:05:00 | AAPL | Stock | 1.2911 | 1.2936 | 1.2871 | 1.2871 | 8369732.0 |
| 2005-04-22 11:10:00 | AAPL | Stock | 1.2871 | 1.2907 | 1.2861 | 1.29 | 7308952.0 |
| 2005-04-22 11:15:00 | AAPL | Stock | 1.2896 | 1.2932 | 1.2889 | 1.2911 | 8484476.0 |
| 2005-04-22 11:20:00 | AAPL | Stock | 1.2911 | 1.2932 | 1.2879 | 1.2896 | 6894972.0 |
| 2005-04-22 11:25:00 | AAPL | Stock | 1.2896 | 1.2907 | 1.2864 | 1.2871 | 4492628.0 |
| 2005-04-22 11:30:00 | AAPL | Stock | 1.2882 | 1.2882 | 1.2861 | 1.2864 | 6655264.0 |
| 2005-04-22 11:35:00 | AAPL | Stock | 1.2864 | 1.2868 | 1.2804 | 1.2807 | 7579236.0 |
| 2005-04-22 11:40:00 | AAPL | Stock | 1.2811 | 1.2821 | 1.275 | 1.2752 | 11217248.0 |
| 2005-04-22 11:45:00 | AAPL | Stock | 1.2754 | 1.2779 | 1.275 | 1.2754 | 10306212.0 |
| 2005-04-22 11:50:00 | AAPL | Stock | 1.2757 | 1.28 | 1.2743 | 1.2746 | 10006304.0 |
| 2005-04-22 11:55:00 | AAPL | Stock | 1.2746 | 1.2754 | 1.2707 | 1.2736 | 13925968.0 |
| 2005-04-22 12:00:00 | AAPL | Stock | 1.2736 | 1.2757 | 1.27 | 1.2714 | 10849552.0 |
| 2005-04-22 12:05:00 | AAPL | Stock | 1.2711 | 1.2725 | 1.2679 | 1.2682 | 12692848.0 |
> showing 50 of 198,696 rows — these rows as CSV