PREVIEW / stock_1min / 2018-08-20
file: by_date/stock_1min/2018/2018-08-20.parquet size: 14.0 MB rows: 1,001,471 symbols: 2,330
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-08-20 04:00:00 | AAPL | Stock | 54.5625 | 54.8375 | 54.5625 | 54.8375 | 8292.0 |
| 2018-08-20 04:01:00 | AAPL | Stock | 54.825 | 54.835 | 54.825 | 54.835 | 800.0 |
| 2018-08-20 04:02:00 | AAPL | Stock | 54.75 | 54.75 | 54.75 | 54.75 | 400.0 |
| 2018-08-20 04:05:00 | AAPL | Stock | 54.8 | 54.8 | 54.8 | 54.8 | 1516.0 |
| 2018-08-20 04:07:00 | AAPL | Stock | 54.7875 | 54.8 | 54.7875 | 54.8 | 800.0 |
| 2018-08-20 04:12:00 | AAPL | Stock | 54.75 | 54.75 | 54.75 | 54.75 | 1600.0 |
| 2018-08-20 04:17:00 | AAPL | Stock | 54.695 | 54.71 | 54.695 | 54.71 | 4360.0 |
| 2018-08-20 04:18:00 | AAPL | Stock | 54.695 | 54.7275 | 54.695 | 54.7275 | 800.0 |
| 2018-08-20 04:22:00 | AAPL | Stock | 54.75 | 54.75 | 54.75 | 54.75 | 2000.0 |
| 2018-08-20 04:28:00 | AAPL | Stock | 54.695 | 54.695 | 54.695 | 54.695 | 400.0 |
| 2018-08-20 04:33:00 | AAPL | Stock | 54.7375 | 54.7375 | 54.7375 | 54.7375 | 3920.0 |
| 2018-08-20 04:34:00 | AAPL | Stock | 54.7375 | 54.7375 | 54.7375 | 54.7375 | 400.0 |
| 2018-08-20 04:35:00 | AAPL | Stock | 54.7375 | 54.7375 | 54.7375 | 54.7375 | 400.0 |
| 2018-08-20 04:39:00 | AAPL | Stock | 54.725 | 54.725 | 54.725 | 54.725 | 2000.0 |
| 2018-08-20 04:44:00 | AAPL | Stock | 54.785 | 54.785 | 54.75 | 54.75 | 6404.0 |
| 2018-08-20 04:46:00 | AAPL | Stock | 54.785 | 54.785 | 54.785 | 54.785 | 628.0 |
| 2018-08-20 04:48:00 | AAPL | Stock | 54.7575 | 54.7575 | 54.7575 | 54.7575 | 400.0 |
| 2018-08-20 04:52:00 | AAPL | Stock | 54.8125 | 54.8125 | 54.7975 | 54.8025 | 2000.0 |
| 2018-08-20 04:54:00 | AAPL | Stock | 54.825 | 54.825 | 54.825 | 54.825 | 1200.0 |
| 2018-08-20 05:04:00 | AAPL | Stock | 54.81 | 54.81 | 54.795 | 54.795 | 10324.0 |
| 2018-08-20 05:05:00 | AAPL | Stock | 54.8 | 54.8 | 54.8 | 54.8 | 792.0 |
| 2018-08-20 05:08:00 | AAPL | Stock | 54.7975 | 54.7975 | 54.795 | 54.795 | 6796.0 |
| 2018-08-20 05:13:00 | AAPL | Stock | 54.7775 | 54.7775 | 54.7775 | 54.7775 | 420.0 |
| 2018-08-20 05:19:00 | AAPL | Stock | 54.7775 | 54.7775 | 54.7775 | 54.7775 | 400.0 |
| 2018-08-20 05:20:00 | AAPL | Stock | 54.7725 | 54.7725 | 54.7575 | 54.7575 | 6800.0 |
| 2018-08-20 05:21:00 | AAPL | Stock | 54.7575 | 54.7575 | 54.75 | 54.75 | 8636.0 |
| 2018-08-20 05:22:00 | AAPL | Stock | 54.75 | 54.75 | 54.75 | 54.75 | 416.0 |
| 2018-08-20 05:23:00 | AAPL | Stock | 54.75 | 54.75 | 54.725 | 54.725 | 4620.0 |
| 2018-08-20 05:24:00 | AAPL | Stock | 54.725 | 54.7275 | 54.725 | 54.725 | 12916.0 |
| 2018-08-20 05:34:00 | AAPL | Stock | 54.7675 | 54.775 | 54.7675 | 54.775 | 2704.0 |
| 2018-08-20 05:37:00 | AAPL | Stock | 54.775 | 54.775 | 54.775 | 54.775 | 400.0 |
| 2018-08-20 05:49:00 | AAPL | Stock | 54.75 | 54.75 | 54.7275 | 54.7275 | 1648.0 |
| 2018-08-20 05:51:00 | AAPL | Stock | 54.745 | 54.745 | 54.745 | 54.745 | 796.0 |
| 2018-08-20 05:53:00 | AAPL | Stock | 54.745 | 54.745 | 54.745 | 54.745 | 660.0 |
| 2018-08-20 05:54:00 | AAPL | Stock | 54.7625 | 54.7625 | 54.7375 | 54.7625 | 3340.0 |
| 2018-08-20 05:55:00 | AAPL | Stock | 54.7625 | 54.7625 | 54.7625 | 54.7625 | 400.0 |
| 2018-08-20 05:58:00 | AAPL | Stock | 54.7625 | 54.7625 | 54.7625 | 54.7625 | 1000.0 |
| 2018-08-20 06:04:00 | AAPL | Stock | 54.75 | 54.75 | 54.7375 | 54.7375 | 800.0 |
| 2018-08-20 06:05:00 | AAPL | Stock | 54.7375 | 54.7375 | 54.7375 | 54.7375 | 400.0 |
| 2018-08-20 06:07:00 | AAPL | Stock | 54.7375 | 54.7375 | 54.7225 | 54.7225 | 7448.0 |
| 2018-08-20 06:08:00 | AAPL | Stock | 54.7025 | 54.7025 | 54.695 | 54.695 | 7252.0 |
| 2018-08-20 06:10:00 | AAPL | Stock | 54.68 | 54.68 | 54.68 | 54.68 | 800.0 |
| 2018-08-20 06:11:00 | AAPL | Stock | 54.705 | 54.705 | 54.705 | 54.705 | 400.0 |
| 2018-08-20 06:13:00 | AAPL | Stock | 54.6775 | 54.6775 | 54.675 | 54.675 | 1960.0 |
| 2018-08-20 06:14:00 | AAPL | Stock | 54.675 | 54.675 | 54.675 | 54.675 | 9044.0 |
| 2018-08-20 06:16:00 | AAPL | Stock | 54.6525 | 54.6525 | 54.6525 | 54.6525 | 3800.0 |
| 2018-08-20 06:17:00 | AAPL | Stock | 54.65 | 54.65 | 54.65 | 54.65 | 800.0 |
| 2018-08-20 06:19:00 | AAPL | Stock | 54.6725 | 54.675 | 54.65 | 54.6525 | 18436.0 |
| 2018-08-20 06:22:00 | AAPL | Stock | 54.685 | 54.685 | 54.685 | 54.685 | 400.0 |
| 2018-08-20 06:26:00 | AAPL | Stock | 54.655 | 54.655 | 54.65 | 54.65 | 1680.0 |
> showing 50 of 1,001,471 rows — these rows as CSV