PREVIEW / stock_5min / 2024-12-04
file: by_date/stock_5min/2024/2024-12-04.parquet size: 7.2 MB rows: 425,536 symbols: 683
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-12-04 04:00:00 | AAPL | Stock | 242.76 | 243.4 | 242.76 | 243.4 | 1851.0 |
| 2024-12-04 04:05:00 | AAPL | Stock | 243.39 | 243.41 | 243.39 | 243.41 | 522.0 |
| 2024-12-04 04:10:00 | AAPL | Stock | 243.45 | 243.69 | 243.45 | 243.6 | 2518.0 |
| 2024-12-04 04:15:00 | AAPL | Stock | 243.56 | 243.56 | 243.52 | 243.55 | 650.0 |
| 2024-12-04 04:20:00 | AAPL | Stock | 243.51 | 243.51 | 243.22 | 243.31 | 5134.0 |
| 2024-12-04 04:25:00 | AAPL | Stock | 243.37 | 243.46 | 243.37 | 243.4 | 2106.0 |
| 2024-12-04 04:30:00 | AAPL | Stock | 243.45 | 243.45 | 243.44 | 243.44 | 400.0 |
| 2024-12-04 04:35:00 | AAPL | Stock | 243.43 | 243.43 | 243.28 | 243.28 | 1595.0 |
| 2024-12-04 04:40:00 | AAPL | Stock | 243.25 | 243.25 | 243.25 | 243.25 | 300.0 |
| 2024-12-04 04:45:00 | AAPL | Stock | 243.22 | 243.26 | 243.22 | 243.26 | 564.0 |
| 2024-12-04 04:55:00 | AAPL | Stock | 243.24 | 243.24 | 243.24 | 243.24 | 300.0 |
| 2024-12-04 05:10:00 | AAPL | Stock | 243.2 | 243.21 | 243.2 | 243.2 | 3948.0 |
| 2024-12-04 05:15:00 | AAPL | Stock | 243.18 | 243.18 | 243.18 | 243.18 | 454.0 |
| 2024-12-04 05:30:00 | AAPL | Stock | 243.08 | 243.08 | 243.08 | 243.08 | 327.0 |
| 2024-12-04 05:40:00 | AAPL | Stock | 243.23 | 243.23 | 243.23 | 243.23 | 100.0 |
| 2024-12-04 05:50:00 | AAPL | Stock | 243.35 | 243.35 | 243.35 | 243.35 | 100.0 |
| 2024-12-04 06:05:00 | AAPL | Stock | 243.42 | 243.45 | 243.42 | 243.45 | 1671.0 |
| 2024-12-04 06:10:00 | AAPL | Stock | 243.46 | 243.6 | 243.46 | 243.59 | 2396.0 |
| 2024-12-04 06:15:00 | AAPL | Stock | 243.59 | 243.59 | 243.5 | 243.5 | 1017.0 |
| 2024-12-04 06:20:00 | AAPL | Stock | 243.48 | 243.48 | 243.48 | 243.48 | 449.0 |
| 2024-12-04 06:25:00 | AAPL | Stock | 243.47 | 243.47 | 243.11 | 243.11 | 8978.0 |
| 2024-12-04 06:30:00 | AAPL | Stock | 243.11 | 243.11 | 243.1 | 243.1 | 370.0 |
| 2024-12-04 06:35:00 | AAPL | Stock | 243.14 | 243.25 | 243.14 | 243.16 | 527.0 |
| 2024-12-04 06:40:00 | AAPL | Stock | 243.16 | 243.16 | 243.11 | 243.11 | 1167.0 |
| 2024-12-04 06:45:00 | AAPL | Stock | 243.1 | 243.1 | 243.0 | 243.0 | 1086.0 |
| 2024-12-04 06:50:00 | AAPL | Stock | 242.98 | 243.07 | 242.97 | 242.99 | 1222.0 |
| 2024-12-04 06:55:00 | AAPL | Stock | 243.0 | 243.01 | 243.0 | 243.0 | 300.0 |
| 2024-12-04 07:00:00 | AAPL | Stock | 243.01 | 243.34 | 242.94 | 243.34 | 8471.0 |
| 2024-12-04 07:05:00 | AAPL | Stock | 243.34 | 243.35 | 243.21 | 243.25 | 2166.0 |
| 2024-12-04 07:10:00 | AAPL | Stock | 243.22 | 243.22 | 243.15 | 243.15 | 1529.0 |
| 2024-12-04 07:15:00 | AAPL | Stock | 243.05 | 243.06 | 242.95 | 242.95 | 2168.0 |
| 2024-12-04 07:20:00 | AAPL | Stock | 242.96 | 242.96 | 242.95 | 242.96 | 1467.0 |
| 2024-12-04 07:25:00 | AAPL | Stock | 243.0 | 243.06 | 243.0 | 243.06 | 895.0 |
| 2024-12-04 07:30:00 | AAPL | Stock | 243.03 | 243.19 | 243.02 | 243.19 | 543.0 |
| 2024-12-04 07:35:00 | AAPL | Stock | 243.19 | 243.3 | 243.06 | 243.06 | 2804.0 |
| 2024-12-04 07:40:00 | AAPL | Stock | 243.06 | 243.07 | 243.04 | 243.07 | 1966.0 |
| 2024-12-04 07:45:00 | AAPL | Stock | 243.15 | 243.16 | 243.15 | 243.16 | 211.0 |
| 2024-12-04 07:50:00 | AAPL | Stock | 243.1 | 243.12 | 243.1 | 243.12 | 390.0 |
| 2024-12-04 07:55:00 | AAPL | Stock | 243.07 | 243.08 | 243.05 | 243.08 | 739.0 |
| 2024-12-04 08:00:00 | AAPL | Stock | 242.99 | 243.35 | 242.044 | 243.18 | 36162.0 |
| 2024-12-04 08:05:00 | AAPL | Stock | 243.18 | 243.18 | 243.14 | 243.18 | 6090.0 |
| 2024-12-04 08:10:00 | AAPL | Stock | 243.2 | 243.23 | 243.2 | 243.22 | 3804.0 |
| 2024-12-04 08:15:00 | AAPL | Stock | 243.2 | 243.2 | 243.12 | 243.1883 | 10370.0 |
| 2024-12-04 08:20:00 | AAPL | Stock | 243.1501 | 243.2 | 243.1 | 243.12 | 4813.0 |
| 2024-12-04 08:25:00 | AAPL | Stock | 243.1 | 243.12 | 243.1 | 243.1 | 3431.0 |
| 2024-12-04 08:30:00 | AAPL | Stock | 243.1 | 243.12 | 242.65 | 243.05 | 157447.0 |
| 2024-12-04 08:35:00 | AAPL | Stock | 243.04 | 243.2 | 243.04 | 243.2 | 11301.0 |
| 2024-12-04 08:40:00 | AAPL | Stock | 243.1992 | 243.22 | 243.05 | 243.1383 | 5326.0 |
| 2024-12-04 08:45:00 | AAPL | Stock | 243.216 | 243.23 | 243.15 | 243.22 | 5791.0 |
| 2024-12-04 08:50:00 | AAPL | Stock | 243.19 | 243.27 | 243.19 | 243.27 | 3636.0 |
> showing 50 of 425,536 rows — these rows as CSV