PREVIEW / stock_5min / 2019-08-21
file: by_date/stock_5min/2019/2019-08-21.parquet size: 5.6 MB rows: 353,475 symbols: 2,562
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-08-21 04:00:00 | AAPL | Stock | 52.775 | 52.775 | 52.775 | 52.775 | 552.0 |
| 2019-08-21 04:05:00 | AAPL | Stock | 52.91 | 52.91 | 52.91 | 52.91 | 748.0 |
| 2019-08-21 04:10:00 | AAPL | Stock | 52.995 | 53.11 | 52.965 | 53.11 | 9908.0 |
| 2019-08-21 04:15:00 | AAPL | Stock | 53.0475 | 53.065 | 53.045 | 53.065 | 1200.0 |
| 2019-08-21 04:20:00 | AAPL | Stock | 53.015 | 53.015 | 53.015 | 53.015 | 400.0 |
| 2019-08-21 04:25:00 | AAPL | Stock | 53.05 | 53.05 | 53.05 | 53.05 | 1172.0 |
| 2019-08-21 04:30:00 | AAPL | Stock | 53.045 | 53.045 | 53.045 | 53.045 | 3600.0 |
| 2019-08-21 04:35:00 | AAPL | Stock | 53.08 | 53.08 | 53.08 | 53.08 | 1200.0 |
| 2019-08-21 04:40:00 | AAPL | Stock | 53.075 | 53.135 | 53.075 | 53.135 | 1660.0 |
| 2019-08-21 04:45:00 | AAPL | Stock | 53.135 | 53.135 | 53.135 | 53.135 | 800.0 |
| 2019-08-21 05:05:00 | AAPL | Stock | 53.1125 | 53.1125 | 53.1125 | 53.1125 | 3600.0 |
| 2019-08-21 05:15:00 | AAPL | Stock | 53.125 | 53.125 | 53.1 | 53.1 | 2108.0 |
| 2019-08-21 05:20:00 | AAPL | Stock | 53.0875 | 53.125 | 53.0875 | 53.125 | 14336.0 |
| 2019-08-21 05:25:00 | AAPL | Stock | 53.15 | 53.15 | 53.15 | 53.15 | 2108.0 |
| 2019-08-21 05:30:00 | AAPL | Stock | 53.1525 | 53.1525 | 53.1525 | 53.1525 | 400.0 |
| 2019-08-21 05:45:00 | AAPL | Stock | 53.2 | 53.2 | 53.2 | 53.2 | 440.0 |
| 2019-08-21 05:50:00 | AAPL | Stock | 53.1325 | 53.1325 | 53.09 | 53.1125 | 9672.0 |
| 2019-08-21 06:00:00 | AAPL | Stock | 53.09 | 53.09 | 53.08 | 53.08 | 12136.0 |
| 2019-08-21 06:05:00 | AAPL | Stock | 53.045 | 53.045 | 53.045 | 53.045 | 5276.0 |
| 2019-08-21 06:10:00 | AAPL | Stock | 53.08 | 53.08 | 53.08 | 53.08 | 400.0 |
| 2019-08-21 06:20:00 | AAPL | Stock | 53.08 | 53.08 | 53.08 | 53.08 | 1600.0 |
| 2019-08-21 06:35:00 | AAPL | Stock | 53.1125 | 53.1125 | 53.1125 | 53.1125 | 400.0 |
| 2019-08-21 06:40:00 | AAPL | Stock | 53.055 | 53.055 | 53.05 | 53.05 | 1580.0 |
| 2019-08-21 06:45:00 | AAPL | Stock | 53.0675 | 53.0675 | 53.0675 | 53.0675 | 4000.0 |
| 2019-08-21 06:55:00 | AAPL | Stock | 53.1125 | 53.1125 | 53.075 | 53.075 | 3200.0 |
| 2019-08-21 07:00:00 | AAPL | Stock | 53.1 | 53.1 | 53.0 | 53.0075 | 25744.0 |
| 2019-08-21 07:05:00 | AAPL | Stock | 53.03 | 53.0625 | 53.03 | 53.0375 | 13800.0 |
| 2019-08-21 07:10:00 | AAPL | Stock | 53.0425 | 53.075 | 53.0425 | 53.0425 | 23024.0 |
| 2019-08-21 07:15:00 | AAPL | Stock | 53.05 | 53.0625 | 53.05 | 53.0625 | 6380.0 |
| 2019-08-21 07:25:00 | AAPL | Stock | 53.0625 | 53.075 | 53.055 | 53.07 | 18524.0 |
| 2019-08-21 07:30:00 | AAPL | Stock | 53.05 | 53.055 | 53.0375 | 53.055 | 13256.0 |
| 2019-08-21 07:35:00 | AAPL | Stock | 53.0375 | 53.05 | 53.025 | 53.0375 | 6240.0 |
| 2019-08-21 07:40:00 | AAPL | Stock | 53.015 | 53.0475 | 53.0 | 53.025 | 21180.0 |
| 2019-08-21 07:45:00 | AAPL | Stock | 53.0375 | 53.075 | 53.0375 | 53.0625 | 15868.0 |
| 2019-08-21 07:50:00 | AAPL | Stock | 53.075 | 53.075 | 53.07 | 53.075 | 17180.0 |
| 2019-08-21 07:55:00 | AAPL | Stock | 53.05 | 53.0625 | 53.005 | 53.0525 | 17228.0 |
| 2019-08-21 08:00:00 | AAPL | Stock | 53.06 | 53.075 | 53.0 | 53.0238 | 75548.0 |
| 2019-08-21 08:05:00 | AAPL | Stock | 53.04 | 53.07 | 53.04 | 53.055 | 4700.0 |
| 2019-08-21 08:10:00 | AAPL | Stock | 53.0625 | 53.0675 | 53.0625 | 53.0675 | 2080.0 |
| 2019-08-21 08:15:00 | AAPL | Stock | 53.075 | 53.1 | 53.0225 | 53.025 | 37584.0 |
| 2019-08-21 08:20:00 | AAPL | Stock | 53.05 | 53.095 | 53.05 | 53.05 | 2400.0 |
| 2019-08-21 08:25:00 | AAPL | Stock | 53.075 | 53.075 | 53.045 | 53.065 | 4200.0 |
| 2019-08-21 08:30:00 | AAPL | Stock | 53.065 | 53.065 | 53.0425 | 53.0425 | 3760.0 |
| 2019-08-21 08:35:00 | AAPL | Stock | 53.05 | 53.0625 | 53.05 | 53.0625 | 6300.0 |
| 2019-08-21 08:40:00 | AAPL | Stock | 53.0625 | 53.0625 | 53.05 | 53.0625 | 6484.0 |
| 2019-08-21 08:45:00 | AAPL | Stock | 53.0675 | 53.0925 | 53.05 | 53.0925 | 12748.0 |
| 2019-08-21 08:50:00 | AAPL | Stock | 53.09 | 53.1125 | 53.0875 | 53.0875 | 26256.0 |
| 2019-08-21 08:55:00 | AAPL | Stock | 53.0875 | 53.115 | 53.08 | 53.115 | 35440.0 |
| 2019-08-21 09:00:00 | AAPL | Stock | 53.1025 | 53.2 | 53.1 | 53.18 | 72296.0 |
| 2019-08-21 09:05:00 | AAPL | Stock | 53.18 | 53.22 | 53.165 | 53.165 | 43312.0 |
> showing 50 of 353,475 rows — these rows as CSV