PREVIEW / stock_1min / 2007-10-02
file: by_date/stock_1min/2007/2007-10-02.parquet size: 11.7 MB rows: 955,289 symbols: 2,550
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 |
|---|---|---|---|---|---|---|---|
| 2007-10-02 05:47:00 | AAPL | Stock | 5.6018 | 5.6018 | 5.6018 | 5.6018 | 4200.0 |
| 2007-10-02 05:57:00 | AAPL | Stock | 5.6018 | 5.6018 | 5.6018 | 5.6018 | 11200.0 |
| 2007-10-02 06:03:00 | AAPL | Stock | 5.6018 | 5.6018 | 5.6018 | 5.6018 | 6272.0 |
| 2007-10-02 06:21:00 | AAPL | Stock | 5.6154 | 5.6154 | 5.6154 | 5.6154 | 2800.0 |
| 2007-10-02 06:41:00 | AAPL | Stock | 5.6154 | 5.6154 | 5.6154 | 5.6154 | 2800.0 |
| 2007-10-02 07:06:00 | AAPL | Stock | 5.6018 | 5.6086 | 5.6018 | 5.6086 | 8400.0 |
| 2007-10-02 07:07:00 | AAPL | Stock | 5.6086 | 5.6093 | 5.6086 | 5.6093 | 19600.0 |
| 2007-10-02 07:08:00 | AAPL | Stock | 5.6143 | 5.6161 | 5.6143 | 5.6161 | 16800.0 |
| 2007-10-02 07:09:00 | AAPL | Stock | 5.6061 | 5.6061 | 5.6061 | 5.6061 | 11200.0 |
| 2007-10-02 07:10:00 | AAPL | Stock | 5.6043 | 5.6043 | 5.6043 | 5.6043 | 2800.0 |
| 2007-10-02 07:12:00 | AAPL | Stock | 5.6171 | 5.6171 | 5.6171 | 5.6171 | 2800.0 |
| 2007-10-02 07:16:00 | AAPL | Stock | 5.6168 | 5.6186 | 5.6168 | 5.6186 | 33600.0 |
| 2007-10-02 07:17:00 | AAPL | Stock | 5.6189 | 5.6189 | 5.6175 | 5.6175 | 19600.0 |
| 2007-10-02 07:20:00 | AAPL | Stock | 5.6143 | 5.6143 | 5.6143 | 5.6143 | 8400.0 |
| 2007-10-02 07:24:00 | AAPL | Stock | 5.6054 | 5.6054 | 5.6054 | 5.6054 | 2800.0 |
| 2007-10-02 07:25:00 | AAPL | Stock | 5.5929 | 5.5929 | 5.5929 | 5.5929 | 2800.0 |
| 2007-10-02 07:27:00 | AAPL | Stock | 5.5936 | 5.5936 | 5.5936 | 5.5936 | 2800.0 |
| 2007-10-02 07:36:00 | AAPL | Stock | 5.5982 | 5.5982 | 5.5982 | 5.5982 | 5600.0 |
| 2007-10-02 07:38:00 | AAPL | Stock | 5.6071 | 5.6071 | 5.6071 | 5.6071 | 9800.0 |
| 2007-10-02 07:40:00 | AAPL | Stock | 5.6068 | 5.6068 | 5.6068 | 5.6068 | 13300.0 |
| 2007-10-02 07:41:00 | AAPL | Stock | 5.6107 | 5.6107 | 5.6107 | 5.6107 | 14000.0 |
| 2007-10-02 07:44:00 | AAPL | Stock | 5.6107 | 5.6114 | 5.6107 | 5.6114 | 5600.0 |
| 2007-10-02 07:50:00 | AAPL | Stock | 5.6125 | 5.6125 | 5.6125 | 5.6125 | 14000.0 |
| 2007-10-02 07:52:00 | AAPL | Stock | 5.6125 | 5.6125 | 5.6121 | 5.6125 | 36400.0 |
| 2007-10-02 07:56:00 | AAPL | Stock | 5.6061 | 5.6061 | 5.6054 | 5.6054 | 42000.0 |
| 2007-10-02 08:00:00 | AAPL | Stock | 5.6071 | 5.615 | 5.6039 | 5.6071 | 493360.0 |
| 2007-10-02 08:01:00 | AAPL | Stock | 5.6071 | 5.6104 | 5.6064 | 5.6071 | 90384.0 |
| 2007-10-02 08:02:00 | AAPL | Stock | 5.6068 | 5.6104 | 5.6061 | 5.6104 | 132748.0 |
| 2007-10-02 08:03:00 | AAPL | Stock | 5.6107 | 5.6107 | 5.6071 | 5.6079 | 115108.0 |
| 2007-10-02 08:04:00 | AAPL | Stock | 5.6079 | 5.6079 | 5.6075 | 5.6075 | 5600.0 |
| 2007-10-02 08:05:00 | AAPL | Stock | 5.6071 | 5.6093 | 5.6071 | 5.6093 | 77308.0 |
| 2007-10-02 08:06:00 | AAPL | Stock | 5.6093 | 5.6107 | 5.6061 | 5.6061 | 110124.0 |
| 2007-10-02 08:07:00 | AAPL | Stock | 5.6054 | 5.6071 | 5.6043 | 5.6071 | 42000.0 |
| 2007-10-02 08:08:00 | AAPL | Stock | 5.6071 | 5.6071 | 5.6071 | 5.6071 | 23800.0 |
| 2007-10-02 08:09:00 | AAPL | Stock | 5.6071 | 5.6096 | 5.6071 | 5.6096 | 56000.0 |
| 2007-10-02 08:10:00 | AAPL | Stock | 5.6107 | 5.6121 | 5.6107 | 5.6121 | 154448.0 |
| 2007-10-02 08:11:00 | AAPL | Stock | 5.6125 | 5.6125 | 5.6086 | 5.6086 | 67200.0 |
| 2007-10-02 08:12:00 | AAPL | Stock | 5.6107 | 5.6118 | 5.6043 | 5.6043 | 152600.0 |
| 2007-10-02 08:13:00 | AAPL | Stock | 5.6068 | 5.6096 | 5.6068 | 5.6096 | 43904.0 |
| 2007-10-02 08:14:00 | AAPL | Stock | 5.6082 | 5.6089 | 5.6075 | 5.6089 | 22400.0 |
| 2007-10-02 08:15:00 | AAPL | Stock | 5.6089 | 5.6089 | 5.6071 | 5.6071 | 30800.0 |
| 2007-10-02 08:16:00 | AAPL | Stock | 5.6071 | 5.6121 | 5.6071 | 5.6121 | 95676.0 |
| 2007-10-02 08:17:00 | AAPL | Stock | 5.6061 | 5.6071 | 5.6054 | 5.6054 | 33600.0 |
| 2007-10-02 08:18:00 | AAPL | Stock | 5.6046 | 5.6071 | 5.6036 | 5.6071 | 52080.0 |
| 2007-10-02 08:19:00 | AAPL | Stock | 5.6054 | 5.6071 | 5.6036 | 5.6036 | 138180.0 |
| 2007-10-02 08:20:00 | AAPL | Stock | 5.6039 | 5.6057 | 5.6036 | 5.6036 | 71792.0 |
| 2007-10-02 08:21:00 | AAPL | Stock | 5.6036 | 5.6071 | 5.6029 | 5.6029 | 70868.0 |
| 2007-10-02 08:22:00 | AAPL | Stock | 5.6025 | 5.6025 | 5.6014 | 5.6014 | 49840.0 |
| 2007-10-02 08:23:00 | AAPL | Stock | 5.6 | 5.6 | 5.5964 | 5.5964 | 213332.0 |
| 2007-10-02 08:24:00 | AAPL | Stock | 5.5982 | 5.6014 | 5.5982 | 5.6 | 93744.0 |
> showing 50 of 955,289 rows — these rows as CSV