PREVIEW / stock_5min / 2005-11-18
file: by_date/stock_5min/2005/2005-11-18.parquet size: 2.9 MB rows: 208,922 symbols: 2,116
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-11-18 07:55:00 | AAPL | Stock | 2.3139 | 2.3139 | 2.3139 | 2.3139 | 8400.0 |
| 2005-11-18 08:00:00 | AAPL | Stock | 2.3211 | 2.3214 | 2.3161 | 2.3214 | 273000.0 |
| 2005-11-18 08:05:00 | AAPL | Stock | 2.3179 | 2.3179 | 2.3161 | 2.3161 | 33880.0 |
| 2005-11-18 08:10:00 | AAPL | Stock | 2.3161 | 2.3179 | 2.3146 | 2.3146 | 80752.0 |
| 2005-11-18 08:15:00 | AAPL | Stock | 2.3171 | 2.3171 | 2.3136 | 2.315 | 175280.0 |
| 2005-11-18 08:20:00 | AAPL | Stock | 2.3189 | 2.3189 | 2.3161 | 2.3179 | 91700.0 |
| 2005-11-18 08:25:00 | AAPL | Stock | 2.3182 | 2.3182 | 2.3179 | 2.3179 | 42756.0 |
| 2005-11-18 08:30:00 | AAPL | Stock | 2.3193 | 2.3214 | 2.3193 | 2.3214 | 310800.0 |
| 2005-11-18 08:35:00 | AAPL | Stock | 2.3204 | 2.3221 | 2.3204 | 2.3214 | 283528.0 |
| 2005-11-18 08:40:00 | AAPL | Stock | 2.3221 | 2.3279 | 2.3214 | 2.3275 | 364980.0 |
| 2005-11-18 08:45:00 | AAPL | Stock | 2.3275 | 2.3279 | 2.3257 | 2.3275 | 327600.0 |
| 2005-11-18 08:50:00 | AAPL | Stock | 2.3279 | 2.3279 | 2.325 | 2.325 | 254520.0 |
| 2005-11-18 08:55:00 | AAPL | Stock | 2.3246 | 2.3246 | 2.3236 | 2.3236 | 135520.0 |
| 2005-11-18 09:00:00 | AAPL | Stock | 2.3236 | 2.3243 | 2.3236 | 2.3243 | 57960.0 |
| 2005-11-18 09:05:00 | AAPL | Stock | 2.3232 | 2.3257 | 2.3232 | 2.325 | 344400.0 |
| 2005-11-18 09:10:00 | AAPL | Stock | 2.3243 | 2.3243 | 2.3193 | 2.3214 | 238420.0 |
| 2005-11-18 09:15:00 | AAPL | Stock | 2.3232 | 2.3232 | 2.3214 | 2.3214 | 42000.0 |
| 2005-11-18 09:20:00 | AAPL | Stock | 2.32 | 2.3268 | 2.32 | 2.3264 | 173320.0 |
| 2005-11-18 09:25:00 | AAPL | Stock | 2.325 | 2.3364 | 2.3214 | 2.3364 | 4976356.0 |
| 2005-11-18 09:30:00 | AAPL | Stock | 2.3325 | 2.3368 | 2.315 | 2.32 | 49179424.0 |
| 2005-11-18 09:35:00 | AAPL | Stock | 2.3196 | 2.3332 | 2.3182 | 2.3296 | 15878128.0 |
| 2005-11-18 09:40:00 | AAPL | Stock | 2.3296 | 2.3314 | 2.3261 | 2.3282 | 9019360.0 |
| 2005-11-18 09:45:00 | AAPL | Stock | 2.3286 | 2.3292 | 2.3207 | 2.3257 | 15586844.0 |
| 2005-11-18 09:50:00 | AAPL | Stock | 2.3257 | 2.3257 | 2.3196 | 2.3239 | 8616692.0 |
| 2005-11-18 09:55:00 | AAPL | Stock | 2.3243 | 2.325 | 2.3182 | 2.3211 | 10251556.0 |
| 2005-11-18 10:00:00 | AAPL | Stock | 2.3221 | 2.3261 | 2.3204 | 2.3225 | 11010692.0 |
| 2005-11-18 10:05:00 | AAPL | Stock | 2.3225 | 2.3293 | 2.3214 | 2.3254 | 9943808.0 |
| 2005-11-18 10:10:00 | AAPL | Stock | 2.3254 | 2.3257 | 2.3179 | 2.32 | 8316420.0 |
| 2005-11-18 10:15:00 | AAPL | Stock | 2.32 | 2.3232 | 2.3161 | 2.3168 | 10161872.0 |
| 2005-11-18 10:20:00 | AAPL | Stock | 2.3171 | 2.3189 | 2.3143 | 2.3189 | 5936336.0 |
| 2005-11-18 10:25:00 | AAPL | Stock | 2.3189 | 2.3214 | 2.3179 | 2.3193 | 3604188.0 |
| 2005-11-18 10:30:00 | AAPL | Stock | 2.3193 | 2.3232 | 2.3189 | 2.3211 | 6706812.0 |
| 2005-11-18 10:35:00 | AAPL | Stock | 2.3211 | 2.3232 | 2.3107 | 2.3118 | 8739948.0 |
| 2005-11-18 10:40:00 | AAPL | Stock | 2.3118 | 2.3143 | 2.3018 | 2.3029 | 12815992.0 |
| 2005-11-18 10:45:00 | AAPL | Stock | 2.3025 | 2.3125 | 2.3021 | 2.3086 | 9918972.0 |
| 2005-11-18 10:50:00 | AAPL | Stock | 2.3082 | 2.3129 | 2.3082 | 2.3086 | 5819912.0 |
| 2005-11-18 10:55:00 | AAPL | Stock | 2.3089 | 2.3093 | 2.3025 | 2.3064 | 9512692.0 |
| 2005-11-18 11:00:00 | AAPL | Stock | 2.3064 | 2.3082 | 2.2989 | 2.2993 | 4984028.0 |
| 2005-11-18 11:05:00 | AAPL | Stock | 2.2996 | 2.3086 | 2.2989 | 2.3071 | 6193824.0 |
| 2005-11-18 11:10:00 | AAPL | Stock | 2.3071 | 2.3143 | 2.3071 | 2.3118 | 6012580.0 |
| 2005-11-18 11:15:00 | AAPL | Stock | 2.3121 | 2.3157 | 2.3114 | 2.3136 | 6143480.0 |
| 2005-11-18 11:20:00 | AAPL | Stock | 2.3136 | 2.315 | 2.31 | 2.3104 | 3124492.0 |
| 2005-11-18 11:25:00 | AAPL | Stock | 2.3104 | 2.3107 | 2.3046 | 2.3071 | 4794104.0 |
| 2005-11-18 11:30:00 | AAPL | Stock | 2.3079 | 2.3104 | 2.3039 | 2.3039 | 3174052.0 |
| 2005-11-18 11:35:00 | AAPL | Stock | 2.3039 | 2.3082 | 2.3036 | 2.3046 | 5433456.0 |
| 2005-11-18 11:40:00 | AAPL | Stock | 2.3046 | 2.3093 | 2.3039 | 2.3071 | 4013744.0 |
| 2005-11-18 11:45:00 | AAPL | Stock | 2.3071 | 2.3104 | 2.305 | 2.3104 | 4347364.0 |
| 2005-11-18 11:50:00 | AAPL | Stock | 2.3104 | 2.3118 | 2.3082 | 2.3104 | 4886084.0 |
| 2005-11-18 11:55:00 | AAPL | Stock | 2.3107 | 2.3129 | 2.3086 | 2.3125 | 4684904.0 |
| 2005-11-18 12:00:00 | AAPL | Stock | 2.3125 | 2.3129 | 2.3093 | 2.31 | 3173828.0 |
> showing 50 of 208,922 rows — these rows as CSV