PREVIEW / stock_5min / 2007-07-11
file: by_date/stock_5min/2007/2007-07-11.parquet size: 4.0 MB rows: 295,464 symbols: 3,077
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 |
|---|---|---|---|---|---|---|---|
| 2007-07-11 09:30:00 | AAPL | Stock | 4.7168 | 4.7218 | 4.6896 | 4.6968 | 31987928.0 |
| 2007-07-11 09:35:00 | AAPL | Stock | 4.6971 | 4.7407 | 4.6946 | 4.7332 | 35838964.0 |
| 2007-07-11 09:40:00 | AAPL | Stock | 4.7329 | 4.7407 | 4.7157 | 4.735 | 25087076.0 |
| 2007-07-11 09:45:00 | AAPL | Stock | 4.7343 | 4.735 | 4.7186 | 4.7261 | 14428848.0 |
| 2007-07-11 09:50:00 | AAPL | Stock | 4.7264 | 4.7271 | 4.7 | 4.7021 | 18248272.0 |
| 2007-07-11 09:55:00 | AAPL | Stock | 4.7018 | 4.7211 | 4.7 | 4.7189 | 16013536.0 |
| 2007-07-11 10:00:00 | AAPL | Stock | 4.7193 | 4.7275 | 4.7075 | 4.7272 | 13477184.0 |
| 2007-07-11 10:05:00 | AAPL | Stock | 4.7275 | 4.7307 | 4.7211 | 4.7304 | 11145932.0 |
| 2007-07-11 10:10:00 | AAPL | Stock | 4.7302 | 4.7571 | 4.73 | 4.7497 | 26003012.0 |
| 2007-07-11 10:15:00 | AAPL | Stock | 4.7496 | 4.7618 | 4.7489 | 4.7546 | 17477712.0 |
| 2007-07-11 10:20:00 | AAPL | Stock | 4.7536 | 4.7554 | 4.7493 | 4.7514 | 11932060.0 |
| 2007-07-11 10:25:00 | AAPL | Stock | 4.7525 | 4.7529 | 4.7393 | 4.7514 | 14474152.0 |
| 2007-07-11 10:30:00 | AAPL | Stock | 4.7514 | 4.7568 | 4.7471 | 4.7486 | 13930616.0 |
| 2007-07-11 10:35:00 | AAPL | Stock | 4.7486 | 4.7646 | 4.748 | 4.7596 | 14289156.0 |
| 2007-07-11 10:40:00 | AAPL | Stock | 4.76 | 4.7704 | 4.7589 | 4.7593 | 20252288.0 |
| 2007-07-11 10:45:00 | AAPL | Stock | 4.7596 | 4.7604 | 4.75 | 4.7532 | 10330544.0 |
| 2007-07-11 10:50:00 | AAPL | Stock | 4.7532 | 4.7596 | 4.7532 | 4.7568 | 6142248.0 |
| 2007-07-11 10:55:00 | AAPL | Stock | 4.7564 | 4.7625 | 4.7554 | 4.76 | 7231476.0 |
| 2007-07-11 11:00:00 | AAPL | Stock | 4.76 | 4.7657 | 4.7593 | 4.7614 | 9673972.0 |
| 2007-07-11 11:05:00 | AAPL | Stock | 4.7611 | 4.7618 | 4.7557 | 4.7579 | 7182644.0 |
| 2007-07-11 11:10:00 | AAPL | Stock | 4.7582 | 4.7625 | 4.7557 | 4.7596 | 6915580.0 |
| 2007-07-11 11:15:00 | AAPL | Stock | 4.7593 | 4.7604 | 4.7554 | 4.7589 | 4947908.0 |
| 2007-07-11 11:20:00 | AAPL | Stock | 4.7586 | 4.7625 | 4.7579 | 4.7617 | 6154540.0 |
| 2007-07-11 11:25:00 | AAPL | Stock | 4.7618 | 4.7696 | 4.7614 | 4.7661 | 11333980.0 |
| 2007-07-11 11:30:00 | AAPL | Stock | 4.7661 | 4.775 | 4.7654 | 4.7689 | 12045852.0 |
| 2007-07-11 11:35:00 | AAPL | Stock | 4.7689 | 4.7693 | 4.7629 | 4.7647 | 6439720.0 |
| 2007-07-11 11:40:00 | AAPL | Stock | 4.765 | 4.7664 | 4.7564 | 4.7632 | 7814604.0 |
| 2007-07-11 11:45:00 | AAPL | Stock | 4.7632 | 4.7704 | 4.7621 | 4.7682 | 10443020.0 |
| 2007-07-11 11:50:00 | AAPL | Stock | 4.7682 | 4.7704 | 4.7679 | 4.7686 | 8459612.0 |
| 2007-07-11 11:55:00 | AAPL | Stock | 4.7682 | 4.7693 | 4.7518 | 4.7543 | 17029152.0 |
| 2007-07-11 12:00:00 | AAPL | Stock | 4.7543 | 4.7668 | 4.7525 | 4.755 | 14524944.0 |
| 2007-07-11 12:05:00 | AAPL | Stock | 4.755 | 4.7671 | 4.7543 | 4.7546 | 7651672.0 |
| 2007-07-11 12:10:00 | AAPL | Stock | 4.7546 | 4.7589 | 4.7543 | 4.7571 | 4697588.0 |
| 2007-07-11 12:15:00 | AAPL | Stock | 4.7564 | 4.7607 | 4.7518 | 4.7582 | 7558936.0 |
| 2007-07-11 12:20:00 | AAPL | Stock | 4.7579 | 4.7593 | 4.7546 | 4.7568 | 5146512.0 |
| 2007-07-11 12:25:00 | AAPL | Stock | 4.7568 | 4.7593 | 4.7543 | 4.7582 | 3938956.0 |
| 2007-07-11 12:30:00 | AAPL | Stock | 4.7582 | 4.7582 | 4.7504 | 4.7507 | 4667292.0 |
| 2007-07-11 12:35:00 | AAPL | Stock | 4.7514 | 4.755 | 4.7507 | 4.7537 | 2847348.0 |
| 2007-07-11 12:40:00 | AAPL | Stock | 4.7539 | 4.755 | 4.7504 | 4.7504 | 2709392.0 |
| 2007-07-11 12:45:00 | AAPL | Stock | 4.7504 | 4.7514 | 4.7357 | 4.7379 | 11658304.0 |
| 2007-07-11 12:50:00 | AAPL | Stock | 4.7379 | 4.7429 | 4.7332 | 4.7382 | 7739732.0 |
| 2007-07-11 12:55:00 | AAPL | Stock | 4.7379 | 4.7414 | 4.7361 | 4.7411 | 4669028.0 |
| 2007-07-11 13:00:00 | AAPL | Stock | 4.7411 | 4.7475 | 4.7396 | 4.7475 | 5854296.0 |
| 2007-07-11 13:05:00 | AAPL | Stock | 4.7468 | 4.7489 | 4.7461 | 4.7485 | 4975796.0 |
| 2007-07-11 13:10:00 | AAPL | Stock | 4.7486 | 4.7543 | 4.7464 | 4.7479 | 7559188.0 |
| 2007-07-11 13:15:00 | AAPL | Stock | 4.7482 | 4.7493 | 4.7454 | 4.7457 | 4306400.0 |
| 2007-07-11 13:20:00 | AAPL | Stock | 4.7454 | 4.7464 | 4.7393 | 4.74 | 5132176.0 |
| 2007-07-11 13:25:00 | AAPL | Stock | 4.7396 | 4.7443 | 4.7375 | 4.7432 | 4056724.0 |
| 2007-07-11 13:30:00 | AAPL | Stock | 4.7432 | 4.7521 | 4.7411 | 4.7514 | 7133840.0 |
| 2007-07-11 13:35:00 | AAPL | Stock | 4.7514 | 4.7536 | 4.7461 | 4.75 | 6048336.0 |
> showing 50 of 295,464 rows — these rows as CSV