PREVIEW / stock_5min / 2024-01-10
file: by_date/stock_5min/2024/2024-01-10.parquet size: 6.6 MB rows: 397,135 symbols: 1,173
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-01-10 04:00:00 | AAPL | Stock | 184.88 | 184.91 | 184.81 | 184.87 | 3142.0 |
| 2024-01-10 04:05:00 | AAPL | Stock | 184.87 | 184.9 | 184.8 | 184.9 | 3856.0 |
| 2024-01-10 04:10:00 | AAPL | Stock | 184.89 | 185.1 | 184.89 | 185.07 | 2063.0 |
| 2024-01-10 04:15:00 | AAPL | Stock | 185.07 | 185.08 | 185.06 | 185.08 | 3051.0 |
| 2024-01-10 04:20:00 | AAPL | Stock | 185.1 | 185.12 | 185.1 | 185.12 | 3043.0 |
| 2024-01-10 04:25:00 | AAPL | Stock | 185.2 | 185.27 | 185.2 | 185.27 | 814.0 |
| 2024-01-10 04:30:00 | AAPL | Stock | 185.32 | 185.32 | 185.32 | 185.32 | 150.0 |
| 2024-01-10 04:35:00 | AAPL | Stock | 185.35 | 185.35 | 185.32 | 185.34 | 1940.0 |
| 2024-01-10 04:40:00 | AAPL | Stock | 185.34 | 185.34 | 185.33 | 185.33 | 1025.0 |
| 2024-01-10 04:45:00 | AAPL | Stock | 185.3 | 185.3 | 185.24 | 185.24 | 2080.0 |
| 2024-01-10 04:50:00 | AAPL | Stock | 185.3 | 185.3 | 185.3 | 185.3 | 125.0 |
| 2024-01-10 05:00:00 | AAPL | Stock | 185.28 | 185.28 | 185.28 | 185.28 | 101.0 |
| 2024-01-10 05:05:00 | AAPL | Stock | 185.33 | 185.33 | 185.33 | 185.33 | 138.0 |
| 2024-01-10 05:10:00 | AAPL | Stock | 185.31 | 185.31 | 185.31 | 185.31 | 127.0 |
| 2024-01-10 05:15:00 | AAPL | Stock | 185.28 | 185.28 | 185.24 | 185.24 | 3764.0 |
| 2024-01-10 05:20:00 | AAPL | Stock | 185.24 | 185.26 | 185.2 | 185.26 | 2703.0 |
| 2024-01-10 05:25:00 | AAPL | Stock | 185.22 | 185.33 | 185.2 | 185.33 | 2958.0 |
| 2024-01-10 05:30:00 | AAPL | Stock | 185.32 | 185.32 | 185.29 | 185.29 | 1909.0 |
| 2024-01-10 05:35:00 | AAPL | Stock | 185.29 | 185.31 | 185.29 | 185.31 | 1283.0 |
| 2024-01-10 05:45:00 | AAPL | Stock | 185.33 | 185.34 | 185.33 | 185.34 | 1039.0 |
| 2024-01-10 05:50:00 | AAPL | Stock | 185.35 | 185.35 | 185.35 | 185.35 | 104.0 |
| 2024-01-10 06:00:00 | AAPL | Stock | 185.41 | 185.41 | 185.31 | 185.31 | 554.0 |
| 2024-01-10 06:05:00 | AAPL | Stock | 185.37 | 185.37 | 185.37 | 185.37 | 1578.0 |
| 2024-01-10 06:10:00 | AAPL | Stock | 185.35 | 185.36 | 185.3 | 185.3 | 1026.0 |
| 2024-01-10 06:15:00 | AAPL | Stock | 185.31 | 185.31 | 185.3 | 185.3 | 1015.0 |
| 2024-01-10 06:20:00 | AAPL | Stock | 185.3 | 185.3 | 185.24 | 185.24 | 2228.0 |
| 2024-01-10 06:25:00 | AAPL | Stock | 185.22 | 185.22 | 185.1 | 185.16 | 2120.0 |
| 2024-01-10 06:30:00 | AAPL | Stock | 185.16 | 185.16 | 185.14 | 185.15 | 638.0 |
| 2024-01-10 06:35:00 | AAPL | Stock | 185.21 | 185.21 | 185.17 | 185.17 | 800.0 |
| 2024-01-10 06:40:00 | AAPL | Stock | 185.19 | 185.19 | 185.15 | 185.15 | 871.0 |
| 2024-01-10 06:45:00 | AAPL | Stock | 185.13 | 185.13 | 184.95 | 184.95 | 5388.0 |
| 2024-01-10 06:50:00 | AAPL | Stock | 184.9 | 184.94 | 184.71 | 184.72 | 2069.0 |
| 2024-01-10 06:55:00 | AAPL | Stock | 184.71 | 184.88 | 184.71 | 184.88 | 1531.0 |
| 2024-01-10 07:00:00 | AAPL | Stock | 184.88 | 185.0 | 184.88 | 185.0 | 2576.0 |
| 2024-01-10 07:05:00 | AAPL | Stock | 185.11 | 185.14 | 185.07 | 185.07 | 4672.0 |
| 2024-01-10 07:10:00 | AAPL | Stock | 185.04 | 185.1 | 185.03 | 185.04 | 2083.0 |
| 2024-01-10 07:15:00 | AAPL | Stock | 185.04 | 185.04 | 185.03 | 185.04 | 1598.0 |
| 2024-01-10 07:20:00 | AAPL | Stock | 185.03 | 185.05 | 185.0 | 185.03 | 3354.0 |
| 2024-01-10 07:25:00 | AAPL | Stock | 185.05 | 185.05 | 185.0 | 185.0 | 2327.0 |
| 2024-01-10 07:30:00 | AAPL | Stock | 185.0 | 185.0 | 184.9 | 184.92 | 1889.0 |
| 2024-01-10 07:35:00 | AAPL | Stock | 184.92 | 184.92 | 184.9 | 184.9 | 359.0 |
| 2024-01-10 07:40:00 | AAPL | Stock | 184.9 | 184.9 | 184.78 | 184.82 | 8725.0 |
| 2024-01-10 07:45:00 | AAPL | Stock | 184.78 | 184.84 | 184.75 | 184.84 | 5411.0 |
| 2024-01-10 07:50:00 | AAPL | Stock | 184.86 | 184.86 | 184.74 | 184.74 | 8276.0 |
| 2024-01-10 07:55:00 | AAPL | Stock | 184.75 | 184.75 | 184.69 | 184.7 | 4343.0 |
| 2024-01-10 08:00:00 | AAPL | Stock | 184.949 | 185.55 | 184.55 | 184.5989 | 60411.0 |
| 2024-01-10 08:05:00 | AAPL | Stock | 184.59 | 184.65 | 184.55 | 184.6 | 6462.0 |
| 2024-01-10 08:10:00 | AAPL | Stock | 184.6 | 184.68 | 184.6 | 184.65 | 5622.0 |
| 2024-01-10 08:15:00 | AAPL | Stock | 184.66 | 184.66 | 184.6 | 184.62 | 9301.0 |
| 2024-01-10 08:20:00 | AAPL | Stock | 184.63 | 184.69 | 184.6 | 184.65 | 20875.0 |
> showing 50 of 397,135 rows — these rows as CSV