PREVIEW / stock_5min / 2019-06-04
file: by_date/stock_5min/2019/2019-06-04.parquet size: 5.7 MB rows: 363,556 symbols: 2,601
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-06-04 04:00:00 | AAPL | Stock | 43.575 | 43.575 | 43.54 | 43.54 | 6000.0 |
| 2019-06-04 04:05:00 | AAPL | Stock | 43.54 | 43.5425 | 43.525 | 43.5425 | 5424.0 |
| 2019-06-04 04:10:00 | AAPL | Stock | 43.585 | 43.6 | 43.585 | 43.6 | 1200.0 |
| 2019-06-04 04:15:00 | AAPL | Stock | 43.5675 | 43.5675 | 43.5675 | 43.5675 | 696.0 |
| 2019-06-04 04:20:00 | AAPL | Stock | 43.5675 | 43.5675 | 43.5675 | 43.5675 | 3092.0 |
| 2019-06-04 04:25:00 | AAPL | Stock | 43.565 | 43.565 | 43.5325 | 43.5325 | 1956.0 |
| 2019-06-04 04:35:00 | AAPL | Stock | 43.6 | 43.6 | 43.56 | 43.56 | 1800.0 |
| 2019-06-04 04:40:00 | AAPL | Stock | 43.585 | 43.585 | 43.585 | 43.585 | 23908.0 |
| 2019-06-04 04:55:00 | AAPL | Stock | 43.68 | 43.6875 | 43.675 | 43.675 | 4276.0 |
| 2019-06-04 05:00:00 | AAPL | Stock | 43.7425 | 43.7425 | 43.675 | 43.675 | 2000.0 |
| 2019-06-04 05:10:00 | AAPL | Stock | 43.61 | 43.665 | 43.61 | 43.665 | 5592.0 |
| 2019-06-04 05:15:00 | AAPL | Stock | 43.6625 | 43.6625 | 43.6425 | 43.6425 | 10456.0 |
| 2019-06-04 05:20:00 | AAPL | Stock | 43.675 | 43.6825 | 43.675 | 43.6825 | 1200.0 |
| 2019-06-04 05:30:00 | AAPL | Stock | 43.6 | 43.625 | 43.6 | 43.625 | 6596.0 |
| 2019-06-04 05:35:00 | AAPL | Stock | 43.6225 | 43.625 | 43.6225 | 43.625 | 6840.0 |
| 2019-06-04 05:40:00 | AAPL | Stock | 43.625 | 43.6975 | 43.625 | 43.6975 | 6740.0 |
| 2019-06-04 05:45:00 | AAPL | Stock | 43.6875 | 43.6875 | 43.6875 | 43.6875 | 400.0 |
| 2019-06-04 06:00:00 | AAPL | Stock | 43.7125 | 43.7125 | 43.7025 | 43.71 | 8092.0 |
| 2019-06-04 06:10:00 | AAPL | Stock | 43.7125 | 43.745 | 43.7125 | 43.745 | 11908.0 |
| 2019-06-04 06:30:00 | AAPL | Stock | 43.7125 | 43.7125 | 43.7125 | 43.7125 | 400.0 |
| 2019-06-04 06:50:00 | AAPL | Stock | 43.625 | 43.625 | 43.605 | 43.6125 | 4600.0 |
| 2019-06-04 06:55:00 | AAPL | Stock | 43.625 | 43.625 | 43.5925 | 43.5925 | 800.0 |
| 2019-06-04 07:00:00 | AAPL | Stock | 43.625 | 43.69 | 43.5325 | 43.5325 | 29876.0 |
| 2019-06-04 07:05:00 | AAPL | Stock | 43.5325 | 43.5325 | 43.49 | 43.5 | 86672.0 |
| 2019-06-04 07:10:00 | AAPL | Stock | 43.485 | 43.525 | 43.485 | 43.5125 | 9084.0 |
| 2019-06-04 07:15:00 | AAPL | Stock | 43.505 | 43.505 | 43.45 | 43.45 | 28400.0 |
| 2019-06-04 07:20:00 | AAPL | Stock | 43.4925 | 43.4925 | 43.45 | 43.485 | 6796.0 |
| 2019-06-04 07:25:00 | AAPL | Stock | 43.485 | 43.5025 | 43.475 | 43.5025 | 11092.0 |
| 2019-06-04 07:30:00 | AAPL | Stock | 43.5025 | 43.5025 | 43.475 | 43.5 | 8752.0 |
| 2019-06-04 07:35:00 | AAPL | Stock | 43.4875 | 43.51 | 43.485 | 43.51 | 16776.0 |
| 2019-06-04 07:40:00 | AAPL | Stock | 43.51 | 43.5625 | 43.51 | 43.5625 | 8792.0 |
| 2019-06-04 07:45:00 | AAPL | Stock | 43.5625 | 43.8 | 43.5575 | 43.6775 | 74892.0 |
| 2019-06-04 07:50:00 | AAPL | Stock | 43.7325 | 43.7325 | 43.68 | 43.685 | 9100.0 |
| 2019-06-04 07:55:00 | AAPL | Stock | 43.6875 | 43.6875 | 43.635 | 43.675 | 24428.0 |
| 2019-06-04 08:00:00 | AAPL | Stock | 43.6125 | 43.7875 | 43.45 | 43.69 | 91788.0 |
| 2019-06-04 08:05:00 | AAPL | Stock | 43.66 | 43.675 | 43.625 | 43.6475 | 26376.0 |
| 2019-06-04 08:10:00 | AAPL | Stock | 43.63 | 43.67 | 43.625 | 43.67 | 13920.0 |
| 2019-06-04 08:15:00 | AAPL | Stock | 43.6725 | 43.8 | 43.665 | 43.7625 | 117812.0 |
| 2019-06-04 08:20:00 | AAPL | Stock | 43.775 | 43.85 | 43.7575 | 43.84 | 81096.0 |
| 2019-06-04 08:25:00 | AAPL | Stock | 43.8375 | 43.8725 | 43.79 | 43.8125 | 56980.0 |
| 2019-06-04 08:30:00 | AAPL | Stock | 43.8225 | 43.825 | 43.7775 | 43.795 | 14080.0 |
| 2019-06-04 08:35:00 | AAPL | Stock | 43.795 | 43.825 | 43.7875 | 43.82 | 18700.0 |
| 2019-06-04 08:40:00 | AAPL | Stock | 43.78 | 43.8175 | 43.78 | 43.8175 | 19548.0 |
| 2019-06-04 08:45:00 | AAPL | Stock | 43.83 | 43.8325 | 43.75 | 43.775 | 77612.0 |
| 2019-06-04 08:50:00 | AAPL | Stock | 43.775 | 43.8425 | 43.775 | 43.8 | 37104.0 |
| 2019-06-04 08:55:00 | AAPL | Stock | 43.8 | 43.8425 | 43.8 | 43.8025 | 88256.0 |
| 2019-06-04 09:00:00 | AAPL | Stock | 43.805 | 43.8678 | 43.8 | 43.8275 | 40596.0 |
| 2019-06-04 09:05:00 | AAPL | Stock | 43.845 | 43.8875 | 43.8275 | 43.88 | 23880.0 |
| 2019-06-04 09:10:00 | AAPL | Stock | 43.88 | 43.9475 | 43.875 | 43.875 | 47588.0 |
| 2019-06-04 09:15:00 | AAPL | Stock | 43.8525 | 43.9 | 43.8525 | 43.8675 | 33280.0 |
> showing 50 of 363,556 rows — these rows as CSV