PREVIEW / stock_1min / 2018-06-15
file: by_date/stock_1min/2018/2018-06-15.parquet size: 15.6 MB rows: 1,109,743 symbols: 2,348
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 |
|---|---|---|---|---|---|---|---|
| 2018-06-15 04:16:00 | AAPL | Stock | 47.545 | 47.545 | 47.545 | 47.545 | 744.0 |
| 2018-06-15 04:31:00 | AAPL | Stock | 47.6225 | 47.6225 | 47.6225 | 47.6225 | 800.0 |
| 2018-06-15 04:40:00 | AAPL | Stock | 47.6825 | 47.6825 | 47.6825 | 47.6825 | 908.0 |
| 2018-06-15 05:12:00 | AAPL | Stock | 47.625 | 47.625 | 47.625 | 47.625 | 828.0 |
| 2018-06-15 05:33:00 | AAPL | Stock | 47.585 | 47.585 | 47.585 | 47.585 | 800.0 |
| 2018-06-15 05:56:00 | AAPL | Stock | 47.585 | 47.585 | 47.585 | 47.585 | 3736.0 |
| 2018-06-15 05:57:00 | AAPL | Stock | 47.585 | 47.585 | 47.585 | 47.585 | 2400.0 |
| 2018-06-15 05:59:00 | AAPL | Stock | 47.5725 | 47.5725 | 47.5725 | 47.5725 | 400.0 |
| 2018-06-15 06:00:00 | AAPL | Stock | 47.5725 | 47.5725 | 47.5725 | 47.5725 | 14800.0 |
| 2018-06-15 06:04:00 | AAPL | Stock | 47.575 | 47.575 | 47.575 | 47.575 | 400.0 |
| 2018-06-15 06:19:00 | AAPL | Stock | 47.5725 | 47.5725 | 47.5725 | 47.5725 | 400.0 |
| 2018-06-15 06:20:00 | AAPL | Stock | 47.545 | 47.545 | 47.54 | 47.54 | 1996.0 |
| 2018-06-15 06:22:00 | AAPL | Stock | 47.51 | 47.51 | 47.51 | 47.51 | 400.0 |
| 2018-06-15 06:24:00 | AAPL | Stock | 47.51 | 47.51 | 47.51 | 47.51 | 400.0 |
| 2018-06-15 06:25:00 | AAPL | Stock | 47.5025 | 47.5025 | 47.5 | 47.5 | 2000.0 |
| 2018-06-15 06:27:00 | AAPL | Stock | 47.5 | 47.5 | 47.5 | 47.5 | 400.0 |
| 2018-06-15 06:28:00 | AAPL | Stock | 47.5075 | 47.5075 | 47.5075 | 47.5075 | 1532.0 |
| 2018-06-15 06:30:00 | AAPL | Stock | 47.4525 | 47.4525 | 47.4525 | 47.4525 | 3200.0 |
| 2018-06-15 06:32:00 | AAPL | Stock | 47.455 | 47.455 | 47.455 | 47.455 | 400.0 |
| 2018-06-15 06:37:00 | AAPL | Stock | 47.4575 | 47.4575 | 47.4575 | 47.4575 | 704.0 |
| 2018-06-15 06:49:00 | AAPL | Stock | 47.48 | 47.48 | 47.48 | 47.48 | 7836.0 |
| 2018-06-15 06:53:00 | AAPL | Stock | 47.505 | 47.505 | 47.505 | 47.505 | 1680.0 |
| 2018-06-15 07:00:00 | AAPL | Stock | 47.5475 | 47.57 | 47.5075 | 47.525 | 11084.0 |
| 2018-06-15 07:01:00 | AAPL | Stock | 47.545 | 47.545 | 47.545 | 47.545 | 800.0 |
| 2018-06-15 07:02:00 | AAPL | Stock | 47.525 | 47.525 | 47.525 | 47.525 | 400.0 |
| 2018-06-15 07:03:00 | AAPL | Stock | 47.515 | 47.525 | 47.5 | 47.5 | 25184.0 |
| 2018-06-15 07:04:00 | AAPL | Stock | 47.5025 | 47.5025 | 47.5025 | 47.5025 | 400.0 |
| 2018-06-15 07:05:00 | AAPL | Stock | 47.5225 | 47.525 | 47.5225 | 47.525 | 800.0 |
| 2018-06-15 07:08:00 | AAPL | Stock | 47.5225 | 47.525 | 47.5025 | 47.5025 | 2980.0 |
| 2018-06-15 07:11:00 | AAPL | Stock | 47.5 | 47.5 | 47.5 | 47.5 | 564.0 |
| 2018-06-15 07:15:00 | AAPL | Stock | 47.5 | 47.5 | 47.5 | 47.5 | 1900.0 |
| 2018-06-15 07:16:00 | AAPL | Stock | 47.5 | 47.5 | 47.5 | 47.5 | 3420.0 |
| 2018-06-15 07:17:00 | AAPL | Stock | 47.5 | 47.5 | 47.5 | 47.5 | 4804.0 |
| 2018-06-15 07:19:00 | AAPL | Stock | 47.5 | 47.5 | 47.5 | 47.5 | 1600.0 |
| 2018-06-15 07:22:00 | AAPL | Stock | 47.515 | 47.5225 | 47.515 | 47.5225 | 2000.0 |
| 2018-06-15 07:23:00 | AAPL | Stock | 47.52 | 47.52 | 47.52 | 47.52 | 800.0 |
| 2018-06-15 07:25:00 | AAPL | Stock | 47.5175 | 47.5175 | 47.5175 | 47.5175 | 820.0 |
| 2018-06-15 07:26:00 | AAPL | Stock | 47.5175 | 47.5175 | 47.5 | 47.5 | 1200.0 |
| 2018-06-15 07:28:00 | AAPL | Stock | 47.5025 | 47.5025 | 47.5025 | 47.5025 | 400.0 |
| 2018-06-15 07:33:00 | AAPL | Stock | 47.545 | 47.55 | 47.545 | 47.55 | 1200.0 |
| 2018-06-15 07:34:00 | AAPL | Stock | 47.5375 | 47.5375 | 47.5375 | 47.5375 | 800.0 |
| 2018-06-15 07:35:00 | AAPL | Stock | 47.575 | 47.5775 | 47.575 | 47.5775 | 1200.0 |
| 2018-06-15 07:37:00 | AAPL | Stock | 47.57 | 47.5875 | 47.57 | 47.5875 | 1200.0 |
| 2018-06-15 07:38:00 | AAPL | Stock | 47.5875 | 47.5875 | 47.575 | 47.575 | 2000.0 |
| 2018-06-15 07:40:00 | AAPL | Stock | 47.58 | 47.58 | 47.58 | 47.58 | 2000.0 |
| 2018-06-15 07:42:00 | AAPL | Stock | 47.5475 | 47.5475 | 47.5475 | 47.5475 | 800.0 |
| 2018-06-15 07:43:00 | AAPL | Stock | 47.575 | 47.575 | 47.575 | 47.575 | 2000.0 |
| 2018-06-15 07:44:00 | AAPL | Stock | 47.575 | 47.575 | 47.575 | 47.575 | 2012.0 |
| 2018-06-15 07:45:00 | AAPL | Stock | 47.575 | 47.575 | 47.575 | 47.575 | 1800.0 |
| 2018-06-15 07:47:00 | AAPL | Stock | 47.5825 | 47.5825 | 47.5825 | 47.5825 | 1200.0 |
> showing 50 of 1,109,743 rows — these rows as CSV