PREVIEW / stock_5min / 2019-03-06
file: by_date/stock_5min/2019/2019-03-06.parquet size: 5.7 MB rows: 364,843 symbols: 2,642
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-03-06 04:30:00 | AAPL | Stock | 43.8175 | 43.8175 | 43.8175 | 43.8175 | 400.0 |
| 2019-03-06 04:40:00 | AAPL | Stock | 43.825 | 43.825 | 43.825 | 43.825 | 400.0 |
| 2019-03-06 06:55:00 | AAPL | Stock | 43.8 | 43.8 | 43.8 | 43.8 | 2000.0 |
| 2019-03-06 07:00:00 | AAPL | Stock | 43.8 | 43.8 | 43.8 | 43.8 | 800.0 |
| 2019-03-06 07:05:00 | AAPL | Stock | 43.8075 | 43.8075 | 43.8075 | 43.8075 | 400.0 |
| 2019-03-06 07:10:00 | AAPL | Stock | 43.8125 | 43.8125 | 43.8125 | 43.8125 | 1260.0 |
| 2019-03-06 07:15:00 | AAPL | Stock | 43.815 | 43.815 | 43.8125 | 43.8125 | 888.0 |
| 2019-03-06 07:20:00 | AAPL | Stock | 43.8 | 43.8 | 43.7775 | 43.7775 | 8848.0 |
| 2019-03-06 07:25:00 | AAPL | Stock | 43.785 | 43.785 | 43.7775 | 43.7775 | 8100.0 |
| 2019-03-06 07:30:00 | AAPL | Stock | 43.7625 | 43.7625 | 43.7075 | 43.725 | 32056.0 |
| 2019-03-06 07:35:00 | AAPL | Stock | 43.7075 | 43.7075 | 43.65 | 43.6775 | 24068.0 |
| 2019-03-06 07:40:00 | AAPL | Stock | 43.685 | 43.7025 | 43.6775 | 43.7025 | 19148.0 |
| 2019-03-06 07:45:00 | AAPL | Stock | 43.7 | 43.7175 | 43.7 | 43.7175 | 8748.0 |
| 2019-03-06 07:50:00 | AAPL | Stock | 43.7175 | 43.7175 | 43.6875 | 43.6875 | 10824.0 |
| 2019-03-06 07:55:00 | AAPL | Stock | 43.6875 | 43.69 | 43.6625 | 43.675 | 48704.0 |
| 2019-03-06 08:00:00 | AAPL | Stock | 43.6725 | 43.81 | 43.63 | 43.63 | 52780.0 |
| 2019-03-06 08:05:00 | AAPL | Stock | 43.645 | 43.6825 | 43.6375 | 43.645 | 19560.0 |
| 2019-03-06 08:10:00 | AAPL | Stock | 43.675 | 43.675 | 43.665 | 43.675 | 9000.0 |
| 2019-03-06 08:15:00 | AAPL | Stock | 43.705 | 43.705 | 43.675 | 43.6825 | 8940.0 |
| 2019-03-06 08:20:00 | AAPL | Stock | 43.675 | 43.675 | 43.675 | 43.675 | 2140.0 |
| 2019-03-06 08:25:00 | AAPL | Stock | 43.6875 | 43.705 | 43.6775 | 43.685 | 15360.0 |
| 2019-03-06 08:30:00 | AAPL | Stock | 43.6775 | 43.8 | 43.645 | 43.8 | 29792.0 |
| 2019-03-06 08:35:00 | AAPL | Stock | 43.78 | 43.8 | 43.715 | 43.7425 | 26180.0 |
| 2019-03-06 08:40:00 | AAPL | Stock | 43.7475 | 43.7475 | 43.7125 | 43.725 | 12972.0 |
| 2019-03-06 08:45:00 | AAPL | Stock | 43.75 | 43.77 | 43.72 | 43.72 | 54096.0 |
| 2019-03-06 08:50:00 | AAPL | Stock | 43.7025 | 43.7325 | 43.7025 | 43.7325 | 15512.0 |
| 2019-03-06 08:55:00 | AAPL | Stock | 43.725 | 43.75 | 43.725 | 43.75 | 5600.0 |
| 2019-03-06 09:00:00 | AAPL | Stock | 43.7375 | 43.76 | 43.725 | 43.7575 | 38120.0 |
| 2019-03-06 09:05:00 | AAPL | Stock | 43.7525 | 43.7525 | 43.75 | 43.75 | 2400.0 |
| 2019-03-06 09:10:00 | AAPL | Stock | 43.7625 | 43.7625 | 43.7125 | 43.7125 | 6800.0 |
| 2019-03-06 09:15:00 | AAPL | Stock | 43.7025 | 43.7175 | 43.6782 | 43.6875 | 22312.0 |
| 2019-03-06 09:20:00 | AAPL | Stock | 43.7 | 43.71 | 43.6775 | 43.6925 | 20364.0 |
| 2019-03-06 09:25:00 | AAPL | Stock | 43.6775 | 43.6925 | 43.65 | 43.6925 | 33800.0 |
| 2019-03-06 09:30:00 | AAPL | Stock | 43.6675 | 43.7575 | 43.5025 | 43.54 | 5320820.0 |
| 2019-03-06 09:35:00 | AAPL | Stock | 43.5425 | 43.7075 | 43.485 | 43.65 | 2348920.0 |
| 2019-03-06 09:40:00 | AAPL | Stock | 43.65 | 43.6975 | 43.6 | 43.6725 | 1249332.0 |
| 2019-03-06 09:45:00 | AAPL | Stock | 43.675 | 43.7075 | 43.5725 | 43.6075 | 1037752.0 |
| 2019-03-06 09:50:00 | AAPL | Stock | 43.6075 | 43.7025 | 43.585 | 43.7 | 1118972.0 |
| 2019-03-06 09:55:00 | AAPL | Stock | 43.7 | 43.725 | 43.655 | 43.7225 | 1622456.0 |
| 2019-03-06 10:00:00 | AAPL | Stock | 43.7238 | 43.7875 | 43.715 | 43.7375 | 1439680.0 |
| 2019-03-06 10:05:00 | AAPL | Stock | 43.7375 | 43.84 | 43.7325 | 43.8325 | 1795592.0 |
| 2019-03-06 10:10:00 | AAPL | Stock | 43.8325 | 43.8725 | 43.81 | 43.825 | 1474104.0 |
| 2019-03-06 10:15:00 | AAPL | Stock | 43.8275 | 43.855 | 43.76 | 43.7775 | 905836.0 |
| 2019-03-06 10:20:00 | AAPL | Stock | 43.7775 | 43.7875 | 43.7025 | 43.7175 | 889800.0 |
| 2019-03-06 10:25:00 | AAPL | Stock | 43.72 | 43.785 | 43.7125 | 43.7325 | 903004.0 |
| 2019-03-06 10:30:00 | AAPL | Stock | 43.7275 | 43.755 | 43.6675 | 43.675 | 731464.0 |
| 2019-03-06 10:35:00 | AAPL | Stock | 43.6725 | 43.7288 | 43.6675 | 43.7125 | 468992.0 |
| 2019-03-06 10:40:00 | AAPL | Stock | 43.715 | 43.772 | 43.6975 | 43.755 | 573444.0 |
| 2019-03-06 10:45:00 | AAPL | Stock | 43.755 | 43.7825 | 43.7125 | 43.7375 | 696092.0 |
| 2019-03-06 10:50:00 | AAPL | Stock | 43.7378 | 43.7625 | 43.705 | 43.74 | 742432.0 |
> showing 50 of 364,843 rows — these rows as CSV