PREVIEW / stock_1min / 2005-10-07
file: by_date/stock_1min/2005/2005-10-07.parquet size: 7.0 MB rows: 581,024 symbols: 1,706
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-07 07:05:00 | AAPL | Stock | 1.8446 | 1.8446 | 1.8446 | 1.8446 | 117600.0 |
| 2005-10-07 07:06:00 | AAPL | Stock | 1.8407 | 1.8407 | 1.8407 | 1.8407 | 56000.0 |
| 2005-10-07 07:07:00 | AAPL | Stock | 1.8182 | 1.8182 | 1.8182 | 1.8182 | 14000.0 |
| 2005-10-07 07:09:00 | AAPL | Stock | 1.8243 | 1.8243 | 1.8243 | 1.8243 | 28000.0 |
| 2005-10-07 07:10:00 | AAPL | Stock | 1.8236 | 1.8236 | 1.8214 | 1.8214 | 19600.0 |
| 2005-10-07 07:11:00 | AAPL | Stock | 1.8196 | 1.8196 | 1.8196 | 1.8196 | 14000.0 |
| 2005-10-07 07:12:00 | AAPL | Stock | 1.8196 | 1.8196 | 1.8143 | 1.8143 | 120400.0 |
| 2005-10-07 07:13:00 | AAPL | Stock | 1.8157 | 1.8157 | 1.8157 | 1.8157 | 14000.0 |
| 2005-10-07 07:14:00 | AAPL | Stock | 1.8161 | 1.8161 | 1.8161 | 1.8161 | 5600.0 |
| 2005-10-07 07:15:00 | AAPL | Stock | 1.8161 | 1.8161 | 1.8161 | 1.8161 | 29680.0 |
| 2005-10-07 07:16:00 | AAPL | Stock | 1.8143 | 1.8143 | 1.8118 | 1.8118 | 22400.0 |
| 2005-10-07 07:20:00 | AAPL | Stock | 1.8146 | 1.8146 | 1.8146 | 1.8146 | 28000.0 |
| 2005-10-07 07:29:00 | AAPL | Stock | 1.8143 | 1.8143 | 1.8143 | 1.8143 | 28000.0 |
| 2005-10-07 07:30:00 | AAPL | Stock | 1.8143 | 1.8143 | 1.8143 | 1.8143 | 64400.0 |
| 2005-10-07 07:32:00 | AAPL | Stock | 1.8168 | 1.8189 | 1.8168 | 1.8189 | 5600.0 |
| 2005-10-07 07:37:00 | AAPL | Stock | 1.8171 | 1.8171 | 1.8171 | 1.8171 | 26040.0 |
| 2005-10-07 07:43:00 | AAPL | Stock | 1.8196 | 1.8196 | 1.8196 | 1.8196 | 5600.0 |
| 2005-10-07 07:45:00 | AAPL | Stock | 1.8186 | 1.8186 | 1.8186 | 1.8186 | 14000.0 |
| 2005-10-07 07:46:00 | AAPL | Stock | 1.8143 | 1.8143 | 1.8143 | 1.8143 | 14000.0 |
| 2005-10-07 07:49:00 | AAPL | Stock | 1.8193 | 1.8193 | 1.8193 | 1.8193 | 2800.0 |
| 2005-10-07 07:50:00 | AAPL | Stock | 1.8143 | 1.8143 | 1.8143 | 1.8143 | 2800.0 |
| 2005-10-07 07:52:00 | AAPL | Stock | 1.8161 | 1.8161 | 1.8143 | 1.8143 | 56000.0 |
| 2005-10-07 07:54:00 | AAPL | Stock | 1.8143 | 1.8143 | 1.8143 | 1.8143 | 28000.0 |
| 2005-10-07 08:00:00 | AAPL | Stock | 1.8129 | 1.8196 | 1.8129 | 1.8143 | 47600.0 |
| 2005-10-07 08:01:00 | AAPL | Stock | 1.8143 | 1.8179 | 1.8129 | 1.8143 | 660716.0 |
| 2005-10-07 08:02:00 | AAPL | Stock | 1.8146 | 1.8146 | 1.8139 | 1.8139 | 87080.0 |
| 2005-10-07 08:03:00 | AAPL | Stock | 1.8139 | 1.8139 | 1.8107 | 1.8107 | 195440.0 |
| 2005-10-07 08:04:00 | AAPL | Stock | 1.8107 | 1.8107 | 1.8036 | 1.8036 | 265020.0 |
| 2005-10-07 08:05:00 | AAPL | Stock | 1.8036 | 1.8071 | 1.8018 | 1.8061 | 351400.0 |
| 2005-10-07 08:06:00 | AAPL | Stock | 1.8071 | 1.8093 | 1.8039 | 1.8039 | 175560.0 |
| 2005-10-07 08:07:00 | AAPL | Stock | 1.8054 | 1.8079 | 1.8039 | 1.8075 | 123200.0 |
| 2005-10-07 08:08:00 | AAPL | Stock | 1.8039 | 1.8064 | 1.8039 | 1.8057 | 31108.0 |
| 2005-10-07 08:09:00 | AAPL | Stock | 1.8064 | 1.8071 | 1.8036 | 1.8036 | 121240.0 |
| 2005-10-07 08:10:00 | AAPL | Stock | 1.8036 | 1.8061 | 1.8032 | 1.8061 | 242592.0 |
| 2005-10-07 08:11:00 | AAPL | Stock | 1.8082 | 1.8111 | 1.8075 | 1.8079 | 52360.0 |
| 2005-10-07 08:12:00 | AAPL | Stock | 1.8089 | 1.81 | 1.8075 | 1.81 | 58800.0 |
| 2005-10-07 08:13:00 | AAPL | Stock | 1.8082 | 1.8082 | 1.8079 | 1.8079 | 25200.0 |
| 2005-10-07 08:14:00 | AAPL | Stock | 1.8075 | 1.8075 | 1.8071 | 1.8075 | 42000.0 |
| 2005-10-07 08:15:00 | AAPL | Stock | 1.8075 | 1.8079 | 1.8071 | 1.8071 | 50400.0 |
| 2005-10-07 08:16:00 | AAPL | Stock | 1.8075 | 1.8079 | 1.8075 | 1.8075 | 22400.0 |
| 2005-10-07 08:17:00 | AAPL | Stock | 1.8071 | 1.8079 | 1.8057 | 1.8057 | 214900.0 |
| 2005-10-07 08:18:00 | AAPL | Stock | 1.8061 | 1.8061 | 1.8061 | 1.8061 | 5600.0 |
| 2005-10-07 08:19:00 | AAPL | Stock | 1.8061 | 1.8068 | 1.8061 | 1.8068 | 11200.0 |
| 2005-10-07 08:20:00 | AAPL | Stock | 1.8057 | 1.8057 | 1.8054 | 1.8054 | 74620.0 |
| 2005-10-07 08:21:00 | AAPL | Stock | 1.8057 | 1.8057 | 1.8036 | 1.8043 | 207228.0 |
| 2005-10-07 08:22:00 | AAPL | Stock | 1.8032 | 1.8057 | 1.8025 | 1.8054 | 221200.0 |
| 2005-10-07 08:23:00 | AAPL | Stock | 1.8061 | 1.8061 | 1.8036 | 1.8036 | 33600.0 |
| 2005-10-07 08:24:00 | AAPL | Stock | 1.8039 | 1.8043 | 1.8018 | 1.8018 | 137200.0 |
| 2005-10-07 08:25:00 | AAPL | Stock | 1.8021 | 1.8021 | 1.8018 | 1.8018 | 184800.0 |
| 2005-10-07 08:26:00 | AAPL | Stock | 1.8036 | 1.8068 | 1.8021 | 1.8068 | 56000.0 |
> showing 50 of 581,024 rows — these rows as CSV