PREVIEW / stock_1min / 2020-01-27
file: by_date/stock_1min/2020/2020-01-27.parquet size: 17.8 MB rows: 1,153,407 symbols: 2,077
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-27 04:00:00 | AAPL | Stock | 78.475 | 78.475 | 78.275 | 78.275 | 27656.0 |
| 2020-01-27 04:01:00 | AAPL | Stock | 78.3125 | 78.3125 | 78.3125 | 78.3125 | 4280.0 |
| 2020-01-27 04:02:00 | AAPL | Stock | 78.345 | 78.345 | 78.345 | 78.345 | 2000.0 |
| 2020-01-27 04:03:00 | AAPL | Stock | 78.275 | 78.275 | 78.275 | 78.275 | 1600.0 |
| 2020-01-27 04:04:00 | AAPL | Stock | 78.265 | 78.345 | 78.25 | 78.2975 | 14728.0 |
| 2020-01-27 04:05:00 | AAPL | Stock | 78.3475 | 78.3475 | 78.275 | 78.325 | 8400.0 |
| 2020-01-27 04:06:00 | AAPL | Stock | 78.25 | 78.25 | 78.2 | 78.2 | 4476.0 |
| 2020-01-27 04:07:00 | AAPL | Stock | 78.195 | 78.195 | 78.1475 | 78.1475 | 4000.0 |
| 2020-01-27 04:08:00 | AAPL | Stock | 78.1875 | 78.1875 | 78.1775 | 78.1775 | 1924.0 |
| 2020-01-27 04:09:00 | AAPL | Stock | 78.1725 | 78.2 | 78.1725 | 78.2 | 3964.0 |
| 2020-01-27 04:10:00 | AAPL | Stock | 78.2 | 78.2175 | 78.2 | 78.2175 | 4688.0 |
| 2020-01-27 04:11:00 | AAPL | Stock | 78.215 | 78.2625 | 78.215 | 78.2625 | 8064.0 |
| 2020-01-27 04:12:00 | AAPL | Stock | 78.3025 | 78.3025 | 78.3025 | 78.3025 | 600.0 |
| 2020-01-27 04:13:00 | AAPL | Stock | 78.2425 | 78.25 | 78.165 | 78.25 | 3080.0 |
| 2020-01-27 04:14:00 | AAPL | Stock | 78.2425 | 78.2425 | 78.2425 | 78.2425 | 800.0 |
| 2020-01-27 04:17:00 | AAPL | Stock | 78.195 | 78.195 | 78.125 | 78.125 | 2800.0 |
| 2020-01-27 04:18:00 | AAPL | Stock | 78.145 | 78.22 | 78.145 | 78.2125 | 8768.0 |
| 2020-01-27 04:19:00 | AAPL | Stock | 78.1325 | 78.1375 | 78.08 | 78.1375 | 5508.0 |
| 2020-01-27 04:23:00 | AAPL | Stock | 78.115 | 78.115 | 78.115 | 78.115 | 800.0 |
| 2020-01-27 04:24:00 | AAPL | Stock | 78.1525 | 78.1525 | 78.1525 | 78.1525 | 532.0 |
| 2020-01-27 04:25:00 | AAPL | Stock | 78.1275 | 78.14 | 78.0 | 78.0525 | 21352.0 |
| 2020-01-27 04:26:00 | AAPL | Stock | 78.05 | 78.055 | 78.05 | 78.055 | 1404.0 |
| 2020-01-27 04:28:00 | AAPL | Stock | 78.02 | 78.02 | 78.0 | 78.0 | 2196.0 |
| 2020-01-27 04:29:00 | AAPL | Stock | 78.05 | 78.05 | 78.05 | 78.05 | 748.0 |
| 2020-01-27 04:33:00 | AAPL | Stock | 78.05 | 78.05 | 78.05 | 78.05 | 400.0 |
| 2020-01-27 04:35:00 | AAPL | Stock | 78.065 | 78.065 | 78.0 | 78.0 | 3932.0 |
| 2020-01-27 04:37:00 | AAPL | Stock | 78.0125 | 78.0125 | 78.0125 | 78.0125 | 400.0 |
| 2020-01-27 04:38:00 | AAPL | Stock | 78.0 | 78.0 | 77.99 | 78.0 | 3884.0 |
| 2020-01-27 04:39:00 | AAPL | Stock | 78.0125 | 78.0125 | 77.96 | 77.96 | 1312.0 |
| 2020-01-27 04:40:00 | AAPL | Stock | 77.965 | 77.995 | 77.9625 | 77.995 | 2744.0 |
| 2020-01-27 04:41:00 | AAPL | Stock | 77.975 | 77.98 | 77.96 | 77.96 | 3040.0 |
| 2020-01-27 04:42:00 | AAPL | Stock | 77.9325 | 77.9575 | 77.9325 | 77.955 | 2004.0 |
| 2020-01-27 04:45:00 | AAPL | Stock | 77.955 | 77.955 | 77.955 | 77.955 | 2304.0 |
| 2020-01-27 04:47:00 | AAPL | Stock | 77.9175 | 77.9175 | 77.9175 | 77.9175 | 960.0 |
| 2020-01-27 04:48:00 | AAPL | Stock | 77.9125 | 77.9125 | 77.9125 | 77.9125 | 400.0 |
| 2020-01-27 04:49:00 | AAPL | Stock | 77.925 | 77.925 | 77.925 | 77.925 | 1200.0 |
| 2020-01-27 04:50:00 | AAPL | Stock | 77.9025 | 77.9025 | 77.8975 | 77.8975 | 976.0 |
| 2020-01-27 04:51:00 | AAPL | Stock | 77.91 | 77.925 | 77.9025 | 77.9025 | 4532.0 |
| 2020-01-27 04:52:00 | AAPL | Stock | 77.9 | 77.9 | 77.9 | 77.9 | 400.0 |
| 2020-01-27 04:53:00 | AAPL | Stock | 77.9575 | 77.9575 | 77.9575 | 77.9575 | 400.0 |
| 2020-01-27 04:54:00 | AAPL | Stock | 77.95 | 78.0 | 77.95 | 78.0 | 12040.0 |
| 2020-01-27 04:55:00 | AAPL | Stock | 78.02 | 78.035 | 78.02 | 78.035 | 2000.0 |
| 2020-01-27 04:56:00 | AAPL | Stock | 78.05 | 78.05 | 78.05 | 78.05 | 800.0 |
| 2020-01-27 04:57:00 | AAPL | Stock | 78.035 | 78.035 | 78.035 | 78.035 | 400.0 |
| 2020-01-27 04:58:00 | AAPL | Stock | 78.0 | 78.0 | 78.0 | 78.0 | 400.0 |
| 2020-01-27 04:59:00 | AAPL | Stock | 78.0225 | 78.0225 | 78.0225 | 78.0225 | 400.0 |
| 2020-01-27 05:00:00 | AAPL | Stock | 78.0225 | 78.025 | 78.0 | 78.025 | 12104.0 |
| 2020-01-27 05:01:00 | AAPL | Stock | 78.0 | 78.0 | 78.0 | 78.0 | 6476.0 |
| 2020-01-27 05:12:00 | AAPL | Stock | 77.875 | 77.875 | 77.8375 | 77.8375 | 8948.0 |
| 2020-01-27 05:13:00 | AAPL | Stock | 77.7775 | 77.7775 | 77.7775 | 77.7775 | 716.0 |
> showing 50 of 1,153,407 rows — these rows as CSV