PREVIEW / stock_5min / 2024-10-16
file: by_date/stock_5min/2024/2024-10-16.parquet size: 6.8 MB rows: 406,054 symbols: 777
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-16 04:00:00 | AAPL | Stock | 234.34 | 234.44 | 234.2 | 234.2 | 1342.0 |
| 2024-10-16 04:05:00 | AAPL | Stock | 234.21 | 234.25 | 234.21 | 234.25 | 511.0 |
| 2024-10-16 04:10:00 | AAPL | Stock | 234.17 | 234.17 | 234.17 | 234.17 | 4160.0 |
| 2024-10-16 04:15:00 | AAPL | Stock | 234.2 | 234.2 | 234.1 | 234.1 | 800.0 |
| 2024-10-16 04:20:00 | AAPL | Stock | 234.31 | 234.31 | 234.1 | 234.1 | 826.0 |
| 2024-10-16 04:25:00 | AAPL | Stock | 234.12 | 234.12 | 234.11 | 234.11 | 436.0 |
| 2024-10-16 04:30:00 | AAPL | Stock | 234.23 | 234.23 | 234.08 | 234.19 | 392.0 |
| 2024-10-16 04:35:00 | AAPL | Stock | 234.12 | 234.23 | 234.12 | 234.23 | 650.0 |
| 2024-10-16 04:45:00 | AAPL | Stock | 234.2 | 234.2 | 234.15 | 234.15 | 316.0 |
| 2024-10-16 05:00:00 | AAPL | Stock | 234.18 | 234.2 | 234.18 | 234.2 | 687.0 |
| 2024-10-16 05:05:00 | AAPL | Stock | 234.2 | 234.2 | 234.2 | 234.2 | 100.0 |
| 2024-10-16 05:10:00 | AAPL | Stock | 234.25 | 234.25 | 234.25 | 234.25 | 113.0 |
| 2024-10-16 05:20:00 | AAPL | Stock | 234.18 | 234.18 | 234.12 | 234.12 | 523.0 |
| 2024-10-16 05:25:00 | AAPL | Stock | 234.11 | 234.11 | 234.11 | 234.11 | 250.0 |
| 2024-10-16 05:30:00 | AAPL | Stock | 234.03 | 234.03 | 233.39 | 233.4 | 3215.0 |
| 2024-10-16 05:35:00 | AAPL | Stock | 233.29 | 233.43 | 233.0 | 233.43 | 2188.0 |
| 2024-10-16 05:40:00 | AAPL | Stock | 233.29 | 233.39 | 233.29 | 233.3 | 650.0 |
| 2024-10-16 05:45:00 | AAPL | Stock | 233.54 | 233.54 | 233.54 | 233.54 | 210.0 |
| 2024-10-16 06:20:00 | AAPL | Stock | 233.46 | 233.54 | 233.46 | 233.53 | 1429.0 |
| 2024-10-16 06:25:00 | AAPL | Stock | 233.44 | 233.5 | 233.42 | 233.5 | 1099.0 |
| 2024-10-16 06:35:00 | AAPL | Stock | 233.48 | 233.52 | 233.48 | 233.51 | 477.0 |
| 2024-10-16 06:40:00 | AAPL | Stock | 233.54 | 233.54 | 233.54 | 233.54 | 149.0 |
| 2024-10-16 06:45:00 | AAPL | Stock | 233.68 | 233.74 | 233.65 | 233.65 | 1717.0 |
| 2024-10-16 06:55:00 | AAPL | Stock | 233.56 | 233.56 | 233.55 | 233.55 | 444.0 |
| 2024-10-16 07:00:00 | AAPL | Stock | 233.69 | 233.8 | 233.69 | 233.8 | 1516.0 |
| 2024-10-16 07:05:00 | AAPL | Stock | 233.73 | 233.79 | 233.69 | 233.79 | 2780.0 |
| 2024-10-16 07:10:00 | AAPL | Stock | 233.79 | 234.04 | 233.79 | 234.04 | 956.0 |
| 2024-10-16 07:15:00 | AAPL | Stock | 234.1 | 234.15 | 234.1 | 234.14 | 859.0 |
| 2024-10-16 07:20:00 | AAPL | Stock | 234.1 | 234.23 | 234.1 | 234.23 | 2925.0 |
| 2024-10-16 07:25:00 | AAPL | Stock | 234.17 | 234.19 | 234.1 | 234.19 | 589.0 |
| 2024-10-16 07:30:00 | AAPL | Stock | 234.2 | 234.2 | 234.15 | 234.2 | 1729.0 |
| 2024-10-16 07:35:00 | AAPL | Stock | 234.2 | 234.22 | 234.02 | 234.02 | 1749.0 |
| 2024-10-16 07:40:00 | AAPL | Stock | 234.02 | 234.05 | 233.85 | 233.86 | 4450.0 |
| 2024-10-16 07:45:00 | AAPL | Stock | 233.99 | 234.12 | 233.99 | 234.09 | 2267.0 |
| 2024-10-16 07:50:00 | AAPL | Stock | 234.0 | 234.0 | 233.92 | 233.92 | 429.0 |
| 2024-10-16 07:55:00 | AAPL | Stock | 233.95 | 233.95 | 233.94 | 233.95 | 996.0 |
| 2024-10-16 08:00:00 | AAPL | Stock | 233.8 | 234.15 | 233.5371 | 233.83 | 32232.0 |
| 2024-10-16 08:05:00 | AAPL | Stock | 233.78 | 233.78 | 233.5712 | 233.6935 | 8196.0 |
| 2024-10-16 08:10:00 | AAPL | Stock | 233.693 | 233.7 | 232.91 | 232.97 | 30215.0 |
| 2024-10-16 08:15:00 | AAPL | Stock | 233.0 | 233.0 | 232.92 | 232.98 | 15202.0 |
| 2024-10-16 08:20:00 | AAPL | Stock | 232.95 | 233.0 | 232.9 | 232.96 | 4246.0 |
| 2024-10-16 08:25:00 | AAPL | Stock | 232.999 | 233.0 | 232.84 | 233.0 | 7651.0 |
| 2024-10-16 08:30:00 | AAPL | Stock | 232.9513 | 233.0 | 232.91 | 233.0 | 5255.0 |
| 2024-10-16 08:35:00 | AAPL | Stock | 233.0 | 233.0 | 232.864 | 232.94 | 6714.0 |
| 2024-10-16 08:40:00 | AAPL | Stock | 233.0 | 233.0 | 232.8502 | 232.8513 | 4471.0 |
| 2024-10-16 08:45:00 | AAPL | Stock | 232.88 | 233.0 | 232.8515 | 233.0 | 7031.0 |
| 2024-10-16 08:50:00 | AAPL | Stock | 233.0 | 233.02 | 232.89 | 232.9204 | 11503.0 |
| 2024-10-16 08:55:00 | AAPL | Stock | 232.95 | 232.95 | 232.84 | 232.91 | 11444.0 |
| 2024-10-16 09:00:00 | AAPL | Stock | 232.91 | 233.22 | 232.89 | 232.89 | 6937.0 |
| 2024-10-16 09:05:00 | AAPL | Stock | 233.1 | 233.1531 | 233.0 | 233.08 | 4831.0 |
> showing 50 of 406,054 rows — these rows as CSV