PREVIEW / stock_5min / 2001-11-01
file: by_date/stock_5min/2001/2001-11-01.parquet size: 1.6 MB rows: 112,831 symbols: 1,356
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 |
|---|---|---|---|---|---|---|---|
| 2001-11-01 08:20:00 | AAPL | Stock | 0.3184 | 0.3184 | 0.3184 | 0.3184 | 112000.0 |
| 2001-11-01 08:30:00 | AAPL | Stock | 0.3145 | 0.3145 | 0.3145 | 0.3145 | 28000.0 |
| 2001-11-01 09:00:00 | AAPL | Stock | 0.3161 | 0.3161 | 0.3161 | 0.3161 | 5600.0 |
| 2001-11-01 09:20:00 | AAPL | Stock | 0.3155 | 0.3155 | 0.3155 | 0.3155 | 5600.0 |
| 2001-11-01 09:25:00 | AAPL | Stock | 0.3159 | 0.3159 | 0.3154 | 0.3154 | 78400.0 |
| 2001-11-01 09:30:00 | AAPL | Stock | 0.3152 | 0.3159 | 0.308 | 0.3089 | 7800800.0 |
| 2001-11-01 09:35:00 | AAPL | Stock | 0.3088 | 0.3164 | 0.3088 | 0.3146 | 6904800.0 |
| 2001-11-01 09:40:00 | AAPL | Stock | 0.3141 | 0.3171 | 0.3134 | 0.3152 | 10628800.0 |
| 2001-11-01 09:45:00 | AAPL | Stock | 0.3146 | 0.3195 | 0.3145 | 0.3189 | 8332800.0 |
| 2001-11-01 09:50:00 | AAPL | Stock | 0.3193 | 0.3193 | 0.3143 | 0.3168 | 2632000.0 |
| 2001-11-01 09:55:00 | AAPL | Stock | 0.3163 | 0.3179 | 0.3152 | 0.3173 | 2503200.0 |
| 2001-11-01 10:00:00 | AAPL | Stock | 0.317 | 0.3196 | 0.312 | 0.315 | 8803200.0 |
| 2001-11-01 10:05:00 | AAPL | Stock | 0.3143 | 0.317 | 0.3134 | 0.3139 | 4043200.0 |
| 2001-11-01 10:10:00 | AAPL | Stock | 0.3139 | 0.3159 | 0.3107 | 0.3125 | 9329600.0 |
| 2001-11-01 10:15:00 | AAPL | Stock | 0.3127 | 0.3134 | 0.31 | 0.3121 | 4810400.0 |
| 2001-11-01 10:20:00 | AAPL | Stock | 0.3118 | 0.3123 | 0.31 | 0.3107 | 4222400.0 |
| 2001-11-01 10:25:00 | AAPL | Stock | 0.3107 | 0.3129 | 0.3104 | 0.3107 | 5236000.0 |
| 2001-11-01 10:30:00 | AAPL | Stock | 0.3111 | 0.3168 | 0.3107 | 0.3168 | 8467200.0 |
| 2001-11-01 10:35:00 | AAPL | Stock | 0.3163 | 0.3188 | 0.3158 | 0.3173 | 3914400.0 |
| 2001-11-01 10:40:00 | AAPL | Stock | 0.3173 | 0.3195 | 0.3164 | 0.3177 | 5353600.0 |
| 2001-11-01 10:45:00 | AAPL | Stock | 0.3173 | 0.3208 | 0.3168 | 0.3186 | 4256000.0 |
| 2001-11-01 10:50:00 | AAPL | Stock | 0.3186 | 0.32 | 0.3179 | 0.3179 | 1568000.0 |
| 2001-11-01 10:55:00 | AAPL | Stock | 0.318 | 0.3221 | 0.3178 | 0.3214 | 5432000.0 |
| 2001-11-01 11:00:00 | AAPL | Stock | 0.3221 | 0.3225 | 0.3211 | 0.322 | 3707200.0 |
| 2001-11-01 11:05:00 | AAPL | Stock | 0.322 | 0.3239 | 0.3212 | 0.3232 | 6932800.0 |
| 2001-11-01 11:10:00 | AAPL | Stock | 0.3229 | 0.3254 | 0.3216 | 0.3238 | 8596000.0 |
| 2001-11-01 11:15:00 | AAPL | Stock | 0.3236 | 0.3246 | 0.3227 | 0.3233 | 3102400.0 |
| 2001-11-01 11:20:00 | AAPL | Stock | 0.3232 | 0.3255 | 0.3227 | 0.3255 | 3858400.0 |
| 2001-11-01 11:25:00 | AAPL | Stock | 0.3255 | 0.3263 | 0.3236 | 0.3236 | 2732800.0 |
| 2001-11-01 11:30:00 | AAPL | Stock | 0.3243 | 0.3261 | 0.3241 | 0.3255 | 1243200.0 |
| 2001-11-01 11:35:00 | AAPL | Stock | 0.3254 | 0.3255 | 0.3236 | 0.3255 | 7285600.0 |
| 2001-11-01 11:40:00 | AAPL | Stock | 0.3253 | 0.3255 | 0.3227 | 0.3232 | 1859200.0 |
| 2001-11-01 11:45:00 | AAPL | Stock | 0.3232 | 0.3234 | 0.322 | 0.3234 | 3500000.0 |
| 2001-11-01 11:50:00 | AAPL | Stock | 0.3232 | 0.3236 | 0.3207 | 0.3213 | 2189600.0 |
| 2001-11-01 11:55:00 | AAPL | Stock | 0.3209 | 0.3223 | 0.3207 | 0.3218 | 1422400.0 |
| 2001-11-01 12:00:00 | AAPL | Stock | 0.3218 | 0.3223 | 0.3214 | 0.322 | 2038400.0 |
| 2001-11-01 12:05:00 | AAPL | Stock | 0.3221 | 0.3223 | 0.3205 | 0.3207 | 1400000.0 |
| 2001-11-01 12:10:00 | AAPL | Stock | 0.3212 | 0.3223 | 0.3207 | 0.3218 | 856800.0 |
| 2001-11-01 12:15:00 | AAPL | Stock | 0.3216 | 0.3221 | 0.3211 | 0.3214 | 756000.0 |
| 2001-11-01 12:20:00 | AAPL | Stock | 0.3214 | 0.3214 | 0.3173 | 0.3187 | 3612000.0 |
| 2001-11-01 12:25:00 | AAPL | Stock | 0.3182 | 0.3198 | 0.318 | 0.3186 | 1299200.0 |
| 2001-11-01 12:30:00 | AAPL | Stock | 0.3186 | 0.3223 | 0.3186 | 0.3223 | 3270400.0 |
| 2001-11-01 12:35:00 | AAPL | Stock | 0.3214 | 0.3218 | 0.3198 | 0.3211 | 1075200.0 |
| 2001-11-01 12:40:00 | AAPL | Stock | 0.3211 | 0.3223 | 0.3206 | 0.3218 | 845600.0 |
| 2001-11-01 12:45:00 | AAPL | Stock | 0.322 | 0.3223 | 0.3216 | 0.3221 | 733600.0 |
| 2001-11-01 12:50:00 | AAPL | Stock | 0.3221 | 0.3221 | 0.3209 | 0.3209 | 1013600.0 |
| 2001-11-01 12:55:00 | AAPL | Stock | 0.3209 | 0.3211 | 0.3207 | 0.3207 | 644000.0 |
| 2001-11-01 13:00:00 | AAPL | Stock | 0.3211 | 0.322 | 0.321 | 0.3218 | 1209600.0 |
| 2001-11-01 13:05:00 | AAPL | Stock | 0.322 | 0.3234 | 0.3214 | 0.3223 | 5583200.0 |
| 2001-11-01 13:10:00 | AAPL | Stock | 0.3223 | 0.3229 | 0.3218 | 0.3225 | 1372000.0 |
> showing 50 of 112,831 rows — these rows as CSV