PREVIEW / stock_1min / 2024-04-30
file: by_date/stock_1min/2024/2024-04-30.parquet size: 20.2 MB rows: 1,229,805 symbols: 979
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-04-30 04:00:00 | AAPL | Stock | 173.22 | 173.74 | 173.12 | 173.74 | 1057.0 |
| 2024-04-30 04:01:00 | AAPL | Stock | 173.74 | 173.74 | 173.74 | 173.74 | 100.0 |
| 2024-04-30 04:02:00 | AAPL | Stock | 173.74 | 173.74 | 173.63 | 173.63 | 204.0 |
| 2024-04-30 04:07:00 | AAPL | Stock | 173.68 | 173.68 | 173.68 | 173.68 | 237.0 |
| 2024-04-30 04:08:00 | AAPL | Stock | 173.68 | 173.68 | 173.68 | 173.68 | 402.0 |
| 2024-04-30 04:09:00 | AAPL | Stock | 173.64 | 173.64 | 173.59 | 173.63 | 350.0 |
| 2024-04-30 04:10:00 | AAPL | Stock | 173.64 | 173.68 | 173.64 | 173.65 | 1873.0 |
| 2024-04-30 04:12:00 | AAPL | Stock | 173.66 | 173.66 | 173.66 | 173.66 | 251.0 |
| 2024-04-30 04:14:00 | AAPL | Stock | 173.68 | 173.68 | 173.68 | 173.68 | 100.0 |
| 2024-04-30 04:16:00 | AAPL | Stock | 173.68 | 173.69 | 173.68 | 173.69 | 200.0 |
| 2024-04-30 04:17:00 | AAPL | Stock | 173.73 | 173.74 | 173.73 | 173.74 | 1971.0 |
| 2024-04-30 04:18:00 | AAPL | Stock | 173.74 | 173.74 | 173.74 | 173.74 | 200.0 |
| 2024-04-30 04:19:00 | AAPL | Stock | 173.74 | 173.87 | 173.74 | 173.87 | 1270.0 |
| 2024-04-30 04:21:00 | AAPL | Stock | 173.85 | 173.85 | 173.85 | 173.85 | 300.0 |
| 2024-04-30 04:23:00 | AAPL | Stock | 173.85 | 173.85 | 173.85 | 173.85 | 100.0 |
| 2024-04-30 04:26:00 | AAPL | Stock | 173.84 | 173.85 | 173.84 | 173.85 | 258.0 |
| 2024-04-30 04:27:00 | AAPL | Stock | 173.85 | 173.85 | 173.85 | 173.85 | 500.0 |
| 2024-04-30 04:28:00 | AAPL | Stock | 173.96 | 173.97 | 173.96 | 173.97 | 229.0 |
| 2024-04-30 04:29:00 | AAPL | Stock | 173.85 | 173.85 | 173.85 | 173.85 | 177.0 |
| 2024-04-30 04:33:00 | AAPL | Stock | 173.95 | 173.95 | 173.95 | 173.95 | 688.0 |
| 2024-04-30 04:34:00 | AAPL | Stock | 173.99 | 173.99 | 173.99 | 173.99 | 254.0 |
| 2024-04-30 04:39:00 | AAPL | Stock | 174.06 | 174.06 | 174.06 | 174.06 | 162.0 |
| 2024-04-30 04:40:00 | AAPL | Stock | 174.05 | 174.05 | 174.05 | 174.05 | 100.0 |
| 2024-04-30 04:49:00 | AAPL | Stock | 174.02 | 174.02 | 173.97 | 173.97 | 548.0 |
| 2024-04-30 05:00:00 | AAPL | Stock | 173.95 | 173.95 | 173.95 | 173.95 | 403.0 |
| 2024-04-30 05:01:00 | AAPL | Stock | 173.95 | 173.98 | 173.95 | 173.98 | 600.0 |
| 2024-04-30 05:03:00 | AAPL | Stock | 174.04 | 174.09 | 174.04 | 174.09 | 1302.0 |
| 2024-04-30 05:08:00 | AAPL | Stock | 174.05 | 174.05 | 174.05 | 174.05 | 200.0 |
| 2024-04-30 05:19:00 | AAPL | Stock | 174.01 | 174.01 | 174.01 | 174.01 | 125.0 |
| 2024-04-30 05:22:00 | AAPL | Stock | 174.0 | 174.05 | 174.0 | 174.05 | 838.0 |
| 2024-04-30 05:32:00 | AAPL | Stock | 174.08 | 174.12 | 174.08 | 174.12 | 404.0 |
| 2024-04-30 05:39:00 | AAPL | Stock | 174.09 | 174.5 | 174.09 | 174.5 | 11116.0 |
| 2024-04-30 05:42:00 | AAPL | Stock | 174.4 | 174.4 | 174.4 | 174.4 | 266.0 |
| 2024-04-30 05:43:00 | AAPL | Stock | 174.42 | 174.42 | 174.42 | 174.42 | 190.0 |
| 2024-04-30 05:44:00 | AAPL | Stock | 174.41 | 174.41 | 174.41 | 174.41 | 340.0 |
| 2024-04-30 05:50:00 | AAPL | Stock | 174.42 | 174.42 | 174.42 | 174.42 | 150.0 |
| 2024-04-30 05:51:00 | AAPL | Stock | 174.4 | 174.4 | 174.4 | 174.4 | 100.0 |
| 2024-04-30 05:52:00 | AAPL | Stock | 174.35 | 174.35 | 174.35 | 174.35 | 463.0 |
| 2024-04-30 05:54:00 | AAPL | Stock | 174.2 | 174.2 | 174.2 | 174.2 | 290.0 |
| 2024-04-30 06:01:00 | AAPL | Stock | 174.36 | 174.36 | 174.35 | 174.35 | 297.0 |
| 2024-04-30 06:02:00 | AAPL | Stock | 174.3 | 174.3 | 174.3 | 174.3 | 100.0 |
| 2024-04-30 06:05:00 | AAPL | Stock | 174.35 | 174.35 | 174.35 | 174.35 | 133.0 |
| 2024-04-30 06:07:00 | AAPL | Stock | 174.32 | 174.32 | 174.32 | 174.32 | 350.0 |
| 2024-04-30 06:13:00 | AAPL | Stock | 174.35 | 174.39 | 174.35 | 174.39 | 963.0 |
| 2024-04-30 06:15:00 | AAPL | Stock | 174.4 | 174.4 | 174.4 | 174.4 | 827.0 |
| 2024-04-30 06:18:00 | AAPL | Stock | 174.39 | 174.39 | 174.38 | 174.38 | 596.0 |
| 2024-04-30 06:19:00 | AAPL | Stock | 174.34 | 174.34 | 174.31 | 174.31 | 1133.0 |
| 2024-04-30 06:21:00 | AAPL | Stock | 174.31 | 174.31 | 174.31 | 174.31 | 100.0 |
| 2024-04-30 06:22:00 | AAPL | Stock | 174.31 | 174.31 | 174.31 | 174.31 | 100.0 |
| 2024-04-30 06:24:00 | AAPL | Stock | 174.31 | 174.39 | 174.31 | 174.31 | 1628.0 |
> showing 50 of 1,229,805 rows — these rows as CSV