PREVIEW / stock_5min / 2019-09-19
file: by_date/stock_5min/2019/2019-09-19.parquet size: 5.7 MB rows: 363,776 symbols: 2,553
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-09-19 04:00:00 | AAPL | Stock | 55.54 | 55.5875 | 55.54 | 55.5875 | 1000.0 |
| 2019-09-19 04:10:00 | AAPL | Stock | 55.5025 | 55.5025 | 55.5025 | 55.5025 | 400.0 |
| 2019-09-19 04:15:00 | AAPL | Stock | 55.5275 | 55.5275 | 55.5 | 55.5 | 4424.0 |
| 2019-09-19 04:20:00 | AAPL | Stock | 55.5275 | 55.5425 | 55.5275 | 55.5425 | 2400.0 |
| 2019-09-19 04:25:00 | AAPL | Stock | 55.5475 | 55.55 | 55.5475 | 55.55 | 8464.0 |
| 2019-09-19 04:35:00 | AAPL | Stock | 55.5475 | 55.55 | 55.5475 | 55.55 | 2000.0 |
| 2019-09-19 04:40:00 | AAPL | Stock | 55.55 | 55.5975 | 55.55 | 55.5975 | 1600.0 |
| 2019-09-19 04:50:00 | AAPL | Stock | 55.595 | 55.6075 | 55.5275 | 55.5275 | 4116.0 |
| 2019-09-19 05:40:00 | AAPL | Stock | 55.55 | 55.55 | 55.55 | 55.55 | 756.0 |
| 2019-09-19 06:05:00 | AAPL | Stock | 55.525 | 55.525 | 55.525 | 55.525 | 2000.0 |
| 2019-09-19 06:10:00 | AAPL | Stock | 55.48 | 55.48 | 55.48 | 55.48 | 400.0 |
| 2019-09-19 06:15:00 | AAPL | Stock | 55.48 | 55.48 | 55.48 | 55.48 | 2800.0 |
| 2019-09-19 06:20:00 | AAPL | Stock | 55.5225 | 55.5225 | 55.5225 | 55.5225 | 400.0 |
| 2019-09-19 06:35:00 | AAPL | Stock | 55.4375 | 55.4375 | 55.435 | 55.435 | 800.0 |
| 2019-09-19 06:45:00 | AAPL | Stock | 55.4625 | 55.4625 | 55.4625 | 55.4625 | 12000.0 |
| 2019-09-19 06:55:00 | AAPL | Stock | 55.465 | 55.465 | 55.465 | 55.465 | 2000.0 |
| 2019-09-19 07:00:00 | AAPL | Stock | 55.4825 | 55.495 | 55.4475 | 55.45 | 25312.0 |
| 2019-09-19 07:05:00 | AAPL | Stock | 55.4625 | 55.5025 | 55.46 | 55.5 | 45216.0 |
| 2019-09-19 07:10:00 | AAPL | Stock | 55.5 | 55.505 | 55.5 | 55.5 | 29628.0 |
| 2019-09-19 07:15:00 | AAPL | Stock | 55.525 | 55.5375 | 55.5 | 55.5375 | 17500.0 |
| 2019-09-19 07:20:00 | AAPL | Stock | 55.55 | 55.55 | 55.5125 | 55.5125 | 2608.0 |
| 2019-09-19 07:25:00 | AAPL | Stock | 55.55 | 55.5725 | 55.55 | 55.5725 | 5904.0 |
| 2019-09-19 07:30:00 | AAPL | Stock | 55.5725 | 55.5725 | 55.5625 | 55.5625 | 3220.0 |
| 2019-09-19 07:35:00 | AAPL | Stock | 55.5625 | 55.5625 | 55.5625 | 55.5625 | 1200.0 |
| 2019-09-19 07:45:00 | AAPL | Stock | 55.5675 | 55.5675 | 55.5625 | 55.5625 | 5240.0 |
| 2019-09-19 07:50:00 | AAPL | Stock | 55.5675 | 55.57 | 55.5675 | 55.57 | 11960.0 |
| 2019-09-19 07:55:00 | AAPL | Stock | 55.5775 | 55.6 | 55.5775 | 55.6 | 1600.0 |
| 2019-09-19 08:00:00 | AAPL | Stock | 55.45 | 55.615 | 55.445 | 55.6 | 72160.0 |
| 2019-09-19 08:05:00 | AAPL | Stock | 55.595 | 55.595 | 55.5725 | 55.5725 | 14832.0 |
| 2019-09-19 08:10:00 | AAPL | Stock | 55.565 | 55.605 | 55.5625 | 55.605 | 10724.0 |
| 2019-09-19 08:15:00 | AAPL | Stock | 55.595 | 55.595 | 55.59 | 55.595 | 5600.0 |
| 2019-09-19 08:20:00 | AAPL | Stock | 55.5925 | 55.6425 | 55.5775 | 55.6425 | 29244.0 |
| 2019-09-19 08:25:00 | AAPL | Stock | 55.645 | 55.6775 | 55.63 | 55.6775 | 23080.0 |
| 2019-09-19 08:30:00 | AAPL | Stock | 55.685 | 55.6875 | 55.625 | 55.65 | 19256.0 |
| 2019-09-19 08:35:00 | AAPL | Stock | 55.6475 | 55.732 | 55.6475 | 55.7225 | 34988.0 |
| 2019-09-19 08:40:00 | AAPL | Stock | 55.7 | 55.72 | 55.6925 | 55.7 | 52204.0 |
| 2019-09-19 08:45:00 | AAPL | Stock | 55.695 | 55.765 | 55.69 | 55.765 | 66280.0 |
| 2019-09-19 08:50:00 | AAPL | Stock | 55.745 | 55.7975 | 55.715 | 55.755 | 35336.0 |
| 2019-09-19 08:55:00 | AAPL | Stock | 55.7748 | 55.7748 | 55.725 | 55.725 | 27136.0 |
| 2019-09-19 09:00:00 | AAPL | Stock | 55.7225 | 55.74 | 55.69 | 55.6925 | 34132.0 |
| 2019-09-19 09:05:00 | AAPL | Stock | 55.71 | 55.76 | 55.68 | 55.75 | 51596.0 |
| 2019-09-19 09:10:00 | AAPL | Stock | 55.7275 | 55.75 | 55.6925 | 55.6925 | 75336.0 |
| 2019-09-19 09:15:00 | AAPL | Stock | 55.69 | 55.6925 | 55.6125 | 55.625 | 27692.0 |
| 2019-09-19 09:20:00 | AAPL | Stock | 55.615 | 55.6525 | 55.5875 | 55.645 | 46436.0 |
| 2019-09-19 09:25:00 | AAPL | Stock | 55.615 | 55.645 | 55.4775 | 55.5025 | 117436.0 |
| 2019-09-19 09:30:00 | AAPL | Stock | 55.53 | 55.7575 | 55.5 | 55.57 | 4648260.0 |
| 2019-09-19 09:35:00 | AAPL | Stock | 55.5725 | 55.755 | 55.525 | 55.6812 | 2100780.0 |
| 2019-09-19 09:40:00 | AAPL | Stock | 55.6812 | 55.74 | 55.5825 | 55.705 | 2070808.0 |
| 2019-09-19 09:45:00 | AAPL | Stock | 55.71 | 55.7175 | 55.595 | 55.7 | 1127868.0 |
| 2019-09-19 09:50:00 | AAPL | Stock | 55.7 | 55.7275 | 55.6152 | 55.6625 | 1213352.0 |
> showing 50 of 363,776 rows — these rows as CSV