PREVIEW / stock_5min / 2020-01-29
file: by_date/stock_5min/2020/2020-01-29.parquet size: 5.9 MB rows: 365,759 symbols: 2,428
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 |
|---|---|---|---|---|---|---|---|
| 2020-01-29 04:00:00 | AAPL | Stock | 81.0625 | 81.0625 | 80.8 | 80.875 | 22396.0 |
| 2020-01-29 04:05:00 | AAPL | Stock | 80.9375 | 81.05 | 80.92 | 81.0075 | 22560.0 |
| 2020-01-29 04:10:00 | AAPL | Stock | 81.0275 | 81.075 | 80.9575 | 81.0 | 15232.0 |
| 2020-01-29 04:15:00 | AAPL | Stock | 81.0 | 81.03 | 80.975 | 80.975 | 11256.0 |
| 2020-01-29 04:20:00 | AAPL | Stock | 80.9925 | 81.0 | 80.9625 | 81.0 | 2772.0 |
| 2020-01-29 04:25:00 | AAPL | Stock | 80.9975 | 81.0 | 80.975 | 80.9775 | 15216.0 |
| 2020-01-29 04:30:00 | AAPL | Stock | 80.97 | 81.0 | 80.97 | 81.0 | 3420.0 |
| 2020-01-29 04:35:00 | AAPL | Stock | 80.9975 | 81.1 | 80.9975 | 81.075 | 7100.0 |
| 2020-01-29 04:40:00 | AAPL | Stock | 81.0975 | 81.1 | 81.07 | 81.07 | 6012.0 |
| 2020-01-29 04:45:00 | AAPL | Stock | 81.125 | 81.1625 | 81.125 | 81.125 | 9264.0 |
| 2020-01-29 04:50:00 | AAPL | Stock | 81.1075 | 81.1075 | 81.085 | 81.085 | 3980.0 |
| 2020-01-29 04:55:00 | AAPL | Stock | 81.105 | 81.1075 | 81.105 | 81.1075 | 5396.0 |
| 2020-01-29 05:00:00 | AAPL | Stock | 81.08 | 81.08 | 81.08 | 81.08 | 736.0 |
| 2020-01-29 05:05:00 | AAPL | Stock | 81.0775 | 81.08 | 80.9375 | 80.96 | 6476.0 |
| 2020-01-29 05:10:00 | AAPL | Stock | 80.9925 | 80.9975 | 80.9925 | 80.995 | 1264.0 |
| 2020-01-29 05:15:00 | AAPL | Stock | 81.0275 | 81.0275 | 81.025 | 81.025 | 2400.0 |
| 2020-01-29 05:20:00 | AAPL | Stock | 81.025 | 81.1075 | 81.025 | 81.05 | 15824.0 |
| 2020-01-29 05:25:00 | AAPL | Stock | 81.05 | 81.05 | 81.0375 | 81.0375 | 11424.0 |
| 2020-01-29 05:30:00 | AAPL | Stock | 81.0425 | 81.0425 | 81.0425 | 81.0425 | 1008.0 |
| 2020-01-29 05:35:00 | AAPL | Stock | 81.0375 | 81.1025 | 81.0375 | 81.1025 | 8116.0 |
| 2020-01-29 05:40:00 | AAPL | Stock | 81.1025 | 81.1075 | 81.1025 | 81.1075 | 4964.0 |
| 2020-01-29 05:45:00 | AAPL | Stock | 81.105 | 81.125 | 81.105 | 81.125 | 8324.0 |
| 2020-01-29 05:50:00 | AAPL | Stock | 81.15 | 81.15 | 81.15 | 81.15 | 752.0 |
| 2020-01-29 05:55:00 | AAPL | Stock | 81.15 | 81.15 | 81.1475 | 81.1475 | 8172.0 |
| 2020-01-29 06:00:00 | AAPL | Stock | 81.1375 | 81.1625 | 81.1275 | 81.1625 | 8576.0 |
| 2020-01-29 06:05:00 | AAPL | Stock | 81.1625 | 81.2225 | 81.1625 | 81.1625 | 7464.0 |
| 2020-01-29 06:10:00 | AAPL | Stock | 81.2 | 81.2675 | 81.185 | 81.2675 | 22956.0 |
| 2020-01-29 06:15:00 | AAPL | Stock | 81.2 | 81.225 | 81.15 | 81.15 | 8344.0 |
| 2020-01-29 06:20:00 | AAPL | Stock | 81.1725 | 81.175 | 81.125 | 81.1325 | 5600.0 |
| 2020-01-29 06:25:00 | AAPL | Stock | 81.185 | 81.2125 | 81.185 | 81.2125 | 2920.0 |
| 2020-01-29 06:30:00 | AAPL | Stock | 81.2125 | 81.2125 | 81.1225 | 81.16 | 13908.0 |
| 2020-01-29 06:35:00 | AAPL | Stock | 81.165 | 81.165 | 81.1225 | 81.1225 | 3260.0 |
| 2020-01-29 06:40:00 | AAPL | Stock | 81.105 | 81.1075 | 81.0625 | 81.1075 | 10720.0 |
| 2020-01-29 06:45:00 | AAPL | Stock | 81.0875 | 81.0875 | 80.925 | 80.9725 | 43900.0 |
| 2020-01-29 06:50:00 | AAPL | Stock | 80.97 | 80.9725 | 80.9375 | 80.9625 | 9912.0 |
| 2020-01-29 06:55:00 | AAPL | Stock | 80.925 | 80.9625 | 80.92 | 80.9625 | 27608.0 |
| 2020-01-29 07:00:00 | AAPL | Stock | 80.9625 | 81.1025 | 80.8475 | 80.9375 | 161932.0 |
| 2020-01-29 07:05:00 | AAPL | Stock | 80.925 | 80.975 | 80.8125 | 80.8125 | 62004.0 |
| 2020-01-29 07:10:00 | AAPL | Stock | 80.8075 | 80.85 | 80.705 | 80.8 | 104120.0 |
| 2020-01-29 07:15:00 | AAPL | Stock | 80.7575 | 80.8075 | 80.69 | 80.72 | 59864.0 |
| 2020-01-29 07:20:00 | AAPL | Stock | 80.75 | 80.975 | 80.75 | 80.8625 | 88112.0 |
| 2020-01-29 07:25:00 | AAPL | Stock | 80.85 | 80.925 | 80.78 | 80.78 | 47740.0 |
| 2020-01-29 07:30:00 | AAPL | Stock | 80.8 | 80.8 | 80.6875 | 80.7225 | 18964.0 |
| 2020-01-29 07:35:00 | AAPL | Stock | 80.7025 | 80.7125 | 80.6475 | 80.7 | 40952.0 |
| 2020-01-29 07:40:00 | AAPL | Stock | 80.675 | 80.7 | 80.6525 | 80.69 | 27428.0 |
| 2020-01-29 07:45:00 | AAPL | Stock | 80.695 | 80.75 | 80.675 | 80.72 | 60004.0 |
| 2020-01-29 07:50:00 | AAPL | Stock | 80.6975 | 80.825 | 80.6625 | 80.7625 | 55972.0 |
| 2020-01-29 07:55:00 | AAPL | Stock | 80.79 | 80.845 | 80.7525 | 80.775 | 44280.0 |
| 2020-01-29 08:00:00 | AAPL | Stock | 80.975 | 81.0975 | 80.65 | 81.075 | 363884.0 |
| 2020-01-29 08:05:00 | AAPL | Stock | 80.805 | 80.8675 | 80.805 | 80.8675 | 62924.0 |
> showing 50 of 365,759 rows — these rows as CSV