PREVIEW / stock_1min / 2004-11-09
file: by_date/stock_1min/2004/2004-11-09.parquet size: 6.2 MB rows: 522,233 symbols: 1,534
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 |
|---|---|---|---|---|---|---|---|
| 2004-11-09 08:00:00 | AAPL | Stock | 0.9739 | 0.9739 | 0.9739 | 0.9739 | 44800.0 |
| 2004-11-09 08:01:00 | AAPL | Stock | 0.9711 | 0.9741 | 0.9711 | 0.9713 | 84000.0 |
| 2004-11-09 08:02:00 | AAPL | Stock | 0.9723 | 0.9723 | 0.9723 | 0.9723 | 56000.0 |
| 2004-11-09 08:03:00 | AAPL | Stock | 0.9732 | 0.9732 | 0.9732 | 0.9732 | 5600.0 |
| 2004-11-09 08:06:00 | AAPL | Stock | 0.9732 | 0.9732 | 0.9732 | 0.9732 | 28000.0 |
| 2004-11-09 08:08:00 | AAPL | Stock | 0.9732 | 0.9732 | 0.9732 | 0.9732 | 36400.0 |
| 2004-11-09 08:10:00 | AAPL | Stock | 0.9732 | 0.9732 | 0.9718 | 0.9718 | 81200.0 |
| 2004-11-09 08:18:00 | AAPL | Stock | 0.9732 | 0.9732 | 0.9732 | 0.9732 | 28000.0 |
| 2004-11-09 08:24:00 | AAPL | Stock | 0.9711 | 0.9711 | 0.9711 | 0.9711 | 669536.0 |
| 2004-11-09 08:26:00 | AAPL | Stock | 0.9711 | 0.9711 | 0.9711 | 0.9711 | 669536.0 |
| 2004-11-09 08:32:00 | AAPL | Stock | 0.9723 | 0.9723 | 0.9723 | 0.9723 | 44800.0 |
| 2004-11-09 08:33:00 | AAPL | Stock | 0.9723 | 0.9723 | 0.9723 | 0.9723 | 11200.0 |
| 2004-11-09 08:35:00 | AAPL | Stock | 0.9732 | 0.9732 | 0.9732 | 0.9732 | 16800.0 |
| 2004-11-09 08:36:00 | AAPL | Stock | 0.9721 | 0.9721 | 0.9718 | 0.9721 | 89600.0 |
| 2004-11-09 08:46:00 | AAPL | Stock | 0.9732 | 0.9732 | 0.9732 | 0.9732 | 5600.0 |
| 2004-11-09 08:48:00 | AAPL | Stock | 0.9732 | 0.9732 | 0.9732 | 0.9732 | 11200.0 |
| 2004-11-09 08:54:00 | AAPL | Stock | 0.9723 | 0.9723 | 0.9723 | 0.9723 | 16800.0 |
| 2004-11-09 09:11:00 | AAPL | Stock | 0.9732 | 0.9732 | 0.9732 | 0.9732 | 16800.0 |
| 2004-11-09 09:12:00 | AAPL | Stock | 0.9732 | 0.9732 | 0.9732 | 0.9732 | 11200.0 |
| 2004-11-09 09:16:00 | AAPL | Stock | 0.9732 | 0.9732 | 0.9732 | 0.9732 | 16800.0 |
| 2004-11-09 09:20:00 | AAPL | Stock | 0.9718 | 0.9718 | 0.9714 | 0.9714 | 56000.0 |
| 2004-11-09 09:21:00 | AAPL | Stock | 0.9718 | 0.9718 | 0.9705 | 0.9705 | 72240.0 |
| 2004-11-09 09:22:00 | AAPL | Stock | 0.9704 | 0.9704 | 0.9704 | 0.9704 | 10920.0 |
| 2004-11-09 09:23:00 | AAPL | Stock | 0.9705 | 0.9705 | 0.9705 | 0.9705 | 32760.0 |
| 2004-11-09 09:25:00 | AAPL | Stock | 0.9714 | 0.9721 | 0.9684 | 0.9696 | 101360.0 |
| 2004-11-09 09:26:00 | AAPL | Stock | 0.9696 | 0.9696 | 0.9695 | 0.9695 | 11200.0 |
| 2004-11-09 09:27:00 | AAPL | Stock | 0.9698 | 0.9709 | 0.9698 | 0.9709 | 11200.0 |
| 2004-11-09 09:29:00 | AAPL | Stock | 0.9689 | 0.9696 | 0.9679 | 0.9695 | 599480.0 |
| 2004-11-09 09:30:00 | AAPL | Stock | 0.9679 | 0.9705 | 0.9673 | 0.9682 | 4941944.0 |
| 2004-11-09 09:31:00 | AAPL | Stock | 0.9691 | 0.9691 | 0.9643 | 0.965 | 3797360.0 |
| 2004-11-09 09:32:00 | AAPL | Stock | 0.965 | 0.9674 | 0.9645 | 0.9661 | 5434128.0 |
| 2004-11-09 09:33:00 | AAPL | Stock | 0.9659 | 0.9661 | 0.9643 | 0.9659 | 3009048.0 |
| 2004-11-09 09:34:00 | AAPL | Stock | 0.9659 | 0.9663 | 0.9648 | 0.9661 | 1865080.0 |
| 2004-11-09 09:35:00 | AAPL | Stock | 0.9661 | 0.9695 | 0.9659 | 0.9673 | 3165288.0 |
| 2004-11-09 09:36:00 | AAPL | Stock | 0.9682 | 0.9711 | 0.9671 | 0.9702 | 4262720.0 |
| 2004-11-09 09:37:00 | AAPL | Stock | 0.9702 | 0.9705 | 0.9698 | 0.9704 | 1288840.0 |
| 2004-11-09 09:38:00 | AAPL | Stock | 0.9702 | 0.9714 | 0.9698 | 0.9711 | 3226832.0 |
| 2004-11-09 09:39:00 | AAPL | Stock | 0.9713 | 0.9727 | 0.9704 | 0.9713 | 3897376.0 |
| 2004-11-09 09:40:00 | AAPL | Stock | 0.9713 | 0.9713 | 0.9688 | 0.9691 | 2953048.0 |
| 2004-11-09 09:41:00 | AAPL | Stock | 0.9693 | 0.9707 | 0.9693 | 0.9704 | 2541896.0 |
| 2004-11-09 09:42:00 | AAPL | Stock | 0.9707 | 0.972 | 0.9695 | 0.9716 | 3681272.0 |
| 2004-11-09 09:43:00 | AAPL | Stock | 0.97 | 0.9707 | 0.9679 | 0.9686 | 1925224.0 |
| 2004-11-09 09:44:00 | AAPL | Stock | 0.9691 | 0.9691 | 0.9671 | 0.9684 | 2310056.0 |
| 2004-11-09 09:45:00 | AAPL | Stock | 0.9684 | 0.9709 | 0.9684 | 0.9705 | 3247272.0 |
| 2004-11-09 09:46:00 | AAPL | Stock | 0.9704 | 0.9707 | 0.9693 | 0.9695 | 3046792.0 |
| 2004-11-09 09:47:00 | AAPL | Stock | 0.9695 | 0.97 | 0.9671 | 0.9682 | 2802800.0 |
| 2004-11-09 09:48:00 | AAPL | Stock | 0.9682 | 0.9693 | 0.9677 | 0.9686 | 2600024.0 |
| 2004-11-09 09:49:00 | AAPL | Stock | 0.9682 | 0.9695 | 0.9682 | 0.9691 | 1825488.0 |
| 2004-11-09 09:50:00 | AAPL | Stock | 0.9693 | 0.9698 | 0.9691 | 0.9691 | 1219008.0 |
| 2004-11-09 09:51:00 | AAPL | Stock | 0.9691 | 0.9695 | 0.9679 | 0.9682 | 1143352.0 |
> showing 50 of 522,233 rows — these rows as CSV