PREVIEW / stock_1min / 2024-10-24
file: by_date/stock_1min/2024/2024-10-24.parquet size: 21.1 MB rows: 1,220,525 symbols: 723
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-10-24 04:00:00 | AAPL | Stock | 230.66 | 231.32 | 230.66 | 231.32 | 442.0 |
| 2024-10-24 04:01:00 | AAPL | Stock | 231.48 | 231.48 | 231.34 | 231.47 | 592.0 |
| 2024-10-24 04:03:00 | AAPL | Stock | 231.4 | 231.4 | 231.39 | 231.39 | 1061.0 |
| 2024-10-24 04:04:00 | AAPL | Stock | 231.37 | 231.39 | 231.34 | 231.39 | 917.0 |
| 2024-10-24 04:05:00 | AAPL | Stock | 231.4 | 231.4 | 231.4 | 231.4 | 382.0 |
| 2024-10-24 04:06:00 | AAPL | Stock | 231.4 | 231.45 | 231.34 | 231.4 | 1520.0 |
| 2024-10-24 04:08:00 | AAPL | Stock | 231.4 | 231.4 | 231.4 | 231.4 | 216.0 |
| 2024-10-24 04:09:00 | AAPL | Stock | 231.4 | 231.4 | 231.4 | 231.4 | 100.0 |
| 2024-10-24 04:10:00 | AAPL | Stock | 231.34 | 231.4 | 231.34 | 231.4 | 203.0 |
| 2024-10-24 04:11:00 | AAPL | Stock | 231.37 | 231.4 | 231.35 | 231.35 | 1560.0 |
| 2024-10-24 04:13:00 | AAPL | Stock | 231.4 | 231.4 | 231.4 | 231.4 | 1172.0 |
| 2024-10-24 04:14:00 | AAPL | Stock | 231.4 | 231.4 | 231.4 | 231.4 | 100.0 |
| 2024-10-24 04:15:00 | AAPL | Stock | 231.4 | 231.4 | 231.4 | 231.4 | 100.0 |
| 2024-10-24 04:16:00 | AAPL | Stock | 231.4 | 231.4 | 231.4 | 231.4 | 200.0 |
| 2024-10-24 04:17:00 | AAPL | Stock | 231.37 | 231.37 | 231.37 | 231.37 | 111.0 |
| 2024-10-24 04:19:00 | AAPL | Stock | 231.4 | 231.4 | 231.4 | 231.4 | 543.0 |
| 2024-10-24 04:23:00 | AAPL | Stock | 231.4 | 231.4 | 231.38 | 231.38 | 1372.0 |
| 2024-10-24 04:24:00 | AAPL | Stock | 231.4 | 231.4 | 231.4 | 231.4 | 200.0 |
| 2024-10-24 04:25:00 | AAPL | Stock | 231.37 | 231.37 | 231.37 | 231.37 | 100.0 |
| 2024-10-24 04:28:00 | AAPL | Stock | 231.4 | 231.4 | 231.39 | 231.39 | 346.0 |
| 2024-10-24 04:29:00 | AAPL | Stock | 231.38 | 231.38 | 231.38 | 231.38 | 125.0 |
| 2024-10-24 04:30:00 | AAPL | Stock | 231.38 | 231.38 | 231.38 | 231.38 | 118.0 |
| 2024-10-24 04:31:00 | AAPL | Stock | 231.4 | 231.4 | 231.4 | 231.4 | 100.0 |
| 2024-10-24 04:34:00 | AAPL | Stock | 231.37 | 231.37 | 231.36 | 231.36 | 350.0 |
| 2024-10-24 04:35:00 | AAPL | Stock | 231.36 | 231.36 | 231.36 | 231.36 | 601.0 |
| 2024-10-24 04:37:00 | AAPL | Stock | 231.37 | 231.37 | 231.37 | 231.37 | 100.0 |
| 2024-10-24 04:38:00 | AAPL | Stock | 231.37 | 231.37 | 231.37 | 231.37 | 500.0 |
| 2024-10-24 04:39:00 | AAPL | Stock | 231.37 | 231.37 | 231.37 | 231.37 | 100.0 |
| 2024-10-24 04:42:00 | AAPL | Stock | 231.33 | 231.37 | 231.33 | 231.37 | 1748.0 |
| 2024-10-24 04:46:00 | AAPL | Stock | 231.32 | 231.32 | 231.3 | 231.3 | 767.0 |
| 2024-10-24 04:47:00 | AAPL | Stock | 231.3 | 231.3 | 231.2 | 231.2 | 1839.0 |
| 2024-10-24 04:48:00 | AAPL | Stock | 231.2 | 231.2 | 231.2 | 231.2 | 408.0 |
| 2024-10-24 05:01:00 | AAPL | Stock | 231.28 | 231.28 | 231.28 | 231.28 | 116.0 |
| 2024-10-24 05:02:00 | AAPL | Stock | 231.21 | 231.21 | 231.21 | 231.21 | 102.0 |
| 2024-10-24 05:03:00 | AAPL | Stock | 231.29 | 231.3 | 231.29 | 231.3 | 350.0 |
| 2024-10-24 05:04:00 | AAPL | Stock | 231.32 | 231.32 | 231.31 | 231.31 | 390.0 |
| 2024-10-24 05:05:00 | AAPL | Stock | 231.31 | 231.31 | 231.21 | 231.21 | 1453.0 |
| 2024-10-24 05:08:00 | AAPL | Stock | 231.38 | 231.38 | 231.38 | 231.38 | 100.0 |
| 2024-10-24 05:16:00 | AAPL | Stock | 231.38 | 231.38 | 231.38 | 231.38 | 414.0 |
| 2024-10-24 05:18:00 | AAPL | Stock | 231.38 | 231.38 | 231.36 | 231.36 | 2928.0 |
| 2024-10-24 05:22:00 | AAPL | Stock | 231.36 | 231.36 | 231.36 | 231.36 | 100.0 |
| 2024-10-24 05:25:00 | AAPL | Stock | 231.38 | 231.38 | 231.38 | 231.38 | 100.0 |
| 2024-10-24 05:35:00 | AAPL | Stock | 231.32 | 231.32 | 231.32 | 231.32 | 100.0 |
| 2024-10-24 05:55:00 | AAPL | Stock | 231.29 | 231.34 | 231.28 | 231.34 | 579.0 |
| 2024-10-24 06:12:00 | AAPL | Stock | 231.36 | 231.36 | 231.36 | 231.36 | 121.0 |
| 2024-10-24 06:15:00 | AAPL | Stock | 231.38 | 231.38 | 231.38 | 231.38 | 100.0 |
| 2024-10-24 06:22:00 | AAPL | Stock | 231.38 | 231.38 | 231.38 | 231.38 | 1019.0 |
| 2024-10-24 06:25:00 | AAPL | Stock | 231.38 | 231.38 | 231.38 | 231.38 | 100.0 |
| 2024-10-24 06:35:00 | AAPL | Stock | 231.44 | 231.44 | 231.44 | 231.44 | 200.0 |
| 2024-10-24 06:43:00 | AAPL | Stock | 231.45 | 231.45 | 231.45 | 231.45 | 300.0 |
> showing 50 of 1,220,525 rows — these rows as CSV