PREVIEW / stock_5min / 2017-10-16
file: by_date/stock_5min/2017/2017-10-16.parquet size: 5.4 MB rows: 348,843 symbols: 2,952
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-10-16 04:00:00 | AAPL | Stock | 39.535 | 39.55 | 39.535 | 39.55 | 8564.0 |
| 2017-10-16 04:05:00 | AAPL | Stock | 39.555 | 39.555 | 39.5525 | 39.5525 | 5320.0 |
| 2017-10-16 04:15:00 | AAPL | Stock | 39.5625 | 39.5625 | 39.5625 | 39.5625 | 576.0 |
| 2017-10-16 04:30:00 | AAPL | Stock | 39.55 | 39.55 | 39.4525 | 39.55 | 5056.0 |
| 2017-10-16 04:45:00 | AAPL | Stock | 39.5425 | 39.5425 | 39.5425 | 39.5425 | 2000.0 |
| 2017-10-16 04:50:00 | AAPL | Stock | 39.54 | 39.54 | 39.54 | 39.54 | 1600.0 |
| 2017-10-16 04:55:00 | AAPL | Stock | 39.545 | 39.545 | 39.545 | 39.545 | 3840.0 |
| 2017-10-16 05:15:00 | AAPL | Stock | 39.5375 | 39.5425 | 39.5375 | 39.5425 | 1712.0 |
| 2017-10-16 05:20:00 | AAPL | Stock | 39.535 | 39.535 | 39.535 | 39.535 | 400.0 |
| 2017-10-16 05:25:00 | AAPL | Stock | 39.505 | 39.5225 | 39.5 | 39.5225 | 3500.0 |
| 2017-10-16 05:40:00 | AAPL | Stock | 39.5125 | 39.5125 | 39.5125 | 39.5125 | 400.0 |
| 2017-10-16 05:55:00 | AAPL | Stock | 39.5425 | 39.5425 | 39.5425 | 39.5425 | 2784.0 |
| 2017-10-16 06:00:00 | AAPL | Stock | 39.5425 | 39.5425 | 39.5425 | 39.5425 | 400.0 |
| 2017-10-16 06:05:00 | AAPL | Stock | 39.5425 | 39.5425 | 39.5425 | 39.5425 | 1596.0 |
| 2017-10-16 06:15:00 | AAPL | Stock | 39.5425 | 39.5425 | 39.5425 | 39.5425 | 4240.0 |
| 2017-10-16 06:20:00 | AAPL | Stock | 39.5675 | 39.57 | 39.5675 | 39.57 | 8788.0 |
| 2017-10-16 06:25:00 | AAPL | Stock | 39.57 | 39.5775 | 39.57 | 39.5775 | 2000.0 |
| 2017-10-16 06:35:00 | AAPL | Stock | 39.5975 | 39.5975 | 39.5975 | 39.5975 | 3188.0 |
| 2017-10-16 06:40:00 | AAPL | Stock | 39.5975 | 39.6 | 39.5975 | 39.5975 | 4000.0 |
| 2017-10-16 06:50:00 | AAPL | Stock | 39.6 | 39.625 | 39.6 | 39.6 | 44720.0 |
| 2017-10-16 07:00:00 | AAPL | Stock | 39.565 | 39.5825 | 39.5425 | 39.5625 | 41840.0 |
| 2017-10-16 07:05:00 | AAPL | Stock | 39.5425 | 39.55 | 39.525 | 39.5375 | 39320.0 |
| 2017-10-16 07:10:00 | AAPL | Stock | 39.5575 | 39.5575 | 39.525 | 39.55 | 32732.0 |
| 2017-10-16 07:15:00 | AAPL | Stock | 39.55 | 39.5525 | 39.55 | 39.55 | 12780.0 |
| 2017-10-16 07:20:00 | AAPL | Stock | 39.55 | 39.5625 | 39.55 | 39.55 | 6552.0 |
| 2017-10-16 07:25:00 | AAPL | Stock | 39.535 | 39.55 | 39.5325 | 39.55 | 1800.0 |
| 2017-10-16 07:30:00 | AAPL | Stock | 39.56 | 39.56 | 39.53 | 39.53 | 6720.0 |
| 2017-10-16 07:35:00 | AAPL | Stock | 39.5275 | 39.5475 | 39.5275 | 39.5475 | 4336.0 |
| 2017-10-16 07:40:00 | AAPL | Stock | 39.545 | 39.55 | 39.545 | 39.55 | 6000.0 |
| 2017-10-16 07:45:00 | AAPL | Stock | 39.545 | 39.55 | 39.5375 | 39.55 | 6216.0 |
| 2017-10-16 07:50:00 | AAPL | Stock | 39.5575 | 39.5825 | 39.5575 | 39.575 | 15244.0 |
| 2017-10-16 07:55:00 | AAPL | Stock | 39.5825 | 39.5825 | 39.5625 | 39.5625 | 7360.0 |
| 2017-10-16 08:00:00 | AAPL | Stock | 39.575 | 39.58 | 39.525 | 39.5725 | 106512.0 |
| 2017-10-16 08:05:00 | AAPL | Stock | 39.57 | 39.57 | 39.565 | 39.57 | 2800.0 |
| 2017-10-16 08:10:00 | AAPL | Stock | 39.56 | 39.575 | 39.5575 | 39.57 | 24000.0 |
| 2017-10-16 08:15:00 | AAPL | Stock | 39.5725 | 39.5775 | 39.5725 | 39.5775 | 18888.0 |
| 2017-10-16 08:20:00 | AAPL | Stock | 39.5775 | 39.585 | 39.565 | 39.565 | 29264.0 |
| 2017-10-16 08:25:00 | AAPL | Stock | 39.565 | 39.565 | 39.56 | 39.5625 | 14708.0 |
| 2017-10-16 08:30:00 | AAPL | Stock | 39.5625 | 39.5725 | 39.5625 | 39.57 | 12044.0 |
| 2017-10-16 08:35:00 | AAPL | Stock | 39.575 | 39.5875 | 39.555 | 39.5625 | 81824.0 |
| 2017-10-16 08:40:00 | AAPL | Stock | 39.57 | 39.57 | 39.5625 | 39.5625 | 12896.0 |
| 2017-10-16 08:45:00 | AAPL | Stock | 39.5625 | 39.5675 | 39.545 | 39.55 | 12996.0 |
| 2017-10-16 08:50:00 | AAPL | Stock | 39.5425 | 39.5525 | 39.5425 | 39.55 | 13480.0 |
| 2017-10-16 08:55:00 | AAPL | Stock | 39.55 | 39.57 | 39.55 | 39.565 | 19800.0 |
| 2017-10-16 09:00:00 | AAPL | Stock | 39.5575 | 39.5625 | 39.5375 | 39.5425 | 48800.0 |
| 2017-10-16 09:05:00 | AAPL | Stock | 39.5425 | 39.5675 | 39.5425 | 39.5625 | 13472.0 |
| 2017-10-16 09:10:00 | AAPL | Stock | 39.5375 | 39.56 | 39.5375 | 39.56 | 7756.0 |
| 2017-10-16 09:15:00 | AAPL | Stock | 39.55 | 39.585 | 39.55 | 39.58 | 39296.0 |
| 2017-10-16 09:20:00 | AAPL | Stock | 39.5825 | 39.5875 | 39.5675 | 39.5725 | 27480.0 |
| 2017-10-16 09:25:00 | AAPL | Stock | 39.575 | 39.5875 | 39.3375 | 39.47 | 591884.0 |
> showing 50 of 348,843 rows — these rows as CSV