PREVIEW / stock_1min / 2020-07-20
file: by_date/stock_1min/2020/2020-07-20.parquet size: 20.4 MB rows: 1,264,908 symbols: 2,072
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-07-20 04:00:00 | AAPL | Stock | 95.8 | 95.8 | 95.8 | 95.8 | 1556.0 |
| 2020-07-20 04:28:00 | AAPL | Stock | 95.75 | 95.75 | 95.75 | 95.75 | 1600.0 |
| 2020-07-20 04:38:00 | AAPL | Stock | 95.75 | 95.75 | 95.75 | 95.75 | 800.0 |
| 2020-07-20 04:39:00 | AAPL | Stock | 95.76 | 95.76 | 95.76 | 95.76 | 400.0 |
| 2020-07-20 04:40:00 | AAPL | Stock | 95.7975 | 95.7975 | 95.7975 | 95.7975 | 800.0 |
| 2020-07-20 04:41:00 | AAPL | Stock | 95.875 | 95.875 | 95.875 | 95.875 | 2228.0 |
| 2020-07-20 04:44:00 | AAPL | Stock | 95.995 | 96.0 | 95.995 | 96.0 | 6760.0 |
| 2020-07-20 04:45:00 | AAPL | Stock | 96.0975 | 96.0975 | 96.0375 | 96.0375 | 1180.0 |
| 2020-07-20 04:47:00 | AAPL | Stock | 96.1175 | 96.12 | 96.09 | 96.12 | 5600.0 |
| 2020-07-20 04:48:00 | AAPL | Stock | 96.095 | 96.095 | 96.095 | 96.095 | 400.0 |
| 2020-07-20 05:04:00 | AAPL | Stock | 96.1975 | 96.2475 | 96.1225 | 96.2475 | 15064.0 |
| 2020-07-20 05:07:00 | AAPL | Stock | 96.055 | 96.055 | 96.055 | 96.055 | 424.0 |
| 2020-07-20 05:16:00 | AAPL | Stock | 96.34 | 96.3775 | 96.34 | 96.3775 | 2400.0 |
| 2020-07-20 05:18:00 | AAPL | Stock | 96.2075 | 96.2075 | 96.2075 | 96.2075 | 400.0 |
| 2020-07-20 05:20:00 | AAPL | Stock | 96.1925 | 96.1925 | 96.1925 | 96.1925 | 800.0 |
| 2020-07-20 05:23:00 | AAPL | Stock | 96.1625 | 96.1625 | 96.1625 | 96.1625 | 1676.0 |
| 2020-07-20 05:25:00 | AAPL | Stock | 96.105 | 96.105 | 96.105 | 96.105 | 400.0 |
| 2020-07-20 05:26:00 | AAPL | Stock | 96.1 | 96.1 | 96.1 | 96.1 | 636.0 |
| 2020-07-20 05:27:00 | AAPL | Stock | 96.2375 | 96.2375 | 96.2375 | 96.2375 | 900.0 |
| 2020-07-20 05:44:00 | AAPL | Stock | 96.24 | 96.24 | 96.24 | 96.24 | 608.0 |
| 2020-07-20 05:45:00 | AAPL | Stock | 96.25 | 96.25 | 96.25 | 96.25 | 400.0 |
| 2020-07-20 06:21:00 | AAPL | Stock | 96.185 | 96.185 | 96.185 | 96.185 | 400.0 |
| 2020-07-20 06:27:00 | AAPL | Stock | 96.1925 | 96.1925 | 96.1925 | 96.1925 | 976.0 |
| 2020-07-20 06:39:00 | AAPL | Stock | 96.22 | 96.22 | 96.22 | 96.22 | 800.0 |
| 2020-07-20 07:00:00 | AAPL | Stock | 96.25 | 96.3125 | 96.25 | 96.3125 | 9436.0 |
| 2020-07-20 07:01:00 | AAPL | Stock | 96.255 | 96.255 | 96.225 | 96.25 | 6008.0 |
| 2020-07-20 07:02:00 | AAPL | Stock | 96.25 | 96.25 | 96.25 | 96.25 | 1588.0 |
| 2020-07-20 07:04:00 | AAPL | Stock | 96.25 | 96.2975 | 96.2125 | 96.25 | 4864.0 |
| 2020-07-20 07:05:00 | AAPL | Stock | 96.25 | 96.26 | 96.25 | 96.26 | 1600.0 |
| 2020-07-20 07:06:00 | AAPL | Stock | 96.2625 | 96.2625 | 96.25 | 96.2525 | 4216.0 |
| 2020-07-20 07:07:00 | AAPL | Stock | 96.3 | 96.3 | 96.3 | 96.3 | 400.0 |
| 2020-07-20 07:08:00 | AAPL | Stock | 96.3 | 96.3 | 96.25 | 96.25 | 2000.0 |
| 2020-07-20 07:10:00 | AAPL | Stock | 96.25 | 96.25 | 96.25 | 96.25 | 504.0 |
| 2020-07-20 07:11:00 | AAPL | Stock | 96.25 | 96.25 | 96.25 | 96.25 | 1192.0 |
| 2020-07-20 07:12:00 | AAPL | Stock | 96.2725 | 96.275 | 96.2275 | 96.2275 | 4472.0 |
| 2020-07-20 07:14:00 | AAPL | Stock | 96.2125 | 96.2125 | 96.2125 | 96.2125 | 7720.0 |
| 2020-07-20 07:16:00 | AAPL | Stock | 96.2225 | 96.2225 | 96.2225 | 96.2225 | 800.0 |
| 2020-07-20 07:19:00 | AAPL | Stock | 96.225 | 96.225 | 96.225 | 96.225 | 2252.0 |
| 2020-07-20 07:23:00 | AAPL | Stock | 96.335 | 96.335 | 96.33 | 96.33 | 1200.0 |
| 2020-07-20 07:24:00 | AAPL | Stock | 96.3725 | 96.3725 | 96.3725 | 96.3725 | 800.0 |
| 2020-07-20 07:25:00 | AAPL | Stock | 96.33 | 96.4 | 96.33 | 96.4 | 2912.0 |
| 2020-07-20 07:26:00 | AAPL | Stock | 96.3825 | 96.3925 | 96.375 | 96.3925 | 3764.0 |
| 2020-07-20 07:27:00 | AAPL | Stock | 96.4225 | 96.4225 | 96.42 | 96.42 | 1120.0 |
| 2020-07-20 07:29:00 | AAPL | Stock | 96.3775 | 96.4175 | 96.375 | 96.4175 | 5244.0 |
| 2020-07-20 07:30:00 | AAPL | Stock | 96.405 | 96.405 | 96.375 | 96.3775 | 2160.0 |
| 2020-07-20 07:31:00 | AAPL | Stock | 96.4 | 96.4 | 96.4 | 96.4 | 2420.0 |
| 2020-07-20 07:32:00 | AAPL | Stock | 96.35 | 96.35 | 96.35 | 96.35 | 400.0 |
| 2020-07-20 07:33:00 | AAPL | Stock | 96.305 | 96.305 | 96.305 | 96.305 | 400.0 |
| 2020-07-20 07:34:00 | AAPL | Stock | 96.33 | 96.33 | 96.33 | 96.33 | 400.0 |
| 2020-07-20 07:35:00 | AAPL | Stock | 96.3625 | 96.3625 | 96.3625 | 96.3625 | 400.0 |
> showing 50 of 1,264,908 rows — these rows as CSV