PREVIEW / stock_5min / 2007-05-31
file: by_date/stock_5min/2007/2007-05-31.parquet size: 4.0 MB rows: 294,410 symbols: 3,012
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 |
|---|---|---|---|---|---|---|---|
| 2007-05-31 09:30:00 | AAPL | Stock | 4.2882 | 4.3036 | 4.2729 | 4.295 | 63504448.0 |
| 2007-05-31 09:35:00 | AAPL | Stock | 4.2946 | 4.3125 | 4.2946 | 4.3093 | 39439344.0 |
| 2007-05-31 09:40:00 | AAPL | Stock | 4.3086 | 4.3121 | 4.2907 | 4.2968 | 37068500.0 |
| 2007-05-31 09:45:00 | AAPL | Stock | 4.2968 | 4.3029 | 4.2939 | 4.2964 | 23692284.0 |
| 2007-05-31 09:50:00 | AAPL | Stock | 4.2964 | 4.2968 | 4.2768 | 4.29 | 35204848.0 |
| 2007-05-31 09:55:00 | AAPL | Stock | 4.29 | 4.2929 | 4.2821 | 4.2864 | 22750672.0 |
| 2007-05-31 10:00:00 | AAPL | Stock | 4.2857 | 4.2993 | 4.2836 | 4.2871 | 22792252.0 |
| 2007-05-31 10:05:00 | AAPL | Stock | 4.2875 | 4.2929 | 4.285 | 4.29 | 20688612.0 |
| 2007-05-31 10:10:00 | AAPL | Stock | 4.29 | 4.2907 | 4.2739 | 4.2804 | 22995280.0 |
| 2007-05-31 10:15:00 | AAPL | Stock | 4.28 | 4.2818 | 4.2693 | 4.2718 | 21856604.0 |
| 2007-05-31 10:20:00 | AAPL | Stock | 4.2718 | 4.285 | 4.2714 | 4.2811 | 18792256.0 |
| 2007-05-31 10:25:00 | AAPL | Stock | 4.2811 | 4.2889 | 4.2775 | 4.2839 | 18105556.0 |
| 2007-05-31 10:30:00 | AAPL | Stock | 4.2839 | 4.2854 | 4.2768 | 4.2825 | 12834108.0 |
| 2007-05-31 10:35:00 | AAPL | Stock | 4.2829 | 4.2886 | 4.2814 | 4.2829 | 15321488.0 |
| 2007-05-31 10:40:00 | AAPL | Stock | 4.2835 | 4.2871 | 4.2804 | 4.2832 | 8227016.0 |
| 2007-05-31 10:45:00 | AAPL | Stock | 4.2832 | 4.2946 | 4.2825 | 4.2918 | 14153328.0 |
| 2007-05-31 10:50:00 | AAPL | Stock | 4.2914 | 4.2943 | 4.2871 | 4.29 | 9614556.0 |
| 2007-05-31 10:55:00 | AAPL | Stock | 4.29 | 4.2914 | 4.2818 | 4.2832 | 9723000.0 |
| 2007-05-31 11:00:00 | AAPL | Stock | 4.2829 | 4.2889 | 4.2807 | 4.2868 | 9256912.0 |
| 2007-05-31 11:05:00 | AAPL | Stock | 4.2868 | 4.2936 | 4.2854 | 4.2918 | 10744328.0 |
| 2007-05-31 11:10:00 | AAPL | Stock | 4.2914 | 4.2929 | 4.2886 | 4.2896 | 8884624.0 |
| 2007-05-31 11:15:00 | AAPL | Stock | 4.2896 | 4.2918 | 4.2793 | 4.2793 | 13323520.0 |
| 2007-05-31 11:20:00 | AAPL | Stock | 4.2793 | 4.2839 | 4.2771 | 4.28 | 11888744.0 |
| 2007-05-31 11:25:00 | AAPL | Stock | 4.2796 | 4.2832 | 4.2718 | 4.2757 | 10986500.0 |
| 2007-05-31 11:30:00 | AAPL | Stock | 4.2757 | 4.2907 | 4.2757 | 4.2882 | 14213612.0 |
| 2007-05-31 11:35:00 | AAPL | Stock | 4.2886 | 4.2889 | 4.2861 | 4.2879 | 3718596.0 |
| 2007-05-31 11:40:00 | AAPL | Stock | 4.2875 | 4.2921 | 4.2871 | 4.2886 | 5816188.0 |
| 2007-05-31 11:45:00 | AAPL | Stock | 4.2882 | 4.2925 | 4.2861 | 4.2904 | 7015820.0 |
| 2007-05-31 11:50:00 | AAPL | Stock | 4.2911 | 4.3029 | 4.2904 | 4.3004 | 13327692.0 |
| 2007-05-31 11:55:00 | AAPL | Stock | 4.3008 | 4.3018 | 4.2964 | 4.2979 | 6106240.0 |
| 2007-05-31 12:00:00 | AAPL | Stock | 4.2979 | 4.3007 | 4.2911 | 4.2925 | 10212524.0 |
| 2007-05-31 12:05:00 | AAPL | Stock | 4.2925 | 4.2968 | 4.2911 | 4.2961 | 6425020.0 |
| 2007-05-31 12:10:00 | AAPL | Stock | 4.2961 | 4.3057 | 4.2957 | 4.3057 | 11931612.0 |
| 2007-05-31 12:15:00 | AAPL | Stock | 4.3057 | 4.3254 | 4.3054 | 4.3243 | 29078308.0 |
| 2007-05-31 12:20:00 | AAPL | Stock | 4.3239 | 4.3304 | 4.3207 | 4.33 | 23406180.0 |
| 2007-05-31 12:25:00 | AAPL | Stock | 4.3284 | 4.3421 | 4.3282 | 4.3382 | 23124864.0 |
| 2007-05-31 12:30:00 | AAPL | Stock | 4.3382 | 4.3411 | 4.3346 | 4.3386 | 20877164.0 |
| 2007-05-31 12:35:00 | AAPL | Stock | 4.3386 | 4.3586 | 4.3386 | 4.3493 | 32235392.0 |
| 2007-05-31 12:40:00 | AAPL | Stock | 4.3496 | 4.3632 | 4.3493 | 4.3592 | 21486024.0 |
| 2007-05-31 12:45:00 | AAPL | Stock | 4.3593 | 4.3618 | 4.3507 | 4.3536 | 16218384.0 |
| 2007-05-31 12:50:00 | AAPL | Stock | 4.3536 | 4.355 | 4.3411 | 4.3421 | 15553160.0 |
| 2007-05-31 12:55:00 | AAPL | Stock | 4.3421 | 4.3479 | 4.3419 | 4.3445 | 8375864.0 |
| 2007-05-31 13:00:00 | AAPL | Stock | 4.3443 | 4.3525 | 4.3261 | 4.3329 | 19490156.0 |
| 2007-05-31 13:05:00 | AAPL | Stock | 4.3336 | 4.3554 | 4.3189 | 4.3225 | 17982636.0 |
| 2007-05-31 13:10:00 | AAPL | Stock | 4.3229 | 4.3314 | 4.3193 | 4.3271 | 12272848.0 |
| 2007-05-31 13:15:00 | AAPL | Stock | 4.3275 | 4.3354 | 4.3254 | 4.3293 | 8566180.0 |
| 2007-05-31 13:20:00 | AAPL | Stock | 4.33 | 4.3304 | 4.3161 | 4.3211 | 11526788.0 |
| 2007-05-31 13:25:00 | AAPL | Stock | 4.3211 | 4.3218 | 4.3079 | 4.3171 | 19016060.0 |
| 2007-05-31 13:30:00 | AAPL | Stock | 4.3175 | 4.3214 | 4.3089 | 4.3196 | 10553732.0 |
| 2007-05-31 13:35:00 | AAPL | Stock | 4.3196 | 4.32 | 4.3104 | 4.3132 | 8553916.0 |
> showing 50 of 294,410 rows — these rows as CSV