How do I get Historical Pricing data for Different Tokens on Devnet and mainnet, using either pyth, chainlink or another oracle

Question

By looking at pyth.network's website, We can see upto 1Months worth of historical prices, I don't know if this is onchain or offchain, but it means that the data is somewhere. I am mainly looking for onchain data though.

I will like to pull specifically the price of a basket of ticker symbols on a specific timestamp or a specific slot #.

Thanks all.

Answer 1

Yes, if you head over to Pyth's Price Feed page (for example, BTC/USD) you can pull the transaction history for any given Publisher to build a historical price chart. Each transaction includes the price of the asset as well as the publish time slot.

Below is an image of an inner instruction of one of the transactions by the AGaSHpDpyveuLyiaocNXMMFCf1LCBBynyaKMJkL8AKK4 BTC/USD Publisher.

Transaction history can be pulled pretty simply using the JS API. This is the @solana/web3.js package.

const { 
    Connection, 
    clusterApiUrl,
    PublicKey,
} = require("@solana/web3.js");

// The Publisher
const PUBLISHER_KEY = new PublicKey(
    "AGaSHpDpyveuLyiaocNXMMFCf1LCBBynyaKMJkL8AKK4"
);

// Start a new Connection.
const connection = new Connection(clusterApiUrl("mainnet-beta"));

// To circumvent the restriction of not being able
// to run top-level await.
const run = async () => {

    // The limit of signatures of 1,000. You might need to
    // paginate your request by using the before or until
    // parameters.
    const result = await connection.getConfirmedSignaturesForAddress2(
        PUBLISHER_KEY
    );

    // The structure of the result will be an array containing
    // objects with keys blockTime, confirmationStatus, err,
    // memo, signature, and slot. We just want the signatures.
    const signatures = result.map(i => i.signature);

    // Now we can fetch the transaction details for each
    // transaction signature. The limit here isn't specified
    // but I believe it is 250. You will need to split your
    // array of 1,000 signatures into 4 blocks to do this.
    return await connection.getParsedTransactions(
        signatures.slice(0, 250)
    );

};

// Run and show result.
run().then(result => console.dir(result, { depth: null }));

Then you can dive into each object to see where the information is stored (should be an inner instruction).

Note that transaction history isn't stored for long on Solana's native RPC endpoints. They're also quick to fire 429s back at you. You might need to use something like QuickNode, Alchemy, or GenesysGo.

Answer 2

The example chart shown is most probably made from indexed, off-chain data (only on-chain possibility would be a storage on-chain solution, think shadow drive, areweave, filecoin).

This seems to be the team's example for an on-chain example. Basic idea is:

• pass the price feed account for the asset you need (1 asset <=> 1 account),
• deserialize it exactly as shown in the example

However this only returns the current state. If the question is concerned with historical price data on-chain, then afaik there is no such thing available.