[CONTRIBUTION] [BUG] Chainlink Price Feeds stale on Polygon, Ethereum, etc

Description

Chainlink price feeds are stale across multiple chains (ethereum, polygon, bnb, avalanche). As shown below, the last timestamp from these models was around Aug/Sep 2024. optimism, gnosis, fantom & arbitrum appear unaffected.

dune.com/queries/5959887

Sub-project: chainlink
Models:

• chainlink_***_price_feeds
• chainlink_***_price_feeds_oracle_addresses

Issue

Old aggregator_address are being referenced in /chainlink***price_feeds_oracle_addresses

• price_feed source events are recorded from the aggregator_address (the proxy_address does not emit required events).
• aggregator_address's are hardcoded as in /chainlink_polygon_price_feeds_oracle_addresses.sql
• aggregator_address's are sometimes updated / rotated by chainlink, as they were in Aug/Sep 2024. Currently referenced addresses are no longer used or emitting events.

Solution

I can update all the aggregator_addresses's to the new address for each affected chain as a PR, but is there anyway to backfill the last 12months of missing data?

Also, any guidance for replicating these models for base chain?

Start with the chainlink_*_price_feeds_oracle_addresses models, especially dbt_subprojects/daily_spellbook/models/chainlink/polygon/chainlink_polygon_price_feeds_oracle_addresses.sql, and compare the hardcoded aggregator addresses with current Chainlink rotations. Check the affected Ethereum, Polygon, BNB, and Avalanche models and determine whether the missing 12 months can be backfilled. Done means affected feeds reference active event-emitting addresses and the backfill approach is documented.