PREVIEW / stock_5min / 2024-09-23
file: by_date/stock_5min/2024/2024-09-23.parquet size: 6.7 MB rows: 401,719 symbols: 782
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-09-23 04:00:00 | AAPL | Stock | 228.4 | 228.48 | 228.18 | 228.21 | 25415.0 |
| 2024-09-23 04:05:00 | AAPL | Stock | 227.97 | 228.2 | 227.81 | 228.01 | 4099.0 |
| 2024-09-23 04:10:00 | AAPL | Stock | 228.0 | 228.22 | 227.76 | 227.76 | 2579.0 |
| 2024-09-23 04:15:00 | AAPL | Stock | 227.57 | 227.63 | 227.37 | 227.63 | 3275.0 |
| 2024-09-23 04:20:00 | AAPL | Stock | 227.77 | 227.8 | 227.7 | 227.7 | 889.0 |
| 2024-09-23 04:25:00 | AAPL | Stock | 227.87 | 227.87 | 227.75 | 227.75 | 2504.0 |
| 2024-09-23 04:30:00 | AAPL | Stock | 227.69 | 227.69 | 227.35 | 227.42 | 1895.0 |
| 2024-09-23 04:35:00 | AAPL | Stock | 227.52 | 227.57 | 227.45 | 227.57 | 1571.0 |
| 2024-09-23 04:40:00 | AAPL | Stock | 227.51 | 227.6 | 227.5 | 227.6 | 670.0 |
| 2024-09-23 04:45:00 | AAPL | Stock | 227.51 | 227.51 | 227.5 | 227.5 | 717.0 |
| 2024-09-23 04:50:00 | AAPL | Stock | 227.7 | 227.7 | 227.7 | 227.7 | 202.0 |
| 2024-09-23 05:00:00 | AAPL | Stock | 227.71 | 227.71 | 227.71 | 227.71 | 205.0 |
| 2024-09-23 05:05:00 | AAPL | Stock | 227.78 | 227.87 | 227.7 | 227.87 | 3169.0 |
| 2024-09-23 05:10:00 | AAPL | Stock | 227.83 | 227.84 | 227.75 | 227.84 | 1610.0 |
| 2024-09-23 05:15:00 | AAPL | Stock | 227.83 | 227.83 | 227.64 | 227.64 | 1158.0 |
| 2024-09-23 05:20:00 | AAPL | Stock | 227.55 | 227.7 | 227.55 | 227.7 | 350.0 |
| 2024-09-23 05:25:00 | AAPL | Stock | 227.73 | 227.73 | 227.59 | 227.59 | 1632.0 |
| 2024-09-23 05:30:00 | AAPL | Stock | 227.6 | 227.88 | 227.55 | 227.75 | 4245.0 |
| 2024-09-23 05:35:00 | AAPL | Stock | 227.76 | 227.88 | 227.76 | 227.87 | 1143.0 |
| 2024-09-23 05:40:00 | AAPL | Stock | 227.88 | 227.88 | 227.8 | 227.8 | 3036.0 |
| 2024-09-23 05:45:00 | AAPL | Stock | 227.75 | 227.89 | 227.75 | 227.89 | 1505.0 |
| 2024-09-23 05:50:00 | AAPL | Stock | 227.95 | 227.98 | 227.85 | 227.85 | 687.0 |
| 2024-09-23 05:55:00 | AAPL | Stock | 227.87 | 227.98 | 227.87 | 227.98 | 849.0 |
| 2024-09-23 06:00:00 | AAPL | Stock | 227.87 | 227.87 | 227.8 | 227.8 | 2948.0 |
| 2024-09-23 06:05:00 | AAPL | Stock | 227.91 | 227.98 | 227.88 | 227.97 | 1020.0 |
| 2024-09-23 06:10:00 | AAPL | Stock | 227.94 | 228.0 | 227.94 | 228.0 | 5814.0 |
| 2024-09-23 06:15:00 | AAPL | Stock | 228.0 | 228.1 | 228.0 | 228.1 | 1086.0 |
| 2024-09-23 06:20:00 | AAPL | Stock | 228.12 | 228.26 | 228.1 | 228.26 | 5116.0 |
| 2024-09-23 06:25:00 | AAPL | Stock | 228.35 | 228.37 | 228.3 | 228.3 | 1740.0 |
| 2024-09-23 06:30:00 | AAPL | Stock | 228.32 | 228.32 | 228.32 | 228.32 | 236.0 |
| 2024-09-23 06:35:00 | AAPL | Stock | 228.28 | 228.34 | 228.22 | 228.3 | 800.0 |
| 2024-09-23 06:40:00 | AAPL | Stock | 228.32 | 228.32 | 228.32 | 228.32 | 100.0 |
| 2024-09-23 06:45:00 | AAPL | Stock | 228.3 | 228.3 | 228.22 | 228.22 | 2032.0 |
| 2024-09-23 06:50:00 | AAPL | Stock | 228.27 | 228.31 | 228.27 | 228.31 | 1117.0 |
| 2024-09-23 06:55:00 | AAPL | Stock | 228.2 | 228.2 | 228.2 | 228.2 | 1874.0 |
| 2024-09-23 07:00:00 | AAPL | Stock | 228.05 | 228.18 | 228.0 | 228.07 | 6733.0 |
| 2024-09-23 07:05:00 | AAPL | Stock | 228.0 | 228.0 | 227.81 | 227.96 | 2916.0 |
| 2024-09-23 07:10:00 | AAPL | Stock | 227.96 | 228.2 | 227.96 | 228.2 | 2660.0 |
| 2024-09-23 07:15:00 | AAPL | Stock | 228.05 | 228.1 | 227.98 | 228.1 | 5634.0 |
| 2024-09-23 07:20:00 | AAPL | Stock | 228.1 | 228.2 | 228.1 | 228.12 | 3033.0 |
| 2024-09-23 07:25:00 | AAPL | Stock | 228.1 | 228.1 | 227.89 | 227.89 | 10694.0 |
| 2024-09-23 07:30:00 | AAPL | Stock | 227.98 | 227.98 | 227.93 | 227.96 | 3340.0 |
| 2024-09-23 07:35:00 | AAPL | Stock | 228.1 | 228.2 | 228.02 | 228.08 | 3908.0 |
| 2024-09-23 07:40:00 | AAPL | Stock | 228.05 | 228.3 | 228.05 | 228.3 | 4895.0 |
| 2024-09-23 07:45:00 | AAPL | Stock | 228.3 | 228.44 | 228.24 | 228.39 | 8401.0 |
| 2024-09-23 07:50:00 | AAPL | Stock | 228.4 | 228.4 | 228.21 | 228.25 | 1150.0 |
| 2024-09-23 07:55:00 | AAPL | Stock | 228.21 | 228.27 | 228.2 | 228.27 | 5746.0 |
| 2024-09-23 08:00:00 | AAPL | Stock | 228.125 | 228.66 | 227.27 | 228.07 | 65988.0 |
| 2024-09-23 08:05:00 | AAPL | Stock | 228.24 | 228.25 | 228.07 | 228.2 | 12381.0 |
| 2024-09-23 08:10:00 | AAPL | Stock | 228.1045 | 228.195 | 227.8 | 227.8 | 12115.0 |
> showing 50 of 401,719 rows — these rows as CSV