PREVIEW / stock_1min / 2012-05-29
file: by_date/stock_1min/2012/2012-05-29.parquet size: 12.9 MB rows: 965,650 symbols: 2,849
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-05-29 04:00:00 | AAPL | Stock | 20.29 | 20.29 | 20.29 | 20.29 | 5600.0 |
| 2012-05-29 04:17:00 | AAPL | Stock | 20.3304 | 20.3304 | 20.3304 | 20.3304 | 2800.0 |
| 2012-05-29 04:34:00 | AAPL | Stock | 20.33 | 20.3304 | 20.33 | 20.3304 | 19880.0 |
| 2012-05-29 05:35:00 | AAPL | Stock | 20.2929 | 20.2929 | 20.2929 | 20.2929 | 2800.0 |
| 2012-05-29 05:42:00 | AAPL | Stock | 20.2571 | 20.2571 | 20.2571 | 20.2571 | 26600.0 |
| 2012-05-29 05:45:00 | AAPL | Stock | 20.2321 | 20.2321 | 20.2321 | 20.2321 | 2800.0 |
| 2012-05-29 06:10:00 | AAPL | Stock | 20.1857 | 20.1857 | 20.1857 | 20.1857 | 5600.0 |
| 2012-05-29 06:31:00 | AAPL | Stock | 20.2004 | 20.2004 | 20.2004 | 20.2004 | 4620.0 |
| 2012-05-29 07:00:00 | AAPL | Stock | 20.2071 | 20.2071 | 20.2071 | 20.2071 | 2800.0 |
| 2012-05-29 07:01:00 | AAPL | Stock | 20.2143 | 20.2143 | 20.2143 | 20.2143 | 2800.0 |
| 2012-05-29 07:02:00 | AAPL | Stock | 20.2214 | 20.2214 | 20.2214 | 20.2214 | 2800.0 |
| 2012-05-29 07:03:00 | AAPL | Stock | 20.2318 | 20.2321 | 20.2318 | 20.2321 | 13888.0 |
| 2012-05-29 07:07:00 | AAPL | Stock | 20.2321 | 20.2321 | 20.2321 | 20.2321 | 13440.0 |
| 2012-05-29 07:08:00 | AAPL | Stock | 20.2407 | 20.2407 | 20.2407 | 20.2407 | 2800.0 |
| 2012-05-29 07:12:00 | AAPL | Stock | 20.2143 | 20.2143 | 20.2143 | 20.2143 | 8372.0 |
| 2012-05-29 07:17:00 | AAPL | Stock | 20.2143 | 20.2143 | 20.2143 | 20.2143 | 4200.0 |
| 2012-05-29 07:19:00 | AAPL | Stock | 20.2143 | 20.2143 | 20.2143 | 20.2143 | 2800.0 |
| 2012-05-29 07:21:00 | AAPL | Stock | 20.2211 | 20.2211 | 20.2211 | 20.2211 | 2800.0 |
| 2012-05-29 07:22:00 | AAPL | Stock | 20.2357 | 20.2389 | 20.2296 | 20.2296 | 21000.0 |
| 2012-05-29 07:23:00 | AAPL | Stock | 20.2325 | 20.2329 | 20.2325 | 20.2329 | 5600.0 |
| 2012-05-29 07:26:00 | AAPL | Stock | 20.2357 | 20.2386 | 20.2357 | 20.2386 | 23800.0 |
| 2012-05-29 07:31:00 | AAPL | Stock | 20.2264 | 20.2304 | 20.2221 | 20.2304 | 22400.0 |
| 2012-05-29 07:32:00 | AAPL | Stock | 20.225 | 20.225 | 20.225 | 20.225 | 2800.0 |
| 2012-05-29 07:33:00 | AAPL | Stock | 20.2321 | 20.2321 | 20.2321 | 20.2321 | 14000.0 |
| 2012-05-29 07:34:00 | AAPL | Stock | 20.2239 | 20.2239 | 20.2239 | 20.2239 | 2800.0 |
| 2012-05-29 07:36:00 | AAPL | Stock | 20.2346 | 20.2346 | 20.2346 | 20.2346 | 2800.0 |
| 2012-05-29 07:38:00 | AAPL | Stock | 20.2321 | 20.2321 | 20.2321 | 20.2321 | 2800.0 |
| 2012-05-29 07:40:00 | AAPL | Stock | 20.2286 | 20.2286 | 20.2286 | 20.2286 | 14000.0 |
| 2012-05-29 07:43:00 | AAPL | Stock | 20.2239 | 20.2239 | 20.2239 | 20.2239 | 2800.0 |
| 2012-05-29 07:50:00 | AAPL | Stock | 20.2318 | 20.2375 | 20.2318 | 20.2375 | 30688.0 |
| 2012-05-29 07:52:00 | AAPL | Stock | 20.2411 | 20.2411 | 20.2411 | 20.2411 | 11200.0 |
| 2012-05-29 07:54:00 | AAPL | Stock | 20.2436 | 20.2464 | 20.2436 | 20.2464 | 50400.0 |
| 2012-05-29 07:55:00 | AAPL | Stock | 20.2482 | 20.2571 | 20.2482 | 20.2571 | 64652.0 |
| 2012-05-29 07:56:00 | AAPL | Stock | 20.2504 | 20.2571 | 20.2504 | 20.2571 | 8400.0 |
| 2012-05-29 07:57:00 | AAPL | Stock | 20.2571 | 20.2571 | 20.2571 | 20.2571 | 9800.0 |
| 2012-05-29 07:58:00 | AAPL | Stock | 20.25 | 20.25 | 20.2396 | 20.2489 | 14000.0 |
| 2012-05-29 08:00:00 | AAPL | Stock | 20.2364 | 20.2475 | 20.2179 | 20.2243 | 162008.0 |
| 2012-05-29 08:01:00 | AAPL | Stock | 20.2332 | 20.2371 | 20.2221 | 20.225 | 73836.0 |
| 2012-05-29 08:02:00 | AAPL | Stock | 20.2239 | 20.2275 | 20.2239 | 20.2275 | 23800.0 |
| 2012-05-29 08:03:00 | AAPL | Stock | 20.2275 | 20.2371 | 20.2275 | 20.2371 | 59248.0 |
| 2012-05-29 08:04:00 | AAPL | Stock | 20.2293 | 20.2386 | 20.2293 | 20.2386 | 57764.0 |
| 2012-05-29 08:05:00 | AAPL | Stock | 20.2461 | 20.2568 | 20.2457 | 20.2464 | 60928.0 |
| 2012-05-29 08:06:00 | AAPL | Stock | 20.2457 | 20.2536 | 20.2393 | 20.2393 | 50260.0 |
| 2012-05-29 08:07:00 | AAPL | Stock | 20.25 | 20.25 | 20.245 | 20.245 | 28000.0 |
| 2012-05-29 08:08:00 | AAPL | Stock | 20.2464 | 20.2464 | 20.2461 | 20.2461 | 8960.0 |
| 2012-05-29 08:09:00 | AAPL | Stock | 20.2414 | 20.2414 | 20.2414 | 20.2414 | 2800.0 |
| 2012-05-29 08:10:00 | AAPL | Stock | 20.2375 | 20.2375 | 20.2371 | 20.2375 | 146832.0 |
| 2012-05-29 08:11:00 | AAPL | Stock | 20.2393 | 20.2393 | 20.2375 | 20.2393 | 26880.0 |
| 2012-05-29 08:12:00 | AAPL | Stock | 20.2393 | 20.2468 | 20.2393 | 20.2468 | 25956.0 |
| 2012-05-29 08:13:00 | AAPL | Stock | 20.2461 | 20.2461 | 20.2411 | 20.2411 | 5600.0 |
> showing 50 of 965,650 rows — these rows as CSV