PREVIEW / stock_1min / 2006-11-13
file: by_date/stock_1min/2006/2006-11-13.parquet size: 8.9 MB rows: 721,799 symbols: 1,996
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-11-13 08:00:00 | AAPL | Stock | 2.9704 | 2.9732 | 2.9696 | 2.9707 | 66668.0 |
| 2006-11-13 08:06:00 | AAPL | Stock | 2.9732 | 2.9764 | 2.9732 | 2.9764 | 109200.0 |
| 2006-11-13 08:10:00 | AAPL | Stock | 2.9761 | 2.9761 | 2.9761 | 2.9761 | 2800.0 |
| 2006-11-13 08:11:00 | AAPL | Stock | 2.9732 | 2.9732 | 2.9711 | 2.9711 | 28000.0 |
| 2006-11-13 08:14:00 | AAPL | Stock | 2.975 | 2.975 | 2.9711 | 2.9711 | 16800.0 |
| 2006-11-13 08:17:00 | AAPL | Stock | 2.9714 | 2.9714 | 2.9714 | 2.9714 | 2800.0 |
| 2006-11-13 08:19:00 | AAPL | Stock | 2.97 | 2.97 | 2.9696 | 2.9696 | 88200.0 |
| 2006-11-13 08:21:00 | AAPL | Stock | 2.9714 | 2.9714 | 2.9714 | 2.9714 | 2800.0 |
| 2006-11-13 08:22:00 | AAPL | Stock | 2.9714 | 2.9714 | 2.9714 | 2.9714 | 8400.0 |
| 2006-11-13 08:23:00 | AAPL | Stock | 2.9714 | 2.9714 | 2.9714 | 2.9714 | 78400.0 |
| 2006-11-13 08:27:00 | AAPL | Stock | 2.9696 | 2.9696 | 2.9696 | 2.9696 | 28000.0 |
| 2006-11-13 08:28:00 | AAPL | Stock | 2.9696 | 2.9696 | 2.9689 | 2.9689 | 23800.0 |
| 2006-11-13 08:33:00 | AAPL | Stock | 2.9689 | 2.9689 | 2.9689 | 2.9689 | 2800.0 |
| 2006-11-13 08:37:00 | AAPL | Stock | 2.9689 | 2.9689 | 2.9689 | 2.9689 | 14896.0 |
| 2006-11-13 08:38:00 | AAPL | Stock | 2.9693 | 2.9693 | 2.9693 | 2.9693 | 28000.0 |
| 2006-11-13 08:42:00 | AAPL | Stock | 2.9704 | 2.9714 | 2.9704 | 2.9714 | 11200.0 |
| 2006-11-13 08:46:00 | AAPL | Stock | 2.9732 | 2.9732 | 2.9732 | 2.9732 | 81200.0 |
| 2006-11-13 08:51:00 | AAPL | Stock | 2.9707 | 2.9707 | 2.9704 | 2.9704 | 8904.0 |
| 2006-11-13 08:54:00 | AAPL | Stock | 2.9696 | 2.9696 | 2.9686 | 2.9686 | 11200.0 |
| 2006-11-13 08:55:00 | AAPL | Stock | 2.9696 | 2.9696 | 2.9696 | 2.9696 | 8904.0 |
| 2006-11-13 09:00:00 | AAPL | Stock | 2.9696 | 2.9696 | 2.9696 | 2.9696 | 14000.0 |
| 2006-11-13 09:02:00 | AAPL | Stock | 2.9696 | 2.9696 | 2.9696 | 2.9696 | 14000.0 |
| 2006-11-13 09:13:00 | AAPL | Stock | 2.9696 | 2.9696 | 2.9696 | 2.9696 | 12012.0 |
| 2006-11-13 09:14:00 | AAPL | Stock | 2.9696 | 2.9696 | 2.9696 | 2.9696 | 130788.0 |
| 2006-11-13 09:16:00 | AAPL | Stock | 2.9696 | 2.9696 | 2.9696 | 2.9696 | 16800.0 |
| 2006-11-13 09:19:00 | AAPL | Stock | 2.9693 | 2.9693 | 2.9693 | 2.9693 | 2800.0 |
| 2006-11-13 09:24:00 | AAPL | Stock | 2.9689 | 2.9693 | 2.9689 | 2.9693 | 33600.0 |
| 2006-11-13 09:26:00 | AAPL | Stock | 2.9664 | 2.9664 | 2.9661 | 2.9661 | 36400.0 |
| 2006-11-13 09:27:00 | AAPL | Stock | 2.9646 | 2.9646 | 2.9646 | 2.9646 | 5600.0 |
| 2006-11-13 09:28:00 | AAPL | Stock | 2.97 | 2.97 | 2.9679 | 2.9679 | 18368.0 |
| 2006-11-13 09:29:00 | AAPL | Stock | 2.9696 | 2.9721 | 2.9696 | 2.9721 | 75936.0 |
| 2006-11-13 09:30:00 | AAPL | Stock | 2.9732 | 2.9754 | 2.9636 | 2.9636 | 4175612.0 |
| 2006-11-13 09:31:00 | AAPL | Stock | 2.9676 | 2.9714 | 2.9632 | 2.9661 | 1426544.0 |
| 2006-11-13 09:32:00 | AAPL | Stock | 2.9657 | 2.9686 | 2.9646 | 2.9671 | 1739752.0 |
| 2006-11-13 09:33:00 | AAPL | Stock | 2.9671 | 2.9675 | 2.9625 | 2.9632 | 1288476.0 |
| 2006-11-13 09:34:00 | AAPL | Stock | 2.9635 | 2.9639 | 2.9514 | 2.9546 | 3630508.0 |
| 2006-11-13 09:35:00 | AAPL | Stock | 2.9546 | 2.9571 | 2.9525 | 2.9564 | 2326940.0 |
| 2006-11-13 09:36:00 | AAPL | Stock | 2.9564 | 2.9568 | 2.9532 | 2.955 | 1024548.0 |
| 2006-11-13 09:37:00 | AAPL | Stock | 2.955 | 2.9621 | 2.9543 | 2.9595 | 1772680.0 |
| 2006-11-13 09:38:00 | AAPL | Stock | 2.96 | 2.9636 | 2.9593 | 2.9636 | 1554196.0 |
| 2006-11-13 09:39:00 | AAPL | Stock | 2.9639 | 2.9657 | 2.9629 | 2.9639 | 1822436.0 |
| 2006-11-13 09:40:00 | AAPL | Stock | 2.9639 | 2.9686 | 2.9625 | 2.9682 | 1353632.0 |
| 2006-11-13 09:41:00 | AAPL | Stock | 2.9686 | 2.9732 | 2.9646 | 2.9721 | 2881508.0 |
| 2006-11-13 09:42:00 | AAPL | Stock | 2.9725 | 2.9811 | 2.9725 | 2.9793 | 3243548.0 |
| 2006-11-13 09:43:00 | AAPL | Stock | 2.9804 | 2.9821 | 2.9779 | 2.9786 | 2537780.0 |
| 2006-11-13 09:44:00 | AAPL | Stock | 2.9793 | 2.9793 | 2.9743 | 2.9743 | 2023196.0 |
| 2006-11-13 09:45:00 | AAPL | Stock | 2.975 | 2.975 | 2.9721 | 2.9729 | 1539384.0 |
| 2006-11-13 09:46:00 | AAPL | Stock | 2.9732 | 2.975 | 2.9725 | 2.9736 | 1916460.0 |
| 2006-11-13 09:47:00 | AAPL | Stock | 2.9732 | 2.975 | 2.9707 | 2.9743 | 1552376.0 |
| 2006-11-13 09:48:00 | AAPL | Stock | 2.9739 | 2.9779 | 2.9739 | 2.9779 | 1294916.0 |
> showing 50 of 721,799 rows — these rows as CSV