PREVIEW / stock_5min / 2006-10-19
file: by_date/stock_5min/2006/2006-10-19.parquet size: 3.1 MB rows: 233,000 symbols: 2,400
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-10-19 04:15:00 | AAPL | Stock | 2.7696 | 2.7696 | 2.7696 | 2.7696 | 2800.0 |
| 2006-10-19 07:05:00 | AAPL | Stock | 2.7714 | 2.7771 | 2.7714 | 2.775 | 25900.0 |
| 2006-10-19 07:10:00 | AAPL | Stock | 2.7764 | 2.7764 | 2.7764 | 2.7764 | 8400.0 |
| 2006-10-19 07:20:00 | AAPL | Stock | 2.7771 | 2.7771 | 2.7771 | 2.7771 | 2800.0 |
| 2006-10-19 07:25:00 | AAPL | Stock | 2.775 | 2.775 | 2.775 | 2.775 | 8400.0 |
| 2006-10-19 07:35:00 | AAPL | Stock | 2.7793 | 2.7836 | 2.7793 | 2.7836 | 81200.0 |
| 2006-10-19 07:40:00 | AAPL | Stock | 2.7843 | 2.7929 | 2.7843 | 2.7929 | 148400.0 |
| 2006-10-19 07:45:00 | AAPL | Stock | 2.7864 | 2.7864 | 2.7857 | 2.7857 | 250600.0 |
| 2006-10-19 07:50:00 | AAPL | Stock | 2.7839 | 2.7839 | 2.7804 | 2.7804 | 179200.0 |
| 2006-10-19 07:55:00 | AAPL | Stock | 2.7804 | 2.7857 | 2.7804 | 2.7811 | 316316.0 |
| 2006-10-19 08:00:00 | AAPL | Stock | 2.7839 | 2.8143 | 2.7814 | 2.8021 | 5957504.0 |
| 2006-10-19 08:05:00 | AAPL | Stock | 2.8021 | 2.8036 | 2.7968 | 2.8018 | 1334732.0 |
| 2006-10-19 08:10:00 | AAPL | Stock | 2.8004 | 2.8139 | 2.8 | 2.8036 | 2119544.0 |
| 2006-10-19 08:15:00 | AAPL | Stock | 2.8071 | 2.82 | 2.8068 | 2.82 | 3604160.0 |
| 2006-10-19 08:20:00 | AAPL | Stock | 2.8196 | 2.8204 | 2.81 | 2.8121 | 3406844.0 |
| 2006-10-19 08:25:00 | AAPL | Stock | 2.8114 | 2.8143 | 2.8064 | 2.8104 | 1056860.0 |
| 2006-10-19 08:30:00 | AAPL | Stock | 2.8104 | 2.8239 | 2.8071 | 2.8236 | 4491060.0 |
| 2006-10-19 08:35:00 | AAPL | Stock | 2.8243 | 2.8268 | 2.8114 | 2.8129 | 4634812.0 |
| 2006-10-19 08:40:00 | AAPL | Stock | 2.8118 | 2.8232 | 2.8118 | 2.8225 | 1483076.0 |
| 2006-10-19 08:45:00 | AAPL | Stock | 2.8229 | 2.8261 | 2.8179 | 2.8218 | 2362052.0 |
| 2006-10-19 08:50:00 | AAPL | Stock | 2.8214 | 2.8282 | 2.8214 | 2.825 | 2735824.0 |
| 2006-10-19 08:55:00 | AAPL | Stock | 2.825 | 2.8264 | 2.8196 | 2.8229 | 2013256.0 |
| 2006-10-19 09:00:00 | AAPL | Stock | 2.8239 | 2.83 | 2.8229 | 2.8261 | 2160116.0 |
| 2006-10-19 09:05:00 | AAPL | Stock | 2.8261 | 2.8321 | 2.8232 | 2.8293 | 2506840.0 |
| 2006-10-19 09:10:00 | AAPL | Stock | 2.8311 | 2.8311 | 2.8268 | 2.8304 | 1297324.0 |
| 2006-10-19 09:15:00 | AAPL | Stock | 2.8304 | 2.8521 | 2.8296 | 2.8511 | 4936456.0 |
| 2006-10-19 09:20:00 | AAPL | Stock | 2.8511 | 2.8518 | 2.8418 | 2.8418 | 4166344.0 |
| 2006-10-19 09:25:00 | AAPL | Stock | 2.8425 | 2.8443 | 2.8304 | 2.8311 | 17128608.0 |
| 2006-10-19 09:30:00 | AAPL | Stock | 2.8307 | 2.8404 | 2.7914 | 2.805 | 108789324.0 |
| 2006-10-19 09:35:00 | AAPL | Stock | 2.8054 | 2.8339 | 2.8 | 2.815 | 60739868.0 |
| 2006-10-19 09:40:00 | AAPL | Stock | 2.815 | 2.8243 | 2.8089 | 2.8239 | 59802848.0 |
| 2006-10-19 09:45:00 | AAPL | Stock | 2.8236 | 2.8304 | 2.82 | 2.8286 | 49188412.0 |
| 2006-10-19 09:50:00 | AAPL | Stock | 2.8286 | 2.8446 | 2.8275 | 2.8336 | 66971380.0 |
| 2006-10-19 09:55:00 | AAPL | Stock | 2.8336 | 2.8404 | 2.8218 | 2.8239 | 45055164.0 |
| 2006-10-19 10:00:00 | AAPL | Stock | 2.8229 | 2.8418 | 2.8221 | 2.8371 | 41375908.0 |
| 2006-10-19 10:05:00 | AAPL | Stock | 2.8371 | 2.8461 | 2.8307 | 2.8382 | 41738144.0 |
| 2006-10-19 10:10:00 | AAPL | Stock | 2.8379 | 2.8482 | 2.8339 | 2.8446 | 32078872.0 |
| 2006-10-19 10:15:00 | AAPL | Stock | 2.8446 | 2.8536 | 2.8443 | 2.8496 | 39696888.0 |
| 2006-10-19 10:20:00 | AAPL | Stock | 2.8496 | 2.8554 | 2.8446 | 2.845 | 35179004.0 |
| 2006-10-19 10:25:00 | AAPL | Stock | 2.8446 | 2.85 | 2.8393 | 2.84 | 35117208.0 |
| 2006-10-19 10:30:00 | AAPL | Stock | 2.8404 | 2.8443 | 2.8379 | 2.8418 | 28918708.0 |
| 2006-10-19 10:35:00 | AAPL | Stock | 2.8429 | 2.8436 | 2.8339 | 2.8375 | 20764296.0 |
| 2006-10-19 10:40:00 | AAPL | Stock | 2.8375 | 2.8429 | 2.8364 | 2.8375 | 17069864.0 |
| 2006-10-19 10:45:00 | AAPL | Stock | 2.8379 | 2.8411 | 2.8343 | 2.8368 | 18424560.0 |
| 2006-10-19 10:50:00 | AAPL | Stock | 2.8354 | 2.8354 | 2.8254 | 2.8275 | 24341940.0 |
| 2006-10-19 10:55:00 | AAPL | Stock | 2.8271 | 2.8339 | 2.8254 | 2.8289 | 20365156.0 |
| 2006-10-19 11:00:00 | AAPL | Stock | 2.8286 | 2.8291 | 2.8189 | 2.8225 | 24360336.0 |
| 2006-10-19 11:05:00 | AAPL | Stock | 2.8229 | 2.8286 | 2.8207 | 2.8279 | 15791412.0 |
| 2006-10-19 11:10:00 | AAPL | Stock | 2.8279 | 2.8293 | 2.8243 | 2.8275 | 13289052.0 |
| 2006-10-19 11:15:00 | AAPL | Stock | 2.8279 | 2.8314 | 2.8246 | 2.8254 | 11493664.0 |
> showing 50 of 233,000 rows — these rows as CSV