20 oct. 2025
/validated o /quarantine./curated./raw, /validated, /curated (Object Lock y versionado).agente_id, recurso_id, fecha, hora(0–23), cantidad_MWh, precio_COP_MWh, tipo_oferta, zona, timestamp_envio, firma_digital.(recurso, fecha, hora); sello de tiempo.Error relativo: \[ ER_{z,h} = \frac{\sum_{r \in \mathcal{R}(z)} \left| DP_{r,h} - GEN_{r,h} \right|} {\sum_{r \in \mathcal{R}(z)} DP_{r,h} + \varepsilon} \]
Definiciones: Participación horaria por agente: \[ s_{i,z,h} = \frac{Q_{i,z,h}}{\sum_{j} Q_{j,z,h} + \varepsilon} \]
HHI (escala 0–10.000): \[ HHI_{z,h} = 10{,}000 \cdot \sum_{i} s_{i,z,h}^{\,2} \]
Cambio de concentración (vs. referencia: día anterior o media móvil): \[ \Delta HHI_{z,h} = HHI_{z,h} - \widetilde{HHI}_{z,h} \]
Baseline robusto y z-score: \[ m_{r,h} = \mathrm{p50}\!\left(X^{hist}_{r,h}\right), \quad MAD_{r,h} = \mathrm{MAD}\!\left(X^{hist}_{r,h}\right) \]
z-score robusto (con ajuste de consistencia): \[ z_{r,h} = \frac{\left| X_{r,h} - m_{r,h} \right|}{1.4826 \cdot \max(MAD_{r,h}, \varepsilon)} \]
Donde \(X\) puede ser precio \(P\) o cantidad \(Q\).
Criterios típicos: outlier si \(z_{r,h} \ge 3\) y/o \(X_{r,h} > \mathrm{p95}\) (precio) o \(X_{r,h} < \mathrm{p05}\) (cantidad), sin indisponibilidad reportada.
Spread de precio frente a referencia zonal: \[ S_{r,h} = P_{r,h} - Ref_{z(h),h} \]
Simultaneidad intra-grupo (en ventana \(w\) minutos):
Define un evento de cambio para el recurso \(r\): \[
E_{r,h} =
\begin{cases}
1, & \text{si } \left| P_{r,h} - P_{r,h}^{\,prev} \right| \ge \theta_p \text{ (misma dirección)} \\
0, & \text{en otro caso}
\end{cases}
\]
Fracción de recursos del grupo \(g\) en \(z\) que cambian en la misma dirección: \[ \mathrm{Simul}_{g,z,h} = \frac{ \sum_{r \in \mathcal{R}_g(z)} E_{r,h} }{ \left| \mathcal{R}_g(z) \right| + \varepsilon } \]
(Severidad alta si \(\mathrm{Simul}_{g,z,h} \ge \tau\) y \(S_{r,h}\) está por encima del umbral de spread.)
alert_id.| Capa | Componente | Métrica | Supuesto | Mes USD | Año USD | Mes COP | Año COP |
|---|---|---|---|---|---|---|---|
| Datos | S3 Storage | GB/mes | 500 | $11.50 | $138.00 | $48.300 | $579.600 |
| Datos | S3 PUT | k-req/mes | 2000 | $10.00 | $120.00 | $42.000 | $504.000 |
| Datos | S3 GET | k-req/mes | 10000 | $4.00 | $48.00 | $16.800 | $201.600 |
| Ingesta | Transfer Family | endp*h/mes | 730 | $219.00 | $2,628.00 | $919.800 | $11.037.600 |
| Ingesta | Kinesis Shards | shard-h/mes | 1460 | $21.90 | $262.80 | $91.980 | $1.103.760 |
| Ingesta | Kinesis PUT | M PUT/mes | 5 | $0.07 | $0.84 | $294 | $3.528 |
| Ingesta | API Gateway | M req/mes | 2 | $7.00 | $84.00 | $29.400 | $352.800 |
| Proc. | Lambda (compute) | GB-s/mes | 75000 | $1.25 | $15.00 | $5.250 | $63.000 |
| Proc. | Lambda (invocs) | M inv/mes | 2 | $0.20 | $2.40 | $840 | $10.080 |
| Proc. | DynamoDB | M WCU+RCU | 1 W | 1 R | $1.50 | $18.00 | $6.300 | $75.600 |
| Datos | Glue ETL | DPU-h/mes | 50 | $22.00 | $264.00 | $92.400 | $1.108.800 |
| Analítica | Athena | TB/mes | 1 | $5.00 | $60.00 | $21.000 | $252.000 |
| Analítica | Timestream (writes) | M puntos/mes | 50 | $25.00 | $300.00 | $105.000 | $1.260.000 |
| Analítica | Aurora (bitácora) | h/mes | 730 | $211.70 | $2,540.40 | $889.140 | $10.669.680 |
| Alertas | EventBridge | M eventos/mes | 5 | $5.00 | $60.00 | $21.000 | $252.000 |
| Alertas | SNS | M envíos/mes | 0.1 | $0.05 | $0.60 | $210 | $2.520 |
| Alertas | SQS | M req/mes | 5 | $2.00 | $24.00 | $8.400 | $100.800 |
| Usuarios | QuickSight Authors | autores | 2 | $48.00 | $576.00 | $201.600 | $2.419.200 |
| Usuarios | QuickSight Readers | lectores×ses | 20×10 | $60.00 | $720.00 | $252.000 | $3.024.000 |
| Seguridad | GuardDuty | aprox/mes |
|
$50.00 | $600.00 | $210.000 | $2.520.000 |
| Seguridad | Security Hub | aprox/mes |
|
$100.00 | $1,200.00 | $420.000 | $5.040.000 |
| Seguridad | Macie | GB clasif/mes | 100 | $10.00 | $120.00 | $42.000 | $504.000 |
| TOTAL (sin contingencia) | $815.17 | $9,782.04 | $3.423.714 | $41.084.568 | |||
| TOTAL + contingencia 20% | $978.20 | $11,738.45 | $4.108.457 | $49.301.482 |