PREVIEW / stock_1min / 2005-10-31
file: by_date/stock_1min/2005/2005-10-31.parquet size: 7.8 MB rows: 632,778 symbols: 1,736
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-31 07:57:00 | AAPL | Stock | 1.9571 | 1.9571 | 1.9571 | 1.9571 | 2800.0 |
| 2005-10-31 08:01:00 | AAPL | Stock | 1.9518 | 1.9579 | 1.9518 | 1.9579 | 47096.0 |
| 2005-10-31 08:02:00 | AAPL | Stock | 1.9589 | 1.9643 | 1.9589 | 1.9636 | 75320.0 |
| 2005-10-31 08:03:00 | AAPL | Stock | 1.9607 | 1.9643 | 1.9607 | 1.9643 | 84000.0 |
| 2005-10-31 08:04:00 | AAPL | Stock | 1.9643 | 1.9643 | 1.9643 | 1.9643 | 14000.0 |
| 2005-10-31 08:05:00 | AAPL | Stock | 1.9679 | 1.9679 | 1.9679 | 1.9679 | 8400.0 |
| 2005-10-31 08:06:00 | AAPL | Stock | 1.9696 | 1.9696 | 1.9679 | 1.9696 | 59024.0 |
| 2005-10-31 08:07:00 | AAPL | Stock | 1.9696 | 1.9707 | 1.9696 | 1.9707 | 22876.0 |
| 2005-10-31 08:08:00 | AAPL | Stock | 1.9707 | 1.9707 | 1.9643 | 1.9643 | 138600.0 |
| 2005-10-31 08:09:00 | AAPL | Stock | 1.9661 | 1.9661 | 1.9643 | 1.9643 | 72324.0 |
| 2005-10-31 08:10:00 | AAPL | Stock | 1.9643 | 1.9643 | 1.9643 | 1.9643 | 12600.0 |
| 2005-10-31 08:11:00 | AAPL | Stock | 1.9661 | 1.9661 | 1.9661 | 1.9661 | 12600.0 |
| 2005-10-31 08:12:00 | AAPL | Stock | 1.9607 | 1.9607 | 1.9607 | 1.9607 | 14000.0 |
| 2005-10-31 08:13:00 | AAPL | Stock | 1.9643 | 1.9643 | 1.9643 | 1.9643 | 14000.0 |
| 2005-10-31 08:14:00 | AAPL | Stock | 1.9643 | 1.9643 | 1.9643 | 1.9643 | 8400.0 |
| 2005-10-31 08:15:00 | AAPL | Stock | 1.9607 | 1.9607 | 1.9607 | 1.9607 | 2800.0 |
| 2005-10-31 08:17:00 | AAPL | Stock | 1.9639 | 1.9639 | 1.9639 | 1.9639 | 2800.0 |
| 2005-10-31 08:18:00 | AAPL | Stock | 1.9614 | 1.9614 | 1.9614 | 1.9614 | 2800.0 |
| 2005-10-31 08:21:00 | AAPL | Stock | 1.9636 | 1.9654 | 1.9636 | 1.9642 | 223720.0 |
| 2005-10-31 08:23:00 | AAPL | Stock | 1.9643 | 1.9661 | 1.9643 | 1.9661 | 22400.0 |
| 2005-10-31 08:24:00 | AAPL | Stock | 1.9671 | 1.9675 | 1.9657 | 1.9657 | 25200.0 |
| 2005-10-31 08:26:00 | AAPL | Stock | 1.9664 | 1.9664 | 1.9664 | 1.9664 | 7000.0 |
| 2005-10-31 08:27:00 | AAPL | Stock | 1.9664 | 1.9664 | 1.9664 | 1.9664 | 8400.0 |
| 2005-10-31 08:28:00 | AAPL | Stock | 1.9661 | 1.9661 | 1.9661 | 1.9661 | 2800.0 |
| 2005-10-31 08:29:00 | AAPL | Stock | 1.9661 | 1.9661 | 1.9661 | 1.9661 | 4200.0 |
| 2005-10-31 08:30:00 | AAPL | Stock | 1.9661 | 1.9664 | 1.9657 | 1.9664 | 47572.0 |
| 2005-10-31 08:31:00 | AAPL | Stock | 1.9668 | 1.9714 | 1.9664 | 1.9714 | 198660.0 |
| 2005-10-31 08:32:00 | AAPL | Stock | 1.9714 | 1.9714 | 1.9711 | 1.9711 | 18200.0 |
| 2005-10-31 08:33:00 | AAPL | Stock | 1.9686 | 1.9686 | 1.9686 | 1.9686 | 2800.0 |
| 2005-10-31 08:34:00 | AAPL | Stock | 1.9696 | 1.97 | 1.9696 | 1.97 | 25200.0 |
| 2005-10-31 08:35:00 | AAPL | Stock | 1.9689 | 1.97 | 1.9689 | 1.9689 | 16800.0 |
| 2005-10-31 08:36:00 | AAPL | Stock | 1.9696 | 1.9696 | 1.9689 | 1.9689 | 18200.0 |
| 2005-10-31 08:37:00 | AAPL | Stock | 1.9671 | 1.9671 | 1.9664 | 1.9664 | 27300.0 |
| 2005-10-31 08:38:00 | AAPL | Stock | 1.9689 | 1.9689 | 1.9689 | 1.9689 | 2800.0 |
| 2005-10-31 08:39:00 | AAPL | Stock | 1.9689 | 1.97 | 1.9689 | 1.97 | 16800.0 |
| 2005-10-31 08:40:00 | AAPL | Stock | 1.9696 | 1.9696 | 1.9686 | 1.9686 | 18200.0 |
| 2005-10-31 08:41:00 | AAPL | Stock | 1.97 | 1.97 | 1.97 | 1.97 | 9632.0 |
| 2005-10-31 08:43:00 | AAPL | Stock | 1.9686 | 1.9707 | 1.9686 | 1.9704 | 40096.0 |
| 2005-10-31 08:46:00 | AAPL | Stock | 1.9704 | 1.9721 | 1.9704 | 1.9714 | 52220.0 |
| 2005-10-31 08:47:00 | AAPL | Stock | 1.9721 | 1.9732 | 1.9721 | 1.9732 | 70308.0 |
| 2005-10-31 08:48:00 | AAPL | Stock | 1.9743 | 1.9743 | 1.9721 | 1.9739 | 78400.0 |
| 2005-10-31 08:49:00 | AAPL | Stock | 1.9721 | 1.9721 | 1.9721 | 1.9721 | 28000.0 |
| 2005-10-31 08:50:00 | AAPL | Stock | 1.9729 | 1.9729 | 1.9729 | 1.9729 | 26320.0 |
| 2005-10-31 08:51:00 | AAPL | Stock | 1.9732 | 1.9743 | 1.9732 | 1.9743 | 84000.0 |
| 2005-10-31 08:52:00 | AAPL | Stock | 1.975 | 1.9768 | 1.975 | 1.975 | 338240.0 |
| 2005-10-31 08:53:00 | AAPL | Stock | 1.975 | 1.975 | 1.9743 | 1.9743 | 165200.0 |
| 2005-10-31 08:54:00 | AAPL | Stock | 1.975 | 1.9768 | 1.9743 | 1.975 | 120400.0 |
| 2005-10-31 08:55:00 | AAPL | Stock | 1.9768 | 1.9768 | 1.975 | 1.975 | 397376.0 |
| 2005-10-31 08:56:00 | AAPL | Stock | 1.975 | 1.9764 | 1.975 | 1.9764 | 52304.0 |
| 2005-10-31 08:57:00 | AAPL | Stock | 1.9761 | 1.9768 | 1.9757 | 1.9761 | 114576.0 |
> showing 50 of 632,778 rows — these rows as CSV