PREVIEW / stock_5min / 2024-06-28
file: by_date/stock_5min/2024/2024-06-28.parquet size: 6.6 MB rows: 404,199 symbols: 908
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-06-28 04:00:00 | AAPL | Stock | 214.12 | 214.93 | 214.12 | 214.7 | 3850.0 |
| 2024-06-28 04:05:00 | AAPL | Stock | 214.62 | 214.62 | 214.57 | 214.62 | 900.0 |
| 2024-06-28 04:10:00 | AAPL | Stock | 214.65 | 214.65 | 214.65 | 214.65 | 100.0 |
| 2024-06-28 04:15:00 | AAPL | Stock | 214.61 | 214.61 | 214.59 | 214.61 | 1319.0 |
| 2024-06-28 04:40:00 | AAPL | Stock | 214.71 | 214.71 | 214.71 | 214.71 | 418.0 |
| 2024-06-28 04:45:00 | AAPL | Stock | 214.69 | 214.69 | 214.69 | 214.69 | 125.0 |
| 2024-06-28 05:00:00 | AAPL | Stock | 214.68 | 215.0 | 214.68 | 215.0 | 1571.0 |
| 2024-06-28 05:05:00 | AAPL | Stock | 215.18 | 215.26 | 215.16 | 215.26 | 658.0 |
| 2024-06-28 05:15:00 | AAPL | Stock | 215.19 | 215.21 | 215.14 | 215.21 | 2371.0 |
| 2024-06-28 05:20:00 | AAPL | Stock | 215.39 | 215.63 | 215.39 | 215.63 | 1500.0 |
| 2024-06-28 05:25:00 | AAPL | Stock | 215.59 | 215.59 | 215.5 | 215.5 | 300.0 |
| 2024-06-28 05:30:00 | AAPL | Stock | 215.4 | 215.4 | 215.25 | 215.25 | 950.0 |
| 2024-06-28 05:35:00 | AAPL | Stock | 215.3 | 215.6 | 215.3 | 215.6 | 7130.0 |
| 2024-06-28 05:40:00 | AAPL | Stock | 215.6 | 215.69 | 215.51 | 215.6 | 5567.0 |
| 2024-06-28 05:45:00 | AAPL | Stock | 215.61 | 215.9 | 215.61 | 215.9 | 4721.0 |
| 2024-06-28 05:50:00 | AAPL | Stock | 216.0 | 216.37 | 215.96 | 216.24 | 6593.0 |
| 2024-06-28 05:55:00 | AAPL | Stock | 216.2 | 216.32 | 216.11 | 216.32 | 16677.0 |
| 2024-06-28 06:00:00 | AAPL | Stock | 216.3 | 216.3 | 216.2 | 216.25 | 1283.0 |
| 2024-06-28 06:05:00 | AAPL | Stock | 216.19 | 216.25 | 216.13 | 216.13 | 1810.0 |
| 2024-06-28 06:10:00 | AAPL | Stock | 216.14 | 216.17 | 216.12 | 216.17 | 400.0 |
| 2024-06-28 06:15:00 | AAPL | Stock | 216.2 | 216.2 | 216.0 | 216.0 | 3781.0 |
| 2024-06-28 06:20:00 | AAPL | Stock | 215.96 | 216.11 | 215.96 | 216.1 | 1323.0 |
| 2024-06-28 06:25:00 | AAPL | Stock | 216.09 | 216.09 | 216.06 | 216.07 | 1830.0 |
| 2024-06-28 06:30:00 | AAPL | Stock | 216.07 | 216.07 | 216.06 | 216.06 | 520.0 |
| 2024-06-28 06:35:00 | AAPL | Stock | 216.06 | 216.08 | 215.97 | 216.08 | 2128.0 |
| 2024-06-28 06:40:00 | AAPL | Stock | 216.08 | 216.18 | 216.08 | 216.18 | 1679.0 |
| 2024-06-28 06:45:00 | AAPL | Stock | 216.22 | 216.3 | 216.06 | 216.3 | 4102.0 |
| 2024-06-28 06:50:00 | AAPL | Stock | 216.23 | 216.23 | 216.19 | 216.23 | 509.0 |
| 2024-06-28 06:55:00 | AAPL | Stock | 216.15 | 216.15 | 216.15 | 216.15 | 230.0 |
| 2024-06-28 07:00:00 | AAPL | Stock | 216.11 | 216.11 | 215.5 | 215.85 | 15468.0 |
| 2024-06-28 07:05:00 | AAPL | Stock | 215.9 | 215.9 | 215.85 | 215.9 | 4671.0 |
| 2024-06-28 07:10:00 | AAPL | Stock | 215.91 | 215.92 | 215.8 | 215.8 | 4163.0 |
| 2024-06-28 07:15:00 | AAPL | Stock | 215.89 | 215.98 | 215.81 | 215.85 | 6319.0 |
| 2024-06-28 07:20:00 | AAPL | Stock | 215.85 | 215.88 | 215.79 | 215.79 | 5411.0 |
| 2024-06-28 07:25:00 | AAPL | Stock | 215.78 | 215.83 | 215.78 | 215.82 | 2691.0 |
| 2024-06-28 07:30:00 | AAPL | Stock | 215.79 | 215.95 | 215.79 | 215.95 | 1255.0 |
| 2024-06-28 07:35:00 | AAPL | Stock | 215.93 | 215.99 | 215.93 | 215.99 | 430.0 |
| 2024-06-28 07:40:00 | AAPL | Stock | 215.99 | 216.259 | 215.97 | 216.11 | 16415.0 |
| 2024-06-28 07:45:00 | AAPL | Stock | 216.11 | 216.13 | 216.11 | 216.11 | 6211.0 |
| 2024-06-28 07:50:00 | AAPL | Stock | 216.11 | 216.11 | 216.05 | 216.06 | 2216.0 |
| 2024-06-28 07:55:00 | AAPL | Stock | 216.04 | 216.1 | 215.91 | 215.92 | 3179.0 |
| 2024-06-28 08:00:00 | AAPL | Stock | 215.8 | 216.26 | 214.69 | 215.97 | 68625.0 |
| 2024-06-28 08:05:00 | AAPL | Stock | 215.98 | 216.0 | 215.9 | 215.97 | 26307.0 |
| 2024-06-28 08:10:00 | AAPL | Stock | 215.9 | 216.0 | 215.8019 | 215.8019 | 30879.0 |
| 2024-06-28 08:15:00 | AAPL | Stock | 215.88 | 215.97 | 215.7 | 215.97 | 13678.0 |
| 2024-06-28 08:20:00 | AAPL | Stock | 215.95 | 215.97 | 215.6004 | 215.65 | 36353.0 |
| 2024-06-28 08:25:00 | AAPL | Stock | 215.69 | 215.92 | 215.58 | 215.92 | 17529.0 |
| 2024-06-28 08:30:00 | AAPL | Stock | 215.72 | 215.98 | 215.55 | 215.88 | 25053.0 |
| 2024-06-28 08:35:00 | AAPL | Stock | 215.95 | 215.95 | 215.76 | 215.8 | 11924.0 |
| 2024-06-28 08:40:00 | AAPL | Stock | 215.8 | 215.8 | 215.5203 | 215.8 | 24814.0 |
> showing 50 of 404,199 rows — these rows as CSV