Sanity Checks (star‑schema DB)
Last updated: 2025-09-22 13:44 -05
1 Quantities
1.1 Total Daily Declared Quantity
Warning
Data missing: all “declared quantity” in 2024.
1.2 Stacked Area by Bidder (Levels)
Note
TEBSAB and TEBSAB CC seem to be the same below.
1.3 Stacked Area by Bidder (Levels) 2
1.6 Heatmaps
Note
It seems as if TEBSAB became TEBSAB CC around 2020.
Note
Similarly: TCIG == TCDG? EMGG == ENDG? CRLG == GECG?
1.7 Bump Chart
1.8 Boxplots
1.9 Daily Market Concentration (HHI)
2 Water
Note
Check ALBAN, ALTO and BAJO ANCHICAYA
2.1 System-wide inflows vs. reservoir levels
2.2 Reservoir storage trajectory — Top 12
2.3 Reservoir indices with rolling mean
2.4 Capacity HHI
3 Bids
3.1 System-wide daily average bid (in COP)
Data missing. Some bids missing just before 2024