Backfilling historical stSOL price information about solido HOT 3 CLOSED

Great!
I just created a small script to populate a database with these values
It is creating one data point for each line. But we could also aggregate it.

from solido.

Pavel at P2P has kindly provided us with a list of historical Solido interactions extracted from the chain, in the following format:

epoch,transaction,slot,blocktime,SOL_deposited,stSOL_minted
221,2t2g6FyGN4WnWwCLcRTuHRn66NaEJTWJy4vo1yxpSeDeWuYM9foHSP6HXxMVhBiSoo8UbS1P7kkxrdMJi2SXQkPf,95592492,1631120798,5.1788,5.1788
221,2mYUcFAw8ztT6mpHrPtQ9TKuwEGyvw26agS5VVkHHjviHN6AJE2Jq5jp3camCkEbf1b8SQ2LMDgfixnwaVfSAA7s,95592924,1631121028,1.25,1.25
232,5w9bk4ixB2VajA2a4JvvVJr774WFDUZPKSaGjd3QxtpiYDRaqTPs9Az85d245cbQijjQ6B2AZtxEpzZpmATKm6kW,100242837,1633634648,40.7,40.565090943

In principle all this information is public, but I’m not sure if it’s a good idea to share the full list here, so I’ll keep it on my machine for now.

Now the only thing left to do is to write a small script to insert this into the database.

CC @enriquefynn you might be interested in this

from solido.

Done, see @enriquefynn’s script above.

from solido.