PREVIEW / stock_5min / 2024-11-21
file: by_date/stock_5min/2024/2024-11-21.parquet size: 7.1 MB rows: 423,692 symbols: 704
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-11-21 04:00:00 | AAPL | Stock | 228.2 | 228.49 | 228.11 | 228.49 | 900.0 |
| 2024-11-21 04:05:00 | AAPL | Stock | 228.43 | 228.6 | 228.4 | 228.45 | 2182.0 |
| 2024-11-21 04:10:00 | AAPL | Stock | 228.31 | 228.45 | 228.31 | 228.45 | 2473.0 |
| 2024-11-21 04:15:00 | AAPL | Stock | 228.46 | 228.81 | 228.46 | 228.81 | 2141.0 |
| 2024-11-21 04:20:00 | AAPL | Stock | 228.78 | 228.86 | 228.6 | 228.86 | 6309.0 |
| 2024-11-21 04:25:00 | AAPL | Stock | 229.0 | 229.01 | 228.58 | 228.58 | 2574.0 |
| 2024-11-21 04:35:00 | AAPL | Stock | 228.55 | 228.55 | 228.55 | 228.55 | 117.0 |
| 2024-11-21 04:45:00 | AAPL | Stock | 228.72 | 228.72 | 228.57 | 228.7 | 575.0 |
| 2024-11-21 04:50:00 | AAPL | Stock | 228.7 | 228.7 | 228.63 | 228.63 | 483.0 |
| 2024-11-21 04:55:00 | AAPL | Stock | 228.6 | 228.6 | 228.6 | 228.6 | 100.0 |
| 2024-11-21 05:00:00 | AAPL | Stock | 228.52 | 228.65 | 228.52 | 228.65 | 200.0 |
| 2024-11-21 05:05:00 | AAPL | Stock | 228.65 | 228.65 | 228.6 | 228.65 | 439.0 |
| 2024-11-21 05:10:00 | AAPL | Stock | 228.65 | 228.74 | 228.5 | 228.74 | 4426.0 |
| 2024-11-21 05:20:00 | AAPL | Stock | 228.57 | 228.57 | 228.57 | 228.57 | 198.0 |
| 2024-11-21 05:25:00 | AAPL | Stock | 228.76 | 228.76 | 228.76 | 228.76 | 200.0 |
| 2024-11-21 05:30:00 | AAPL | Stock | 228.69 | 228.69 | 228.57 | 228.57 | 261.0 |
| 2024-11-21 05:35:00 | AAPL | Stock | 228.58 | 228.65 | 228.58 | 228.65 | 1142.0 |
| 2024-11-21 05:40:00 | AAPL | Stock | 228.75 | 229.0 | 228.75 | 229.0 | 2266.0 |
| 2024-11-21 05:50:00 | AAPL | Stock | 228.86 | 228.88 | 228.86 | 228.88 | 1675.0 |
| 2024-11-21 06:00:00 | AAPL | Stock | 228.8 | 229.22 | 228.8 | 229.13 | 3523.0 |
| 2024-11-21 06:05:00 | AAPL | Stock | 229.3 | 229.45 | 229.3 | 229.45 | 530.0 |
| 2024-11-21 06:10:00 | AAPL | Stock | 229.4 | 229.41 | 229.2 | 229.4 | 1295.0 |
| 2024-11-21 06:15:00 | AAPL | Stock | 229.48 | 229.48 | 229.48 | 229.48 | 379.0 |
| 2024-11-21 06:25:00 | AAPL | Stock | 229.64 | 229.76 | 229.64 | 229.75 | 1739.0 |
| 2024-11-21 06:30:00 | AAPL | Stock | 229.76 | 229.82 | 229.7 | 229.82 | 8129.0 |
| 2024-11-21 06:35:00 | AAPL | Stock | 229.87 | 229.96 | 229.7 | 229.7 | 5795.0 |
| 2024-11-21 06:40:00 | AAPL | Stock | 229.72 | 229.72 | 229.72 | 229.72 | 118.0 |
| 2024-11-21 06:45:00 | AAPL | Stock | 229.48 | 229.61 | 229.48 | 229.61 | 930.0 |
| 2024-11-21 06:50:00 | AAPL | Stock | 229.61 | 229.61 | 229.5 | 229.5 | 1505.0 |
| 2024-11-21 06:55:00 | AAPL | Stock | 229.54 | 229.66 | 229.5 | 229.66 | 2428.0 |
| 2024-11-21 07:00:00 | AAPL | Stock | 229.43 | 229.43 | 229.35 | 229.38 | 1909.0 |
| 2024-11-21 07:05:00 | AAPL | Stock | 229.45 | 229.6 | 229.45 | 229.6 | 2433.0 |
| 2024-11-21 07:10:00 | AAPL | Stock | 229.62 | 229.75 | 229.62 | 229.72 | 2397.0 |
| 2024-11-21 07:15:00 | AAPL | Stock | 229.75 | 229.95 | 229.75 | 229.94 | 2316.0 |
| 2024-11-21 07:20:00 | AAPL | Stock | 229.91 | 229.91 | 229.8 | 229.81 | 750.0 |
| 2024-11-21 07:25:00 | AAPL | Stock | 229.81 | 229.81 | 229.8 | 229.8 | 204.0 |
| 2024-11-21 07:30:00 | AAPL | Stock | 229.73 | 229.81 | 229.69 | 229.73 | 2351.0 |
| 2024-11-21 07:35:00 | AAPL | Stock | 229.68 | 229.8 | 229.68 | 229.8 | 2162.0 |
| 2024-11-21 07:40:00 | AAPL | Stock | 229.8 | 229.97 | 229.8 | 229.97 | 2863.0 |
| 2024-11-21 07:45:00 | AAPL | Stock | 229.91 | 229.91 | 229.52 | 229.52 | 2204.0 |
| 2024-11-21 07:50:00 | AAPL | Stock | 229.39 | 229.4 | 229.09 | 229.09 | 5804.0 |
| 2024-11-21 07:55:00 | AAPL | Stock | 229.13 | 229.35 | 229.13 | 229.35 | 2577.0 |
| 2024-11-21 08:00:00 | AAPL | Stock | 229.95 | 229.95 | 228.02 | 229.3 | 48242.0 |
| 2024-11-21 08:05:00 | AAPL | Stock | 229.26 | 229.3 | 229.2 | 229.2 | 2426.0 |
| 2024-11-21 08:10:00 | AAPL | Stock | 229.235 | 229.3 | 229.235 | 229.28 | 6510.0 |
| 2024-11-21 08:15:00 | AAPL | Stock | 229.3069 | 229.49 | 229.3069 | 229.36 | 5705.0 |
| 2024-11-21 08:20:00 | AAPL | Stock | 229.433 | 229.433 | 229.14 | 229.15 | 3657.0 |
| 2024-11-21 08:25:00 | AAPL | Stock | 229.21 | 229.3586 | 228.428 | 229.1001 | 6057.0 |
| 2024-11-21 08:30:00 | AAPL | Stock | 229.17 | 229.48 | 229.1 | 229.43 | 9057.0 |
| 2024-11-21 08:35:00 | AAPL | Stock | 229.46 | 229.6 | 229.3 | 229.6 | 5588.0 |
> showing 50 of 423,692 rows — these rows as CSV