PREVIEW / stock_1min / 2016-06-17
file: by_date/stock_1min/2016/2016-06-17.parquet size: 14.7 MB rows: 1,083,070 symbols: 2,680
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 |
|---|---|---|---|---|---|---|---|
| 2016-06-17 04:25:00 | AAPL | Stock | 24.3675 | 24.3675 | 24.3675 | 24.3675 | 720.0 |
| 2016-06-17 04:26:00 | AAPL | Stock | 24.34 | 24.34 | 24.34 | 24.34 | 880.0 |
| 2016-06-17 04:27:00 | AAPL | Stock | 24.3175 | 24.3175 | 24.3175 | 24.3175 | 2000.0 |
| 2016-06-17 05:04:00 | AAPL | Stock | 24.32 | 24.32 | 24.32 | 24.32 | 2000.0 |
| 2016-06-17 05:06:00 | AAPL | Stock | 24.32 | 24.32 | 24.32 | 24.32 | 800.0 |
| 2016-06-17 05:20:00 | AAPL | Stock | 24.32 | 24.32 | 24.32 | 24.32 | 3200.0 |
| 2016-06-17 05:21:00 | AAPL | Stock | 24.3125 | 24.3125 | 24.3125 | 24.3125 | 400.0 |
| 2016-06-17 05:24:00 | AAPL | Stock | 24.3125 | 24.3125 | 24.305 | 24.305 | 3200.0 |
| 2016-06-17 05:25:00 | AAPL | Stock | 24.295 | 24.295 | 24.2875 | 24.2875 | 3200.0 |
| 2016-06-17 05:27:00 | AAPL | Stock | 24.27 | 24.27 | 24.25 | 24.25 | 5272.0 |
| 2016-06-17 05:33:00 | AAPL | Stock | 24.235 | 24.235 | 24.2125 | 24.2125 | 1912.0 |
| 2016-06-17 05:34:00 | AAPL | Stock | 24.3375 | 24.3375 | 24.3375 | 24.3375 | 400.0 |
| 2016-06-17 06:00:00 | AAPL | Stock | 24.3325 | 24.3325 | 24.3325 | 24.3325 | 2000.0 |
| 2016-06-17 06:01:00 | AAPL | Stock | 24.25 | 24.25 | 24.25 | 24.25 | 2240.0 |
| 2016-06-17 06:02:00 | AAPL | Stock | 24.25 | 24.25 | 24.25 | 24.25 | 2000.0 |
| 2016-06-17 06:12:00 | AAPL | Stock | 24.25 | 24.25 | 24.25 | 24.25 | 2680.0 |
| 2016-06-17 06:14:00 | AAPL | Stock | 24.245 | 24.245 | 24.245 | 24.245 | 1200.0 |
| 2016-06-17 06:20:00 | AAPL | Stock | 24.25 | 24.25 | 24.25 | 24.25 | 1152.0 |
| 2016-06-17 06:21:00 | AAPL | Stock | 24.25 | 24.25 | 24.25 | 24.25 | 848.0 |
| 2016-06-17 06:36:00 | AAPL | Stock | 24.2525 | 24.2525 | 24.2525 | 24.2525 | 2000.0 |
| 2016-06-17 06:37:00 | AAPL | Stock | 24.2875 | 24.2875 | 24.2875 | 24.2875 | 2000.0 |
| 2016-06-17 06:38:00 | AAPL | Stock | 24.3125 | 24.3125 | 24.3125 | 24.3125 | 2000.0 |
| 2016-06-17 06:55:00 | AAPL | Stock | 24.2875 | 24.2875 | 24.2625 | 24.2625 | 3964.0 |
| 2016-06-17 06:56:00 | AAPL | Stock | 24.2525 | 24.2525 | 24.2525 | 24.2525 | 3600.0 |
| 2016-06-17 07:00:00 | AAPL | Stock | 24.2575 | 24.2575 | 24.255 | 24.255 | 7600.0 |
| 2016-06-17 07:03:00 | AAPL | Stock | 24.255 | 24.255 | 24.255 | 24.255 | 4836.0 |
| 2016-06-17 07:06:00 | AAPL | Stock | 24.27 | 24.27 | 24.265 | 24.265 | 1324.0 |
| 2016-06-17 07:14:00 | AAPL | Stock | 24.2775 | 24.2775 | 24.2775 | 24.2775 | 400.0 |
| 2016-06-17 07:15:00 | AAPL | Stock | 24.2775 | 24.2775 | 24.275 | 24.275 | 16800.0 |
| 2016-06-17 07:34:00 | AAPL | Stock | 24.2525 | 24.2525 | 24.2525 | 24.2525 | 920.0 |
| 2016-06-17 07:35:00 | AAPL | Stock | 24.2625 | 24.2625 | 24.2625 | 24.2625 | 2000.0 |
| 2016-06-17 07:37:00 | AAPL | Stock | 24.2625 | 24.2625 | 24.25 | 24.25 | 8000.0 |
| 2016-06-17 07:38:00 | AAPL | Stock | 24.2525 | 24.275 | 24.24 | 24.275 | 18036.0 |
| 2016-06-17 07:39:00 | AAPL | Stock | 24.25 | 24.25 | 24.23 | 24.25 | 14400.0 |
| 2016-06-17 07:40:00 | AAPL | Stock | 24.25 | 24.25 | 24.25 | 24.25 | 20000.0 |
| 2016-06-17 07:41:00 | AAPL | Stock | 24.2475 | 24.25 | 24.2475 | 24.25 | 5220.0 |
| 2016-06-17 07:42:00 | AAPL | Stock | 24.25 | 24.25 | 24.225 | 24.225 | 14036.0 |
| 2016-06-17 07:52:00 | AAPL | Stock | 24.25 | 24.25 | 24.25 | 24.25 | 400.0 |
| 2016-06-17 07:54:00 | AAPL | Stock | 24.245 | 24.245 | 24.245 | 24.245 | 800.0 |
| 2016-06-17 07:55:00 | AAPL | Stock | 24.25 | 24.25 | 24.2375 | 24.2375 | 6400.0 |
| 2016-06-17 07:57:00 | AAPL | Stock | 24.24 | 24.24 | 24.24 | 24.24 | 400.0 |
| 2016-06-17 07:59:00 | AAPL | Stock | 24.23 | 24.23 | 24.225 | 24.225 | 10680.0 |
| 2016-06-17 08:00:00 | AAPL | Stock | 24.295 | 24.295 | 24.225 | 24.2375 | 64200.0 |
| 2016-06-17 08:01:00 | AAPL | Stock | 24.2475 | 24.25 | 24.225 | 24.225 | 35744.0 |
| 2016-06-17 08:03:00 | AAPL | Stock | 24.2375 | 24.2375 | 24.2375 | 24.2375 | 1200.0 |
| 2016-06-17 08:04:00 | AAPL | Stock | 24.2525 | 24.2525 | 24.25 | 24.2525 | 7700.0 |
| 2016-06-17 08:05:00 | AAPL | Stock | 24.2525 | 24.2525 | 24.2375 | 24.2375 | 4760.0 |
| 2016-06-17 08:06:00 | AAPL | Stock | 24.2475 | 24.25 | 24.2475 | 24.25 | 17392.0 |
| 2016-06-17 08:07:00 | AAPL | Stock | 24.25 | 24.25 | 24.25 | 24.25 | 8808.0 |
| 2016-06-17 08:09:00 | AAPL | Stock | 24.25 | 24.25 | 24.25 | 24.25 | 1000.0 |
> showing 50 of 1,083,070 rows — these rows as CSV