Collect and Filter 500.000 Active BSC Wallets for Airdrop Campaign

Project Description:

We are looking for an experienced freelancer in Web3 data analysis and blockchain querying to help us collect and filter high-potential wallets on the Binance Smart Chain (BSC) for an upcoming airdrop campaign aimed at bootstrapping our community.

⸻

Scope of Work:

1. Wallet Collection:
• Scrape BSC blockchain to extract wallet addresses that have:
• Performed token transfers or swaps in the past 90 days
• Interacted with DeFi protocols (e.g., PancakeSwap, lending, staking)
• Claimed from previous airdrops
• Minted or received NFTs (BEP-721 / BEP-1155)
• Interacted with smart contracts via dApps
Output format:
A .csv file with the following fields (per wallet):
address - Wallet address
last_active_date - Most recent transaction timestamp
bnb_balance - BNB balance
token_count - Number of tokens held
is_dex_user - True if interacted with DEX
nft_activity - NFT mint/receive count or boolean

2. Filtering Criteria:
• Wallets with total balance less than $10 USD
• Last on-chain activity within 90 days
• Must not be:
• Contract addresses
• CEX hot wallets (Binance, OKX, etc.)
• Blacklisted or flagged as spam/bot accounts
• Remove spam wallets:
• Those holding 100+ low-value tokens
• Those with high-frequency airdrop farming behavior
Deliverables:
• Cleaned list of 50,000 – 500,000 valid BSC wallets
• CSV file ready for use in Airdrop targeting
• Bonus if able to categorize wallets (DEX users, NFT holders, Airdrop claimers, etc.)

⸻

Technical Requirements:
• Experience with:
• Web3.py, ethers.js, BscScan API, Bitquery, Covalent, or BigQuery
• Able to write GraphQL, SQL, or use blockchain SDKs
• Experience with anti-bot heuristics or airdrop targeting is a plus