PREVIEW / stock_1min / 2017-12-21
file: by_date/stock_1min/2017/2017-12-21.parquet size: 15.2 MB rows: 1,079,100 symbols: 2,436
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-12-21 04:30:00 | AAPL | Stock | 43.5 | 43.5 | 43.5 | 43.5 | 400.0 |
| 2017-12-21 05:00:00 | AAPL | Stock | 43.4575 | 43.4575 | 43.4575 | 43.4575 | 616.0 |
| 2017-12-21 05:05:00 | AAPL | Stock | 43.4625 | 43.4625 | 43.4625 | 43.4625 | 572.0 |
| 2017-12-21 05:07:00 | AAPL | Stock | 43.5 | 43.5 | 43.5 | 43.5 | 400.0 |
| 2017-12-21 05:10:00 | AAPL | Stock | 43.4625 | 43.4625 | 43.4625 | 43.4625 | 572.0 |
| 2017-12-21 05:11:00 | AAPL | Stock | 43.4625 | 43.4625 | 43.4625 | 43.4625 | 800.0 |
| 2017-12-21 05:15:00 | AAPL | Stock | 43.455 | 43.455 | 43.455 | 43.455 | 400.0 |
| 2017-12-21 05:40:00 | AAPL | Stock | 43.455 | 43.455 | 43.455 | 43.455 | 400.0 |
| 2017-12-21 05:56:00 | AAPL | Stock | 43.4625 | 43.4625 | 43.4625 | 43.4625 | 540.0 |
| 2017-12-21 06:16:00 | AAPL | Stock | 43.465 | 43.465 | 43.465 | 43.465 | 796.0 |
| 2017-12-21 06:32:00 | AAPL | Stock | 43.48 | 43.48 | 43.48 | 43.48 | 924.0 |
| 2017-12-21 06:36:00 | AAPL | Stock | 43.55 | 43.55 | 43.55 | 43.55 | 400.0 |
| 2017-12-21 06:56:00 | AAPL | Stock | 43.515 | 43.515 | 43.5025 | 43.5025 | 1080.0 |
| 2017-12-21 07:00:00 | AAPL | Stock | 43.5 | 43.5 | 43.5 | 43.5 | 400.0 |
| 2017-12-21 07:02:00 | AAPL | Stock | 43.525 | 43.525 | 43.525 | 43.525 | 1800.0 |
| 2017-12-21 07:06:00 | AAPL | Stock | 43.5375 | 43.5375 | 43.5375 | 43.5375 | 4656.0 |
| 2017-12-21 07:16:00 | AAPL | Stock | 43.54 | 43.54 | 43.54 | 43.54 | 1200.0 |
| 2017-12-21 07:25:00 | AAPL | Stock | 43.5125 | 43.5375 | 43.5125 | 43.5375 | 800.0 |
| 2017-12-21 07:32:00 | AAPL | Stock | 43.5125 | 43.5125 | 43.5125 | 43.5125 | 852.0 |
| 2017-12-21 07:34:00 | AAPL | Stock | 43.515 | 43.515 | 43.515 | 43.515 | 1600.0 |
| 2017-12-21 07:35:00 | AAPL | Stock | 43.5275 | 43.5275 | 43.5275 | 43.5275 | 860.0 |
| 2017-12-21 07:38:00 | AAPL | Stock | 43.5125 | 43.5125 | 43.5125 | 43.5125 | 400.0 |
| 2017-12-21 07:39:00 | AAPL | Stock | 43.53 | 43.5375 | 43.53 | 43.5375 | 2376.0 |
| 2017-12-21 07:42:00 | AAPL | Stock | 43.5475 | 43.5475 | 43.5475 | 43.5475 | 400.0 |
| 2017-12-21 07:48:00 | AAPL | Stock | 43.56 | 43.56 | 43.56 | 43.56 | 1600.0 |
| 2017-12-21 07:49:00 | AAPL | Stock | 43.565 | 43.565 | 43.565 | 43.565 | 4808.0 |
| 2017-12-21 07:50:00 | AAPL | Stock | 43.57 | 43.57 | 43.565 | 43.565 | 5752.0 |
| 2017-12-21 07:51:00 | AAPL | Stock | 43.5625 | 43.5875 | 43.5625 | 43.5875 | 4800.0 |
| 2017-12-21 07:53:00 | AAPL | Stock | 43.565 | 43.565 | 43.5625 | 43.5625 | 2348.0 |
| 2017-12-21 07:56:00 | AAPL | Stock | 43.575 | 43.575 | 43.575 | 43.575 | 800.0 |
| 2017-12-21 07:59:00 | AAPL | Stock | 43.565 | 43.565 | 43.5625 | 43.5625 | 5000.0 |
| 2017-12-21 08:00:00 | AAPL | Stock | 43.5375 | 43.5875 | 43.505 | 43.5875 | 29388.0 |
| 2017-12-21 08:03:00 | AAPL | Stock | 43.5875 | 43.5875 | 43.5875 | 43.5875 | 800.0 |
| 2017-12-21 08:07:00 | AAPL | Stock | 43.5875 | 43.5875 | 43.5875 | 43.5875 | 5600.0 |
| 2017-12-21 08:10:00 | AAPL | Stock | 43.5875 | 43.5875 | 43.5875 | 43.5875 | 2000.0 |
| 2017-12-21 08:11:00 | AAPL | Stock | 43.5875 | 43.5875 | 43.5875 | 43.5875 | 1200.0 |
| 2017-12-21 08:12:00 | AAPL | Stock | 43.59 | 43.59 | 43.59 | 43.59 | 1200.0 |
| 2017-12-21 08:13:00 | AAPL | Stock | 43.605 | 43.605 | 43.605 | 43.605 | 800.0 |
| 2017-12-21 08:18:00 | AAPL | Stock | 43.62 | 43.63 | 43.6075 | 43.625 | 11064.0 |
| 2017-12-21 08:19:00 | AAPL | Stock | 43.625 | 43.635 | 43.625 | 43.625 | 15192.0 |
| 2017-12-21 08:20:00 | AAPL | Stock | 43.6275 | 43.6275 | 43.625 | 43.625 | 4800.0 |
| 2017-12-21 08:21:00 | AAPL | Stock | 43.625 | 43.625 | 43.625 | 43.625 | 1996.0 |
| 2017-12-21 08:22:00 | AAPL | Stock | 43.6125 | 43.625 | 43.6125 | 43.625 | 2652.0 |
| 2017-12-21 08:23:00 | AAPL | Stock | 43.625 | 43.625 | 43.625 | 43.625 | 800.0 |
| 2017-12-21 08:25:00 | AAPL | Stock | 43.635 | 43.635 | 43.635 | 43.635 | 400.0 |
| 2017-12-21 08:27:00 | AAPL | Stock | 43.625 | 43.625 | 43.625 | 43.625 | 2000.0 |
| 2017-12-21 08:28:00 | AAPL | Stock | 43.6375 | 43.6375 | 43.6375 | 43.6375 | 1660.0 |
| 2017-12-21 08:30:00 | AAPL | Stock | 43.6375 | 43.6375 | 43.6375 | 43.6375 | 488.0 |
| 2017-12-21 08:31:00 | AAPL | Stock | 43.6375 | 43.6375 | 43.6375 | 43.6375 | 2000.0 |
| 2017-12-21 08:32:00 | AAPL | Stock | 43.6275 | 43.6275 | 43.6 | 43.6 | 14484.0 |
> showing 50 of 1,079,100 rows — these rows as CSV