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

[thestabull]

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?

[0xBoxer]

hi @thestabull thanks for raising this issue!

I think updating these pricefeeds is a reasonable consideration, however I would like you to see if we can get out of hardcoding the variables here to be more adept for any future upgrades and to make multichain deployment of this data pipeline easier.

Let me know what you think!