PREVIEW / stock_1min / 2017-06-22
file: by_date/stock_1min/2017/2017-06-22.parquet size: 14.3 MB rows: 1,046,207 symbols: 2,496
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-22 04:24:00 | AAPL | Stock | 36.5225 | 36.5225 | 36.5225 | 36.5225 | 800.0 |
| 2017-06-22 04:53:00 | AAPL | Stock | 36.4925 | 36.4925 | 36.4875 | 36.4875 | 1716.0 |
| 2017-06-22 06:04:00 | AAPL | Stock | 36.485 | 36.485 | 36.485 | 36.485 | 2000.0 |
| 2017-06-22 06:07:00 | AAPL | Stock | 36.455 | 36.455 | 36.455 | 36.455 | 400.0 |
| 2017-06-22 06:14:00 | AAPL | Stock | 36.455 | 36.455 | 36.455 | 36.455 | 1224.0 |
| 2017-06-22 06:47:00 | AAPL | Stock | 36.45 | 36.45 | 36.45 | 36.45 | 1140.0 |
| 2017-06-22 07:27:00 | AAPL | Stock | 36.47 | 36.47 | 36.47 | 36.47 | 400.0 |
| 2017-06-22 07:30:00 | AAPL | Stock | 36.46 | 36.46 | 36.46 | 36.46 | 2000.0 |
| 2017-06-22 07:34:00 | AAPL | Stock | 36.4525 | 36.4525 | 36.45 | 36.45 | 2652.0 |
| 2017-06-22 07:54:00 | AAPL | Stock | 36.4425 | 36.4425 | 36.4425 | 36.4425 | 400.0 |
| 2017-06-22 07:56:00 | AAPL | Stock | 36.44 | 36.44 | 36.4375 | 36.4375 | 6220.0 |
| 2017-06-22 07:57:00 | AAPL | Stock | 36.4125 | 36.4125 | 36.4125 | 36.4125 | 8000.0 |
| 2017-06-22 07:58:00 | AAPL | Stock | 36.45 | 36.45 | 36.45 | 36.45 | 2400.0 |
| 2017-06-22 07:59:00 | AAPL | Stock | 36.4475 | 36.4475 | 36.4475 | 36.4475 | 2420.0 |
| 2017-06-22 08:00:00 | AAPL | Stock | 36.45 | 36.45 | 36.4275 | 36.4275 | 2344.0 |
| 2017-06-22 08:02:00 | AAPL | Stock | 36.4325 | 36.44 | 36.43 | 36.44 | 7380.0 |
| 2017-06-22 08:05:00 | AAPL | Stock | 36.435 | 36.435 | 36.4325 | 36.4325 | 2232.0 |
| 2017-06-22 08:06:00 | AAPL | Stock | 36.4325 | 36.4375 | 36.4325 | 36.4325 | 16144.0 |
| 2017-06-22 08:07:00 | AAPL | Stock | 36.425 | 36.425 | 36.425 | 36.425 | 400.0 |
| 2017-06-22 08:08:00 | AAPL | Stock | 36.425 | 36.425 | 36.425 | 36.425 | 2000.0 |
| 2017-06-22 08:09:00 | AAPL | Stock | 36.4175 | 36.4175 | 36.4175 | 36.4175 | 1200.0 |
| 2017-06-22 08:16:00 | AAPL | Stock | 36.425 | 36.425 | 36.425 | 36.425 | 1736.0 |
| 2017-06-22 08:20:00 | AAPL | Stock | 36.44 | 36.44 | 36.44 | 36.44 | 11744.0 |
| 2017-06-22 08:22:00 | AAPL | Stock | 36.4375 | 36.4375 | 36.4375 | 36.4375 | 800.0 |
| 2017-06-22 08:25:00 | AAPL | Stock | 36.4625 | 36.465 | 36.45 | 36.465 | 8000.0 |
| 2017-06-22 08:40:00 | AAPL | Stock | 36.475 | 36.475 | 36.475 | 36.475 | 800.0 |
| 2017-06-22 08:43:00 | AAPL | Stock | 36.4725 | 36.4725 | 36.4725 | 36.4725 | 2200.0 |
| 2017-06-22 08:45:00 | AAPL | Stock | 36.4725 | 36.475 | 36.4725 | 36.475 | 5604.0 |
| 2017-06-22 08:49:00 | AAPL | Stock | 36.48 | 36.48 | 36.48 | 36.48 | 17000.0 |
| 2017-06-22 08:58:00 | AAPL | Stock | 36.465 | 36.465 | 36.4625 | 36.4625 | 5508.0 |
| 2017-06-22 08:59:00 | AAPL | Stock | 36.45 | 36.45 | 36.4475 | 36.4475 | 1200.0 |
| 2017-06-22 09:05:00 | AAPL | Stock | 36.4475 | 36.4475 | 36.4475 | 36.4475 | 2000.0 |
| 2017-06-22 09:07:00 | AAPL | Stock | 36.445 | 36.445 | 36.445 | 36.445 | 1464.0 |
| 2017-06-22 09:13:00 | AAPL | Stock | 36.45 | 36.45 | 36.45 | 36.45 | 400.0 |
| 2017-06-22 09:14:00 | AAPL | Stock | 36.45 | 36.45 | 36.45 | 36.45 | 400.0 |
| 2017-06-22 09:15:00 | AAPL | Stock | 36.4525 | 36.4525 | 36.4525 | 36.4525 | 600.0 |
| 2017-06-22 09:17:00 | AAPL | Stock | 36.48 | 36.48 | 36.4525 | 36.4525 | 1200.0 |
| 2017-06-22 09:19:00 | AAPL | Stock | 36.455 | 36.4575 | 36.455 | 36.4575 | 800.0 |
| 2017-06-22 09:20:00 | AAPL | Stock | 36.455 | 36.455 | 36.4525 | 36.4525 | 3112.0 |
| 2017-06-22 09:21:00 | AAPL | Stock | 36.48 | 36.48 | 36.45 | 36.45 | 4408.0 |
| 2017-06-22 09:25:00 | AAPL | Stock | 36.475 | 36.475 | 36.475 | 36.475 | 680.0 |
| 2017-06-22 09:26:00 | AAPL | Stock | 36.475 | 36.475 | 36.475 | 36.475 | 1200.0 |
| 2017-06-22 09:27:00 | AAPL | Stock | 36.475 | 36.5 | 36.475 | 36.4875 | 4704.0 |
| 2017-06-22 09:28:00 | AAPL | Stock | 36.45 | 36.45 | 36.4475 | 36.4475 | 3600.0 |
| 2017-06-22 09:29:00 | AAPL | Stock | 36.4375 | 36.445 | 36.405 | 36.4375 | 14820.0 |
| 2017-06-22 09:30:00 | AAPL | Stock | 36.4375 | 36.4925 | 36.4225 | 36.49 | 1331576.0 |
| 2017-06-22 09:31:00 | AAPL | Stock | 36.485 | 36.4925 | 36.395 | 36.4012 | 395004.0 |
| 2017-06-22 09:32:00 | AAPL | Stock | 36.41 | 36.4225 | 36.345 | 36.3675 | 354868.0 |
| 2017-06-22 09:33:00 | AAPL | Stock | 36.3675 | 36.425 | 36.365 | 36.4175 | 294512.0 |
| 2017-06-22 09:34:00 | AAPL | Stock | 36.4175 | 36.4275 | 36.3975 | 36.3975 | 144348.0 |
> showing 50 of 1,046,207 rows — these rows as CSV