PREVIEW / stock_5min / 2018-12-19
file: by_date/stock_5min/2018/2018-12-19.parquet size: 5.9 MB rows: 376,604 symbols: 2,728
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-19 04:15:00 | AAPL | Stock | 41.6075 | 41.6075 | 41.6075 | 41.6075 | 400.0 |
| 2018-12-19 04:55:00 | AAPL | Stock | 41.575 | 41.575 | 41.575 | 41.575 | 5692.0 |
| 2018-12-19 05:00:00 | AAPL | Stock | 41.5925 | 41.5925 | 41.5925 | 41.5925 | 400.0 |
| 2018-12-19 05:05:00 | AAPL | Stock | 41.6375 | 41.6375 | 41.6375 | 41.6375 | 604.0 |
| 2018-12-19 05:15:00 | AAPL | Stock | 41.7425 | 41.7425 | 41.7425 | 41.7425 | 1012.0 |
| 2018-12-19 05:20:00 | AAPL | Stock | 41.7025 | 41.7025 | 41.7025 | 41.7025 | 800.0 |
| 2018-12-19 05:45:00 | AAPL | Stock | 41.665 | 41.665 | 41.665 | 41.665 | 400.0 |
| 2018-12-19 06:20:00 | AAPL | Stock | 41.675 | 41.6875 | 41.675 | 41.6875 | 980.0 |
| 2018-12-19 06:25:00 | AAPL | Stock | 41.7 | 41.7 | 41.7 | 41.7 | 536.0 |
| 2018-12-19 06:35:00 | AAPL | Stock | 41.675 | 41.675 | 41.675 | 41.675 | 1600.0 |
| 2018-12-19 07:00:00 | AAPL | Stock | 41.63 | 41.675 | 41.615 | 41.6525 | 8792.0 |
| 2018-12-19 07:05:00 | AAPL | Stock | 41.6825 | 41.7 | 41.68 | 41.6875 | 7120.0 |
| 2018-12-19 07:10:00 | AAPL | Stock | 41.7 | 41.7175 | 41.7 | 41.7175 | 2936.0 |
| 2018-12-19 07:15:00 | AAPL | Stock | 41.71 | 41.71 | 41.675 | 41.675 | 5148.0 |
| 2018-12-19 07:20:00 | AAPL | Stock | 41.6875 | 41.6875 | 41.675 | 41.675 | 1600.0 |
| 2018-12-19 07:25:00 | AAPL | Stock | 41.6825 | 41.6875 | 41.67 | 41.67 | 2400.0 |
| 2018-12-19 07:30:00 | AAPL | Stock | 41.675 | 41.675 | 41.675 | 41.675 | 600.0 |
| 2018-12-19 07:40:00 | AAPL | Stock | 41.6775 | 41.6775 | 41.645 | 41.645 | 9292.0 |
| 2018-12-19 07:45:00 | AAPL | Stock | 41.68 | 41.68 | 41.68 | 41.68 | 1000.0 |
| 2018-12-19 07:50:00 | AAPL | Stock | 41.6725 | 41.675 | 41.6675 | 41.675 | 7992.0 |
| 2018-12-19 07:55:00 | AAPL | Stock | 41.6625 | 41.6725 | 41.6625 | 41.6725 | 2800.0 |
| 2018-12-19 08:00:00 | AAPL | Stock | 41.67 | 41.73 | 41.5875 | 41.5925 | 167068.0 |
| 2018-12-19 08:05:00 | AAPL | Stock | 41.5975 | 41.6 | 41.55 | 41.55 | 33120.0 |
| 2018-12-19 08:10:00 | AAPL | Stock | 41.5575 | 41.5725 | 41.5475 | 41.5725 | 13520.0 |
| 2018-12-19 08:15:00 | AAPL | Stock | 41.575 | 41.58 | 41.55 | 41.5625 | 18172.0 |
| 2018-12-19 08:20:00 | AAPL | Stock | 41.5625 | 41.575 | 41.5625 | 41.5625 | 7696.0 |
| 2018-12-19 08:25:00 | AAPL | Stock | 41.575 | 41.5875 | 41.5625 | 41.5625 | 7336.0 |
| 2018-12-19 08:30:00 | AAPL | Stock | 41.565 | 41.6 | 41.5075 | 41.6 | 33876.0 |
| 2018-12-19 08:35:00 | AAPL | Stock | 41.5918 | 41.6 | 41.5825 | 41.5825 | 5000.0 |
| 2018-12-19 08:40:00 | AAPL | Stock | 41.5775 | 41.595 | 41.525 | 41.595 | 6000.0 |
| 2018-12-19 08:45:00 | AAPL | Stock | 41.5825 | 41.62 | 41.5825 | 41.5825 | 6420.0 |
| 2018-12-19 08:50:00 | AAPL | Stock | 41.5875 | 41.5875 | 41.55 | 41.55 | 24400.0 |
| 2018-12-19 08:55:00 | AAPL | Stock | 41.5625 | 41.62 | 41.56 | 41.5825 | 17536.0 |
| 2018-12-19 09:00:00 | AAPL | Stock | 41.5825 | 41.5825 | 41.465 | 41.525 | 41260.0 |
| 2018-12-19 09:05:00 | AAPL | Stock | 41.5425 | 41.55 | 41.52 | 41.525 | 19084.0 |
| 2018-12-19 09:10:00 | AAPL | Stock | 41.5175 | 41.5625 | 41.515 | 41.53 | 12000.0 |
| 2018-12-19 09:15:00 | AAPL | Stock | 41.5375 | 41.575 | 41.53 | 41.535 | 14744.0 |
| 2018-12-19 09:20:00 | AAPL | Stock | 41.555 | 41.5715 | 41.5275 | 41.5275 | 4200.0 |
| 2018-12-19 09:25:00 | AAPL | Stock | 41.5375 | 41.55 | 41.5 | 41.5 | 13100.0 |
| 2018-12-19 09:30:00 | AAPL | Stock | 41.5 | 41.5 | 41.26 | 41.355 | 3686364.0 |
| 2018-12-19 09:35:00 | AAPL | Stock | 41.3475 | 41.4175 | 41.24 | 41.3225 | 2219292.0 |
| 2018-12-19 09:40:00 | AAPL | Stock | 41.3275 | 41.494 | 41.3222 | 41.4825 | 1886272.0 |
| 2018-12-19 09:45:00 | AAPL | Stock | 41.48 | 41.575 | 41.4525 | 41.515 | 1368192.0 |
| 2018-12-19 09:50:00 | AAPL | Stock | 41.5118 | 41.67 | 41.4525 | 41.65 | 1760984.0 |
| 2018-12-19 09:55:00 | AAPL | Stock | 41.655 | 41.7875 | 41.615 | 41.6875 | 2083456.0 |
| 2018-12-19 10:00:00 | AAPL | Stock | 41.6875 | 41.7975 | 41.68 | 41.7765 | 1685292.0 |
| 2018-12-19 10:05:00 | AAPL | Stock | 41.775 | 41.7775 | 41.695 | 41.724 | 1414164.0 |
| 2018-12-19 10:10:00 | AAPL | Stock | 41.7275 | 41.7975 | 41.67 | 41.7575 | 1568600.0 |
| 2018-12-19 10:15:00 | AAPL | Stock | 41.76 | 41.8625 | 41.7475 | 41.7775 | 2047340.0 |
| 2018-12-19 10:20:00 | AAPL | Stock | 41.775 | 41.795 | 41.6025 | 41.6475 | 1469616.0 |
> showing 50 of 376,604 rows — these rows as CSV