PREVIEW / stock_5min / 2006-03-20
file: by_date/stock_5min/2006/2006-03-20.parquet size: 3.1 MB rows: 224,219 symbols: 2,216
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-03-20 05:10:00 | AAPL | Stock | 2.3214 | 2.3214 | 2.3214 | 2.3214 | 13608.0 |
| 2006-03-20 05:15:00 | AAPL | Stock | 2.3214 | 2.3214 | 2.3214 | 2.3214 | 2800.0 |
| 2006-03-20 06:55:00 | AAPL | Stock | 2.3214 | 2.3214 | 2.3214 | 2.3214 | 176400.0 |
| 2006-03-20 07:15:00 | AAPL | Stock | 2.325 | 2.325 | 2.325 | 2.325 | 53200.0 |
| 2006-03-20 07:20:00 | AAPL | Stock | 2.3286 | 2.3286 | 2.3286 | 2.3286 | 2800.0 |
| 2006-03-20 07:40:00 | AAPL | Stock | 2.33 | 2.3304 | 2.33 | 2.3304 | 56000.0 |
| 2006-03-20 07:50:00 | AAPL | Stock | 2.3232 | 2.3232 | 2.3232 | 2.3232 | 8400.0 |
| 2006-03-20 08:00:00 | AAPL | Stock | 2.3214 | 2.33 | 2.3214 | 2.3286 | 584472.0 |
| 2006-03-20 08:05:00 | AAPL | Stock | 2.3282 | 2.3286 | 2.325 | 2.3286 | 287280.0 |
| 2006-03-20 08:10:00 | AAPL | Stock | 2.3286 | 2.3286 | 2.3232 | 2.325 | 340816.0 |
| 2006-03-20 08:15:00 | AAPL | Stock | 2.325 | 2.3286 | 2.325 | 2.3268 | 226800.0 |
| 2006-03-20 08:20:00 | AAPL | Stock | 2.3254 | 2.3254 | 2.325 | 2.325 | 179200.0 |
| 2006-03-20 08:25:00 | AAPL | Stock | 2.3246 | 2.325 | 2.3243 | 2.325 | 304528.0 |
| 2006-03-20 08:30:00 | AAPL | Stock | 2.3232 | 2.325 | 2.3232 | 2.3232 | 11200.0 |
| 2006-03-20 08:35:00 | AAPL | Stock | 2.3236 | 2.3264 | 2.3236 | 2.3264 | 368144.0 |
| 2006-03-20 08:40:00 | AAPL | Stock | 2.3264 | 2.3264 | 2.3239 | 2.3239 | 113400.0 |
| 2006-03-20 08:45:00 | AAPL | Stock | 2.3246 | 2.3257 | 2.3229 | 2.3229 | 224000.0 |
| 2006-03-20 08:50:00 | AAPL | Stock | 2.3218 | 2.3232 | 2.3218 | 2.3229 | 116424.0 |
| 2006-03-20 08:55:00 | AAPL | Stock | 2.3232 | 2.3246 | 2.3225 | 2.3246 | 225820.0 |
| 2006-03-20 09:00:00 | AAPL | Stock | 2.3246 | 2.3264 | 2.3236 | 2.325 | 151200.0 |
| 2006-03-20 09:05:00 | AAPL | Stock | 2.325 | 2.3268 | 2.3239 | 2.325 | 277200.0 |
| 2006-03-20 09:10:00 | AAPL | Stock | 2.325 | 2.325 | 2.32 | 2.32 | 360472.0 |
| 2006-03-20 09:15:00 | AAPL | Stock | 2.3207 | 2.325 | 2.3207 | 2.325 | 124600.0 |
| 2006-03-20 09:20:00 | AAPL | Stock | 2.3246 | 2.3325 | 2.3243 | 2.3325 | 1316532.0 |
| 2006-03-20 09:25:00 | AAPL | Stock | 2.3325 | 2.3325 | 2.3286 | 2.3289 | 1873200.0 |
| 2006-03-20 09:30:00 | AAPL | Stock | 2.3293 | 2.3379 | 2.3264 | 2.3286 | 27878060.0 |
| 2006-03-20 09:35:00 | AAPL | Stock | 2.3286 | 2.3357 | 2.3243 | 2.3275 | 24054940.0 |
| 2006-03-20 09:40:00 | AAPL | Stock | 2.3271 | 2.3339 | 2.3229 | 2.3296 | 23269820.0 |
| 2006-03-20 09:45:00 | AAPL | Stock | 2.3293 | 2.3332 | 2.3225 | 2.3229 | 12514740.0 |
| 2006-03-20 09:50:00 | AAPL | Stock | 2.3229 | 2.3257 | 2.3175 | 2.3221 | 14096628.0 |
| 2006-03-20 09:55:00 | AAPL | Stock | 2.3221 | 2.3232 | 2.3154 | 2.3154 | 11765068.0 |
| 2006-03-20 10:00:00 | AAPL | Stock | 2.3154 | 2.3175 | 2.3111 | 2.3136 | 13326124.0 |
| 2006-03-20 10:05:00 | AAPL | Stock | 2.3139 | 2.3179 | 2.3082 | 2.3114 | 11085900.0 |
| 2006-03-20 10:10:00 | AAPL | Stock | 2.3118 | 2.3143 | 2.3086 | 2.3125 | 8544648.0 |
| 2006-03-20 10:15:00 | AAPL | Stock | 2.3121 | 2.3182 | 2.31 | 2.3146 | 9036580.0 |
| 2006-03-20 10:20:00 | AAPL | Stock | 2.3146 | 2.3175 | 2.3114 | 2.3175 | 8439340.0 |
| 2006-03-20 10:25:00 | AAPL | Stock | 2.3179 | 2.3196 | 2.3096 | 2.3121 | 12953416.0 |
| 2006-03-20 10:30:00 | AAPL | Stock | 2.3125 | 2.3154 | 2.3032 | 2.3043 | 12938660.0 |
| 2006-03-20 10:35:00 | AAPL | Stock | 2.3043 | 2.3129 | 2.3036 | 2.31 | 7745052.0 |
| 2006-03-20 10:40:00 | AAPL | Stock | 2.31 | 2.3114 | 2.3011 | 2.3036 | 6145160.0 |
| 2006-03-20 10:45:00 | AAPL | Stock | 2.3029 | 2.305 | 2.2871 | 2.2904 | 20062504.0 |
| 2006-03-20 10:50:00 | AAPL | Stock | 2.2904 | 2.2946 | 2.2875 | 2.2946 | 12538792.0 |
| 2006-03-20 10:55:00 | AAPL | Stock | 2.2946 | 2.2979 | 2.2911 | 2.295 | 8034628.0 |
| 2006-03-20 11:00:00 | AAPL | Stock | 2.295 | 2.3282 | 2.2946 | 2.2975 | 7821044.0 |
| 2006-03-20 11:05:00 | AAPL | Stock | 2.2979 | 2.3046 | 2.2957 | 2.3018 | 5305132.0 |
| 2006-03-20 11:10:00 | AAPL | Stock | 2.3014 | 2.3054 | 2.2993 | 2.3036 | 5641972.0 |
| 2006-03-20 11:15:00 | AAPL | Stock | 2.305 | 2.3096 | 2.3021 | 2.3064 | 8467172.0 |
| 2006-03-20 11:20:00 | AAPL | Stock | 2.3064 | 2.3107 | 2.3036 | 2.3082 | 7970704.0 |
| 2006-03-20 11:25:00 | AAPL | Stock | 2.3082 | 2.31 | 2.3043 | 2.3057 | 5486152.0 |
| 2006-03-20 11:30:00 | AAPL | Stock | 2.3064 | 2.3075 | 2.3004 | 2.3032 | 4297888.0 |
> showing 50 of 224,219 rows — these rows as CSV