PREVIEW / stock_5min / 2002-06-28
file: by_date/stock_5min/2002/2002-06-28.parquet size: 2.2 MB rows: 153,801 symbols: 1,452
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 |
|---|---|---|---|---|---|---|---|
| 2002-06-28 08:00:00 | AAPL | Stock | 0.3048 | 0.3048 | 0.3048 | 0.3048 | 44800.0 |
| 2002-06-28 09:20:00 | AAPL | Stock | 0.3043 | 0.3043 | 0.303 | 0.303 | 196000.0 |
| 2002-06-28 09:25:00 | AAPL | Stock | 0.3036 | 0.3054 | 0.3036 | 0.3052 | 509600.0 |
| 2002-06-28 09:30:00 | AAPL | Stock | 0.3054 | 0.3091 | 0.3038 | 0.3091 | 7576800.0 |
| 2002-06-28 09:35:00 | AAPL | Stock | 0.3095 | 0.3107 | 0.3075 | 0.3107 | 3404800.0 |
| 2002-06-28 09:40:00 | AAPL | Stock | 0.3109 | 0.3129 | 0.3107 | 0.3129 | 5555200.0 |
| 2002-06-28 09:45:00 | AAPL | Stock | 0.3129 | 0.3138 | 0.3116 | 0.3116 | 4457600.0 |
| 2002-06-28 09:50:00 | AAPL | Stock | 0.3125 | 0.3127 | 0.3107 | 0.3107 | 1976800.0 |
| 2002-06-28 09:55:00 | AAPL | Stock | 0.3107 | 0.3121 | 0.3102 | 0.3114 | 1388800.0 |
| 2002-06-28 10:00:00 | AAPL | Stock | 0.3107 | 0.3121 | 0.3098 | 0.3109 | 3444000.0 |
| 2002-06-28 10:05:00 | AAPL | Stock | 0.3109 | 0.3118 | 0.3095 | 0.31 | 1282400.0 |
| 2002-06-28 10:10:00 | AAPL | Stock | 0.3102 | 0.3125 | 0.3102 | 0.3125 | 2055200.0 |
| 2002-06-28 10:15:00 | AAPL | Stock | 0.3125 | 0.3143 | 0.3111 | 0.3143 | 2749600.0 |
| 2002-06-28 10:20:00 | AAPL | Stock | 0.3138 | 0.3152 | 0.3134 | 0.3136 | 1489600.0 |
| 2002-06-28 10:25:00 | AAPL | Stock | 0.3136 | 0.3138 | 0.3125 | 0.3129 | 3903200.0 |
| 2002-06-28 10:30:00 | AAPL | Stock | 0.3129 | 0.3141 | 0.3125 | 0.3139 | 1545600.0 |
| 2002-06-28 10:35:00 | AAPL | Stock | 0.3138 | 0.3146 | 0.312 | 0.3122 | 4278400.0 |
| 2002-06-28 10:40:00 | AAPL | Stock | 0.3123 | 0.3136 | 0.3107 | 0.3107 | 3651200.0 |
| 2002-06-28 10:45:00 | AAPL | Stock | 0.3109 | 0.3111 | 0.3095 | 0.3098 | 2128000.0 |
| 2002-06-28 10:50:00 | AAPL | Stock | 0.3098 | 0.3098 | 0.3077 | 0.3086 | 3561600.0 |
| 2002-06-28 10:55:00 | AAPL | Stock | 0.3095 | 0.31 | 0.3086 | 0.3093 | 795200.0 |
| 2002-06-28 11:00:00 | AAPL | Stock | 0.3096 | 0.3104 | 0.3091 | 0.3095 | 2335200.0 |
| 2002-06-28 11:05:00 | AAPL | Stock | 0.3098 | 0.3098 | 0.3089 | 0.3095 | 1024800.0 |
| 2002-06-28 11:10:00 | AAPL | Stock | 0.3093 | 0.3098 | 0.3089 | 0.3089 | 1400000.0 |
| 2002-06-28 11:15:00 | AAPL | Stock | 0.3089 | 0.3113 | 0.3089 | 0.3111 | 3292800.0 |
| 2002-06-28 11:20:00 | AAPL | Stock | 0.3111 | 0.3114 | 0.3104 | 0.3104 | 1187200.0 |
| 2002-06-28 11:25:00 | AAPL | Stock | 0.3102 | 0.3114 | 0.31 | 0.3109 | 2284800.0 |
| 2002-06-28 11:30:00 | AAPL | Stock | 0.3105 | 0.3113 | 0.3104 | 0.3107 | 2402400.0 |
| 2002-06-28 11:35:00 | AAPL | Stock | 0.3107 | 0.3111 | 0.3105 | 0.3105 | 1439200.0 |
| 2002-06-28 11:40:00 | AAPL | Stock | 0.3105 | 0.3107 | 0.3095 | 0.3098 | 1629600.0 |
| 2002-06-28 11:45:00 | AAPL | Stock | 0.3099 | 0.3107 | 0.3099 | 0.3105 | 7868000.0 |
| 2002-06-28 11:50:00 | AAPL | Stock | 0.3107 | 0.3109 | 0.3107 | 0.3107 | 957600.0 |
| 2002-06-28 11:55:00 | AAPL | Stock | 0.3105 | 0.3107 | 0.3105 | 0.3105 | 1220800.0 |
| 2002-06-28 12:00:00 | AAPL | Stock | 0.3107 | 0.3113 | 0.3105 | 0.3109 | 991200.0 |
| 2002-06-28 12:05:00 | AAPL | Stock | 0.3113 | 0.3113 | 0.3109 | 0.3111 | 285600.0 |
| 2002-06-28 12:10:00 | AAPL | Stock | 0.3111 | 0.3127 | 0.3109 | 0.3127 | 4043200.0 |
| 2002-06-28 12:15:00 | AAPL | Stock | 0.3127 | 0.315 | 0.3112 | 0.3143 | 12012000.0 |
| 2002-06-28 12:20:00 | AAPL | Stock | 0.3143 | 0.3155 | 0.3141 | 0.3152 | 9217600.0 |
| 2002-06-28 12:25:00 | AAPL | Stock | 0.3152 | 0.3161 | 0.3143 | 0.3157 | 3264800.0 |
| 2002-06-28 12:30:00 | AAPL | Stock | 0.3159 | 0.3179 | 0.3159 | 0.3171 | 2889600.0 |
| 2002-06-28 12:35:00 | AAPL | Stock | 0.3166 | 0.3177 | 0.3163 | 0.317 | 2889600.0 |
| 2002-06-28 12:40:00 | AAPL | Stock | 0.317 | 0.3171 | 0.3161 | 0.3166 | 604800.0 |
| 2002-06-28 12:45:00 | AAPL | Stock | 0.3166 | 0.3168 | 0.3161 | 0.3161 | 532000.0 |
| 2002-06-28 12:50:00 | AAPL | Stock | 0.3157 | 0.3161 | 0.3152 | 0.3157 | 1338400.0 |
| 2002-06-28 12:55:00 | AAPL | Stock | 0.3157 | 0.3164 | 0.3152 | 0.3164 | 2038400.0 |
| 2002-06-28 13:00:00 | AAPL | Stock | 0.3164 | 0.3168 | 0.3163 | 0.3164 | 767200.0 |
| 2002-06-28 13:05:00 | AAPL | Stock | 0.3166 | 0.3166 | 0.3163 | 0.3163 | 128800.0 |
| 2002-06-28 13:10:00 | AAPL | Stock | 0.3164 | 0.3173 | 0.3164 | 0.3168 | 1652000.0 |
| 2002-06-28 13:15:00 | AAPL | Stock | 0.3171 | 0.3175 | 0.3166 | 0.3168 | 2296000.0 |
| 2002-06-28 13:20:00 | AAPL | Stock | 0.3168 | 0.3173 | 0.3168 | 0.317 | 2301600.0 |
> showing 50 of 153,801 rows — these rows as CSV