PREVIEW / stock_1min / 2017-06-30
file: by_date/stock_1min/2017/2017-06-30.parquet size: 14.1 MB rows: 1,030,548 symbols: 2,490
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 |
|---|---|---|---|---|---|---|---|
| 2017-06-30 05:01:00 | AAPL | Stock | 35.9875 | 35.9875 | 35.9875 | 35.9875 | 6968.0 |
| 2017-06-30 06:02:00 | AAPL | Stock | 36.0475 | 36.0475 | 36.0475 | 36.0475 | 1400.0 |
| 2017-06-30 06:07:00 | AAPL | Stock | 36.0225 | 36.0225 | 36.0225 | 36.0225 | 400.0 |
| 2017-06-30 06:09:00 | AAPL | Stock | 36.0525 | 36.065 | 36.0525 | 36.065 | 1480.0 |
| 2017-06-30 06:13:00 | AAPL | Stock | 36.0625 | 36.065 | 36.0625 | 36.065 | 2960.0 |
| 2017-06-30 06:17:00 | AAPL | Stock | 36.0725 | 36.0725 | 36.0725 | 36.0725 | 400.0 |
| 2017-06-30 06:34:00 | AAPL | Stock | 36.055 | 36.055 | 36.0525 | 36.0525 | 1820.0 |
| 2017-06-30 06:59:00 | AAPL | Stock | 36.09 | 36.09 | 36.09 | 36.09 | 892.0 |
| 2017-06-30 07:02:00 | AAPL | Stock | 36.0675 | 36.0675 | 36.0675 | 36.0675 | 800.0 |
| 2017-06-30 07:04:00 | AAPL | Stock | 36.08 | 36.08 | 36.08 | 36.08 | 4000.0 |
| 2017-06-30 07:05:00 | AAPL | Stock | 36.1 | 36.1 | 36.1 | 36.1 | 980.0 |
| 2017-06-30 07:06:00 | AAPL | Stock | 36.1 | 36.1025 | 36.1 | 36.1 | 8640.0 |
| 2017-06-30 07:08:00 | AAPL | Stock | 36.1075 | 36.1075 | 36.1075 | 36.1075 | 4000.0 |
| 2017-06-30 07:09:00 | AAPL | Stock | 36.1125 | 36.115 | 36.1125 | 36.115 | 3340.0 |
| 2017-06-30 07:10:00 | AAPL | Stock | 36.125 | 36.125 | 36.125 | 36.125 | 580.0 |
| 2017-06-30 07:11:00 | AAPL | Stock | 36.125 | 36.14 | 36.125 | 36.14 | 19532.0 |
| 2017-06-30 07:12:00 | AAPL | Stock | 36.14 | 36.14 | 36.14 | 36.14 | 12248.0 |
| 2017-06-30 07:13:00 | AAPL | Stock | 36.145 | 36.145 | 36.145 | 36.145 | 3484.0 |
| 2017-06-30 07:14:00 | AAPL | Stock | 36.125 | 36.125 | 36.1225 | 36.1225 | 8040.0 |
| 2017-06-30 07:16:00 | AAPL | Stock | 36.1125 | 36.1125 | 36.1075 | 36.1075 | 2848.0 |
| 2017-06-30 07:20:00 | AAPL | Stock | 36.1025 | 36.1025 | 36.1025 | 36.1025 | 5072.0 |
| 2017-06-30 07:25:00 | AAPL | Stock | 36.105 | 36.105 | 36.1 | 36.1 | 10672.0 |
| 2017-06-30 07:28:00 | AAPL | Stock | 36.0975 | 36.0975 | 36.0975 | 36.0975 | 600.0 |
| 2017-06-30 07:29:00 | AAPL | Stock | 36.075 | 36.075 | 36.075 | 36.075 | 1200.0 |
| 2017-06-30 07:30:00 | AAPL | Stock | 36.0625 | 36.0625 | 36.0625 | 36.0625 | 400.0 |
| 2017-06-30 07:32:00 | AAPL | Stock | 36.0625 | 36.07 | 36.0625 | 36.07 | 1392.0 |
| 2017-06-30 07:33:00 | AAPL | Stock | 36.07 | 36.08 | 36.07 | 36.08 | 3808.0 |
| 2017-06-30 07:35:00 | AAPL | Stock | 36.08 | 36.08 | 36.08 | 36.08 | 2000.0 |
| 2017-06-30 07:36:00 | AAPL | Stock | 36.0875 | 36.0875 | 36.0875 | 36.0875 | 400.0 |
| 2017-06-30 07:40:00 | AAPL | Stock | 36.0775 | 36.0775 | 36.0775 | 36.0775 | 4000.0 |
| 2017-06-30 07:50:00 | AAPL | Stock | 36.07 | 36.07 | 36.07 | 36.07 | 1200.0 |
| 2017-06-30 07:53:00 | AAPL | Stock | 36.0675 | 36.075 | 36.0675 | 36.075 | 2400.0 |
| 2017-06-30 07:54:00 | AAPL | Stock | 36.075 | 36.075 | 36.075 | 36.075 | 792.0 |
| 2017-06-30 07:55:00 | AAPL | Stock | 36.0825 | 36.0825 | 36.0825 | 36.0825 | 992.0 |
| 2017-06-30 07:56:00 | AAPL | Stock | 36.07 | 36.07 | 36.07 | 36.07 | 400.0 |
| 2017-06-30 07:58:00 | AAPL | Stock | 36.0675 | 36.0675 | 36.0675 | 36.0675 | 400.0 |
| 2017-06-30 08:00:00 | AAPL | Stock | 36.1125 | 36.145 | 36.0675 | 36.075 | 12848.0 |
| 2017-06-30 08:01:00 | AAPL | Stock | 36.07 | 36.07 | 36.0625 | 36.07 | 13612.0 |
| 2017-06-30 08:02:00 | AAPL | Stock | 36.0625 | 36.065 | 36.05 | 36.0525 | 22904.0 |
| 2017-06-30 08:03:00 | AAPL | Stock | 36.0425 | 36.0425 | 36.0425 | 36.0425 | 800.0 |
| 2017-06-30 08:05:00 | AAPL | Stock | 36.025 | 36.025 | 36.025 | 36.025 | 400.0 |
| 2017-06-30 08:06:00 | AAPL | Stock | 36.025 | 36.05 | 36.025 | 36.05 | 7472.0 |
| 2017-06-30 08:07:00 | AAPL | Stock | 36.05 | 36.05 | 36.05 | 36.05 | 13184.0 |
| 2017-06-30 08:09:00 | AAPL | Stock | 36.05 | 36.0775 | 36.05 | 36.0775 | 43008.0 |
| 2017-06-30 08:10:00 | AAPL | Stock | 36.0775 | 36.0775 | 36.065 | 36.065 | 2100.0 |
| 2017-06-30 08:11:00 | AAPL | Stock | 36.075 | 36.075 | 36.075 | 36.075 | 400.0 |
| 2017-06-30 08:12:00 | AAPL | Stock | 36.0625 | 36.0625 | 36.0625 | 36.0625 | 840.0 |
| 2017-06-30 08:13:00 | AAPL | Stock | 36.05 | 36.05 | 36.045 | 36.045 | 4800.0 |
| 2017-06-30 08:14:00 | AAPL | Stock | 36.0625 | 36.0625 | 36.0625 | 36.0625 | 400.0 |
| 2017-06-30 08:15:00 | AAPL | Stock | 36.05 | 36.0575 | 36.0375 | 36.0575 | 3140.0 |
> showing 50 of 1,030,548 rows — these rows as CSV