PREVIEW / stock_1min / 2024-03-06
file: by_date/stock_1min/2024/2024-03-06.parquet size: 22.1 MB rows: 1,319,532 symbols: 1,116
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 |
|---|---|---|---|---|---|---|---|
| 2024-03-06 04:00:00 | AAPL | Stock | 170.12 | 172.0 | 169.63 | 170.74 | 6893.0 |
| 2024-03-06 04:01:00 | AAPL | Stock | 170.66 | 170.8 | 170.65 | 170.8 | 4574.0 |
| 2024-03-06 04:02:00 | AAPL | Stock | 170.94 | 170.94 | 170.78 | 170.78 | 261.0 |
| 2024-03-06 04:03:00 | AAPL | Stock | 170.83 | 170.85 | 170.83 | 170.85 | 760.0 |
| 2024-03-06 04:04:00 | AAPL | Stock | 170.93 | 170.96 | 170.91 | 170.96 | 1250.0 |
| 2024-03-06 04:05:00 | AAPL | Stock | 170.98 | 170.98 | 170.92 | 170.92 | 1656.0 |
| 2024-03-06 04:06:00 | AAPL | Stock | 170.92 | 171.0 | 170.92 | 170.99 | 2449.0 |
| 2024-03-06 04:07:00 | AAPL | Stock | 170.95 | 170.95 | 170.95 | 170.95 | 300.0 |
| 2024-03-06 04:08:00 | AAPL | Stock | 170.94 | 170.95 | 170.92 | 170.92 | 2179.0 |
| 2024-03-06 04:11:00 | AAPL | Stock | 170.88 | 170.9 | 170.88 | 170.9 | 501.0 |
| 2024-03-06 04:12:00 | AAPL | Stock | 170.89 | 170.89 | 170.89 | 170.89 | 140.0 |
| 2024-03-06 04:13:00 | AAPL | Stock | 170.89 | 170.89 | 170.88 | 170.88 | 559.0 |
| 2024-03-06 04:14:00 | AAPL | Stock | 170.91 | 170.91 | 170.89 | 170.89 | 925.0 |
| 2024-03-06 04:15:00 | AAPL | Stock | 170.9 | 170.93 | 170.9 | 170.93 | 1078.0 |
| 2024-03-06 04:17:00 | AAPL | Stock | 170.93 | 171.0 | 170.93 | 171.0 | 1221.0 |
| 2024-03-06 04:18:00 | AAPL | Stock | 171.14 | 171.14 | 171.14 | 171.14 | 300.0 |
| 2024-03-06 04:20:00 | AAPL | Stock | 171.0 | 171.04 | 171.0 | 171.04 | 602.0 |
| 2024-03-06 04:21:00 | AAPL | Stock | 171.0 | 171.04 | 171.0 | 171.04 | 1172.0 |
| 2024-03-06 04:22:00 | AAPL | Stock | 170.97 | 170.97 | 170.84 | 170.96 | 2602.0 |
| 2024-03-06 04:23:00 | AAPL | Stock | 170.85 | 170.85 | 170.85 | 170.85 | 100.0 |
| 2024-03-06 04:25:00 | AAPL | Stock | 170.9 | 170.9 | 170.9 | 170.9 | 107.0 |
| 2024-03-06 04:26:00 | AAPL | Stock | 170.91 | 170.91 | 170.89 | 170.89 | 993.0 |
| 2024-03-06 04:27:00 | AAPL | Stock | 170.89 | 170.89 | 170.89 | 170.89 | 940.0 |
| 2024-03-06 04:28:00 | AAPL | Stock | 170.9 | 170.9 | 170.9 | 170.9 | 102.0 |
| 2024-03-06 04:29:00 | AAPL | Stock | 170.9 | 170.99 | 170.9 | 170.99 | 465.0 |
| 2024-03-06 04:30:00 | AAPL | Stock | 170.9 | 170.9 | 170.9 | 170.9 | 238.0 |
| 2024-03-06 04:32:00 | AAPL | Stock | 171.0 | 171.0 | 171.0 | 171.0 | 482.0 |
| 2024-03-06 04:33:00 | AAPL | Stock | 171.0 | 171.0 | 171.0 | 171.0 | 100.0 |
| 2024-03-06 04:34:00 | AAPL | Stock | 171.02 | 171.02 | 171.02 | 171.02 | 100.0 |
| 2024-03-06 04:36:00 | AAPL | Stock | 171.04 | 171.04 | 171.04 | 171.04 | 154.0 |
| 2024-03-06 04:37:00 | AAPL | Stock | 171.05 | 171.05 | 171.04 | 171.04 | 1038.0 |
| 2024-03-06 04:38:00 | AAPL | Stock | 171.04 | 171.05 | 171.04 | 171.05 | 4598.0 |
| 2024-03-06 04:39:00 | AAPL | Stock | 171.05 | 171.05 | 171.05 | 171.05 | 738.0 |
| 2024-03-06 04:40:00 | AAPL | Stock | 171.1 | 171.14 | 171.1 | 171.14 | 513.0 |
| 2024-03-06 04:49:00 | AAPL | Stock | 171.0 | 171.0 | 170.95 | 171.0 | 2595.0 |
| 2024-03-06 04:50:00 | AAPL | Stock | 170.9 | 170.96 | 170.9 | 170.96 | 264.0 |
| 2024-03-06 04:51:00 | AAPL | Stock | 170.98 | 170.98 | 170.98 | 170.98 | 238.0 |
| 2024-03-06 04:56:00 | AAPL | Stock | 171.0 | 171.0 | 171.0 | 171.0 | 330.0 |
| 2024-03-06 04:57:00 | AAPL | Stock | 171.0 | 171.0 | 170.99 | 170.99 | 379.0 |
| 2024-03-06 05:01:00 | AAPL | Stock | 171.05 | 171.05 | 171.04 | 171.04 | 700.0 |
| 2024-03-06 05:02:00 | AAPL | Stock | 171.05 | 171.05 | 171.05 | 171.05 | 154.0 |
| 2024-03-06 05:04:00 | AAPL | Stock | 171.05 | 171.05 | 171.04 | 171.04 | 643.0 |
| 2024-03-06 05:06:00 | AAPL | Stock | 171.03 | 171.03 | 171.03 | 171.03 | 135.0 |
| 2024-03-06 05:09:00 | AAPL | Stock | 171.06 | 171.06 | 171.06 | 171.06 | 470.0 |
| 2024-03-06 05:10:00 | AAPL | Stock | 171.06 | 171.06 | 171.06 | 171.06 | 404.0 |
| 2024-03-06 05:11:00 | AAPL | Stock | 171.06 | 171.06 | 171.03 | 171.03 | 233.0 |
| 2024-03-06 05:12:00 | AAPL | Stock | 171.07 | 171.1 | 171.07 | 171.1 | 1325.0 |
| 2024-03-06 05:13:00 | AAPL | Stock | 171.03 | 171.03 | 171.03 | 171.03 | 337.0 |
| 2024-03-06 05:14:00 | AAPL | Stock | 171.08 | 171.1 | 171.08 | 171.1 | 775.0 |
| 2024-03-06 05:15:00 | AAPL | Stock | 171.08 | 171.08 | 171.08 | 171.08 | 140.0 |
> showing 50 of 1,319,532 rows — these rows as CSV