PREVIEW / stock_5min / 2006-09-27
file: by_date/stock_5min/2006/2006-09-27.parquet size: 3.1 MB rows: 228,805 symbols: 2,375
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-09-27 04:15:00 | AAPL | Stock | 2.7661 | 2.7661 | 2.7661 | 2.7661 | 3920.0 |
| 2006-09-27 07:50:00 | AAPL | Stock | 2.7843 | 2.7843 | 2.7843 | 2.7843 | 5600.0 |
| 2006-09-27 07:55:00 | AAPL | Stock | 2.7829 | 2.7829 | 2.7829 | 2.7829 | 11200.0 |
| 2006-09-27 08:00:00 | AAPL | Stock | 2.7829 | 2.7857 | 2.7804 | 2.7854 | 279216.0 |
| 2006-09-27 08:05:00 | AAPL | Stock | 2.7857 | 2.7857 | 2.7821 | 2.7857 | 248360.0 |
| 2006-09-27 08:10:00 | AAPL | Stock | 2.7857 | 2.7868 | 2.7821 | 2.7857 | 146300.0 |
| 2006-09-27 08:15:00 | AAPL | Stock | 2.7857 | 2.7889 | 2.7843 | 2.7879 | 376040.0 |
| 2006-09-27 08:20:00 | AAPL | Stock | 2.7879 | 2.7879 | 2.7832 | 2.7839 | 289660.0 |
| 2006-09-27 08:25:00 | AAPL | Stock | 2.7832 | 2.7854 | 2.7821 | 2.7832 | 296156.0 |
| 2006-09-27 08:30:00 | AAPL | Stock | 2.7839 | 2.7857 | 2.775 | 2.7754 | 1788500.0 |
| 2006-09-27 08:35:00 | AAPL | Stock | 2.7779 | 2.7782 | 2.7714 | 2.7746 | 1022756.0 |
| 2006-09-27 08:40:00 | AAPL | Stock | 2.7746 | 2.7746 | 2.7543 | 2.7554 | 2291240.0 |
| 2006-09-27 08:45:00 | AAPL | Stock | 2.7554 | 2.7589 | 2.7507 | 2.7564 | 1626044.0 |
| 2006-09-27 08:50:00 | AAPL | Stock | 2.7571 | 2.7589 | 2.7529 | 2.7536 | 807856.0 |
| 2006-09-27 08:55:00 | AAPL | Stock | 2.7546 | 2.7546 | 2.7496 | 2.75 | 1044652.0 |
| 2006-09-27 09:00:00 | AAPL | Stock | 2.7507 | 2.7511 | 2.7468 | 2.7475 | 343504.0 |
| 2006-09-27 09:05:00 | AAPL | Stock | 2.7475 | 2.75 | 2.7464 | 2.75 | 430640.0 |
| 2006-09-27 09:10:00 | AAPL | Stock | 2.7489 | 2.7554 | 2.7479 | 2.7554 | 582064.0 |
| 2006-09-27 09:15:00 | AAPL | Stock | 2.7536 | 2.7571 | 2.7536 | 2.7557 | 222404.0 |
| 2006-09-27 09:20:00 | AAPL | Stock | 2.7554 | 2.7554 | 2.7518 | 2.7518 | 579460.0 |
| 2006-09-27 09:25:00 | AAPL | Stock | 2.7539 | 2.7589 | 2.7521 | 2.7568 | 832384.0 |
| 2006-09-27 09:30:00 | AAPL | Stock | 2.7561 | 2.7586 | 2.7414 | 2.7561 | 25140696.0 |
| 2006-09-27 09:35:00 | AAPL | Stock | 2.7564 | 2.7668 | 2.7475 | 2.7504 | 29072708.0 |
| 2006-09-27 09:40:00 | AAPL | Stock | 2.7507 | 2.7582 | 2.7468 | 2.7493 | 20913452.0 |
| 2006-09-27 09:45:00 | AAPL | Stock | 2.7493 | 2.7521 | 2.7464 | 2.7489 | 19562564.0 |
| 2006-09-27 09:50:00 | AAPL | Stock | 2.7482 | 2.7518 | 2.7382 | 2.7404 | 21441252.0 |
| 2006-09-27 09:55:00 | AAPL | Stock | 2.7404 | 2.7539 | 2.7339 | 2.7464 | 23296420.0 |
| 2006-09-27 10:00:00 | AAPL | Stock | 2.7464 | 2.7532 | 2.7443 | 2.7479 | 18737460.0 |
| 2006-09-27 10:05:00 | AAPL | Stock | 2.7482 | 2.7482 | 2.7339 | 2.7343 | 13918660.0 |
| 2006-09-27 10:10:00 | AAPL | Stock | 2.7343 | 2.7382 | 2.7271 | 2.7289 | 27694324.0 |
| 2006-09-27 10:15:00 | AAPL | Stock | 2.7287 | 2.7318 | 2.7218 | 2.7232 | 22932616.0 |
| 2006-09-27 10:20:00 | AAPL | Stock | 2.7232 | 2.7525 | 2.7164 | 2.7243 | 27852244.0 |
| 2006-09-27 10:25:00 | AAPL | Stock | 2.7243 | 2.7307 | 2.7229 | 2.73 | 16140964.0 |
| 2006-09-27 10:30:00 | AAPL | Stock | 2.73 | 2.7354 | 2.725 | 2.7332 | 14344176.0 |
| 2006-09-27 10:35:00 | AAPL | Stock | 2.7332 | 2.7393 | 2.7296 | 2.7371 | 17350704.0 |
| 2006-09-27 10:40:00 | AAPL | Stock | 2.7368 | 2.7389 | 2.7264 | 2.7282 | 13906620.0 |
| 2006-09-27 10:45:00 | AAPL | Stock | 2.7282 | 2.7329 | 2.7264 | 2.7293 | 8377208.0 |
| 2006-09-27 10:50:00 | AAPL | Stock | 2.7296 | 2.7332 | 2.7268 | 2.7332 | 8049104.0 |
| 2006-09-27 10:55:00 | AAPL | Stock | 2.7332 | 2.7339 | 2.7282 | 2.7332 | 8479968.0 |
| 2006-09-27 11:00:00 | AAPL | Stock | 2.7336 | 2.7361 | 2.7296 | 2.7307 | 10062920.0 |
| 2006-09-27 11:05:00 | AAPL | Stock | 2.7307 | 2.7364 | 2.7304 | 2.7339 | 7204260.0 |
| 2006-09-27 11:10:00 | AAPL | Stock | 2.7337 | 2.7368 | 2.7289 | 2.7332 | 9647596.0 |
| 2006-09-27 11:15:00 | AAPL | Stock | 2.7332 | 2.7354 | 2.7289 | 2.731 | 7411628.0 |
| 2006-09-27 11:20:00 | AAPL | Stock | 2.7309 | 2.7311 | 2.7229 | 2.7271 | 9898644.0 |
| 2006-09-27 11:25:00 | AAPL | Stock | 2.7271 | 2.7339 | 2.7261 | 2.7307 | 10983280.0 |
| 2006-09-27 11:30:00 | AAPL | Stock | 2.7311 | 2.7339 | 2.73 | 2.7318 | 6642888.0 |
| 2006-09-27 11:35:00 | AAPL | Stock | 2.7316 | 2.7357 | 2.7311 | 2.7322 | 8306788.0 |
| 2006-09-27 11:40:00 | AAPL | Stock | 2.7323 | 2.7346 | 2.7293 | 2.7304 | 6436920.0 |
| 2006-09-27 11:45:00 | AAPL | Stock | 2.7304 | 2.7336 | 2.7279 | 2.7321 | 5318796.0 |
| 2006-09-27 11:50:00 | AAPL | Stock | 2.7321 | 2.7325 | 2.7279 | 2.7293 | 6668116.0 |
> showing 50 of 228,805 rows — these rows as CSV