PREVIEW / stock_1min / 2017-12-22
file: by_date/stock_1min/2017/2017-12-22.parquet size: 14.1 MB rows: 1,018,812 symbols: 2,408
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-22 04:00:00 | AAPL | Stock | 43.795 | 43.795 | 43.795 | 43.795 | 400.0 |
| 2017-12-22 04:02:00 | AAPL | Stock | 43.7 | 43.7 | 43.7 | 43.7 | 800.0 |
| 2017-12-22 06:21:00 | AAPL | Stock | 43.74 | 43.74 | 43.74 | 43.74 | 1736.0 |
| 2017-12-22 06:29:00 | AAPL | Stock | 43.74 | 43.74 | 43.74 | 43.74 | 1300.0 |
| 2017-12-22 06:35:00 | AAPL | Stock | 43.7425 | 43.7425 | 43.7425 | 43.7425 | 468.0 |
| 2017-12-22 06:42:00 | AAPL | Stock | 43.7425 | 43.7425 | 43.7225 | 43.7225 | 1132.0 |
| 2017-12-22 06:43:00 | AAPL | Stock | 43.7225 | 43.7225 | 43.7225 | 43.7225 | 1628.0 |
| 2017-12-22 06:51:00 | AAPL | Stock | 43.7225 | 43.7225 | 43.7225 | 43.7225 | 1200.0 |
| 2017-12-22 06:54:00 | AAPL | Stock | 43.7225 | 43.7225 | 43.7225 | 43.7225 | 628.0 |
| 2017-12-22 07:00:00 | AAPL | Stock | 43.73 | 43.74 | 43.73 | 43.74 | 2476.0 |
| 2017-12-22 07:02:00 | AAPL | Stock | 43.725 | 43.725 | 43.725 | 43.725 | 400.0 |
| 2017-12-22 07:05:00 | AAPL | Stock | 43.7375 | 43.74 | 43.7375 | 43.74 | 5240.0 |
| 2017-12-22 07:08:00 | AAPL | Stock | 43.7625 | 43.7625 | 43.7625 | 43.7625 | 800.0 |
| 2017-12-22 07:12:00 | AAPL | Stock | 43.7525 | 43.7525 | 43.7525 | 43.7525 | 800.0 |
| 2017-12-22 07:13:00 | AAPL | Stock | 43.7525 | 43.7525 | 43.7525 | 43.7525 | 800.0 |
| 2017-12-22 07:14:00 | AAPL | Stock | 43.75 | 43.75 | 43.75 | 43.75 | 2000.0 |
| 2017-12-22 07:16:00 | AAPL | Stock | 43.75 | 43.75 | 43.75 | 43.75 | 700.0 |
| 2017-12-22 07:17:00 | AAPL | Stock | 43.75 | 43.75 | 43.75 | 43.75 | 800.0 |
| 2017-12-22 07:29:00 | AAPL | Stock | 43.75 | 43.77 | 43.75 | 43.77 | 888.0 |
| 2017-12-22 07:32:00 | AAPL | Stock | 43.75 | 43.75 | 43.75 | 43.75 | 400.0 |
| 2017-12-22 07:34:00 | AAPL | Stock | 43.7525 | 43.7525 | 43.75 | 43.75 | 5592.0 |
| 2017-12-22 07:39:00 | AAPL | Stock | 43.745 | 43.745 | 43.7425 | 43.7425 | 5048.0 |
| 2017-12-22 07:41:00 | AAPL | Stock | 43.74 | 43.74 | 43.74 | 43.74 | 10000.0 |
| 2017-12-22 07:43:00 | AAPL | Stock | 43.74 | 43.74 | 43.74 | 43.74 | 4132.0 |
| 2017-12-22 07:51:00 | AAPL | Stock | 43.74 | 43.74 | 43.74 | 43.74 | 800.0 |
| 2017-12-22 07:57:00 | AAPL | Stock | 43.72 | 43.72 | 43.72 | 43.72 | 1712.0 |
| 2017-12-22 08:00:00 | AAPL | Stock | 43.73 | 43.7725 | 43.6675 | 43.74 | 15976.0 |
| 2017-12-22 08:01:00 | AAPL | Stock | 43.7375 | 43.7375 | 43.7375 | 43.7375 | 800.0 |
| 2017-12-22 08:03:00 | AAPL | Stock | 43.7 | 43.725 | 43.69 | 43.69 | 8592.0 |
| 2017-12-22 08:04:00 | AAPL | Stock | 43.6925 | 43.695 | 43.6925 | 43.695 | 2596.0 |
| 2017-12-22 08:06:00 | AAPL | Stock | 43.7025 | 43.7025 | 43.7025 | 43.7025 | 2200.0 |
| 2017-12-22 08:08:00 | AAPL | Stock | 43.7025 | 43.7025 | 43.7025 | 43.7025 | 1780.0 |
| 2017-12-22 08:10:00 | AAPL | Stock | 43.7125 | 43.7125 | 43.7075 | 43.7075 | 23792.0 |
| 2017-12-22 08:11:00 | AAPL | Stock | 43.7075 | 43.7075 | 43.7075 | 43.7075 | 548.0 |
| 2017-12-22 08:12:00 | AAPL | Stock | 43.7025 | 43.7025 | 43.695 | 43.695 | 7524.0 |
| 2017-12-22 08:13:00 | AAPL | Stock | 43.7 | 43.7 | 43.7 | 43.7 | 1800.0 |
| 2017-12-22 08:14:00 | AAPL | Stock | 43.695 | 43.695 | 43.69 | 43.695 | 4444.0 |
| 2017-12-22 08:15:00 | AAPL | Stock | 43.695 | 43.695 | 43.695 | 43.695 | 400.0 |
| 2017-12-22 08:17:00 | AAPL | Stock | 43.6825 | 43.6825 | 43.6775 | 43.6775 | 1760.0 |
| 2017-12-22 08:18:00 | AAPL | Stock | 43.675 | 43.675 | 43.675 | 43.675 | 1728.0 |
| 2017-12-22 08:20:00 | AAPL | Stock | 43.675 | 43.675 | 43.675 | 43.675 | 2000.0 |
| 2017-12-22 08:22:00 | AAPL | Stock | 43.675 | 43.675 | 43.675 | 43.675 | 1040.0 |
| 2017-12-22 08:23:00 | AAPL | Stock | 43.675 | 43.675 | 43.675 | 43.675 | 400.0 |
| 2017-12-22 08:24:00 | AAPL | Stock | 43.665 | 43.665 | 43.665 | 43.665 | 520.0 |
| 2017-12-22 08:25:00 | AAPL | Stock | 43.665 | 43.665 | 43.665 | 43.665 | 876.0 |
| 2017-12-22 08:26:00 | AAPL | Stock | 43.675 | 43.675 | 43.675 | 43.675 | 2000.0 |
| 2017-12-22 08:27:00 | AAPL | Stock | 43.675 | 43.675 | 43.675 | 43.675 | 1000.0 |
| 2017-12-22 08:28:00 | AAPL | Stock | 43.6625 | 43.675 | 43.6625 | 43.675 | 2080.0 |
| 2017-12-22 08:30:00 | AAPL | Stock | 43.68 | 43.6875 | 43.68 | 43.68 | 6800.0 |
| 2017-12-22 08:31:00 | AAPL | Stock | 43.68 | 43.68 | 43.6625 | 43.6675 | 6436.0 |
> showing 50 of 1,018,812 rows — these rows as CSV