PREVIEW / stock_5min / 2010-08-09
file: by_date/stock_5min/2010/2010-08-09.parquet size: 4.5 MB rows: 315,497 symbols: 3,491
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-09 06:25:00 | AAPL | Stock | 9.2964 | 9.2964 | 9.2964 | 9.2964 | 2800.0 |
| 2010-08-09 06:35:00 | AAPL | Stock | 9.2607 | 9.2607 | 9.2607 | 9.2607 | 2800.0 |
| 2010-08-09 06:55:00 | AAPL | Stock | 9.2821 | 9.2821 | 9.2821 | 9.2821 | 14000.0 |
| 2010-08-09 07:00:00 | AAPL | Stock | 9.2611 | 9.2611 | 9.2589 | 9.2589 | 30800.0 |
| 2010-08-09 07:10:00 | AAPL | Stock | 9.2611 | 9.2746 | 9.2575 | 9.2575 | 14000.0 |
| 2010-08-09 07:30:00 | AAPL | Stock | 9.2714 | 9.2714 | 9.2714 | 9.2714 | 14000.0 |
| 2010-08-09 07:35:00 | AAPL | Stock | 9.2657 | 9.2814 | 9.2657 | 9.2811 | 8400.0 |
| 2010-08-09 07:40:00 | AAPL | Stock | 9.28 | 9.2821 | 9.2786 | 9.2786 | 53592.0 |
| 2010-08-09 07:50:00 | AAPL | Stock | 9.2854 | 9.3071 | 9.2854 | 9.3071 | 143304.0 |
| 2010-08-09 07:55:00 | AAPL | Stock | 9.3071 | 9.3143 | 9.3071 | 9.3079 | 57008.0 |
| 2010-08-09 08:00:00 | AAPL | Stock | 9.3132 | 9.3229 | 9.3089 | 9.3229 | 254548.0 |
| 2010-08-09 08:05:00 | AAPL | Stock | 9.3196 | 9.3286 | 9.3168 | 9.3261 | 163632.0 |
| 2010-08-09 08:10:00 | AAPL | Stock | 9.3286 | 9.335 | 9.3221 | 9.3304 | 264852.0 |
| 2010-08-09 08:15:00 | AAPL | Stock | 9.33 | 9.33 | 9.3229 | 9.33 | 59640.0 |
| 2010-08-09 08:20:00 | AAPL | Stock | 9.3268 | 9.3268 | 9.3214 | 9.3232 | 167580.0 |
| 2010-08-09 08:25:00 | AAPL | Stock | 9.3239 | 9.3268 | 9.3182 | 9.3182 | 163324.0 |
| 2010-08-09 08:30:00 | AAPL | Stock | 9.3218 | 9.3218 | 9.3168 | 9.3196 | 123116.0 |
| 2010-08-09 08:35:00 | AAPL | Stock | 9.3193 | 9.3229 | 9.3193 | 9.3229 | 79240.0 |
| 2010-08-09 08:40:00 | AAPL | Stock | 9.3239 | 9.3282 | 9.3239 | 9.3261 | 175728.0 |
| 2010-08-09 08:45:00 | AAPL | Stock | 9.3254 | 9.3279 | 9.3254 | 9.3264 | 110712.0 |
| 2010-08-09 08:50:00 | AAPL | Stock | 9.325 | 9.3254 | 9.3193 | 9.3193 | 177492.0 |
| 2010-08-09 08:55:00 | AAPL | Stock | 9.3179 | 9.3189 | 9.3164 | 9.3179 | 81228.0 |
| 2010-08-09 09:00:00 | AAPL | Stock | 9.3179 | 9.3214 | 9.3171 | 9.3214 | 219940.0 |
| 2010-08-09 09:05:00 | AAPL | Stock | 9.3207 | 9.3268 | 9.3207 | 9.3211 | 234584.0 |
| 2010-08-09 09:10:00 | AAPL | Stock | 9.3214 | 9.3286 | 9.3211 | 9.3268 | 94192.0 |
| 2010-08-09 09:15:00 | AAPL | Stock | 9.3264 | 9.3286 | 9.3182 | 9.3211 | 89600.0 |
| 2010-08-09 09:20:00 | AAPL | Stock | 9.3179 | 9.3264 | 9.3143 | 9.3236 | 255444.0 |
| 2010-08-09 09:25:00 | AAPL | Stock | 9.3236 | 9.3375 | 9.3225 | 9.3354 | 361536.0 |
| 2010-08-09 09:30:00 | AAPL | Stock | 9.3371 | 9.3393 | 9.3064 | 9.3107 | 8953000.0 |
| 2010-08-09 09:35:00 | AAPL | Stock | 9.3118 | 9.3296 | 9.2964 | 9.3164 | 7031976.0 |
| 2010-08-09 09:40:00 | AAPL | Stock | 9.3172 | 9.3189 | 9.2946 | 9.3007 | 6094144.0 |
| 2010-08-09 09:45:00 | AAPL | Stock | 9.3 | 9.3014 | 9.275 | 9.2886 | 8451016.0 |
| 2010-08-09 09:50:00 | AAPL | Stock | 9.2889 | 9.3004 | 9.2829 | 9.295 | 5443116.0 |
| 2010-08-09 09:55:00 | AAPL | Stock | 9.2964 | 9.2964 | 9.2796 | 9.2943 | 5779564.0 |
| 2010-08-09 10:00:00 | AAPL | Stock | 9.2946 | 9.3171 | 9.2929 | 9.3057 | 6724228.0 |
| 2010-08-09 10:05:00 | AAPL | Stock | 9.3057 | 9.3186 | 9.3057 | 9.3154 | 4471068.0 |
| 2010-08-09 10:10:00 | AAPL | Stock | 9.3161 | 9.3321 | 9.3154 | 9.3207 | 6865040.0 |
| 2010-08-09 10:15:00 | AAPL | Stock | 9.3196 | 9.325 | 9.3064 | 9.3084 | 6548948.0 |
| 2010-08-09 10:20:00 | AAPL | Stock | 9.3068 | 9.3125 | 9.2989 | 9.3007 | 4979380.0 |
| 2010-08-09 10:25:00 | AAPL | Stock | 9.3002 | 9.3011 | 9.2893 | 9.2914 | 3827488.0 |
| 2010-08-09 10:30:00 | AAPL | Stock | 9.2921 | 9.3036 | 9.2921 | 9.3004 | 2416876.0 |
| 2010-08-09 10:35:00 | AAPL | Stock | 9.3014 | 9.3114 | 9.2907 | 9.2957 | 3037720.0 |
| 2010-08-09 10:40:00 | AAPL | Stock | 9.2954 | 9.3071 | 9.2954 | 9.2989 | 1992956.0 |
| 2010-08-09 10:45:00 | AAPL | Stock | 9.3 | 9.3036 | 9.2944 | 9.2944 | 1773940.0 |
| 2010-08-09 10:50:00 | AAPL | Stock | 9.2943 | 9.2975 | 9.2786 | 9.28 | 5692680.0 |
| 2010-08-09 10:55:00 | AAPL | Stock | 9.28 | 9.2893 | 9.2704 | 9.2796 | 6121052.0 |
| 2010-08-09 11:00:00 | AAPL | Stock | 9.2807 | 9.2871 | 9.2782 | 9.2853 | 2847880.0 |
| 2010-08-09 11:05:00 | AAPL | Stock | 9.2853 | 9.2914 | 9.2814 | 9.2894 | 2500736.0 |
| 2010-08-09 11:10:00 | AAPL | Stock | 9.2911 | 9.2982 | 9.2905 | 9.2968 | 2395456.0 |
| 2010-08-09 11:15:00 | AAPL | Stock | 9.2979 | 9.305 | 9.2964 | 9.3039 | 3227196.0 |
> showing 50 of 315,497 rows — these rows as CSV