PREVIEW / stock_1min / 2011-01-28
file: by_date/stock_1min/2011/2011-01-28.parquet size: 14.2 MB rows: 1,058,278 symbols: 2,854
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 |
|---|---|---|---|---|---|---|---|
| 2011-01-28 07:00:00 | AAPL | Stock | 12.2225 | 12.2225 | 12.2082 | 12.2082 | 14000.0 |
| 2011-01-28 07:07:00 | AAPL | Stock | 12.2421 | 12.2421 | 12.2421 | 12.2421 | 10780.0 |
| 2011-01-28 07:21:00 | AAPL | Stock | 12.2411 | 12.2411 | 12.2411 | 12.2411 | 5600.0 |
| 2011-01-28 07:46:00 | AAPL | Stock | 12.2457 | 12.2457 | 12.2457 | 12.2457 | 5600.0 |
| 2011-01-28 07:59:00 | AAPL | Stock | 12.2457 | 12.2457 | 12.245 | 12.245 | 14000.0 |
| 2011-01-28 08:00:00 | AAPL | Stock | 12.2411 | 12.2446 | 12.2379 | 12.2379 | 30464.0 |
| 2011-01-28 08:01:00 | AAPL | Stock | 12.2332 | 12.2332 | 12.2214 | 12.2214 | 32900.0 |
| 2011-01-28 08:02:00 | AAPL | Stock | 12.2304 | 12.2304 | 12.2214 | 12.2214 | 14000.0 |
| 2011-01-28 08:03:00 | AAPL | Stock | 12.2282 | 12.2321 | 12.2282 | 12.2321 | 56084.0 |
| 2011-01-28 08:04:00 | AAPL | Stock | 12.2321 | 12.2321 | 12.2275 | 12.2275 | 5600.0 |
| 2011-01-28 08:05:00 | AAPL | Stock | 12.2321 | 12.2321 | 12.2321 | 12.2321 | 11200.0 |
| 2011-01-28 08:06:00 | AAPL | Stock | 12.2339 | 12.2357 | 12.2339 | 12.2357 | 35784.0 |
| 2011-01-28 08:07:00 | AAPL | Stock | 12.2321 | 12.2321 | 12.2271 | 12.2271 | 6160.0 |
| 2011-01-28 08:08:00 | AAPL | Stock | 12.2286 | 12.2286 | 12.2286 | 12.2286 | 14000.0 |
| 2011-01-28 08:09:00 | AAPL | Stock | 12.2321 | 12.2379 | 12.2321 | 12.2379 | 35560.0 |
| 2011-01-28 08:10:00 | AAPL | Stock | 12.2325 | 12.2325 | 12.2325 | 12.2325 | 5600.0 |
| 2011-01-28 08:12:00 | AAPL | Stock | 12.2329 | 12.2329 | 12.2329 | 12.2329 | 6160.0 |
| 2011-01-28 08:13:00 | AAPL | Stock | 12.2339 | 12.2339 | 12.2321 | 12.2332 | 54600.0 |
| 2011-01-28 08:14:00 | AAPL | Stock | 12.2339 | 12.2575 | 12.2339 | 12.2575 | 62440.0 |
| 2011-01-28 08:17:00 | AAPL | Stock | 12.2368 | 12.2368 | 12.2368 | 12.2368 | 2800.0 |
| 2011-01-28 08:18:00 | AAPL | Stock | 12.2368 | 12.2368 | 12.2321 | 12.2321 | 49140.0 |
| 2011-01-28 08:19:00 | AAPL | Stock | 12.2368 | 12.2368 | 12.2368 | 12.2368 | 2800.0 |
| 2011-01-28 08:20:00 | AAPL | Stock | 12.2368 | 12.2375 | 12.2368 | 12.2375 | 22960.0 |
| 2011-01-28 08:21:00 | AAPL | Stock | 12.2375 | 12.2375 | 12.2375 | 12.2375 | 2800.0 |
| 2011-01-28 08:26:00 | AAPL | Stock | 12.2357 | 12.2357 | 12.2357 | 12.2357 | 8400.0 |
| 2011-01-28 08:27:00 | AAPL | Stock | 12.2375 | 12.2379 | 12.2375 | 12.2379 | 17780.0 |
| 2011-01-28 08:28:00 | AAPL | Stock | 12.2379 | 12.25 | 12.2379 | 12.25 | 64232.0 |
| 2011-01-28 08:29:00 | AAPL | Stock | 12.25 | 12.25 | 12.2404 | 12.2404 | 45920.0 |
| 2011-01-28 08:30:00 | AAPL | Stock | 12.2357 | 12.2393 | 12.2321 | 12.2393 | 33600.0 |
| 2011-01-28 08:31:00 | AAPL | Stock | 12.2404 | 12.2571 | 12.2404 | 12.2571 | 37800.0 |
| 2011-01-28 08:32:00 | AAPL | Stock | 12.2625 | 12.2743 | 12.2586 | 12.2743 | 240240.0 |
| 2011-01-28 08:33:00 | AAPL | Stock | 12.2704 | 12.2829 | 12.2704 | 12.2829 | 175280.0 |
| 2011-01-28 08:34:00 | AAPL | Stock | 12.2854 | 12.2882 | 12.2807 | 12.2807 | 131124.0 |
| 2011-01-28 08:35:00 | AAPL | Stock | 12.2804 | 12.2836 | 12.2636 | 12.2679 | 86268.0 |
| 2011-01-28 08:36:00 | AAPL | Stock | 12.2696 | 12.2714 | 12.2693 | 12.2711 | 43120.0 |
| 2011-01-28 08:37:00 | AAPL | Stock | 12.2746 | 12.2746 | 12.2686 | 12.2704 | 39200.0 |
| 2011-01-28 08:38:00 | AAPL | Stock | 12.2704 | 12.2764 | 12.27 | 12.2764 | 37520.0 |
| 2011-01-28 08:39:00 | AAPL | Stock | 12.2761 | 12.2786 | 12.2761 | 12.2768 | 131460.0 |
| 2011-01-28 08:40:00 | AAPL | Stock | 12.2768 | 12.2768 | 12.2732 | 12.2732 | 15400.0 |
| 2011-01-28 08:41:00 | AAPL | Stock | 12.2775 | 12.2775 | 12.2775 | 12.2775 | 2800.0 |
| 2011-01-28 08:42:00 | AAPL | Stock | 12.2775 | 12.2775 | 12.2775 | 12.2775 | 10500.0 |
| 2011-01-28 08:43:00 | AAPL | Stock | 12.2764 | 12.2764 | 12.2714 | 12.2714 | 11788.0 |
| 2011-01-28 08:44:00 | AAPL | Stock | 12.2714 | 12.2714 | 12.2636 | 12.2657 | 83972.0 |
| 2011-01-28 08:45:00 | AAPL | Stock | 12.2671 | 12.2679 | 12.2671 | 12.2679 | 6580.0 |
| 2011-01-28 08:46:00 | AAPL | Stock | 12.2721 | 12.2721 | 12.2721 | 12.2721 | 2800.0 |
| 2011-01-28 08:47:00 | AAPL | Stock | 12.2679 | 12.2682 | 12.2679 | 12.2682 | 8652.0 |
| 2011-01-28 08:48:00 | AAPL | Stock | 12.2693 | 12.2693 | 12.2682 | 12.2682 | 14000.0 |
| 2011-01-28 08:50:00 | AAPL | Stock | 12.2732 | 12.2746 | 12.2693 | 12.2693 | 8400.0 |
| 2011-01-28 08:51:00 | AAPL | Stock | 12.2707 | 12.2746 | 12.2679 | 12.2679 | 126000.0 |
| 2011-01-28 08:52:00 | AAPL | Stock | 12.2686 | 12.2686 | 12.2686 | 12.2686 | 2800.0 |
> showing 50 of 1,058,278 rows — these rows as CSV