PREVIEW / stock_1min / 2024-09-25
file: by_date/stock_1min/2024/2024-09-25.parquet size: 20.3 MB rows: 1,203,581 symbols: 793
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-09-25 04:00:00 | AAPL | Stock | 226.98 | 226.98 | 225.74 | 225.74 | 6860.0 |
| 2024-09-25 04:01:00 | AAPL | Stock | 225.51 | 226.0 | 225.51 | 226.0 | 1397.0 |
| 2024-09-25 04:02:00 | AAPL | Stock | 226.25 | 226.25 | 226.0 | 226.0 | 677.0 |
| 2024-09-25 04:03:00 | AAPL | Stock | 226.36 | 226.36 | 226.36 | 226.36 | 377.0 |
| 2024-09-25 04:04:00 | AAPL | Stock | 226.06 | 226.06 | 226.06 | 226.06 | 747.0 |
| 2024-09-25 04:05:00 | AAPL | Stock | 226.06 | 226.11 | 226.06 | 226.11 | 549.0 |
| 2024-09-25 04:06:00 | AAPL | Stock | 226.25 | 226.25 | 226.2 | 226.2 | 656.0 |
| 2024-09-25 04:08:00 | AAPL | Stock | 226.27 | 226.27 | 226.27 | 226.27 | 100.0 |
| 2024-09-25 04:09:00 | AAPL | Stock | 226.21 | 226.21 | 226.21 | 226.21 | 441.0 |
| 2024-09-25 04:13:00 | AAPL | Stock | 226.4 | 226.45 | 226.4 | 226.41 | 2336.0 |
| 2024-09-25 04:19:00 | AAPL | Stock | 226.4 | 226.4 | 226.3 | 226.3 | 650.0 |
| 2024-09-25 04:20:00 | AAPL | Stock | 226.27 | 226.27 | 226.19 | 226.19 | 1155.0 |
| 2024-09-25 04:21:00 | AAPL | Stock | 226.07 | 226.07 | 226.01 | 226.06 | 753.0 |
| 2024-09-25 04:29:00 | AAPL | Stock | 226.21 | 226.21 | 226.1 | 226.1 | 795.0 |
| 2024-09-25 04:30:00 | AAPL | Stock | 226.13 | 226.13 | 226.13 | 226.13 | 115.0 |
| 2024-09-25 04:31:00 | AAPL | Stock | 226.11 | 226.11 | 226.0 | 226.1 | 3820.0 |
| 2024-09-25 04:32:00 | AAPL | Stock | 226.09 | 226.09 | 226.09 | 226.09 | 100.0 |
| 2024-09-25 04:34:00 | AAPL | Stock | 226.01 | 226.01 | 225.85 | 225.85 | 1990.0 |
| 2024-09-25 04:38:00 | AAPL | Stock | 226.02 | 226.02 | 226.02 | 226.02 | 619.0 |
| 2024-09-25 04:40:00 | AAPL | Stock | 225.91 | 225.91 | 225.91 | 225.91 | 104.0 |
| 2024-09-25 04:41:00 | AAPL | Stock | 225.86 | 225.86 | 225.7 | 225.7 | 2545.0 |
| 2024-09-25 04:43:00 | AAPL | Stock | 225.76 | 225.76 | 225.76 | 225.76 | 200.0 |
| 2024-09-25 04:44:00 | AAPL | Stock | 225.75 | 225.75 | 225.75 | 225.75 | 100.0 |
| 2024-09-25 04:55:00 | AAPL | Stock | 225.89 | 225.89 | 225.88 | 225.88 | 999.0 |
| 2024-09-25 05:04:00 | AAPL | Stock | 225.98 | 225.98 | 225.98 | 225.98 | 100.0 |
| 2024-09-25 05:07:00 | AAPL | Stock | 225.92 | 225.92 | 225.88 | 225.88 | 961.0 |
| 2024-09-25 05:08:00 | AAPL | Stock | 225.89 | 225.89 | 225.89 | 225.89 | 100.0 |
| 2024-09-25 05:09:00 | AAPL | Stock | 225.89 | 225.89 | 225.89 | 225.89 | 200.0 |
| 2024-09-25 05:10:00 | AAPL | Stock | 225.89 | 225.89 | 225.89 | 225.89 | 100.0 |
| 2024-09-25 05:11:00 | AAPL | Stock | 225.89 | 225.9 | 225.89 | 225.9 | 2000.0 |
| 2024-09-25 05:12:00 | AAPL | Stock | 225.89 | 225.89 | 225.89 | 225.89 | 105.0 |
| 2024-09-25 05:13:00 | AAPL | Stock | 225.9 | 225.9 | 225.9 | 225.9 | 200.0 |
| 2024-09-25 05:15:00 | AAPL | Stock | 225.89 | 225.89 | 225.89 | 225.89 | 1000.0 |
| 2024-09-25 05:19:00 | AAPL | Stock | 225.87 | 225.87 | 225.86 | 225.86 | 449.0 |
| 2024-09-25 05:21:00 | AAPL | Stock | 225.87 | 225.87 | 225.87 | 225.87 | 200.0 |
| 2024-09-25 05:22:00 | AAPL | Stock | 225.8 | 225.8 | 225.78 | 225.78 | 300.0 |
| 2024-09-25 05:32:00 | AAPL | Stock | 226.0 | 226.0 | 226.0 | 226.0 | 133.0 |
| 2024-09-25 05:35:00 | AAPL | Stock | 226.05 | 226.05 | 226.05 | 226.05 | 100.0 |
| 2024-09-25 05:45:00 | AAPL | Stock | 225.96 | 225.96 | 225.9 | 225.9 | 977.0 |
| 2024-09-25 05:50:00 | AAPL | Stock | 225.9 | 225.9 | 225.9 | 225.9 | 100.0 |
| 2024-09-25 05:51:00 | AAPL | Stock | 225.91 | 225.91 | 225.91 | 225.91 | 200.0 |
| 2024-09-25 05:52:00 | AAPL | Stock | 225.91 | 225.91 | 225.88 | 225.88 | 400.0 |
| 2024-09-25 05:55:00 | AAPL | Stock | 225.88 | 225.88 | 225.88 | 225.88 | 116.0 |
| 2024-09-25 05:56:00 | AAPL | Stock | 225.85 | 225.85 | 225.8 | 225.8 | 6392.0 |
| 2024-09-25 05:57:00 | AAPL | Stock | 225.82 | 225.82 | 225.81 | 225.81 | 584.0 |
| 2024-09-25 05:59:00 | AAPL | Stock | 225.84 | 225.84 | 225.84 | 225.84 | 100.0 |
| 2024-09-25 06:01:00 | AAPL | Stock | 225.97 | 226.0 | 225.8 | 225.98 | 3389.0 |
| 2024-09-25 06:02:00 | AAPL | Stock | 226.02 | 226.18 | 225.93 | 225.93 | 8290.0 |
| 2024-09-25 06:03:00 | AAPL | Stock | 226.07 | 226.09 | 226.07 | 226.09 | 721.0 |
| 2024-09-25 06:04:00 | AAPL | Stock | 226.09 | 226.1 | 226.0 | 226.02 | 2405.0 |
> showing 50 of 1,203,581 rows — these rows as CSV