PREVIEW / stock_1min / 2017-12-01
file: by_date/stock_1min/2017/2017-12-01.parquet size: 16.1 MB rows: 1,129,093 symbols: 2,443
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-01 04:01:00 | AAPL | Stock | 42.7375 | 42.7375 | 42.7375 | 42.7375 | 536.0 |
| 2017-12-01 04:08:00 | AAPL | Stock | 42.775 | 42.775 | 42.775 | 42.775 | 400.0 |
| 2017-12-01 04:24:00 | AAPL | Stock | 42.7875 | 42.7875 | 42.7875 | 42.7875 | 400.0 |
| 2017-12-01 04:25:00 | AAPL | Stock | 42.7875 | 42.7875 | 42.7875 | 42.7875 | 800.0 |
| 2017-12-01 04:48:00 | AAPL | Stock | 42.7875 | 42.7875 | 42.7875 | 42.7875 | 400.0 |
| 2017-12-01 05:05:00 | AAPL | Stock | 42.755 | 42.755 | 42.755 | 42.755 | 800.0 |
| 2017-12-01 05:08:00 | AAPL | Stock | 42.755 | 42.755 | 42.75 | 42.75 | 2000.0 |
| 2017-12-01 05:26:00 | AAPL | Stock | 42.8075 | 42.8075 | 42.8 | 42.8 | 800.0 |
| 2017-12-01 05:27:00 | AAPL | Stock | 42.8 | 42.8 | 42.8 | 42.8 | 400.0 |
| 2017-12-01 05:38:00 | AAPL | Stock | 42.775 | 42.775 | 42.775 | 42.775 | 400.0 |
| 2017-12-01 05:40:00 | AAPL | Stock | 42.75 | 42.75 | 42.75 | 42.75 | 3984.0 |
| 2017-12-01 05:42:00 | AAPL | Stock | 42.675 | 42.675 | 42.675 | 42.675 | 3460.0 |
| 2017-12-01 05:44:00 | AAPL | Stock | 42.675 | 42.675 | 42.675 | 42.675 | 400.0 |
| 2017-12-01 05:45:00 | AAPL | Stock | 42.675 | 42.675 | 42.675 | 42.675 | 1128.0 |
| 2017-12-01 05:46:00 | AAPL | Stock | 42.675 | 42.675 | 42.675 | 42.675 | 800.0 |
| 2017-12-01 06:02:00 | AAPL | Stock | 42.5775 | 42.5775 | 42.5775 | 42.5775 | 548.0 |
| 2017-12-01 06:06:00 | AAPL | Stock | 42.5775 | 42.5775 | 42.5775 | 42.5775 | 3200.0 |
| 2017-12-01 06:07:00 | AAPL | Stock | 42.5775 | 42.5775 | 42.55 | 42.55 | 1936.0 |
| 2017-12-01 06:08:00 | AAPL | Stock | 42.55 | 42.55 | 42.55 | 42.55 | 3200.0 |
| 2017-12-01 06:10:00 | AAPL | Stock | 42.55 | 42.575 | 42.55 | 42.55 | 1200.0 |
| 2017-12-01 06:11:00 | AAPL | Stock | 42.55 | 42.55 | 42.55 | 42.55 | 1800.0 |
| 2017-12-01 06:14:00 | AAPL | Stock | 42.6225 | 42.6225 | 42.6225 | 42.6225 | 400.0 |
| 2017-12-01 06:16:00 | AAPL | Stock | 42.525 | 42.525 | 42.525 | 42.525 | 1288.0 |
| 2017-12-01 06:18:00 | AAPL | Stock | 42.51 | 42.51 | 42.5 | 42.5 | 2724.0 |
| 2017-12-01 06:19:00 | AAPL | Stock | 42.5 | 42.5 | 42.5 | 42.5 | 5600.0 |
| 2017-12-01 06:21:00 | AAPL | Stock | 42.5 | 42.5 | 42.5 | 42.5 | 2400.0 |
| 2017-12-01 06:24:00 | AAPL | Stock | 42.5 | 42.55 | 42.5 | 42.55 | 4452.0 |
| 2017-12-01 06:25:00 | AAPL | Stock | 42.55 | 42.5575 | 42.55 | 42.5575 | 1200.0 |
| 2017-12-01 06:26:00 | AAPL | Stock | 42.57 | 42.57 | 42.57 | 42.57 | 1920.0 |
| 2017-12-01 06:27:00 | AAPL | Stock | 42.5375 | 42.595 | 42.5375 | 42.595 | 1788.0 |
| 2017-12-01 06:28:00 | AAPL | Stock | 42.5875 | 42.6 | 42.5875 | 42.6 | 1996.0 |
| 2017-12-01 06:33:00 | AAPL | Stock | 42.585 | 42.585 | 42.5775 | 42.5775 | 2780.0 |
| 2017-12-01 06:34:00 | AAPL | Stock | 42.5775 | 42.5775 | 42.5775 | 42.5775 | 1620.0 |
| 2017-12-01 06:37:00 | AAPL | Stock | 42.61 | 42.61 | 42.6075 | 42.61 | 3600.0 |
| 2017-12-01 06:38:00 | AAPL | Stock | 42.6025 | 42.6025 | 42.6 | 42.6 | 2400.0 |
| 2017-12-01 06:40:00 | AAPL | Stock | 42.6 | 42.6225 | 42.6 | 42.6225 | 5600.0 |
| 2017-12-01 06:42:00 | AAPL | Stock | 42.6225 | 42.6225 | 42.6225 | 42.6225 | 2400.0 |
| 2017-12-01 06:43:00 | AAPL | Stock | 42.6225 | 42.6225 | 42.6225 | 42.6225 | 400.0 |
| 2017-12-01 06:44:00 | AAPL | Stock | 42.6475 | 42.6475 | 42.6475 | 42.6475 | 400.0 |
| 2017-12-01 06:47:00 | AAPL | Stock | 42.5875 | 42.5875 | 42.5875 | 42.5875 | 400.0 |
| 2017-12-01 07:00:00 | AAPL | Stock | 42.595 | 42.605 | 42.59 | 42.605 | 3460.0 |
| 2017-12-01 07:02:00 | AAPL | Stock | 42.605 | 42.625 | 42.605 | 42.625 | 14144.0 |
| 2017-12-01 07:03:00 | AAPL | Stock | 42.64 | 42.6875 | 42.64 | 42.6875 | 19588.0 |
| 2017-12-01 07:04:00 | AAPL | Stock | 42.68 | 42.68 | 42.6225 | 42.6225 | 38000.0 |
| 2017-12-01 07:05:00 | AAPL | Stock | 42.65 | 42.7925 | 42.625 | 42.7925 | 45972.0 |
| 2017-12-01 07:06:00 | AAPL | Stock | 42.745 | 42.745 | 42.6675 | 42.6675 | 3596.0 |
| 2017-12-01 07:08:00 | AAPL | Stock | 42.6875 | 42.6875 | 42.6875 | 42.6875 | 3600.0 |
| 2017-12-01 07:09:00 | AAPL | Stock | 42.6875 | 42.6875 | 42.675 | 42.675 | 5172.0 |
| 2017-12-01 07:10:00 | AAPL | Stock | 42.6675 | 42.6675 | 42.65 | 42.65 | 1672.0 |
| 2017-12-01 07:11:00 | AAPL | Stock | 42.6525 | 42.6625 | 42.65 | 42.6625 | 4236.0 |
> showing 50 of 1,129,093 rows — these rows as CSV