PREVIEW / stock_1min / 2004-04-02
file: by_date/stock_1min/2004/2004-04-02.parquet size: 6.1 MB rows: 512,765 symbols: 1,449
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-04-02 08:01:00 | AAPL | Stock | 0.4841 | 0.4841 | 0.4841 | 0.4841 | 112000.0 |
| 2004-04-02 08:09:00 | AAPL | Stock | 0.4866 | 0.4866 | 0.4866 | 0.4866 | 5600.0 |
| 2004-04-02 08:17:00 | AAPL | Stock | 0.4841 | 0.4841 | 0.4841 | 0.4841 | 112000.0 |
| 2004-04-02 08:30:00 | AAPL | Stock | 0.4875 | 0.4875 | 0.4875 | 0.4875 | 5600.0 |
| 2004-04-02 08:32:00 | AAPL | Stock | 0.4882 | 0.4882 | 0.4882 | 0.4882 | 22400.0 |
| 2004-04-02 08:36:00 | AAPL | Stock | 0.4909 | 0.4909 | 0.4909 | 0.4909 | 28000.0 |
| 2004-04-02 08:37:00 | AAPL | Stock | 0.4914 | 0.4914 | 0.4914 | 0.4914 | 5600.0 |
| 2004-04-02 08:40:00 | AAPL | Stock | 0.492 | 0.492 | 0.492 | 0.492 | 28000.0 |
| 2004-04-02 08:41:00 | AAPL | Stock | 0.4938 | 0.4943 | 0.4936 | 0.4938 | 84000.0 |
| 2004-04-02 08:46:00 | AAPL | Stock | 0.4946 | 0.4946 | 0.4946 | 0.4946 | 16800.0 |
| 2004-04-02 08:47:00 | AAPL | Stock | 0.4946 | 0.4946 | 0.4946 | 0.4946 | 235200.0 |
| 2004-04-02 08:48:00 | AAPL | Stock | 0.4946 | 0.4946 | 0.4946 | 0.4946 | 112000.0 |
| 2004-04-02 08:49:00 | AAPL | Stock | 0.4941 | 0.4941 | 0.493 | 0.493 | 16800.0 |
| 2004-04-02 08:50:00 | AAPL | Stock | 0.492 | 0.492 | 0.492 | 0.492 | 19600.0 |
| 2004-04-02 08:55:00 | AAPL | Stock | 0.492 | 0.4929 | 0.492 | 0.4929 | 81200.0 |
| 2004-04-02 08:59:00 | AAPL | Stock | 0.493 | 0.493 | 0.493 | 0.493 | 56000.0 |
| 2004-04-02 09:00:00 | AAPL | Stock | 0.4938 | 0.4938 | 0.4938 | 0.4938 | 11200.0 |
| 2004-04-02 09:03:00 | AAPL | Stock | 0.493 | 0.493 | 0.493 | 0.493 | 22400.0 |
| 2004-04-02 09:04:00 | AAPL | Stock | 0.493 | 0.493 | 0.492 | 0.493 | 397600.0 |
| 2004-04-02 09:09:00 | AAPL | Stock | 0.4927 | 0.4929 | 0.4927 | 0.4929 | 56000.0 |
| 2004-04-02 09:10:00 | AAPL | Stock | 0.4932 | 0.4932 | 0.4929 | 0.4929 | 44800.0 |
| 2004-04-02 09:16:00 | AAPL | Stock | 0.493 | 0.493 | 0.493 | 0.493 | 5600.0 |
| 2004-04-02 09:17:00 | AAPL | Stock | 0.4929 | 0.4929 | 0.4929 | 0.4929 | 11200.0 |
| 2004-04-02 09:21:00 | AAPL | Stock | 0.493 | 0.493 | 0.4929 | 0.4929 | 117600.0 |
| 2004-04-02 09:23:00 | AAPL | Stock | 0.4938 | 0.4938 | 0.4938 | 0.4938 | 72800.0 |
| 2004-04-02 09:24:00 | AAPL | Stock | 0.4938 | 0.4938 | 0.4938 | 0.4938 | 28000.0 |
| 2004-04-02 09:26:00 | AAPL | Stock | 0.4938 | 0.4938 | 0.4938 | 0.4938 | 28000.0 |
| 2004-04-02 09:27:00 | AAPL | Stock | 0.4938 | 0.4938 | 0.4938 | 0.4938 | 140000.0 |
| 2004-04-02 09:29:00 | AAPL | Stock | 0.4921 | 0.4948 | 0.4921 | 0.4936 | 1345568.0 |
| 2004-04-02 09:30:00 | AAPL | Stock | 0.4954 | 0.4966 | 0.492 | 0.4961 | 8292872.0 |
| 2004-04-02 09:31:00 | AAPL | Stock | 0.4941 | 0.4968 | 0.4934 | 0.4955 | 2253104.0 |
| 2004-04-02 09:32:00 | AAPL | Stock | 0.4955 | 0.4964 | 0.4948 | 0.4952 | 1754032.0 |
| 2004-04-02 09:33:00 | AAPL | Stock | 0.4954 | 0.4971 | 0.4948 | 0.497 | 2225104.0 |
| 2004-04-02 09:34:00 | AAPL | Stock | 0.4966 | 0.4988 | 0.4955 | 0.4963 | 8279712.0 |
| 2004-04-02 09:35:00 | AAPL | Stock | 0.4961 | 0.4971 | 0.4955 | 0.4963 | 1602608.0 |
| 2004-04-02 09:36:00 | AAPL | Stock | 0.4963 | 0.4963 | 0.495 | 0.4954 | 3485160.0 |
| 2004-04-02 09:37:00 | AAPL | Stock | 0.4954 | 0.4963 | 0.4952 | 0.4955 | 1938496.0 |
| 2004-04-02 09:38:00 | AAPL | Stock | 0.4961 | 0.4961 | 0.4955 | 0.4955 | 173600.0 |
| 2004-04-02 09:39:00 | AAPL | Stock | 0.4955 | 0.4955 | 0.4954 | 0.4955 | 760480.0 |
| 2004-04-02 09:40:00 | AAPL | Stock | 0.4955 | 0.497 | 0.4954 | 0.4966 | 1870960.0 |
| 2004-04-02 09:41:00 | AAPL | Stock | 0.4966 | 0.4968 | 0.4954 | 0.4954 | 968016.0 |
| 2004-04-02 09:42:00 | AAPL | Stock | 0.4954 | 0.4954 | 0.4946 | 0.4948 | 976640.0 |
| 2004-04-02 09:43:00 | AAPL | Stock | 0.4948 | 0.4948 | 0.4946 | 0.4948 | 1443120.0 |
| 2004-04-02 09:44:00 | AAPL | Stock | 0.4948 | 0.4954 | 0.4945 | 0.4945 | 2881144.0 |
| 2004-04-02 09:45:00 | AAPL | Stock | 0.4945 | 0.4951 | 0.493 | 0.493 | 4037544.0 |
| 2004-04-02 09:46:00 | AAPL | Stock | 0.493 | 0.493 | 0.4913 | 0.4916 | 1448104.0 |
| 2004-04-02 09:47:00 | AAPL | Stock | 0.4914 | 0.4916 | 0.4904 | 0.4914 | 1352848.0 |
| 2004-04-02 09:48:00 | AAPL | Stock | 0.4914 | 0.493 | 0.4895 | 0.4905 | 3908800.0 |
| 2004-04-02 09:49:00 | AAPL | Stock | 0.4918 | 0.4927 | 0.4914 | 0.4927 | 812224.0 |
| 2004-04-02 09:50:00 | AAPL | Stock | 0.4925 | 0.4927 | 0.4914 | 0.4914 | 612192.0 |
> showing 50 of 512,765 rows — these rows as CSV