Skip to content
LPUD - June Winners Transparency Video episode artwork

Jun 17, 2023

LPUD - June Winners Transparency Video

from anomadsoul 3Speak Podcast Hosted by anomadsoul

https://3speak.tv/watch?v=anomadsoul/yaeylfxd ### Check the official announcement here This is a video where I pick the LPUD winners for the month of June, this is not an announcement, it's just a video where anyone can watch the process we used to pick the winners of the Leo Power Up day First anniversary. This is the SQL query I ran to get the LPUD June participants: Select ID, json, timestamp, tid, required_auth From TxCustoms where timestamp between '2023-06-14' and '2023-06-16 14:00:00' and tid like '%ssc_mainnet_hive%' and json like '%"contractAction":"stake"%' and json like '%"symbol":"LEO"%' order by timestamp desc This is the Javascript script I ran to clean the SQL database: const leo = [ '{"contractName":"tokens","contractAction":"stake","contractPayload":{"to":"tinyputerboy","symbol":"LEO","quantity":"0.225"}}', '{"contractName":"tokens","contractAction":"stake","contractPayload":{"to":"kolus290","symbol":"LEO","quantity":"2.115"}}', ]; for (let i = 0; i < leo.length; i++) { const obj = JSON.parse(leo[i]); console.log(obj.contractPayload.to, parseFloat(obj.contractPayload.quantity)); } The link to the spreadsheet is here That's it, if anyone has any questions regarding the transparency of this process, hit me up on discord @anomadsoul#8455

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

LPUD - June Winners Transparency Video

No transcript yet.

Requests help us decide what to transcribe next.

Frequently asked questions

When was this anomadsoul 3Speak Podcast episode published?

This episode was published on June 17, 2023.

Can I download this anomadsoul 3Speak Podcast episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.