PREVIEW / stock_1min / 2004-11-29
file: by_date/stock_1min/2004/2004-11-29.parquet size: 6.7 MB rows: 556,803 symbols: 1,549
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-11-29 08:00:00 | AAPL | Stock | 1.2248 | 1.2277 | 1.2138 | 1.2232 | 389704.0 |
| 2004-11-29 08:01:00 | AAPL | Stock | 1.2214 | 1.2293 | 1.2188 | 1.2268 | 923664.0 |
| 2004-11-29 08:02:00 | AAPL | Stock | 1.2266 | 1.2266 | 1.2214 | 1.2232 | 1220856.0 |
| 2004-11-29 08:03:00 | AAPL | Stock | 1.222 | 1.2248 | 1.217 | 1.217 | 590800.0 |
| 2004-11-29 08:04:00 | AAPL | Stock | 1.2179 | 1.2255 | 1.2134 | 1.2161 | 1313200.0 |
| 2004-11-29 08:05:00 | AAPL | Stock | 1.2161 | 1.2188 | 1.2143 | 1.2161 | 895944.0 |
| 2004-11-29 08:06:00 | AAPL | Stock | 1.2155 | 1.217 | 1.2152 | 1.2152 | 369152.0 |
| 2004-11-29 08:07:00 | AAPL | Stock | 1.2152 | 1.2184 | 1.2143 | 1.2161 | 941920.0 |
| 2004-11-29 08:08:00 | AAPL | Stock | 1.2155 | 1.2159 | 1.2143 | 1.2143 | 1105832.0 |
| 2004-11-29 08:09:00 | AAPL | Stock | 1.2143 | 1.217 | 1.2143 | 1.2161 | 893200.0 |
| 2004-11-29 08:10:00 | AAPL | Stock | 1.2164 | 1.217 | 1.2152 | 1.2154 | 196000.0 |
| 2004-11-29 08:11:00 | AAPL | Stock | 1.2164 | 1.2179 | 1.2164 | 1.2179 | 681800.0 |
| 2004-11-29 08:12:00 | AAPL | Stock | 1.2179 | 1.2179 | 1.2161 | 1.2177 | 165704.0 |
| 2004-11-29 08:13:00 | AAPL | Stock | 1.217 | 1.2177 | 1.2152 | 1.2152 | 273840.0 |
| 2004-11-29 08:14:00 | AAPL | Stock | 1.2152 | 1.2161 | 1.2136 | 1.2143 | 1222872.0 |
| 2004-11-29 08:15:00 | AAPL | Stock | 1.2148 | 1.2179 | 1.2148 | 1.2177 | 313600.0 |
| 2004-11-29 08:16:00 | AAPL | Stock | 1.217 | 1.217 | 1.2149 | 1.2149 | 106400.0 |
| 2004-11-29 08:17:00 | AAPL | Stock | 1.217 | 1.217 | 1.2145 | 1.2154 | 636496.0 |
| 2004-11-29 08:18:00 | AAPL | Stock | 1.2152 | 1.2161 | 1.2152 | 1.2161 | 128800.0 |
| 2004-11-29 08:19:00 | AAPL | Stock | 1.2154 | 1.2159 | 1.2152 | 1.2154 | 72800.0 |
| 2004-11-29 08:20:00 | AAPL | Stock | 1.2161 | 1.217 | 1.2161 | 1.217 | 226800.0 |
| 2004-11-29 08:21:00 | AAPL | Stock | 1.2161 | 1.2177 | 1.2152 | 1.2173 | 425880.0 |
| 2004-11-29 08:22:00 | AAPL | Stock | 1.2173 | 1.2177 | 1.217 | 1.217 | 1167600.0 |
| 2004-11-29 08:23:00 | AAPL | Stock | 1.217 | 1.2205 | 1.217 | 1.2205 | 2427880.0 |
| 2004-11-29 08:24:00 | AAPL | Stock | 1.2213 | 1.222 | 1.2179 | 1.2188 | 961632.0 |
| 2004-11-29 08:25:00 | AAPL | Stock | 1.2188 | 1.2196 | 1.217 | 1.2179 | 950600.0 |
| 2004-11-29 08:26:00 | AAPL | Stock | 1.2191 | 1.2196 | 1.2171 | 1.2179 | 1154440.0 |
| 2004-11-29 08:27:00 | AAPL | Stock | 1.217 | 1.2182 | 1.217 | 1.217 | 407400.0 |
| 2004-11-29 08:28:00 | AAPL | Stock | 1.2179 | 1.2188 | 1.217 | 1.2188 | 196000.0 |
| 2004-11-29 08:29:00 | AAPL | Stock | 1.2171 | 1.2179 | 1.2161 | 1.2168 | 1761760.0 |
| 2004-11-29 08:30:00 | AAPL | Stock | 1.2166 | 1.2168 | 1.2152 | 1.2152 | 706776.0 |
| 2004-11-29 08:31:00 | AAPL | Stock | 1.2159 | 1.2164 | 1.2152 | 1.2152 | 1260504.0 |
| 2004-11-29 08:32:00 | AAPL | Stock | 1.2157 | 1.2168 | 1.2155 | 1.2168 | 179200.0 |
| 2004-11-29 08:33:00 | AAPL | Stock | 1.2163 | 1.2171 | 1.2161 | 1.2171 | 73920.0 |
| 2004-11-29 08:34:00 | AAPL | Stock | 1.2164 | 1.2164 | 1.2159 | 1.2161 | 280000.0 |
| 2004-11-29 08:35:00 | AAPL | Stock | 1.2161 | 1.2161 | 1.2155 | 1.2161 | 61600.0 |
| 2004-11-29 08:36:00 | AAPL | Stock | 1.2159 | 1.2161 | 1.2159 | 1.2161 | 50400.0 |
| 2004-11-29 08:37:00 | AAPL | Stock | 1.2155 | 1.2161 | 1.2155 | 1.2161 | 498400.0 |
| 2004-11-29 08:38:00 | AAPL | Stock | 1.2161 | 1.2161 | 1.2161 | 1.2161 | 12096.0 |
| 2004-11-29 08:39:00 | AAPL | Stock | 1.2161 | 1.2175 | 1.2154 | 1.2161 | 702352.0 |
| 2004-11-29 08:40:00 | AAPL | Stock | 1.2164 | 1.2166 | 1.2163 | 1.2166 | 33600.0 |
| 2004-11-29 08:41:00 | AAPL | Stock | 1.2168 | 1.217 | 1.2168 | 1.2168 | 170800.0 |
| 2004-11-29 08:42:00 | AAPL | Stock | 1.2163 | 1.217 | 1.2161 | 1.217 | 547904.0 |
| 2004-11-29 08:43:00 | AAPL | Stock | 1.2164 | 1.2188 | 1.2161 | 1.2188 | 360920.0 |
| 2004-11-29 08:44:00 | AAPL | Stock | 1.2188 | 1.2205 | 1.2188 | 1.2205 | 742280.0 |
| 2004-11-29 08:45:00 | AAPL | Stock | 1.2205 | 1.2239 | 1.2196 | 1.2205 | 1585136.0 |
| 2004-11-29 08:46:00 | AAPL | Stock | 1.2205 | 1.2213 | 1.2198 | 1.2213 | 549080.0 |
| 2004-11-29 08:47:00 | AAPL | Stock | 1.2211 | 1.2213 | 1.2207 | 1.2207 | 80360.0 |
| 2004-11-29 08:48:00 | AAPL | Stock | 1.2205 | 1.2205 | 1.2188 | 1.2188 | 817600.0 |
| 2004-11-29 08:49:00 | AAPL | Stock | 1.2186 | 1.2198 | 1.2182 | 1.2198 | 418264.0 |
> showing 50 of 556,803 rows — these rows as CSV