{"id":1540,"onChainId":554,"chainId":8453,"title":"poidh v3 Ethereum Data","description":"Looking for a comprehensive CSV containing historical wallet-level activity from the **poidh v3 contracts across Ethereum Mainnet, Arbitrum, and Base.**\n\nThe goal is to accurately account for how much ETH each wallet has paid into successfully completed bounties, how much ETH each wallet has earned, and how many poidh NFTs each wallet currently holds.\n\n## Contracts to analyze\n\n**poidh v3 Core Contracts:**\n\n- Ethereum Mainnet: https://etherscan.io/address/0xe731dfadbff20542e10d09d26fc71445c70d4232\n- Arbitrum: https://arbiscan.io/address/0x5555fa783936c260f77385b4e153b9725fef1719\n- Base: https://basescan.org/address/0x5555fa783936c260f77385b4e153b9725fef1719\n\n**poidh v3 NFT Contracts:**\n\n- Ethereum Mainnet: https://etherscan.io/address/0x9c5f45d5e1382e4058d334d93c6c01442012a4d9\n- Arbitrum: https://arbiscan.io/address/0x27e117cc9a8da363442e7bd0618939e3eeeacf6a\n- Base: https://basescan.org/address/0x27e117cc9a8da363442e7bd0618939e3eeeacf6a\n\n## Information to include\n\n**1. ETH paid by wallet**\n\nHow much ETH each wallet contributed toward bounties that were successfully completed.\n\nI'm NOT looking for total ETH deposited into the protocol. Only count contributions that ultimately funded completed bounties.\n\n- For crowdfunded (open) bounties, attribute the completed bounty's payout amount to each contributing wallet according to their actual contribution.\n- For solo bounties, attribute the completed bounty's amount to its creator/funder.\n- Exclude contributions that were refunded or withdrawn before a bounty was completed.\n- Exclude canceled, unfinished, or otherwise unsuccessful bounties.\n\n**2. ETH earned by wallet**\n\nHow much ETH each wallet earned cumulatively from successfully completed bounties.\n\nUse the **gross bounty amount, BEFORE the 2.5% protocol fee.**\n\nFor example, if someone won a 1 ETH bounty, they should receive credit for 1 ETH earned, not 0.975 ETH.\n\n**3. NFTs held by wallet**\n\nHow many legitimate poidh v3 NFTs each unique wallet currently holds across the three chains.\n\nUse current ownership, not historical mint counts. NFTs that have been transferred should be attributed to their current holders.\n\nAccount separately for NFTs still held by the protocol contracts themselves, rather than attributing them to individual users.\n\n## CSV requirements\n\nPlease deliver a single consolidated CSV with one row per unique wallet.\n\nInclude the following columns:\n\n- `wallet_address`\n- `eth_paid_mainnet`\n- `eth_paid_arbitrum`\n- `eth_paid_base`\n- `eth_paid_total`\n- `eth_earned_mainnet`\n- `eth_earned_arbitrum`\n- `eth_earned_base`\n- `eth_earned_total`\n- `nfts_held_mainnet`\n- `nfts_held_arbitrum`\n- `nfts_held_base`\n- `nfts_held_total`\n\n**Include all relevant wallets**, even if they have zero values in certain columns. For example, a wallet that holds an NFT but has never funded or won a bounty should still appear.\n\n## Methodology and verification\n\nYou're welcome to use whatever approach you think is most effective to extract and verify the historical data from the contracts.\n\nPlease include:\n\n- The completed CSV file.\n- A brief explanation of how you collected and calculated the data.\n- The block numbers or timestamps used for the data snapshot.\n- Any scripts, queries, or code used to produce the results (ideally via a public GitHub repository).\n- Any limitations or edge cases you encountered.\n\nFor more info about how poidh works see https://docs.poidh.xyz.\n\n## What matters most\n\n**Accuracy and completeness.**\n\nI want to be able to confidently determine how much ETH every wallet has actually contributed to successful poidh outcomes, how much ETH every wallet has earned from those outcomes, and how many NFTs each wallet currently holds.\n\nPlease ensure that the total gross ETH credited to contributors reconciles with the total gross ETH credited to winners, both per chain and across all three chains.\n\nThe final dataset should be reproducible and independently verifiable against onchain records.\n\nFeel free to use this bounty's published date as the cutoff for data. Transactions that occured after this bounty's creation do not need to be included.\n\n## Submitting your claim\n\nSubmit your completed CSV, a link to your methodology/code, and a brief summary of your findings.\n\nFor your claim image, please include a screenshot or visualization of your results.\n\nMultiple submissions are welcome. First legitimate claim that fulfills all our requirements for **accuracy, completeness, and reproducibility** wins.","amount":"1000000000000000","issuer":"0x10fc964ef70c8467cd8c53e9ed9347422adf96a8","createdAt":"1794110394","inProgress":false,"isJoinedBounty":false,"isCanceled":false,"isMultiplayer":true,"isVoting":false,"deadline":null,"ban":[],"extra":{"bountyId":1540,"chainId":8453,"album":"data"},"status":"completed","statusLabel":"Completed","statusEmoji":"✅","acceptingClaims":false,"votingInProgress":false,"voteResolved":false,"voteStartedAt":null,"voteResolution":null,"winningClaim":{"claimId":9485,"title":"poidh v3 wallet data: Ethereum + Arbitrum + Base (reconciled CSV)","description":"poidh v3 wallet data: Ethereum + Arbitrum + Base\nCSV: 1436 wallets, one row each, the 13 requested columns (ETH paid / earned / NFTs held per chain + totals).\nCutoff 2026-11-08T03:59:54Z (bounty creation): Ethereum block 26367617, Arbitrum 522271780, Base 54600096.\nReconciliation, ETH paid by contributors = ETH earned by winners (gross, before 2.5% fee):\n- Ethereum: 27 completed bounties, 3.381683 = 3.381683 ETH OK\n- Arbitrum: 113 completed bounties, 2.969041 = 2.969041 ETH OK\n- Base: 321 completed bounties, 6.019435 = 6.019435 ETH OK\n- All chains: 12.370159 = 12.370159 ETH; per bounty, contributions = payout for all 461.\nNFTs (ownerOf at cutoff, every token): 461 in user wallets; 4844 unaccepted-claim NFTs held by the core contracts as escrow, listed separately. Minted = wallets + escrow, 0 burned.\nMethod: every core event + NFT Transfer replayed, cross-checked against contract state at the cutoff block (participants, winners, ownerOf). Withdrawn/refunded stakes, cancelled and open bounties excluded. 18 bounties spot-checked against tx receipts; a positive control (one join removed) makes the checks fail.\nCSV: https://apps.swiftbotlab.workers.dev/proof/poidh-v3-data/poidh_v3_wallets.csv\nMethod, reconciliation tables, sample tx hashes, limitations: https://apps.swiftbotlab.workers.dev/proof/poidh-v3-data/README.md\nAll scripts + raw inputs (reruns offline): https://apps.swiftbotlab.workers.dev/proof/poidh-v3-data.zip","uri":"https://apps.swiftbotlab.workers.dev/proof/poidh-v3-data/preview.png","winner":{"address":"0x2481e29895b43e87e547a50fb0bb5aa1e70585eb","name":null,"farcasterHandle":"swiftbotlab","twitterHandle":null,"profileUrl":"https://poidh.xyz/account/0x2481e29895b43e87e547a50fb0bb5aa1e70585eb","profileDataUrl":"https://poidh.xyz/account/0x2481e29895b43e87e547a50fb0bb5aa1e70585eb/data"}},"hasClaims":true,"hasParticipants":false,"priceUsd":1.73964,"currency":"eth","url":"https://poidh.xyz/base/bounty/1540","skillUrl":"https://poidh.xyz/skill.md","docsUrl":"https://docs.poidh.xyz/","githubUrl":"https://github.com/picsoritdidnthappen/poidh-app","claims":[{"claimId":9485,"uri":"https://apps.swiftbotlab.workers.dev/proof/poidh-v3-data/preview.png","isAccepted":true,"issuerAddress":"0x2481e29895b43e87e547a50fb0bb5aa1e70585eb","issuerName":null,"farcasterHandle":"swiftbotlab","twitterHandle":null,"profileUrl":"https://poidh.xyz/account/0x2481e29895b43e87e547a50fb0bb5aa1e70585eb","profileDataUrl":"https://poidh.xyz/account/0x2481e29895b43e87e547a50fb0bb5aa1e70585eb/data","title":"poidh v3 wallet data: Ethereum + Arbitrum + Base (reconciled CSV)","description":"poidh v3 wallet data: Ethereum + Arbitrum + Base\nCSV: 1436 wallets, one row each, the 13 requested columns (ETH paid / earned / NFTs held per chain + totals).\nCutoff 2026-11-08T03:59:54Z (bounty creation): Ethereum block 26367617, Arbitrum 522271780, Base 54600096.\nReconciliation, ETH paid by contributors = ETH earned by winners (gross, before 2.5% fee):\n- Ethereum: 27 completed bounties, 3.381683 = 3.381683 ETH OK\n- Arbitrum: 113 completed bounties, 2.969041 = 2.969041 ETH OK\n- Base: 321 completed bounties, 6.019435 = 6.019435 ETH OK\n- All chains: 12.370159 = 12.370159 ETH; per bounty, contributions = payout for all 461.\nNFTs (ownerOf at cutoff, every token): 461 in user wallets; 4844 unaccepted-claim NFTs held by the core contracts as escrow, listed separately. Minted = wallets + escrow, 0 burned.\nMethod: every core event + NFT Transfer replayed, cross-checked against contract state at the cutoff block (participants, winners, ownerOf). Withdrawn/refunded stakes, cancelled and open bounties excluded. 18 bounties spot-checked against tx receipts; a positive control (one join removed) makes the checks fail.\nCSV: https://apps.swiftbotlab.workers.dev/proof/poidh-v3-data/poidh_v3_wallets.csv\nMethod, reconciliation tables, sample tx hashes, limitations: https://apps.swiftbotlab.workers.dev/proof/poidh-v3-data/README.md\nAll scripts + raw inputs (reruns offline): https://apps.swiftbotlab.workers.dev/proof/poidh-v3-data.zip"},{"claimId":9512,"uri":"https://cdn.jsdelivr.net/gh/nicoarias81/poidh-v3-wallet-data@main/chart/poidh_v3_wallets.png","isAccepted":false,"issuerAddress":"0xf5f9d435cf5d8c334340fa2b40b792d7136b9d90","issuerName":null,"farcasterHandle":null,"twitterHandle":null,"profileUrl":"https://poidh.xyz/account/0xf5f9d435cf5d8c334340fa2b40b792d7136b9d90","profileDataUrl":"https://poidh.xyz/account/0xf5f9d435cf5d8c334340fa2b40b792d7136b9d90/data","title":"poidh v3 in one CSV: 1,413 wallets, 444 completed bounties, paid = earned to the wei","description":"Complete on-chain dataset for poidh v3 on Ethereum mainnet, Arbitrum and Base, cut off at 2026-11-08T03:59:54Z.\n\nCSV (1,413 wallets x 13 columns): https://raw.githubusercontent.com/nicoarias81/poidh-v3-wallet-data/main/output/poidh_v3_wallet_data.csv\nRepo + methodology + reconciliation: https://github.com/nicoarias81/poidh-v3-wallet-data\n\nWHAT IS IN IT\nEvery address that appears in any poidh v3 event on the three chains (bounty issuer, open-bounty contributor, claim issuer, refund/withdraw participant) plus every current NFT holder is in the file, in sorted order. 450 of the 1,413 rows have a non-zero value in at least one column; the rest are claim-only or refund-only wallets and are kept as explicit zeros instead of being dropped.\n\nOnly completed bounties count. Solo bounties: the issuer is charged the amount paid at creation. Open bounties: each contributor is charged the amount they actually joined with, minus any WithdrawFromOpenBounty, so partial refunds are netted. Cancelled and never-accepted bounties are excluded from paid and from earned. Earned is the gross bountyAmount forwarded to ClaimAccepted.claimIssuer, before the 2.5% protocol fee - a winner of 1 ETH is credited 1 ETH, not 0.975. NFTs are current ownership at the snapshot block, replayed from ERC-721 Transfer logs; tokens still in core-contract escrow (4,713 across the three chains) are reported separately and never attributed to a user wallet.\n\nSNAPSHOT BLOCKS (latest block with timestamp <= cutoff, verified with eth_getBlockByNumber)\nmainnet 26,367,617 (03:59:47Z) - arbitrum 522,271,780 (exact) - base 54,600,096 (exact)\n\nRECONCILIATION (paid by contributors vs earned by winners, gross)\nmainnet: 46 created, 27 accepted, 3.381683 ETH paid = 3.381683 ETH earned\narbitrum: 161 created, 113 accepted, 2.969041 ETH paid = 2.969041 ETH earned\nbase: 542 created, 304 accepted, 5.568481 ETH paid = 5.568481 ETH earned\ntotal: 749 created, 444 accepted, 11.919205 ETH paid = 11.919205 ETH earned (match to the wei)\n\nIndependent checks: bountyCounter() read on-chain equals the number of BountyCreated events on mainnet (46) and arbitrum (161); total distinct claim NFTs = escrow 4,713 + user-held 444 on every chain; implied protocol fee is exactly 2.5% of gross on each chain, and no payout deviates from it.\n\nHOW IT WAS BUILT, AND WHERE IT CAN BE WRONG\nEvents decoded from refs/PoidhV3.sol signatures, logs sorted chronologically by (blockNumber, logIndex) so ownership replay is order-independent of the page order the source returned. Base is the hard chain: every free public RPC refuses archive-range eth_getLogs, so Base logs were paged from the Blockscout v2 API up to the snapshot block and normalised into the same raw-log shape. Three scripts reproduce the whole thing: fetch.py, build_csv.py, make_chart.py. Known limits, all stated in the README: paid is scoped to accepted bounties by design; ownership is point-in-time, so historical holders and secondary-market trades before the snapshot are not listed; a claim NFT that was never accepted stays in escrow and is counted there, not as a winner's NFT.\n"},{"claimId":9498,"uri":"https://iili.io/nbI6CVR.png","isAccepted":false,"issuerAddress":"0x7152f226f565c3b86943ce7b4f38e77110bd4c07","issuerName":null,"farcasterHandle":"aegis13","twitterHandle":null,"profileUrl":"https://poidh.xyz/account/0x7152f226f565c3b86943ce7b4f38e77110bd4c07","profileDataUrl":"https://poidh.xyz/account/0x7152f226f565c3b86943ce7b4f38e77110bd4c07/data","title":"POIDH v3 Cross-Chain Wallet CSV & GitHub Repo (Ethereum + Arbitrum + Base, 462 Completed Bounties Reconciled)","description":"1. DELIVERABLE CSVs & PUBLIC GITHUB REPOSITORY:\n• Consolidated 13-Column CSV (Latest Head, 1,438 wallets / 462 completed bounties): https://farrior13.github.io/aegis-club-radar/poidh-v3-data/poidh_v3_wallets.csv\n• Active Non-Zero Wallets CSV (470 wallets with paid/earned/NFTs > 0): https://farrior13.github.io/aegis-club-radar/poidh-v3-data/poidh_v3_wallets_active_only.csv\n• Creation Cutoff Snapshot CSV (1,436 wallets @ block 1794110394 / 461 completed bounties): https://farrior13.github.io/aegis-club-radar/poidh-v3-data/poidh_v3_wallets_cutoff_1794110394.csv\n• Protocol Escrow NFTs CSV (4,858 unaccepted-claim NFTs held by Core contracts): https://farrior13.github.io/aegis-club-radar/poidh-v3-data/poidh_v3_protocol_nft_holdings.csv\n• Completed Bounties Audit CSV (All 462 completed bounties): https://farrior13.github.io/aegis-club-radar/poidh-v3-data/completed_bounties.csv\n• Public GitHub Repository (Scripts, Methodology, Verification & Data): https://github.com/Farrior13/aegis-club-radar/tree/main/poidh-v3-data\n• Interactive Web Explorer: https://farrior13.github.io/aegis-club-radar/poidh-v3-data/\n• Visual Scorecard Image: https://iili.io/nbI6CVR.png\n\n2. FULL CROSS-CHAIN RECONCILIATION (GROSS ETH PAID == GROSS ETH EARNED BEFORE 2.5% FEE):\n• Ethereum Mainnet (Block #26,371,283): 27 completed bounties (1 solo / 26 open, 19 via vote) -> 3.381683 ETH paid == 3.381683 ETH earned (0 wei diff). NFTs: 27 in user wallets + 380 in protocol escrow (407 minted).\n• Arbitrum One (Block #522,413,361): 113 completed bounties (14 solo / 99 open, 37 via vote) -> 2.969041 ETH paid == 2.969041 ETH earned (0 wei diff). NFTs: 113 in user wallets + 619 in protocol escrow (732 minted).\n• Base Mainnet (Block #54,821,853): 322 completed bounties (36 solo / 286 open, 178 via vote, including Bounty #490 Claim #4165 for 0.0022 ETH) -> 6.02163544252522 ETH paid == 6.02163544252522 ETH earned (0 wei diff). NFTs: 322 in user wallets + 3,859 in protocol escrow (4,181 minted).\n• ALL 3 CHAINS TOTAL (Latest Head): 462 completed bounties -> 12.37235944252522 ETH paid == 12.37235944252522 ETH earned (12,372,359,442,525,220,000 wei, 0 discrepancies). 462 NFTs in user wallets + 4,858 in protocol escrow = 5,320 minted (0 burned).\n• Creation Cutoff Snapshot (2026-11-08 03:59:54 UTC, blocks 26,367,617 / 522,271,780 / 54,600,096): 461 completed bounties -> 12.37015944252522 ETH paid == earned, 461 user NFTs + 4,844 escrow NFTs.\n\n3. METHODOLOGY & DUAL VERIFICATION:\n• Extracted all core contract events and ERC-721 Transfer logs directly from archival JSON-RPC endpoints via eth_getLogs (avoiding Base explorer indexing gaps) and cross-verified every bounty, participant stake, claim status, and NFT ownerOf/balanceOf via Multicall3 at the target block.\n• Excludes withdrawn open-bounty contributions (WithdrawFromOpenBounty), cancelled bounties (BountyCancelled / RefundClaimed), and still-open bounties. Credits winners with gross bountyAmount before the 2.5% fee and separates protocol-escrowed NFTs from user holdings."}],"comments":[]}