PREVIEW / stock_5min / 2019-10-09
file: by_date/stock_5min/2019/2019-10-09.parquet size: 5.4 MB rows: 343,727 symbols: 2,481
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-10-09 04:00:00 | AAPL | Stock | 56.25 | 56.2625 | 56.25 | 56.2625 | 4732.0 |
| 2019-10-09 04:05:00 | AAPL | Stock | 56.2625 | 56.2625 | 56.2625 | 56.2625 | 7568.0 |
| 2019-10-09 04:10:00 | AAPL | Stock | 56.3 | 56.3 | 56.2875 | 56.2975 | 16988.0 |
| 2019-10-09 04:15:00 | AAPL | Stock | 56.3125 | 56.3375 | 56.295 | 56.295 | 11132.0 |
| 2019-10-09 04:20:00 | AAPL | Stock | 56.36 | 56.375 | 56.36 | 56.375 | 11500.0 |
| 2019-10-09 04:30:00 | AAPL | Stock | 56.3625 | 56.375 | 56.3625 | 56.375 | 4404.0 |
| 2019-10-09 04:40:00 | AAPL | Stock | 56.4 | 56.4725 | 56.4 | 56.4725 | 9096.0 |
| 2019-10-09 04:45:00 | AAPL | Stock | 56.4375 | 56.4425 | 56.4375 | 56.4425 | 800.0 |
| 2019-10-09 04:50:00 | AAPL | Stock | 56.4425 | 56.4425 | 56.425 | 56.425 | 1200.0 |
| 2019-10-09 04:55:00 | AAPL | Stock | 56.42 | 56.425 | 56.42 | 56.425 | 1200.0 |
| 2019-10-09 05:05:00 | AAPL | Stock | 56.415 | 56.415 | 56.415 | 56.415 | 400.0 |
| 2019-10-09 05:10:00 | AAPL | Stock | 56.44 | 56.64 | 56.44 | 56.6225 | 26476.0 |
| 2019-10-09 05:15:00 | AAPL | Stock | 56.6375 | 56.68 | 56.5925 | 56.5925 | 8492.0 |
| 2019-10-09 05:20:00 | AAPL | Stock | 56.63 | 56.665 | 56.615 | 56.615 | 11764.0 |
| 2019-10-09 05:25:00 | AAPL | Stock | 56.6375 | 56.6375 | 56.6375 | 56.6375 | 400.0 |
| 2019-10-09 05:30:00 | AAPL | Stock | 56.615 | 56.6625 | 56.615 | 56.6625 | 14152.0 |
| 2019-10-09 05:35:00 | AAPL | Stock | 56.625 | 56.625 | 56.5775 | 56.6075 | 7348.0 |
| 2019-10-09 05:45:00 | AAPL | Stock | 56.635 | 56.75 | 56.635 | 56.75 | 8976.0 |
| 2019-10-09 05:50:00 | AAPL | Stock | 56.7425 | 56.7425 | 56.6875 | 56.6875 | 9512.0 |
| 2019-10-09 05:55:00 | AAPL | Stock | 56.725 | 56.75 | 56.725 | 56.75 | 1200.0 |
| 2019-10-09 06:00:00 | AAPL | Stock | 56.6425 | 56.6425 | 56.6425 | 56.6425 | 400.0 |
| 2019-10-09 06:05:00 | AAPL | Stock | 56.645 | 56.645 | 56.645 | 56.645 | 400.0 |
| 2019-10-09 06:10:00 | AAPL | Stock | 56.69 | 56.695 | 56.645 | 56.645 | 5608.0 |
| 2019-10-09 06:15:00 | AAPL | Stock | 56.645 | 56.645 | 56.645 | 56.645 | 1584.0 |
| 2019-10-09 06:20:00 | AAPL | Stock | 56.69 | 56.75 | 56.69 | 56.7375 | 5312.0 |
| 2019-10-09 06:30:00 | AAPL | Stock | 56.765 | 56.775 | 56.7375 | 56.775 | 13164.0 |
| 2019-10-09 06:35:00 | AAPL | Stock | 56.8125 | 56.8375 | 56.8125 | 56.8375 | 4124.0 |
| 2019-10-09 06:40:00 | AAPL | Stock | 56.81 | 56.81 | 56.81 | 56.81 | 812.0 |
| 2019-10-09 06:55:00 | AAPL | Stock | 56.7775 | 56.8075 | 56.7775 | 56.8075 | 8016.0 |
| 2019-10-09 07:00:00 | AAPL | Stock | 56.7575 | 56.83 | 56.6875 | 56.6875 | 80228.0 |
| 2019-10-09 07:05:00 | AAPL | Stock | 56.685 | 56.7125 | 56.6625 | 56.7125 | 33784.0 |
| 2019-10-09 07:10:00 | AAPL | Stock | 56.7 | 56.7125 | 56.6625 | 56.6625 | 11320.0 |
| 2019-10-09 07:15:00 | AAPL | Stock | 56.7 | 56.78 | 56.6975 | 56.75 | 53688.0 |
| 2019-10-09 07:20:00 | AAPL | Stock | 56.7725 | 56.795 | 56.7725 | 56.775 | 33400.0 |
| 2019-10-09 07:25:00 | AAPL | Stock | 56.795 | 56.8 | 56.775 | 56.785 | 9104.0 |
| 2019-10-09 07:30:00 | AAPL | Stock | 56.775 | 56.8 | 56.7125 | 56.7425 | 34408.0 |
| 2019-10-09 07:35:00 | AAPL | Stock | 56.73 | 56.7675 | 56.725 | 56.7675 | 4176.0 |
| 2019-10-09 07:40:00 | AAPL | Stock | 56.75 | 56.75 | 56.7175 | 56.7175 | 23984.0 |
| 2019-10-09 07:45:00 | AAPL | Stock | 56.74 | 56.775 | 56.7 | 56.715 | 12252.0 |
| 2019-10-09 07:50:00 | AAPL | Stock | 56.7375 | 56.7825 | 56.725 | 56.7825 | 32088.0 |
| 2019-10-09 07:55:00 | AAPL | Stock | 56.7925 | 56.8125 | 56.765 | 56.775 | 76432.0 |
| 2019-10-09 08:00:00 | AAPL | Stock | 56.704 | 56.8125 | 56.6625 | 56.7975 | 230856.0 |
| 2019-10-09 08:05:00 | AAPL | Stock | 56.7525 | 56.7875 | 56.75 | 56.75 | 15332.0 |
| 2019-10-09 08:10:00 | AAPL | Stock | 56.7175 | 56.7725 | 56.7175 | 56.725 | 41216.0 |
| 2019-10-09 08:15:00 | AAPL | Stock | 56.7125 | 56.7475 | 56.7025 | 56.7125 | 16340.0 |
| 2019-10-09 08:20:00 | AAPL | Stock | 56.7125 | 56.725 | 56.6775 | 56.6775 | 23084.0 |
| 2019-10-09 08:25:00 | AAPL | Stock | 56.72 | 56.72 | 56.6775 | 56.7 | 23836.0 |
| 2019-10-09 08:30:00 | AAPL | Stock | 56.7125 | 56.7375 | 56.7 | 56.725 | 33936.0 |
| 2019-10-09 08:35:00 | AAPL | Stock | 56.7375 | 56.77 | 56.7025 | 56.7275 | 38852.0 |
| 2019-10-09 08:40:00 | AAPL | Stock | 56.7275 | 56.75 | 56.6 | 56.6745 | 76568.0 |
> showing 50 of 343,727 rows — these rows as CSV