PREVIEW / stock_5min / 2005-05-06
file: by_date/stock_5min/2005/2005-05-06.parquet size: 2.6 MB rows: 192,738 symbols: 1,973
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-05-06 08:00:00 | AAPL | Stock | 1.3054 | 1.3054 | 1.3054 | 1.3054 | 84000.0 |
| 2005-05-06 08:10:00 | AAPL | Stock | 1.31 | 1.31 | 1.31 | 1.31 | 2800.0 |
| 2005-05-06 08:15:00 | AAPL | Stock | 1.31 | 1.31 | 1.31 | 1.31 | 14000.0 |
| 2005-05-06 08:25:00 | AAPL | Stock | 1.31 | 1.3107 | 1.31 | 1.31 | 67760.0 |
| 2005-05-06 08:30:00 | AAPL | Stock | 1.3111 | 1.3179 | 1.3111 | 1.3175 | 1343300.0 |
| 2005-05-06 08:35:00 | AAPL | Stock | 1.3171 | 1.3193 | 1.3171 | 1.3182 | 392980.0 |
| 2005-05-06 08:40:00 | AAPL | Stock | 1.3175 | 1.3196 | 1.3175 | 1.3182 | 253400.0 |
| 2005-05-06 08:45:00 | AAPL | Stock | 1.3179 | 1.3182 | 1.3175 | 1.3175 | 129192.0 |
| 2005-05-06 08:50:00 | AAPL | Stock | 1.3179 | 1.3189 | 1.3179 | 1.3189 | 42000.0 |
| 2005-05-06 08:55:00 | AAPL | Stock | 1.3189 | 1.3189 | 1.3179 | 1.3179 | 400680.0 |
| 2005-05-06 09:00:00 | AAPL | Stock | 1.3175 | 1.3189 | 1.3175 | 1.3186 | 127904.0 |
| 2005-05-06 09:05:00 | AAPL | Stock | 1.3179 | 1.3196 | 1.3179 | 1.3196 | 66612.0 |
| 2005-05-06 09:10:00 | AAPL | Stock | 1.3196 | 1.3204 | 1.3196 | 1.3196 | 319200.0 |
| 2005-05-06 09:15:00 | AAPL | Stock | 1.3186 | 1.3186 | 1.3175 | 1.3179 | 199780.0 |
| 2005-05-06 09:20:00 | AAPL | Stock | 1.3179 | 1.3179 | 1.3164 | 1.3164 | 392140.0 |
| 2005-05-06 09:25:00 | AAPL | Stock | 1.3171 | 1.3193 | 1.3146 | 1.3179 | 926268.0 |
| 2005-05-06 09:30:00 | AAPL | Stock | 1.3175 | 1.3268 | 1.3175 | 1.3214 | 16851856.0 |
| 2005-05-06 09:35:00 | AAPL | Stock | 1.3211 | 1.3236 | 1.3154 | 1.3189 | 10294592.0 |
| 2005-05-06 09:40:00 | AAPL | Stock | 1.3193 | 1.3207 | 1.3171 | 1.3189 | 6747300.0 |
| 2005-05-06 09:45:00 | AAPL | Stock | 1.3193 | 1.3204 | 1.3161 | 1.3171 | 7550368.0 |
| 2005-05-06 09:50:00 | AAPL | Stock | 1.3175 | 1.3196 | 1.3157 | 1.3179 | 7098756.0 |
| 2005-05-06 09:55:00 | AAPL | Stock | 1.3179 | 1.3196 | 1.3168 | 1.3179 | 5024768.0 |
| 2005-05-06 10:00:00 | AAPL | Stock | 1.3182 | 1.3196 | 1.3171 | 1.3193 | 3839808.0 |
| 2005-05-06 10:05:00 | AAPL | Stock | 1.3175 | 1.3196 | 1.3161 | 1.3182 | 4944744.0 |
| 2005-05-06 10:10:00 | AAPL | Stock | 1.3182 | 1.3182 | 1.3139 | 1.3161 | 5487664.0 |
| 2005-05-06 10:15:00 | AAPL | Stock | 1.3161 | 1.3182 | 1.3157 | 1.3172 | 4446736.0 |
| 2005-05-06 10:20:00 | AAPL | Stock | 1.3175 | 1.3204 | 1.3171 | 1.3204 | 4286380.0 |
| 2005-05-06 10:25:00 | AAPL | Stock | 1.3204 | 1.325 | 1.3186 | 1.3242 | 13713028.0 |
| 2005-05-06 10:30:00 | AAPL | Stock | 1.325 | 1.3268 | 1.3214 | 1.3232 | 9438464.0 |
| 2005-05-06 10:35:00 | AAPL | Stock | 1.3232 | 1.3232 | 1.3204 | 1.3218 | 5116832.0 |
| 2005-05-06 10:40:00 | AAPL | Stock | 1.3218 | 1.3232 | 1.32 | 1.32 | 5711720.0 |
| 2005-05-06 10:45:00 | AAPL | Stock | 1.32 | 1.3214 | 1.3189 | 1.3196 | 3982328.0 |
| 2005-05-06 10:50:00 | AAPL | Stock | 1.3196 | 1.3214 | 1.3179 | 1.3214 | 5353936.0 |
| 2005-05-06 10:55:00 | AAPL | Stock | 1.3211 | 1.3232 | 1.3211 | 1.3229 | 1923824.0 |
| 2005-05-06 11:00:00 | AAPL | Stock | 1.3232 | 1.3246 | 1.3214 | 1.3232 | 4953844.0 |
| 2005-05-06 11:05:00 | AAPL | Stock | 1.3232 | 1.3243 | 1.3218 | 1.3236 | 3144568.0 |
| 2005-05-06 11:10:00 | AAPL | Stock | 1.3236 | 1.324 | 1.3214 | 1.3214 | 2609460.0 |
| 2005-05-06 11:15:00 | AAPL | Stock | 1.3214 | 1.3246 | 1.3214 | 1.3243 | 2617524.0 |
| 2005-05-06 11:20:00 | AAPL | Stock | 1.3243 | 1.3246 | 1.3222 | 1.3243 | 2929304.0 |
| 2005-05-06 11:25:00 | AAPL | Stock | 1.3239 | 1.3243 | 1.3214 | 1.3214 | 2532544.0 |
| 2005-05-06 11:30:00 | AAPL | Stock | 1.3215 | 1.3243 | 1.3211 | 1.3243 | 3341408.0 |
| 2005-05-06 11:35:00 | AAPL | Stock | 1.3243 | 1.3243 | 1.3229 | 1.3239 | 1357916.0 |
| 2005-05-06 11:40:00 | AAPL | Stock | 1.3239 | 1.3243 | 1.3229 | 1.3236 | 1504720.0 |
| 2005-05-06 11:45:00 | AAPL | Stock | 1.3236 | 1.3243 | 1.3218 | 1.3232 | 2579556.0 |
| 2005-05-06 11:50:00 | AAPL | Stock | 1.3232 | 1.3239 | 1.3196 | 1.32 | 3551016.0 |
| 2005-05-06 11:55:00 | AAPL | Stock | 1.32 | 1.3204 | 1.3179 | 1.3196 | 4226040.0 |
| 2005-05-06 12:00:00 | AAPL | Stock | 1.3193 | 1.32 | 1.3168 | 1.3182 | 3252144.0 |
| 2005-05-06 12:05:00 | AAPL | Stock | 1.3182 | 1.3189 | 1.3168 | 1.3171 | 3199616.0 |
| 2005-05-06 12:10:00 | AAPL | Stock | 1.3168 | 1.3182 | 1.3154 | 1.3161 | 4709628.0 |
| 2005-05-06 12:15:00 | AAPL | Stock | 1.3161 | 1.3182 | 1.3161 | 1.3171 | 2851296.0 |
> showing 50 of 192,738 rows — these rows as CSV