PREVIEW / stock_1min / 2000-06-20
file: by_date/stock_1min/2000/2000-06-20.parquet size: 2.4 MB rows: 208,379 symbols: 956
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 |
|---|---|---|---|---|---|---|---|
| 2000-06-20 08:02:00 | AAPL | Stock | 0.863 | 0.863 | 0.863 | 0.863 | 504000.0 |
| 2000-06-20 08:05:00 | AAPL | Stock | 0.8728 | 0.875 | 0.8728 | 0.875 | 22400.0 |
| 2000-06-20 08:10:00 | AAPL | Stock | 0.8772 | 0.8772 | 0.875 | 0.875 | 22400.0 |
| 2000-06-20 08:13:00 | AAPL | Stock | 0.8719 | 0.8719 | 0.8697 | 0.8697 | 22400.0 |
| 2000-06-20 08:19:00 | AAPL | Stock | 0.8722 | 0.8722 | 0.8722 | 0.8722 | 11200.0 |
| 2000-06-20 08:20:00 | AAPL | Stock | 0.8717 | 0.8722 | 0.8717 | 0.8719 | 112000.0 |
| 2000-06-20 08:21:00 | AAPL | Stock | 0.8717 | 0.8717 | 0.8717 | 0.8717 | 44800.0 |
| 2000-06-20 08:26:00 | AAPL | Stock | 0.8733 | 0.8733 | 0.8733 | 0.8733 | 22400.0 |
| 2000-06-20 08:27:00 | AAPL | Stock | 0.8733 | 0.8733 | 0.8717 | 0.8719 | 134400.0 |
| 2000-06-20 08:29:00 | AAPL | Stock | 0.8638 | 0.8638 | 0.8638 | 0.8638 | 22400.0 |
| 2000-06-20 08:31:00 | AAPL | Stock | 0.8638 | 0.8638 | 0.8638 | 0.8638 | 33600.0 |
| 2000-06-20 08:37:00 | AAPL | Stock | 0.8666 | 0.8666 | 0.8666 | 0.8666 | 11200.0 |
| 2000-06-20 08:45:00 | AAPL | Stock | 0.8666 | 0.8666 | 0.8666 | 0.8666 | 22400.0 |
| 2000-06-20 08:58:00 | AAPL | Stock | 0.8661 | 0.8661 | 0.8627 | 0.8627 | 22400.0 |
| 2000-06-20 09:00:00 | AAPL | Stock | 0.8672 | 0.8672 | 0.8672 | 0.8672 | 89600.0 |
| 2000-06-20 09:10:00 | AAPL | Stock | 0.8672 | 0.8683 | 0.8672 | 0.8683 | 67200.0 |
| 2000-06-20 09:11:00 | AAPL | Stock | 0.8672 | 0.8672 | 0.8672 | 0.8672 | 22400.0 |
| 2000-06-20 09:12:00 | AAPL | Stock | 0.8672 | 0.8672 | 0.8672 | 0.8672 | 78400.0 |
| 2000-06-20 09:15:00 | AAPL | Stock | 0.8683 | 0.8683 | 0.8683 | 0.8683 | 89600.0 |
| 2000-06-20 09:16:00 | AAPL | Stock | 0.8672 | 0.8672 | 0.8661 | 0.8661 | 201600.0 |
| 2000-06-20 09:19:00 | AAPL | Stock | 0.8661 | 0.8661 | 0.8661 | 0.8661 | 11200.0 |
| 2000-06-20 09:20:00 | AAPL | Stock | 0.865 | 0.865 | 0.865 | 0.865 | 11200.0 |
| 2000-06-20 09:21:00 | AAPL | Stock | 0.8728 | 0.8728 | 0.8728 | 0.8728 | 11200.0 |
| 2000-06-20 09:22:00 | AAPL | Stock | 0.8722 | 0.8728 | 0.87 | 0.8728 | 78400.0 |
| 2000-06-20 09:23:00 | AAPL | Stock | 0.875 | 0.875 | 0.875 | 0.875 | 100800.0 |
| 2000-06-20 09:24:00 | AAPL | Stock | 0.8756 | 0.8772 | 0.875 | 0.8772 | 324800.0 |
| 2000-06-20 09:25:00 | AAPL | Stock | 0.8756 | 0.8795 | 0.8728 | 0.8783 | 705600.0 |
| 2000-06-20 09:26:00 | AAPL | Stock | 0.8795 | 0.8795 | 0.8783 | 0.8783 | 145600.0 |
| 2000-06-20 09:28:00 | AAPL | Stock | 0.8789 | 0.8795 | 0.8789 | 0.8789 | 492800.0 |
| 2000-06-20 09:29:00 | AAPL | Stock | 0.8795 | 0.8795 | 0.8795 | 0.8795 | 313600.0 |
| 2000-06-20 09:30:00 | AAPL | Stock | 0.8795 | 0.8817 | 0.8783 | 0.8811 | 168000.0 |
| 2000-06-20 09:31:00 | AAPL | Stock | 0.8806 | 0.8834 | 0.8795 | 0.8806 | 2643200.0 |
| 2000-06-20 09:32:00 | AAPL | Stock | 0.8834 | 0.8862 | 0.8795 | 0.8834 | 4894400.0 |
| 2000-06-20 09:33:00 | AAPL | Stock | 0.885 | 0.8873 | 0.8795 | 0.8817 | 4088000.0 |
| 2000-06-20 09:34:00 | AAPL | Stock | 0.8867 | 0.8884 | 0.8834 | 0.8884 | 3304000.0 |
| 2000-06-20 09:35:00 | AAPL | Stock | 0.8878 | 0.8884 | 0.8839 | 0.8839 | 6305600.0 |
| 2000-06-20 09:36:00 | AAPL | Stock | 0.8839 | 0.889 | 0.8839 | 0.889 | 4222400.0 |
| 2000-06-20 09:37:00 | AAPL | Stock | 0.8895 | 0.8951 | 0.8862 | 0.8951 | 5678400.0 |
| 2000-06-20 09:38:00 | AAPL | Stock | 0.8929 | 0.8956 | 0.885 | 0.894 | 6440000.0 |
| 2000-06-20 09:39:00 | AAPL | Stock | 0.8945 | 0.8962 | 0.894 | 0.8951 | 1086400.0 |
| 2000-06-20 09:40:00 | AAPL | Stock | 0.8962 | 0.8996 | 0.8929 | 0.8996 | 4043200.0 |
| 2000-06-20 09:41:00 | AAPL | Stock | 0.8996 | 0.9035 | 0.8951 | 0.9018 | 4928000.0 |
| 2000-06-20 09:42:00 | AAPL | Stock | 0.9035 | 0.9124 | 0.9012 | 0.9124 | 3225600.0 |
| 2000-06-20 09:43:00 | AAPL | Stock | 0.9124 | 0.9169 | 0.9082 | 0.9141 | 4032000.0 |
| 2000-06-20 09:44:00 | AAPL | Stock | 0.9152 | 0.9169 | 0.9107 | 0.9129 | 4020800.0 |
| 2000-06-20 09:45:00 | AAPL | Stock | 0.9135 | 0.9169 | 0.9085 | 0.9129 | 4614400.0 |
| 2000-06-20 09:46:00 | AAPL | Stock | 0.909 | 0.9135 | 0.9085 | 0.9085 | 3897600.0 |
| 2000-06-20 09:47:00 | AAPL | Stock | 0.9107 | 0.9107 | 0.9085 | 0.9102 | 1803200.0 |
| 2000-06-20 09:48:00 | AAPL | Stock | 0.9113 | 0.9135 | 0.9102 | 0.9135 | 2049600.0 |
| 2000-06-20 09:49:00 | AAPL | Stock | 0.9135 | 0.9169 | 0.9102 | 0.9163 | 3192000.0 |
> showing 50 of 208,379 rows — these rows as CSV