PREVIEW / stock_1min / 2006-12-07
file: by_date/stock_1min/2006/2006-12-07.parquet size: 8.6 MB rows: 693,025 symbols: 2,003
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 |
|---|---|---|---|---|---|---|---|
| 2006-12-07 06:00:00 | AAPL | Stock | 3.2146 | 3.2146 | 3.2146 | 3.2146 | 2800.0 |
| 2006-12-07 07:14:00 | AAPL | Stock | 3.2125 | 3.2125 | 3.2125 | 3.2125 | 5600.0 |
| 2006-12-07 07:23:00 | AAPL | Stock | 3.215 | 3.215 | 3.215 | 3.215 | 5600.0 |
| 2006-12-07 07:31:00 | AAPL | Stock | 3.2161 | 3.2161 | 3.2161 | 3.2161 | 5600.0 |
| 2006-12-07 07:37:00 | AAPL | Stock | 3.2182 | 3.2182 | 3.2182 | 3.2182 | 11200.0 |
| 2006-12-07 07:48:00 | AAPL | Stock | 3.2182 | 3.2182 | 3.2182 | 3.2182 | 11200.0 |
| 2006-12-07 07:50:00 | AAPL | Stock | 3.2211 | 3.2218 | 3.2211 | 3.2218 | 22400.0 |
| 2006-12-07 07:52:00 | AAPL | Stock | 3.2218 | 3.2218 | 3.2218 | 3.2218 | 14000.0 |
| 2006-12-07 07:53:00 | AAPL | Stock | 3.2232 | 3.2232 | 3.2232 | 3.2232 | 14000.0 |
| 2006-12-07 07:55:00 | AAPL | Stock | 3.2232 | 3.2232 | 3.2168 | 3.2168 | 5600.0 |
| 2006-12-07 08:00:00 | AAPL | Stock | 3.2168 | 3.2182 | 3.2168 | 3.2168 | 93800.0 |
| 2006-12-07 08:01:00 | AAPL | Stock | 3.2168 | 3.2168 | 3.2168 | 3.2168 | 18200.0 |
| 2006-12-07 08:02:00 | AAPL | Stock | 3.2211 | 3.2232 | 3.2211 | 3.2232 | 45500.0 |
| 2006-12-07 08:03:00 | AAPL | Stock | 3.2229 | 3.2229 | 3.2214 | 3.2214 | 43400.0 |
| 2006-12-07 08:04:00 | AAPL | Stock | 3.2214 | 3.2214 | 3.2214 | 3.2214 | 58800.0 |
| 2006-12-07 08:05:00 | AAPL | Stock | 3.2214 | 3.2218 | 3.2214 | 3.2214 | 30800.0 |
| 2006-12-07 08:06:00 | AAPL | Stock | 3.2214 | 3.2229 | 3.2214 | 3.2229 | 42000.0 |
| 2006-12-07 08:07:00 | AAPL | Stock | 3.2229 | 3.2229 | 3.2229 | 3.2229 | 23800.0 |
| 2006-12-07 08:08:00 | AAPL | Stock | 3.2232 | 3.2232 | 3.2232 | 3.2232 | 22400.0 |
| 2006-12-07 08:09:00 | AAPL | Stock | 3.2232 | 3.2232 | 3.2229 | 3.2229 | 17220.0 |
| 2006-12-07 08:10:00 | AAPL | Stock | 3.2218 | 3.2218 | 3.2214 | 3.2214 | 23520.0 |
| 2006-12-07 08:11:00 | AAPL | Stock | 3.2214 | 3.2232 | 3.2214 | 3.2232 | 55020.0 |
| 2006-12-07 08:12:00 | AAPL | Stock | 3.2229 | 3.2232 | 3.2229 | 3.2232 | 25200.0 |
| 2006-12-07 08:13:00 | AAPL | Stock | 3.2232 | 3.2232 | 3.2232 | 3.2232 | 72800.0 |
| 2006-12-07 08:14:00 | AAPL | Stock | 3.2214 | 3.2218 | 3.2214 | 3.2218 | 11200.0 |
| 2006-12-07 08:15:00 | AAPL | Stock | 3.2214 | 3.2218 | 3.2182 | 3.2214 | 58380.0 |
| 2006-12-07 08:18:00 | AAPL | Stock | 3.2179 | 3.2179 | 3.2179 | 3.2179 | 3360.0 |
| 2006-12-07 08:19:00 | AAPL | Stock | 3.2179 | 3.2214 | 3.2179 | 3.2214 | 53060.0 |
| 2006-12-07 08:20:00 | AAPL | Stock | 3.2179 | 3.2179 | 3.2179 | 3.2179 | 14000.0 |
| 2006-12-07 08:21:00 | AAPL | Stock | 3.2179 | 3.22 | 3.2179 | 3.22 | 33600.0 |
| 2006-12-07 08:22:00 | AAPL | Stock | 3.2189 | 3.2189 | 3.2186 | 3.2186 | 30800.0 |
| 2006-12-07 08:23:00 | AAPL | Stock | 3.2196 | 3.2196 | 3.2196 | 3.2196 | 11004.0 |
| 2006-12-07 08:24:00 | AAPL | Stock | 3.2186 | 3.2186 | 3.2186 | 3.2186 | 5600.0 |
| 2006-12-07 08:25:00 | AAPL | Stock | 3.2189 | 3.2189 | 3.2189 | 3.2189 | 22400.0 |
| 2006-12-07 08:26:00 | AAPL | Stock | 3.2196 | 3.22 | 3.2196 | 3.2196 | 123004.0 |
| 2006-12-07 08:27:00 | AAPL | Stock | 3.2196 | 3.2214 | 3.2196 | 3.2214 | 23800.0 |
| 2006-12-07 08:28:00 | AAPL | Stock | 3.2196 | 3.2196 | 3.2196 | 3.2196 | 2800.0 |
| 2006-12-07 08:31:00 | AAPL | Stock | 3.2186 | 3.2186 | 3.2179 | 3.2179 | 25200.0 |
| 2006-12-07 08:32:00 | AAPL | Stock | 3.2179 | 3.2179 | 3.2168 | 3.2168 | 28000.0 |
| 2006-12-07 08:33:00 | AAPL | Stock | 3.2179 | 3.2179 | 3.2179 | 3.2179 | 11200.0 |
| 2006-12-07 08:34:00 | AAPL | Stock | 3.2179 | 3.2179 | 3.2179 | 3.2179 | 22400.0 |
| 2006-12-07 08:36:00 | AAPL | Stock | 3.2186 | 3.2186 | 3.2186 | 3.2186 | 5600.0 |
| 2006-12-07 08:39:00 | AAPL | Stock | 3.2196 | 3.2196 | 3.2196 | 3.2196 | 2800.0 |
| 2006-12-07 08:40:00 | AAPL | Stock | 3.2207 | 3.2214 | 3.2207 | 3.2214 | 14000.0 |
| 2006-12-07 08:41:00 | AAPL | Stock | 3.2214 | 3.2214 | 3.2214 | 3.2214 | 30800.0 |
| 2006-12-07 08:42:00 | AAPL | Stock | 3.2196 | 3.2196 | 3.2186 | 3.2186 | 14000.0 |
| 2006-12-07 08:44:00 | AAPL | Stock | 3.2196 | 3.2196 | 3.2196 | 3.2196 | 7000.0 |
| 2006-12-07 08:47:00 | AAPL | Stock | 3.2214 | 3.2214 | 3.2182 | 3.22 | 71008.0 |
| 2006-12-07 08:48:00 | AAPL | Stock | 3.22 | 3.2207 | 3.2179 | 3.2207 | 64596.0 |
| 2006-12-07 08:49:00 | AAPL | Stock | 3.2207 | 3.2207 | 3.22 | 3.22 | 44996.0 |
> showing 50 of 693,025 rows — these rows as CSV