PREVIEW / stock_5min / 2024-10-08
file: by_date/stock_5min/2024/2024-10-08.parquet size: 6.6 MB rows: 393,601 symbols: 779
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-08 04:00:00 | AAPL | Stock | 222.1 | 222.3 | 222.0 | 222.11 | 3458.0 |
| 2024-10-08 04:05:00 | AAPL | Stock | 222.1 | 222.1 | 222.06 | 222.06 | 1576.0 |
| 2024-10-08 04:10:00 | AAPL | Stock | 222.12 | 222.12 | 221.88 | 221.88 | 1516.0 |
| 2024-10-08 04:15:00 | AAPL | Stock | 222.0 | 222.0 | 221.84 | 222.0 | 1534.0 |
| 2024-10-08 04:20:00 | AAPL | Stock | 222.0 | 222.0 | 222.0 | 222.0 | 476.0 |
| 2024-10-08 04:25:00 | AAPL | Stock | 222.04 | 222.14 | 222.04 | 222.14 | 438.0 |
| 2024-10-08 04:30:00 | AAPL | Stock | 222.01 | 222.01 | 222.01 | 222.01 | 100.0 |
| 2024-10-08 04:40:00 | AAPL | Stock | 221.88 | 221.88 | 221.7 | 221.8 | 1845.0 |
| 2024-10-08 04:45:00 | AAPL | Stock | 221.93 | 221.96 | 221.93 | 221.96 | 633.0 |
| 2024-10-08 04:55:00 | AAPL | Stock | 222.0 | 222.0 | 221.97 | 221.97 | 818.0 |
| 2024-10-08 05:00:00 | AAPL | Stock | 222.07 | 222.19 | 222.07 | 222.15 | 598.0 |
| 2024-10-08 05:05:00 | AAPL | Stock | 222.21 | 222.22 | 222.21 | 222.22 | 308.0 |
| 2024-10-08 05:15:00 | AAPL | Stock | 222.22 | 222.3 | 222.22 | 222.22 | 2521.0 |
| 2024-10-08 05:20:00 | AAPL | Stock | 222.45 | 222.45 | 222.45 | 222.45 | 250.0 |
| 2024-10-08 05:25:00 | AAPL | Stock | 222.44 | 222.45 | 222.44 | 222.45 | 455.0 |
| 2024-10-08 05:30:00 | AAPL | Stock | 222.43 | 222.5 | 222.4 | 222.5 | 1259.0 |
| 2024-10-08 05:35:00 | AAPL | Stock | 222.63 | 222.69 | 222.63 | 222.65 | 763.0 |
| 2024-10-08 05:40:00 | AAPL | Stock | 222.44 | 222.44 | 222.44 | 222.44 | 300.0 |
| 2024-10-08 05:45:00 | AAPL | Stock | 222.57 | 222.57 | 222.48 | 222.48 | 230.0 |
| 2024-10-08 05:50:00 | AAPL | Stock | 222.46 | 222.79 | 222.4 | 222.78 | 3149.0 |
| 2024-10-08 05:55:00 | AAPL | Stock | 222.73 | 222.8 | 222.73 | 222.8 | 1252.0 |
| 2024-10-08 06:00:00 | AAPL | Stock | 222.77 | 222.82 | 222.77 | 222.81 | 1283.0 |
| 2024-10-08 06:05:00 | AAPL | Stock | 222.82 | 222.82 | 222.75 | 222.75 | 543.0 |
| 2024-10-08 06:10:00 | AAPL | Stock | 222.79 | 222.79 | 222.79 | 222.79 | 1057.0 |
| 2024-10-08 06:15:00 | AAPL | Stock | 222.71 | 222.71 | 222.68 | 222.7 | 1009.0 |
| 2024-10-08 06:30:00 | AAPL | Stock | 222.83 | 222.95 | 222.75 | 222.95 | 2862.0 |
| 2024-10-08 06:35:00 | AAPL | Stock | 222.95 | 222.97 | 222.8 | 222.91 | 3396.0 |
| 2024-10-08 06:40:00 | AAPL | Stock | 222.91 | 222.91 | 222.83 | 222.83 | 1073.0 |
| 2024-10-08 06:45:00 | AAPL | Stock | 222.82 | 222.82 | 222.73 | 222.75 | 2370.0 |
| 2024-10-08 06:50:00 | AAPL | Stock | 222.96 | 223.16 | 222.96 | 223.15 | 1559.0 |
| 2024-10-08 06:55:00 | AAPL | Stock | 223.15 | 223.24 | 223.07 | 223.13 | 2870.0 |
| 2024-10-08 07:00:00 | AAPL | Stock | 223.08 | 223.25 | 223.0 | 223.11 | 6979.0 |
| 2024-10-08 07:05:00 | AAPL | Stock | 223.08 | 223.35 | 223.05 | 223.35 | 7620.0 |
| 2024-10-08 07:10:00 | AAPL | Stock | 223.21 | 223.26 | 223.2 | 223.24 | 1083.0 |
| 2024-10-08 07:15:00 | AAPL | Stock | 223.09 | 223.09 | 223.0 | 223.0 | 2139.0 |
| 2024-10-08 07:20:00 | AAPL | Stock | 222.89 | 222.9 | 222.78 | 222.8 | 2636.0 |
| 2024-10-08 07:25:00 | AAPL | Stock | 222.95 | 222.95 | 222.87 | 222.9 | 679.0 |
| 2024-10-08 07:30:00 | AAPL | Stock | 223.0 | 223.22 | 223.0 | 223.22 | 2305.0 |
| 2024-10-08 07:35:00 | AAPL | Stock | 223.21 | 223.25 | 223.17 | 223.22 | 2667.0 |
| 2024-10-08 07:40:00 | AAPL | Stock | 223.14 | 223.18 | 223.14 | 223.18 | 521.0 |
| 2024-10-08 07:45:00 | AAPL | Stock | 223.09 | 223.15 | 223.09 | 223.15 | 546.0 |
| 2024-10-08 07:50:00 | AAPL | Stock | 223.13 | 223.25 | 223.13 | 223.25 | 1083.0 |
| 2024-10-08 07:55:00 | AAPL | Stock | 223.2 | 223.2 | 223.18 | 223.18 | 638.0 |
| 2024-10-08 08:00:00 | AAPL | Stock | 223.2 | 223.25 | 221.47 | 223.25 | 34858.0 |
| 2024-10-08 08:05:00 | AAPL | Stock | 223.14 | 223.1995 | 223.13 | 223.1995 | 3653.0 |
| 2024-10-08 08:10:00 | AAPL | Stock | 221.136 | 223.14 | 221.136 | 223.11 | 6883.0 |
| 2024-10-08 08:15:00 | AAPL | Stock | 223.15 | 223.15 | 223.0003 | 223.1 | 3050.0 |
| 2024-10-08 08:20:00 | AAPL | Stock | 223.15 | 223.26 | 223.15 | 223.2 | 14268.0 |
| 2024-10-08 08:25:00 | AAPL | Stock | 223.2493 | 223.25 | 223.1 | 223.1503 | 11312.0 |
| 2024-10-08 08:30:00 | AAPL | Stock | 223.15 | 223.28 | 223.15 | 223.28 | 2618.0 |
> showing 50 of 393,601 rows — these rows as CSV