PREVIEW / stock_1min / 2008-12-03
file: by_date/stock_1min/2008/2008-12-03.parquet size: 12.7 MB rows: 1,014,420 symbols: 2,718
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-12-03 06:44:00 | AAPL | Stock | 3.2321 | 3.2321 | 3.2321 | 3.2321 | 8400.0 |
| 2008-12-03 06:56:00 | AAPL | Stock | 3.2321 | 3.2321 | 3.2143 | 3.2143 | 14000.0 |
| 2008-12-03 06:58:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2143 | 3.2143 | 14000.0 |
| 2008-12-03 07:00:00 | AAPL | Stock | 3.1839 | 3.2125 | 3.1786 | 3.1964 | 37800.0 |
| 2008-12-03 07:01:00 | AAPL | Stock | 3.1964 | 3.1964 | 3.1786 | 3.1786 | 19600.0 |
| 2008-12-03 07:03:00 | AAPL | Stock | 3.1743 | 3.1743 | 3.1743 | 3.1743 | 20244.0 |
| 2008-12-03 07:12:00 | AAPL | Stock | 3.1907 | 3.1911 | 3.1907 | 3.1911 | 8400.0 |
| 2008-12-03 07:15:00 | AAPL | Stock | 3.1911 | 3.1911 | 3.1911 | 3.1911 | 25200.0 |
| 2008-12-03 07:16:00 | AAPL | Stock | 3.1964 | 3.2 | 3.1964 | 3.2 | 46200.0 |
| 2008-12-03 07:17:00 | AAPL | Stock | 3.2018 | 3.2018 | 3.2018 | 3.2018 | 2800.0 |
| 2008-12-03 07:19:00 | AAPL | Stock | 3.205 | 3.205 | 3.205 | 3.205 | 2800.0 |
| 2008-12-03 07:20:00 | AAPL | Stock | 3.2089 | 3.2089 | 3.2089 | 3.2089 | 2800.0 |
| 2008-12-03 07:21:00 | AAPL | Stock | 3.2136 | 3.2136 | 3.2136 | 3.2136 | 2800.0 |
| 2008-12-03 07:22:00 | AAPL | Stock | 3.2136 | 3.2139 | 3.2136 | 3.2139 | 7000.0 |
| 2008-12-03 07:27:00 | AAPL | Stock | 3.2107 | 3.2107 | 3.2107 | 3.2107 | 138460.0 |
| 2008-12-03 07:28:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2143 | 3.2143 | 2800.0 |
| 2008-12-03 07:33:00 | AAPL | Stock | 3.2071 | 3.2071 | 3.2071 | 3.2071 | 2800.0 |
| 2008-12-03 07:34:00 | AAPL | Stock | 3.1964 | 3.1964 | 3.1964 | 3.1964 | 12600.0 |
| 2008-12-03 07:40:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2143 | 3.2143 | 9268.0 |
| 2008-12-03 07:41:00 | AAPL | Stock | 3.1968 | 3.1968 | 3.1968 | 3.1968 | 2800.0 |
| 2008-12-03 07:46:00 | AAPL | Stock | 3.2036 | 3.2036 | 3.2036 | 3.2036 | 68600.0 |
| 2008-12-03 07:47:00 | AAPL | Stock | 3.2036 | 3.2036 | 3.2036 | 3.2036 | 8120.0 |
| 2008-12-03 07:52:00 | AAPL | Stock | 3.2036 | 3.2036 | 3.2036 | 3.2036 | 2800.0 |
| 2008-12-03 07:56:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2143 | 3.2143 | 5600.0 |
| 2008-12-03 07:58:00 | AAPL | Stock | 3.2054 | 3.2161 | 3.2036 | 3.2146 | 80164.0 |
| 2008-12-03 08:00:00 | AAPL | Stock | 3.2229 | 3.2371 | 3.2089 | 3.2321 | 233856.0 |
| 2008-12-03 08:01:00 | AAPL | Stock | 3.2321 | 3.2321 | 3.2257 | 3.2257 | 170968.0 |
| 2008-12-03 08:02:00 | AAPL | Stock | 3.2407 | 3.2407 | 3.2271 | 3.2293 | 33600.0 |
| 2008-12-03 08:04:00 | AAPL | Stock | 3.2321 | 3.2357 | 3.2321 | 3.2332 | 36120.0 |
| 2008-12-03 08:06:00 | AAPL | Stock | 3.2325 | 3.2375 | 3.2321 | 3.2375 | 47208.0 |
| 2008-12-03 08:07:00 | AAPL | Stock | 3.2321 | 3.2321 | 3.2289 | 3.2289 | 44100.0 |
| 2008-12-03 08:08:00 | AAPL | Stock | 3.2286 | 3.2393 | 3.2286 | 3.2368 | 72800.0 |
| 2008-12-03 08:09:00 | AAPL | Stock | 3.2357 | 3.2357 | 3.2286 | 3.2286 | 38080.0 |
| 2008-12-03 08:10:00 | AAPL | Stock | 3.2311 | 3.2311 | 3.2286 | 3.2286 | 35840.0 |
| 2008-12-03 08:11:00 | AAPL | Stock | 3.2286 | 3.2286 | 3.2286 | 3.2286 | 28000.0 |
| 2008-12-03 08:12:00 | AAPL | Stock | 3.2268 | 3.2282 | 3.2232 | 3.2232 | 64400.0 |
| 2008-12-03 08:13:00 | AAPL | Stock | 3.2196 | 3.2196 | 3.215 | 3.215 | 11928.0 |
| 2008-12-03 08:14:00 | AAPL | Stock | 3.2214 | 3.2232 | 3.2214 | 3.2221 | 19600.0 |
| 2008-12-03 08:15:00 | AAPL | Stock | 3.2229 | 3.2232 | 3.2229 | 3.2232 | 14000.0 |
| 2008-12-03 08:16:00 | AAPL | Stock | 3.2232 | 3.2261 | 3.2221 | 3.2261 | 78064.0 |
| 2008-12-03 08:17:00 | AAPL | Stock | 3.2286 | 3.2286 | 3.2261 | 3.2279 | 24808.0 |
| 2008-12-03 08:18:00 | AAPL | Stock | 3.2221 | 3.225 | 3.2221 | 3.2221 | 28000.0 |
| 2008-12-03 08:19:00 | AAPL | Stock | 3.2232 | 3.225 | 3.2221 | 3.225 | 30800.0 |
| 2008-12-03 08:20:00 | AAPL | Stock | 3.2221 | 3.2221 | 3.2221 | 3.2221 | 29680.0 |
| 2008-12-03 08:21:00 | AAPL | Stock | 3.2221 | 3.2221 | 3.2221 | 3.2221 | 2800.0 |
| 2008-12-03 08:22:00 | AAPL | Stock | 3.225 | 3.225 | 3.225 | 3.225 | 2800.0 |
| 2008-12-03 08:24:00 | AAPL | Stock | 3.2239 | 3.2239 | 3.2239 | 3.2239 | 2800.0 |
| 2008-12-03 08:25:00 | AAPL | Stock | 3.2239 | 3.2239 | 3.2239 | 3.2239 | 5600.0 |
| 2008-12-03 08:26:00 | AAPL | Stock | 3.2271 | 3.2271 | 3.2214 | 3.2214 | 77840.0 |
| 2008-12-03 08:27:00 | AAPL | Stock | 3.2225 | 3.2229 | 3.2054 | 3.2071 | 273280.0 |
> showing 50 of 1,014,420 rows — these rows as CSV