PREVIEW / stock_1min / 2004-11-11
file: by_date/stock_1min/2004/2004-11-11.parquet size: 6.1 MB rows: 512,169 symbols: 1,530
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-11 08:23:00 | AAPL | Stock | 0.9813 | 0.9813 | 0.9813 | 0.9813 | 9576.0 |
| 2004-11-11 08:29:00 | AAPL | Stock | 0.9821 | 0.9821 | 0.9821 | 0.9821 | 5600.0 |
| 2004-11-11 08:30:00 | AAPL | Stock | 0.98 | 0.98 | 0.98 | 0.98 | 16800.0 |
| 2004-11-11 08:38:00 | AAPL | Stock | 0.9813 | 0.9813 | 0.9813 | 0.9813 | 28000.0 |
| 2004-11-11 08:40:00 | AAPL | Stock | 0.9813 | 0.9813 | 0.9813 | 0.9813 | 56000.0 |
| 2004-11-11 08:45:00 | AAPL | Stock | 0.9839 | 0.9839 | 0.9839 | 0.9839 | 112000.0 |
| 2004-11-11 08:50:00 | AAPL | Stock | 0.9839 | 0.9841 | 0.9839 | 0.9841 | 39200.0 |
| 2004-11-11 08:54:00 | AAPL | Stock | 0.9855 | 0.9857 | 0.9855 | 0.9857 | 30240.0 |
| 2004-11-11 08:55:00 | AAPL | Stock | 0.9821 | 0.9823 | 0.9821 | 0.9823 | 44800.0 |
| 2004-11-11 08:56:00 | AAPL | Stock | 0.9821 | 0.9821 | 0.9821 | 0.9821 | 56000.0 |
| 2004-11-11 08:57:00 | AAPL | Stock | 0.9821 | 0.9821 | 0.9821 | 0.9821 | 16800.0 |
| 2004-11-11 09:14:00 | AAPL | Stock | 0.9821 | 0.9821 | 0.9821 | 0.9821 | 16800.0 |
| 2004-11-11 09:21:00 | AAPL | Stock | 0.9813 | 0.9813 | 0.9813 | 0.9813 | 70616.0 |
| 2004-11-11 09:25:00 | AAPL | Stock | 0.9805 | 0.9809 | 0.9805 | 0.9809 | 11200.0 |
| 2004-11-11 09:27:00 | AAPL | Stock | 0.9821 | 0.9821 | 0.9804 | 0.9804 | 242144.0 |
| 2004-11-11 09:28:00 | AAPL | Stock | 0.9804 | 0.9807 | 0.9804 | 0.9804 | 274400.0 |
| 2004-11-11 09:29:00 | AAPL | Stock | 0.9804 | 0.9814 | 0.98 | 0.9811 | 838656.0 |
| 2004-11-11 09:30:00 | AAPL | Stock | 0.9809 | 0.982 | 0.9809 | 0.982 | 70000.0 |
| 2004-11-11 09:31:00 | AAPL | Stock | 0.982 | 0.982 | 0.9809 | 0.9814 | 506240.0 |
| 2004-11-11 09:32:00 | AAPL | Stock | 0.9807 | 0.9814 | 0.9796 | 0.98 | 1260784.0 |
| 2004-11-11 09:33:00 | AAPL | Stock | 0.98 | 0.9804 | 0.9788 | 0.9791 | 723296.0 |
| 2004-11-11 09:34:00 | AAPL | Stock | 0.9789 | 0.9804 | 0.9789 | 0.9804 | 280112.0 |
| 2004-11-11 09:35:00 | AAPL | Stock | 0.9805 | 0.9813 | 0.9805 | 0.9813 | 95648.0 |
| 2004-11-11 09:36:00 | AAPL | Stock | 0.9813 | 0.9816 | 0.9804 | 0.9809 | 992712.0 |
| 2004-11-11 09:37:00 | AAPL | Stock | 0.9813 | 0.9816 | 0.98 | 0.98 | 299600.0 |
| 2004-11-11 09:38:00 | AAPL | Stock | 0.9802 | 0.9804 | 0.9795 | 0.9795 | 200816.0 |
| 2004-11-11 09:39:00 | AAPL | Stock | 0.9802 | 0.9802 | 0.9782 | 0.9789 | 509824.0 |
| 2004-11-11 09:40:00 | AAPL | Stock | 0.9793 | 0.9795 | 0.9777 | 0.9784 | 176400.0 |
| 2004-11-11 09:41:00 | AAPL | Stock | 0.9779 | 0.9798 | 0.9779 | 0.9789 | 118888.0 |
| 2004-11-11 09:42:00 | AAPL | Stock | 0.9788 | 0.98 | 0.9786 | 0.9798 | 302288.0 |
| 2004-11-11 09:43:00 | AAPL | Stock | 0.9793 | 0.9802 | 0.9786 | 0.9786 | 156800.0 |
| 2004-11-11 09:44:00 | AAPL | Stock | 0.9786 | 0.98 | 0.9786 | 0.98 | 286720.0 |
| 2004-11-11 09:45:00 | AAPL | Stock | 0.9798 | 0.98 | 0.9795 | 0.9796 | 156800.0 |
| 2004-11-11 09:46:00 | AAPL | Stock | 0.9796 | 0.9798 | 0.9795 | 0.9798 | 531664.0 |
| 2004-11-11 09:47:00 | AAPL | Stock | 0.9796 | 0.9796 | 0.9788 | 0.9788 | 117600.0 |
| 2004-11-11 09:48:00 | AAPL | Stock | 0.9791 | 0.9793 | 0.9784 | 0.9786 | 616000.0 |
| 2004-11-11 09:49:00 | AAPL | Stock | 0.9786 | 0.9795 | 0.9784 | 0.9789 | 1079792.0 |
| 2004-11-11 09:50:00 | AAPL | Stock | 0.9784 | 0.9795 | 0.9784 | 0.9789 | 257880.0 |
| 2004-11-11 09:51:00 | AAPL | Stock | 0.9788 | 0.9788 | 0.9773 | 0.9777 | 1116304.0 |
| 2004-11-11 09:52:00 | AAPL | Stock | 0.9777 | 0.9777 | 0.9763 | 0.9763 | 1034824.0 |
| 2004-11-11 09:53:00 | AAPL | Stock | 0.9763 | 0.9775 | 0.9761 | 0.9773 | 1585136.0 |
| 2004-11-11 09:54:00 | AAPL | Stock | 0.9768 | 0.9768 | 0.9741 | 0.975 | 1342376.0 |
| 2004-11-11 09:55:00 | AAPL | Stock | 0.9755 | 0.9755 | 0.9727 | 0.9741 | 1954400.0 |
| 2004-11-11 09:56:00 | AAPL | Stock | 0.9745 | 0.975 | 0.9714 | 0.9729 | 1839264.0 |
| 2004-11-11 09:57:00 | AAPL | Stock | 0.9723 | 0.9732 | 0.9702 | 0.9705 | 2785328.0 |
| 2004-11-11 09:58:00 | AAPL | Stock | 0.9702 | 0.9711 | 0.9684 | 0.9702 | 3174192.0 |
| 2004-11-11 09:59:00 | AAPL | Stock | 0.9704 | 0.9714 | 0.9693 | 0.971 | 2624440.0 |
| 2004-11-11 10:00:00 | AAPL | Stock | 0.9711 | 0.9723 | 0.9702 | 0.9723 | 3293360.0 |
| 2004-11-11 10:01:00 | AAPL | Stock | 0.9723 | 0.9741 | 0.9705 | 0.9741 | 3495352.0 |
| 2004-11-11 10:02:00 | AAPL | Stock | 0.9741 | 0.9775 | 0.9732 | 0.9775 | 5668768.0 |
> showing 50 of 512,169 rows — these rows as CSV