PREVIEW / stock_1min / 2013-03-13
file: by_date/stock_1min/2013/2013-03-13.parquet size: 12.9 MB rows: 957,570 symbols: 2,803
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 |
|---|---|---|---|---|---|---|---|
| 2013-03-13 05:22:00 | AAPL | Stock | 15.2786 | 15.2786 | 15.2786 | 15.2786 | 2800.0 |
| 2013-03-13 05:25:00 | AAPL | Stock | 15.2786 | 15.2786 | 15.2786 | 15.2786 | 16604.0 |
| 2013-03-13 05:26:00 | AAPL | Stock | 15.2786 | 15.2786 | 15.2786 | 15.2786 | 2800.0 |
| 2013-03-13 06:22:00 | AAPL | Stock | 15.2679 | 15.2679 | 15.2571 | 15.2571 | 5600.0 |
| 2013-03-13 06:35:00 | AAPL | Stock | 15.2489 | 15.2489 | 15.2489 | 15.2489 | 4200.0 |
| 2013-03-13 06:36:00 | AAPL | Stock | 15.2321 | 15.2321 | 15.2321 | 15.2321 | 5600.0 |
| 2013-03-13 07:01:00 | AAPL | Stock | 15.2679 | 15.2679 | 15.2679 | 15.2679 | 5600.0 |
| 2013-03-13 07:03:00 | AAPL | Stock | 15.2679 | 15.2679 | 15.2679 | 15.2679 | 13776.0 |
| 2013-03-13 07:04:00 | AAPL | Stock | 15.2679 | 15.2679 | 15.2679 | 15.2679 | 5600.0 |
| 2013-03-13 07:05:00 | AAPL | Stock | 15.2589 | 15.2679 | 15.2589 | 15.2679 | 17500.0 |
| 2013-03-13 07:08:00 | AAPL | Stock | 15.2589 | 15.2654 | 15.2543 | 15.2589 | 34832.0 |
| 2013-03-13 07:09:00 | AAPL | Stock | 15.2632 | 15.2654 | 15.2632 | 15.2654 | 7000.0 |
| 2013-03-13 07:12:00 | AAPL | Stock | 15.25 | 15.25 | 15.25 | 15.25 | 7000.0 |
| 2013-03-13 07:17:00 | AAPL | Stock | 15.2454 | 15.2454 | 15.2454 | 15.2454 | 3500.0 |
| 2013-03-13 07:18:00 | AAPL | Stock | 15.25 | 15.25 | 15.25 | 15.25 | 2800.0 |
| 2013-03-13 07:30:00 | AAPL | Stock | 15.2475 | 15.2475 | 15.2475 | 15.2475 | 2800.0 |
| 2013-03-13 07:31:00 | AAPL | Stock | 15.24 | 15.24 | 15.24 | 15.24 | 9828.0 |
| 2013-03-13 07:32:00 | AAPL | Stock | 15.2357 | 15.2361 | 15.2357 | 15.2357 | 19796.0 |
| 2013-03-13 07:37:00 | AAPL | Stock | 15.2404 | 15.2404 | 15.2404 | 15.2404 | 2800.0 |
| 2013-03-13 07:39:00 | AAPL | Stock | 15.2461 | 15.2461 | 15.2461 | 15.2461 | 5600.0 |
| 2013-03-13 07:42:00 | AAPL | Stock | 15.2461 | 15.2461 | 15.2461 | 15.2461 | 2800.0 |
| 2013-03-13 07:45:00 | AAPL | Stock | 15.2457 | 15.2464 | 15.2457 | 15.2464 | 5600.0 |
| 2013-03-13 07:47:00 | AAPL | Stock | 15.2464 | 15.25 | 15.2464 | 15.25 | 11200.0 |
| 2013-03-13 07:48:00 | AAPL | Stock | 15.25 | 15.2521 | 15.25 | 15.2521 | 15092.0 |
| 2013-03-13 07:59:00 | AAPL | Stock | 15.2543 | 15.2543 | 15.2539 | 15.2539 | 14000.0 |
| 2013-03-13 08:00:00 | AAPL | Stock | 15.2411 | 15.2639 | 15.2325 | 15.2379 | 114632.0 |
| 2013-03-13 08:02:00 | AAPL | Stock | 15.2414 | 15.2414 | 15.2321 | 15.2329 | 59360.0 |
| 2013-03-13 08:03:00 | AAPL | Stock | 15.2361 | 15.2429 | 15.2361 | 15.2429 | 55720.0 |
| 2013-03-13 08:04:00 | AAPL | Stock | 15.2368 | 15.2396 | 15.2346 | 15.2396 | 14280.0 |
| 2013-03-13 08:05:00 | AAPL | Stock | 15.2382 | 15.2382 | 15.2382 | 15.2382 | 7840.0 |
| 2013-03-13 08:06:00 | AAPL | Stock | 15.2436 | 15.2436 | 15.2386 | 15.2386 | 11200.0 |
| 2013-03-13 08:07:00 | AAPL | Stock | 15.2436 | 15.2446 | 15.2357 | 15.2361 | 54796.0 |
| 2013-03-13 08:09:00 | AAPL | Stock | 15.2857 | 15.2857 | 15.2857 | 15.2857 | 8400.0 |
| 2013-03-13 08:11:00 | AAPL | Stock | 15.2357 | 15.2364 | 15.2321 | 15.2364 | 22400.0 |
| 2013-03-13 08:12:00 | AAPL | Stock | 15.2432 | 15.2443 | 15.2368 | 15.2368 | 14000.0 |
| 2013-03-13 08:13:00 | AAPL | Stock | 15.245 | 15.2461 | 15.2446 | 15.2446 | 8400.0 |
| 2013-03-13 08:14:00 | AAPL | Stock | 15.2464 | 15.2593 | 15.2464 | 15.2593 | 42084.0 |
| 2013-03-13 08:16:00 | AAPL | Stock | 15.2568 | 15.2589 | 15.2504 | 15.2589 | 22848.0 |
| 2013-03-13 08:18:00 | AAPL | Stock | 15.2564 | 15.2571 | 15.2564 | 15.2571 | 5600.0 |
| 2013-03-13 08:19:00 | AAPL | Stock | 15.2511 | 15.2564 | 15.2504 | 15.2564 | 9100.0 |
| 2013-03-13 08:20:00 | AAPL | Stock | 15.2561 | 15.2625 | 15.2561 | 15.2625 | 30072.0 |
| 2013-03-13 08:21:00 | AAPL | Stock | 15.2539 | 15.2539 | 15.25 | 15.2539 | 34608.0 |
| 2013-03-13 08:22:00 | AAPL | Stock | 15.2546 | 15.2546 | 15.2546 | 15.2546 | 2800.0 |
| 2013-03-13 08:23:00 | AAPL | Stock | 15.255 | 15.2589 | 15.2507 | 15.2507 | 25200.0 |
| 2013-03-13 08:25:00 | AAPL | Stock | 15.2518 | 15.2621 | 15.2518 | 15.2621 | 14616.0 |
| 2013-03-13 08:26:00 | AAPL | Stock | 15.2571 | 15.2661 | 15.2571 | 15.2643 | 50400.0 |
| 2013-03-13 08:27:00 | AAPL | Stock | 15.2661 | 15.2661 | 15.2661 | 15.2661 | 2800.0 |
| 2013-03-13 08:30:00 | AAPL | Stock | 15.2643 | 15.2732 | 15.2614 | 15.2732 | 64400.0 |
| 2013-03-13 08:31:00 | AAPL | Stock | 15.2732 | 15.2786 | 15.2711 | 15.2725 | 33600.0 |
| 2013-03-13 08:32:00 | AAPL | Stock | 15.2804 | 15.2804 | 15.2686 | 15.2804 | 166404.0 |
> showing 50 of 957,570 rows — these rows as CSV