PREVIEW / stock_5min / 2002-07-11
file: by_date/stock_5min/2002/2002-07-11.parquet size: 2.0 MB rows: 134,986 symbols: 1,448
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-07-11 08:05:00 | AAPL | Stock | 0.3125 | 0.3125 | 0.3125 | 0.3125 | 16800.0 |
| 2002-07-11 08:40:00 | AAPL | Stock | 0.3107 | 0.3107 | 0.3098 | 0.3098 | 56000.0 |
| 2002-07-11 09:00:00 | AAPL | Stock | 0.3045 | 0.3045 | 0.3045 | 0.3045 | 11200.0 |
| 2002-07-11 09:15:00 | AAPL | Stock | 0.3071 | 0.3071 | 0.3071 | 0.3071 | 5600.0 |
| 2002-07-11 09:25:00 | AAPL | Stock | 0.3073 | 0.3098 | 0.3073 | 0.3098 | 28000.0 |
| 2002-07-11 09:30:00 | AAPL | Stock | 0.3082 | 0.3082 | 0.3048 | 0.3061 | 5695200.0 |
| 2002-07-11 09:35:00 | AAPL | Stock | 0.3061 | 0.3079 | 0.3045 | 0.3046 | 5605600.0 |
| 2002-07-11 09:40:00 | AAPL | Stock | 0.3046 | 0.3061 | 0.3039 | 0.3039 | 2010400.0 |
| 2002-07-11 09:45:00 | AAPL | Stock | 0.3039 | 0.3048 | 0.303 | 0.3048 | 5241600.0 |
| 2002-07-11 09:50:00 | AAPL | Stock | 0.3043 | 0.3105 | 0.3043 | 0.3104 | 4334400.0 |
| 2002-07-11 09:55:00 | AAPL | Stock | 0.3104 | 0.3127 | 0.3098 | 0.3116 | 6641600.0 |
| 2002-07-11 10:00:00 | AAPL | Stock | 0.3114 | 0.3184 | 0.3111 | 0.3173 | 8299200.0 |
| 2002-07-11 10:05:00 | AAPL | Stock | 0.318 | 0.318 | 0.3136 | 0.3146 | 6053600.0 |
| 2002-07-11 10:10:00 | AAPL | Stock | 0.3146 | 0.3159 | 0.3141 | 0.3157 | 3920000.0 |
| 2002-07-11 10:15:00 | AAPL | Stock | 0.3159 | 0.317 | 0.3143 | 0.315 | 3130400.0 |
| 2002-07-11 10:20:00 | AAPL | Stock | 0.3149 | 0.3179 | 0.3145 | 0.3152 | 3029600.0 |
| 2002-07-11 10:25:00 | AAPL | Stock | 0.3148 | 0.3173 | 0.3146 | 0.3157 | 3096800.0 |
| 2002-07-11 10:30:00 | AAPL | Stock | 0.3157 | 0.3157 | 0.3116 | 0.3121 | 3337600.0 |
| 2002-07-11 10:35:00 | AAPL | Stock | 0.3125 | 0.3143 | 0.3123 | 0.3141 | 2536800.0 |
| 2002-07-11 10:40:00 | AAPL | Stock | 0.3141 | 0.3157 | 0.3102 | 0.3102 | 3270400.0 |
| 2002-07-11 10:45:00 | AAPL | Stock | 0.3102 | 0.3134 | 0.308 | 0.3129 | 3130400.0 |
| 2002-07-11 10:50:00 | AAPL | Stock | 0.3129 | 0.3148 | 0.3127 | 0.3127 | 2660000.0 |
| 2002-07-11 10:55:00 | AAPL | Stock | 0.3127 | 0.3136 | 0.3121 | 0.313 | 1719200.0 |
| 2002-07-11 11:00:00 | AAPL | Stock | 0.3132 | 0.3146 | 0.3127 | 0.3143 | 1405600.0 |
| 2002-07-11 11:05:00 | AAPL | Stock | 0.3143 | 0.3146 | 0.3136 | 0.3139 | 1461600.0 |
| 2002-07-11 11:10:00 | AAPL | Stock | 0.3141 | 0.3141 | 0.3125 | 0.3139 | 1825600.0 |
| 2002-07-11 11:15:00 | AAPL | Stock | 0.3129 | 0.3141 | 0.3118 | 0.312 | 1416800.0 |
| 2002-07-11 11:20:00 | AAPL | Stock | 0.312 | 0.312 | 0.3084 | 0.3084 | 1948800.0 |
| 2002-07-11 11:25:00 | AAPL | Stock | 0.3086 | 0.3118 | 0.3082 | 0.3111 | 2934400.0 |
| 2002-07-11 11:30:00 | AAPL | Stock | 0.3113 | 0.3116 | 0.3093 | 0.3104 | 1584800.0 |
| 2002-07-11 11:35:00 | AAPL | Stock | 0.3104 | 0.3104 | 0.3089 | 0.3089 | 1439200.0 |
| 2002-07-11 11:40:00 | AAPL | Stock | 0.3089 | 0.3089 | 0.3079 | 0.308 | 1388800.0 |
| 2002-07-11 11:45:00 | AAPL | Stock | 0.308 | 0.3114 | 0.308 | 0.3107 | 2240000.0 |
| 2002-07-11 11:50:00 | AAPL | Stock | 0.3107 | 0.3107 | 0.3091 | 0.3096 | 1411200.0 |
| 2002-07-11 11:55:00 | AAPL | Stock | 0.3096 | 0.3105 | 0.3089 | 0.3102 | 963200.0 |
| 2002-07-11 12:00:00 | AAPL | Stock | 0.3102 | 0.3104 | 0.3086 | 0.3089 | 1248800.0 |
| 2002-07-11 12:05:00 | AAPL | Stock | 0.3088 | 0.3089 | 0.3086 | 0.3089 | 1825600.0 |
| 2002-07-11 12:10:00 | AAPL | Stock | 0.3089 | 0.3089 | 0.308 | 0.308 | 2441600.0 |
| 2002-07-11 12:15:00 | AAPL | Stock | 0.3082 | 0.3104 | 0.308 | 0.3102 | 1629600.0 |
| 2002-07-11 12:20:00 | AAPL | Stock | 0.3102 | 0.3116 | 0.3102 | 0.3107 | 2413600.0 |
| 2002-07-11 12:25:00 | AAPL | Stock | 0.3111 | 0.3116 | 0.3102 | 0.3105 | 1534400.0 |
| 2002-07-11 12:30:00 | AAPL | Stock | 0.3105 | 0.3109 | 0.3095 | 0.3109 | 1148000.0 |
| 2002-07-11 12:35:00 | AAPL | Stock | 0.3109 | 0.3136 | 0.3107 | 0.3127 | 3785600.0 |
| 2002-07-11 12:40:00 | AAPL | Stock | 0.3125 | 0.3125 | 0.3109 | 0.3118 | 1920800.0 |
| 2002-07-11 12:45:00 | AAPL | Stock | 0.3118 | 0.3139 | 0.3118 | 0.3132 | 2660000.0 |
| 2002-07-11 12:50:00 | AAPL | Stock | 0.3129 | 0.315 | 0.3127 | 0.315 | 2167200.0 |
| 2002-07-11 12:55:00 | AAPL | Stock | 0.3152 | 0.3173 | 0.3152 | 0.3164 | 6983200.0 |
| 2002-07-11 13:00:00 | AAPL | Stock | 0.3164 | 0.3178 | 0.3155 | 0.3157 | 2867200.0 |
| 2002-07-11 13:05:00 | AAPL | Stock | 0.3161 | 0.3168 | 0.3157 | 0.3157 | 2492000.0 |
| 2002-07-11 13:10:00 | AAPL | Stock | 0.3157 | 0.3164 | 0.3146 | 0.3146 | 2374400.0 |
> showing 50 of 134,986 rows — these rows as CSV