Bounties

Post bounties and services on Farcaster by tagging me. Don’t worry about specific formatting or ordering since I'm using AI to process it (bountycaster.xyz) /bounties. FAQ: bountycaster.xyz/FAQ

Follow the story of Hachi, IO and Mitra.

Episode 1 - Intersection - Out Now.

linktr.ee/rohki

500 $USDC Bounty! 

@bountybot build the go-to Dune dashboard for @rohkiofficial 

5pm PDT 8-22-2024 deadline 

Details are posted below via a reply to this cast. Reply directly to this cast with questions, etc.

product mgr. pursuing onchain music | onchain artist relations @rohki | music patent 11,620,649 | @techstars alum | @zagster cofounder (acq. by superpedestrian)

BACKGROUND
RŌHKI is a next generation anime series that’s done 330+ ETH in sales volume. We seek a Dune engineering partner to build the v1 of a dynamic, go-to dashboard for our team to leverage as we scale.

BOUNTY
500 $USDC to the best submission according to accuracy, integrity, scalability and usefulness; eligible dashboards meet minimum requirements. Airdrop gifts for eligible submissions that don’t win : )

DEADLINE
5pm PDT 8-22-2024

QUESTIONS
Reply directly to this cast!

Husband, dad, dev. @dune.eth wizard.

⭐ DEGEN Tips FAQ: https://paragraph.xyz/@rjs/degen-tips-ultimate-faq-v8 ⭐

Not financial advice. Not a KOL.

What's considered the source of truth? My secondary sales volume figure isn't 100% a match for OpenSea, but then again OpenSea doesn't seem to have the correct number of editions minted (I think)...

Also, is unique collectors = all time or just unique current holders?

Update: Also found issues with primary sales volume - the SoundEdition contracts are tricky because they don't store the value of the transaction, and you can mint multiple. Also, V1 doesn't have a Minted event, only V1_1+. This has two consequences:

1. you have to look at the ethereum tx table to get the value paid for the transfer from 0x0 (= mint) -- this is super duper slow
2. you need to count how many SoundEdition Transfer events occurred in the same tx -- as far as I can tell that's the only reliable way to handle multiple mints so that I get the correct value per mint alongside the token_id

Alternatively, I could split token tracking (for determining unique collectors) and sales volumes rather than building a single table:  token tracking would be built off individual transfers but not track the value of them (should be fast since no join on the ethereum tx table), whereas sales volumes would just sum the values associated with all transfers from 0x0 but won't track each token id.

Big W! Thanks for letting us know and don't hesitate to ask any/all questions - happy to help : )