PREVIEW / stock_1min / 2023-12-19
file: by_date/stock_1min/2023/2023-12-19.parquet size: 22.3 MB rows: 1,326,615 symbols: 1,252
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 |
|---|---|---|---|---|---|---|---|
| 2023-12-19 04:00:00 | AAPL | Stock | 195.76 | 195.76 | 195.76 | 195.76 | 100.0 |
| 2023-12-19 04:04:00 | AAPL | Stock | 195.87 | 195.87 | 195.87 | 195.87 | 108.0 |
| 2023-12-19 04:20:00 | AAPL | Stock | 195.97 | 195.97 | 195.97 | 195.97 | 150.0 |
| 2023-12-19 04:31:00 | AAPL | Stock | 196.0 | 196.0 | 196.0 | 196.0 | 1000.0 |
| 2023-12-19 04:46:00 | AAPL | Stock | 195.99 | 195.99 | 195.99 | 195.99 | 100.0 |
| 2023-12-19 04:55:00 | AAPL | Stock | 195.91 | 195.91 | 195.91 | 195.91 | 100.0 |
| 2023-12-19 05:03:00 | AAPL | Stock | 195.9 | 195.9 | 195.9 | 195.9 | 312.0 |
| 2023-12-19 05:04:00 | AAPL | Stock | 195.92 | 195.92 | 195.92 | 195.92 | 100.0 |
| 2023-12-19 05:05:00 | AAPL | Stock | 195.94 | 195.94 | 195.94 | 195.94 | 100.0 |
| 2023-12-19 05:18:00 | AAPL | Stock | 195.88 | 195.88 | 195.88 | 195.88 | 100.0 |
| 2023-12-19 05:33:00 | AAPL | Stock | 195.8 | 195.8 | 195.8 | 195.8 | 112.0 |
| 2023-12-19 05:47:00 | AAPL | Stock | 195.85 | 195.85 | 195.85 | 195.85 | 101.0 |
| 2023-12-19 06:04:00 | AAPL | Stock | 195.83 | 195.83 | 195.83 | 195.83 | 799.0 |
| 2023-12-19 06:05:00 | AAPL | Stock | 195.82 | 195.82 | 195.82 | 195.82 | 100.0 |
| 2023-12-19 06:07:00 | AAPL | Stock | 195.83 | 195.83 | 195.83 | 195.83 | 100.0 |
| 2023-12-19 06:10:00 | AAPL | Stock | 195.86 | 195.86 | 195.86 | 195.86 | 118.0 |
| 2023-12-19 06:11:00 | AAPL | Stock | 195.86 | 195.86 | 195.86 | 195.86 | 199.0 |
| 2023-12-19 06:13:00 | AAPL | Stock | 195.8 | 195.8 | 195.8 | 195.8 | 382.0 |
| 2023-12-19 06:14:00 | AAPL | Stock | 195.8 | 195.8 | 195.8 | 195.8 | 100.0 |
| 2023-12-19 06:21:00 | AAPL | Stock | 195.78 | 195.78 | 195.78 | 195.78 | 100.0 |
| 2023-12-19 06:23:00 | AAPL | Stock | 195.75 | 195.86 | 195.75 | 195.86 | 1424.0 |
| 2023-12-19 06:28:00 | AAPL | Stock | 195.86 | 195.9 | 195.86 | 195.9 | 4275.0 |
| 2023-12-19 06:31:00 | AAPL | Stock | 195.99 | 195.99 | 195.99 | 195.99 | 101.0 |
| 2023-12-19 06:32:00 | AAPL | Stock | 195.98 | 195.98 | 195.98 | 195.98 | 189.0 |
| 2023-12-19 06:34:00 | AAPL | Stock | 196.0 | 196.0 | 196.0 | 196.0 | 100.0 |
| 2023-12-19 06:41:00 | AAPL | Stock | 196.0 | 196.0 | 196.0 | 196.0 | 108.0 |
| 2023-12-19 06:43:00 | AAPL | Stock | 196.0 | 196.0 | 196.0 | 196.0 | 100.0 |
| 2023-12-19 06:47:00 | AAPL | Stock | 196.0 | 196.0 | 196.0 | 196.0 | 668.0 |
| 2023-12-19 06:51:00 | AAPL | Stock | 195.99 | 195.99 | 195.99 | 195.99 | 680.0 |
| 2023-12-19 06:52:00 | AAPL | Stock | 196.0 | 196.1 | 196.0 | 196.1 | 2287.0 |
| 2023-12-19 06:53:00 | AAPL | Stock | 196.11 | 196.11 | 196.11 | 196.11 | 215.0 |
| 2023-12-19 06:56:00 | AAPL | Stock | 196.17 | 196.19 | 196.17 | 196.18 | 932.0 |
| 2023-12-19 06:58:00 | AAPL | Stock | 196.16 | 196.18 | 196.15 | 196.17 | 1215.0 |
| 2023-12-19 07:00:00 | AAPL | Stock | 196.07 | 196.07 | 196.07 | 196.07 | 183.0 |
| 2023-12-19 07:01:00 | AAPL | Stock | 196.01 | 196.04 | 196.0 | 196.0 | 590.0 |
| 2023-12-19 07:03:00 | AAPL | Stock | 196.0 | 196.0 | 196.0 | 196.0 | 105.0 |
| 2023-12-19 07:04:00 | AAPL | Stock | 196.0 | 196.0 | 196.0 | 196.0 | 250.0 |
| 2023-12-19 07:05:00 | AAPL | Stock | 195.99 | 196.0 | 195.99 | 196.0 | 1115.0 |
| 2023-12-19 07:08:00 | AAPL | Stock | 196.0 | 196.0 | 196.0 | 196.0 | 175.0 |
| 2023-12-19 07:09:00 | AAPL | Stock | 196.0 | 196.0 | 196.0 | 196.0 | 1600.0 |
| 2023-12-19 07:11:00 | AAPL | Stock | 196.0 | 196.0 | 196.0 | 196.0 | 200.0 |
| 2023-12-19 07:12:00 | AAPL | Stock | 196.06 | 196.19 | 196.06 | 196.19 | 760.0 |
| 2023-12-19 07:13:00 | AAPL | Stock | 196.22 | 196.22 | 196.22 | 196.22 | 337.0 |
| 2023-12-19 07:16:00 | AAPL | Stock | 196.29 | 196.29 | 196.29 | 196.29 | 150.0 |
| 2023-12-19 07:17:00 | AAPL | Stock | 196.28 | 196.3 | 196.25 | 196.3 | 1667.0 |
| 2023-12-19 07:18:00 | AAPL | Stock | 196.32 | 196.38 | 196.26 | 196.26 | 1218.0 |
| 2023-12-19 07:19:00 | AAPL | Stock | 196.25 | 196.25 | 196.25 | 196.25 | 341.0 |
| 2023-12-19 07:20:00 | AAPL | Stock | 196.18 | 196.18 | 196.15 | 196.15 | 1668.0 |
| 2023-12-19 07:21:00 | AAPL | Stock | 196.1 | 196.1 | 196.05 | 196.05 | 499.0 |
| 2023-12-19 07:22:00 | AAPL | Stock | 196.05 | 196.05 | 196.05 | 196.05 | 225.0 |
> showing 50 of 1,326,615 rows — these rows as CSV