PREVIEW / stock_5min / 2006-11-02
file: by_date/stock_5min/2006/2006-11-02.parquet size: 3.3 MB rows: 241,789 symbols: 2,440
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 |
|---|---|---|---|---|---|---|---|
| 2006-11-02 08:00:00 | AAPL | Stock | 2.8421 | 2.8514 | 2.8332 | 2.8482 | 375396.0 |
| 2006-11-02 08:05:00 | AAPL | Stock | 2.8482 | 2.85 | 2.8482 | 2.85 | 342104.0 |
| 2006-11-02 08:10:00 | AAPL | Stock | 2.8457 | 2.85 | 2.845 | 2.8464 | 110600.0 |
| 2006-11-02 08:15:00 | AAPL | Stock | 2.8464 | 2.8464 | 2.8429 | 2.8429 | 54880.0 |
| 2006-11-02 08:20:00 | AAPL | Stock | 2.8446 | 2.8446 | 2.8446 | 2.8446 | 113120.0 |
| 2006-11-02 08:25:00 | AAPL | Stock | 2.8446 | 2.8464 | 2.8418 | 2.8418 | 178920.0 |
| 2006-11-02 08:30:00 | AAPL | Stock | 2.8414 | 2.8414 | 2.8332 | 2.8332 | 541072.0 |
| 2006-11-02 08:35:00 | AAPL | Stock | 2.8357 | 2.8389 | 2.8321 | 2.8336 | 502852.0 |
| 2006-11-02 08:40:00 | AAPL | Stock | 2.8336 | 2.8339 | 2.8286 | 2.8293 | 307804.0 |
| 2006-11-02 08:45:00 | AAPL | Stock | 2.8289 | 2.8314 | 2.8254 | 2.8296 | 400708.0 |
| 2006-11-02 08:50:00 | AAPL | Stock | 2.8304 | 2.8304 | 2.825 | 2.8271 | 110180.0 |
| 2006-11-02 08:55:00 | AAPL | Stock | 2.825 | 2.825 | 2.8193 | 2.8193 | 304220.0 |
| 2006-11-02 09:00:00 | AAPL | Stock | 2.8193 | 2.8193 | 2.815 | 2.8179 | 450520.0 |
| 2006-11-02 09:05:00 | AAPL | Stock | 2.8179 | 2.8196 | 2.8168 | 2.8196 | 107100.0 |
| 2006-11-02 09:10:00 | AAPL | Stock | 2.8196 | 2.8196 | 2.8146 | 2.8175 | 138880.0 |
| 2006-11-02 09:15:00 | AAPL | Stock | 2.8161 | 2.8164 | 2.815 | 2.8161 | 227640.0 |
| 2006-11-02 09:20:00 | AAPL | Stock | 2.8161 | 2.8193 | 2.8143 | 2.8193 | 216020.0 |
| 2006-11-02 09:25:00 | AAPL | Stock | 2.8189 | 2.8207 | 2.815 | 2.8207 | 316568.0 |
| 2006-11-02 09:30:00 | AAPL | Stock | 2.8184 | 2.8304 | 2.8111 | 2.8118 | 17620764.0 |
| 2006-11-02 09:35:00 | AAPL | Stock | 2.8111 | 2.825 | 2.8036 | 2.8068 | 17562132.0 |
| 2006-11-02 09:40:00 | AAPL | Stock | 2.8043 | 2.8175 | 2.8043 | 2.8121 | 9960804.0 |
| 2006-11-02 09:45:00 | AAPL | Stock | 2.8121 | 2.8143 | 2.8057 | 2.8132 | 9343348.0 |
| 2006-11-02 09:50:00 | AAPL | Stock | 2.8132 | 2.8161 | 2.8036 | 2.8089 | 16032128.0 |
| 2006-11-02 09:55:00 | AAPL | Stock | 2.8089 | 2.8186 | 2.8075 | 2.8168 | 10659068.0 |
| 2006-11-02 10:00:00 | AAPL | Stock | 2.8171 | 2.8293 | 2.8125 | 2.8279 | 11227720.0 |
| 2006-11-02 10:05:00 | AAPL | Stock | 2.8282 | 2.8304 | 2.8171 | 2.8239 | 9141916.0 |
| 2006-11-02 10:10:00 | AAPL | Stock | 2.8239 | 2.8282 | 2.8193 | 2.8218 | 7371392.0 |
| 2006-11-02 10:15:00 | AAPL | Stock | 2.8225 | 2.8275 | 2.8214 | 2.8239 | 7272552.0 |
| 2006-11-02 10:20:00 | AAPL | Stock | 2.8239 | 2.8264 | 2.8182 | 2.8189 | 6103692.0 |
| 2006-11-02 10:25:00 | AAPL | Stock | 2.8189 | 2.8279 | 2.8186 | 2.8275 | 7181860.0 |
| 2006-11-02 10:30:00 | AAPL | Stock | 2.8271 | 2.8279 | 2.8218 | 2.8271 | 7713104.0 |
| 2006-11-02 10:35:00 | AAPL | Stock | 2.8271 | 2.8296 | 2.8243 | 2.8279 | 8701840.0 |
| 2006-11-02 10:40:00 | AAPL | Stock | 2.8279 | 2.8279 | 2.82 | 2.8218 | 7665336.0 |
| 2006-11-02 10:45:00 | AAPL | Stock | 2.8214 | 2.8246 | 2.8204 | 2.8232 | 4422460.0 |
| 2006-11-02 10:50:00 | AAPL | Stock | 2.8232 | 2.8279 | 2.8218 | 2.8225 | 6416228.0 |
| 2006-11-02 10:55:00 | AAPL | Stock | 2.8225 | 2.8243 | 2.8193 | 2.82 | 7132244.0 |
| 2006-11-02 11:00:00 | AAPL | Stock | 2.82 | 2.8207 | 2.8168 | 2.8196 | 6869072.0 |
| 2006-11-02 11:05:00 | AAPL | Stock | 2.8196 | 2.8204 | 2.8168 | 2.8179 | 4497584.0 |
| 2006-11-02 11:10:00 | AAPL | Stock | 2.8175 | 2.8271 | 2.8168 | 2.8218 | 7299012.0 |
| 2006-11-02 11:15:00 | AAPL | Stock | 2.8221 | 2.8261 | 2.8214 | 2.8261 | 3565884.0 |
| 2006-11-02 11:20:00 | AAPL | Stock | 2.8261 | 2.8329 | 2.8246 | 2.8257 | 11429684.0 |
| 2006-11-02 11:25:00 | AAPL | Stock | 2.8257 | 2.8264 | 2.8146 | 2.8168 | 7705460.0 |
| 2006-11-02 11:30:00 | AAPL | Stock | 2.8161 | 2.8164 | 2.8111 | 2.8157 | 7254828.0 |
| 2006-11-02 11:35:00 | AAPL | Stock | 2.8157 | 2.8168 | 2.8114 | 2.8132 | 5459356.0 |
| 2006-11-02 11:40:00 | AAPL | Stock | 2.8132 | 2.8168 | 2.8125 | 2.8143 | 3119480.0 |
| 2006-11-02 11:45:00 | AAPL | Stock | 2.8143 | 2.8161 | 2.8139 | 2.8154 | 4142824.0 |
| 2006-11-02 11:50:00 | AAPL | Stock | 2.8154 | 2.8161 | 2.8129 | 2.8129 | 6354152.0 |
| 2006-11-02 11:55:00 | AAPL | Stock | 2.8129 | 2.815 | 2.8114 | 2.8136 | 3841684.0 |
| 2006-11-02 12:00:00 | AAPL | Stock | 2.8129 | 2.8193 | 2.8129 | 2.8157 | 5005168.0 |
| 2006-11-02 12:05:00 | AAPL | Stock | 2.8154 | 2.8186 | 2.8146 | 2.8182 | 3337096.0 |
> showing 50 of 241,789 rows — these rows as CSV