PREVIEW / stock_1min / 2013-09-30
file: by_date/stock_1min/2013/2013-09-30.parquet size: 13.8 MB rows: 1,006,309 symbols: 2,884
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-09-30 04:00:00 | AAPL | Stock | 17.1532 | 17.1532 | 17.0664 | 17.0664 | 5600.0 |
| 2013-09-30 04:06:00 | AAPL | Stock | 17.0664 | 17.0664 | 17.0664 | 17.0664 | 5600.0 |
| 2013-09-30 04:11:00 | AAPL | Stock | 17.0479 | 17.0479 | 17.0196 | 17.0196 | 9240.0 |
| 2013-09-30 04:12:00 | AAPL | Stock | 17.0204 | 17.0329 | 17.0204 | 17.0329 | 22036.0 |
| 2013-09-30 04:13:00 | AAPL | Stock | 17.025 | 17.025 | 17.025 | 17.025 | 8400.0 |
| 2013-09-30 04:15:00 | AAPL | Stock | 17.0257 | 17.0257 | 17.0236 | 17.0236 | 28000.0 |
| 2013-09-30 04:16:00 | AAPL | Stock | 17.0179 | 17.0179 | 17.0179 | 17.0179 | 58800.0 |
| 2013-09-30 04:17:00 | AAPL | Stock | 17.0104 | 17.0104 | 17.0104 | 17.0104 | 2800.0 |
| 2013-09-30 04:22:00 | AAPL | Stock | 17.0104 | 17.0104 | 17.0104 | 17.0104 | 48412.0 |
| 2013-09-30 04:35:00 | AAPL | Stock | 17.0118 | 17.0118 | 17.0039 | 17.0039 | 22400.0 |
| 2013-09-30 04:38:00 | AAPL | Stock | 17.0357 | 17.0357 | 17.0357 | 17.0357 | 8204.0 |
| 2013-09-30 04:46:00 | AAPL | Stock | 17.0446 | 17.0446 | 17.0446 | 17.0446 | 2800.0 |
| 2013-09-30 05:39:00 | AAPL | Stock | 17.0539 | 17.0539 | 17.0539 | 17.0539 | 2800.0 |
| 2013-09-30 05:52:00 | AAPL | Stock | 17.07 | 17.07 | 17.07 | 17.07 | 5600.0 |
| 2013-09-30 05:54:00 | AAPL | Stock | 17.0611 | 17.0714 | 17.0611 | 17.0714 | 8400.0 |
| 2013-09-30 06:00:00 | AAPL | Stock | 17.0543 | 17.0543 | 17.0543 | 17.0543 | 4452.0 |
| 2013-09-30 06:15:00 | AAPL | Stock | 17.0693 | 17.0725 | 17.0693 | 17.0725 | 23212.0 |
| 2013-09-30 06:17:00 | AAPL | Stock | 17.0782 | 17.0786 | 17.0782 | 17.0786 | 5600.0 |
| 2013-09-30 06:19:00 | AAPL | Stock | 17.0714 | 17.0714 | 17.0714 | 17.0714 | 2800.0 |
| 2013-09-30 06:35:00 | AAPL | Stock | 17.0754 | 17.0754 | 17.0714 | 17.0714 | 20720.0 |
| 2013-09-30 06:36:00 | AAPL | Stock | 17.0714 | 17.0754 | 17.0714 | 17.075 | 14000.0 |
| 2013-09-30 06:37:00 | AAPL | Stock | 17.0714 | 17.0714 | 17.0714 | 17.0714 | 28000.0 |
| 2013-09-30 06:41:00 | AAPL | Stock | 17.075 | 17.075 | 17.0714 | 17.0714 | 8792.0 |
| 2013-09-30 06:43:00 | AAPL | Stock | 17.0711 | 17.0711 | 17.0711 | 17.0711 | 56000.0 |
| 2013-09-30 06:46:00 | AAPL | Stock | 17.0611 | 17.0704 | 17.0611 | 17.0704 | 19600.0 |
| 2013-09-30 06:48:00 | AAPL | Stock | 17.0629 | 17.0629 | 17.0629 | 17.0629 | 2800.0 |
| 2013-09-30 06:50:00 | AAPL | Stock | 17.0539 | 17.0539 | 17.0539 | 17.0539 | 2800.0 |
| 2013-09-30 06:52:00 | AAPL | Stock | 17.0589 | 17.0589 | 17.0589 | 17.0589 | 2800.0 |
| 2013-09-30 06:53:00 | AAPL | Stock | 17.0625 | 17.0625 | 17.0586 | 17.0593 | 69860.0 |
| 2013-09-30 07:00:00 | AAPL | Stock | 17.0607 | 17.0607 | 17.0607 | 17.0607 | 8400.0 |
| 2013-09-30 07:01:00 | AAPL | Stock | 17.0707 | 17.0707 | 17.0707 | 17.0707 | 2800.0 |
| 2013-09-30 07:02:00 | AAPL | Stock | 17.0671 | 17.0714 | 17.0664 | 17.0711 | 34132.0 |
| 2013-09-30 07:04:00 | AAPL | Stock | 17.0714 | 17.0714 | 17.0714 | 17.0714 | 14000.0 |
| 2013-09-30 07:08:00 | AAPL | Stock | 17.0721 | 17.0721 | 17.0721 | 17.0721 | 14420.0 |
| 2013-09-30 07:09:00 | AAPL | Stock | 17.0757 | 17.0757 | 17.0757 | 17.0757 | 30800.0 |
| 2013-09-30 07:10:00 | AAPL | Stock | 17.085 | 17.085 | 17.085 | 17.085 | 2800.0 |
| 2013-09-30 07:11:00 | AAPL | Stock | 17.0854 | 17.0857 | 17.0846 | 17.0857 | 12600.0 |
| 2013-09-30 07:12:00 | AAPL | Stock | 17.0929 | 17.0961 | 17.0929 | 17.0961 | 11200.0 |
| 2013-09-30 07:14:00 | AAPL | Stock | 17.0893 | 17.0946 | 17.0893 | 17.0946 | 5600.0 |
| 2013-09-30 07:16:00 | AAPL | Stock | 17.0896 | 17.09 | 17.0804 | 17.0886 | 61012.0 |
| 2013-09-30 07:17:00 | AAPL | Stock | 17.0839 | 17.0839 | 17.0714 | 17.0714 | 29456.0 |
| 2013-09-30 07:18:00 | AAPL | Stock | 17.0714 | 17.0714 | 17.0714 | 17.0714 | 5600.0 |
| 2013-09-30 07:21:00 | AAPL | Stock | 17.0682 | 17.0682 | 17.0682 | 17.0682 | 2800.0 |
| 2013-09-30 07:22:00 | AAPL | Stock | 17.0689 | 17.0689 | 17.0689 | 17.0689 | 3164.0 |
| 2013-09-30 07:24:00 | AAPL | Stock | 17.0639 | 17.0643 | 17.0639 | 17.0643 | 5600.0 |
| 2013-09-30 07:25:00 | AAPL | Stock | 17.0643 | 17.0714 | 17.0643 | 17.0679 | 38528.0 |
| 2013-09-30 07:26:00 | AAPL | Stock | 17.0621 | 17.0621 | 17.0618 | 17.0618 | 5600.0 |
| 2013-09-30 07:27:00 | AAPL | Stock | 17.0618 | 17.0618 | 17.0571 | 17.0571 | 30324.0 |
| 2013-09-30 07:28:00 | AAPL | Stock | 17.0554 | 17.0554 | 17.0554 | 17.0554 | 2800.0 |
| 2013-09-30 07:29:00 | AAPL | Stock | 17.0486 | 17.0486 | 17.0482 | 17.0482 | 8400.0 |
> showing 50 of 1,006,309 rows — these rows as CSV