PREVIEW / stock_5min / 2024-08-02
file: by_date/stock_5min/2024/2024-08-02.parquet size: 6.8 MB rows: 414,678 symbols: 880
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-08-02 04:00:00 | AAPL | Stock | 217.9 | 218.82 | 216.55 | 216.65 | 9189.0 |
| 2024-08-02 04:05:00 | AAPL | Stock | 216.65 | 217.63 | 216.65 | 217.63 | 16921.0 |
| 2024-08-02 04:10:00 | AAPL | Stock | 217.46 | 217.46 | 217.1 | 217.1 | 2455.0 |
| 2024-08-02 04:15:00 | AAPL | Stock | 217.34 | 217.34 | 217.0 | 217.15 | 1787.0 |
| 2024-08-02 04:20:00 | AAPL | Stock | 217.39 | 217.39 | 217.0 | 217.09 | 2059.0 |
| 2024-08-02 04:25:00 | AAPL | Stock | 217.2 | 217.75 | 217.2 | 217.75 | 1185.0 |
| 2024-08-02 04:30:00 | AAPL | Stock | 217.63 | 217.88 | 217.48 | 217.88 | 2606.0 |
| 2024-08-02 04:35:00 | AAPL | Stock | 217.87 | 217.87 | 217.87 | 217.87 | 100.0 |
| 2024-08-02 04:45:00 | AAPL | Stock | 217.6 | 217.6 | 217.6 | 217.6 | 100.0 |
| 2024-08-02 04:50:00 | AAPL | Stock | 217.75 | 217.99 | 217.75 | 217.95 | 1494.0 |
| 2024-08-02 04:55:00 | AAPL | Stock | 218.11 | 218.26 | 218.1 | 218.15 | 2196.0 |
| 2024-08-02 05:00:00 | AAPL | Stock | 218.0 | 218.0 | 217.9 | 217.9 | 1863.0 |
| 2024-08-02 05:05:00 | AAPL | Stock | 217.9 | 218.01 | 217.9 | 218.01 | 2550.0 |
| 2024-08-02 05:10:00 | AAPL | Stock | 217.9 | 218.0 | 217.9 | 218.0 | 1372.0 |
| 2024-08-02 05:15:00 | AAPL | Stock | 217.95 | 217.95 | 217.9 | 217.9 | 3656.0 |
| 2024-08-02 05:20:00 | AAPL | Stock | 217.9 | 217.9 | 217.63 | 217.76 | 2089.0 |
| 2024-08-02 05:25:00 | AAPL | Stock | 217.6 | 217.69 | 217.6 | 217.69 | 1140.0 |
| 2024-08-02 05:30:00 | AAPL | Stock | 217.75 | 218.1 | 217.68 | 217.8 | 3493.0 |
| 2024-08-02 05:35:00 | AAPL | Stock | 218.0 | 218.0 | 217.99 | 218.0 | 517.0 |
| 2024-08-02 05:40:00 | AAPL | Stock | 218.1 | 218.12 | 217.8 | 217.8 | 3428.0 |
| 2024-08-02 05:45:00 | AAPL | Stock | 217.94 | 217.94 | 217.7 | 217.8 | 1433.0 |
| 2024-08-02 05:50:00 | AAPL | Stock | 217.85 | 217.9 | 217.75 | 217.9 | 760.0 |
| 2024-08-02 05:55:00 | AAPL | Stock | 218.0 | 218.01 | 218.0 | 218.01 | 621.0 |
| 2024-08-02 06:00:00 | AAPL | Stock | 218.05 | 218.15 | 218.05 | 218.05 | 2240.0 |
| 2024-08-02 06:05:00 | AAPL | Stock | 218.05 | 218.05 | 217.51 | 217.8 | 5569.0 |
| 2024-08-02 06:10:00 | AAPL | Stock | 218.01 | 218.17 | 217.95 | 217.95 | 1328.0 |
| 2024-08-02 06:15:00 | AAPL | Stock | 218.08 | 218.65 | 218.08 | 218.65 | 1283.0 |
| 2024-08-02 06:20:00 | AAPL | Stock | 218.84 | 220.57 | 218.84 | 219.7 | 6588.0 |
| 2024-08-02 06:25:00 | AAPL | Stock | 219.92 | 220.2 | 219.55 | 220.0 | 3153.0 |
| 2024-08-02 06:30:00 | AAPL | Stock | 219.79 | 219.9 | 218.99 | 219.0 | 4503.0 |
| 2024-08-02 06:35:00 | AAPL | Stock | 219.0 | 219.0 | 218.75 | 218.9 | 3080.0 |
| 2024-08-02 06:40:00 | AAPL | Stock | 219.2 | 219.69 | 219.2 | 219.65 | 4636.0 |
| 2024-08-02 06:45:00 | AAPL | Stock | 219.6 | 219.62 | 219.5 | 219.62 | 4059.0 |
| 2024-08-02 06:50:00 | AAPL | Stock | 219.6 | 219.8 | 219.5 | 219.8 | 5096.0 |
| 2024-08-02 06:55:00 | AAPL | Stock | 219.88 | 220.47 | 219.87 | 220.47 | 7932.0 |
| 2024-08-02 07:00:00 | AAPL | Stock | 220.1 | 220.1 | 219.65 | 220.1 | 18203.0 |
| 2024-08-02 07:05:00 | AAPL | Stock | 220.25 | 220.48 | 219.89 | 219.89 | 11204.0 |
| 2024-08-02 07:10:00 | AAPL | Stock | 219.85 | 219.85 | 219.4 | 219.47 | 6950.0 |
| 2024-08-02 07:15:00 | AAPL | Stock | 219.5 | 220.3 | 219.32 | 220.2 | 27079.0 |
| 2024-08-02 07:20:00 | AAPL | Stock | 220.22 | 220.4 | 220.0 | 220.1 | 30926.0 |
| 2024-08-02 07:25:00 | AAPL | Stock | 219.93 | 219.93 | 219.26 | 219.3 | 7174.0 |
| 2024-08-02 07:30:00 | AAPL | Stock | 219.45 | 219.5 | 218.94 | 219.5 | 14784.0 |
| 2024-08-02 07:35:00 | AAPL | Stock | 219.48 | 219.49 | 218.05 | 218.12 | 16832.0 |
| 2024-08-02 07:40:00 | AAPL | Stock | 218.14 | 218.21 | 217.41 | 217.87 | 22217.0 |
| 2024-08-02 07:45:00 | AAPL | Stock | 217.82 | 218.0 | 217.65 | 217.75 | 6102.0 |
| 2024-08-02 07:50:00 | AAPL | Stock | 217.92 | 218.05 | 217.64 | 217.81 | 8091.0 |
| 2024-08-02 07:55:00 | AAPL | Stock | 217.9 | 217.9 | 217.28 | 217.5 | 11974.0 |
| 2024-08-02 08:00:00 | AAPL | Stock | 220.02 | 220.5 | 215.85 | 218.31 | 120629.0 |
| 2024-08-02 08:05:00 | AAPL | Stock | 218.33 | 218.97 | 218.31 | 218.6881 | 32065.0 |
| 2024-08-02 08:10:00 | AAPL | Stock | 218.6694 | 218.6694 | 218.04 | 218.25 | 16682.0 |
> showing 50 of 414,678 rows — these rows as CSV