PREVIEW / stock_1min / 2008-09-30
file: by_date/stock_1min/2008/2008-09-30.parquet size: 13.3 MB rows: 1,063,760 symbols: 2,756
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 |
|---|---|---|---|---|---|---|---|
| 2008-09-30 04:12:00 | AAPL | Stock | 3.7882 | 3.7882 | 3.7882 | 3.7882 | 25452.0 |
| 2008-09-30 04:13:00 | AAPL | Stock | 3.7857 | 3.7857 | 3.7857 | 3.7857 | 5600.0 |
| 2008-09-30 04:20:00 | AAPL | Stock | 3.8211 | 3.8211 | 3.8211 | 3.8211 | 28000.0 |
| 2008-09-30 04:21:00 | AAPL | Stock | 3.7746 | 3.7746 | 3.7746 | 3.7746 | 14000.0 |
| 2008-09-30 04:24:00 | AAPL | Stock | 3.8136 | 3.8136 | 3.8125 | 3.8136 | 54600.0 |
| 2008-09-30 04:27:00 | AAPL | Stock | 3.8032 | 3.8032 | 3.8032 | 3.8032 | 2800.0 |
| 2008-09-30 04:28:00 | AAPL | Stock | 3.8032 | 3.8032 | 3.8032 | 3.8032 | 2800.0 |
| 2008-09-30 04:30:00 | AAPL | Stock | 3.7786 | 3.7786 | 3.7786 | 3.7786 | 14000.0 |
| 2008-09-30 04:32:00 | AAPL | Stock | 3.7857 | 3.7857 | 3.7857 | 3.7857 | 14000.0 |
| 2008-09-30 04:33:00 | AAPL | Stock | 3.7818 | 3.7821 | 3.7818 | 3.7821 | 8400.0 |
| 2008-09-30 04:34:00 | AAPL | Stock | 3.7821 | 3.7821 | 3.7821 | 3.7821 | 53200.0 |
| 2008-09-30 04:36:00 | AAPL | Stock | 3.7857 | 3.7857 | 3.7821 | 3.7821 | 22400.0 |
| 2008-09-30 04:37:00 | AAPL | Stock | 3.7821 | 3.7821 | 3.7821 | 3.7821 | 2800.0 |
| 2008-09-30 05:05:00 | AAPL | Stock | 3.7768 | 3.7768 | 3.7768 | 3.7768 | 2800.0 |
| 2008-09-30 05:13:00 | AAPL | Stock | 3.7768 | 3.7768 | 3.7768 | 3.7768 | 2800.0 |
| 2008-09-30 05:16:00 | AAPL | Stock | 3.7839 | 3.7839 | 3.7839 | 3.7839 | 11200.0 |
| 2008-09-30 05:17:00 | AAPL | Stock | 3.7839 | 3.7911 | 3.7839 | 3.7886 | 8400.0 |
| 2008-09-30 05:18:00 | AAPL | Stock | 3.7857 | 3.7857 | 3.7839 | 3.7839 | 5600.0 |
| 2008-09-30 05:20:00 | AAPL | Stock | 3.7839 | 3.7839 | 3.7839 | 3.7839 | 2800.0 |
| 2008-09-30 05:21:00 | AAPL | Stock | 3.7857 | 3.7875 | 3.7857 | 3.7875 | 39200.0 |
| 2008-09-30 05:22:00 | AAPL | Stock | 3.7911 | 3.7911 | 3.7875 | 3.7911 | 14000.0 |
| 2008-09-30 05:23:00 | AAPL | Stock | 3.7896 | 3.7921 | 3.7896 | 3.7921 | 20020.0 |
| 2008-09-30 05:24:00 | AAPL | Stock | 3.8 | 3.8 | 3.8 | 3.8 | 2800.0 |
| 2008-09-30 05:25:00 | AAPL | Stock | 3.8 | 3.8 | 3.8 | 3.8 | 2800.0 |
| 2008-09-30 05:26:00 | AAPL | Stock | 3.7993 | 3.7993 | 3.7929 | 3.7929 | 11200.0 |
| 2008-09-30 05:28:00 | AAPL | Stock | 3.7875 | 3.7875 | 3.7857 | 3.7857 | 5600.0 |
| 2008-09-30 05:30:00 | AAPL | Stock | 3.7839 | 3.7839 | 3.7839 | 3.7839 | 2800.0 |
| 2008-09-30 05:34:00 | AAPL | Stock | 3.7946 | 3.7946 | 3.7946 | 3.7946 | 14000.0 |
| 2008-09-30 05:38:00 | AAPL | Stock | 3.7857 | 3.7857 | 3.7857 | 3.7857 | 64540.0 |
| 2008-09-30 05:40:00 | AAPL | Stock | 3.7961 | 3.7961 | 3.7961 | 3.7961 | 2800.0 |
| 2008-09-30 05:41:00 | AAPL | Stock | 3.7964 | 3.7964 | 3.7964 | 3.7964 | 2800.0 |
| 2008-09-30 05:45:00 | AAPL | Stock | 3.8 | 3.8 | 3.8 | 3.8 | 2800.0 |
| 2008-09-30 05:51:00 | AAPL | Stock | 3.8068 | 3.8071 | 3.8 | 3.8 | 8400.0 |
| 2008-09-30 05:52:00 | AAPL | Stock | 3.8 | 3.8214 | 3.8 | 3.8214 | 25900.0 |
| 2008-09-30 05:53:00 | AAPL | Stock | 3.8214 | 3.8214 | 3.8214 | 3.8214 | 2800.0 |
| 2008-09-30 05:54:00 | AAPL | Stock | 3.8214 | 3.8214 | 3.8214 | 3.8214 | 2800.0 |
| 2008-09-30 05:55:00 | AAPL | Stock | 3.8179 | 3.8179 | 3.8179 | 3.8179 | 2800.0 |
| 2008-09-30 05:57:00 | AAPL | Stock | 3.8179 | 3.8214 | 3.8179 | 3.8214 | 14000.0 |
| 2008-09-30 05:58:00 | AAPL | Stock | 3.8214 | 3.8214 | 3.8214 | 3.8214 | 2800.0 |
| 2008-09-30 06:13:00 | AAPL | Stock | 3.8214 | 3.8214 | 3.8214 | 3.8214 | 2800.0 |
| 2008-09-30 06:19:00 | AAPL | Stock | 3.7964 | 3.7964 | 3.7964 | 3.7964 | 28000.0 |
| 2008-09-30 06:20:00 | AAPL | Stock | 3.7964 | 3.8 | 3.7857 | 3.7857 | 39200.0 |
| 2008-09-30 06:23:00 | AAPL | Stock | 3.7857 | 3.7857 | 3.7857 | 3.7857 | 28000.0 |
| 2008-09-30 06:24:00 | AAPL | Stock | 3.8 | 3.8036 | 3.8 | 3.8036 | 56000.0 |
| 2008-09-30 06:25:00 | AAPL | Stock | 3.8036 | 3.8036 | 3.8036 | 3.8036 | 8400.0 |
| 2008-09-30 06:27:00 | AAPL | Stock | 3.8036 | 3.8036 | 3.8036 | 3.8036 | 28000.0 |
| 2008-09-30 06:29:00 | AAPL | Stock | 3.795 | 3.795 | 3.795 | 3.795 | 28000.0 |
| 2008-09-30 06:31:00 | AAPL | Stock | 3.7861 | 3.7861 | 3.7857 | 3.7857 | 42000.0 |
| 2008-09-30 06:32:00 | AAPL | Stock | 3.7857 | 3.7943 | 3.7857 | 3.7943 | 5600.0 |
| 2008-09-30 06:36:00 | AAPL | Stock | 3.7857 | 3.7857 | 3.7857 | 3.7857 | 33600.0 |
> showing 50 of 1,063,760 rows — these rows as CSV