PREVIEW / stock_1min / 2018-12-12
file: by_date/stock_1min/2018/2018-12-12.parquet size: 16.3 MB rows: 1,143,855 symbols: 2,288
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-12-12 04:03:00 | AAPL | Stock | 42.4375 | 42.4375 | 42.4375 | 42.4375 | 400.0 |
| 2018-12-12 04:12:00 | AAPL | Stock | 42.5625 | 42.5625 | 42.5625 | 42.5625 | 616.0 |
| 2018-12-12 04:18:00 | AAPL | Stock | 42.65 | 42.65 | 42.65 | 42.65 | 500.0 |
| 2018-12-12 04:44:00 | AAPL | Stock | 42.725 | 42.725 | 42.725 | 42.725 | 400.0 |
| 2018-12-12 04:45:00 | AAPL | Stock | 42.725 | 42.725 | 42.725 | 42.725 | 1200.0 |
| 2018-12-12 04:46:00 | AAPL | Stock | 42.725 | 42.725 | 42.725 | 42.725 | 1200.0 |
| 2018-12-12 04:48:00 | AAPL | Stock | 42.7025 | 42.7025 | 42.7 | 42.7 | 1200.0 |
| 2018-12-12 04:52:00 | AAPL | Stock | 42.6875 | 42.6875 | 42.6875 | 42.6875 | 5576.0 |
| 2018-12-12 04:53:00 | AAPL | Stock | 42.7 | 42.7 | 42.7 | 42.7 | 400.0 |
| 2018-12-12 04:58:00 | AAPL | Stock | 42.7 | 42.7 | 42.7 | 42.7 | 4000.0 |
| 2018-12-12 05:02:00 | AAPL | Stock | 42.7 | 42.7 | 42.7 | 42.7 | 2000.0 |
| 2018-12-12 05:15:00 | AAPL | Stock | 42.74 | 42.74 | 42.74 | 42.74 | 400.0 |
| 2018-12-12 05:25:00 | AAPL | Stock | 42.72 | 42.72 | 42.72 | 42.72 | 400.0 |
| 2018-12-12 05:29:00 | AAPL | Stock | 42.65 | 42.65 | 42.65 | 42.65 | 1200.0 |
| 2018-12-12 05:30:00 | AAPL | Stock | 42.65 | 42.65 | 42.65 | 42.65 | 604.0 |
| 2018-12-12 05:34:00 | AAPL | Stock | 42.65 | 42.65 | 42.65 | 42.65 | 1148.0 |
| 2018-12-12 05:35:00 | AAPL | Stock | 42.65 | 42.715 | 42.65 | 42.715 | 2296.0 |
| 2018-12-12 05:37:00 | AAPL | Stock | 42.715 | 42.715 | 42.715 | 42.715 | 1540.0 |
| 2018-12-12 05:38:00 | AAPL | Stock | 42.715 | 42.715 | 42.715 | 42.715 | 400.0 |
| 2018-12-12 05:40:00 | AAPL | Stock | 42.7 | 42.7 | 42.7 | 42.7 | 424.0 |
| 2018-12-12 05:41:00 | AAPL | Stock | 42.715 | 42.715 | 42.715 | 42.715 | 1300.0 |
| 2018-12-12 05:42:00 | AAPL | Stock | 42.715 | 42.715 | 42.715 | 42.715 | 2000.0 |
| 2018-12-12 05:45:00 | AAPL | Stock | 42.715 | 42.715 | 42.715 | 42.715 | 400.0 |
| 2018-12-12 05:53:00 | AAPL | Stock | 42.705 | 42.705 | 42.705 | 42.705 | 588.0 |
| 2018-12-12 06:08:00 | AAPL | Stock | 42.65 | 42.65 | 42.65 | 42.65 | 1000.0 |
| 2018-12-12 06:17:00 | AAPL | Stock | 42.625 | 42.625 | 42.625 | 42.625 | 1612.0 |
| 2018-12-12 06:18:00 | AAPL | Stock | 42.625 | 42.625 | 42.625 | 42.625 | 788.0 |
| 2018-12-12 06:25:00 | AAPL | Stock | 42.67 | 42.67 | 42.67 | 42.67 | 400.0 |
| 2018-12-12 06:34:00 | AAPL | Stock | 42.7 | 42.715 | 42.7 | 42.715 | 1600.0 |
| 2018-12-12 06:39:00 | AAPL | Stock | 42.5975 | 42.5975 | 42.515 | 42.515 | 8100.0 |
| 2018-12-12 06:41:00 | AAPL | Stock | 42.565 | 42.5875 | 42.565 | 42.565 | 2912.0 |
| 2018-12-12 06:42:00 | AAPL | Stock | 42.5625 | 42.5625 | 42.5625 | 42.5625 | 1600.0 |
| 2018-12-12 06:46:00 | AAPL | Stock | 42.5875 | 42.5875 | 42.5875 | 42.5875 | 800.0 |
| 2018-12-12 06:47:00 | AAPL | Stock | 42.5625 | 42.5625 | 42.5625 | 42.5625 | 400.0 |
| 2018-12-12 06:48:00 | AAPL | Stock | 42.5875 | 42.5875 | 42.5875 | 42.5875 | 4248.0 |
| 2018-12-12 06:49:00 | AAPL | Stock | 42.575 | 42.5875 | 42.575 | 42.5875 | 1600.0 |
| 2018-12-12 06:50:00 | AAPL | Stock | 42.5625 | 42.5875 | 42.5275 | 42.5875 | 5200.0 |
| 2018-12-12 06:51:00 | AAPL | Stock | 42.58 | 42.6425 | 42.58 | 42.6425 | 4800.0 |
| 2018-12-12 06:52:00 | AAPL | Stock | 42.625 | 42.625 | 42.625 | 42.625 | 400.0 |
| 2018-12-12 06:53:00 | AAPL | Stock | 42.675 | 42.675 | 42.665 | 42.665 | 1652.0 |
| 2018-12-12 06:54:00 | AAPL | Stock | 42.605 | 42.605 | 42.605 | 42.605 | 2000.0 |
| 2018-12-12 06:55:00 | AAPL | Stock | 42.605 | 42.605 | 42.5925 | 42.5925 | 12400.0 |
| 2018-12-12 06:57:00 | AAPL | Stock | 42.585 | 42.585 | 42.585 | 42.585 | 400.0 |
| 2018-12-12 06:58:00 | AAPL | Stock | 42.6075 | 42.6075 | 42.6075 | 42.6075 | 596.0 |
| 2018-12-12 07:00:00 | AAPL | Stock | 42.6 | 42.6 | 42.6 | 42.6 | 3064.0 |
| 2018-12-12 07:01:00 | AAPL | Stock | 42.575 | 42.575 | 42.5625 | 42.5625 | 6000.0 |
| 2018-12-12 07:02:00 | AAPL | Stock | 42.5625 | 42.5625 | 42.535 | 42.535 | 2000.0 |
| 2018-12-12 07:03:00 | AAPL | Stock | 42.545 | 42.545 | 42.525 | 42.525 | 804.0 |
| 2018-12-12 07:04:00 | AAPL | Stock | 42.505 | 42.525 | 42.505 | 42.5075 | 2640.0 |
| 2018-12-12 07:05:00 | AAPL | Stock | 42.525 | 42.535 | 42.525 | 42.535 | 6092.0 |
> showing 50 of 1,143,855 rows — these rows as CSV