PREVIEW / stock_5min / 2007-06-12
file: by_date/stock_5min/2007/2007-06-12.parquet size: 4.0 MB rows: 295,545 symbols: 3,026
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-06-12 09:30:00 | AAPL | Stock | 4.2625 | 4.2768 | 4.2254 | 4.2496 | 70017780.0 |
| 2007-06-12 09:35:00 | AAPL | Stock | 4.2489 | 4.29 | 4.2429 | 4.2693 | 48350204.0 |
| 2007-06-12 09:40:00 | AAPL | Stock | 4.2693 | 4.2871 | 4.2607 | 4.2861 | 34508572.0 |
| 2007-06-12 09:45:00 | AAPL | Stock | 4.2862 | 4.3121 | 4.2821 | 4.3054 | 47099024.0 |
| 2007-06-12 09:50:00 | AAPL | Stock | 4.305 | 4.3054 | 4.2964 | 4.2982 | 34858852.0 |
| 2007-06-12 09:55:00 | AAPL | Stock | 4.2982 | 4.3018 | 4.2779 | 4.2829 | 37402792.0 |
| 2007-06-12 10:00:00 | AAPL | Stock | 4.2832 | 4.2982 | 4.2796 | 4.2968 | 26518464.0 |
| 2007-06-12 10:05:00 | AAPL | Stock | 4.2968 | 4.3243 | 4.2957 | 4.3218 | 42304108.0 |
| 2007-06-12 10:10:00 | AAPL | Stock | 4.3218 | 4.3314 | 4.3071 | 4.3136 | 30383612.0 |
| 2007-06-12 10:15:00 | AAPL | Stock | 4.3136 | 4.3179 | 4.2996 | 4.3043 | 25886028.0 |
| 2007-06-12 10:20:00 | AAPL | Stock | 4.3043 | 4.3125 | 4.2857 | 4.3111 | 25158448.0 |
| 2007-06-12 10:25:00 | AAPL | Stock | 4.3111 | 4.3229 | 4.3036 | 4.3054 | 24587248.0 |
| 2007-06-12 10:30:00 | AAPL | Stock | 4.3054 | 4.3118 | 4.2857 | 4.2879 | 27060964.0 |
| 2007-06-12 10:35:00 | AAPL | Stock | 4.2886 | 4.3004 | 4.2836 | 4.2982 | 22959384.0 |
| 2007-06-12 10:40:00 | AAPL | Stock | 4.2982 | 4.3082 | 4.2857 | 4.2979 | 17939852.0 |
| 2007-06-12 10:45:00 | AAPL | Stock | 4.2979 | 4.3014 | 4.2882 | 4.2974 | 11802084.0 |
| 2007-06-12 10:50:00 | AAPL | Stock | 4.2972 | 4.3032 | 4.2886 | 4.2889 | 12282452.0 |
| 2007-06-12 10:55:00 | AAPL | Stock | 4.2889 | 4.2943 | 4.2843 | 4.2886 | 13633928.0 |
| 2007-06-12 11:00:00 | AAPL | Stock | 4.2886 | 4.3007 | 4.2843 | 4.2907 | 15509928.0 |
| 2007-06-12 11:05:00 | AAPL | Stock | 4.2907 | 4.2911 | 4.2629 | 4.2762 | 30868656.0 |
| 2007-06-12 11:10:00 | AAPL | Stock | 4.2761 | 4.2821 | 4.2679 | 4.2818 | 16152332.0 |
| 2007-06-12 11:15:00 | AAPL | Stock | 4.2818 | 4.2943 | 4.2739 | 4.2925 | 16047640.0 |
| 2007-06-12 11:20:00 | AAPL | Stock | 4.2925 | 4.2957 | 4.2882 | 4.2921 | 9726892.0 |
| 2007-06-12 11:25:00 | AAPL | Stock | 4.2921 | 4.2989 | 4.2904 | 4.2925 | 11713100.0 |
| 2007-06-12 11:30:00 | AAPL | Stock | 4.2921 | 4.3068 | 4.2918 | 4.2961 | 14620816.0 |
| 2007-06-12 11:35:00 | AAPL | Stock | 4.2961 | 4.3046 | 4.2954 | 4.3039 | 9269596.0 |
| 2007-06-12 11:40:00 | AAPL | Stock | 4.3036 | 4.3064 | 4.2961 | 4.2989 | 13746264.0 |
| 2007-06-12 11:45:00 | AAPL | Stock | 4.2989 | 4.3082 | 4.2968 | 4.2978 | 10166632.0 |
| 2007-06-12 11:50:00 | AAPL | Stock | 4.2979 | 4.3025 | 4.2964 | 4.3018 | 7941276.0 |
| 2007-06-12 11:55:00 | AAPL | Stock | 4.3018 | 4.3214 | 4.3005 | 4.3207 | 18134144.0 |
| 2007-06-12 12:00:00 | AAPL | Stock | 4.3211 | 4.3236 | 4.3093 | 4.3136 | 18255888.0 |
| 2007-06-12 12:05:00 | AAPL | Stock | 4.3132 | 4.3196 | 4.3082 | 4.3161 | 12088020.0 |
| 2007-06-12 12:10:00 | AAPL | Stock | 4.3161 | 4.3214 | 4.3125 | 4.3214 | 13934004.0 |
| 2007-06-12 12:15:00 | AAPL | Stock | 4.3214 | 4.3357 | 4.3193 | 4.3329 | 24103408.0 |
| 2007-06-12 12:20:00 | AAPL | Stock | 4.3332 | 4.3407 | 4.3257 | 4.3296 | 20180104.0 |
| 2007-06-12 12:25:00 | AAPL | Stock | 4.3293 | 4.3321 | 4.3164 | 4.3246 | 11969384.0 |
| 2007-06-12 12:30:00 | AAPL | Stock | 4.3246 | 4.3246 | 4.3129 | 4.3189 | 13468112.0 |
| 2007-06-12 12:35:00 | AAPL | Stock | 4.3189 | 4.3254 | 4.3164 | 4.3221 | 10349836.0 |
| 2007-06-12 12:40:00 | AAPL | Stock | 4.3225 | 4.325 | 4.3125 | 4.3204 | 8771252.0 |
| 2007-06-12 12:45:00 | AAPL | Stock | 4.3204 | 4.3229 | 4.3175 | 4.3186 | 6174336.0 |
| 2007-06-12 12:50:00 | AAPL | Stock | 4.3186 | 4.3214 | 4.3061 | 4.3061 | 8673224.0 |
| 2007-06-12 12:55:00 | AAPL | Stock | 4.3071 | 4.3125 | 4.3057 | 4.3121 | 6041056.0 |
| 2007-06-12 13:00:00 | AAPL | Stock | 4.3118 | 4.3121 | 4.2971 | 4.3079 | 12440764.0 |
| 2007-06-12 13:05:00 | AAPL | Stock | 4.3079 | 4.3111 | 4.2979 | 4.3086 | 10696700.0 |
| 2007-06-12 13:10:00 | AAPL | Stock | 4.3089 | 4.3211 | 4.3082 | 4.3139 | 10116148.0 |
| 2007-06-12 13:15:00 | AAPL | Stock | 4.3139 | 4.3246 | 4.3139 | 4.3182 | 10295600.0 |
| 2007-06-12 13:20:00 | AAPL | Stock | 4.3179 | 4.3225 | 4.3111 | 4.315 | 8013628.0 |
| 2007-06-12 13:25:00 | AAPL | Stock | 4.315 | 4.3171 | 4.3096 | 4.315 | 5321120.0 |
| 2007-06-12 13:30:00 | AAPL | Stock | 4.3154 | 4.3157 | 4.305 | 4.3143 | 5244484.0 |
| 2007-06-12 13:35:00 | AAPL | Stock | 4.3136 | 4.3225 | 4.31 | 4.3225 | 7722008.0 |
> showing 50 of 295,545 rows — these rows as CSV