PREVIEW / stock_1min / 2021-07-23
file: by_date/stock_1min/2021/2021-07-23.parquet size: 22.8 MB rows: 1,300,927 symbols: 2,397
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 |
|---|---|---|---|---|---|---|---|
| 2021-07-23 04:01:00 | AAPL | Stock | 147.5 | 147.52 | 147.5 | 147.52 | 341.0 |
| 2021-07-23 04:02:00 | AAPL | Stock | 147.6 | 147.69 | 147.5 | 147.65 | 1409.0 |
| 2021-07-23 04:03:00 | AAPL | Stock | 147.51 | 147.51 | 147.51 | 147.51 | 915.0 |
| 2021-07-23 04:04:00 | AAPL | Stock | 147.59 | 147.59 | 147.59 | 147.59 | 300.0 |
| 2021-07-23 04:05:00 | AAPL | Stock | 147.57 | 147.57 | 147.57 | 147.57 | 400.0 |
| 2021-07-23 04:12:00 | AAPL | Stock | 147.5 | 147.5 | 147.5 | 147.5 | 186.0 |
| 2021-07-23 04:15:00 | AAPL | Stock | 147.65 | 147.65 | 147.65 | 147.65 | 140.0 |
| 2021-07-23 04:19:00 | AAPL | Stock | 147.61 | 147.61 | 147.56 | 147.56 | 218.0 |
| 2021-07-23 04:20:00 | AAPL | Stock | 147.56 | 147.56 | 147.56 | 147.56 | 120.0 |
| 2021-07-23 04:22:00 | AAPL | Stock | 147.6 | 147.6 | 147.6 | 147.6 | 200.0 |
| 2021-07-23 04:24:00 | AAPL | Stock | 147.6 | 147.6 | 147.6 | 147.6 | 100.0 |
| 2021-07-23 04:26:00 | AAPL | Stock | 147.63 | 147.63 | 147.63 | 147.63 | 200.0 |
| 2021-07-23 04:27:00 | AAPL | Stock | 147.63 | 147.63 | 147.63 | 147.63 | 630.0 |
| 2021-07-23 04:28:00 | AAPL | Stock | 147.68 | 147.68 | 147.64 | 147.64 | 325.0 |
| 2021-07-23 04:29:00 | AAPL | Stock | 147.69 | 147.69 | 147.69 | 147.69 | 238.0 |
| 2021-07-23 04:31:00 | AAPL | Stock | 147.75 | 147.78 | 147.75 | 147.78 | 815.0 |
| 2021-07-23 04:32:00 | AAPL | Stock | 147.85 | 147.87 | 147.85 | 147.87 | 525.0 |
| 2021-07-23 04:34:00 | AAPL | Stock | 147.87 | 147.9 | 147.87 | 147.9 | 530.0 |
| 2021-07-23 04:35:00 | AAPL | Stock | 147.89 | 147.9 | 147.89 | 147.9 | 476.0 |
| 2021-07-23 04:36:00 | AAPL | Stock | 147.88 | 147.88 | 147.85 | 147.85 | 471.0 |
| 2021-07-23 04:37:00 | AAPL | Stock | 147.81 | 147.86 | 147.81 | 147.86 | 432.0 |
| 2021-07-23 04:39:00 | AAPL | Stock | 147.89 | 147.89 | 147.88 | 147.89 | 433.0 |
| 2021-07-23 04:42:00 | AAPL | Stock | 147.82 | 147.82 | 147.82 | 147.82 | 100.0 |
| 2021-07-23 04:45:00 | AAPL | Stock | 147.86 | 147.86 | 147.84 | 147.84 | 200.0 |
| 2021-07-23 04:48:00 | AAPL | Stock | 147.84 | 147.84 | 147.84 | 147.84 | 257.0 |
| 2021-07-23 04:50:00 | AAPL | Stock | 147.84 | 147.84 | 147.84 | 147.84 | 510.0 |
| 2021-07-23 04:56:00 | AAPL | Stock | 147.78 | 147.78 | 147.78 | 147.78 | 1144.0 |
| 2021-07-23 05:05:00 | AAPL | Stock | 147.75 | 147.75 | 147.75 | 147.75 | 291.0 |
| 2021-07-23 05:10:00 | AAPL | Stock | 147.7 | 147.7 | 147.7 | 147.7 | 215.0 |
| 2021-07-23 05:12:00 | AAPL | Stock | 147.85 | 147.85 | 147.85 | 147.85 | 331.0 |
| 2021-07-23 05:17:00 | AAPL | Stock | 147.7 | 147.7 | 147.7 | 147.7 | 108.0 |
| 2021-07-23 05:21:00 | AAPL | Stock | 147.8 | 147.8 | 147.8 | 147.8 | 224.0 |
| 2021-07-23 05:30:00 | AAPL | Stock | 147.74 | 147.74 | 147.65 | 147.65 | 2046.0 |
| 2021-07-23 05:35:00 | AAPL | Stock | 147.64 | 147.64 | 147.64 | 147.64 | 211.0 |
| 2021-07-23 05:36:00 | AAPL | Stock | 147.64 | 147.65 | 147.64 | 147.65 | 652.0 |
| 2021-07-23 05:37:00 | AAPL | Stock | 147.66 | 147.66 | 147.66 | 147.66 | 100.0 |
| 2021-07-23 05:41:00 | AAPL | Stock | 147.64 | 147.64 | 147.64 | 147.64 | 100.0 |
| 2021-07-23 05:42:00 | AAPL | Stock | 147.64 | 147.64 | 147.64 | 147.64 | 509.0 |
| 2021-07-23 05:49:00 | AAPL | Stock | 147.66 | 147.66 | 147.66 | 147.66 | 100.0 |
| 2021-07-23 05:51:00 | AAPL | Stock | 147.66 | 147.66 | 147.66 | 147.66 | 456.0 |
| 2021-07-23 05:52:00 | AAPL | Stock | 147.66 | 147.66 | 147.66 | 147.66 | 200.0 |
| 2021-07-23 05:53:00 | AAPL | Stock | 147.65 | 147.66 | 147.6 | 147.6 | 537.0 |
| 2021-07-23 05:54:00 | AAPL | Stock | 147.61 | 147.61 | 147.61 | 147.61 | 297.0 |
| 2021-07-23 05:55:00 | AAPL | Stock | 147.61 | 147.61 | 147.61 | 147.61 | 785.0 |
| 2021-07-23 05:59:00 | AAPL | Stock | 147.61 | 147.61 | 147.61 | 147.61 | 102.0 |
| 2021-07-23 06:00:00 | AAPL | Stock | 147.54 | 147.54 | 147.54 | 147.54 | 120.0 |
| 2021-07-23 06:12:00 | AAPL | Stock | 147.49 | 147.49 | 147.49 | 147.49 | 400.0 |
| 2021-07-23 06:16:00 | AAPL | Stock | 147.51 | 147.51 | 147.51 | 147.51 | 1225.0 |
| 2021-07-23 06:25:00 | AAPL | Stock | 147.54 | 147.54 | 147.54 | 147.54 | 141.0 |
| 2021-07-23 06:26:00 | AAPL | Stock | 147.54 | 147.54 | 147.54 | 147.54 | 100.0 |
> showing 50 of 1,300,927 rows — these rows as CSV