PREVIEW / stock_5min / 2003-06-03
file: by_date/stock_5min/2003/2003-06-03.parquet size: 2.1 MB rows: 147,942 symbols: 1,578
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 |
|---|---|---|---|---|---|---|---|
| 2003-06-03 08:00:00 | AAPL | Stock | 0.3116 | 0.3116 | 0.3116 | 0.3116 | 5600000.0 |
| 2003-06-03 08:30:00 | AAPL | Stock | 0.3109 | 0.3116 | 0.3109 | 0.3116 | 2872800.0 |
| 2003-06-03 08:40:00 | AAPL | Stock | 0.3109 | 0.3109 | 0.3109 | 0.3109 | 44800.0 |
| 2003-06-03 09:00:00 | AAPL | Stock | 0.3105 | 0.3105 | 0.3105 | 0.3105 | 28000.0 |
| 2003-06-03 09:15:00 | AAPL | Stock | 0.3105 | 0.3188 | 0.3105 | 0.3123 | 274400.0 |
| 2003-06-03 09:20:00 | AAPL | Stock | 0.3123 | 0.3123 | 0.3123 | 0.3123 | 5600.0 |
| 2003-06-03 09:25:00 | AAPL | Stock | 0.31 | 0.3138 | 0.3088 | 0.3121 | 146048.0 |
| 2003-06-03 09:30:00 | AAPL | Stock | 0.3114 | 0.3125 | 0.3071 | 0.3075 | 8770440.0 |
| 2003-06-03 09:35:00 | AAPL | Stock | 0.3075 | 0.3095 | 0.3041 | 0.3043 | 11186280.0 |
| 2003-06-03 09:40:00 | AAPL | Stock | 0.3043 | 0.3071 | 0.3039 | 0.3063 | 8604120.0 |
| 2003-06-03 09:45:00 | AAPL | Stock | 0.3063 | 0.3082 | 0.3059 | 0.307 | 10170720.0 |
| 2003-06-03 09:50:00 | AAPL | Stock | 0.3071 | 0.3077 | 0.3055 | 0.3055 | 8322496.0 |
| 2003-06-03 09:55:00 | AAPL | Stock | 0.3055 | 0.3102 | 0.3055 | 0.3095 | 5280632.0 |
| 2003-06-03 10:00:00 | AAPL | Stock | 0.3091 | 0.3104 | 0.3089 | 0.3091 | 3483144.0 |
| 2003-06-03 10:05:00 | AAPL | Stock | 0.3093 | 0.3138 | 0.3086 | 0.313 | 8218000.0 |
| 2003-06-03 10:10:00 | AAPL | Stock | 0.3132 | 0.3132 | 0.3107 | 0.3114 | 3012800.0 |
| 2003-06-03 10:15:00 | AAPL | Stock | 0.3114 | 0.3125 | 0.3102 | 0.3106 | 3326400.0 |
| 2003-06-03 10:20:00 | AAPL | Stock | 0.3104 | 0.3104 | 0.3084 | 0.3084 | 4200000.0 |
| 2003-06-03 10:25:00 | AAPL | Stock | 0.3084 | 0.3093 | 0.3077 | 0.3088 | 3343200.0 |
| 2003-06-03 10:30:00 | AAPL | Stock | 0.3089 | 0.3098 | 0.3089 | 0.3093 | 4328800.0 |
| 2003-06-03 10:35:00 | AAPL | Stock | 0.3091 | 0.31 | 0.3089 | 0.3098 | 2592800.0 |
| 2003-06-03 10:40:00 | AAPL | Stock | 0.3096 | 0.3098 | 0.3091 | 0.3091 | 1215872.0 |
| 2003-06-03 10:45:00 | AAPL | Stock | 0.3089 | 0.3113 | 0.3089 | 0.3104 | 2452072.0 |
| 2003-06-03 10:50:00 | AAPL | Stock | 0.3105 | 0.3111 | 0.3095 | 0.3109 | 1172640.0 |
| 2003-06-03 10:55:00 | AAPL | Stock | 0.3105 | 0.3121 | 0.3105 | 0.3111 | 957600.0 |
| 2003-06-03 11:00:00 | AAPL | Stock | 0.3111 | 0.3118 | 0.3096 | 0.3118 | 2055200.0 |
| 2003-06-03 11:05:00 | AAPL | Stock | 0.3118 | 0.3121 | 0.3113 | 0.3116 | 2150400.0 |
| 2003-06-03 11:10:00 | AAPL | Stock | 0.3118 | 0.3123 | 0.3116 | 0.312 | 2828000.0 |
| 2003-06-03 11:15:00 | AAPL | Stock | 0.312 | 0.312 | 0.3118 | 0.312 | 392000.0 |
| 2003-06-03 11:20:00 | AAPL | Stock | 0.312 | 0.3122 | 0.3118 | 0.3121 | 862400.0 |
| 2003-06-03 11:25:00 | AAPL | Stock | 0.3121 | 0.3142 | 0.3121 | 0.3141 | 4728808.0 |
| 2003-06-03 11:30:00 | AAPL | Stock | 0.3141 | 0.3146 | 0.3141 | 0.3146 | 3043600.0 |
| 2003-06-03 11:35:00 | AAPL | Stock | 0.3145 | 0.3155 | 0.3145 | 0.315 | 3404800.0 |
| 2003-06-03 11:40:00 | AAPL | Stock | 0.3154 | 0.3154 | 0.3139 | 0.3143 | 1596000.0 |
| 2003-06-03 11:45:00 | AAPL | Stock | 0.3141 | 0.3152 | 0.3136 | 0.315 | 4102000.0 |
| 2003-06-03 11:50:00 | AAPL | Stock | 0.3154 | 0.3155 | 0.3148 | 0.3152 | 1058400.0 |
| 2003-06-03 11:55:00 | AAPL | Stock | 0.315 | 0.315 | 0.3127 | 0.3127 | 4328856.0 |
| 2003-06-03 12:00:00 | AAPL | Stock | 0.3127 | 0.3139 | 0.3127 | 0.3129 | 2205840.0 |
| 2003-06-03 12:05:00 | AAPL | Stock | 0.3129 | 0.3129 | 0.3116 | 0.312 | 1786064.0 |
| 2003-06-03 12:10:00 | AAPL | Stock | 0.312 | 0.3132 | 0.3118 | 0.3129 | 4649456.0 |
| 2003-06-03 12:15:00 | AAPL | Stock | 0.3129 | 0.3129 | 0.3102 | 0.3111 | 5756800.0 |
| 2003-06-03 12:20:00 | AAPL | Stock | 0.3113 | 0.3121 | 0.3113 | 0.312 | 1590400.0 |
| 2003-06-03 12:25:00 | AAPL | Stock | 0.312 | 0.312 | 0.3107 | 0.3107 | 4113368.0 |
| 2003-06-03 12:30:00 | AAPL | Stock | 0.3109 | 0.3111 | 0.3105 | 0.3109 | 1467200.0 |
| 2003-06-03 12:35:00 | AAPL | Stock | 0.3104 | 0.3111 | 0.31 | 0.3109 | 3326176.0 |
| 2003-06-03 12:40:00 | AAPL | Stock | 0.3107 | 0.3111 | 0.3098 | 0.3102 | 4300800.0 |
| 2003-06-03 12:45:00 | AAPL | Stock | 0.3098 | 0.3102 | 0.3095 | 0.3098 | 2552088.0 |
| 2003-06-03 12:50:00 | AAPL | Stock | 0.3095 | 0.3098 | 0.3091 | 0.3093 | 3029600.0 |
| 2003-06-03 12:55:00 | AAPL | Stock | 0.3096 | 0.31 | 0.3089 | 0.3098 | 4446400.0 |
| 2003-06-03 13:00:00 | AAPL | Stock | 0.3098 | 0.31 | 0.3091 | 0.3098 | 3264800.0 |
> showing 50 of 147,942 rows — these rows as CSV