PREVIEW / stock_5min / 2019-11-22
file: by_date/stock_5min/2019/2019-11-22.parquet size: 5.6 MB rows: 353,475 symbols: 2,477
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-22 04:00:00 | AAPL | Stock | 65.7625 | 65.7625 | 65.7625 | 65.7625 | 428.0 |
| 2019-11-22 04:05:00 | AAPL | Stock | 65.7625 | 65.7625 | 65.7625 | 65.7625 | 1272.0 |
| 2019-11-22 04:15:00 | AAPL | Stock | 65.75 | 65.75 | 65.75 | 65.75 | 420.0 |
| 2019-11-22 04:25:00 | AAPL | Stock | 65.7475 | 65.75 | 65.7475 | 65.75 | 2000.0 |
| 2019-11-22 04:30:00 | AAPL | Stock | 65.66 | 65.66 | 65.66 | 65.66 | 480.0 |
| 2019-11-22 04:35:00 | AAPL | Stock | 65.7375 | 65.7375 | 65.7375 | 65.7375 | 1276.0 |
| 2019-11-22 04:40:00 | AAPL | Stock | 65.65 | 65.65 | 65.65 | 65.65 | 1212.0 |
| 2019-11-22 04:45:00 | AAPL | Stock | 65.7225 | 65.755 | 65.7225 | 65.755 | 1720.0 |
| 2019-11-22 06:00:00 | AAPL | Stock | 65.7425 | 65.7425 | 65.7425 | 65.7425 | 1260.0 |
| 2019-11-22 06:05:00 | AAPL | Stock | 65.745 | 65.745 | 65.705 | 65.705 | 916.0 |
| 2019-11-22 06:10:00 | AAPL | Stock | 65.68 | 65.68 | 65.665 | 65.665 | 3388.0 |
| 2019-11-22 06:40:00 | AAPL | Stock | 65.6925 | 65.6925 | 65.6925 | 65.6925 | 804.0 |
| 2019-11-22 06:55:00 | AAPL | Stock | 65.7025 | 65.7025 | 65.7025 | 65.7025 | 4160.0 |
| 2019-11-22 07:00:00 | AAPL | Stock | 65.7025 | 65.775 | 65.7 | 65.7625 | 17416.0 |
| 2019-11-22 07:05:00 | AAPL | Stock | 65.75 | 65.75 | 65.75 | 65.75 | 4800.0 |
| 2019-11-22 07:10:00 | AAPL | Stock | 65.775 | 65.775 | 65.75 | 65.75 | 2748.0 |
| 2019-11-22 07:15:00 | AAPL | Stock | 65.7625 | 65.775 | 65.7525 | 65.7525 | 5280.0 |
| 2019-11-22 07:20:00 | AAPL | Stock | 65.7625 | 65.7625 | 65.7625 | 65.7625 | 1728.0 |
| 2019-11-22 07:25:00 | AAPL | Stock | 65.765 | 65.775 | 65.765 | 65.775 | 3800.0 |
| 2019-11-22 07:30:00 | AAPL | Stock | 65.775 | 65.775 | 65.7625 | 65.7625 | 1564.0 |
| 2019-11-22 07:35:00 | AAPL | Stock | 65.77 | 65.775 | 65.7425 | 65.7425 | 10728.0 |
| 2019-11-22 07:40:00 | AAPL | Stock | 65.75 | 65.75 | 65.7425 | 65.7425 | 2400.0 |
| 2019-11-22 07:45:00 | AAPL | Stock | 65.75 | 65.7625 | 65.75 | 65.75 | 6276.0 |
| 2019-11-22 07:50:00 | AAPL | Stock | 65.75 | 65.75 | 65.725 | 65.725 | 3200.0 |
| 2019-11-22 07:55:00 | AAPL | Stock | 65.7475 | 65.75 | 65.7475 | 65.75 | 5780.0 |
| 2019-11-22 08:00:00 | AAPL | Stock | 65.7375 | 65.8 | 65.7 | 65.7425 | 167560.0 |
| 2019-11-22 08:05:00 | AAPL | Stock | 65.6995 | 65.725 | 65.6995 | 65.725 | 4800.0 |
| 2019-11-22 08:10:00 | AAPL | Stock | 65.7225 | 65.725 | 65.68 | 65.7125 | 15832.0 |
| 2019-11-22 08:15:00 | AAPL | Stock | 65.68 | 65.725 | 65.675 | 65.675 | 9600.0 |
| 2019-11-22 08:20:00 | AAPL | Stock | 65.678 | 65.6875 | 65.67 | 65.67 | 4128.0 |
| 2019-11-22 08:25:00 | AAPL | Stock | 65.6875 | 65.7075 | 65.67 | 65.7075 | 4184.0 |
| 2019-11-22 08:30:00 | AAPL | Stock | 65.7 | 65.7175 | 65.7 | 65.7175 | 4644.0 |
| 2019-11-22 08:35:00 | AAPL | Stock | 65.72 | 65.72 | 65.6275 | 65.6325 | 31904.0 |
| 2019-11-22 08:40:00 | AAPL | Stock | 65.6525 | 65.681 | 65.6525 | 65.681 | 8384.0 |
| 2019-11-22 08:45:00 | AAPL | Stock | 65.6825 | 65.7625 | 65.6275 | 65.6925 | 59300.0 |
| 2019-11-22 08:50:00 | AAPL | Stock | 65.71 | 65.78 | 65.71 | 65.78 | 47812.0 |
| 2019-11-22 08:55:00 | AAPL | Stock | 65.7975 | 65.8 | 65.5025 | 65.75 | 204860.0 |
| 2019-11-22 09:00:00 | AAPL | Stock | 65.75 | 65.75 | 65.7225 | 65.75 | 16340.0 |
| 2019-11-22 09:05:00 | AAPL | Stock | 65.7375 | 65.745 | 65.7125 | 65.725 | 24544.0 |
| 2019-11-22 09:10:00 | AAPL | Stock | 65.7375 | 65.7375 | 65.7 | 65.7 | 19832.0 |
| 2019-11-22 09:15:00 | AAPL | Stock | 65.7 | 65.73 | 65.695 | 65.73 | 5824.0 |
| 2019-11-22 09:20:00 | AAPL | Stock | 65.7175 | 65.75 | 65.7175 | 65.7325 | 37408.0 |
| 2019-11-22 09:25:00 | AAPL | Stock | 65.7425 | 65.7625 | 65.5875 | 65.6375 | 108000.0 |
| 2019-11-22 09:30:00 | AAPL | Stock | 65.6375 | 65.7625 | 65.53 | 65.758 | 3677000.0 |
| 2019-11-22 09:35:00 | AAPL | Stock | 65.755 | 65.795 | 65.6025 | 65.67 | 1305892.0 |
| 2019-11-22 09:40:00 | AAPL | Stock | 65.6625 | 65.6625 | 65.385 | 65.45 | 1600952.0 |
| 2019-11-22 09:45:00 | AAPL | Stock | 65.4575 | 65.6155 | 65.44 | 65.5833 | 1409136.0 |
| 2019-11-22 09:50:00 | AAPL | Stock | 65.5875 | 65.6625 | 65.54 | 65.62 | 673236.0 |
| 2019-11-22 09:55:00 | AAPL | Stock | 65.6225 | 65.665 | 65.5825 | 65.635 | 702440.0 |
| 2019-11-22 10:00:00 | AAPL | Stock | 65.635 | 65.725 | 65.6275 | 65.695 | 920512.0 |
> showing 50 of 353,475 rows — these rows as CSV