PREVIEW / stock_1min / 2019-03-26
file: by_date/stock_1min/2019/2019-03-26.parquet size: 15.7 MB rows: 1,105,727 symbols: 2,225
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 |
|---|---|---|---|---|---|---|---|
| 2019-03-26 04:00:00 | AAPL | Stock | 47.445 | 47.4525 | 47.445 | 47.4525 | 6288.0 |
| 2019-03-26 04:03:00 | AAPL | Stock | 47.445 | 47.4625 | 47.445 | 47.4625 | 8000.0 |
| 2019-03-26 04:04:00 | AAPL | Stock | 47.44 | 47.44 | 47.44 | 47.44 | 400.0 |
| 2019-03-26 04:05:00 | AAPL | Stock | 47.38 | 47.38 | 47.38 | 47.38 | 400.0 |
| 2019-03-26 04:06:00 | AAPL | Stock | 47.3175 | 47.3175 | 47.3 | 47.3 | 10152.0 |
| 2019-03-26 04:07:00 | AAPL | Stock | 47.155 | 47.155 | 47.055 | 47.15 | 9912.0 |
| 2019-03-26 04:08:00 | AAPL | Stock | 47.245 | 47.2975 | 47.0 | 47.0 | 21644.0 |
| 2019-03-26 04:09:00 | AAPL | Stock | 47.125 | 47.125 | 47.125 | 47.125 | 484.0 |
| 2019-03-26 04:10:00 | AAPL | Stock | 47.125 | 47.13 | 47.125 | 47.13 | 11880.0 |
| 2019-03-26 04:12:00 | AAPL | Stock | 47.125 | 47.125 | 47.125 | 47.125 | 796.0 |
| 2019-03-26 04:15:00 | AAPL | Stock | 47.165 | 47.165 | 47.165 | 47.165 | 400.0 |
| 2019-03-26 04:18:00 | AAPL | Stock | 47.17 | 47.17 | 47.17 | 47.17 | 400.0 |
| 2019-03-26 04:19:00 | AAPL | Stock | 47.17 | 47.17 | 47.17 | 47.17 | 5972.0 |
| 2019-03-26 04:34:00 | AAPL | Stock | 47.1625 | 47.1625 | 47.1625 | 47.1625 | 600.0 |
| 2019-03-26 05:08:00 | AAPL | Stock | 47.25 | 47.25 | 47.25 | 47.25 | 800.0 |
| 2019-03-26 05:14:00 | AAPL | Stock | 47.2475 | 47.2475 | 47.2475 | 47.2475 | 9272.0 |
| 2019-03-26 05:32:00 | AAPL | Stock | 47.335 | 47.335 | 47.335 | 47.335 | 2000.0 |
| 2019-03-26 05:35:00 | AAPL | Stock | 47.335 | 47.35 | 47.335 | 47.35 | 3096.0 |
| 2019-03-26 05:37:00 | AAPL | Stock | 47.35 | 47.35 | 47.35 | 47.35 | 3636.0 |
| 2019-03-26 05:38:00 | AAPL | Stock | 47.375 | 47.375 | 47.375 | 47.375 | 768.0 |
| 2019-03-26 05:44:00 | AAPL | Stock | 47.38 | 47.38 | 47.375 | 47.375 | 2448.0 |
| 2019-03-26 06:02:00 | AAPL | Stock | 47.485 | 47.4875 | 47.485 | 47.4875 | 5968.0 |
| 2019-03-26 06:04:00 | AAPL | Stock | 47.3975 | 47.4875 | 47.3975 | 47.4875 | 3112.0 |
| 2019-03-26 06:21:00 | AAPL | Stock | 47.45 | 47.4875 | 47.45 | 47.4875 | 3200.0 |
| 2019-03-26 06:24:00 | AAPL | Stock | 47.45 | 47.45 | 47.45 | 47.45 | 400.0 |
| 2019-03-26 06:27:00 | AAPL | Stock | 47.44 | 47.44 | 47.425 | 47.44 | 1200.0 |
| 2019-03-26 06:28:00 | AAPL | Stock | 47.4625 | 47.4625 | 47.4625 | 47.4625 | 400.0 |
| 2019-03-26 06:31:00 | AAPL | Stock | 47.4925 | 47.5 | 47.4925 | 47.5 | 8800.0 |
| 2019-03-26 06:33:00 | AAPL | Stock | 47.525 | 47.525 | 47.525 | 47.525 | 400.0 |
| 2019-03-26 06:37:00 | AAPL | Stock | 47.505 | 47.5475 | 47.5025 | 47.5475 | 4400.0 |
| 2019-03-26 06:40:00 | AAPL | Stock | 47.56 | 47.56 | 47.56 | 47.56 | 400.0 |
| 2019-03-26 06:44:00 | AAPL | Stock | 47.52 | 47.52 | 47.5 | 47.5 | 7584.0 |
| 2019-03-26 06:45:00 | AAPL | Stock | 47.5 | 47.5025 | 47.5 | 47.5025 | 3752.0 |
| 2019-03-26 06:46:00 | AAPL | Stock | 47.5325 | 47.5325 | 47.5325 | 47.5325 | 4000.0 |
| 2019-03-26 06:51:00 | AAPL | Stock | 47.5 | 47.5 | 47.5 | 47.5 | 588.0 |
| 2019-03-26 06:54:00 | AAPL | Stock | 47.5625 | 47.5625 | 47.5625 | 47.5625 | 3600.0 |
| 2019-03-26 06:57:00 | AAPL | Stock | 47.57 | 47.58 | 47.57 | 47.575 | 8520.0 |
| 2019-03-26 06:58:00 | AAPL | Stock | 47.575 | 47.575 | 47.575 | 47.575 | 2400.0 |
| 2019-03-26 07:00:00 | AAPL | Stock | 47.5475 | 47.6 | 47.515 | 47.6 | 16400.0 |
| 2019-03-26 07:01:00 | AAPL | Stock | 47.625 | 47.6375 | 47.6075 | 47.6375 | 7400.0 |
| 2019-03-26 07:02:00 | AAPL | Stock | 47.675 | 47.6875 | 47.675 | 47.6825 | 21476.0 |
| 2019-03-26 07:03:00 | AAPL | Stock | 47.6925 | 47.6975 | 47.6825 | 47.6825 | 6440.0 |
| 2019-03-26 07:05:00 | AAPL | Stock | 47.695 | 47.695 | 47.68 | 47.68 | 4304.0 |
| 2019-03-26 07:06:00 | AAPL | Stock | 47.675 | 47.69 | 47.645 | 47.6775 | 19588.0 |
| 2019-03-26 07:07:00 | AAPL | Stock | 47.6925 | 47.74 | 47.69 | 47.74 | 27972.0 |
| 2019-03-26 07:08:00 | AAPL | Stock | 47.735 | 47.7425 | 47.735 | 47.7375 | 4360.0 |
| 2019-03-26 07:09:00 | AAPL | Stock | 47.7425 | 47.745 | 47.7125 | 47.7125 | 14616.0 |
| 2019-03-26 07:10:00 | AAPL | Stock | 47.735 | 47.7375 | 47.735 | 47.7375 | 800.0 |
| 2019-03-26 07:11:00 | AAPL | Stock | 47.715 | 47.78 | 47.715 | 47.78 | 34768.0 |
| 2019-03-26 07:12:00 | AAPL | Stock | 47.7875 | 47.7875 | 47.75 | 47.7875 | 15404.0 |
> showing 50 of 1,105,727 rows — these rows as CSV