PREVIEW / stock_1min / 2009-09-04
file: by_date/stock_1min/2009/2009-09-04.parquet size: 11.9 MB rows: 914,289 symbols: 2,711
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 |
|---|---|---|---|---|---|---|---|
| 2009-09-04 04:15:00 | AAPL | Stock | 6.0 | 6.0 | 6.0 | 6.0 | 2800.0 |
| 2009-09-04 06:50:00 | AAPL | Stock | 5.95 | 5.95 | 5.95 | 5.95 | 2800.0 |
| 2009-09-04 07:02:00 | AAPL | Stock | 5.95 | 5.95 | 5.95 | 5.95 | 11200.0 |
| 2009-09-04 07:11:00 | AAPL | Stock | 5.9643 | 5.9643 | 5.9643 | 5.9643 | 12320.0 |
| 2009-09-04 07:29:00 | AAPL | Stock | 5.9643 | 5.9643 | 5.9464 | 5.9464 | 30800.0 |
| 2009-09-04 07:41:00 | AAPL | Stock | 5.9471 | 5.9471 | 5.9464 | 5.9464 | 8400.0 |
| 2009-09-04 07:53:00 | AAPL | Stock | 5.9629 | 5.9643 | 5.9629 | 5.9643 | 12600.0 |
| 2009-09-04 07:56:00 | AAPL | Stock | 5.9643 | 5.9643 | 5.9643 | 5.9643 | 12880.0 |
| 2009-09-04 08:00:00 | AAPL | Stock | 5.9754 | 5.9821 | 5.9643 | 5.9821 | 60760.0 |
| 2009-09-04 08:01:00 | AAPL | Stock | 5.965 | 5.98 | 5.9646 | 5.98 | 57680.0 |
| 2009-09-04 08:03:00 | AAPL | Stock | 5.9679 | 5.9786 | 5.9679 | 5.9786 | 122360.0 |
| 2009-09-04 08:04:00 | AAPL | Stock | 5.9786 | 5.9786 | 5.9786 | 5.9786 | 31500.0 |
| 2009-09-04 08:05:00 | AAPL | Stock | 5.975 | 5.975 | 5.975 | 5.975 | 13720.0 |
| 2009-09-04 08:06:00 | AAPL | Stock | 5.975 | 5.975 | 5.975 | 5.975 | 50960.0 |
| 2009-09-04 08:07:00 | AAPL | Stock | 5.975 | 5.975 | 5.975 | 5.975 | 5600.0 |
| 2009-09-04 08:08:00 | AAPL | Stock | 5.9721 | 5.975 | 5.9714 | 5.975 | 18480.0 |
| 2009-09-04 08:09:00 | AAPL | Stock | 5.9714 | 5.9714 | 5.9714 | 5.9714 | 14000.0 |
| 2009-09-04 08:10:00 | AAPL | Stock | 5.9714 | 5.9714 | 5.9714 | 5.9714 | 22400.0 |
| 2009-09-04 08:12:00 | AAPL | Stock | 5.9664 | 5.9664 | 5.9643 | 5.9643 | 11172.0 |
| 2009-09-04 08:14:00 | AAPL | Stock | 5.9679 | 5.9679 | 5.9679 | 5.9679 | 28924.0 |
| 2009-09-04 08:15:00 | AAPL | Stock | 5.9671 | 5.9679 | 5.965 | 5.965 | 43232.0 |
| 2009-09-04 08:18:00 | AAPL | Stock | 5.9614 | 5.9614 | 5.9614 | 5.9614 | 2800.0 |
| 2009-09-04 08:21:00 | AAPL | Stock | 5.9639 | 5.9639 | 5.9639 | 5.9639 | 5600.0 |
| 2009-09-04 08:22:00 | AAPL | Stock | 5.9625 | 5.9639 | 5.9625 | 5.9639 | 14000.0 |
| 2009-09-04 08:23:00 | AAPL | Stock | 5.9604 | 5.9604 | 5.96 | 5.96 | 5600.0 |
| 2009-09-04 08:24:00 | AAPL | Stock | 5.9596 | 5.9596 | 5.9596 | 5.9596 | 16828.0 |
| 2009-09-04 08:27:00 | AAPL | Stock | 5.9639 | 5.9643 | 5.9639 | 5.9643 | 11900.0 |
| 2009-09-04 08:28:00 | AAPL | Stock | 5.9636 | 5.9643 | 5.9636 | 5.9643 | 37240.0 |
| 2009-09-04 08:29:00 | AAPL | Stock | 5.9643 | 5.9643 | 5.9625 | 5.9625 | 26488.0 |
| 2009-09-04 08:30:00 | AAPL | Stock | 5.9586 | 5.9586 | 5.9286 | 5.9286 | 156772.0 |
| 2009-09-04 08:31:00 | AAPL | Stock | 5.9286 | 5.9393 | 5.9225 | 5.9332 | 93548.0 |
| 2009-09-04 08:32:00 | AAPL | Stock | 5.9289 | 5.9393 | 5.9289 | 5.9393 | 92904.0 |
| 2009-09-04 08:33:00 | AAPL | Stock | 5.9393 | 5.9464 | 5.9393 | 5.9464 | 43400.0 |
| 2009-09-04 08:34:00 | AAPL | Stock | 5.9543 | 5.955 | 5.9504 | 5.955 | 58800.0 |
| 2009-09-04 08:35:00 | AAPL | Stock | 5.9611 | 5.9775 | 5.9561 | 5.9761 | 275632.0 |
| 2009-09-04 08:36:00 | AAPL | Stock | 5.9761 | 5.9761 | 5.9761 | 5.9761 | 11900.0 |
| 2009-09-04 08:37:00 | AAPL | Stock | 5.9761 | 5.9786 | 5.9696 | 5.9786 | 73668.0 |
| 2009-09-04 08:38:00 | AAPL | Stock | 5.9793 | 5.9793 | 5.9714 | 5.975 | 58492.0 |
| 2009-09-04 08:39:00 | AAPL | Stock | 5.975 | 5.98 | 5.9736 | 5.9786 | 92260.0 |
| 2009-09-04 08:40:00 | AAPL | Stock | 5.9786 | 5.9786 | 5.9782 | 5.9782 | 8400.0 |
| 2009-09-04 08:41:00 | AAPL | Stock | 5.9782 | 5.9782 | 5.975 | 5.975 | 30800.0 |
| 2009-09-04 08:42:00 | AAPL | Stock | 5.9754 | 5.9782 | 5.975 | 5.975 | 35448.0 |
| 2009-09-04 08:43:00 | AAPL | Stock | 5.975 | 5.975 | 5.9718 | 5.9739 | 211960.0 |
| 2009-09-04 08:44:00 | AAPL | Stock | 5.9739 | 5.9739 | 5.9704 | 5.9714 | 107660.0 |
| 2009-09-04 08:45:00 | AAPL | Stock | 5.9721 | 5.9732 | 5.9711 | 5.9714 | 76720.0 |
| 2009-09-04 08:46:00 | AAPL | Stock | 5.9714 | 5.9732 | 5.9704 | 5.9725 | 72800.0 |
| 2009-09-04 08:47:00 | AAPL | Stock | 5.9714 | 5.9718 | 5.9714 | 5.9714 | 43876.0 |
| 2009-09-04 08:48:00 | AAPL | Stock | 5.9725 | 5.9768 | 5.9725 | 5.9757 | 94500.0 |
| 2009-09-04 08:49:00 | AAPL | Stock | 5.9775 | 5.9779 | 5.9754 | 5.9779 | 54600.0 |
| 2009-09-04 08:50:00 | AAPL | Stock | 5.9757 | 5.9761 | 5.9754 | 5.9757 | 41524.0 |
> showing 50 of 914,289 rows — these rows as CSV