PREVIEW / stock_1min / 2018-10-16
file: by_date/stock_1min/2018/2018-10-16.parquet size: 16.6 MB rows: 1,109,868 symbols: 2,317
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-10-16 04:00:00 | AAPL | Stock | 54.5 | 54.64 | 54.5 | 54.64 | 1488.0 |
| 2018-10-16 04:01:00 | AAPL | Stock | 54.6275 | 54.6275 | 54.6275 | 54.6275 | 400.0 |
| 2018-10-16 04:04:00 | AAPL | Stock | 54.725 | 54.725 | 54.725 | 54.725 | 2800.0 |
| 2018-10-16 04:15:00 | AAPL | Stock | 54.7125 | 54.7125 | 54.7125 | 54.7125 | 400.0 |
| 2018-10-16 04:27:00 | AAPL | Stock | 54.63 | 54.63 | 54.63 | 54.63 | 1200.0 |
| 2018-10-16 04:31:00 | AAPL | Stock | 54.625 | 54.625 | 54.625 | 54.625 | 400.0 |
| 2018-10-16 04:39:00 | AAPL | Stock | 54.5675 | 54.5675 | 54.55 | 54.55 | 2976.0 |
| 2018-10-16 04:40:00 | AAPL | Stock | 54.5425 | 54.5425 | 54.525 | 54.525 | 1320.0 |
| 2018-10-16 04:46:00 | AAPL | Stock | 54.525 | 54.525 | 54.525 | 54.525 | 1984.0 |
| 2018-10-16 04:47:00 | AAPL | Stock | 54.525 | 54.525 | 54.5 | 54.5 | 3600.0 |
| 2018-10-16 05:47:00 | AAPL | Stock | 54.6 | 54.6 | 54.6 | 54.6 | 1600.0 |
| 2018-10-16 05:48:00 | AAPL | Stock | 54.6 | 54.6 | 54.6 | 54.6 | 400.0 |
| 2018-10-16 05:51:00 | AAPL | Stock | 54.6 | 54.6 | 54.6 | 54.6 | 400.0 |
| 2018-10-16 06:03:00 | AAPL | Stock | 54.5975 | 54.5975 | 54.575 | 54.575 | 3196.0 |
| 2018-10-16 06:06:00 | AAPL | Stock | 54.575 | 54.575 | 54.575 | 54.575 | 1440.0 |
| 2018-10-16 06:21:00 | AAPL | Stock | 54.6 | 54.6 | 54.6 | 54.6 | 400.0 |
| 2018-10-16 06:23:00 | AAPL | Stock | 54.6475 | 54.6475 | 54.6475 | 54.6475 | 8000.0 |
| 2018-10-16 06:24:00 | AAPL | Stock | 54.65 | 54.65 | 54.65 | 54.65 | 800.0 |
| 2018-10-16 06:51:00 | AAPL | Stock | 54.6875 | 54.6875 | 54.6875 | 54.6875 | 400.0 |
| 2018-10-16 06:59:00 | AAPL | Stock | 54.6725 | 54.6725 | 54.6725 | 54.6725 | 784.0 |
| 2018-10-16 07:00:00 | AAPL | Stock | 54.6725 | 54.6725 | 54.545 | 54.6 | 5168.0 |
| 2018-10-16 07:01:00 | AAPL | Stock | 54.6 | 54.6 | 54.5375 | 54.5375 | 6760.0 |
| 2018-10-16 07:02:00 | AAPL | Stock | 54.5525 | 54.605 | 54.5525 | 54.605 | 12764.0 |
| 2018-10-16 07:04:00 | AAPL | Stock | 54.5625 | 54.565 | 54.54 | 54.54 | 3296.0 |
| 2018-10-16 07:05:00 | AAPL | Stock | 54.5625 | 54.5625 | 54.5625 | 54.5625 | 1080.0 |
| 2018-10-16 07:08:00 | AAPL | Stock | 54.5625 | 54.5875 | 54.5 | 54.5725 | 25508.0 |
| 2018-10-16 07:09:00 | AAPL | Stock | 54.5725 | 54.5725 | 54.5725 | 54.5725 | 400.0 |
| 2018-10-16 07:12:00 | AAPL | Stock | 54.57 | 54.57 | 54.55 | 54.55 | 4076.0 |
| 2018-10-16 07:13:00 | AAPL | Stock | 54.5175 | 54.525 | 54.5175 | 54.5225 | 2000.0 |
| 2018-10-16 07:14:00 | AAPL | Stock | 54.555 | 54.555 | 54.555 | 54.555 | 2000.0 |
| 2018-10-16 07:15:00 | AAPL | Stock | 54.555 | 54.5725 | 54.555 | 54.5725 | 4400.0 |
| 2018-10-16 07:17:00 | AAPL | Stock | 54.61 | 54.625 | 54.5975 | 54.625 | 14000.0 |
| 2018-10-16 07:18:00 | AAPL | Stock | 54.6625 | 54.6625 | 54.63 | 54.63 | 1200.0 |
| 2018-10-16 07:19:00 | AAPL | Stock | 54.645 | 54.6625 | 54.645 | 54.6625 | 10068.0 |
| 2018-10-16 07:20:00 | AAPL | Stock | 54.65 | 54.655 | 54.65 | 54.655 | 1880.0 |
| 2018-10-16 07:21:00 | AAPL | Stock | 54.6475 | 54.6475 | 54.6475 | 54.6475 | 2800.0 |
| 2018-10-16 07:22:00 | AAPL | Stock | 54.6375 | 54.6375 | 54.625 | 54.625 | 5200.0 |
| 2018-10-16 07:25:00 | AAPL | Stock | 54.6375 | 54.64 | 54.6375 | 54.64 | 2800.0 |
| 2018-10-16 07:27:00 | AAPL | Stock | 54.6375 | 54.6375 | 54.625 | 54.625 | 7160.0 |
| 2018-10-16 07:29:00 | AAPL | Stock | 54.64 | 54.645 | 54.625 | 54.625 | 3000.0 |
| 2018-10-16 07:30:00 | AAPL | Stock | 54.625 | 54.625 | 54.625 | 54.625 | 3000.0 |
| 2018-10-16 07:31:00 | AAPL | Stock | 54.625 | 54.625 | 54.625 | 54.625 | 800.0 |
| 2018-10-16 07:32:00 | AAPL | Stock | 54.635 | 54.65 | 54.635 | 54.65 | 7096.0 |
| 2018-10-16 07:33:00 | AAPL | Stock | 54.6425 | 54.6525 | 54.6425 | 54.6525 | 15100.0 |
| 2018-10-16 07:35:00 | AAPL | Stock | 54.65 | 54.655 | 54.6375 | 54.655 | 1716.0 |
| 2018-10-16 07:36:00 | AAPL | Stock | 54.6625 | 54.6625 | 54.6625 | 54.6625 | 3740.0 |
| 2018-10-16 07:37:00 | AAPL | Stock | 54.6625 | 54.6625 | 54.65 | 54.65 | 1400.0 |
| 2018-10-16 07:39:00 | AAPL | Stock | 54.645 | 54.66 | 54.6375 | 54.66 | 5968.0 |
| 2018-10-16 07:40:00 | AAPL | Stock | 54.6375 | 54.6375 | 54.6 | 54.6 | 10148.0 |
| 2018-10-16 07:41:00 | AAPL | Stock | 54.605 | 54.605 | 54.605 | 54.605 | 400.0 |
> showing 50 of 1,109,868 rows — these rows as CSV