PREVIEW / stock_1min / 2013-04-08
file: by_date/stock_1min/2013/2013-04-08.parquet size: 12.8 MB rows: 945,685 symbols: 2,838
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-04-08 04:00:00 | AAPL | Stock | 15.1779 | 15.1779 | 15.1779 | 15.1779 | 11704.0 |
| 2013-04-08 04:19:00 | AAPL | Stock | 15.2371 | 15.2371 | 15.2371 | 15.2371 | 2800.0 |
| 2013-04-08 04:46:00 | AAPL | Stock | 15.2411 | 15.2411 | 15.2411 | 15.2411 | 2800.0 |
| 2013-04-08 04:54:00 | AAPL | Stock | 15.2411 | 15.2411 | 15.2411 | 15.2411 | 2800.0 |
| 2013-04-08 05:06:00 | AAPL | Stock | 15.2411 | 15.2411 | 15.2411 | 15.2411 | 5600.0 |
| 2013-04-08 05:08:00 | AAPL | Stock | 15.2321 | 15.2321 | 15.2321 | 15.2321 | 2800.0 |
| 2013-04-08 05:40:00 | AAPL | Stock | 15.2264 | 15.2264 | 15.2264 | 15.2264 | 2800.0 |
| 2013-04-08 05:43:00 | AAPL | Stock | 15.2357 | 15.2357 | 15.2357 | 15.2357 | 2800.0 |
| 2013-04-08 05:44:00 | AAPL | Stock | 15.2371 | 15.2371 | 15.2371 | 15.2371 | 2800.0 |
| 2013-04-08 05:53:00 | AAPL | Stock | 15.2379 | 15.2379 | 15.2379 | 15.2379 | 5600.0 |
| 2013-04-08 05:55:00 | AAPL | Stock | 15.2379 | 15.2379 | 15.2379 | 15.2379 | 5600.0 |
| 2013-04-08 05:56:00 | AAPL | Stock | 15.2414 | 15.2468 | 15.2414 | 15.2468 | 19600.0 |
| 2013-04-08 06:03:00 | AAPL | Stock | 15.2321 | 15.2321 | 15.2321 | 15.2321 | 5600.0 |
| 2013-04-08 06:20:00 | AAPL | Stock | 15.2571 | 15.2571 | 15.2571 | 15.2571 | 2940.0 |
| 2013-04-08 06:25:00 | AAPL | Stock | 15.25 | 15.25 | 15.25 | 15.25 | 2800.0 |
| 2013-04-08 06:26:00 | AAPL | Stock | 15.2436 | 15.2571 | 15.2436 | 15.2571 | 11200.0 |
| 2013-04-08 06:27:00 | AAPL | Stock | 15.2704 | 15.2704 | 15.2679 | 15.2679 | 14000.0 |
| 2013-04-08 06:54:00 | AAPL | Stock | 15.2446 | 15.2446 | 15.2446 | 15.2446 | 2800.0 |
| 2013-04-08 06:57:00 | AAPL | Stock | 15.2607 | 15.2607 | 15.2607 | 15.2607 | 8400.0 |
| 2013-04-08 06:58:00 | AAPL | Stock | 15.2596 | 15.2596 | 15.2596 | 15.2596 | 2800.0 |
| 2013-04-08 07:00:00 | AAPL | Stock | 15.25 | 15.25 | 15.2496 | 15.2496 | 5600.0 |
| 2013-04-08 07:02:00 | AAPL | Stock | 15.1821 | 15.2375 | 15.1821 | 15.2143 | 76104.0 |
| 2013-04-08 07:03:00 | AAPL | Stock | 15.2339 | 15.2411 | 15.2339 | 15.2411 | 7000.0 |
| 2013-04-08 07:05:00 | AAPL | Stock | 15.2482 | 15.2529 | 15.2482 | 15.2529 | 5600.0 |
| 2013-04-08 07:06:00 | AAPL | Stock | 15.2493 | 15.2614 | 15.2493 | 15.2614 | 16800.0 |
| 2013-04-08 07:07:00 | AAPL | Stock | 15.2668 | 15.2764 | 15.2668 | 15.2764 | 8400.0 |
| 2013-04-08 07:09:00 | AAPL | Stock | 15.2507 | 15.2507 | 15.2418 | 15.2418 | 12600.0 |
| 2013-04-08 07:10:00 | AAPL | Stock | 15.2511 | 15.2511 | 15.2511 | 15.2511 | 2800.0 |
| 2013-04-08 07:11:00 | AAPL | Stock | 15.2621 | 15.2664 | 15.2621 | 15.2664 | 7000.0 |
| 2013-04-08 07:12:00 | AAPL | Stock | 15.2679 | 15.2704 | 15.2679 | 15.2704 | 22400.0 |
| 2013-04-08 07:14:00 | AAPL | Stock | 15.2679 | 15.2857 | 15.2679 | 15.2857 | 60312.0 |
| 2013-04-08 07:16:00 | AAPL | Stock | 15.3036 | 15.3036 | 15.2857 | 15.2857 | 16576.0 |
| 2013-04-08 07:17:00 | AAPL | Stock | 15.2946 | 15.2946 | 15.2946 | 15.2946 | 2800.0 |
| 2013-04-08 07:18:00 | AAPL | Stock | 15.2946 | 15.3132 | 15.2946 | 15.3071 | 32144.0 |
| 2013-04-08 07:19:00 | AAPL | Stock | 15.3071 | 15.3071 | 15.3071 | 15.3071 | 5600.0 |
| 2013-04-08 07:22:00 | AAPL | Stock | 15.3071 | 15.3071 | 15.3071 | 15.3071 | 11200.0 |
| 2013-04-08 07:24:00 | AAPL | Stock | 15.3071 | 15.3211 | 15.3071 | 15.3211 | 19460.0 |
| 2013-04-08 07:25:00 | AAPL | Stock | 15.3211 | 15.3211 | 15.3211 | 15.3211 | 11200.0 |
| 2013-04-08 07:26:00 | AAPL | Stock | 15.3186 | 15.3214 | 15.3186 | 15.3214 | 47068.0 |
| 2013-04-08 07:27:00 | AAPL | Stock | 15.33 | 15.33 | 15.3196 | 15.3196 | 22400.0 |
| 2013-04-08 07:28:00 | AAPL | Stock | 15.3196 | 15.3214 | 15.3036 | 15.3036 | 56000.0 |
| 2013-04-08 07:29:00 | AAPL | Stock | 15.3036 | 15.3036 | 15.3036 | 15.3036 | 5600.0 |
| 2013-04-08 07:31:00 | AAPL | Stock | 15.2946 | 15.2946 | 15.2946 | 15.2946 | 8400.0 |
| 2013-04-08 07:32:00 | AAPL | Stock | 15.2875 | 15.2875 | 15.2857 | 15.2875 | 36400.0 |
| 2013-04-08 07:33:00 | AAPL | Stock | 15.2857 | 15.2857 | 15.2718 | 15.2718 | 11200.0 |
| 2013-04-08 07:35:00 | AAPL | Stock | 15.2857 | 15.2857 | 15.2721 | 15.2721 | 5600.0 |
| 2013-04-08 07:36:00 | AAPL | Stock | 15.2721 | 15.2721 | 15.2721 | 15.2721 | 5600.0 |
| 2013-04-08 07:41:00 | AAPL | Stock | 15.2804 | 15.2875 | 15.2804 | 15.2875 | 38388.0 |
| 2013-04-08 07:47:00 | AAPL | Stock | 15.2682 | 15.2682 | 15.2682 | 15.2682 | 3948.0 |
| 2013-04-08 07:48:00 | AAPL | Stock | 15.2754 | 15.2754 | 15.2754 | 15.2754 | 5600.0 |
> showing 50 of 945,685 rows — these rows as CSV