PREVIEW / stock_5min / 2019-11-26
file: by_date/stock_5min/2019/2019-11-26.parquet size: 5.8 MB rows: 366,464 symbols: 2,500
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-11-26 04:20:00 | AAPL | Stock | 66.5125 | 66.5125 | 66.5125 | 66.5125 | 400.0 |
| 2019-11-26 04:25:00 | AAPL | Stock | 66.5125 | 66.5125 | 66.5125 | 66.5125 | 400.0 |
| 2019-11-26 04:35:00 | AAPL | Stock | 66.5425 | 66.5425 | 66.5425 | 66.5425 | 2000.0 |
| 2019-11-26 04:45:00 | AAPL | Stock | 66.5 | 66.5 | 66.5 | 66.5 | 424.0 |
| 2019-11-26 04:50:00 | AAPL | Stock | 66.55 | 66.55 | 66.55 | 66.55 | 1024.0 |
| 2019-11-26 05:05:00 | AAPL | Stock | 66.565 | 66.565 | 66.5375 | 66.5375 | 5600.0 |
| 2019-11-26 05:10:00 | AAPL | Stock | 66.55 | 66.55 | 66.5375 | 66.5375 | 1696.0 |
| 2019-11-26 05:25:00 | AAPL | Stock | 66.55 | 66.55 | 66.55 | 66.55 | 844.0 |
| 2019-11-26 05:30:00 | AAPL | Stock | 66.55 | 66.55 | 66.55 | 66.55 | 400.0 |
| 2019-11-26 06:25:00 | AAPL | Stock | 66.565 | 66.565 | 66.565 | 66.565 | 2000.0 |
| 2019-11-26 06:35:00 | AAPL | Stock | 66.6 | 66.625 | 66.5975 | 66.6125 | 3008.0 |
| 2019-11-26 06:40:00 | AAPL | Stock | 66.6225 | 66.625 | 66.6225 | 66.625 | 1200.0 |
| 2019-11-26 06:45:00 | AAPL | Stock | 66.625 | 66.625 | 66.625 | 66.625 | 1992.0 |
| 2019-11-26 06:50:00 | AAPL | Stock | 66.615 | 66.625 | 66.6125 | 66.6125 | 8472.0 |
| 2019-11-26 06:55:00 | AAPL | Stock | 66.625 | 66.65 | 66.615 | 66.615 | 8884.0 |
| 2019-11-26 07:00:00 | AAPL | Stock | 66.625 | 66.6725 | 66.62 | 66.625 | 22528.0 |
| 2019-11-26 07:05:00 | AAPL | Stock | 66.6125 | 66.625 | 66.6125 | 66.625 | 17508.0 |
| 2019-11-26 07:10:00 | AAPL | Stock | 66.675 | 66.675 | 66.675 | 66.675 | 3620.0 |
| 2019-11-26 07:15:00 | AAPL | Stock | 66.65 | 66.6525 | 66.65 | 66.6525 | 1600.0 |
| 2019-11-26 07:20:00 | AAPL | Stock | 66.6775 | 66.69 | 66.67 | 66.69 | 12756.0 |
| 2019-11-26 07:25:00 | AAPL | Stock | 66.6925 | 66.6925 | 66.69 | 66.69 | 17192.0 |
| 2019-11-26 07:30:00 | AAPL | Stock | 66.7125 | 66.7225 | 66.7125 | 66.7225 | 13276.0 |
| 2019-11-26 07:35:00 | AAPL | Stock | 66.7225 | 66.73 | 66.7 | 66.7125 | 15828.0 |
| 2019-11-26 07:40:00 | AAPL | Stock | 66.7 | 66.7075 | 66.7 | 66.7075 | 2400.0 |
| 2019-11-26 07:45:00 | AAPL | Stock | 66.7075 | 66.7075 | 66.69 | 66.69 | 7844.0 |
| 2019-11-26 07:50:00 | AAPL | Stock | 66.6875 | 66.7 | 66.6525 | 66.7 | 13480.0 |
| 2019-11-26 07:55:00 | AAPL | Stock | 66.7 | 66.7 | 66.6875 | 66.6875 | 9900.0 |
| 2019-11-26 08:00:00 | AAPL | Stock | 66.6875 | 66.7225 | 66.6 | 66.7125 | 67564.0 |
| 2019-11-26 08:05:00 | AAPL | Stock | 66.71 | 66.7125 | 66.71 | 66.7125 | 17552.0 |
| 2019-11-26 08:10:00 | AAPL | Stock | 66.71 | 66.75 | 66.71 | 66.75 | 47392.0 |
| 2019-11-26 08:15:00 | AAPL | Stock | 66.7675 | 66.7725 | 66.75 | 66.76 | 11124.0 |
| 2019-11-26 08:20:00 | AAPL | Stock | 66.77 | 66.77 | 66.6475 | 66.6525 | 30132.0 |
| 2019-11-26 08:25:00 | AAPL | Stock | 66.685 | 66.685 | 66.675 | 66.675 | 6116.0 |
| 2019-11-26 08:30:00 | AAPL | Stock | 66.6625 | 66.725 | 66.6625 | 66.7125 | 42484.0 |
| 2019-11-26 08:35:00 | AAPL | Stock | 66.725 | 66.7625 | 66.7 | 66.7 | 65256.0 |
| 2019-11-26 08:40:00 | AAPL | Stock | 66.7025 | 66.7125 | 66.7025 | 66.7025 | 3600.0 |
| 2019-11-26 08:45:00 | AAPL | Stock | 66.7 | 66.725 | 66.7 | 66.7025 | 12252.0 |
| 2019-11-26 08:50:00 | AAPL | Stock | 66.72 | 66.72 | 66.6875 | 66.705 | 10452.0 |
| 2019-11-26 08:55:00 | AAPL | Stock | 66.715 | 66.715 | 66.7 | 66.7025 | 28676.0 |
| 2019-11-26 09:00:00 | AAPL | Stock | 66.7025 | 66.7025 | 66.6375 | 66.65 | 21820.0 |
| 2019-11-26 09:05:00 | AAPL | Stock | 66.67 | 66.695 | 66.65 | 66.68 | 43960.0 |
| 2019-11-26 09:10:00 | AAPL | Stock | 66.705 | 66.7225 | 66.705 | 66.715 | 3192.0 |
| 2019-11-26 09:15:00 | AAPL | Stock | 66.7125 | 66.7125 | 66.705 | 66.705 | 800.0 |
| 2019-11-26 09:20:00 | AAPL | Stock | 66.715 | 66.7225 | 66.7 | 66.7225 | 26560.0 |
| 2019-11-26 09:25:00 | AAPL | Stock | 66.7225 | 66.75 | 66.7175 | 66.7325 | 36884.0 |
| 2019-11-26 09:30:00 | AAPL | Stock | 66.7325 | 66.79 | 66.4375 | 66.4675 | 3184728.0 |
| 2019-11-26 09:35:00 | AAPL | Stock | 66.4625 | 66.54 | 66.37 | 66.3778 | 1188428.0 |
| 2019-11-26 09:40:00 | AAPL | Stock | 66.3775 | 66.5275 | 66.3085 | 66.5125 | 1674664.0 |
| 2019-11-26 09:45:00 | AAPL | Stock | 66.5125 | 66.561 | 66.4075 | 66.435 | 1422344.0 |
| 2019-11-26 09:50:00 | AAPL | Stock | 66.4375 | 66.52 | 66.38 | 66.485 | 962564.0 |
> showing 50 of 366,464 rows — these rows as CSV