PREVIEW / stock_1min / 2012-01-20
file: by_date/stock_1min/2012/2012-01-20.parquet size: 12.5 MB rows: 933,683 symbols: 2,844
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 |
|---|---|---|---|---|---|---|---|
| 2012-01-20 04:00:00 | AAPL | Stock | 15.2107 | 15.2107 | 15.2107 | 15.2107 | 2800.0 |
| 2012-01-20 04:03:00 | AAPL | Stock | 15.1821 | 15.1821 | 15.1821 | 15.1821 | 3640.0 |
| 2012-01-20 04:28:00 | AAPL | Stock | 15.2082 | 15.2082 | 15.2082 | 15.2082 | 5600.0 |
| 2012-01-20 05:02:00 | AAPL | Stock | 15.155 | 15.155 | 15.155 | 15.155 | 5600.0 |
| 2012-01-20 05:03:00 | AAPL | Stock | 15.1518 | 15.1518 | 15.1518 | 15.1518 | 22400.0 |
| 2012-01-20 05:39:00 | AAPL | Stock | 15.2143 | 15.2143 | 15.2143 | 15.2143 | 11200.0 |
| 2012-01-20 06:06:00 | AAPL | Stock | 15.2225 | 15.2225 | 15.2225 | 15.2225 | 2800.0 |
| 2012-01-20 06:32:00 | AAPL | Stock | 15.2143 | 15.2143 | 15.2143 | 15.2143 | 2800.0 |
| 2012-01-20 07:01:00 | AAPL | Stock | 15.2096 | 15.2096 | 15.2096 | 15.2096 | 2800.0 |
| 2012-01-20 07:02:00 | AAPL | Stock | 15.2143 | 15.2143 | 15.2143 | 15.2143 | 5600.0 |
| 2012-01-20 07:04:00 | AAPL | Stock | 15.225 | 15.225 | 15.225 | 15.225 | 4256.0 |
| 2012-01-20 07:06:00 | AAPL | Stock | 15.2254 | 15.2461 | 15.2146 | 15.2461 | 29260.0 |
| 2012-01-20 07:10:00 | AAPL | Stock | 15.2321 | 15.2364 | 15.2321 | 15.2321 | 22120.0 |
| 2012-01-20 07:12:00 | AAPL | Stock | 15.2286 | 15.2286 | 15.2286 | 15.2286 | 2800.0 |
| 2012-01-20 07:13:00 | AAPL | Stock | 15.2214 | 15.2214 | 15.2214 | 15.2214 | 9128.0 |
| 2012-01-20 07:16:00 | AAPL | Stock | 15.2321 | 15.2321 | 15.2321 | 15.2321 | 14000.0 |
| 2012-01-20 07:18:00 | AAPL | Stock | 15.2243 | 15.2243 | 15.2243 | 15.2243 | 2800.0 |
| 2012-01-20 07:19:00 | AAPL | Stock | 15.2229 | 15.2229 | 15.2229 | 15.2229 | 2800.0 |
| 2012-01-20 07:20:00 | AAPL | Stock | 15.2321 | 15.2321 | 15.2321 | 15.2321 | 16800.0 |
| 2012-01-20 07:22:00 | AAPL | Stock | 15.2325 | 15.2325 | 15.2321 | 15.2321 | 14000.0 |
| 2012-01-20 07:23:00 | AAPL | Stock | 15.2321 | 15.2321 | 15.2321 | 15.2321 | 2800.0 |
| 2012-01-20 07:30:00 | AAPL | Stock | 15.2357 | 15.2357 | 15.2357 | 15.2357 | 2800.0 |
| 2012-01-20 07:33:00 | AAPL | Stock | 15.2357 | 15.2357 | 15.2357 | 15.2357 | 11200.0 |
| 2012-01-20 07:35:00 | AAPL | Stock | 15.2357 | 15.2357 | 15.2357 | 15.2357 | 2800.0 |
| 2012-01-20 07:37:00 | AAPL | Stock | 15.2357 | 15.2357 | 15.2357 | 15.2357 | 8400.0 |
| 2012-01-20 07:39:00 | AAPL | Stock | 15.2411 | 15.2643 | 15.2411 | 15.2643 | 26180.0 |
| 2012-01-20 07:40:00 | AAPL | Stock | 15.2643 | 15.2643 | 15.2643 | 15.2643 | 11200.0 |
| 2012-01-20 07:41:00 | AAPL | Stock | 15.2536 | 15.2536 | 15.25 | 15.25 | 8400.0 |
| 2012-01-20 07:42:00 | AAPL | Stock | 15.2496 | 15.25 | 15.2496 | 15.25 | 33600.0 |
| 2012-01-20 07:43:00 | AAPL | Stock | 15.275 | 15.275 | 15.2732 | 15.2732 | 8400.0 |
| 2012-01-20 07:48:00 | AAPL | Stock | 15.2521 | 15.2521 | 15.2504 | 15.2504 | 5600.0 |
| 2012-01-20 07:50:00 | AAPL | Stock | 15.2636 | 15.2636 | 15.2636 | 15.2636 | 2800.0 |
| 2012-01-20 07:57:00 | AAPL | Stock | 15.2529 | 15.2529 | 15.2514 | 15.2514 | 14000.0 |
| 2012-01-20 07:58:00 | AAPL | Stock | 15.25 | 15.25 | 15.2411 | 15.2411 | 33600.0 |
| 2012-01-20 08:00:00 | AAPL | Stock | 15.2536 | 15.2536 | 15.2532 | 15.2532 | 5600.0 |
| 2012-01-20 08:01:00 | AAPL | Stock | 15.2407 | 15.2407 | 15.2407 | 15.2407 | 28000.0 |
| 2012-01-20 08:02:00 | AAPL | Stock | 15.2357 | 15.2357 | 15.2307 | 15.2307 | 35644.0 |
| 2012-01-20 08:04:00 | AAPL | Stock | 15.2343 | 15.2343 | 15.2343 | 15.2343 | 2800.0 |
| 2012-01-20 08:05:00 | AAPL | Stock | 15.2411 | 15.2411 | 15.2411 | 15.2411 | 19600.0 |
| 2012-01-20 08:06:00 | AAPL | Stock | 15.2411 | 15.2411 | 15.2379 | 15.2379 | 9212.0 |
| 2012-01-20 08:07:00 | AAPL | Stock | 15.2375 | 15.2375 | 15.2375 | 15.2375 | 8400.0 |
| 2012-01-20 08:08:00 | AAPL | Stock | 15.2286 | 15.2286 | 15.2232 | 15.2232 | 47236.0 |
| 2012-01-20 08:11:00 | AAPL | Stock | 15.2214 | 15.2214 | 15.2214 | 15.2214 | 2800.0 |
| 2012-01-20 08:12:00 | AAPL | Stock | 15.2157 | 15.2157 | 15.2157 | 15.2157 | 2800.0 |
| 2012-01-20 08:13:00 | AAPL | Stock | 15.2214 | 15.2214 | 15.2214 | 15.2214 | 5600.0 |
| 2012-01-20 08:14:00 | AAPL | Stock | 15.2304 | 15.2304 | 15.2304 | 15.2304 | 2800.0 |
| 2012-01-20 08:16:00 | AAPL | Stock | 15.2268 | 15.2268 | 15.225 | 15.225 | 8820.0 |
| 2012-01-20 08:17:00 | AAPL | Stock | 15.23 | 15.23 | 15.23 | 15.23 | 5600.0 |
| 2012-01-20 08:19:00 | AAPL | Stock | 15.2268 | 15.2268 | 15.2268 | 15.2268 | 2800.0 |
| 2012-01-20 08:20:00 | AAPL | Stock | 15.2236 | 15.2236 | 15.2236 | 15.2236 | 5600.0 |
> showing 50 of 933,683 rows — these rows as CSV